public string UpdateSubMenu(AssignSubMenuModel model)
{
var Path = Server.MapPath("/xmlkot/AssignSubMenuItem.xml");
var Data = user.UpdateSubMenuItem(model, Path);
return(Data);
}
public List <AssignSubMenuModel> ListOfSubMenu()
{
var data = entities.tblAssignSubMenuItems.GroupBy(x => x.Mainitemid).ToList();
List <AssignSubMenuModel> List = new List <AssignSubMenuModel>();
foreach (var item in data)
{
AssignSubMenuModel model = new AssignSubMenuModel();
model.MainItemName = item.FirstOrDefault().tblItem.Name;
model.SubItemName = item.FirstOrDefault().tblSubItem.Name;
model.MainItemId = item.FirstOrDefault().tblItem.ItemId;
var items = entities.tblAssignSubMenuItems.Where(x => x.Mainitemid == item.Key).ToList();
List <InnerSubMenuItem> l = new List <InnerSubMenuItem>();
foreach (var it in items)
{
InnerSubMenuItem m = new InnerSubMenuItem();
m.SubMenuNames = it.tblSubItem.Name;
l.Add(m);
}
model.ListOfInnerSubMenuItem = l;
List.Add(model);
}
return(List);
}
public string UpdateSubMenuItem(AssignSubMenuModel model, string path)
{
XDocument xd = XDocument.Load(path);
var newElement = new XElement("Items",
new XElement("Mainitemid", Convert.ToInt32(model.MainItem)),
new XElement("subitemid", model.SubItem)
);
xd.Element("Item").Add(newElement);
xd.Save(path);
//}
return(FillXmlData(path));
}
public List <AssignSubMenuModel> ShowAllSubMenuList()
{
List <AssignSubMenuModel> List = new List <AssignSubMenuModel>();
var data = (from n in entities.tblAssignSubMenuItems select n).AsEnumerable(); //entities.AddCategoryVendors.ToList();
foreach (var item in data)
{
AssignSubMenuModel model = new AssignSubMenuModel();
model.id = item.ID;
model.MainItemName = item.tblItem.Name;
model.SubItemName = item.tblSubItem.Name;
List.Add(model);
}
return(List);
}
public AssignSubMenuModel EditSubMenu(int Id)
{
AssignSubMenuModel model = new AssignSubMenuModel();
if (Id != 0)
{
var data = entities.tblAssignSubMenuItems.Where(x => x.ID == Id).SingleOrDefault();
//model.MainItem = data.tblItem.Name;
model.SubItem = data.subitemid;
return(model);
}
else
{
return(model);
}
}
public ActionResult AssignSubMenuItem(int id = 0)
{
AssignSubMenuModel model = new AssignSubMenuModel();
IEnumerable <SelectListItem> MainMenuCategory = (from n in db.tblCategories select n).AsEnumerable().Select(n => new SelectListItem()
{
Text = n.Name, Value = n.CategoryId.ToString()
});
ViewBag.MainMenu = new SelectList(MainMenuCategory, "Value", "Text", "MenuCategory");
IEnumerable <SelectListItem> SubMenu = (from n in db.tblSubItems select n).AsEnumerable().Select(n => new SelectListItem()
{
Text = n.Name, Value = n.SubItemId.ToString()
});
ViewBag.SubMenu = new SelectList(SubMenu, "Value", "Text", "SubMenu");
return(View(user.EditSubMenu(id)));
}
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");
}
}
