public JsonResult DelProviders(Provider _delpro)
{
var delitems = db.Providers.Find(_delpro.id);
db.Providers.Remove(delitems);
db.SaveChanges();
var result = db.Providers.ToList();
return Json(result, JsonRequestBehavior.AllowGet);
}
//get provider by id
public JsonResult GetProviderById(Provider EdtProvider)
{
var getId = db.Providers.Find(EdtProvider.id);
var data = db.Providers.Where(s => s.id == getId.id).Select(x => new { id = x.id, name = x.name, address = x.address, phone = x.phone }).FirstOrDefault();
return Json(data, JsonRequestBehavior.AllowGet);
}