public ActionResult Action(webpages_Roles objSubmit) { if (objSubmit.RoleId == 0) { objSubmit.DateCreated = DateTime.Now; objSubmit.DateUpdated = DateTime.Now; objSubmit.IsDeleted = false; objSubmit.IsShow = true; userRoleRepository.Add(objSubmit); } else { var obj = userRoleRepository.GetById <webpages_Roles>(objSubmit.RoleId); UpdateModel(obj); objSubmit.DateUpdated = DateTime.Now; userRoleRepository.Update(obj); } return(Json(new { Error = false }, JsonRequestBehavior.AllowGet)); }
/** * Retorna true se o privilégio do usuário logado é de vendedor da ATOS */ public static bool isAtosRoleVendedor(string token) { webpages_Users user = GetUser(token); if (user == null) { return(false); } using (var _db = new painel_taxservices_dbContext()) { _db.Configuration.ProxyCreationEnabled = false; webpages_Roles role = _db.webpages_UsersInRoles .Where(r => r.UserId == user.id_users) .Where(r => r.RoleId > 50) .Select(r => r.webpages_Roles) .FirstOrDefault(); if (role == null) { return(false); } return(role.RoleLevel >= 0 && role.RoleLevel <= 2 && role.RoleName.ToUpper().Equals("COMERCIAL")); } }
public void UpdateRole(webpages_Roles roleInput) { if (ModelState.IsValid) { try { var repo = new Durandal2UserMaintContext(); var role = (from v in repo.webpages_Roles where v.RoleId == roleInput.RoleId select v).FirstOrDefault(); if (role != null) { role.RoleName = roleInput.RoleName; repo.SaveChanges(); } else { throw new Exception("Role to update not found"); } } catch (Exception) { throw; } } else { string errors = ModelState.Values.SelectMany(modelState => modelState.Errors).Aggregate(string.Empty, (current, error) => current + (error.ErrorMessage + Environment.NewLine)); throw new Exception(errors); } }
public ActionResult Details(int id = 0) { UserProfile up = new UserProfile(); try { //Check Authorization string roleName = System.Web.Security.Roles.GetRolesForUser().Single(); if (roleName.ToUpper() == "USER") { return(RedirectToAction("login", "account")); } up = db.tbl_UserProfile.Find(id); webpages_UsersInRoles wr = db.tbl_webpages_UsersInRoles.Find(up.UserId); webpages_Roles r = db.tbl_webpages_Roles.Find(wr.RoleId); up.RoleId = wr.RoleId; up.RoleName = r.RoleName; if (up == null) { return(HttpNotFound()); } } catch (Exception e) { ExceptionHandler handler = new ExceptionHandler(); handler.HandleException(e); } return(View(up)); }
public String GetRole(string username, string pass) { USER_PASSWORD id = (from u in data.USER_PASSWORD where u.USER_NAME.Equals(username) && u.PASSWORD.Equals(pass) select u).First(); webpages_Roles role = data.webpages_Roles.Where(r => r.USER_PASSWORD.Any(u => u.USER_NAME.Equals(username) && u.PASSWORD.Equals(pass))).First(); return(role.RoleName); }
private void AsignUserRoles(CGDataEntities.CGWebEntities webEntities) { SimpleRoleProvider provider = new SimpleRoleProvider(); List <int> roleKeyList = _usersInRoles.Select(T => T.Value).Distinct().ToList(); foreach (int roleKey in roleKeyList) { string roleName = _roles[roleKey]; int[] usersInRoleIndexes = _usersInRoles.Where(kv => kv.Value.Equals(roleKey)).Select(kv => kv.Key).ToArray(); string[] userNames = new string[usersInRoleIndexes.Count()]; for (int i = 0; i < usersInRoleIndexes.Count(); i++) { userNames[i] = _userProfileList[usersInRoleIndexes[i]].Username; } //wont work without HttpContext :( //provider.AddUsersToRoles(userNames, roleNames); webpages_Roles currentRole = webEntities.webpages_Roles.Where(R => R.RoleName.Equals(roleName)).Single(); foreach (UserProfile profile in webEntities.UserProfiles.Where(UP => userNames.Contains(UP.UserName))) { profile.webpages_Roles.Add(currentRole); } webEntities.SaveChanges(); } log.Info("Added Roles to system."); }
public ActionResult DeleteConfirmed(int id) { webpages_Roles webpages_roles = db.webpages_Roles.Find(id); db.webpages_Roles.Remove(webpages_roles); db.SaveChanges(); return(RedirectToAction("Index")); }
// // GET: /Registru/Edit/5 public ActionResult Edit(int id) { UserProfile userProfile = _database.UserProfiles.Single(userPorofile => userPorofile.UserId == id); webpages_Roles role = userProfile.webpages_Roles.FirstOrDefault(); ViewBag.RoleName = role.RoleName; return(View(userProfile)); }
private static webpages_Roles CreateAdminRole(UserDbContext context) { var admin = new webpages_Roles { RoleName = "Administrators" }; context.webpages_Roles.Add(admin); return(admin); }
public static RoleModel ToModel(this webpages_Roles role) { return(new RoleModel() { Id = role.RoleId, RoleName = role.RoleName, Description = role.Description, }); }
public ActionResult Edit(webpages_Roles webpages_roles) { if (ModelState.IsValid) { db.Entry(webpages_roles).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(webpages_roles)); }
// // GET: /Roles/Delete/5 public ActionResult Delete(int id = 0) { webpages_Roles webpages_roles = db.webpages_Roles.Find(id); if (webpages_roles == null) { return(HttpNotFound()); } return(View(webpages_roles)); }
public webpages_Roles DeleteRole(int id) { webpages_Roles db = context.webpages_roles.Find(id); if (db != null) { context.webpages_roles.Remove(db); context.SaveChanges(); } return(db); }
public void InsertOrUpdate(webpages_Roles entity) { if (entity.RoleId == default(int)) { _context.SetAdd(entity); } else { _context.SetModified(entity); } }
public ActionResult Create(webpages_Roles webpages_roles) { if (ModelState.IsValid) { db.webpages_Roles.Add(webpages_roles); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(webpages_roles)); }
public async Task <ActionResult> Edit([Bind(Include = "RoleId,RoleName")] webpages_Roles webpages_Roles) { if (ModelState.IsValid) { db.Entry(webpages_Roles).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(webpages_Roles)); }
public async Task <ActionResult> Create([Bind(Include = "RoleId,RoleName")] webpages_Roles webpages_Roles) { if (ModelState.IsValid) { db.webpages_Roles.Add(webpages_Roles); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(webpages_Roles)); }
public static void CreateUser(int UserId, int RoleId) { using (ManagementSystemEntities db = new ManagementSystemEntities()) { UserProfile user = db.UserProfiles.FirstOrDefault(a => a.UserId == UserId); if (user != null) { webpages_Roles userRole = db.webpages_Roles.FirstOrDefault(a => a.RoleId == RoleId); user.webpages_Roles.Add(userRole); db.SaveChanges(); } } }
public async Task <ActionResult> DeleteConfirmed(int?id) { if (id == null) { return(RedirectToAction("Index")); } webpages_Roles webpages_Roles = await db.webpages_Roles.FindAsync(id); db.webpages_Roles.Remove(webpages_Roles); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
/// <summary> /// Apaga uma Webpages_Roles /// </summary> /// <param name="param"></param> /// <returns></returns> public static void Delete(string token, Int32 RoleId, painel_taxservices_dbContext _dbContext = null) { painel_taxservices_dbContext _db; if (_dbContext == null) { _db = new painel_taxservices_dbContext(); } else { _db = _dbContext; } try { webpages_Roles role = _db.webpages_Roles.Where(r => r.RoleId == RoleId).FirstOrDefault(); if (role == null) { throw new Exception("Role inexistente"); // não existe role com o Id informado } Int32 RoleLevelMin = Permissoes.GetRoleLevelMin(token, _db); //if (role.RoleName.ToUpper().Equals("COMERCIAL") || role.RoleLevel < RoleLevelMin) throw new Exception("401"); // não possui autorização para remover o privilégio if (Permissoes.isAtosRoleVendedor(role) || role.RoleLevel < RoleLevelMin) { throw new Exception("401"); // não possui autorização para remover o privilégio } GatewayWebpagesPermissions.Delete(token, RoleId, _db); GatewayWebpagesUsersInRoles.Delete(token, RoleId, true, _db); _db.webpages_Roles.Remove(_db.webpages_Roles.Where(e => e.RoleId.Equals(RoleId)).First()); _db.SaveChanges(); } catch (Exception e) { if (e is DbEntityValidationException) { string erro = MensagemErro.getMensagemErro((DbEntityValidationException)e); throw new Exception(erro.Equals("") ? "Falha ao apagar role" : erro); } throw new Exception(e.InnerException == null ? e.Message : e.InnerException.InnerException == null ? e.InnerException.Message : e.InnerException.InnerException.Message); } finally { if (_dbContext == null) { // Fecha conexão _db.Database.Connection.Close(); _db.Dispose(); } } }
// GET: Roles/Delete/5 public async Task <ActionResult> Delete(int?id) { if (id == null) { return(RedirectToAction("Index")); } webpages_Roles webpages_Roles = await db.webpages_Roles.FindAsync(id); if (webpages_Roles == null) { return(HttpNotFound()); } return(View(webpages_Roles)); }
public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } webpages_Roles webpages_roles = db.webpages_Roles.Find(id); if (webpages_roles == null) { return(HttpNotFound()); } return(View(webpages_roles)); }
// GET: Roles/Details/5 public async Task <ActionResult> Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } webpages_Roles webpages_Roles = await db.webpages_Roles.FindAsync(id); if (webpages_Roles == null) { return(HttpNotFound()); } return(View(webpages_Roles)); }
/// <summary> /// Adiciona nova Webpages_Roles /// </summary> /// <param name="param"></param> /// <returns></returns> public static Int32 Add(string token, webpages_Roles param, painel_taxservices_dbContext _dbContext = null) { painel_taxservices_dbContext _db; if (_dbContext == null) { _db = new painel_taxservices_dbContext(); } else { _db = _dbContext; } try { // Por segurança, só deixa alterar se o usuário tiver permissão para setar aquela role Int32 RoleLevelMin = Permissoes.GetRoleLevelMin(token, _db); if (param.RoleLevel < RoleLevelMin) { throw new Exception("401"); // não possui autorização para criar um privilégio com esse RoleLevel } if (_db.webpages_Roles.Where(r => r.RoleName.ToUpper().Equals(param.RoleName.ToUpper())).FirstOrDefault() != null) { throw new Exception("Já existe uma role com o nome '" + param.RoleName.ToUpper() + "'"); // já existe um privilégio com esse nome } _db.webpages_Roles.Add(param); _db.SaveChanges(); return(param.RoleId); } catch (Exception e) { if (e is DbEntityValidationException) { string erro = MensagemErro.getMensagemErro((DbEntityValidationException)e); throw new Exception(erro.Equals("") ? "Falha ao salvar role" : erro); } throw new Exception(e.InnerException == null ? e.Message : e.InnerException.InnerException == null ? e.InnerException.Message : e.InnerException.InnerException.Message); } finally { if (_dbContext == null) { // Fecha conexão _db.Database.Connection.Close(); _db.Dispose(); } } }
public void SaveRole(webpages_Roles role) { if (role.RoleId == 0) { context.webpages_roles.Add(role); } else { webpages_Roles db = context.webpages_roles.Find(role.RoleId); if (db != null) { db.RoleName = role.RoleName; } } context.SaveChanges(); }
public string GetRoleName(int roleId) { string ret = ""; webpages_Roles role = repository.Roles_GetByRoleId(roleId); if (role != null) { ret = role.RoleName; } else { throw new Exception("Invalid Role Id provided"); } return(ret); }
// POST /webpages_Roles/token/ public HttpResponseMessage Post(string token, [FromBody] webpages_Roles param) { // Abre nova conexão using (painel_taxservices_dbContext _db = new painel_taxservices_dbContext()) { tbLogAcessoUsuario log = new tbLogAcessoUsuario(); try { HttpResponseMessage retorno = new HttpResponseMessage(); log = Bibliotecas.LogAcaoUsuario.New(token, JsonConvert.SerializeObject(param), "Post", _db); if (Permissoes.Autenticado(token, _db)) { Int32 dados = GatewayWebpagesRoles.Add(token, param, _db); log.codResposta = (int)HttpStatusCode.OK; Bibliotecas.LogAcaoUsuario.Save(log, _db); return(Request.CreateResponse <Int32>(HttpStatusCode.OK, dados)); } else { log.codResposta = (int)HttpStatusCode.Unauthorized; log.msgErro = "Unauthorized"; Bibliotecas.LogAcaoUsuario.Save(log, _db); return(Request.CreateResponse(HttpStatusCode.Unauthorized)); } } catch (Exception e) { if (e.Message.Equals("401")) { log.codResposta = (int)HttpStatusCode.Unauthorized; log.msgErro = "Unauthorized"; Bibliotecas.LogAcaoUsuario.Save(log); return(Request.CreateResponse(HttpStatusCode.Unauthorized)); } else { log.codResposta = (int)HttpStatusCode.InternalServerError; log.msgErro = e.Message; Bibliotecas.LogAcaoUsuario.Save(log); throw new HttpResponseException(HttpStatusCode.InternalServerError); } } } }
public int GetRoleId(string roleName) { int ret = 0; webpages_Roles role = repository.Roles_GetByRoleName(roleName);//.webpages_Roles.Where(m => m.RoleName == roleName).FirstOrDefault(); if (role != null) { ret = role.RoleId; } else { throw new Exception("Invalid Role name provided"); } return(ret); }
public ActionResult DeleteConfirmed(int id) { UserProfile userProfile = _database.UserProfiles.Single(user => user.UserId == id); userProfile.Active = !userProfile.Active; _database.ObjectStateManager.ChangeObjectState(userProfile, EntityState.Modified); _database.SaveChanges(); webpages_Roles role = userProfile.webpages_Roles.FirstOrDefault(); if (role.RoleName == "Customer") { return(RedirectToAction("RegisteredCustomers")); } else { return(RedirectToAction("RegisteredRestaurants")); } }
public static void InsertNewEmployee(EmployeeUsersDetails employeeUser) { int userId = UserProfilesRepository.GetUserByUserName(employeeUser.UserName).UserId; Employee employee = new Employee(); employee.CurrentSalary = employeeUser.CurrentSalary; employee.JoinDate = employeeUser.JoinDate; employee.UserId = userId; employee.CreateDate = DateTimeHelper.Today(); if (employeeUser.RoleId == 0) { webpages_Roles role = RolesRepositories.GetEmployeeRole(); employeeUser.RoleId = role.RoleId; } EmployeesRepositories.InsertNewEmployee(employee); RolesRepositories.CreateUser(userId, employeeUser.RoleId); }