public string dlt(int id)
{
SHEET1 dl = dc.SHEET1.Find(id);
dc.SHEET1.Remove(dl);
dc.SaveChanges();
return("Deleted Successfully!");
}
public ActionResult Add_item(SHEET1 e)
{
using (dc)
{
dc.SHEET1.Add(e);
dc.SaveChanges();
}
return(RedirectToAction("Create"));
}
public string edt(SHEET1 objPMR)
{
string msg;
try
{
dc.Entry(objPMR).State = EntityState.Modified;
dc.SaveChanges();
msg = "Saved Successfully";
}
catch (Exception ex)
{
msg = ex.Message;
}
return(msg);
}
public string crt([Bind(Exclude = "RID")] SHEET1 objPMR)
{
string msg;
try
{
if (ModelState.IsValid)
{
dc.SHEET1.Add(objPMR);
dc.SaveChanges();
msg = "Saved Successfully";
}
else
{
msg = "Validation Failed";
}
}
catch (Exception ex)
{
msg = ex.Message;
}
return(msg);
}
