public IActionResult Get(ItemFilterVM filter)
{
try
{
return(Ok(_itemService.GetAll(filter)));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public GetItemVM GetAll(ItemFilterVM filter)
{
GetItemVM vm = new GetItemVM();
vm.Items = _context.Item.
Where(a => (a.BrandCategoryID == filter.BrandCategoryID || filter.BrandCategoryID == 0) &&
(a.GenderSubCategory.GenderCategoryID == filter.GenderCategoryID || filter.GenderCategoryID == 0) &&
(a.GenderSubCategory.SubCategoryID == filter.SubCategoryID || filter.SubCategoryID == 0) &&
(a.GenderSubCategory.SubCategory.CategoryID == filter.CategoryID || filter.CategoryID == 0))
.Select(a => new GetItemVM.Rows
{
ID = a.ID,
SerialNumber = a.SerialNumber,
Name = a.Name,
Description = a.Description,
Price = a.Price,
BrandCategory = _context.BrandCategory.Where(b => b.ID == a.BrandCategoryID).FirstOrDefault().Name,
GenderCategory = _context.GenderSubCategory.Where(c => c.ID == a.GenderSubCategoryID).FirstOrDefault().GenderCategory.Name,
SubCategory = _context.GenderSubCategory.Where(d => d.ID == a.GenderSubCategoryID).FirstOrDefault().SubCategory.Name,
Image = _context.ItemImage.Where(f => f.ItemID == a.ID).FirstOrDefault().Image,
BranchID = filter.BranchID
}).ToList();
return(vm);
}