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 PartsProductsViewModel AddNewPartsProducts() { VehicleModelRepository vehicleModelRepository = new VehicleModelRepository(new AutoSolutionContext()); PartsSubCategoryRepository partsSubCategoryRepository = new PartsSubCategoryRepository(new AutoSolutionContext()); TransmissionTypeRepository transmissionTypeRepository = new TransmissionTypeRepository(new AutoSolutionContext()); VehicleEngineTypeRepository vehicleEngineTypeRepository = new VehicleEngineTypeRepository(new AutoSolutionContext()); PartsProductManufacturerRepository partsProductManufacturerRepository = new PartsProductManufacturerRepository(new AutoSolutionContext()); PartsProductsViewModel partsProductsViewModel = new PartsProductsViewModel() { VehicleManufacturerList = vehicleModelRepository.GetVehicleManufacturerDropDown(), PartsProductsCategoryList = partsSubCategoryRepository.GetPartsProductCategoryDropDown(), PartsProductsSubCategoryList = partsSubCategoryRepository.GetPartsProductSubCategoryDropDownEmpty(), PartProductManufacturerList = partsProductManufacturerRepository.GetPPManufacturerDropDownEmpty(), VehicleModelList = vehicleModelRepository.GetVehicleModelDropDownEmpty(), //TransmissionTypeList = transmissionTypeRepository.GetTransmissionTypeDownEmpty(), //EngineTypeList = vehicleEngineTypeRepository.GetVehicleEngineTypeDropDownEmpty(), }; return(partsProductsViewModel); }
public PartProductwraperForHome GetPartsProducts(int PageNo, int TotalCount, int id) { VehicleModelRepository vehicleModelRepository = new VehicleModelRepository(new AutoSolutionContext()); PartsSubCategoryRepository partsSubCategoryRepository = new PartsSubCategoryRepository(new AutoSolutionContext()); PartProductwraperForHome partProductwraperForHome = new PartProductwraperForHome() { FindYourPart = { VehicleManufacturersList = vehicleModelRepository.GetVehicleManufacturerDropDownForHome(), VehicleModelsList = vehicleModelRepository.GetVehicleModelDropDownEmptyForHome(), PartsProductsCategoryList = partsSubCategoryRepository.GetPartsProductCategoryDropDown(), PartsProductsSubCategoryList = partsSubCategoryRepository.GetPartsProductSubCategoryDropDownEmpty() }, PartsProductsCategory = AutoSolutionContext.PartsProductsCategories.Where(x => x.PartsProductsCategoryId == id).FirstOrDefault(), PartsProductsViewModelsList = (from ppsc in AutoSolutionContext.PartsProductsSubCategories join pp in AutoSolutionContext.PartsProducts on ppsc.PartsProductsSubCategoryId equals pp.PartsProductsSubCategoryId where id == ppsc.PartsProductsCategoryId orderby pp.AddedDate select new PartsProductsViewModel() { PartsProductName = pp.PartsProductName, UnitPrice = pp.UnitPrice, ShortDescription = pp.ShortDescription, VehicleManufacturerName = pp.VehicleManufacturer.VehicleManufacturerName, VehicleModelName = pp.VehicleModel.VehicleModelName, startYear = pp.startYear, EndYear = pp.EndYear }).Skip((PageNo - 1) * 12).Take(12).ToList(), Pager = new Pager(TotalCount, PageNo, 12) }; return(partProductwraperForHome); }
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); }