public DataTable GetTable(IMainFilterEntity mfe) { var hourlyColumns = _time == Enums.DayActualTime.THREE; var numberOfColumns = _time == Enums.DayActualTime.THIRTY ? 30 : MAXNOOFCOLUMNS; var topics = ReservationsDataAccess.CalculateTopics(hourlyColumns, numberOfColumns, mfe, false).ToDictionary(d => d.Tme); var dataTable = new DataTable(); var now = DateTime.Now.GetDateAndHourOnlyByCountry(mfe.Country); for (int i = 0; i < MAXNOOFCOLUMNS; i++) { dataTable.Columns.Add(hourlyColumns ? now.AddHours(i).ToString(CultureInfo.CurrentCulture) : now.AddDays(i).ToString(CultureInfo.CurrentCulture), typeof(string) ); } dataTable.Rows.Add(topics.Values.Select(d => d.Balance.ToString()).ToArray()); dataTable.Rows.Add(topics.Values.Select(d => d.Available.ToString()).ToArray()); dataTable.Rows.Add(topics.Values.Select(d => d.Opentrips.ToString()).ToArray()); dataTable.Rows.Add(topics.Values.Select(d => d.Reservations.ToString()).ToArray()); dataTable.Rows.Add(topics.Values.Select(d => d.OnewayRes.ToString()).ToArray()); dataTable.Rows.Add(topics.Values.Select(d => d.GoldServiceReservations.ToString()).ToArray()); dataTable.Rows.Add(topics.Values.Select(d => d.PrepaidReservations.ToString()).ToArray()); dataTable.Rows.Add(topics.Values.Select(d => d.Checkin.ToString()).ToArray()); dataTable.Rows.Add(topics.Values.Select(d => d.OnewayCheckin.ToString()).ToArray()); dataTable.Rows.Add(topics.Values.Select(d => d.Offset.ToString()).ToArray()); dataTable.Rows.Add(topics.Values.Select(d => d.LocalCheckIn.ToString()).ToArray()); dataTable.Rows.Add(topics.Values.Select(d => d.Buffer.ToString()).ToArray()); dataTable.Rows.Add(topics.Values.Select(d => d.AddditionDeletion.ToString()).ToArray()); _DataTable = dataTable; return(dataTable); }
//public void SetTable(IReservationDetailsEntity Entity) //{ // string rsArrivalTime = Entity.RS_ARRIVAL_TIME == null ? "" : Entity.RS_ARRIVAL_TIME.Value.ToShortTimeString(); // string rtrnTime = Entity.RTRN_TIME == null ? "" : Entity.RTRN_TIME.Value.ToShortTimeString(); // spanResId.InnerHtml = Entity.RES_ID_NBR; // tdResId.InnerHtml = Entity.RES_ID_NBR; // tdCheckOutLoc.InnerHtml = Entity.RENT_LOC; // tdCheckOutDate.InnerHtml = Entity.RS_ARRIVAL_DATE == null ? "" : Entity.RS_ARRIVAL_DATE.Value.ToShortDateString() + " " + rsArrivalTime; // tdResLoc.InnerHtml = Entity.RES_LOC; // tdCheckInLoc.InnerHtml = Entity.RTRN_LOC; // tdCheckInDate.InnerHtml = Entity.RTRN_DATE == null ? "" : Entity.RTRN_DATE.Value.ToShortDateString() + " " + rtrnTime; // tdDays.InnerHtml = Entity.RES_DAYS.ToString(); // tdGroup.InnerHtml = Entity.GR_INCL_GOLDUPGR; // tdGroupGold.InnerHtml = Entity.GR_INCL_GOLDUPGR; // tdCustomer.InnerHtml = Entity.CUST_NAME; // tdPhone.InnerHtml = Entity.PHONE; // tdCdp.InnerHtml = Entity.CDPID_NBR; // tdGoldNbr.InnerHtml = Entity.NO1_CLUB_GOLD; // tdGoldStatus.InnerHtml = Entity.GR_INCL_GOLDUPGR; // tdFltNbr.InnerHtml = Entity.FLIGHT_NBR; // tdTaco.InnerHtml = Entity.TACO; // tdNeverlost.InnerHtml = Entity.NEVERLOST; // tdPrepaid.InnerHtml = Entity.PREPAID; // tdResDate.InnerHtml = Entity.DATE_SOLD == null ? "" : Entity.DATE_SOLD.Value.ToShortDateString(); // tdRemarks.InnerHtml = Entity.REMARKS; // tdTariff.InnerHtml = Entity.RATE_QUOTED; // Visible = true; //} public void SetReservationTable(IReservationDetailsEntity Entity) { var goldGroupName = ReservationsDataAccess.LookupGoldLevel(Entity.RES_ID_NBR); string rsArrivalTime = Entity.RS_ARRIVAL_TIME == null ? "" : Entity.RS_ARRIVAL_TIME.Value.ToShortTimeString(); string rtrnTime = Entity.RTRN_TIME == null ? "" : Entity.RTRN_TIME.Value.ToShortTimeString(); lblResIDValue.Text = Entity.RES_ID_NBR; lblCheckOutValue.Text = Entity.RENT_LOC; lblCheckOutDateValue.Text = Entity.RS_ARRIVAL_DATE == null ? "" : Entity.RS_ARRIVAL_DATE.Value.ToShortDateString() + " " + rsArrivalTime; lblResLocValue.Text = Entity.RES_LOC; lblCheckInValue.Text = Entity.RTRN_LOC; lblCheckInDateValue.Text = Entity.RTRN_DATE == null ? "" : Entity.RTRN_DATE.Value.ToShortDateString() + " " + rtrnTime; lblDaysValue.Text = Entity.RES_DAYS.ToString(); lblGroupValue.Text = Entity.ReservedCarGroup; lblGroupGoldValue.Text = Entity.GR_INCL_GOLDUPGR; lblCustomerValue.Text = Entity.CUST_NAME; lblPhoneValue.Text = Entity.PHONE; lblCDPValue.Text = Entity.CDPID_NBR; lblGoldNumberValue.Text = Entity.NO1_CLUB_GOLD; lblGoldStatusValue.Text = goldGroupName; lblFlightNumberValue.Text = Entity.FLIGHT_NBR; lblTacoValue.Text = Entity.TACO; lblNeverLostValue.Text = Entity.NEVERLOST; lblPrepaidValue.Text = Entity.PREPAID; lblResDateValue.Text = Entity.DATE_SOLD == null ? "" : Entity.DATE_SOLD.Value.ToShortDateString(); lblRemarksValue.Text = Entity.REMARKS; lblTariffValue.Text = Entity.RATE_QUOTED; Visible = true; }
public void TestCalculateTopics() { var mfe = GetMainFilterExample(); var site = ReservationsDataAccess.CalculateTopics(true, 72, mfe, true, true); var fleet = ReservationsDataAccess.CalculateTopics(true, 72, mfe, true, false); var dayActuals = ReservationsDataAccess.CalculateTopics(true, 72, mfe, false); TestResultComparison.CheckAllPoolingValues(dayActuals, fleet, site); }
public void TestCalculateTopics() { var mfe = GetMainFilterExample(); var site = ReservationsDataAccess.CalculateTopics(true, 72, mfe, true, true); var fleet = ReservationsDataAccess.CalculateTopics(true, 72, mfe, true, false); var dayActuals = ReservationsDataAccess.CalculateTopics(true, 72, mfe, false); var ss = site.Where(d => d.Tme == 24); var ff = fleet.Where(d => d.Tme == 24); var ss2 = ss.Sum(d => d.Offset); var ff2 = ff.Sum(d => d.Offset); TestResultComparison.CheckAllPoolingValues(dayActuals, fleet, site); }
public void TestMethod2() { var mfe = new MainFilterEntity { Country = "United Kingdom", PoolRegion = "South England" , CmsLogic = true, LocationGrpArea = "HEATHROW" , CarSegment = "Car", CarClass = @"CompactMan", CarGroup = "C" }; //var ss = AlertsDataAccess.GetLocationCarGroupsWithNegativeBalance(mfe, DateTime.Now.AddDays(2).Date); var alertClasses = AlertsDataAccess.GetLocationCarGroups(mfe, DateTime.Now.AddDays(1).Date); //var dd = alertClasses.Where(d => d.Label.Substring(0,7) == "GEAAC60").ToList(); var actualsClasses = ReservationsDataAccess.CalculateTopics(true, 20, mfe, false, false); foreach (var ac in alertClasses) { var time = ac.Tme; var data = actualsClasses.FirstOrDefault(d => d.Tme == time); //var labelBits = ac.Label.Split(' '); if (data != null) { Assert.IsTrue(ac.Balance == data.Balance); } //var branch = labelBits[0]; // var carGroup = labelBits[1]; //var balance = ac.Balance; } Assert.IsTrue(true); }
public void TestCalculateTopics() { //var p = new List<string> // { // "GEBRA63", // "GEBRA91", // "GECLL61", // "GEESW60", // "GEGTT91", // "GEHAJ61", // "GEHAJ63", // "GEHAJ66", // "GEHDM60", // "GEKSL60", // "GEKSL90", // "GENOH61", // "GEPDB61", // "GESGR60", // "GEWER60", // "GEWUN60", // "GEGTN61" // }; var p = new List <string> { "GELEJ50", }; var mfe = GetMainFilterExample(); foreach (var s in p) { mfe.Branch = ""; var site = ReservationsDataAccess.CalculateTopics(true, 72, mfe, true, true); mfe.Branch = s; var fleet = ReservationsDataAccess.CalculateTopics(true, 72, mfe, true, false); var dayActuals = ReservationsDataAccess.CalculateTopics(true, 72, mfe, false); TestResultComparison.CheckAllPoolingValues(dayActuals, fleet, site, s); } }
public IList <String[]> GetList(Enums.DayActualTime tme) { var hourlyColumns = tme == Enums.DayActualTime.THREE; var returned = new List <String[]>(); var numberOfColumns = tme == Enums.DayActualTime.THIRTY ? 30 : (Int32)Enums.ThreeDayActuals.MAXNOOFCOLUMNS; var topicData = ReservationsDataAccess.CalculateTopics(hourlyColumns, numberOfColumns, Filter, true, false); int topicId = (from topic in _resTopics where topic.Name.Equals(Filter.Topic) select topic.Id).Single(); foreach (string lbl in topicData.Select(p => p.Label).Distinct()) { var s = new String[NoInArray]; s[0] = lbl; for (int i = 0; i < NoInArray - 1; i++) { var data = topicData.FirstOrDefault(d => d.Tme == i && d.Label == lbl); int val = 0; if (data != null) { switch (topicId) { case 1: val = data.Available; break; case 2: val = data.Opentrips; break; case 3: val = data.Reservations; break; case 4: val = data.OnewayRes; break; case 5: val = data.GoldServiceReservations; break; case 6: val = data.PrepaidReservations; break; //case 7: val = e3 == null ? 0 : e3.Predelivery; break; case 8: val = data.Checkin; break; case 9: val = data.OnewayCheckin; break; case 10: val = data.LocalCheckIn; break; case 11: val = data.Balance; break; case 12: val = data.JustAdditions; break; case 13: val = data.JustDeletions; break; } } s[i + 1] = val.ToString(CultureInfo.InvariantCulture); } returned.Add(s); } var totals = new string[NoInArray]; for (int i = 1; i < NoInArray; i++) { totals[i] = returned.Sum(p => Convert.ToDecimal(p.ElementAt(i))).ToString(); } totals[0] = "Totals"; returned.Add(totals); return(returned); }