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); }
private void RefreshData() { FleetStatusRow fleetData; var mergedParameters = generalParams.GetParameterDictionary(); var startDate = mergedParameters.GetDateFromDictionary(DictionaryParameter.StartDate); var endDate = mergedParameters.GetDateFromDictionary(DictionaryParameter.EndDate); var todaysData = startDate.Date == DateTime.Now.Date && endDate == DateTime.Now.Date; using (var dataAccess = new FleetStatusDataAccess(mergedParameters)) { lblLastUpdate.Text = LastUpdatedFromFleetNow.GetLastUpdatedDateTime(dataAccess); fleetData = dataAccess.GetFleetStatus(); } upnlUpdatedTime.Update(); ucFleetStatusChart.LoadChart(fleetData); ucFleetStatusChart.TodaysData = todaysData; ucFleetStatusGrid.LoadGrid(fleetData, mergedParameters); }
private void PopulateGridParameters(Dictionary <DictionaryParameter, string> parameters) { var locationCountry = AllString; var poolRegion = AllString; var locationArea = AllString; var location = AllString; var owningCountry = AllString; var carSegment = AllString; var carClass = AllString; var carGroup = AllString; var fleetTypes = string.Empty; var dateRange = string.Empty; using (var dataAccess = new FleetStatusDataAccess(parameters)) { if (parameters.ContainsValueAndIsntEmpty(DictionaryParameter.LocationCountry)) { locationCountry = dataAccess.GetCountryFromId(parameters[DictionaryParameter.LocationCountry]); } if (parameters.ContainsValueAndIsntEmpty(DictionaryParameter.Pool)) { int poolId = int.Parse(parameters[DictionaryParameter.Pool]); poolRegion = dataAccess.GetPoolFromId(poolId); } else { if (parameters.ContainsValueAndIsntEmpty(DictionaryParameter.Region)) { int regionId = int.Parse(parameters[DictionaryParameter.Region]); poolRegion = dataAccess.GetRegionFromId(regionId); } } if (parameters.ContainsValueAndIsntEmpty(DictionaryParameter.LocationGroup)) { int locationGroupId = int.Parse(parameters[DictionaryParameter.LocationGroup]); locationArea = dataAccess.GetLocationGroupFromId(locationGroupId); } else { if (parameters.ContainsValueAndIsntEmpty(DictionaryParameter.Area)) { int areaId = int.Parse(parameters[DictionaryParameter.Area]); locationArea = dataAccess.GetAreaFromId(areaId); } } if (parameters.ContainsValueAndIsntEmpty(DictionaryParameter.Location)) { int locationId = int.Parse(parameters[DictionaryParameter.Location]); location = dataAccess.GetLocationFromId(locationId); } if (parameters.ContainsValueAndIsntEmpty(DictionaryParameter.OwningCountry)) { owningCountry = dataAccess.GetCountryFromId(parameters[DictionaryParameter.OwningCountry]); } if (parameters.ContainsValueAndIsntEmpty(DictionaryParameter.CarSegment)) { int carSegmentId = int.Parse(parameters[DictionaryParameter.CarSegment]); carSegment = dataAccess.GetCarSegmentFromId(carSegmentId); } if (parameters.ContainsValueAndIsntEmpty(DictionaryParameter.CarClass)) { int carClassId = int.Parse(parameters[DictionaryParameter.CarClass]); carClass = dataAccess.GetCarClassFromId(carClassId); } if (parameters.ContainsValueAndIsntEmpty(DictionaryParameter.CarGroup)) { int carGroupId = int.Parse(parameters[DictionaryParameter.CarGroup]); carGroup = dataAccess.GetCarGroupFromId(carGroupId); } if (parameters.ContainsValueAndIsntEmpty(DictionaryParameter.FleetTypes)) { var fleetTypeIds = parameters[DictionaryParameter.FleetTypes].Split(','); var fleetTypeIdsHolder = new List <int>(); fleetTypeIds.ForEach(d => fleetTypeIdsHolder.Add(int.Parse(d))); fleetTypes = string.Join(", ", dataAccess.GetFleetTypenamesFromIds(fleetTypeIdsHolder)); } } if (parameters[DictionaryParameter.StartDate] == DateTime.Now.ToShortDateString() || parameters[DictionaryParameter.DayOfWeek] == "0" || parameters[DictionaryParameter.DayOfWeek] == string.Empty) { lblDayOfWeek.Text = AllString; } else { lblDayOfWeek.Text = Enum.Parse(typeof(DayOfWeek), parameters[DictionaryParameter.DayOfWeek]).ToString(); } lblDate.Text = string.Format("From {0} to {1}", parameters[DictionaryParameter.StartDate], parameters[DictionaryParameter.EndDate]); lblValues.Text = parameters[DictionaryParameter.AvailabilityKeyGrouping]; lblDisplay.Text = parameters[DictionaryParameter.AvailabilityDayGrouping]; lblLocationCountry.Text = locationCountry; lblPoolRegion.Text = poolRegion; lblLocationGroupArea.Text = locationArea; lblLocation.Text = location; lblOwningCountry.Text = owningCountry; lblCarSegment.Text = carSegment; lblCarClass.Text = carClass; lblCarGroup.Text = carGroup; lblFleetTypes.Text = fleetTypes; }