public ActionResult SupportGridDelete(Int32 Id) { StoredProcedureEntities context = new StoredProcedureEntities(); /* it is not allowed to delete some initial records */ Int32 foundItem = context.SupportTeams .Take(4) .Where(i => i.Id == Id) .Count(); if (foundItem != 0) { TempData["message"] = "Error: It is not possible to delete test records"; } else { var result = context.DeleteSupportEngineer(Id).First(); // a number of deleted rows (usually 1) if (result.HasValue) { TempData["message"] = "A number of deleted rows: " + result.Value.ToString(); } } var model = context.SelectSupportTeam(); return(PartialView("SupportGridPartial", model)); }
public ActionResult SupportGridPartial() { StoredProcedureEntities context = new StoredProcedureEntities(); var model = context.SelectSupportTeam(); return(PartialView("SupportGridPartial", model)); }
public ActionResult SupportGridInsert([ModelBinder(typeof(DevExpressEditorsBinder))] SelectSupportTeam_Result supportEngineer) { StoredProcedureEntities context = new StoredProcedureEntities(); var result = context.InsertSupportEngineer(supportEngineer.Name).First(); // inserted key value if (result.HasValue) { TempData["message"] = "Inserted row key: " + result.Value.ToString(); } var model = context.SelectSupportTeam(); return(PartialView("SupportGridPartial", model)); }