ALTER TABLE yourtable DROP CONSTRAINT DF_AspNetUser_UserN__34C8D9D1
ALTER TABLE TableName DROP CONSTRAINT dependent_constraint;
import { useEffect } from "react";
const useClickOutside = (ref, handler) => {
useEffect(() => {
const listener = (event) => {
if (!ref.current || ref.current.contains(event.target)) {
return;
}
handler(event);
};
document.addEventListener("mousedown", listener);
document.addEventListener("touchstart", listener);
return () => {
document.removeEventListener("mousedown", listener);
document.removeEventListener("touchstart", listener);
};
}, [handler, ref]);
};
export { useClickOutside }; 
import { useClickOutside } from "./useClickOutside";
// ...
export const ReducerButtons = () => {
const [state, dispatch] = useReducer(reducer, initialState);
const ref = useRef<HTMLDivElement>(null);
useClickOutside(ref, () => {
console.log("clicked outside");
});
return (
<div ref={ref}>
// ...
</div>
);
}; 
const useClickOutside = (
ref: React.RefObject<HTMLDivElement>,
handler: () => void
) => { const listener = (event: React.MouseEvent<HTMLElement>) => { 
ref.current.contains(event.target as Node)
const useClickOutside = (
ref: React.RefObject<HTMLDivElement>,
handler: (event: React.MouseEvent<HTMLElement>) => void
) => { 
(method) Document.addEventListener<"mousedown">(type: "mousedown", listener: (this: Document, ev: MouseEvent) => any, options?: boolean | AddEventListenerOptions | undefined): void (+1 overload)
(method) Document.addEventListener<"touchstart">(type: "touchstart", listener: (this: Document, ev: TouchEvent) => any, options?: boolean | AddEventListenerOptions | undefined): void (+1 overload)
const useClickOutside = (
ref: React.RefObject<HTMLDivElement>,
handler: (event: MouseEvent | TouchEvent) => void
) => {
useEffect(() => {
const listener = (event: MouseEvent | TouchEvent) => { 
const useClickOutside = (
ref: React.RefObject<HTMLElement>,
handler: (event: MouseEvent | TouchEvent) => void
) => { import { useEffect } from "react";
const useClickOutside = (
ref: React.RefObject<HTMLElement>,
handler: (event: MouseEvent | TouchEvent) => void
) => {
useEffect(() => {
const listener = (event: MouseEvent | TouchEvent) => {
if (!ref.current || ref.current.contains(event.target as Node)) {
return;
}
handler(event);
};
document.addEventListener("mousedown", listener);
document.addEventListener("touchstart", listener);
return () => {
document.removeEventListener("mousedown", listener);
document.removeEventListener("touchstart", listener);
};
}, [handler, ref]);
};
export { useClickOutside }; Async library for .NET to help build real-time, multi-user interactive web applications.
The real-time web is a set of technologies and practices that enable users to receive information as soon as it is published by its authors, rather than requiring that they or their software check a source periodically for updates.
PM> Install-Package SignalR.Sample
PM> Install-Package SignalR
Microsoft.Web.Infrastructure Newtonsoft.Json SignalR SignalR.Hosting.AspNet SignalR.Hosting.Common
jquery-1.6.4.js jquery.signalR-0.5.1.js
using SignalR.Hubs;
namespace SimpleChatWithSignalR
{
public class SimpleChat : Hub
{
public void SendMessage(string message)
{
Clients.reciveMessage(message);
}
}
}
<input type="text" id="msg" />
<input type="button" value="Send" id="send" /><br />
<textarea id='messages' readonly="true" style="height: 200px; width: 200px;"></textarea>
<script src="Scripts/jquery-1.6.4.min.js" type="text/javascript"></script>
<script src="Scripts/jquery.signalR-0.5.1.min.js" type="text/javascript"></script>
<script src="signalr/hubs" type="text/javascript"></script>
<script type="text/javascript">
var chat = $.connection.simpleChat;
chat.reciveMessage = function (msg) {
$('#messages').val($('#messages').val() + "-" + msg + "\r\n");
};
$.connection.hub.start();
$('#send').click(function () {
chat.sendMessage($('#msg').val());
});
</script> <script src="signalr/hubs" type="text/javascript"></script>
var productsDataSource = new kendo.data.DataSource({
transport: {
read: {
url: "api/products",
dataType: "json",
contentType: 'application/json; charset=utf-8',
type: 'GET'
},
create: {
url: "api/products",
contentType: 'application/json; charset=utf-8',
type: "POST"
},
update: {
url: function (product) {
return "api/products/" + product.Id;
},
contentType: 'application/json; charset=utf-8',
type: "PUT"
},
destroy: {
url: function (product) {
return "api/products/" + product.Id;
},
contentType: 'application/json; charset=utf-8',
type: "DELETE"
},
//...
},
schema: {
//...
model: {
id: "Id", // define the model of the data source. Required for validation and property types.
fields: {
"Id": { type: "number", editable: false }, //تعیین نوع فیلد برای جستجوی پویا مهم است
"Name": { type: "string", validation: { required: true } },
"IsAvailable": { type: "boolean" },
"Price": { type: "number", validation: { required: true, min: 1 } },
"AddDate": { type: "date", validation: { required: true } }
}
}
},
batch: false, // enable batch editing - changes will be saved when the user clicks the "Save changes" button
//...
}); namespace KendoUI06.Controllers
{
public class ProductsController : ApiController
{
public HttpResponseMessage Post(Product product)
{
if (!ModelState.IsValid)
return Request.CreateResponse(HttpStatusCode.BadRequest);
var id = 1;
var lastItem = ProductDataSource.LatestProducts.LastOrDefault();
if (lastItem != null)
{
id = lastItem.Id + 1;
}
product.Id = id;
ProductDataSource.LatestProducts.Add(product);
var response = Request.CreateResponse(HttpStatusCode.Created, product);
response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = product.Id }));
// گرید آی دی جدید را به این صورت دریافت می‌کند
response.Content = new ObjectContent<DataSourceResult>(
new DataSourceResult { Data = new[] { product } }, new JsonMediaTypeFormatter());
return response;
}
}
} var productsDataSource = new kendo.data.DataSource({
//...
schema: {
data: "Data",
total: "Total",
}
//...
}); namespace KendoUI06.Controllers
{
public class ProductsController : ApiController
{
public DataSourceResult Get(HttpRequestMessage requestMessage)
{
var request = JsonConvert.DeserializeObject<DataSourceRequest>(
requestMessage.RequestUri.ParseQueryString().GetKey(0)
);
var list = ProductDataSource.LatestProducts;
return list.AsQueryable()
.ToDataSourceResult(request.Take, request.Skip, request.Sort, request.Filter);
}
}
} response.Content = new ObjectContent<DataSourceResult>(
new DataSourceResult { Data = new[] { product } }, new JsonMediaTypeFormatter()); namespace KendoUI06.Controllers
{
public class ProductsController : ApiController
{
public HttpResponseMessage Delete(int id)
{
var item = ProductDataSource.LatestProducts.FirstOrDefault(x => x.Id == id);
if (item == null)
return Request.CreateResponse(HttpStatusCode.NotFound);
ProductDataSource.LatestProducts.Remove(item);
return Request.CreateResponse(HttpStatusCode.OK, item);
}
[HttpPut] // Add it to fix this error: The requested resource does not support http method 'PUT'
public HttpResponseMessage Update(int id, Product product)
{
var item = ProductDataSource.LatestProducts
.Select(
(prod, index) =>
new
{
Item = prod,
Index = index
})
.FirstOrDefault(x => x.Item.Id == id);
if (item == null)
return Request.CreateResponse(HttpStatusCode.NotFound);
if (!ModelState.IsValid || id != product.Id)
return Request.CreateResponse(HttpStatusCode.BadRequest);
ProductDataSource.LatestProducts[item.Index] = product;
return Request.CreateResponse(HttpStatusCode.OK);
}
}
} $("#report-grid").kendoGrid({
//....
editable: {
confirmation: "آیا مایل به حذف ردیف انتخابی هستید؟",
destroy: true, // whether or not to delete item when button is clicked
mode: "popup", // options are "incell", "inline", and "popup"
//template: kendo.template($("#popupEditorTemplate").html()), // template to use for pop-up editing
update: true, // switch item to edit mode when clicked?
window: {
title: "مشخصات محصول" // Localization for Edit in the popup window
}
},
columns: [
//....
{
command: [
{ name: "edit", text: "ویرایش" },
{ name: "destroy", text: "حذف" }
],
title: " ", width: "160px"
}
],
toolbar: [
{ name: "create", text: "افزودن ردیف جدید" },
{ name: "save", text: "ذخیره‌ی تمامی تغییرات" },
{ name: "cancel", text: "لغو کلیه‌ی تغییرات" },
{ template: kendo.template($("#toolbarTemplate").html()) }
],
messages: {
editable: {
cancelDelete: "لغو",
confirmation: "آیا مایل به حذف این رکورد هستید؟",
confirmDelete: "حذف"
},
commands: {
create: "افزودن ردیف جدید",
cancel: "لغو کلیه‌ی تغییرات",
save: "ذخیره‌ی تمامی تغییرات",
destroy: "حذف",
edit: "ویرایش",
update: "ثبت",
canceledit: "لغو"
}
}
});