public ActionResult Create(CTGRY_TBL categoryModel)
{
try
{
using (DMSDbEntities db = new DMSDbEntities())
{
db.CTGRY_TBL.Add(categoryModel);
db.SaveChanges();
return RedirectToAction("Index",db.CTGRY_TBL.ToList());
}
}
catch
{
return View();
}
}
public ActionResult Edit(CTGRY_TBL categoryModel)
{
try
{
using (DMSDbEntities db = new DMSDbEntities())
{
var entry = db.Entry<CTGRY_TBL>(categoryModel);
if (entry.State.Equals(EntityState.Detached))
{
db.CTGRY_TBL.Attach(categoryModel);
}
entry.State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index",db.CTGRY_TBL.ToList());
}
}
catch
{
return View();
}
}
public ActionResult Delete(CTGRY_TBL categoryModel)
{
try
{
using (DMSDbEntities db = new DMSDbEntities())
{
var entry = db.Entry<CTGRY_TBL>(categoryModel);
entry.State = EntityState.Deleted;
db.CTGRY_TBL.ToList().RemoveAll(p => p.CtgryId == categoryModel.CtgryId);
db.SaveChanges();
return RedirectToAction("Index", db.CTGRY_TBL.ToList());
}
}
catch
{
return View();
}
}