public bool SetRolesAuth(OSS_ROLES_AUTH ROLEAUTH)
{
try
{
OSS_ROLES_AUTH TU = _context.OSS_ROLES_AUTH.Where(t => t.U_Role == ROLEAUTH.U_Role).FirstOrDefault();
if (TU != null)
{
TU.U_Role = ROLEAUTH.U_Role;
TU.U_Component = ROLEAUTH.U_Component;
_context.OSS_ROLES_AUTH.Update(TU);
_context.SaveChanges();
return(true);
}
string Query = "select ISNULL(cast(max(cast(Code as int)+1)as nvarchar),'1') as Code from [@OSS_ROLES_AUTH]";
//MaxCode = _context.Database.SqlQuery<int>(Query).SingleOrDefault();
var MaxCodeStr = _context.OSS_ROLES_AUTH.FromSqlRaw(Query).Select(t => t.Code).FirstOrDefault();
ROLEAUTH.Code = MaxCodeStr;
ROLEAUTH.Name = MaxCodeStr;
//newRLAth.U_Role = ROLEAUTH.U_Role;
//newRLAth.U_Component = ROLEAUTH.U_Component;
ROLEAUTH.U_Method = "";
_context.OSS_ROLES_AUTH.Add(ROLEAUTH);
_context.SaveChanges();
return(true);
}
catch (Exception e)
{ return(false); }
}
public IActionResult SetRolesAuth(RoleAuthVM obj)
{
var thisObj = new OSS_ROLES_AUTH {
U_Role = obj.role,
U_Component = string.Join(",", obj.component.ToArray())
};
var result = _AuthRepo.SetRolesAuth(thisObj);
return(Ok());
}
