private DataTable GetOldDayData() { var fleetTypes = "RAC OPS"; // CARSALES, RAC TTL, RAC OPS, HERTZ ON DEMAND (Firefly), LICENSEE var dataTable = AvailabilityHistoricalTrend.GetHistoricalTrendData("GE", -1, -1, -1, -1, "-1", fleetTypes, -1, -1, -1, FromDate, ToDate, -1, "DAY", "NUMERIC", "-1"); return(dataTable); }
protected void GenerateReport() { //Set default values int logic = -1; string country = "-1"; int cms_pool_id = -1; string cms_pool = null; int cms_location_group_id = -1; string cms_location_group = null; int ops_region_id = -1; string ops_region = null; int ops_area_id = -1; string ops_area = null; int car_segment_id = -1; string car_segment = null; int car_class_id = -1; string car_class = null; int car_group_id = -1; string car_group = null; DateTime availabilityDate = DateTime.Now; int dayOfWeekValue = -1; string dayOfWeek = null; int dateRangeValue = -1; string dateRange = null; string location = "-1"; string fleetName = "-1"; //Pass values from usercontrol logic = this.UserControlReportSettings.Logic; country = this.UserControlReportSettings.Country; switch (logic) { case (int)ReportSettings.OptionLogic.CMS: cms_pool_id = this.UserControlReportSettings.CMS_Pool_Id; cms_pool = this.UserControlReportSettings.CMS_Pool; cms_location_group_id = this.UserControlReportSettings.CMS_Location_Group_Id; cms_location_group = this.UserControlReportSettings.CMS_Location_Group; break; case (int)ReportSettings.OptionLogic.OPS: ops_region_id = this.UserControlReportSettings.OPS_Region_Id; ops_region = this.UserControlReportSettings.OPS_Region; ops_area_id = this.UserControlReportSettings.OPS_Area_Id; ops_area = this.UserControlReportSettings.OPS_Area; break; } car_segment_id = this.UserControlReportSettings.Car_Segment_Id; car_segment = this.UserControlReportSettings.Car_Segment; car_class_id = this.UserControlReportSettings.Car_Class_Id; car_class = this.UserControlReportSettings.Car_Class; car_group_id = this.UserControlReportSettings.Car_Group_Id; car_group = this.UserControlReportSettings.Car_Group; location = this.UserControlReportSettings.Location; fleetName = this.UserControlReportSettings.Fleet_Name; availabilityDate = this.UserControlReportSettings.DateAvailability; dayOfWeekValue = this.UserControlReportSettings.DayOfWeekValue; dayOfWeek = this.UserControlReportSettings.DayOfWeek; DateTime startDate = DateTime.Now; if (UserControlReportSettings.DateRangeValue.Contains("Custom")) { startDate = UserControlReportSettings.customStartDate; availabilityDate = UserControlReportSettings.customEndDate; TimeSpan ts = startDate - availabilityDate; dateRangeValue = ts.Days; } else { dateRangeValue = Convert.ToInt32(this.UserControlReportSettings.DateRangeValue); dateRange = this.UserControlReportSettings.DateRange; if (dateRangeValue == -1) { startDate = availabilityDate.AddDays(dateRangeValue + 1); } else { startDate = availabilityDate.AddDays(dateRangeValue); } } string availabilityLogic = this.UserControlReportSettings.AvailabilityLogic; string grouping_criteria = ReportSettings.getRangeGroupingCriteria(dateRangeValue); var onRentType = UserControlReportSettings.OnRentTypeSelected; //Set Last Selection Value base.SaveLastSelectionToSession(logic, country, cms_pool_id, cms_location_group_id, ops_region_id, ops_area_id, location, car_segment_id, car_class_id, car_group_id); SessionHandler.OnRentTypeSelected = onRentType; //Load Data this.GenerateChart(AvailabilityHistoricalTrend.GetHistoricalTrendData(country, cms_pool_id, cms_location_group_id, ops_region_id, ops_area_id, location, fleetName, car_segment_id, car_class_id, car_group_id, startDate, availabilityDate, dayOfWeekValue, grouping_criteria, availabilityLogic, onRentType), dateRangeValue, availabilityLogic); //Set report Selection this.SetReportSelection(logic, country, cms_pool_id, cms_location_group_id, ops_region_id, ops_area_id, car_segment_id, car_class_id, car_group_id, location, startDate, dayOfWeekValue, dateRangeValue); //Log Usage Statistics base.LogUsageStatistics((int)ReportStatistics.ReportName.AvailabilityHistoricalTrend, country, cms_pool_id, cms_location_group_id, ops_region_id, ops_area_id, location); this.UpdatePanelHistoricalTrend.Update(); }