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 static List <DayActualEntity> GetFeaData(IMainFilterEntity mfe, bool hourlyTimeSlots, MarsDBDataContext db)
{
var checkOutData = FeaFilter.GetFeaCheckOut(db, mfe);
var checkInData = FeaFilter.GetFeaCheckIn(db, mfe);
var feaData = _feq.GetFeaDataWithoutLabels(checkOutData, checkInData,
hourlyTimeSlots ? Enums.DayActualTime.THREE : Enums.DayActualTime.THIRTY, mfe, db).ToList();
var returned = feaData;
return(returned);
}
IList <DayActualEntity> GetFeaData(IMainFilterEntity mfe)
{
using (var db = new MarsDBDataContext())
{
IList <DayActualEntity> feaData = new List <DayActualEntity>();
try
{
//db.Log = new DebugTextWriter();
var checkInData = _feaFilterQ.GetFeaCheckOut(db, mfe);
var checkoutData = _feaFilterQ.GetFeaCheckIn(db, mfe);
feaData = _feq.GetFeaDataWithoutLabels(checkInData, checkoutData, _time, mfe, db).ToList();
}
catch (SqlException ex)
{
//ILog _logger = LogManager.GetLogger("Pooling");
//if (_logger != null) _logger.Error(" SQL Exception thrown in DayActualRepository accessing FLEET_EUROPE_ACTUAL table, message : " + ex.Message);
}
return(feaData);
}
}
