private void buttonPackageSales_Click(object sender, RibbonControlEventArgs e)
{
PseudoProgressForm progress = new PseudoProgressForm();
progress.ProgressLabel = "Querying SAP...";
BackgroundWorker backgroundWorker = new BackgroundWorker();
PackageSales packageSalesDataset = new PackageSales();
backgroundWorker.DoWork +=
delegate(object workSender, DoWorkEventArgs eventArg)
{
PackageSales.PackageSaleDataTable packageSalesTable =
packageSalesDataset.PackageSale;
Sales sales = DataHelper.GetSalesData();
foreach (Sales.PackageRow packageRow in sales.Package.Rows)
{
PackageSales.PackageSaleRow packageSaleRow = packageSalesTable.NewPackageSaleRow();
packageSaleRow.PackageName = packageRow.PackageName;
packageSaleRow.NumberOfSales = 0;
packageSaleRow.PriceOfSales = 0;
foreach (DataRow row in packageRow.GetChildRows("Package_PackageSale"))
{
Sales.PackageSaleRow salesPackageSaleRow = row as Sales.PackageSaleRow;
packageSaleRow.NumberOfSales += 1;
packageSaleRow.PriceOfSales += salesPackageSaleRow.Price;
}
packageSalesTable.AddPackageSaleRow(packageSaleRow);
}
};
backgroundWorker.RunWorkerCompleted +=
delegate(object workSender, RunWorkerCompletedEventArgs eventArg)
{
progress.Close();
progress.Dispose();
ExcelHelper.LoadExcelSheet(
"PackageSalesDistribution",
Resources.PackageSalesDistribution,
packageSalesDataset);
};
backgroundWorker.RunWorkerAsync();
progress.ShowDialog();
}
private void BookEvent_Load(object sender, EventArgs e)
{
#region populate combobox country
SAPRefCountryReadWrite country =
new SAPRefCountryReadWrite(Config._dbConnectionName);
comboBoxCountry.DataSource = country.SelectAll().RefCountry;
comboBoxCountry.DisplayMember = SAPRefCountryReadWrite._countryNameColumnName;
comboBoxCountry.ValueMember = SAPRefCountryReadWrite._countryCodeColumnName;
#endregion
#region populate combobox language
SAPRefLanguageReadWrite language =
new SAPRefLanguageReadWrite(Config._dbConnectionName);
comboBoxLanguage.DataSource = language.SelectAll().RefLanguage;
comboBoxLanguage.DisplayMember = SAPRefLanguageReadWrite._languageColumnName;
comboBoxLanguage.ValueMember = SAPRefLanguageReadWrite._languageCodeColumnName;
#endregion
#region create grid
SAPPackageEventReadOnly packageEvent =
new SAPPackageEventReadOnly(Config._dbConnectionName);
dtEventFlight = new DataTable();
dtEventFlight.Columns.Add("EventName", typeof(string));
dtEventFlight.Columns.Add("EventVenue", typeof(string));
dtEventFlight.Columns.Add("EventDate", typeof(DateTime));
dtEventFlight.Columns.Add("FlightDate", typeof(string));
dtEventFlight.Columns.Add("FlightTime", typeof(string));
dtEventFlight.Columns.Add("FlightAirport", typeof(string));
dtEventFlight.Columns.Add("FlightConnection", typeof(string));
dtEventFlight.Columns.Add("FlightAgency", typeof(string));
dtEventFlight.Columns.Add("VenueCity", typeof(string));
dtEventFlight.Columns.Add("EventID", typeof(int));
using (SAPDataReaderPackageEvent rdrEvent =
packageEvent.ReaderSelectByPackageID(_packageID))
{
if (rdrEvent.DataReader != null &&
rdrEvent.DataReader.HasRows)
{
while (rdrEvent.DataReader.Read())
{
dtEventFlight.Rows.Add(
rdrEvent.EventName,
rdrEvent.VenueName,
rdrEvent.EventDate,
string.Empty,
string.Empty,
string.Empty,
string.Empty,
string.Empty,
rdrEvent.VenueCity,
rdrEvent.EventID);
} //while (rdrEvent.DataReader.Read());
}
}
dataGridViewEvent.DataSource = dtEventFlight;
GridHelper.HideColumns(
dataGridViewEvent,
"FlightConnection",
"FlightAgency",
"VenueCity",
"EventID");
#endregion
#region get customer from SAP
dtCustomer = new DataTable();
dtCustomer.Columns.Add("customername", typeof(string));
dtCustomer.Columns.Add("customerid", typeof(string));
PseudoProgressForm progress = new PseudoProgressForm();
progress.ProgressLabel = "Querying SAP...";
BackgroundWorker bgWorker = new BackgroundWorker();
addCustomerItem = new AddCustomerItem(AddCustomer);
bgWorker.DoWork +=
delegate(object senderWorker, DoWorkEventArgs eWorker)
{
SAPCustomer sapCustomer = new SAPCustomer(Config.SAPUserName, Config.SAPPassword);
if (sapCustomer.GetList() && sapCustomer._customerList.Length > 0)
{
//customerList = sapCustomer._customerList;
customerList = new SortedList <string, BAPISCUDAT>();
foreach (BAPISCUDAT item in
sapCustomer._customerList)
{
if (!customerList.ContainsKey(item.CUSTOMERID))
{
customerList.Add(item.CUSTOMERID, item);
dtCustomer.Rows.Add(item.CUSTNAME, item.CUSTOMERID);
}
}
}
};
bgWorker.RunWorkerCompleted +=
delegate(object senderWorker, RunWorkerCompletedEventArgs eWorker)
{
progress.Close();
progress.Dispose();
};
bgWorker.RunWorkerAsync();
progress.ShowDialog();
dtCustomer.DefaultView.Sort = "customername";
comboBoxCustomername.DataSource = dtCustomer.DefaultView;
comboBoxCustomername.DisplayMember = "customername";
comboBoxCustomername.ValueMember = "customerid";
comboBoxCustomername.Text = string.Empty;
#endregion
}
private void buttonSearch_Click(object sender, EventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
listViewFlight.Items.Clear();
addListItem = new AddListItem(AddListItemMethod);
SAPFlightConnection _flightConnection = new SAPFlightConnection(Config.SAPUserName, Config.SAPPassword);
string airlineID = string.Empty;
string travelAgency = string.Empty;
if (comboBoxAirline.SelectedIndex > -1)
{
airlineID = (string)comboBoxAirline.SelectedValue;
}
if (comboBoxTravelAgency.SelectedIndex > -1)
{
travelAgency = (string)comboBoxTravelAgency.SelectedValue;
}
PseudoProgressForm progress = new PseudoProgressForm();
progress.ProgressLabel = "Querying SAP...";
BackgroundWorker bgWorker = new BackgroundWorker();
string destinationTo = comboBoxTo.Text;
string destinationFrom = textBoxCity.Text;
bgWorker.DoWork +=
delegate(object senderWorker, DoWorkEventArgs eWorker)
{
if (_flightConnection.GetList(
airlineID,
travelAgency,
destinationFrom,
destinationTo))
{
_flConn = _flightConnection._bapiConnectionList;
_connectionList = new List <FlightConnectionList>();
foreach (BAPISCODAT item
in _flConn)
{
Invoke(addListItem, item);
}
}
};
bgWorker.RunWorkerCompleted +=
delegate(object senderWorker, RunWorkerCompletedEventArgs eWorker)
{
progress.Close();
progress.Dispose();
if (listViewFlight.Items.Count == 0)
{
Message.DisplayMessage("No records found.");
}
};
bgWorker.RunWorkerAsync();
progress.ShowDialog();
}
catch (Exception ex)
{
ErrorForm errorForm =
new ErrorForm(ex.Message, ex.ToString());
errorForm.ShowDialog(this);
errorForm.Close();
}
finally
{
Cursor = Cursors.Default;
}
}
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();
}
private void buttonPackageType_Click(object sender, RibbonControlEventArgs e)
{
PseudoProgressForm progress = new PseudoProgressForm();
progress.ProgressLabel = "Querying SAP...";
BackgroundWorker backgroundWorker = new BackgroundWorker();
PackagePerPromoType packageSalesPerTypeDataset =
new PackagePerPromoType();
backgroundWorker.DoWork +=
delegate(object workSender, DoWorkEventArgs eventArg)
{
PackagePerPromoType.PackageDataTable packageSalesTable =
packageSalesPerTypeDataset.Package;
Sales sales = DataHelper.GetSalesData();
foreach (Sales.PackageRow packageRow in sales.Package.Rows)
{
PackagePerPromoType.PackageRow packageSaleRow = packageSalesTable.NewPackageRow();
packageSaleRow.PackageID = packageRow.PackageID;
packageSaleRow.PackageName = packageRow.PackageName;
packageSaleRow.GoldPackageCount = 0;
packageSaleRow.SilverPackageCount = 0;
packageSaleRow.BronzePackageCount = 0;
packageSaleRow.GoldPackageTotalSales = 0;
packageSaleRow.SilverPackageTotalSales = 0;
packageSaleRow.BronzePackageTotalSales = 0;
foreach (DataRow saleRow in packageRow.GetChildRows("Package_PackageSale"))
{
Sales.PackageSaleRow salesPackageSaleRow = saleRow as Sales.PackageSaleRow;
foreach (DataRow eventRow in salesPackageSaleRow.GetChildRows("PackageSale_EventSale"))
{
Sales.EventSaleRow salesEventSaleRow = eventRow as Sales.EventSaleRow;
switch (salesEventSaleRow.PackageType)
{
case "Gold":
packageSaleRow.GoldPackageCount += 1;
packageSaleRow.GoldPackageTotalSales += salesEventSaleRow.Price;
break;
case "Silver":
packageSaleRow.SilverPackageCount += 1;
packageSaleRow.SilverPackageTotalSales += salesEventSaleRow.Price;
break;
case "Bronze":
packageSaleRow.BronzePackageCount += 1;
packageSaleRow.BronzePackageTotalSales += salesEventSaleRow.Price;
break;
}
}
}
packageSalesTable.AddPackageRow(packageSaleRow);
}
};
backgroundWorker.RunWorkerCompleted +=
delegate(object workSender, RunWorkerCompletedEventArgs eventArg)
{
progress.Close();
progress.Dispose();
ExcelHelper.LoadExcelSheet(
"PackageSalesPerPromoType",
Resources.PackageSalesPerPromoType,
packageSalesPerTypeDataset);
};
backgroundWorker.RunWorkerAsync();
progress.ShowDialog();
}
private void buttonRevenueForecast_Click(object sender, RibbonControlEventArgs e)
{
SelectYearForm selectYearForm = new SelectYearForm();
selectYearForm.ShowDialog();
int year = selectYearForm.SelectedYear;
selectYearForm.Dispose();
if (year == 0)
{
return;
}
PseudoProgressForm progress = new PseudoProgressForm();
progress.ProgressLabel = "Querying SAP...";
BackgroundWorker backgroundWorker = new BackgroundWorker();
PackagesRevenue revenueDataset = new PackagesRevenue();
backgroundWorker.DoWork +=
delegate(object workSender, DoWorkEventArgs eventArg)
{
PackagesRevenue.PackageRevenueDataTable revenueTable =
revenueDataset.PackageRevenue;
Dictionary <string, ArrayList> allSales =
new Dictionary <string, ArrayList>();
allSales.Add("Gold", new ArrayList());
allSales.Add("Silver", new ArrayList());
allSales.Add("Bronze", new ArrayList());
allSales["Gold"].Add("Gold");
allSales["Silver"].Add("Silver");
allSales["Bronze"].Add("Bronze");
Sales[] aSales = new Sales[12];
for (int month = 0; month < aSales.Length; month++)
{
aSales[month] = DataHelper.GetSalesData(month + 1, year);
allSales["Gold"].Add(0);
allSales["Silver"].Add(0);
allSales["Bronze"].Add(0);
foreach (Sales.EventSaleRow eventSaleRow in aSales[month].EventSale.Rows)
{
allSales[eventSaleRow.PackageType][month + 1] =
Convert.ToDecimal(allSales[eventSaleRow.PackageType][month + 1]) +
(eventSaleRow.Price - eventSaleRow.Cost);
}
}
allSales["Gold"].Add(year);
allSales["Silver"].Add(year);
allSales["Bronze"].Add(year);
revenueTable.LoadDataRow(allSales["Gold"].ToArray(), true);
revenueTable.LoadDataRow(allSales["Silver"].ToArray(), true);
revenueTable.LoadDataRow(allSales["Bronze"].ToArray(), true);
};
backgroundWorker.RunWorkerCompleted +=
delegate(object workSender, RunWorkerCompletedEventArgs eventArg)
{
progress.Close();
progress.Dispose();
ExcelHelper.LoadExcelSheet(
"RevenueForecast",
Resources.RevenueForecast,
revenueDataset);
};
backgroundWorker.RunWorkerAsync();
progress.ShowDialog();
}
