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 VehicleVersionViewModel GetVehicleVersion(int PageNo, int TotalCount) { VehicleModelRepository vehicleModelRepository = new VehicleModelRepository(new AutoSolutionContext()); var VehicleVersionViewModel = new VehicleVersionViewModel() { VehicleModelList = vehicleModelRepository.GetVehicleModelDropDown(), VehicleVersionList = AutoSolutionContext.VehicleVersions.OrderBy(x => x.VehicleVersionName).Skip((PageNo - 1) * 10).Take(10).ToList(), Pager = new Pager(TotalCount, PageNo, 10) }; return(VehicleVersionViewModel); }
public VehicleVersionViewModel AddNewVehicleVerison() { VehicleModelRepository vehicleModelRepository = new VehicleModelRepository(new AutoSolutionContext()); TransmissionTypeRepository transmissionTypeRepository = new TransmissionTypeRepository(new AutoSolutionContext()); VehicleEngineTypeRepository vehicleEngineTypeRepository = new VehicleEngineTypeRepository(new AutoSolutionContext()); VehicleVersionViewModel vehicleVersionViewModel = new VehicleVersionViewModel() { VehicleManufacturerList = vehicleModelRepository.GetVehicleManufacturerDropDown(), VehicleModelList = vehicleModelRepository.GetVehicleModelDropDownEmpty(), TransmissionTypeList = transmissionTypeRepository.GetTransmissionTypeDownEmpty(), EngineTypeList = vehicleEngineTypeRepository.GetVehicleEngineTypeDropDownEmpty(), }; return(vehicleVersionViewModel); }
public VehicleVersionViewModel GetVehicleVersion(int PageNo, int TotalCount, string SearchTerm, string SelectedVehicleVersion) { if ((!string.IsNullOrEmpty(SelectedVehicleVersion)) && (!string.IsNullOrEmpty(SearchTerm))) { VehicleModelRepository vehicleModelRepository = new VehicleModelRepository(new AutoSolutionContext()); int SelectedModel = Convert.ToInt32(SelectedVehicleVersion); var VehicleVersionViewModel = new VehicleVersionViewModel() { VehicleModelList = vehicleModelRepository.GetVehicleModelDropDownEmpty(), VehicleVersionList = AutoSolutionContext.VehicleVersions.OrderBy(x => x.VehicleVersionName).Where(x => x.VehicleVersionName.ToLower().Contains(SearchTerm.ToLower()) || x.VehicleModelId == SelectedModel).Skip((PageNo - 1) * 10).Take(10).ToList(), Pager = new Pager(TotalCount, PageNo, 10) }; return(VehicleVersionViewModel); } return(null); }
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); }