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]); } var startDate = mergedParameters.GetDateFromDictionary(DictionaryParameter.StartDate); var endDate = mergedParameters.GetDateFromDictionary(DictionaryParameter.EndDate); var todaysData = startDate.Date == DateTime.Now.Date && endDate == DateTime.Now.Date; ucHistoricalTrendChart.HourlySeries = todaysData; ucHistoricalTrendGrid.HourlySeries = todaysData; using (var dataAccess = new HistoricalTrendDataAccess(mergedParameters)) { lblLastUpdate.Text = LastUpdatedFromFleetNow.GetLastUpdatedDateTime(dataAccess); fleetData = todaysData ? dataAccess.GetCurrentTrend() : dataAccess.GetHistoricalTrend(); } upnlUpdatedTime.Update(); ucHistoricalTrendChart.LoadChart(fleetData, type); ucHistoricalTrendGrid.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 TestMethod2() { var parameters = new Dictionary <DictionaryParameter, string>(); //parameters[DictionaryParameter.LocationCountry] = "GE"; parameters[DictionaryParameter.StartDate] = new DateTime(2014, 09, 20).ToShortDateString(); parameters[DictionaryParameter.EndDate] = new DateTime(2014, 09, 25).ToShortDateString(); using (var dataAccess = new HistoricalTrendDataAccess(parameters)) { var d = dataAccess.GetHistoricAgeRowData(); } Assert.IsTrue(true); }
public void CheckHistoricAgeRowData() { var parameters = new Dictionary <DictionaryParameter, string>(); parameters[DictionaryParameter.LocationCountry] = "GE"; parameters[DictionaryParameter.StartDate] = DateTime.Now.AddDays(-4).ToShortDateString(); parameters[DictionaryParameter.EndDate] = DateTime.Now.AddDays(-3).ToShortDateString(); parameters[DictionaryParameter.KciGrouping] = "True"; using (var dc = new HistoricalTrendDataAccess(parameters)) { var historicalData = dc.GetHistoricalTrendEntries(); } }
public void TestDays() { List <FleetStatusRow> fleetData; using (var dataAccess = new HistoricalTrendDataAccess(GetDayParameters())) { fleetData = dataAccess.GetHistoricalTrend(); } var dt = GetOldDayData(); fleetData = fleetData.OrderBy(d => d.Day).ToList(); Assert.AreNotEqual(dt.Rows.Count, 0, "No Data from old system"); foreach (DataRow row in dt.Rows) { var repDateOld = DateTime.Parse(row["REP_DATE"].ToString()); var newData = fleetData.FirstOrDefault(d => d.Day == repDateOld); if (newData == null) { continue; } var tfOld = int.Parse(row["TOTAL_FLEET"].ToString()); var tfNew = newData.TotalFleet; Assert.AreEqual(tfOld, tfNew); var orOld = int.Parse(row["ON_RENT"].ToString()); var orNew = newData.OnRent; Assert.AreEqual(orOld, orNew); var idleOld = int.Parse(row["RT"].ToString()); var idleNew = newData.Idle; Assert.AreEqual(idleOld, idleNew); } Assert.IsTrue(true); }