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