public ActionResult AddSubItem(int id = 0) { AddSubItemModel model = new AddSubItemModel(); if (id > 0) { var data = (from p in db.tblSubItems where p.SubItemId == id select p).SingleOrDefault(); model.Description = data.Description; model.subItemId = data.SubItemId; model.Name = data.Name; return(View(model)); } else { return(View(model)); } }
public ActionResult SubItemDetails() { var data = (from p in db.tblSubItems where p.Active == true select p).ToList(); List <AddSubItemModel> List = new List <AddSubItemModel>(); foreach (var item in data) { AddSubItemModel model = new AddSubItemModel(); model.Name = item.Name; model.Description = item.Description; model.subItemId = item.SubItemId; model.Name = item.Name; List.Add(model); } return(View(List)); }
public ActionResult AddSubItem(AddSubItemModel model) { tblSubItem tb = new tblSubItem(); var subitemcheck = (from p in db.tblSubItems where p.Name == model.Name && p.Active == true select p).SingleOrDefault(); if (subitemcheck == null) { try { if (model.subItemId > 0) { tb = (from p in db.tblSubItems where p.SubItemId == model.subItemId select p).SingleOrDefault(); } tb.Description = model.Description; tb.Name = model.Name; tb.Active = model.Active; if (model.subItemId > 0) { db.SaveChanges(); TempData["item"] = "Edit Successfully..!"; return(RedirectToAction("SubItemDetails")); } else { db.tblSubItems.Add(tb); db.SaveChanges(); TempData["item"] = "Record Insert Successfully..!"; return(RedirectToAction("SubItemDetails")); } } catch (Exception ex) { TempData["item"] = ex.Message; return(RedirectToAction("SubItemDetails")); } } else { TempData["itemCreate"] = "This Item is already exist "; return(RedirectToAction("AddSubItem")); } }