private void btnSaveMeeting1_Click(object sender, EventArgs e) { DataRow newMeetingRow = DM.dtMeeting.NewRow(); if ((txtMeetingName1.Text == "") || (numCapacity1.Value.ToString() == "")) { MessageBox.Show("You must enter a value for each of the text fields", "Error"); } else if (int.Parse(numCapacity1.Value.ToString()) <= 1000 || int.Parse(numCapacity1.Value.ToString()) >= 20000) { MessageBox.Show("You must enter a value for capacity more than 1000 and less than 20000", "Error"); } else { newMeetingRow["MeetingName"] = txtMeetingName1.Text; newMeetingRow["RaceCourseID"] = int.Parse(cmbRID1.Text); newMeetingRow["Status"] = cmbStatus1.Text; newMeetingRow["Capacity"] = int.Parse(numCapacity1.Value.ToString()); newMeetingRow["MeetingDate"] = dtpMeetingDate1.Value.ToString(); //Add the new row to the Table DM.dtMeeting.Rows.Add(newMeetingRow); DM.UpdateMeeting(); //Give the user a success message MessageBox.Show("Meeting added successfully", "Success"); pnlAddMeeting.Visible = false; lstMeeting.Visible = true; btnPrevious.Enabled = true; btnNext.Enabled = true; btnUpdateMeeting.Enabled = true; btnDeleteMeeting.Enabled = true; btnReturn.Enabled = true; } }
//Function to delete the Meeting record private void btnDeleteMeeting_Click(object sender, EventArgs e) { DataRow deleteMeetingRow = DM.dtMeeting.Rows[currencyManager.Position]; DataRow[] RaceCourseRow = DM.dtRaceCourse.Select("RaceCourseID = " + txtMeetingRaceCourseID.Text); if (RaceCourseRow.Length != 0) { MessageBox.Show("You may only delete meetings that have no races!", "Error"); } else { if (MessageBox.Show("Are you sure you want to delete this record?", "Warning", MessageBoxButtons.OKCancel) == DialogResult.OK) { deleteMeetingRow.Delete(); DM.UpdateMeeting(); //Update database MessageBox.Show("Meeting deleted successfully!", "Success"); } } }