public IActionResult Index() { var result = _dashboardRepository.GetCounts(this.loginUserId, this.isAdmin); result.TotalCategories = _categoryRepository.GetList(this.loginUserId, this.isAdmin).Count; result.TotalMenuItems = _menuItemRepository.GetList(this.loginUserId, this.isAdmin).Count; result.TotalMenu = _menuRepository.GetList(this.loginUserId, this.isAdmin).Count; return(View(result)); }
public IActionResult GetList(DataTableAjaxPostModel param) { int recordsTotal = 0; var result = _menuItemRepository.GetList(this.loginUserId, isAdmin); if (result.Any()) { recordsTotal = result.Count; if (param.conceptId > 0) { result = result.Where(x => x.MenuItemConcepts.Any(x => x.ConceptId == param.conceptId)).ToList(); } if (param.categoryId > 0) { result = result.Where(x => x.CategoryId == param.categoryId).ToList(); } if (param.menuItemId > 0) { result = result.Where(x => x.Id == param.menuItemId).ToList(); } if (param.status == Helper.Active) { result = result.Where(x => x.Status).ToList(); } else if (param.status == Helper.Inactive) { result = result.Where(x => !x.Status).ToList(); } result.ForEach(x => x.ConceptName = string.Join(", ", x.MenuItemConcepts.Select(x => x.ConceptName).ToList())); if (!string.IsNullOrEmpty(param.search.value)) { var search = param.search.value; result = result.Where(x => x.PLU.ToLower().Contains(search.ToLower()) || x.Name.ToLower().Contains(search.ToLower()) || x.ConceptName.ToLower().Contains(search.ToLower()) || x.CategoryName.ToLower().Contains(search.ToLower()) || x.Currency.ToLower().Contains(search.ToLower()) || x.Price.ToString().Contains(search.ToLower()) || x.LabelEN.ToLower().Contains(search.ToLower()) || x.LabelAR.ToLower().Contains(search.ToLower()) ).ToList(); } } string order = Convert.ToString(param.order[0].column); string orderDir = param.order[0].dir; switch (order) { case "0": result = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? result.OrderByDescending(p => p.PLU).ToList() : result.OrderBy(p => p.PLU).ToList(); break; case "1": result = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? result.OrderByDescending(p => p.Name).ToList() : result.OrderBy(p => p.Name).ToList(); break; case "2": result = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? result.OrderByDescending(p => p.ConceptName).ToList() : result.OrderBy(p => p.ConceptName).ToList(); break; case "3": result = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? result.OrderByDescending(p => p.CategoryName).ToList() : result.OrderBy(p => p.CategoryName).ToList(); break; case "4": result = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? result.OrderByDescending(p => p.Currency).ToList() : result.OrderBy(p => p.Currency).ToList(); break; case "5": result = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? result.OrderByDescending(p => p.Price).ToList() : result.OrderBy(p => p.Price).ToList(); break; case "6": result = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? result.OrderByDescending(p => p.LabelEN).ToList() : result.OrderBy(p => p.LabelEN).ToList(); break; case "7": result = orderDir.Equals("DESC", StringComparison.CurrentCultureIgnoreCase) ? result.OrderByDescending(p => p.LabelAR).ToList() : result.OrderBy(p => p.LabelAR).ToList(); break; default: result = result.OrderByDescending(p => p.Id).ToList(); break; } var data = result; if (param.length > 0) { data = result.Skip(param.start).Take(param.length).ToList(); } return(Json(new { draw = param.draw, recordsFiltered = result.Count, recordsTotal = recordsTotal, data = data })); }
public IActionResult Index(int Id = 0) { var menu = new Menu_VM(); ViewBag.ConceptsList = new SelectList(conceptsList, "Id", "ConceptName"); if (Id > 0) { menu = _menuRepository.Get(Id, this.loginUserId, isAdmin); if (menu == null) { return(RedirectToAction("List", "Menu")); } else { menuItemList = _menuItemRepository.GetList(this.loginUserId, isAdmin).Where(x => x.Status && x.MenuItemConcepts.Any(x => x.ConceptId == menu.ConceptId)).ToList(); if (menuItemList.Any()) { categoryList = menuItemList.Select(x => new Category_VM() { Id = x.CategoryId, Name = x.CategoryName }).DistinctBy(x => x.Name).ToList(); categoryList.Add(new Category_VM { Id = 0, Name = "All" }); } ViewBag.MenuItems = new SelectList(menuItemList, "Id", "Name"); ViewBag.Categories = new SelectList(categoryList.OrderBy(x => x.Id), "Id", "Name"); ViewData["Title"] = "Edit"; return(View(menu)); } } else { if (conceptsList.Any()) { if (SelectedConceptId > 0) { menuItemList = _menuItemRepository.GetList(this.loginUserId, isAdmin).Where(x => x.Status && x.MenuItemConcepts.Any(x => x.ConceptId == SelectedConceptId)).ToList(); menu.ConceptId = SelectedConceptId; } else { menuItemList = _menuItemRepository.GetList(this.loginUserId, isAdmin).Where(x => x.Status && x.MenuItemConcepts.Any(x => x.ConceptId == conceptsList[0].Id)).ToList(); } if (menuItemList.Any()) { categoryList = menuItemList.Select(x => new Category_VM() { Id = x.CategoryId, Name = x.CategoryName }).DistinctBy(x => x.Name).ToList(); categoryList.Add(new Category_VM { Id = 0, Name = "All" }); } } ViewBag.MenuItems = new SelectList(menuItemList, "Id", "Name"); ViewBag.Categories = new SelectList(categoryList.OrderBy(x => x.Id), "Id", "Name"); ViewData["Title"] = "Add"; return(View(menu)); } }