private void dataGridViewEvent_CellValueNeeded(object sender, DataGridViewCellValueEventArgs e) { if (_sourceEvents.Count == 0) { return; } EventList currentEvent = _sourceEvents[e.RowIndex]; switch (dataGridViewEvent.Columns[e.ColumnIndex].Name) { case "ColumnName": e.Value = currentEvent.EventName; break; case "ColumnDescription": e.Value = currentEvent.EventDescription; break; case "ColumnPoster": e.Value = currentEvent.EventPhoto; break; case "ColumnEdit": if (currentEvent.EventEditTag) { e.Value = Resources.icoedit_disabled; } else { e.Value = Resources.icoedit; } break; case "ColumnDelete": if (currentEvent.EventDeleteTag) { e.Value = Resources.icodelete_disabled; } else { e.Value = Resources.icodelete; } break; } }
private void buttonDelete_Click(object sender, EventArgs e) { if (_eventCurrentIndex >= 0) { if (_sourceEvents.Count > 0) { EventList deletedEvent = _sourceEvents[_eventCurrentIndex]; if (deletedEvent.EventDeleteTag) { return; } SAPPackageEventMapReadWrite eventMapRW = new SAPPackageEventMapReadWrite(Config._dbConnectionName); if (eventMapRW.SelectByEventID( deletedEvent.EventID).PackageEventMap.Rows.Count > 0) { Message.DisplayMessage("Unable to delete. " + "Event is currently associated with a package."); return; } if (Message.DeleteMessage( deletedEvent.EventName) == DialogResult.Yes) { SAPEventReadWrite eventRW = new SAPEventReadWrite(Config._dbConnectionName); eventRW.Delete(deletedEvent.EventID); _sourceEvents.RemoveAt(_eventCurrentIndex); dataGridViewEvent.RowCount = _sourceEvents.Count; } } } }
private void buttonSave_Click(object sender, EventArgs e) { string eventName = comboBoxEventType.Text.Trim(); int eventTypeID = 0; int eventID = _eventID; bool hasNoError = true; bool isSuccess = false; errorProvider.Clear(); #region get price/cost DateTime eventSchedule = new DateTime( monthCalendarSchedule.SelectionEnd.Year, monthCalendarSchedule.SelectionEnd.Month, monthCalendarSchedule.SelectionEnd.Day, dateTimePickerSchedule.Value.Hour, dateTimePickerSchedule.Value.Minute, dateTimePickerSchedule.Value.Second); decimal goldPackageCost = Convert.ToDecimal(_packageTypeList[0].PackageCost); decimal silverPackageCost = Convert.ToDecimal(_packageTypeList[1].PackageCost); decimal bronzePackageCost = Convert.ToDecimal(_packageTypeList[2].PackageCost); decimal totalPackageCost = goldPackageCost + silverPackageCost + bronzePackageCost; #endregion _eventList = new EventList(); #region check image file string fileName = openFileDialog.FileName; byte[] byteImage = null; if (File.Exists(fileName)) { FileInfo imageFile = new FileInfo(fileName); using (FileStream fs = new FileStream( fileName, FileMode.Open, FileAccess.Read, FileShare.Read)) { int fileSize = Convert.ToInt32(imageFile.Length); byteImage = new byte[fileSize]; int bytesRead = fs.Read( byteImage, 0, fileSize); fs.Close(); } } else if (_eventID > 0) { byteImage = _previousImage; } else { byteImage = UtilityHelper.BitmapToByte(Resources.blank); } #endregion if (byteImage == null) { errorProvider.SetError(pictureBoxPoster, "Poster is required."); hasNoError = false; } if (eventName.Length == 0) { errorProvider.SetError(comboBoxEventType, "Event Type is required."); hasNoError = false; } if (textBoxName.Text.Trim().Length == 0) { errorProvider.SetError(textBoxName, "Event name is required."); hasNoError = false; } if (textBoxDescription.Text.Trim().Length == 0) { errorProvider.SetError(textBoxDescription, "Event description is required."); hasNoError = false; } if (!hasNoError) { return; } try { SAPEventTypeReadWrite eventType = new SAPEventTypeReadWrite(Config._dbConnectionName); SAPDataSetEventType.EventTypeDataTable dtEventType = eventType.SelectByEventTypeName(eventName).EventType; if (dtEventType.Rows.Count > 0) { eventTypeID = ((SAPDataSetEventType.EventTypeRow)dtEventType.Rows[0]).EventTypeID; } if (eventTypeID == 0) { eventType.Insert( eventName, eventName, out eventTypeID); } using (SWPTransactionDBConnection dbTransaction = new SWPTransactionDBConnection(Config._dbConnectionName)) { try { SAPEventReadWrite mEvent = new SAPEventReadWrite(dbTransaction); SAPEventActorReadWrite eventActor = new SAPEventActorReadWrite(dbTransaction); SAPEventActorMapReadWrite eventActorMap = new SAPEventActorMapReadWrite(dbTransaction); if (_eventID == 0) { mEvent.Insert( Convert.ToInt32(comboBoxVenue.SelectedValue), eventTypeID, textBoxName.Text, textBoxDescription.Text, byteImage, eventSchedule, _packageTypeList[0].PackagePrice, _packageTypeList[1].PackagePrice, _packageTypeList[2].PackagePrice, goldPackageCost, silverPackageCost, bronzePackageCost, totalPackageCost, out eventID); } else { mEvent.Update( _eventID, Convert.ToInt32(comboBoxVenue.SelectedValue), eventTypeID, textBoxName.Text, textBoxDescription.Text, byteImage, eventSchedule, _packageTypeList[0].PackagePrice, _packageTypeList[1].PackagePrice, _packageTypeList[2].PackagePrice, goldPackageCost, silverPackageCost, bronzePackageCost, totalPackageCost); } if (dsEventActor.Tables[0].Rows.Count == 0) { eventActorMap.DeleteByEventID(eventID); } DataTable dtAdded = dsEventActor.Tables[0].GetChanges(DataRowState.Added); DataTable dtDeleted = dsEventActor.Tables[0].GetChanges(DataRowState.Deleted); int eventActorMapID = 0; if (dtAdded != null) { foreach (DataRow dr in dtAdded.Rows) { int eventActorID = Convert.ToInt32(dr[1]); if (eventActorID == 0) { eventActor.Insert( (string)dr[0], out eventActorID); } eventActorMap.Insert( eventID, eventActorID, out eventActorMapID); } } if (dtDeleted != null) { foreach (DataRow dr in dtDeleted.Rows) { int eventActorID = (int)dr[1]; if (eventActorID != 0) { eventActorMap.DeleteByEventActorID(eventActorID); } } } 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(); } } } catch (Exception ex) { ErrorForm errorForm = new ErrorForm(ex.Message, ex.ToString()); errorForm.ShowDialog(this); errorForm.Close(); } if (isSuccess) { _eventList.EventName = textBoxName.Text; _eventList.EventDescription = textBoxDescription.Text; _eventList.EventPhoto = byteImage; _eventList.EventID = eventID; DialogResult = DialogResult.OK; Close(); } }
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); } }