private void GetAssociatedEvents() { dataGridViewEvents.RowCount = 0; SourceEvent = new List <AssociatedEventList>(); decimal price = 0; 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); if (item != null) { price += item.EventGoldPrice; item.PackageType = "Gold"; SourceEvent.Add(item); } } //while (readerEventMap.DataReader.Read()); } } labelTotalPrice.Text = price.ToString("c"); dataGridViewEvents.RowCount = SourceEvent.Count; }
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; }