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));
}
