private void ShowPoster(int rowIndex) { if (_sourcePackage.Count > 0 && rowIndex > -1) { pictureBoxPoster.Image = UtilityHelper.ByteToImage(_sourcePackage[rowIndex].PackagePhoto); } }
private void ShowPoster(int rowIndex) { if (_sourceEvents.Count > 0 && rowIndex > -1) { pictureBoxPoster.Image = UtilityHelper.ByteToImage(_sourceEvents[rowIndex].EventPhoto); } }
private void FillTabContent(int index) { DataRow dr = _dtVenue.Rows[index]; _rowIndex = index; _venueID = Convert.ToInt32(dr[SAPVenueReadWrite._venueIDColumnName]); textBoxName.Text = ((string)dr[SAPVenueReadWrite._venueNameColumnName]).Trim(); textBoxDescription.Text = ((string)dr[SAPVenueReadWrite._venueDescriptionColumnName]).Trim(); textBoxStreet.Text = ((string)dr[SAPVenueReadWrite._venueStreetColumnName]).Trim(); textBoxCity.Text = ((string)dr[SAPVenueReadWrite._venueCityColumnName]).Trim(); textBoxState.Text = ((string)dr[SAPVenueReadWrite._venueStateColumnName]).Trim(); textBoxPostalCode.Text = ((string)dr[SAPVenueReadWrite._venuePostalCodeColumnName]).Trim(); pictureBoxLocationMap.Image = UtilityHelper.ByteToImage((byte[])dr[SAPVenueReadWrite._venueGeographicMapColumnName]); pictureBoxVenueImage.Image = UtilityHelper.ByteToImage((byte[])dr[SAPVenueReadWrite._venueImageColumnName]); pictureBoxFacilityImage.Image = UtilityHelper.ByteToImage((byte[])dr[SAPVenueReadWrite._venueFacilityMapColumnName]); }
private void ManagePackage_Load(object sender, EventArgs e) { #region Populate Grid _sourcePackage = new List <PackageList>(); List <PackageList> usedPackage = new List <PackageList>(); List <PackageList> unUsedPackage = new List <PackageList>(); SAPEventAttendeeReadWrite eventAttendeeRW = new SAPEventAttendeeReadWrite(Config._dbConnectionName); SAPPackageReadWrite packageRW = new SAPPackageReadWrite(Config._dbConnectionName); using (SAPDataReaderPackage rdrPackage = packageRW.ReaderSelectAll()) { if (rdrPackage.DataReader != null && rdrPackage.DataReader.HasRows) { SAPDataSetEventAttendee.EventAttendeeDataTable dtEventAttendee = eventAttendeeRW.SelectAll().EventAttendee; while (rdrPackage.DataReader.Read()) { PackageList item = new PackageList(); item.PackageName = rdrPackage.PackageName; item.PackageDescription = rdrPackage.PackageDescription; item.PackagePhoto = rdrPackage.PackageImage; item.PackageID = rdrPackage.PackageID; DataRow[] rows = dtEventAttendee.Select("packageid = " + item.PackageID.ToString()); if (rows != null && rows.Length > 0) { item.PackageTag = true; usedPackage.Add(item); } else { item.PackageTag = false; unUsedPackage.Add(item); } } //while (rdrPackage.DataReader.Read()); _sourcePackage.AddRange(unUsedPackage); _sourcePackage.AddRange(usedPackage); } } //SAPEventAttendeeReadWrite #endregion #region Create Data Grid dataGridViewPackage.VirtualMode = true; DataGridViewTextBoxColumn columnName = new DataGridViewTextBoxColumn(); columnName.HeaderText = "Name"; columnName.Name = "ColumnName"; columnName.Width = 100; dataGridViewPackage.Columns.Add(columnName); DataGridViewTextBoxColumn columnDesc = new DataGridViewTextBoxColumn(); columnDesc.HeaderText = "Description"; columnDesc.Name = "ColumnDescription"; columnDesc.Width = 150; columnDesc.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; dataGridViewPackage.Columns.Add(columnDesc); //create icon edit column DataGridViewImageColumn editColumn = new DataGridViewImageColumn(); editColumn.Image = Resources.icoedit; editColumn.Width = 25; editColumn.Name = "ColumnEdit"; editColumn.HeaderText = string.Empty; editColumn.SortMode = DataGridViewColumnSortMode.NotSortable; //create icond delete column DataGridViewImageColumn deleteColumn = new DataGridViewImageColumn(); deleteColumn.Image = Resources.icodelete; deleteColumn.Width = 25; deleteColumn.Name = "ColumnDelete"; deleteColumn.HeaderText = string.Empty; deleteColumn.SortMode = DataGridViewColumnSortMode.NotSortable; dataGridViewPackage.Columns.Insert(2, editColumn); editColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.None; dataGridViewPackage.Columns.Insert(3, deleteColumn); deleteColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.None; #endregion dataGridViewPackage.RowCount = _sourcePackage.Count; pictureBoxNewPackage.Image = Resources.iconew; //set first image on poster panel if (_sourcePackage.Count > 0) { pictureBoxPoster.Image = UtilityHelper.ByteToImage(_sourcePackage[0].PackagePhoto); } }
private void PopulateItems() { _sourceEvent = new List <AssociatedEventList>(); if (_packageID > 0) { //get associated events SAPPackageEventMapReadWrite eventMap = new SAPPackageEventMapReadWrite(Config._dbConnectionName); using (SAPDataReaderPackageEventMap readerEventMap = eventMap.ReaderSelectByPackageID(_packageID)) { if (readerEventMap.DataReader != null && readerEventMap.DataReader.HasRows) { while (readerEventMap.DataReader.Read()) { AssociatedEventList item = GetItem(readerEventMap.EventID); item.EventID = readerEventMap.EventID; item.IsNewID = false; item.PackageMapID = readerEventMap.PackageEventMapID; _sourceEvent.Add(item); }// while (readerEventMap.DataReader.Read()); } } //get pacakage info SAPPackageReadWrite package = new SAPPackageReadWrite(Config._dbConnectionName); using (SAPDataReaderPackage readerPackage = package.ReaderSelectByPackageID(_packageID)) { if (readerPackage.DataReader != null && readerPackage.DataReader.HasRows) { readerPackage.DataReader.Read(); textBoxName.Text = readerPackage.PackageName; textBoxDescription.Text = readerPackage.PackageDescription; pictureBoxPoster.Image = UtilityHelper.ByteToImage(readerPackage.PackageImage); _imageSelected = readerPackage.PackageImage; } } } #region Create Datagrid dataGridViewEvents.VirtualMode = true; dataGridViewEvents.Columns.Add( CreateColumn("Name", EventNameColumn, 100, "")); dataGridViewEvents.Columns.Add( CreateColumn("Date", EventDateColumn, 100, "")); dataGridViewEvents.Columns.Add( CreateColumn("Venue", EventVenueColumn, 100, "")); dataGridViewEvents.Columns.Add( CreateColumn("Gold Price", EventGoldPriceColumn, 75, "c")); dataGridViewEvents.Columns.Add( CreateColumn("Silver", EventSilverPriceColumn, 75, "c")); dataGridViewEvents.Columns.Add( CreateColumn("Bronze", EventBronzePriceColumn, 75, "c")); #endregion _removedEvent = new List <AssociatedEventList>(); dataGridViewEvents.RowCount = _sourceEvent.Count; }
private void GetSource() { List <EventList> unUsedEvent = new List <EventList>(); List <EventList> usedEvent = new List <EventList>(); _sourceEvents = new List <EventList>(); SAPEventReadWrite eventRW = new SAPEventReadWrite(Config._dbConnectionName); SAPEventAttendeeAgencyMapReadWrite eventAttendyMapRW = new SAPEventAttendeeAgencyMapReadWrite(Config._dbConnectionName); SAPPackageEventMapReadWrite packageEventMapRW = new SAPPackageEventMapReadWrite(Config._dbConnectionName); using (SAPDataReaderEvent readerEvent = eventRW.ReaderSelectAll()) { if (readerEvent.DataReader != null && readerEvent.DataReader.HasRows) { SAPDataSetEventAttendeeAgencyMap.EventAttendeeAgencyMapDataTable dtEventAttendee = eventAttendyMapRW.SelectAll().EventAttendeeAgencyMap; SAPDataSetPackageEventMap.PackageEventMapDataTable dtPackageEvent = packageEventMapRW.SelectAll().PackageEventMap; while (readerEvent.DataReader.Read()) { EventList item = new EventList(); item.EventName = readerEvent.EventName; item.EventDescription = readerEvent.EventDescription; item.EventPhoto = readerEvent.EventPhoto; item.EventID = readerEvent.EventID; DataRow[] rows = dtEventAttendee.Select("EventID = " + item.EventID.ToString()); if (rows != null && rows.Length > 0) { item.EventEditTag = true; item.EventDeleteTag = true; usedEvent.Add(item); } else { item.EventEditTag = false; rows = dtPackageEvent.Select("EventId = " + item.EventID.ToString()); item.EventDeleteTag = (rows != null && rows.Length > 0); unUsedEvent.Add(item); } }// while (readerEvent.DataReader.Read()); _sourceEvents.AddRange(unUsedEvent); _sourceEvents.AddRange(usedEvent); } } if (_sourceEvents.Count > 0) { pictureBoxPoster.Image = UtilityHelper.ByteToImage(_sourceEvents[0].EventPhoto); } }