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