public List <DNUserItem> GetListAllSevice(int agencyId, string json)
{
var date = DateTime.Now.TotalSeconds();
var list = FDIUtils.StringToListString(json);
var query = from c in FDIDB.DN_Users
where (!c.IsLockedOut.HasValue || !c.IsLockedOut.Value) && c.AgencyID == agencyId &&
(!c.IsDeleted.HasValue || !c.IsDeleted.Value) && (c.IsService.HasValue && c.IsService.Value) && list.Contains(c.CodeCheckIn)
select new DNUserItem
{
UserId = c.UserId,
UserName = c.UserName,
CodeCheckIn = c.CodeCheckIn,
Times = c.Shop_Orders2.Where(m => m.EndDate > date && m.Status == 3).OrderByDescending(m => m.EndDate).Select(o => new DNUserOrderItem
{
BId = o.BedDeskID,
S = o.StartDate,
E = o.EndDate
}),
LoweredUserName = c.LoweredUserName,
};
return(query.ToList());
}
