private List <ComparisonRow> GetCurrentComparisonData()
{
var comparisonType = _siteComparison ? ComparisonLevelLookup.GetSiteComparisonTypeFromParameters(Parameters)
: ComparisonLevelLookup.GetFleetComparisonTypeFromParameters(Parameters);
var returned = GetCurrentComparisonData(comparisonType);
return(returned);
}
private List <FleetStatusRow> GetCurrentFleetComparison(bool siteComparison)
{
var comparisonType = siteComparison ? ComparisonLevelLookup.GetSiteComparisonTypeFromParameters(Parameters)
: ComparisonLevelLookup.GetFleetComparisonTypeFromParameters(Parameters);
var groupedData = GetSingleKeyGroupedVehicle(comparisonType);
var extractedData = ExtractVehicleColumns(groupedData);
var returned = extractedData.ToList();
return(returned);
}
private List <FleetStatusRow> GetHistoricalComparison(bool siteComparison)
{
var comparisonType = siteComparison ? ComparisonLevelLookup.GetSiteComparisonTypeFromParameters(Parameters)
: ComparisonLevelLookup.GetFleetComparisonTypeFromParameters(Parameters);
var groupedQueryable = GetTwoKeyGroupedAvailabilityHistory(comparisonType);
var availabilityKeyGrouping = BaseVehicleDataAccess.GetAvailabilityGroupingFromParameters(Parameters);
var fleetDayKeyGrouping = ExtractFleetHistoryColumns(availabilityKeyGrouping, groupedQueryable);
var fleetKeyGrouping = GroupByKey(fleetDayKeyGrouping);
var returned = fleetKeyGrouping.ToList();
return(returned);
}
private List <AgeingRow> GetTodayAgeRowData()
{
var vehicles = BaseVehicleDataAccess.GetVehicleQueryable(Parameters, DataContext, true, true);
vehicles = VehicleFieldRestrictions.RestrictByIdleInForeignCountry(vehicles);
var comparisonType = ComparisonLevelLookup.GetSiteComparisonTypeFromParameters(Parameters);
IQueryable <IGrouping <string, Vehicle> > groupedData = null;
switch (comparisonType)
{
case DictionaryParameter.LocationCountry:
groupedData = from v in vehicles
group v by v.LOCATION.COUNTRy1.country_description
into gd
select gd;
break;
case DictionaryParameter.Pool:
groupedData = from v in vehicles
group v by v.LOCATION.CMS_LOCATION_GROUP.CMS_POOL.cms_pool1
into gd
select gd;
break;
case DictionaryParameter.LocationGroup:
groupedData = from v in vehicles
group v by v.LOCATION.CMS_LOCATION_GROUP.cms_location_group1
into gd
select gd;
break;
case DictionaryParameter.Area:
groupedData = from v in vehicles
group v by v.LOCATION.OPS_AREA.ops_area1
into gd
select gd;
break;
case DictionaryParameter.Region:
groupedData = from v in vehicles
group v by v.LOCATION.OPS_AREA.OPS_REGION.ops_region1
into gd
select gd;
break;
case DictionaryParameter.Location:
groupedData = from v in vehicles
group v by v.LOCATION.location1
into gd
select gd;
break;
}
if (groupedData == null)
{
return(null);
}
var compData = from gd in groupedData
select new AgeingRow
{
Key = gd.Key,
FleetCount = gd.Count(),
Ages = gd.Select(d => d.DaysInCountry).ToList()
};
var returned = compData.ToList();
return(returned);
}
public List <HistoricalTrendRow> GetHistoricAgeRowData()
{
var vehicleHistories = BaseVehicleDataAccess.GetVehicleHistoryQueryable(Parameters, DataContext, true, true);
if (vehicleHistories == null)
{
return(new List <HistoricalTrendRow>());
}
var startDate = Parameters.GetDateFromDictionary(DictionaryParameter.StartDate);
var endDate = Parameters.GetDateFromDictionary(DictionaryParameter.EndDate);
var daysInCountry = 0;
if (Parameters.ContainsValueAndIsntEmpty(DictionaryParameter.MinDaysInCountry))
{
daysInCountry = int.Parse(Parameters[DictionaryParameter.MinDaysInCountry]);
}
vehicleHistories = from vh in vehicleHistories
where vh.TimeStamp >= startDate &&
vh.TimeStamp <= endDate &&
vh.IsFleet &&
vh.DaysInCountry >= daysInCountry
select vh;
vehicleHistories = VehicleFieldRestrictions.RestrictVehicleHistoryByIdleInForeignCountry(vehicleHistories);
var comparisonType = ComparisonLevelLookup.GetSiteComparisonTypeFromParameters(Parameters);
IQueryable <HistoricalTrendRow> historicalTrendData = null;
switch (comparisonType)
{
case DictionaryParameter.LocationCountry:
historicalTrendData = from v in vehicleHistories
group v by new { v.TimeStamp.Date, v.LOCATION.COUNTRy1.country_description }
into gd
select new HistoricalTrendRow
{
ColumnCode = gd.Key.country_description,
CodeCount = gd.Count(),
Date = gd.Key.Date
};
break;
case DictionaryParameter.Pool:
historicalTrendData = from v in vehicleHistories
group v by new { v.TimeStamp.Date, v.LOCATION.CMS_LOCATION_GROUP.CMS_POOL.cms_pool1 }
into gd
select new HistoricalTrendRow
{
ColumnCode = gd.Key.cms_pool1,
CodeCount = gd.Count(),
Date = gd.Key.Date
};
break;
case DictionaryParameter.LocationGroup:
historicalTrendData = from v in vehicleHistories
group v by new { v.TimeStamp.Date, v.LOCATION.CMS_LOCATION_GROUP.cms_location_group1 }
into gd
select new HistoricalTrendRow
{
ColumnCode = gd.Key.cms_location_group1,
CodeCount = gd.Count(),
Date = gd.Key.Date
};
break;
case DictionaryParameter.Area:
historicalTrendData = from v in vehicleHistories
group v by new { v.TimeStamp.Date, v.LOCATION.OPS_AREA.ops_area1 }
into gd
select new HistoricalTrendRow
{
ColumnCode = gd.Key.ops_area1,
CodeCount = gd.Count(),
Date = gd.Key.Date
};
break;
case DictionaryParameter.Region:
historicalTrendData = from v in vehicleHistories
group v by new { v.TimeStamp.Date, v.LOCATION.OPS_AREA.OPS_REGION.ops_region1 }
into gd
select new HistoricalTrendRow
{
ColumnCode = gd.Key.ops_region1,
CodeCount = gd.Count(),
Date = gd.Key.Date
};
break;
case DictionaryParameter.Location:
historicalTrendData = from v in vehicleHistories
group v by new { v.TimeStamp.Date, v.LOCATION.location1 }
into gd
select new HistoricalTrendRow
{
ColumnCode = gd.Key.location1,
CodeCount = gd.Count(),
Date = gd.Key.Date
};
break;
}
if (historicalTrendData == null)
{
return(new List <HistoricalTrendRow>());
}
var returned = historicalTrendData.ToList();
return(returned);
}