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