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