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