public async Task <object> GetUserOutGroup([FromBody] UserInGroupModelCustom obj)
{
try
{
var sql = "select * from ASP_NET_USERS where (ID not in (select USER_ID from VIB_USER_IN_GROUP where GROUP_USER_CODE = '" + obj.Id + "') and (UPPER(USER_NAME) LIKE UPPER('%" + obj.UName + "%')))";
var query = await _context.Users.FromSql(sql).ToListAsync();
var data = query.Where(x => x.Active).Select(x => new
{
UserId = x.Id,
UserName = x.UserName,
FullName = x.FamilyName + " " + x.GivenName,
Email = x.Email,
RoleId = "--- Role ---",
}).OrderBy(x => x.UserName);
return(Json(data));
}
catch (Exception ex)
{
JMessage objex = new JMessage()
{
Error = true, Object = ex
};
return(Json(objex));
}
}
public object GetUserInGroup([FromBody] UserInGroupModelCustom obj)
{
try
{
var query = from uig in _context.AdUserInGroups
join u in _context.Users on uig.UserId equals u.Id
where ((String.IsNullOrEmpty(obj.UName) || u.UserName.ToLower().Contains(obj.UName)) && uig.GroupUserCode == obj.Id)
select new
{
UserId = uig.User.Id,
UserName = uig.User.UserName,
FullName = uig.User.FamilyName + " " + uig.User.GivenName,
Email = uig.User.Email,
RoleId = uig.RoleId,
};
return(Json(query));
}
catch (Exception ex)
{
JMessage objex = new JMessage()
{
Error = true, Object = ex
};
return(Json(objex));
}
}
