private void VenueForm_Load(object sender, EventArgs e)
{
#region create grid
SAPEventReadWrite eventRW =
new SAPEventReadWrite(Config._dbConnectionName);
SAPVenueReadWrite venueRW =
new SAPVenueReadWrite(Config._dbConnectionName);
_dtVenue = new DataTable();
//_dtVenue.Columns.Add("EditIco", typeof(byte[]));
//_dtVenue.Columns.Add("DelIco", typeof(byte[]));
_dtVenue.Columns.Add("VenueID", typeof(int));
_dtVenue.Columns.Add("VenueName", typeof(string));
_dtVenue.Columns.Add("VenueDescription", typeof(string));
_dtVenue.Columns.Add("VenueStreet", typeof(string));
_dtVenue.Columns.Add("VenueCity", typeof(string));
_dtVenue.Columns.Add("VenueState", typeof(string));
_dtVenue.Columns.Add("VenuePostalCode", typeof(string));
_dtVenue.Columns.Add("VenueGeographicMap", typeof(byte[]));
_dtVenue.Columns.Add("VenueFacilityMap", typeof(byte[]));
_dtVenue.Columns.Add("VenueImage", typeof(byte[]));
_dtVenue.Columns.Add("EditTag", typeof(bool));
_dtVenue.Columns.Add("DelTag", typeof(bool));
//byte[] editIco = UtilityHelper.BitmapToByte(Resources.icoedit);
//byte[] delIco = UtilityHelper.BitmapToByte(Resources.icodelete);
//byte[] editDisableIco = UtilityHelper.BitmapToByte(Resources.icoedit_disabled);
//byte[] delDisableIco = UtilityHelper.BitmapToByte(Resources.icodelete_disabled);
bool editAble = false;
bool delAble = false;
List <int> usedVenue = new List <int>();
using (SAPDataReaderEvent rdrEvent =
eventRW.ReaderSelectAll())
{
if (rdrEvent.DataReader != null &&
rdrEvent.DataReader.HasRows)
{
while (rdrEvent.DataReader.Read())
{
usedVenue.Add(rdrEvent.VenueID);
} //while (rdrEvent.DataReader.Read());
}
}
using (SAPDataReaderVenue rdrVenue =
venueRW.ReaderSelectAll())
{
if (rdrVenue.DataReader != null &&
rdrVenue.DataReader.HasRows)
{
while (rdrVenue.DataReader.Read())
{
//byte[] editImage = editIco;
//byte[] delImage = delIco;
bool tag = usedVenue.Contains(rdrVenue.VenueID);
delAble = !tag;
editAble = !tag;
_dtVenue.Rows.Add(
//editImage,
//delImage,
rdrVenue.VenueID,
rdrVenue.VenueName,
rdrVenue.VenueDescription,
rdrVenue.VenueStreet,
rdrVenue.VenueCity,
rdrVenue.VenueState,
rdrVenue.VenuePostalCode,
rdrVenue.VenueGeographicMap,
rdrVenue.VenueFacilityMap,
rdrVenue.VenueImage,
editAble,
delAble);
} //while (rdrVenue.DataReader.Read());
}
}
dataGridViewVenue.DataSource = _dtVenue;
#endregion
#region utilize grid
GridHelper.HideColumns(
dataGridViewVenue,
SAPVenueReadWrite._venueIDColumnName,
SAPVenueReadWrite._venueDescriptionColumnName,
SAPVenueReadWrite._venueGeographicMapColumnName,
SAPVenueReadWrite._venueFacilityMapColumnName,
SAPVenueReadWrite._venueImageColumnName,
"EditTag",
"DelTag");
string[] columns = new string[]
{
//"EditIco",
//"DelIco",
SAPVenueReadWrite._venueNameColumnName,
SAPVenueReadWrite._venueStreetColumnName,
SAPVenueReadWrite._venueCityColumnName,
SAPVenueReadWrite._venueStateColumnName,
SAPVenueReadWrite._venuePostalCodeColumnName
};
string[] titles = new string[]
{
//"",
//"",
"Venue",
"Street",
"City",
"State",
"Postal Code"
};
int[] gridWidth = new int[]
{
//20,
//20,
200,
100,
100,
100,
100
};
GridHelper.SetColumnTitle(
dataGridViewVenue,
columns,
titles);
GridHelper.SetWidthColumn(
dataGridViewVenue,
columns,
gridWidth);
#endregion
mode = EnumFormMode.ViewMode;
UtilityHelper.SetToReadOnly(Controls);
if (_isChildForm)
{
mode = EnumFormMode.CallbackAdd;
buttonAddSave.Text = "Save";
buttonCancel.Text = "Cancel";
dataGridViewVenue.Enabled = false;
UtilityHelper.ClearTextbox(Controls);
UtilityHelper.EnableControls(Controls);
}
}
public static PackageInfo GetPackageInfo()
{
PackageInfo packageInfoDataset = new PackageInfo();
PackageInfo.PackageDataTable packageInfoPackageDataTable =
packageInfoDataset.Package;
PackageInfo.EventDataTable packageInfoEventDataTable =
packageInfoDataset.Event;
PackageInfo.FlightDataTable packageInfoFlightDataTable =
packageInfoDataset.Flight;
SAPPackageReadWrite package =
new SAPPackageReadWrite(Config._dbConnectionName);
SAPEventReadWrite events =
new SAPEventReadWrite(Config._dbConnectionName);
SAPVenueReadWrite venue =
new SAPVenueReadWrite(Config._dbConnectionName);
SAPPackageEventMapReadWrite packageEventMap =
new SAPPackageEventMapReadWrite(Config._dbConnectionName);
SAPFlight flightHelper = new SAPFlight(
Config.SAPUserName, Config.SAPPassword);
SAPDataSetPackage packageDataset = package.SelectAll();
foreach (SAPDataSetPackage.PackageRow packageRow in packageDataset.Package.Rows)
{
PackageInfo.PackageRow packageInfoPackageRow =
packageInfoPackageDataTable.AddPackageRow(
packageRow.PackageID,
packageRow.PackageName,
packageRow.PackageDescription);
SAPDataSetPackageEventMap packageEventMapDataset =
packageEventMap.SelectByPackageID(packageRow.PackageID);
foreach (SAPDataSetPackageEventMap.PackageEventMapRow packageEventMapRow in packageEventMapDataset.PackageEventMap.Rows)
{
SAPDataSetEvent eventDataset = events.SelectByEventID(packageEventMapRow.EventID);
foreach (SAPDataSetEvent.EventRow eventRow in eventDataset.Event.Rows)
{
PackageInfo.EventRow packageInfoEventRow =
packageInfoEventDataTable.AddEventRow(
eventRow.EventID,
packageInfoPackageRow,
eventRow.EventName,
eventRow.EventDescription,
eventRow.EventDate.ToString(),
eventRow.VenueName,
0,
0,
0);
string venueCity = string.Empty;
using (SAPDataReaderVenue venueReader = venue.ReaderSelectByVenueID(eventRow.VenueID))
{
if (venueReader.DataReader.HasRows)
{
venueReader.DataReader.Read();
venueCity = venueReader.VenueCity.ToUpper();
}
}
if (venueCity != string.Empty)
{
flightHelper.GetList(string.Empty, venueCity);
foreach (SAPServices.SAP_FLIGHTLIST.BAPISFLDAT flight in flightHelper._flightList)
{
//flight dates should be between today and before the event date
if (Convert.ToDateTime(flight.FLIGHTDATE) > DateTime.Today &&
Convert.ToDateTime(flight.FLIGHTDATE) < eventRow.EventDate)
{
flightHelper.CheckAvailability(flight.AIRLINEID, flight.CONNECTID, flight.FLIGHTDATE);
PackageInfo.FlightRow packageInfoFlightRow =
packageInfoFlightDataTable.AddFlightRow(
packageInfoEventRow,
flight.AIRLINE,
flight.FLIGHTDATE,
flight.DEPTIME,
flight.AIRPORTFR,
flight.CITYFROM,
flight.AIRPORTTO,
flight.CITYTO,
flight.ARRDATE,
flight.ARRTIME,
flightHelper._availability.FIRSTFREE,
flightHelper._availability.BUSINFREE,
flightHelper._availability.ECONOFREE);
packageInfoEventRow.GoldAvailability += flightHelper._availability.FIRSTFREE;
packageInfoEventRow.SilverAvailability += flightHelper._availability.BUSINFREE;
packageInfoEventRow.BronzeAvailability += flightHelper._availability.ECONOFREE;
}
}
}
}
}
}
return(packageInfoDataset);
}
