//GET -------------------------------------------------------------------------------------- public IActionResult Index() { RolesRepository rolesRepository = new RolesRepository(); IEnumerable <Rol> rolesIEnumerable = rolesRepository.GetAll(); return(View(rolesIEnumerable)); }
public IHttpActionResult GetAll() { var roles = _rolesRepository.GetAll(); var resultRoles = roles.Select(role => new { role.Id, Role = role.Name }); return(Ok(resultRoles)); }
private void UpdateUserRoles(string[] assignedRoles, User user, RolesRepository rolesRepository) { if (assignedRoles == null) { return; } var assignedRolesHS = new HashSet <string>(assignedRoles); var userRoles = new HashSet <int>(user.Roles.Select(u => u.ID)); foreach (var role in rolesRepository.GetAll()) { if (assignedRolesHS.Contains(role.ID.ToString())) { if (!userRoles.Contains(role.ID)) { user.Roles.Add(role); } } else if (userRoles.Contains(role.ID)) { user.Roles.Remove(role); } } }
public ActionResult EditRole(int id) { LibraryManagementSystemContext context = new LibraryManagementSystemContext(); RolesRepository rolesRepository = new RolesRepository(context); AuthenticatingActionsRepository authenticatingActionsRepository = new AuthenticatingActionsRepository(context); RolesEditRoleVM model = new RolesEditRoleVM(); if (id > 0) { Role role = rolesRepository.GetAll(filter: r => r.ID == id, includeProperties: "AuthenticatingActions").FirstOrDefault(); PopulateAssignedAuthenticatingActions(role, authenticatingActionsRepository); model.ID = role.ID; model.Name = role.Name; } else { Role role = new Role(); role.AuthenticatingActions = new List <AuthenticatingAction>(); PopulateAssignedAuthenticatingActions(role, authenticatingActionsRepository); } return(View(model)); }
static void Main(string[] args) { string coString = "Data Source=localhost;Initial Catalog=DATABASE_TASK_2;Integrated Security=True"; Console.WriteLine("----Roles----\n"); RolesRepository rolesRepo = new RolesRepository(coString); var allRoles = rolesRepo.GetAll(); foreach (var it in allRoles) { Console.WriteLine(it.ToString()); } Console.WriteLine("-------------------------------------------------------------\n"); Console.WriteLine("----Users----\n"); UsersRepository usersRepo = new UsersRepository(coString); var allUsers = usersRepo.GetAll(); foreach (var it in allUsers) { Console.WriteLine(it.ToString()); } Console.WriteLine((rolesRepo.Get(0) != null) ? rolesRepo.Get(1).ToString() : "no role with such id"); Console.ReadLine(); }
[HttpGet] public async Task <IHttpActionResult> GetAll() { try { var campo = await _repository.GetAll(); return(Ok(campo)); } catch (Exception e) { log.Error(new MDCSet(this.ControllerContext.RouteData), e); return(InternalServerError(e)); } }
public IEnumerable <SystemRole> GetSystemRoles() { return(rolesRepository .GetAll() .Select(r => new SystemRole() { RoleName = r.RoleName, RoleId = r.RoleId, IsActive = r.IsActive, CreatedDate = r.CreatedDate })); }
public ActionResult DeleteRole(int id) { LibraryManagementSystemContext context = new LibraryManagementSystemContext(); RolesRepository rolesRepository = new RolesRepository(context); RolesDeleteRoleVM model = new RolesDeleteRoleVM(); Role role = rolesRepository.GetAll(filter: r => r.ID == id, includeProperties: "AuthenticatingActions").FirstOrDefault(); model.ID = role.ID; model.Name = role.Name; return View(model); }
public ActionResult DeleteRole(int id) { LibraryManagementSystemContext context = new LibraryManagementSystemContext(); RolesRepository rolesRepository = new RolesRepository(context); RolesDeleteRoleVM model = new RolesDeleteRoleVM(); Role role = rolesRepository.GetAll(filter: r => r.ID == id, includeProperties: "AuthenticatingActions").FirstOrDefault(); model.ID = role.ID; model.Name = role.Name; return(View(model)); }
public ActionResult Index(int?id) { RolesRepository _rolesRepository = new RolesRepository(_context); if (id == null) { var lst = _rolesRepository.GetAll(currentAccount, LanguageId).ToList(); if (lst.Count > 0) { ViewBag.RolesId = new SelectList(lst, "RolesId", "RolesName"); PageSelectData(lst.First()); ViewBag.id = lst.First().RolesId; } return(View()); } else { int RolesId = Convert.ToInt32(id); try { RolesModel rolesmodel = _rolesRepository.Find(RolesId); if (rolesmodel == null) { return(HttpNotFound()); } ViewBag.RolesId = new SelectList(_rolesRepository.GetAll(currentAccount, LanguageId), "RolesId", "RolesName", RolesId); ViewBag.id = RolesId; PageSelectData(rolesmodel); return(View()); } catch { return(HttpNotFound()); } } }
public ActionResult DeleteRole(RolesDeleteRoleVM model) { LibraryManagementSystemContext context = new LibraryManagementSystemContext(); RolesRepository rolesRepository = new RolesRepository(context); Role role = rolesRepository.GetAll(filter: r => r.ID == model.ID, includeProperties: "AuthenticatingActions").FirstOrDefault(); if (role == null) { return HttpNotFound(); } role.AuthenticatingActions = null; rolesRepository.Delete(role); return RedirectToAction("Index", "Roles"); }
public ActionResult DeleteRole(RolesDeleteRoleVM model) { LibraryManagementSystemContext context = new LibraryManagementSystemContext(); RolesRepository rolesRepository = new RolesRepository(context); Role role = rolesRepository.GetAll(filter: r => r.ID == model.ID, includeProperties: "AuthenticatingActions").FirstOrDefault(); if (role == null) { return(HttpNotFound()); } role.AuthenticatingActions = null; rolesRepository.Delete(role); return(RedirectToAction("Index", "Roles")); }
private void PopulateAssignedRoles(User user, RolesRepository rolesRepository) { var allRoles = rolesRepository.GetAll(); HashSet <int> userRoles = new HashSet <int>(user.Roles.Select(r => r.ID)); List <AssignedRolesVM> model = new List <AssignedRolesVM>(); foreach (var role in allRoles) { model.Add(new AssignedRolesVM { ID = role.ID, Name = role.Name, IsAssigned = userRoles.Contains(role.ID) }); } ViewBag.Roles = model; }
public ActionResult Index() { LibraryManagementSystemContext context = new LibraryManagementSystemContext(); RolesRepository rolesRepository = new RolesRepository(context); RolesIndexVM model = new RolesIndexVM(); this.TryUpdateModel(model); model.RolesPager = model.RolesPager ?? new GenericPagerVM(); model.RolesPager.CurrentPage = model.RolesPager.CurrentPage == 0 ? 1 : model.RolesPager.CurrentPage; model.RolesPager.PagesCount = this.GetPagesCount(); model.RolesList = rolesRepository.GetAll(model.RolesPager.CurrentPage, ApplicationConfiguration.ItemsPerPage); model.RolesPager.Prefix = "RolesPager"; model.RolesPager.Action = "Index"; model.RolesPager.Controller = "Roles"; model.RolesPager.CurrentParameters = new Dictionary <string, object>() { { "RolesPager.CurrentPage", model.RolesPager.CurrentPage } }; return(View(model)); }
public ActionResult EditRole(int id) { LibraryManagementSystemContext context = new LibraryManagementSystemContext(); RolesRepository rolesRepository = new RolesRepository(context); AuthenticatingActionsRepository authenticatingActionsRepository = new AuthenticatingActionsRepository(context); RolesEditRoleVM model = new RolesEditRoleVM(); if (id > 0) { Role role = rolesRepository.GetAll(filter: r => r.ID == id, includeProperties: "AuthenticatingActions").FirstOrDefault(); PopulateAssignedAuthenticatingActions(role, authenticatingActionsRepository); model.ID = role.ID; model.Name = role.Name; } else { Role role = new Role(); role.AuthenticatingActions = new List<AuthenticatingAction>(); PopulateAssignedAuthenticatingActions(role, authenticatingActionsRepository); } return View(model); }
public ActionResult Index() { LibraryManagementSystemContext context = new LibraryManagementSystemContext(); RolesRepository rolesRepository = new RolesRepository(context); RolesIndexVM model = new RolesIndexVM(); this.TryUpdateModel(model); model.RolesPager = model.RolesPager ?? new GenericPagerVM(); model.RolesPager.CurrentPage = model.RolesPager.CurrentPage == 0 ? 1 : model.RolesPager.CurrentPage; model.RolesPager.PagesCount = this.GetPagesCount(); model.RolesList = rolesRepository.GetAll(model.RolesPager.CurrentPage, ApplicationConfiguration.ItemsPerPage); model.RolesPager.Prefix = "RolesPager"; model.RolesPager.Action = "Index"; model.RolesPager.Controller = "Roles"; model.RolesPager.CurrentParameters = new Dictionary<string, object>() { {"RolesPager.CurrentPage",model.RolesPager.CurrentPage} }; return View(model); }
private void UpdateUserRoles(string[] assignedRoles, User user, RolesRepository rolesRepository) { if (assignedRoles == null) { return; } var assignedRolesHS = new HashSet<string>(assignedRoles); var userRoles = new HashSet<int>(user.Roles.Select(u => u.ID)); foreach (var role in rolesRepository.GetAll()) { if (assignedRolesHS.Contains(role.ID.ToString())) { if (!userRoles.Contains(role.ID)) { user.Roles.Add(role); } } else if (userRoles.Contains(role.ID)) { user.Roles.Remove(role); } } }
private void PopulateAssignedRoles(User user, RolesRepository rolesRepository) { var allRoles = rolesRepository.GetAll(); HashSet<int> userRoles = new HashSet<int>(user.Roles.Select(r => r.ID)); List<AssignedRolesVM> model = new List<AssignedRolesVM>(); foreach (var role in allRoles) { model.Add(new AssignedRolesVM { ID = role.ID, Name = role.Name, IsAssigned = userRoles.Contains(role.ID) }); } ViewBag.Roles = model; }
public ActionResult EditUser(UsersEditUserVM model, string[] assignedRoles) { LibraryManagementSystemContext context = new LibraryManagementSystemContext(); ModelState.Remove("DateOut"); UsersRepository usersRepositoryContext = new UsersRepository(context); if (model.Email != null && usersRepositoryContext.GetAll().Any(u => u.Email == model.Email) && model.ID != usersRepositoryContext.GetAll(filter: u => u.Email == model.Email).FirstOrDefault().ID) { ModelState.AddModelError("Email", "* email already exists"); } if (model.ID <= 0 && string.IsNullOrEmpty(model.Password)) { this.ModelState.AddModelError("Password", "* password required"); } if (!this.ModelState.IsValid) { RolesRepository rolesRepository = new RolesRepository(context); var allRoles = rolesRepository.GetAll(); List<AssignedRolesVM> assignedRolesViewModel = new List<AssignedRolesVM>(); foreach (var role in allRoles) { assignedRolesViewModel.Add(new AssignedRolesVM { ID = role.ID, Name = role.Name, IsAssigned = false }); } ViewBag.Roles = assignedRolesViewModel; return View(model); } TryUpdateModel(model); User user = null; using (UnitOfWork unitOfWork = new UnitOfWork(context)) { try { UsersRepository usersRepositoryUnitOfWork = new UsersRepository(unitOfWork); RolesRepository rolesRepository = new RolesRepository(unitOfWork); if (model.ID > 0) { user = usersRepositoryUnitOfWork.GetAll(filter: u => u.ID == model.ID, includeProperties: "Roles").FirstOrDefault(); user.PersonalNumber = model.PersonalNumber; } else { user = new User(); user.Roles = new List<Role>(); user.PersonalNumber = usersRepositoryUnitOfWork.GetAll().LastOrDefault().PersonalNumber + 1; } user.Password = (model.Password != null) && (model.Password.Trim() != String.Empty) ? model.Password.Trim() : user.Password; user.FirstName = model.FirstName; user.Email = model.Email; user.Address = model.Address; user.LastName = model.LastName; user.Birthday = model.Birthday; user.DateIn = model.DateIn; user.DateOut = model.DateOut != null ? model.DateOut : null; UpdateUserRoles(assignedRoles, user, rolesRepository); usersRepositoryUnitOfWork.Save(user); PopulateAssignedRoles(user, rolesRepository); unitOfWork.Commit(); } catch (Exception ex) { unitOfWork.RollBack(); throw ex; } } return RedirectToAction("Index", "Users"); }
public List <Role> GetAll() { return(rolesRep.GetAll()); }
public ActionResult EditRole(RolesEditRoleVM model, string[] assignedAuthenticatingActions) { LibraryManagementSystemContext context = new LibraryManagementSystemContext(); Role role = null; if (!this.ModelState.IsValid) { AuthenticatingActionsRepository authenticatingActionsRepository = new AuthenticatingActionsRepository(context); var authenticatingActions = authenticatingActionsRepository.GetAll(); List <AuthenticatingActionsVM> authenticatingActionsViewModel = new List <AuthenticatingActionsVM>(); foreach (var action in authenticatingActions) { authenticatingActionsViewModel.Add(new AuthenticatingActionsVM { ID = action.ID, Name = action.Name, IsAssigned = false }); } ViewBag.AuthenticatingActions = authenticatingActionsViewModel; return(View(model)); } using (UnitOfWork unitOfWork = new UnitOfWork(context)) { try { var authenticatingActionsRepository = new AuthenticatingActionsRepository(unitOfWork); var rolesRepository = new RolesRepository(unitOfWork); if (model.ID > 0) { role = rolesRepository.GetAll(filter: r => r.ID == model.ID, includeProperties: "AuthenticatingActions").FirstOrDefault(); } else { role = new Role(); role.AuthenticatingActions = new List <AuthenticatingAction>(); } role.Name = model.Name; UpdateAuthenticatingActions(assignedAuthenticatingActions, role, authenticatingActionsRepository); rolesRepository.Save(role); PopulateAssignedAuthenticatingActions(role, authenticatingActionsRepository); unitOfWork.Commit(); } catch (Exception ex) { unitOfWork.RollBack(); throw ex; } } return(RedirectToAction("Index", "Roles")); }
public ActionResult EditRole(RolesEditRoleVM model, string[] assignedAuthenticatingActions) { LibraryManagementSystemContext context = new LibraryManagementSystemContext(); Role role = null; if (!this.ModelState.IsValid) { AuthenticatingActionsRepository authenticatingActionsRepository = new AuthenticatingActionsRepository(context); var authenticatingActions = authenticatingActionsRepository.GetAll(); List<AuthenticatingActionsVM> authenticatingActionsViewModel = new List<AuthenticatingActionsVM>(); foreach (var action in authenticatingActions) { authenticatingActionsViewModel.Add(new AuthenticatingActionsVM { ID = action.ID, Name = action.Name, IsAssigned = false }); } ViewBag.AuthenticatingActions = authenticatingActionsViewModel; return View(model); } using (UnitOfWork unitOfWork = new UnitOfWork(context)) { try { var authenticatingActionsRepository = new AuthenticatingActionsRepository(unitOfWork); var rolesRepository = new RolesRepository(unitOfWork); if (model.ID > 0) { role = rolesRepository.GetAll(filter: r => r.ID == model.ID, includeProperties: "AuthenticatingActions").FirstOrDefault(); } else { role = new Role(); role.AuthenticatingActions = new List<AuthenticatingAction>(); } role.Name = model.Name; UpdateAuthenticatingActions(assignedAuthenticatingActions, role, authenticatingActionsRepository); rolesRepository.Save(role); PopulateAssignedAuthenticatingActions(role, authenticatingActionsRepository); unitOfWork.Commit(); } catch (Exception ex) { unitOfWork.RollBack(); throw ex; } } return RedirectToAction("Index", "Roles"); }
public ActionResult EditUser(UsersEditUserVM model, string[] assignedRoles) { LibraryManagementSystemContext context = new LibraryManagementSystemContext(); ModelState.Remove("DateOut"); UsersRepository usersRepositoryContext = new UsersRepository(context); if (model.Email != null && usersRepositoryContext.GetAll().Any(u => u.Email == model.Email) && model.ID != usersRepositoryContext.GetAll(filter: u => u.Email == model.Email).FirstOrDefault().ID) { ModelState.AddModelError("Email", "* email already exists"); } if (model.ID <= 0 && string.IsNullOrEmpty(model.Password)) { this.ModelState.AddModelError("Password", "* password required"); } if (!this.ModelState.IsValid) { RolesRepository rolesRepository = new RolesRepository(context); var allRoles = rolesRepository.GetAll(); List <AssignedRolesVM> assignedRolesViewModel = new List <AssignedRolesVM>(); foreach (var role in allRoles) { assignedRolesViewModel.Add(new AssignedRolesVM { ID = role.ID, Name = role.Name, IsAssigned = false }); } ViewBag.Roles = assignedRolesViewModel; return(View(model)); } TryUpdateModel(model); User user = null; using (UnitOfWork unitOfWork = new UnitOfWork(context)) { try { UsersRepository usersRepositoryUnitOfWork = new UsersRepository(unitOfWork); RolesRepository rolesRepository = new RolesRepository(unitOfWork); if (model.ID > 0) { user = usersRepositoryUnitOfWork.GetAll(filter: u => u.ID == model.ID, includeProperties: "Roles").FirstOrDefault(); user.PersonalNumber = model.PersonalNumber; } else { user = new User(); user.Roles = new List <Role>(); user.PersonalNumber = usersRepositoryUnitOfWork.GetAll().LastOrDefault().PersonalNumber + 1; } user.Password = (model.Password != null) && (model.Password.Trim() != String.Empty) ? model.Password.Trim() : user.Password; user.FirstName = model.FirstName; user.Email = model.Email; user.Address = model.Address; user.LastName = model.LastName; user.Birthday = model.Birthday; user.DateIn = model.DateIn; user.DateOut = model.DateOut != null ? model.DateOut : null; UpdateUserRoles(assignedRoles, user, rolesRepository); usersRepositoryUnitOfWork.Save(user); PopulateAssignedRoles(user, rolesRepository); unitOfWork.Commit(); } catch (Exception ex) { unitOfWork.RollBack(); throw ex; } } return(RedirectToAction("Index", "Users")); }