public UnitOfWork(AutoSolutionContext context)
{
_context = context;
User = new UserRepository(_context);
City = new CityRepository(_context);
CityArea = new CityAreaRepository(_context);
Province = new ProvinceRepository(_context);
ServiceCategory = new ServiceCategoryRepository(_context);
UserServiceCatogory = new UserServiceCatogoryRepository(_context);
VehicleManufacturer = new VehicleManufacturerRepository(_context);
RoleRepository = new RoleRepository(_context);
VehicleModel = new VehicleModelRepository(_context);
TransmissionType = new TransmissionTypeRepository(_context);
VehicleEngineType = new VehicleEngineTypeRepository(_context);
PartsProductsCategory = new PartsProductsCategoryRepository(_context);
PartsSubCategory = new PartsSubCategoryRepository(_context);
VehicleVersion = new VehicleVersionRepository(_context);
PartsProductManufacturer = new PartsProductManufacturerRepository(_context);
PartsProducts = new PartsProductsRepository(_context);
Template = new TemplateRepository(_context);
WishList = new WishListRepository(_context);
Order = new OrderRepository(_context);
OrderDetail = new OrderDetailRepository(_context);
OrderStatus = new OrderStatusRepository(_context);
}
public OuterMostPartsViewModel GetPartsProductForHome()
{
PartsProductsCategoryRepository partsProductsCategoryRepository = new PartsProductsCategoryRepository(new AutoSolutionContext());
PartsSubCategoryRepository partsSubCategoryRepository = new PartsSubCategoryRepository(new AutoSolutionContext());
OuterMostPartsViewModel outerMostPartsViewModel = new OuterMostPartsViewModel()
{
OuterpartViewModelsList = AutoSolutionContext.PartsProductsCategories.Select(x => new OuterPartViewModel()
{
PartsProductsCategoryId = x.PartsProductsCategoryId,
PartsProductsCategoryName = x.PartsProductsCategoryName,
partInnerViewModelList = x.PartsProductsSubCategories.OrderBy(sub => sub.PartsProductsSubCategoryName).Select(y => new InnerPartViewModel()
{
PartsProductsSubCategoryId = y.PartsProductsSubCategoryId,
PartsProductsSubCategoryName = y.PartsProductsSubCategoryName,
}).ToList(),
PartsProductsViewModelsList = (from sub in x.PartsProductsSubCategories
join pp in AutoSolutionContext.PartsProducts
on sub.PartsProductsSubCategoryId equals pp.PartsProductsSubCategoryId
orderby pp.PartsProductName
//where sub.PartsProductsSubCategoryId ==pp.PartsProductsSubCategoryId
select new PartsProductsViewModel()
{
PartsProductId = pp.PartsProductId,
PartsProductName = pp.PartsProductName,
UnitPrice = pp.UnitPrice,
ShortDescription = pp.ShortDescription,
VehicleManufacturerName = pp.VehicleManufacturer.VehicleManufacturerName,
VehicleModelName = pp.VehicleModel.VehicleModelName,
startYear = pp.startYear,
EndYear = pp.EndYear
}).Take(8).ToList()
}).ToList()
};
return(outerMostPartsViewModel);
}
