private IdentityModel ConvertUser(MD.tbl_Common_User user)
{
if (user == null)
{
return(null);
}
var result = new IdentityModel();
var roleUser = user.tbl_Common_RoleUser.FirstOrDefault();
int roleId = roleUser == null ? 0 : roleUser.RoleId.Value;
var role = ctx.Role.Where(r => r.RoleId == roleId).FirstOrDefault();
result.Id = user.UserId.ToString();
result.LogonName = user.LogonName;
result.RoleId = roleId;
result.RoleName = role == null ? "" : role.Name;
result.RoleSelectList =
(from m in ctx.ModulePermissionDefine
join pi in ctx.RolePermissionConfig.DefaultIfEmpty() on m.ModuleId equals pi.ModuleId into inner
from p in inner.DefaultIfEmpty()
where (p.RoleId == roleId || p.RoleId == null)
select new RolePermission
{
Action = string.IsNullOrEmpty(m.Action) ? "index" : m.Action,
Area = m.Area ?? string.Empty,
Controller = m.Controller ?? string.Empty,
ModuleId = m.ModuleId,
IsAvailable = (m.Value & p.Value) == m.Value ? true : false
}).ToList();
MD.tbl_Common_UserOfGasStation userGas = ctx.UserOfGasStation.Where(m => m.UserId == user.UserId).FirstOrDefault();
return(result);
}
public IdentityModel GetLoginByName(string userName)
{
var user = Ctx.tbl_Common_User.AsNoTracking().Where(u => u.LogonName == userName && u.IsDeleted != true).FirstOrDefault();
if (user == null)
{
return(null);
}
try
{
var results = (from login in Ctx.tbl_Common_User
where login.LogonName == userName && login.Status == 1 && login.IsDeleted != true
select new IdentityModel()
{
Id = login.UserId.ToString(),
LogonName = login.LogonName,
UserName = login.UserName,
PasswordHash = login.Password,
DomainAccount = login.DomainAccount,
EmailAddress = login.EmailAddress
}).FirstOrDefault();
var roleUsers = user.tbl_Common_RoleUser.FirstOrDefault();
int roleIds = roleUsers == null ? 0 : roleUsers.RoleId.Value;
var role = Ctx.tbl_Common_Role.Where(r => r.RoleId == roleIds).FirstOrDefault();
results.Id = user.UserId.ToString();
results.RoleId = roleIds;
results.RoleName = role == null ? "" : role.Name;
results.RoleSelectList =
(from m in Ctx.tbl_Common_ModulePermissionDefine
join pi in Ctx.tbl_Common_RolePermissionConfig.DefaultIfEmpty() on m.ModuleId equals pi.ModuleId into inner
from p in inner.DefaultIfEmpty()
where (p.RoleId == roleIds || p.RoleId == null)
select new RolePermission
{
Action = string.IsNullOrEmpty(m.Action) ? "index" : m.Action,
Area = m.Area ?? string.Empty,
Controller = m.Controller ?? string.Empty,
ModuleId = m.ModuleId,
IsAvailable = (m.Value & p.Value) == m.Value ? true : false
}).ToList();
MD.tbl_Common_UserOfGasStation userGas = Ctx.tbl_Common_UserOfGasStation.Where(m => m.UserId == user.UserId).FirstOrDefault();
//if (gas != null)
// results.CompanyId = gas.Company;
return(results);
}
catch (Exception)
{
return(null);
}
}
