/// <summary> /// Obtiene un usuario de la base de datos por su id /// </summary> /// <param name="id">Id del usuario que se desea buscar</param> /// <returns>El usuario que corresponde con el id</returns> /// <exception cref="UserNotFoundException">En caso de no encontrar ningun usuario se devuelve /// una excepcion para avisar que no se encontró ningún usuario con ese id</exception> public User GetUserById(int id) { try { // _logger.LogInformation("Entrando en GetUserById(id)",id); User user; DAOFactory factory = DAOFactory.GetFactory(DAOFactory.Type.Postgres); RoleDAO roles = factory.GetRoleDAO(); var table = PgConnection.Instance.ExecuteFunction(SP_GETUSERBYID, id); if (table.Rows.Count == 0) { throw new UserNotFoundException("No se Encontró Usuario"); } var user_id = Convert.ToInt32(table.Rows[0][0]); var documentId = Convert.ToInt64(table.Rows[0][1]); var name = table.Rows[0][2].ToString(); var lastname = table.Rows[0][3].ToString(); var email = table.Rows[0][4].ToString(); user = new User(user_id, documentId, name, lastname, email); user.Roles = roles.GetRolesForUser(id); // _logger.LogDebug("User:"******"Error", e); e.ToString(); throw; } }
public bool GetByNome(string nome, Connection conn, MySqlTransaction transaction = null) { using (var dao = new RoleDAO(conn)) { return(dao.GetByNome(this, nome, transaction)); } }
protected override bool AuthorizeCore(HttpContextBase httpContext) { CommonFunc cFunc = new CommonFunc(); if (cFunc.GetSession() == null) { return(false); //Chua dang nhap } else if (cFunc.CheckSessionInvalid() == false) { return(false); //Ko dung phien } else //check role { RoleDAO roleDao = new RoleDAO(); List <ROLE> userRoles = roleDao.GetRoles(cFunc.GetIdUserBySession()); foreach (var role in allowedRoles) { foreach (ROLE uR in userRoles) { if (role == uR.ROLE1) { return(true); } } } return(false); } }
public ViewRoles(controlPanel parent) { InitializeComponent(); this.parent = parent; dataGrid.IsReadOnly = true; dataGrid.ItemsSource = RoleDAO.getAllRoles(); }
public static Role FindByNormalizedName(string normalizedName, Connection connection, MySqlTransaction transaction = null) { using (var dao = new RoleDAO(connection)) { return(dao.FindByNormalizedName(normalizedName.ToUpper(), transaction)); } }
public static Role FindByName(string name, Connection connection, MySqlTransaction transaction = null) { using (var dao = new RoleDAO(connection)) { return(dao.FindByName(name, transaction)); } }
public void Delete(Connection connection, MySqlTransaction transaction = null) { using (var dao = new RoleDAO(connection)) { dao.Remove(this, transaction); } }
public static IList <RoleModel> GetRoles(Connection conn, MySqlTransaction transaction) { using (var dao = new RoleDAO(conn)) { return(dao.GetRoles(transaction)); } }
// GET: Admin/QuyenHanThanhVien public ActionResult Index(string searchString, int page = 1, int pagesize = 5) { var dao = new RoleDAO(); var list = dao.ListAll(searchString, page, pagesize); return(View(list)); }
public static void Init() { _apis = RoleDAO.GetApis().ToList(); _headings = RoleDAO.GetHeadings().ToList(); _subHeadings = RoleDAO.GetSubHeadings().ToList(); _roles = RoleDAO.GetRoles().ToList(); }
public HomeController() { _categoryDAO = new CategoryDAO(); _employeeDAO = new EmployeeDAO(); _roleDAO = new RoleDAO(); _notificationChannelDAO = new NotificationChannelDAO(); }
//hien thi danh sach user public ActionResult Users() { if (CheckStatusUser()) { return(RedirectToAction("Login")); } if (CheckAdmin()) { int page = Convert.ToInt32(Request["page"]); if (page <= 0) { page = 1; } UserDAO userDao = new UserDAO(); RoleDAO roleDao = new RoleDAO(); StatusUserDAO statusUserDao = new StatusUserDAO(); var list = userDao.Users(new Pagination(10, page)); ViewBag.Users = list.Comics; ViewBag.Page = list.Page; ViewBag.Numpage = list.PageSize; ViewBag.Roles = roleDao.List(); ViewBag.StatusUsers = statusUserDao.List(); return(View()); } return(RedirectToAction("Index")); }
// private readonly ILogger _logger; // GETS /// <summary> /// Se conecta con la base de datos para seleccionar todos los usuarios que no sean clientes /// </summary> /// <returns>Una lista de usuarios que no tienen como rol cliente</returns> public List <User> GetEmployees() { try { // _logger.LogInformation("Entrando en GetEmployees"); var users = new List <User>(); var table = PgConnection.Instance.ExecuteFunction(SP_GETEMPLOYEES); DAOFactory factory = DAOFactory.GetFactory(DAOFactory.Type.Postgres); RoleDAO roles = factory.GetRoleDAO(); for (int i = 0; i < table.Rows.Count; i++) { var id = Convert.ToInt32(table.Rows[i][0]); var documentId = Convert.ToInt64(table.Rows[i][1]); var name = table.Rows[i][2].ToString(); var lastname = table.Rows[i][3].ToString(); var email = table.Rows[i][4].ToString(); var user = new User(id, documentId, name, lastname, email); //Role roles = new List<Entity>(); user.Roles = roles.GetRolesForUser(id); users.Add(user); } // _logger.LogDebug("Users:", users); return(users); } catch (Exception e) { // _logger.LogError("Error", e); e.ToString(); throw; } }
public static Role FindById(int id, Connection connection, MySqlTransaction transaction = null) { using (var dao = new RoleDAO(connection)) { return(dao.FindById(id, transaction)); } }
public static List <Role> FindRoles(Connection connection, MySqlTransaction transaction) { using (var dao = new RoleDAO(connection)) { return(dao.FindRoles(transaction)); } }
public bool GetById(int id, Connection conn, MySqlTransaction transaction = null) { using (var dao = new RoleDAO(conn)) { return(dao.GetById(this, id, transaction)); } }
public Status delete(List <int> roleIDs) { if (roleIDs.Count == 0) { return(Status.SUCCESS); } RoleDAO roleDao = Factory.getInstance <RoleDAO>(); Role_PermissionDAO role_PermissionDao = Factory.getInstance <Role_PermissionDAO>(); Dictionary <string, object> wherelist = new Dictionary <string, object>(); foreach (int roleID in roleIDs) { //获取角色信息 RoleVO roleVo = roleDao.getOne <RoleVO>(roleID); if (roleVo.isIntegrant)//禁止删除系统角色 { return(Status.PERMISSION_DENIED); } wherelist.Clear(); wherelist.Add("roleID", roleID); role_PermissionDao.delete(wherelist); } return(Status.SUCCESS); }
public ActionResult Login(FormCollection f) { string email = f["email"].ToString(); string password = f["password"].ToString(); UserDAO userDao = new UserDAO(); var res = userDao.Login(email, GetMD5(password)); if (res) { var user = userDao.GetUser(email); var roleDao = new RoleDAO(); var listRole = roleDao.GetRoles(user.ID); CommonFunc cFunc = new CommonFunc(); cFunc.SetSession(user.ID, "20211"); cFunc.SetCookie(); if (listRole.Where(r => r.ROLE1 == "ADMIN").FirstOrDefault() != null) { return(Content("/Admin/Home/Index/" + user.ID)); } else if (listRole.Where(r => r.ROLE1 == "TEACHER").FirstOrDefault() != null) { return(Content("/Teacher/Home/Index/" + user.ID)); } else if (listRole.Where(r => r.ROLE1 == "STUDENT").FirstOrDefault() != null) { return(Content("/Student/Home/Index/" + user.ID)); } //} } return(Content("false")); }
public void deleteRoleById() { int id = RoleDAO.add(testStr); RoleDAO.deleteById(id); Assert.Null(RoleDAO.getById(id)); }
private void cmb_rol_SelectedIndexChanged(object sender, EventArgs e) { RoleDAO role = new RoleDAO(); role = (RoleDAO)cmb_rol.SelectedItem; this.openContainer(role.Id); }
public void register(UserDto user) { Users newUser = new Users(); newUser.CreatedDate = DateTime.Now; newUser.Role = RoleDAO.getRoleById(CONST.ROLE.NORMALUSER); newUser.Status = null; }
public void Delete(City city) { RoleDAO roleDAO = new RoleDAO(); city.Active = 0; roleDAO.Update(TABLE, IDFIELDNAME, city.AssembleDictionary(), city.Id); }
public void getRoleById() { Role test = RoleDAO.getById(testId); Assert.NotNull(test); Assert.AreEqual(test.Id, testId); Assert.AreEqual(test.Name, testStr); }
public void SetViewBag() { var _useraccess = new UserStatusDAO(); var _userrole = new RoleDAO(); ViewBag.UserRole = _userrole.ListRole(); ViewBag.UserStatus = _useraccess.ListUserStatus(); }
public SimuladorPermissoesController(PermissoesDaSimulacaoDAO permiDAO, RoleDAO roleDAO, TipoDeCalculosDAO tipoCalc) { this.permissaoDAO = permiDAO; this.roleDAO = roleDAO; this.tipoDeCalculo = tipoCalc; }
public void Delete(Role role) { RoleDAO roleDAO = new RoleDAO(); role.Active = 0; roleDAO.Update(TABLE, IDFIELDNAME, role.AssembleDictionary(), role.Id); }
// GET: Admin/Role public ActionResult Index(string searchString, int page = 1, int pageSize = 10) { var dao = new RoleDAO(); var model = dao.ListAllPaging(searchString, page, pageSize); ViewBag.SearchString = searchString; return(View(model)); }
public RoleDAO Map(Role _roletomap) { RoleDAO _roletoview = new RoleDAO(); _roletoview.RoleID = _roletomap.RoleID; _roletoview.RoleName = _roletomap.RoleName; _roletoview.RoleDesc = _roletomap.RoleName; return(_roletoview); }
public SystemService(IMapper mapper, ConfigurationOptions options) { _menuDao = new MenuDAO(options); _permissionDao = new PermissionDAO(options); _permissionApiDao = new PermissionApiDAO(options); _userDao = new UserDAO(options); _roleDao = new RoleDAO(options); _mapper = mapper; }
public override string[] GetAllRoles() { IList<Role> role = new RoleDAO().GetAll(); string[] rs = new string[role.Count]; for (int i = 0; i < rs.Length; i++) { rs[i] = role[i].RoleName; } return rs; }
public static void Main() { IUserDAO udao = new UserDAO(); IRoleDAO rdao = new RoleDAO(); string username = "******"; string roleid = "Rep"; User u = udao.GetUserByUsername(username); Role r = rdao.GetRoleInfo(roleid); //udao.UpdateUserRole(u,r); }
public override string[] GetRolesForUser(string username) { RoleDAO rd = new RoleDAO(); IList<Role> role = rd.GetByUserName(username); string[] rs = new string[role.Count]; for(int i=0;i<rs.Length;i++) { rs[i] = role[i].RoleName; } return rs; }
public override bool IsUserInRole(string username, string roleName) { RoleDAO rd = new RoleDAO(); IList<Role> roles = rd.GetByUserName(username); foreach (Role r in roles) { if (r.RoleName == roleName) return true; } return false; }
public static void LoadCurrentUser(string userName, HttpContext context) { User User = (new UserDAO()).GetByUserName(userName, null); Kingdom kingdom = new KingdomDAO().GetByUserId(User.UserId); context.Session.Add("KingdomId", kingdom.KingdomId); context.Session.Add("CurrentUser", User); context.Session.Add("UserId", User.UserId); IList<Role> roles = new RoleDAO().GetByUserId(User.UserId); Dictionary<string, int> roleNames = new Dictionary<string, int>(); foreach (Role role in roles) { if (roleNames.ContainsKey(role.RoleName.ToLower()) == false) { roleNames.Add(role.RoleName.ToLower(), role.RoleId); } } context.Session.Add("UserRoles", roleNames); }