public List <UserRolesEntity> GetUserRolesQryList(string userName) { List <UserRolesEntity> lst = null; DataTable table; string sql = getSqlQry(); sql += " WHERE Users.UserName = '******' "; table = this.dbHelper.retriveData(sql); if (table != null && table.Rows.Count > 0) { lst = new List <UserRolesEntity>(); foreach (DataRow row in table.Rows) { UserRolesEntity data = new UserRolesEntity(); this.SetData(row, data); this.SetQryData(row, data); lst.Add(data); } } return(lst); }
public async Task <MessageAndStatus> Register(string userName, string password, LoginType loginType = LoginType.Local) { var user = new UserEntity { EmailAddress = userName, Password = password, LoginType = (byte)loginType }; UserRolesEntity userRoles = new UserRolesEntity { User = user, RoleId = 1 }; _context.Add(userRoles); try { await _context.SaveChangesAsync(); } catch (Exception ex) { return(new MessageAndStatus { Status = "ERROR", Message = "" }); } return(new MessageAndStatus { Status = "OK", Message = await GenerateToken2(user.UserId) }); // Ok(await GenerateAccessTokenAsync(user.UserId)); }
public async Task <UserRolesEntity> CreateUserRolesAsync(UserRolesEntity userRole) { var result = Mapping.Mapper.Map <UserRoles>(userRole); await _context.UserRoles.AddAsync(result); await _context.SaveChangesAsync(); return(Mapping.Mapper.Map <UserRolesEntity>(result)); }
public async Task <UserRolesEntity> EditUserRolesAsync(int userRoleId, UserRolesEntity userRole) { var oldmodel = await _context.UserRoles.Include(e => e.Users) .FirstOrDefaultAsync(e => e.UserRoleId == userRoleId); var newModel = Mapping.Mapper.Map(userRole, oldmodel); //await EditSupplierAddressAsync(supplierId, supplier.Address); await _context.SaveChangesAsync(); var result = Mapping.Mapper.Map <UserRolesEntity>(newModel); return(result); }
public async Task <IActionResult> CreateUserRolesAsync(UserRolesEntity userRole) { if (_userRolesService.CheckIfNewUserRoleExist(userRole)) { var model = await _userRolesService.CreateUserRolesAsync(userRole); var location = _linkGanarator.GetPathByAction("GetUserRolesByIdAsync", "Users", new { userRoleId = model.UserRoleId }); return(Created(location, model)); } else { return(BadRequest("user Role has already been created")); } }
public List <UserRolesEntity> GetList() { List <UserRolesEntity> lst = null; DataTable table; string sql = this.getSql(); table = this.dbHelper.retriveData(sql); if (table != null && table.Rows.Count > 0) { lst = new List <UserRolesEntity>(); foreach (DataRow row in table.Rows) { UserRolesEntity data = new UserRolesEntity(); this.SetData(row, data); lst.Add(data); } } return(lst); }
public async Task <ActionResult <UserRolesEntity> > EditUserRolesAsync(int userRoleId, UserRolesEntity userRole) { if (_userRolesService.CheckIfNewUserRoleExist(userRole)) { var model = await _userRolesService.EditUserRolesAsync(userRoleId, userRole); //var result = _mapper.Map<CatalogsEntity>(catalogs); var location = _linkGanarator.GetPathByAction("GetUserRolesByIdAsync", "Users", new { userRoleId = model.UserRoleId }); return(model); } else { return(BadRequest("user Role has already been created")); } }
private void SetQryData(DataRow Row, UserRolesEntity data) { data.UserData.UserName = Row["UserName"].ToString(); data.RoleData.RoleName = Row["RoleName"].ToString(); }
private void SetData(DataRow Row, UserRolesEntity data) { data.UserData.UserId = Row["UserId"].ToString().ToIntVal(); data.RoleData.RoleId = Row["RoleId"].ToString().ToIntVal(); }
public bool CheckIfNewUserRoleExist(UserRolesEntity userRole) { return(_context.UserRoles. FirstOrDefault(e => e.Title == userRole.Title) == null ? true : false); }