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"); }
public static List <DayActualEntity> GetPoolingCheckInDataWithLabels(IMainFilterEntity mfe, bool hourlyTimeSlots , PoolingDataClassesDataContext db, bool siteQ) { var q2And3 = CarParametersFilter.FilterByCarParameters(db, mfe, true); q2And3 = SiteParametersFilter.FilterByReturnLocation(q2And3, mfe); var checkinData = siteQ ? _resCISiteQ.GetQueryableCI(q2And3, mfe, hourlyTimeSlots ? Enums.DayActualTime.THREE : Enums.DayActualTime.THIRTY, db) : _resCIFleetQ.GetFleetReservationsWithLabels(q2And3, mfe, hourlyTimeSlots ? Enums.DayActualTime.THREE : Enums.DayActualTime.THIRTY, db); var returned = checkinData.ToList(); return(returned); }
IList <DayActualEntity> GetPoolingCIData(Enums.DayActualTime tme) { using (PoolingDataClassesDataContext db = new PoolingDataClassesDataContext()) { IList <DayActualEntity> l = new List <DayActualEntity>(); try { IQueryable <App.Classes.DAL.Pooling.PoolingDataContext.Reservation> q2And3 = _resCarFilterQ.FilterByCarParameters(db, Filter, true); q2And3 = _resFilterQ.FilterByReturnLocation(q2And3, Filter); l = _resCISiteQ.GetQueryableCI(q2And3, Filter, tme, db).ToList(); } catch (SqlException ex) { //ILog _logger = log4net.LogManager.GetLogger("Pooling"); // if (_logger != null) _logger.Error(" SQL Exception thrown in SiteComparisonRepository accessing Reservations table, message : " + ex.Message); } return(l); } }