예제 #1
0
 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);
 }
예제 #2
0
        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);
        }
예제 #3
0
        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);
        }
예제 #4
0
        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);
        }