public override List <Data.Model.CarPartSubCategory> Get(CarPartsSearchRequest search)
{
var query = _context.Set <CarPartSubCategory>().AsQueryable();
if (search?.categoryID.HasValue == true)
{
query = query.Where(x => x.CategoryID == search.categoryID);
}
query = query.OrderBy(x => x.SubCategoryName);
var list = query.ToList();
return(_mapper.Map <List <Data.Model.CarPartSubCategory> >(list));
}
public override List <Data.ViewModel.CarPartsVM> Get(CarPartsSearchRequest search)
{
var query = _context.Set <CarParts>().Include(p => p.Category).Include(p => p.SubCategory).AsQueryable();
if (search?.categoryID.HasValue == true && search?.subCategoryID.HasValue == false)
{
query = query.Where(x => x.CategoryID == search.categoryID);
}
if (search?.subCategoryID.HasValue == true)
{
query = query.Where(x => x.SubCategoryID == search.subCategoryID);
}
query = query.Where(p => p.CarServiceID == search.CarServiceID).OrderBy(x => x.SubCategory.SubCategoryName);
var list = query.ToList();
var listVM = new List <Data.ViewModel.CarPartsVM>();
foreach (var x in list)
{
listVM.Add(new Data.ViewModel.CarPartsVM()
{
Name = x.Name,
Price = x.Price,
Quality = x.Quality,
CategoryName = x.Category.CategoryName,
SubCategoryName = x.SubCategory.SubCategoryName,
CategoryID = x.CategoryID,
SubCategoryID = x.SubCategoryID,
CarPartID = x.CarPartID
});
}
return(listVM);
}
