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