public void DownloadPackingListSearchResult([FromUri] string container, [FromUri] string po, [FromUri] string color, [FromUri] string style, [FromUri] string customer, [FromUri] string size) { var searchResults = _context.RegularCartonDetails.Where(x => x.Id > 0).ToList(); if (container != "NULL") { searchResults = searchResults.Where(x => x.Container == container).ToList(); } if (po != "NULL") { searchResults = searchResults.Where(x => x.PurchaseOrder == po).ToList(); } if (style != "NULL") { searchResults = searchResults.Where(x => x.Style == style).ToList(); } if (color != "NULL") { searchResults = searchResults.Where(x => x.Color == color).ToList(); } if (customer != "NULL") { searchResults = searchResults.Where(x => x.Customer == customer).ToList(); } if (size != "NULL") { searchResults = searchResults.Where(x => x.SizeBundle == size).ToList(); } var generator = new ExcelGenerator(); generator.GenerateSearchResultsExcelFile(searchResults, container, po, style, color, customer, size); }