public void CompareAllHistoryReports() { var parameters = new Dictionary <DictionaryParameter, string>(); parameters[DictionaryParameter.LocationCountry] = "GE"; parameters[DictionaryParameter.StartDate] = DateTime.Now.AddDays(0).ToShortDateString(); parameters[DictionaryParameter.KciGrouping] = "True"; List <ComparisonRow> ageingData; List <ComparisonRow> siteCompData; List <ComparisonRow> fleetCompData; using (var dc = new ComparisonDataAccess(parameters)) { fleetCompData = dc.GetComparisonEntries(false); siteCompData = dc.GetComparisonEntries(true); ageingData = dc.GetComparisonByStatusEntries(); } var totalAgeing = ageingData.First(d => d.Key == NonRevBaseDataAccess.TotalKeyName).FleetCount; var totalSiteComp = siteCompData.First(d => d.Key == NonRevBaseDataAccess.TotalKeyName).FleetCount; var totalFleetComp = fleetCompData.First(d => d.Key == NonRevBaseDataAccess.TotalKeyName).FleetCount; Assert.IsTrue(totalAgeing == totalSiteComp); Assert.IsTrue(totalAgeing == totalFleetComp); }
private void RefreshData() { List <FleetStatusRow> fleetData; var mergedParameters = generalParams.GetParameterDictionary(); var type = PercentageDivisorType.Values; if (mergedParameters.ContainsKey(DictionaryParameter.PercentageCalculation) && mergedParameters[DictionaryParameter.PercentageCalculation] != string.Empty) { type = (PercentageDivisorType)Enum.Parse(typeof(PercentageDivisorType), mergedParameters[DictionaryParameter.PercentageCalculation]); } using (var dataAccess = new ComparisonDataAccess(mergedParameters)) { lblLastUpdate.Text = LastUpdatedFromFleetNow.GetLastUpdatedDateTime(dataAccess); fleetData = dataAccess.GetComparisonData(true); } upnlUpdatedTime.Update(); fleetData = fleetData.OrderBy(d => d.Key).ToList(); ucComparisonChart.LoadChart(fleetData, type); ucComparisonTrendGrid.LoadGrid(fleetData, type); }
public void CheckFigures() { //Arrange var parameters = new Dictionary <DictionaryParameter, string> { { DictionaryParameter.OwningCountry, "GE" } , { DictionaryParameter.LocationCountry, "GE" } , { DictionaryParameter.Pool, "71" } , { DictionaryParameter.LocationGroup, string.Empty } , { DictionaryParameter.Region, string.Empty } , { DictionaryParameter.Area, string.Empty } , { DictionaryParameter.Location, string.Empty } , { DictionaryParameter.CarSegment, string.Empty } , { DictionaryParameter.CarClass, string.Empty } , { DictionaryParameter.CarGroup, string.Empty } , { DictionaryParameter.CmsSelected, true.ToString() } }; var daySelected = DateTime.Now.ToShortDateString(); parameters.Add(DictionaryParameter.StartDate, daySelected); parameters.Add(DictionaryParameter.EndDate, daySelected); parameters.Add(DictionaryParameter.FleetTypes, "4,5,6"); FleetStatusRow fleetData; List <FleetStatusRow> siteComparisonData; List <FleetStatusRow> fleetComparisonData; List <FleetStatusRow> historicalTrendData; //Act using (var dataAccess = new FleetStatusDataAccess(parameters)) { fleetData = dataAccess.GetFleetStatus(); } using (var dataAccess = new ComparisonDataAccess(parameters)) { siteComparisonData = dataAccess.GetComparisonData(true); fleetComparisonData = dataAccess.GetComparisonData(false); } using (var dataAccess = new HistoricalTrendDataAccess(parameters)) { historicalTrendData = dataAccess.GetCurrentTrend(); } //Assert var totalSite = siteComparisonData.Sum(s => s.TotalFleet); var totalFleet = fleetComparisonData.Sum(s => s.TotalFleet); var totalTrendFleet = historicalTrendData.Last().TotalFleet; Assert.IsTrue(fleetData.TotalFleet == totalSite); Assert.IsTrue(fleetData.TotalFleet == totalFleet); Assert.IsTrue(fleetData.TotalFleet == totalTrendFleet); }
public void CheckNonRevComparison() { var parameters = new Dictionary <DictionaryParameter, string>(); parameters[DictionaryParameter.LocationCountry] = "GE"; parameters[DictionaryParameter.StartDate] = DateTime.Now.AddDays(-4).ToShortDateString(); parameters[DictionaryParameter.EndDate] = DateTime.Now.ToShortDateString(); parameters[DictionaryParameter.DayOfWeek] = DayOfWeek.Friday.ToString(); using (var dc = new ComparisonDataAccess(parameters)) { var data = dc.GetComparisonEntries(); } Assert.IsTrue(true); }
private IEnumerable <LocationSummaryRow> GetAvailabilitySummaryData(Dictionary <DictionaryParameter, string> parameters) { var fleetStatusDataAccess = new ComparisonDataAccess(parameters, DataContext); var vehicles = BaseVehicleDataAccess.GetVehicleQueryable(parameters, DataContext, true, true); var carClassGroupedData = GroupByCarClass(vehicles); var extractedData = fleetStatusDataAccess.ExtractVehicleColumns(carClassGroupedData); var availabilityRows = BuildLocationSummaryAvailabilityRows(extractedData); return(availabilityRows); }
private IEnumerable <LocationSummaryForeignRow> GetForeignVehicleSummaryData(Dictionary <DictionaryParameter, string> parameters) { var fleetStatusDataAccess = new ComparisonDataAccess(parameters, DataContext); var vehicles = BaseVehicleDataAccess.GetVehicleQueryable(parameters, DataContext, true, true); vehicles = from v in vehicles where v.LastLocationCode.Substring(0, 2) != v.OwningCountry select v; var carClassGroupedData = GroupByCarSegmentName(vehicles); var extractedData = fleetStatusDataAccess.ExtractVehicleColumns(carClassGroupedData); var availabilityRows = BuildLocationSummaryForeignRows(extractedData); return(availabilityRows); }