public async Task <IActionResult> CerateOrEdit([FromBody] ESysUserRole eSysUserRole)
{
bool flag = false;
try
{
if (eSysUserRole.ID == 0)
{
using (var uow = _uowFactory.Create())
{
flag = await _SysUserRoleRepository.AddAsync(eSysUserRole);
uow.SaveChanges();
}
if (flag)
{
return(Ok(new { status = true, message = "success" }));
}
else
{
return(Ok(new { status = false, message = "error" }));
}
}
else
{
using (var uow = _uowFactory.Create())
{
flag = await _SysUserRoleRepository.UpdateAsync(eSysUserRole);
uow.SaveChanges();
}
if (flag)
{
return(Ok(new { status = true, message = "success" }));
}
else
{
return(Ok(new { status = false, message = "error" }));
}
}
}
catch (Exception ex)
{
return(Ok(new { status = false, message = ex.Message }));
}
}
public async Task <bool> UpdateAsync(ESysUserRole eSysUserRole)
{
string sql = "update Sys_UserRole set RoleID=@RoleID,UserID=@UserID,UserName=@UserName where ID=@ID;";
return(await _context.ExecuteAsync(sql, eSysUserRole) > 0);
}
public async Task <bool> AddAsync(ESysUserRole eSysUserRole)
{
string sql = "insert into Sys_UserRole(RoleID,UserID,UserName) values(@RoleID,@UserID,@UserName);select @@Identity;";
return(await _context.ExecuteAsync(sql, eSysUserRole) > 0);
}
