private void FlightConnectionForm_Load(object sender, EventArgs e) { #region populate combobox travel agency SAPRefTravelAgencyReadWrite travelAgency = new SAPRefTravelAgencyReadWrite(Config._dbConnectionName); SAPDataSetRefTravelAgency.RefTravelAgencyDataTable dt = travelAgency.SelectAll().RefTravelAgency; comboBoxTravelAgency.DataSource = dt; comboBoxTravelAgency.DisplayMember = SAPRefTravelAgencyReadWrite._agencyNameColumnName; comboBoxTravelAgency.ValueMember = SAPRefTravelAgencyReadWrite._agencyNumberColumnName; comboBoxTravelAgency.SelectedValue = "00000110"; //Bavarian Castle #endregion #region populate combobox carrier SAPRefCarrierReadWrite carrier = new SAPRefCarrierReadWrite(Config._dbConnectionName); SAPDataSetRefCarrier.RefCarrierDataTable dtCarrier = carrier.SelectAll().RefCarrier; SAPDataSetRefCarrier.RefCarrierRow rowCarrier = dtCarrier.NewRefCarrierRow(); rowCarrier.CarrID = string.Empty; rowCarrier.CarrName = string.Empty; rowCarrier.CurrCode = string.Empty; dtCarrier.Rows.InsertAt(rowCarrier, 0); comboBoxAirline.DataSource = dtCarrier; comboBoxAirline.DisplayMember = SAPRefCarrierReadWrite._carrNameColumnName; comboBoxAirline.ValueMember = SAPRefCarrierReadWrite._carrIDColumnName; #endregion #region populate city SAPRefFlightCityReadWrite flightCity = new SAPRefFlightCityReadWrite(Config._dbConnectionName); //SAPDataSetRefFlightCity.RefFlightCityDataTable dtFlightCityFrom = // flightCity.SelectAll().RefFlightCity; SAPDataSetRefFlightCity.RefFlightCityDataTable dtFlightCityTo = flightCity.SelectAll().RefFlightCity; //(SAPDataSetRefFlightCity.RefFlightCityDataTable)dtFlightCityFrom.Copy(); //comboBoxFrom.DataSource = dtFlightCityFrom; //comboBoxFrom.DisplayMember = SAPRefFlightCityReadWrite._cityNameColumnName; comboBoxTo.DataSource = dtFlightCityTo; comboBoxTo.DisplayMember = SAPRefFlightCityReadWrite._cityNameColumnName; comboBoxTo.Text = _flightCityTo; //comboBoxFrom.Text = _flightCityFrom; textBoxCity.Text = _flightCityFrom; #endregion }
private void PackageListControl_Load(object sender, EventArgs e) { SAPRefTravelAgencyReadWrite agency = new SAPRefTravelAgencyReadWrite(Config._dbConnectionName); SAPDataSetRefTravelAgency.RefTravelAgencyDataTable agencyData = agency.SelectAll().RefTravelAgency; SAPDataSetRefTravelAgency.RefTravelAgencyRow agencyRow = agencyData.NewRefTravelAgencyRow(); agencyRow.AgencyNumber = "0"; agencyRow.AgencyName = "All"; agencyData.Rows.InsertAt(agencyRow, 0); comboBoxAgency.DisplayMember = SAPRefTravelAgencyReadWrite._agencyNameColumnName; comboBoxAgency.ValueMember = SAPRefTravelAgencyReadWrite._agencyNumberColumnName; comboBoxAgency.DataSource = agencyData; comboBoxAgency.SelectedValue = "00000110"; //Bavarian Castle RefreshData(comboBoxAgency.SelectedValue.ToString()); }
private void buttonTicket_Click(object sender, RibbonControlEventArgs e) { PseudoProgressForm progress = new PseudoProgressForm(); progress.ProgressLabel = "Querying SAP..."; BackgroundWorker backgroundWorker = new BackgroundWorker(); TicketSales ticketDataset = new TicketSales(); backgroundWorker.DoWork += delegate(object workSender, DoWorkEventArgs eventArg) { TicketSales.TicketSaleDataTable ticketSaleDataTable = ticketDataset.TicketSale; SAPEventAttendeeAgencyMapReadWrite attendeeAgency = new SAPEventAttendeeAgencyMapReadWrite(Config._dbConnectionName); SAPRefTravelAgencyReadWrite travelAgency = new SAPRefTravelAgencyReadWrite(Config._dbConnectionName); //get all agencies where client booked flights to Dictionary <string, string> agencyList = new Dictionary <string, string>(); using (SAPDataReaderEventAttendeeAgencyMap reader = attendeeAgency.ReaderSelectAll()) { if (reader.DataReader.HasRows) { while (reader.DataReader.Read()) { if (!agencyList.ContainsKey(reader.AgencyNumber)) { string agencyName = string.Empty; using (SAPDataReaderRefTravelAgency travelReader = travelAgency.ReaderSelectByAgencyNumber(reader.AgencyNumber)) { travelReader.DataReader.Read(); agencyName = travelReader.AgencyName; } agencyList.Add( reader.AgencyNumber, agencyName); } } } } SAPFlightTrip flightTripHelper = new SAPFlightTrip(Config.SAPUserName, Config.SAPPassword); SAPFlightConnection flightConnectionHelper = new SAPFlightConnection(Config.SAPUserName, Config.SAPPassword); foreach (KeyValuePair <string, string> agency in agencyList) { TicketSales.TicketSaleRow ticketSaleRow = ticketSaleDataTable.NewTicketSaleRow(); ticketSaleRow.AgencyName = agency.Value; ticketSaleRow.TicketsSold = 0; ticketSaleRow.TotalTicketPrice = 0; flightTripHelper.GetList(string.Empty, agency.Key); foreach (SAPServices.SAP_FLIGHTTRIPLIST.BAPISTRDAT flightTrip in flightTripHelper._bapiFlightTripList) { flightConnectionHelper.GetDetail( flightTrip.FLCONN1, flightTrip.FLDATE1, string.Empty, flightTrip.AGENCYNUM); ticketSaleRow.TicketsSold += 1; ticketSaleRow.TotalTicketPrice += flightConnectionHelper._bapiPrice.PRICE_BUS1; } ticketSaleDataTable.AddTicketSaleRow(ticketSaleRow); } }; backgroundWorker.RunWorkerCompleted += delegate(object workSender, RunWorkerCompletedEventArgs eventArg) { progress.Close(); progress.Dispose(); ExcelHelper.LoadExcelSheet( "TicketSalesDistribution", Resources.TicketSalesDistribution, ticketDataset); }; backgroundWorker.RunWorkerAsync(); progress.ShowDialog(); }