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