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