public string AssignSubMenu(AssignSubMenuModel model)
{
tblAssignSubMenuItem tb = new tblAssignSubMenuItem();
var duplicate = entities.tblAssignSubMenuItems.Where(o => o.ID.Equals(model.id)).SingleOrDefault();
if (duplicate == null)
{
try
{
if (model.id != 0)
{
tb = entities.tblAssignSubMenuItems.Where(x => x.ID == model.id).SingleOrDefault();
tb.Mainitemid = Convert.ToInt32(model.MainItem);
tb.subitemid = model.SubItem;
entities.SaveChanges();
return("Record Updated Successfully...");
}
else
{
tb.Mainitemid = Convert.ToInt32(model.MainItem);
//tb.Category_name = model.CategoryName;
tb.subitemid = model.SubItem;
//tb.Vendor_name = model.VendorName;
entities.tblAssignSubMenuItems.Add(tb);
entities.SaveChanges();
return("Record Saved Successfully...");
}
}
catch (Exception ex)
{
return("something Wrong try Agian !");
}
}
else
{
return(" Already Exits");
}
}
public string SaveSubMenuItem(string path)
{
try
{
XDocument xd = XDocument.Load(path);
//int oulte = 99; //WebSecurity.CurrentUserId;
var result = (from item in xd.Descendants("Items")
select item).ToList();
foreach (var item in result)
{
tblAssignSubMenuItem tb = new tblAssignSubMenuItem();
tb.Mainitemid = Convert.ToInt32(item.Element("Mainitemid").Value);
tb.subitemid = Convert.ToInt32(item.Element("subitemid").Value);
//tb.Quantity = Convert.ToDecimal(item.Element("Quantity").Value);
//tb.RawMaterialId = Convert.ToInt32(item.Element("RawMaterialId").Value);
//tb.Portion = Convert.ToInt32(item.Element("Portion").Value);
//tb.Unit = item.Element("Unit").Value;
entities.tblAssignSubMenuItems.Add(tb);
entities.SaveChanges();
}
var items = (from item in xd.Descendants("Items")
select item);
items.Remove();
xd.Save(path);
return("Record Inserted Successfully...");
}
catch (Exception ex)
{
return("something Wrong ! Try Agian " + ex);
}
}
