public List <ActualDataEntity> GetReservationCheckIns()
{
var resDataAccess = new ReservationDataAccess(Parameters, DataContext);
Parameters[DictionaryParameter.ReservationCheckOutInDateLogic] = false.ToString();
var reservations = resDataAccess.RestrictReservation();
Parameters[DictionaryParameter.ReservationCheckOutInDateLogic] = true.ToString();
reservations = RestrictOnLongtermOffAirports(reservations);
var groupedResData = from res in reservations
group res by new { res.ReturnDate.Date, TOtalHours = res.ReturnDate.Hour + res.ReturnLocation.turnaround_hours ?? 0 }
into groupedRes
orderby groupedRes.Key.Date, groupedRes.Key.TOtalHours
select new ActualDataEntity
{
Day = groupedRes.Key.Date,
Hour = groupedRes.Key.TOtalHours,
Number = groupedRes.Count()
};
var returned = groupedResData.ToList();
return(returned);
}
public List <ActualDataEntity> GetReservationsCheckOuts()
{
var resDataAccess = new ReservationDataAccess(Parameters, DataContext);
var reservations = resDataAccess.RestrictReservation();
reservations = RestrictOnLongtermOffAirports(reservations);
var groupedResData = from res in reservations
group res by new { res.PickupDate.Date, res.PickupDate.Hour }
into groupedRes
orderby groupedRes.Key.Date, groupedRes.Key.Hour
select new ActualDataEntity
{
Day = groupedRes.Key.Date,
Hour = groupedRes.Key.Hour,
Number = groupedRes.Count()
};
var returned = groupedResData.ToList();
return(returned);
}