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