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 CreatePackageSlide()
{
Slide slide;
Shape pictureShape;
Slide slidePackage;
slidePackage = slides[SlideTemplate.PackageSlide];
//set image layout
imageTop = slidePackage.Shapes[1].Top;
imageLeft = slidePackage.Shapes[1].Left;
imageWidth = slidePackage.Shapes[1].Width;
imageHeight = slidePackage.Shapes[1].Height;
_packageImageFileName =
Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyPictures),
"PackageImage" +
_packageID.ToString() +
".jpg");
SAPPackageReadWrite packageRW = new SAPPackageReadWrite(Config._dbConnectionName);
using (SAPDataReaderPackage rdrPackage =
packageRW.ReaderSelectByPackageID(_packageID))
{
if (rdrPackage.DataReader != null && rdrPackage.DataReader.HasRows)
{
rdrPackage.DataReader.Read();
ByteToFile(rdrPackage.PackageImage, _packageImageFileName);
slide = DuplicateSlide(slidePackage);
_pptxFileName = rdrPackage.PackageName.Trim();
_pptxFileName = _pptxFileName.Replace(" ", "");
//package poster
do
{
slide.Shapes[1].Delete();
} while (slide.Shapes.Count > 0);
if (File.Exists(_packageImageFileName))
{
pictureShape = slide.Shapes.AddPicture(
_packageImageFileName,
MsoTriState.msoFalse,
MsoTriState.msoCTrue,
imageLeft,
imageTop,
imageWidth,
imageHeight);
pictureShape.ZOrder(MsoZOrderCmd.msoSendToBack);
}
slide = DuplicateSlide(slidePackage);
slide.Shapes[1].Delete();
if (File.Exists(_packageImageFileName))
{
pictureShape = slide.Shapes.AddPicture(
_packageImageFileName,
MsoTriState.msoFalse,
MsoTriState.msoCTrue,
imageLeft,
imageTop,
imageWidth,
imageHeight);
pictureShape.ZOrder(MsoZOrderCmd.msoSendToBack);
}
slide.Shapes[4].TextFrame.TextRange.Text = rdrPackage.PackageName.Trim();
slide.Shapes[5].TextFrame.TextRange.Text = rdrPackage.PackageDescription.Trim();
}
}
}