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);
}
}