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