public JsonResult GetListUserInGroup(string deparment)
{
var list = (from a in _context.AdGroupUsers
join b in _context.AdUserInGroups on a.GroupUserCode equals b.GroupUserCode into b2
from b1 in b2.DefaultIfEmpty()
join c in _context.Users on b1.UserId equals c.Id into c2
from c1 in c2.DefaultIfEmpty()
where a.GroupUserCode == deparment
select new
{
c1
}).ToList();
List <DispatchesUser1> list1 = new List <DispatchesUser1>();
foreach (var item in list)
{
if (item.c1 != null)
{
DispatchesUser1 dt = new DispatchesUser1();
dt.Id = item.c1.Id;
dt.GivenName = item.c1.GivenName;
list1.Add(dt);
}
}
return(Json(list1));
}
public JsonResult GetDispatchesUser()
{
var user = _context.Users.FirstOrDefault(x => x.UserName == ESEIM.AppContext.UserName);
var deparment = _context.AdUserInGroups.FirstOrDefault(x => x.UserId == user.Id);
var query = from a in _context.AdUserInGroups
join b in _context.Users on a.UserId equals b.Id into b2
from b1 in b2.DefaultIfEmpty()
where a.GroupUserCode == deparment.GroupUserCode &&
a.UserId != user.Id
select new
{
a,
b1
};
var list = query.ToList();
List <DispatchesUser1> list1 = new List <DispatchesUser1>();
foreach (var item in list)
{
if (item.b1 != null)
{
DispatchesUser1 dt = new DispatchesUser1();
dt.Id = item.b1.Id;
dt.GivenName = item.b1.GivenName;
list1.Add(dt);
}
}
return(Json(list1));
}