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"));
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
tblSubItem subitem = new tblSubItem();
if (db.tblSubItems.Any(d => d.Title == txtTitle.Text))
{
Page.ClientScript.RegisterStartupScript(GetType(), "msgbox", "alert('" + txtTitle.Text + " " + "already exists!" + "');", true);
}
else
{
subitem.Title = txtTitle.Text;
subitem.ItemId = Int32.Parse(ddlItem.SelectedValue);
subitem.SubSystemId = Int32.Parse(ddlSubSystem.SelectedValue);
db.tblSubItems.Add(subitem);
db.SaveChanges();
Page.ClientScript.RegisterStartupScript(GetType(), "msgbox", "alert('Added successfully');", true);
txtTitle.Text = "";
}
}
public ActionResult DeleteSubitem(int id)
{
try
{
//if ((from p in db.tbl_SubItemRawIndent where p.SubItemId.Equals(id) select p ).Count() == 0)
//{
//
tblSubItem tb = (from p in db.tblSubItems where p.SubItemId == id select p).SingleOrDefault();
tb.Active = false;
db.SaveChanges();
TempData["Message"] = "Delete Successfully !!";
//}
//else
// TempData["Message"] = "Used in Sub Menu Item Ingrediant !!";
}
catch
{
ModelState.AddModelError("", "Error Occured !");
}
return(RedirectToAction("SubItemDetails"));
}
