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