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()); }