private void buttonDelete_Click(object sender, EventArgs e) { if (_sourcePackage.Count > 0) { PackageList deletedPackage = _sourcePackage[_packageCurrentIndex]; if (deletedPackage.PackageTag) { return; } if (Message.DeleteMessage(deletedPackage.PackageName) == DialogResult.Yes) { SAPPackageEventMapReadWrite eventMapRW = new SAPPackageEventMapReadWrite(Config._dbConnectionName); SAPDataSetPackageEventMap ds = eventMapRW.SelectByPackageID(deletedPackage.PackageID); foreach (SAPDataSetPackageEventMap.PackageEventMapRow row in ds.PackageEventMap.Rows) { eventMapRW.Delete(row.PackageEventMapID); } SAPPackageReadWrite packageRW = new SAPPackageReadWrite(Config._dbConnectionName); packageRW.Delete(deletedPackage.PackageID); _sourcePackage.RemoveAt(_packageCurrentIndex); dataGridViewPackage.RowCount = _sourcePackage.Count; } } }
private void buttonEdit_Click(object sender, EventArgs e) { if (_packageCurrentIndex >= 0) { PackageList currentPackage = _sourcePackage[_packageCurrentIndex]; PackageForm newPackageForm = new PackageForm(); if (currentPackage.PackageTag) { newPackageForm._isReadOnly = true; //return; } newPackageForm._packageID = currentPackage.PackageID; if (newPackageForm.ShowDialog(this) == DialogResult.OK) { if (newPackageForm._packageItem != null) { _sourcePackage[_packageCurrentIndex] = newPackageForm._packageItem; } } newPackageForm.Dispose(); } }
private void dataGridViewPackage_CellValueNeeded(object sender, DataGridViewCellValueEventArgs e) { if (_sourcePackage.Count == 0) { return; } PackageList currentPackage = _sourcePackage[e.RowIndex]; switch (dataGridViewPackage.Columns[e.ColumnIndex].Name) { case "ColumnName": e.Value = currentPackage.PackageName; break; case "ColumnDescription": e.Value = currentPackage.PackageDescription; break; case "ColumnPoster": e.Value = currentPackage.PackagePhoto; break; case "ColumnEdit": if (currentPackage.PackageTag) { e.Value = Resources.icoedit_disabled; } else { e.Value = Resources.icoedit; } break; case "ColumnDelete": if (currentPackage.PackageTag) { e.Value = Resources.icodelete_disabled; } else { e.Value = Resources.icodelete; } break; } }
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 buttonSave_Click(object sender, EventArgs e) { errorProvider.Clear(); bool hasNoError = true; _packageItem = new PackageList(); int packageID = _packageID; int packageEventMapID; bool isSuccess = false; #region Check Image file string fileName = openFileDialog.FileName; byte[] byteImage = null; if (File.Exists(fileName)) { byteImage = UtilityHelper.FileToByte(fileName); } else if (_packageID > 0) { byteImage = _imageSelected; } else { byteImage = UtilityHelper.BitmapToByte(Resources.blank); } #endregion if (textBoxName.Text.Trim().Length == 0) { errorProvider.SetError(textBoxName, "Package name is required."); hasNoError = false; } if (textBoxDescription.Text.Trim().Length == 0) { errorProvider.SetError(textBoxDescription, "Package description is required."); hasNoError = false; } if (dataGridViewEvents.RowCount == 0) { errorProvider.SetError(dataGridViewEvents, "At least one event is required."); hasNoError = false; } if (byteImage == null) { errorProvider.SetError(pictureBoxPoster, "Poster is required."); hasNoError = false; } if (!hasNoError) { return; } using (SWPTransactionDBConnection dbTransaction = new SWPTransactionDBConnection(Config._dbConnectionName)) { try { SAPPackageReadWrite packageRW = new SAPPackageReadWrite(dbTransaction); SAPPackageEventMapReadWrite packageEventRW = new SAPPackageEventMapReadWrite(dbTransaction); if (_packageID == 0) { packageRW.Insert( textBoxName.Text, textBoxDescription.Text, byteImage, out packageID); foreach (AssociatedEventList item in _sourceEvent) { packageEventRW.Insert( packageID, item.EventID, out packageEventMapID); } } else { packageRW.Update( _packageID, textBoxName.Text, textBoxDescription.Text, byteImage); foreach (AssociatedEventList item in _removedEvent) { packageEventRW.Delete(item.PackageMapID); } foreach (AssociatedEventList item in _sourceEvent) { if (item.IsNewID) { packageEventRW.Insert( _packageID, item.EventID, out packageEventMapID); } } } dbTransaction.Transaction.Commit(); isSuccess = true; } catch (Exception ex) { dbTransaction.Transaction.Rollback(); ErrorForm errorForm = new ErrorForm(ex.Message, ex.ToString()); errorForm.ShowDialog(this); errorForm.Close(); } finally { dbTransaction.Transaction.Dispose(); } } if (isSuccess) { _packageItem.PackageName = textBoxName.Text; _packageItem.PackageDescription = textBoxDescription.Text; _packageItem.PackagePhoto = byteImage; _packageItem.PackageID = packageID; DialogResult = DialogResult.OK; Close(); } }