public ActionResult AddCategory(int?ID) { if (Session["ID"] != null) { int id = Convert.ToInt32(Session["ID"]); int RoleMember = Convert.ToInt32(Enums.UserRoleId.Member); User user = db.Users.Where(x => x.ID == id).FirstOrDefault(); if (user.RoleID != RoleMember) { ManageCategoryViewModel Model = new ManageCategoryViewModel(); if (ID != null) { NoteCategory countryData = db.NoteCategories.Where(x => x.ID == ID).FirstOrDefault(); Model.CategoryName = countryData.Name; Model.Description = countryData.Description; return(View(Model)); } return(View()); } else { return(RedirectToAction("Index", "Home")); } } else { return(RedirectToAction("Login", "Account")); } }
public ActionResult AddCategory(ManageCategoryViewModel model) { if (ModelState.IsValid) { NoteCategory countryData = db.NoteCategories.Where(x => x.Name.Equals(model.CategoryName)).FirstOrDefault(); int AddedBy = Convert.ToInt32(Session["ID"]); if (countryData != null) { countryData.Name = model.CategoryName; countryData.Description = model.Description; countryData.ModifiedDate = DateTime.Now; countryData.ModifiedBy = AddedBy; countryData.IsActive = true; db.SaveChanges(); } else { NoteCategory NewEntry = new NoteCategory() { Name = model.CategoryName, Description = model.Description, CreatedBy = AddedBy, CreatedDate = DateTime.Now, IsActive = true, }; db.NoteCategories.Add(NewEntry); db.SaveChanges(); } return(RedirectToAction("ManageCategory", "Category")); } else { return(View(model)); } }
public ActionResult EditCategory(int id) { ViewBag.Settings = "active"; ViewBag.managecategory = "active"; var user = db.Users.FirstOrDefault(x => x.Email == User.Identity.Name); var detail = db.NoteCategories.FirstOrDefault(x => x.ID == id); ManageCategoryViewModel categoryModel = new ManageCategoryViewModel(); categoryModel.ID = detail.ID; categoryModel.categoryName = detail.Name; categoryModel.description = detail.Description; return(View(categoryModel)); }
public async Task <IActionResult> DeleteCategory(ManageCategoryViewModel model) { if (!ModelState.IsValid) { TempData.AddErrorMessage(TempMessages.GeneralInvalidInputData); return(RedirectToAction(nameof(AdminsController.DeleteCategory), new { id = model.Name })); } try { await _categoryService.DeleteCategory(model.Name); } catch (InvalidOperationException) { TempData.AddErrorMessage(TempMessages.ErrorDuringCategoryDelete); } TempData.AddSuccessMessage(TempMessages.SuccessCategoryDelete); return(RedirectToAction(nameof(AdminsController.Index), AdminController)); }
public ActionResult EditCategory(ManageCategoryViewModel catModel) { var user = db.Users.FirstOrDefault(x => x.Email == User.Identity.Name); var model = db.NoteCategories.Where(x => x.ID == catModel.ID).FirstOrDefault(); if (ModelState.IsValid) { model.Name = catModel.categoryName; model.Description = catModel.description; model.ModifiedDate = DateTime.Now; model.ModifiedBy = user.ID; model.IsActive = true; db.SaveChanges(); return(RedirectToAction("ManageCategory")); } return(View()); }
public ActionResult ManageCategory() { if (Session["ID"] != null) { int id = Convert.ToInt32(Session["ID"]); int RoleMember = Convert.ToInt32(Enums.UserRoleId.Member); User user = db.Users.Where(x => x.ID == id).FirstOrDefault(); if (user.RoleID != RoleMember) { ManageCategoryViewModel Model = new ManageCategoryViewModel(); Model.getCategoryData_Results = db.GetCategoryData().ToList(); return(View(Model)); } else { return(RedirectToAction("Index", "Home")); } } else { return(RedirectToAction("Login", "Account")); } }
public ActionResult AddCategory(ManageCategoryViewModel category) { var user = db.Users.FirstOrDefault(x => x.Email == User.Identity.Name); if (ModelState.IsValid) { //add data into category table NoteCategories Notes = new NoteCategories(); Notes.Name = category.categoryName; Notes.Description = category.description; Notes.CreatedDate = DateTime.Now; Notes.CreatedBy = user.ID; Notes.IsActive = true; db.NoteCategories.Add(Notes); db.SaveChanges(); return(RedirectToAction("ManageCategory")); } return(View()); }
public async Task <ActionResult> Edit(ManageCategoryViewModel viewModel) { if (!ModelState.IsValid) { return(View(viewModel)); } var category = viewModel.ToCategory(); var validationResult = categoryValidator.Validate(category); if (!validationResult.IsValid()) { validationResult.Errors.ToList().ForEach(e => ModelState.AddModelError(e.PropertyName, e.ErrorMessage)); return(View(viewModel)); } await categoryService.EditCategory(category); TempData["message"] = $"Zapisano kategorie {category.Name}"; return(RedirectToActionPermanent("Index")); }
public static Category ToCategory(this ManageCategoryViewModel viewModel) => Mapper.Map <Category>(viewModel);
public ActionResult Index() { ManageCategoryViewModel vmCategory = new ManageCategoryViewModel(); vmCategory.Read(); return View(vmCategory); }
public ActionResult ManageCategory(string SortOrder, string Category_search, int Category_page = 1) { var user = db.Users.FirstOrDefault(x => x.Email == User.Identity.Name); ViewBag.Settings = "active"; ViewBag.managecategory = "active"; //sorting ViewBag.CategorySortParm = SortOrder == "Category" ? "Category_desc" : "Category"; ViewBag.DescriptionSortParm = SortOrder == "Description" ? "Description_desc" : "Description"; ViewBag.AddedBySortParm = SortOrder == "AddedBy" ? "AddedBy_desc" : "AddedBy"; ViewBag.ActiveSortParm = SortOrder == "Active" ? "Active_desc" : "Active"; ViewBag.DateSortParm = SortOrder == "Date" ? "Date_desc" : "Date"; ManageCategoryViewModel Categories = new ManageCategoryViewModel(); //Query string var cate = from cat in db.NoteCategories join ur in db.Users on cat.CreatedBy equals ur.ID select new ManageCat { categories = cat, users = ur }; //searching if (Category_search != null) { cate = cate.Where(x => x.categories.Name.Contains(Category_search) || x.categories.Description.Contains(Category_search) || x.categories.CreatedDate.ToString().Contains(Category_search) || x.users.FirstName.Contains(Category_search) || x.users.LastName.Contains(Category_search)); } //sorting switch (SortOrder) { case "Category_desc": cate = cate.OrderByDescending(s => s.categories.Name); break; case "Category": cate = cate.OrderBy(s => s.categories.Name); break; case "Description_desc": cate = cate.OrderByDescending(s => s.categories.Description); break; case "Description": cate = cate.OrderBy(s => s.categories.Description); break; case "AddedBy_desc": cate = cate.OrderByDescending(s => s.users.FirstName); break; case "AddedBy": cate = cate.OrderBy(s => s.users.FirstName); break; case "Active_desc": cate = cate.OrderByDescending(s => s.categories.IsActive); break; case "Active": cate = cate.OrderBy(s => s.categories.IsActive); break; case "Date_desc": cate = cate.OrderByDescending(s => s.categories.CreatedDate); break; case "Date": cate = cate.OrderBy(s => s.categories.CreatedDate); break; default: cate = cate.OrderByDescending(s => s.categories.CreatedDate); break; } //assign data to model Categories.Category = cate; //pagination var pager = new Pager(cate.Count(), Category_page, 10); ViewBag.currentPage = pager.CurrentPage; ViewBag.endPage = pager.EndPage; ViewBag.startpage = pager.StartPage; ViewBag.totalPage = cate.Count(); Categories.Category = cate.Skip((pager.CurrentPage - 1) * pager.PageSize).Take(pager.PageSize); return(View(Categories)); }
public ResultViewModel <IEnumerable <ManageCategoryViewModel> > Search(int SortBy, int SearchBy, int SearchIn, string SearchText, int PageIndex, int PageSize) { ResultViewModel <IEnumerable <ManageCategoryViewModel> > result = new ResultViewModel <IEnumerable <ManageCategoryViewModel> >(); int count = 0; try { if (SearchIn == 1)//mainCategory { if (SearchBy == 0) { var searshResult = mainCategoryService.GetAll(out count, SortBy, PageIndex, PageSize).Select(i => i.ToManageCategoryViewModel()); result.Data = searshResult; } else if (SearchBy == 1)//SearchByParent { var searshResult = mainCategoryService.GetAll(out count, SortBy, PageIndex, PageSize). Select(i => i.ToManageCategoryViewModel()); result.Data = searshResult; } else if (SearchBy == 2) //searchbychild { var searshResult = mainCategoryService.SearchByChilds(out count, 0, SearchText, PageIndex, PageSize). Select(i => i.ToManageCategoryViewModel()); result.Data = searshResult; } else if (SearchBy == 3)//SearchByName { var searshResult = mainCategoryService.SearchByName(out count, 0, SearchText, PageIndex, PageSize) .Select(i => i.ToManageCategoryViewModel()); result.Data = searshResult; } else if (SearchBy == 4) //SearchByID { int ID; bool VaildID = int.TryParse(SearchText, out ID); if (VaildID) { var searshResult = mainCategoryService.GetAll(out count, 0, PageIndex, PageSize).Where(i => i.ID == ID) .Select(i => i.ToManageCategoryViewModel()); result.Data = searshResult; } } } else if (SearchIn == 2)//SubCategory { if (SearchBy == 0) { var searshResult = subCategoryService.GetAll(out count, SortBy, PageIndex, PageSize) .Select(i => i.ToManageCategoryViewModel()); result.Data = searshResult; } else if (SearchBy == 1) { var searshResult = subCategoryService.SearchByName(out count, SortBy, SearchText, PageIndex, PageSize) .Select(i => i.ToManageCategoryViewModel()); result.Data = searshResult; } else if (SearchBy == 2) { var searshResult = subCategoryService.SearchByChilds(out count, SortBy, SearchText, PageIndex, PageSize) .Select(i => i.ToManageCategoryViewModel()); result.Data = searshResult; } else if (SearchBy == 3) { var searshResult = subCategoryService.SearchByName(out count, SortBy, SearchText, PageIndex, PageSize). Select(i => i.ToManageCategoryViewModel()); result.Data = searshResult; } else if (SearchBy == 4) { int ID; bool VaildID = int.TryParse(SearchText, out ID); if (VaildID) { var searshResult = subCategoryService.SeachByID(ID). Select(i => i.ToManageCategoryViewModel()); result.Data = searshResult; } } } else if (SearchIn == 3)//Track { if (SearchBy == 0) { var searshResult = trackService.GetAll(out count, SortBy, PageIndex, PageSize). Select(i => i.ToManageCategoryViewModel()); result.Data = searshResult; } else if (SearchBy == 1) { var searshResult = trackService.SearchByParentName(out count, SortBy, SearchText, PageIndex, PageSize). Select(i => i.ToManageCategoryViewModel()); result.Data = searshResult; } else if (SearchBy == 2) { var searshResult = trackService.SearchByChilds(out count, SortBy, SearchText, PageIndex, PageSize). Select(i => i.ToManageCategoryViewModel()); result.Data = searshResult; } else if (SearchBy == 3) { var searshResult = trackService.SearchByName(out count, SortBy, SearchText, PageIndex, PageSize). Select(i => i.ToManageCategoryViewModel()); result.Data = searshResult; } else if (SearchBy == 4) { int ID; bool VaildID = int.TryParse(SearchText, out ID); if (VaildID) { var searshResult = trackService.SeachByID(ID). Select(i => i.ToManageCategoryViewModel()); result.Data = searshResult; } } } else if (SearchIn == 4)//Course { if (SearchBy == 0) { var searshResult = courseService.GetAll(out count, SortBy, PageIndex, PageSize). Select(i => i.ToManageCategoryViewModel()); result.Data = searshResult; } else if (SearchBy == 1) { var searshResult = courseService.SearchByParentName(out count, SortBy, SearchText, PageIndex, PageSize). Select(i => i.ToManageCategoryViewModel()); result.Data = searshResult; } else if (SearchBy == 2) { result.Data = new List <ManageCategoryViewModel>(); } else if (SearchBy == 3) { var searshResult = courseService.SearchByName(out count, SortBy, SearchText, PageIndex, PageSize). Select(i => i.ToManageCategoryViewModel()); result.Data = searshResult; } else if (SearchBy == 4) { int ID; bool VaildID = int.TryParse(SearchText, out ID); if (VaildID) { var searshResult = courseService.SeachByID(ID). Select(i => i.ToManageCategoryViewModel()); result.Data = searshResult; } } } else { List <ManageCategoryViewModel> res = new List <ManageCategoryViewModel>(); var searshResult = new ManageCategoryViewModel() { ID = 1, Name = "Main Category Parent", Childs = mainCategoryService.GetAll(out count, SortBy, PageIndex, PageSize).Select(i => i.Name).ToList(), Parent = "" }; res.Add(searshResult); result.Data = res; } result.Count = count; if (SearchIn == 0) { count = 0; } result.Successed = true; } catch (Exception ex) { result.Successed = false; result.Message = "Something Went Wrong !!"; } return(result); }
public ActionResult Create() { var viewModel = new ManageCategoryViewModel(); return(View(viewModel)); }