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