public async Task <IActionResult> r3UpdateDataModel(UserGroupRole userGroupRole)
{
string PasswordEn = Helper.Encrypt(userGroupRole.sys_Dm_User.Username, userGroupRole.sys_Dm_User.Password);
RequestToken token = CommonData.GetDataFromToken(User);
userGroupRole.sys_Dm_User.UserCreateId = token.UserID;
userGroupRole.sys_Dm_User.CreateDate = DateTime.Now;
// update user
var user = await _context.Sys_Dm_User.FindAsync(userGroupRole.sys_Dm_User.Id);
user.Password = PasswordEn;
user.FullName = userGroupRole.sys_Dm_User.FullName;
user.Role = userGroupRole.sys_Dm_User.Role;
// update quyền
var userGroup = _context.Sys_Cog_UsersGroup.Where(x => x.UserId == userGroupRole.sys_Dm_User.Id);
_context.Sys_Cog_UsersGroup.RemoveRange(userGroup);
foreach (var item in userGroupRole.GroupRoles)
{
Sys_Cog_UsersGroup obj = new Sys_Cog_UsersGroup();
obj.UserId = user.Id;
obj.GroupRoleId = item.Id;
_context.Sys_Cog_UsersGroup.Add(obj);
}
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
return(new ObjectResult(new { error = 1 }));
}
return(new ObjectResult(new { error = 0 }));
}
public async Task <ActionResult <IEnumerable <Sys_Dm_User> > > r1AddDataSysDmUser(UserGroupRole userGroupRole)
{
try
{
RequestToken token = CommonData.GetDataFromToken(User);
var userLogin = await _context.Sys_Dm_User.FindAsync(token.UserID);
if (_context.Sys_Dm_User.Count(x => x.Code == userGroupRole.sys_Dm_User.Code) > 0)
{
return(new ObjectResult(new { error = 2, ms = "Mã nhân viên đã tồn tại trong hệ thống." }));
}
var department = await _context.Sys_Dm_Department.FindAsync(userLogin.DepartmentId);
var nest = await _context.Sys_Dm_Department.FindAsync(userGroupRole.sys_Dm_User.NestId);
Nullable <int> NestId = null;
if (nest != null)
{
NestId = nest.Id;
}
var position = await _context.Sys_Dm_Position.FindAsync(userGroupRole.sys_Dm_User.PositionId);
if (position == null)
{
return(new ObjectResult(new { error = 2, ms = "Chưa chọn chức vụ cho nhân viên mới." }));
}
string PasswordEn = Helper.Encrypt(userGroupRole.sys_Dm_User.Username, userGroupRole.sys_Dm_User.Password);
userGroupRole.sys_Dm_User.Password = PasswordEn;
userGroupRole.sys_Dm_User.PositionName = position.Name;
userGroupRole.sys_Dm_User.DepartmentName = department.Name;
userGroupRole.sys_Dm_User.UserCreateId = token.UserID;
userGroupRole.sys_Dm_User.CreateDate = DateTime.Now;
userGroupRole.sys_Dm_User.NestId = NestId;
_context.Sys_Dm_User.Add(userGroupRole.sys_Dm_User);
await _context.SaveChangesAsync();
var user = _context.Sys_Dm_User.FirstOrDefault(x => x.Code == userGroupRole.sys_Dm_User.Code);
foreach (var item in userGroupRole.GroupRoles)
{
Sys_Cog_UsersGroup obj = new Sys_Cog_UsersGroup();
obj.UserId = user.Id;
obj.GroupRoleId = item.Id;
_context.Sys_Cog_UsersGroup.Add(obj);
}
await _context.SaveChangesAsync();
return(new ObjectResult(new { error = 0 }));
}
catch (Exception)
{
return(new ObjectResult(new { error = 1 }));
}
}
public async Task <ActionResult <IEnumerable <Sys_Dm_User> > > r1AddDataSysDmUser(UserGroupRole userGroupRole)
{
try
{
var userId = Convert.ToInt32(User.Claims.First(c => c.Type == "UserId").Value);
var userLogin = await _context.Sys_Dm_User.FindAsync(userId);
if (_context.Sys_Dm_User.Count(x => x.Code == userGroupRole.sys_Dm_User.Code) > 0)
{
return(new ObjectResult(new { error = 2, ms = "Mã nhân viên đã tồn tại trong hệ thống." }));
}
var department = await _context.Sys_Dm_Department.FindAsync(userLogin.ParentDepartId);
var position = await _context.Sys_Dm_Position.FindAsync(userGroupRole.sys_Dm_User.PositionId);
if (position == null)
{
return(new ObjectResult(new { error = 2, ms = "Chưa chọn chức vụ cho nhân viên mới." }));
}
string PasswordEn = Helper.Encrypt(userGroupRole.sys_Dm_User.Username, userGroupRole.sys_Dm_User.Password);
userGroupRole.sys_Dm_User.Password = PasswordEn;
userGroupRole.sys_Dm_User.PositionName = position.Name;
userGroupRole.sys_Dm_User.DepartmentName = department.Name;
userGroupRole.sys_Dm_User.UserCreateId = userId;
userGroupRole.sys_Dm_User.CreateDate = DateTime.Now;
_context.Sys_Dm_User.Add(userGroupRole.sys_Dm_User);
await _context.SaveChangesAsync();
var user = _context.Sys_Dm_User.FirstOrDefault(x => x.Code == userGroupRole.sys_Dm_User.Code);
foreach (var item in userGroupRole.GroupRoles)
{
Sys_Cog_UsersGroup obj = new Sys_Cog_UsersGroup();
obj.UserId = user.Id;
obj.GroupRoleId = item.Id;
_context.Sys_Cog_UsersGroup.Add(obj);
}
await _context.SaveChangesAsync();
return(new ObjectResult(new { error = 0 }));
}
catch (Exception)
{
return(new ObjectResult(new { error = 1 }));
}
}
public async Task <IActionResult> r3UpdateDataModel(int id, UserGroupRole userGroupRole)
{
string PasswordEn = Helper.Encrypt(userGroupRole.sys_Dm_User.Username, userGroupRole.sys_Dm_User.Password);
var userId = Convert.ToInt32(User.Claims.First(c => c.Type == "UserId").Value);
if (id != userGroupRole.sys_Dm_User.Id)
{
return(new ObjectResult(new { error = 1 }));
}
userGroupRole.sys_Dm_User.UserCreateId = userId;
userGroupRole.sys_Dm_User.CreateDate = DateTime.Now;
// update user
var user = await _context.Sys_Dm_User.FindAsync(userGroupRole.sys_Dm_User.Id);
user.Password = PasswordEn;
user.FullName = userGroupRole.sys_Dm_User.FullName;
user.Code = userGroupRole.sys_Dm_User.Code;
// update quyền
var userGroup = _context.Sys_Cog_UsersGroup.Where(x => x.UserId == userGroupRole.sys_Dm_User.Id);
_context.Sys_Cog_UsersGroup.RemoveRange(userGroup);
foreach (var item in userGroupRole.GroupRoles)
{
Sys_Cog_UsersGroup obj = new Sys_Cog_UsersGroup();
obj.UserId = user.Id;
obj.GroupRoleId = item.Id;
_context.Sys_Cog_UsersGroup.Add(obj);
}
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
return(new ObjectResult(new { error = 1 }));
}
return(new ObjectResult(new { error = 0 }));
}