public async Task <object> GetBuildingByIngredientAndBatch(string ingredient, string batchValue) { var ingredientName = ingredient.ToSafetyString(); var from = DateTime.Now.Date.AddDays(-3).Date; var to = DateTime.Now.Date.Date; var plans = _repoPlan.FindAll() .Include(x => x.Building) .Include(x => x.BPFCEstablish) .ThenInclude(x => x.Glues) .Where(x => x.DueDate.Date >= from && x.DueDate.Date <= to) .Select(x => new { x.BPFCEstablish.Glues, Line = x.Building.ParentID, x.DueDate }); var lines = new List <int?>(); foreach (var plan in plans) { // lap nhung bpfc chua ingredient search foreach (var glue in plan.Glues.Where(x => x.isShow == true && x.Name.Contains(ingredientName.Trim()))) { lines.Add(plan.Line); } } var listBuilding = lines.Distinct(); var buildings = await _repoBuilding.FindAll().Where(x => listBuilding.Contains(x.ID)).ToListAsync(); return(buildings); }
//Lấy danh sách Brand và phân trang public async Task <PagedList <PlanDto> > GetWithPaginations(PaginationParams param) { var lists = _repoPlan.FindAll().ProjectTo <PlanDto>(_configMapper).OrderByDescending(x => x.ID); return(await PagedList <PlanDto> .CreateAsync(lists, param.PageNumber, param.PageSize)); }