public void FeaDataAccess()
        {
            var feaQ       = new FeaPoolingDataAccess();
            var feaFilterQ = new FeaFilteredQueryable();
            var mfe        = GetMainFilterExample();

            List <DayActualEntity> site;
            List <DayActualEntity> fleet;
            List <DayActualEntity> dayActuals;

            using (var db = new MarsDBDataContext())
            {
                var checkOut    = feaFilterQ.GetFeaCheckOut(db, mfe);
                var checkInData = feaFilterQ.GetFeaCheckIn(db, mfe);


                mfe.Branch = "";

                site = feaQ.GetFeaDataWithLabels(checkOut, checkInData,
                                                 Enums.DayActualTime.THREE, true, mfe, db).ToList();
                mfe.Branch = "GELEJ50";
                fleet      = feaQ.GetFeaDataWithLabels(checkOut, checkInData,
                                                       Enums.DayActualTime.THREE, false, mfe, db).ToList();

                dayActuals = feaQ.GetFeaDataWithoutLabels(checkOut, checkInData, Enums.DayActualTime.THREE, mfe, db).ToList();
            }

            TestResultComparison.CheckAllPoolingValues(dayActuals, fleet, site, "GELEJ50");
        }
        public void TestReservationCheckOutDataAccess()
        {
            var mfe           = GetMainFilterExample();
            var resCarFilterQ = new ReservationsFilterCar();
            var resFilterQ    = new ReservationsSiteFilter();
            var reqCo         = new PoolingCheckOutReservations();

            var resCOSiteQ  = new ResSiteCOQueryable();
            var resCOFleetQ = new PoolingCheckOutReservationsWithLabels();

            List <DayActualEntity> dayActuals;
            List <DayActualEntity> fleet;
            List <DayActualEntity> site;

            using (var db = new PoolingDataClassesDataContext())
            {
                var q2And3 = resCarFilterQ.FilterByCarParameters(db, mfe, false);
                q2And3 = resFilterQ.FilterByRentalLocation(q2And3, mfe);


                mfe.Branch = "";
                site       = resCOSiteQ.GetQueryableCO(q2And3, mfe, Enums.DayActualTime.THREE).ToList();
                mfe.Branch = "GELEJ50";
                fleet      = resCOFleetQ.GetQueryable(q2And3, mfe, Enums.DayActualTime.THREE).ToList();


                dayActuals = reqCo.GetReservationsWithoutLabels(q2And3, mfe, Enums.DayActualTime.THREE).ToList();
            }

            TestResultComparison.CheckAllPoolingValues(dayActuals, fleet, site, "GELEJ50");
        }
        public void TestReservationCheckInDataAccess()
        {
            var mfe           = GetMainFilterExample();
            var resCarFilterQ = new ReservationsFilterCar();
            var resFilterQ    = new ReservationsSiteFilter();
            var reqCi         = new ResActualCIQueryable();
            var resCiSiteQ    = new ResSiteCIQueryable();
            var resCiFleetQ   = new PoolingCheckInReservations();

            List <DayActualEntity> dayActuals;
            List <DayActualEntity> site;
            List <DayActualEntity> fleet;

            using (var db = new PoolingDataClassesDataContext())
            {
                var q2And3 = resCarFilterQ.FilterByCarParameters(db, mfe, true);
                q2And3 = resFilterQ.FilterByReturnLocation(q2And3, mfe);

                mfe.Branch = "";
                site       = resCiSiteQ.GetQueryableCI(q2And3, mfe, Enums.DayActualTime.THREE, db);
                mfe.Branch = "GELEJ50";
                fleet      = resCiFleetQ.GetFleetReservationsWithLabels(q2And3, mfe, Enums.DayActualTime.THREE, db);

                dayActuals = reqCi.GetQueryable(q2And3, mfe, Enums.DayActualTime.THREE);
            }


            TestResultComparison.CheckAllPoolingValues(dayActuals, fleet, site, "GELEJ50");
        }
Esempio n. 4
0
        public void TestCalculateTopics()
        {
            var mfe = GetMainFilterExample();

            var site = ReservationsDataAccess.CalculateTopics(true, 72, mfe, true, true);

            var fleet      = ReservationsDataAccess.CalculateTopics(true, 72, mfe, true, false);
            var dayActuals = ReservationsDataAccess.CalculateTopics(true, 72, mfe, false);

            TestResultComparison.CheckAllPoolingValues(dayActuals, fleet, site);
        }
        public void TestCalculateTopics()
        {
            var mfe  = GetMainFilterExample();
            var site = ReservationsDataAccess.CalculateTopics(true, 72, mfe, true, true);

            var fleet      = ReservationsDataAccess.CalculateTopics(true, 72, mfe, true, false);
            var dayActuals = ReservationsDataAccess.CalculateTopics(true, 72, mfe, false);


            var ss = site.Where(d => d.Tme == 24);
            var ff = fleet.Where(d => d.Tme == 24);

            var ss2 = ss.Sum(d => d.Offset);
            var ff2 = ff.Sum(d => d.Offset);

            TestResultComparison.CheckAllPoolingValues(dayActuals, fleet, site);
        }
        public void TestCalculateTopics()
        {
            //var p = new List<string>
            //                 {
            //                     "GEBRA63",
            //                     "GEBRA91",
            //                     "GECLL61",
            //                     "GEESW60",
            //                     "GEGTT91",
            //                     "GEHAJ61",
            //                     "GEHAJ63",
            //                     "GEHAJ66",
            //                     "GEHDM60",
            //                     "GEKSL60",
            //                     "GEKSL90",
            //                     "GENOH61",
            //                     "GEPDB61",
            //                     "GESGR60",
            //                     "GEWER60",
            //                     "GEWUN60",
            //                     "GEGTN61"
            //                 };

            var p = new List <string>
            {
                "GELEJ50",
            };
            var mfe = GetMainFilterExample();

            foreach (var s in p)
            {
                mfe.Branch = "";
                var site = ReservationsDataAccess.CalculateTopics(true, 72, mfe, true, true);
                mfe.Branch = s;
                var fleet      = ReservationsDataAccess.CalculateTopics(true, 72, mfe, true, false);
                var dayActuals = ReservationsDataAccess.CalculateTopics(true, 72, mfe, false);

                TestResultComparison.CheckAllPoolingValues(dayActuals, fleet, site, s);
            }
        }