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