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