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