/// <summary>
/// When the user enters information into all of the fields
/// and the add button is clicked, the information is then
/// stored into the database, if it cannot complete
/// an error message is displayed
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAdd_Click(object sender, RoutedEventArgs e)
{
string strRaceName = txtRaceName.Text;
string strRaceLocation = txtRaceLocation.Text;
string strRaceDistance = txtRaceDistance.Text;
string strRaceDate = txtRaceDate.Text;
string strJuniorMaleTime = txtJuniorMaleTime.Text;
string strJuniorFemaleTime = txtJuniorFemaleTime.Text;
string strSeniorMaleTime = txtSeniorMaleTime.Text;
string strSeniorFemaleTime = txtSeniorFemaleTime.Text;
try
{
RacesDatabase broker = new RacesDatabase();
broker.insertRaces(strRaceName, strRaceLocation, strRaceDistance, strRaceDate, strJuniorMaleTime, strJuniorFemaleTime, strSeniorMaleTime, strSeniorFemaleTime);
MessageBox.Show("Race successfully added");
txtRaceName.Clear();
txtRaceLocation.Clear();
txtRaceDistance.Clear();
txtRaceDate.Clear();
txtJuniorMaleTime.Clear();
txtJuniorFemaleTime.Clear();
txtSeniorMaleTime.Clear();
txtSeniorFemaleTime.Clear();
updateRaceInfo();
}
catch
{
MessageBox.Show("Please ensure that all boxes have been filled in and try again.");
}
}//end of method
/// <summary>
/// updates the information in the connected database by
/// using the update method from the database class then
/// window closes once races has been successfully updated
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnUpdate_Click(object sender, RoutedEventArgs e)
{
try
{
if (race != null)
{
race.RaceName = txtRaceName.Text;
race.RaceLocation = txtRaceLocation.Text;
race.RaceDistance = txtRaceDistance.Text;
race.RaceDate = txtRaceDate.Text;
race.JuniorMaleTime = txtJuniorMaleTime.Text;
race.JuniorFemaleTime = txtJuniorFemaleTime.Text;
race.SeniorMaleTime = txtSeniorMaleTime.Text;
race.SeniorFemaleTime = txtSeniorFemaleTime.Text;
RacesDatabase d = new RacesDatabase();
d.updateRaces(race);
MessageBox.Show("Race Successfully Updated!");
txtRaceName.Clear();
txtRaceLocation.Clear();
txtRaceDistance.Clear();
txtRaceDate.Clear();
txtJuniorMaleTime.Clear();
txtJuniorFemaleTime.Clear();
txtSeniorMaleTime.Clear();
txtSeniorFemaleTime.Clear();
}
}
catch
{
MessageBox.Show("Something went wrong, Please make sure all boxes are filled in and then try again");
}
}//end of method
}//end of method
/// <summary>
/// asks the user to confirm the deletion and if yes is selected
/// the database entry will be removed from the connected database
/// then the Adminraces window will close
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
try
{
if (MessageBox.Show("do you wish to delete the selected race?", "Confirm Delete", MessageBoxButton.OKCancel) == MessageBoxResult.OK)
{
if (race != null)
{
RacesDatabase d = new RacesDatabase();
d.deleteRaces(race);
MessageBox.Show("Race Deleted");
txtRaceName.Clear();
txtRaceLocation.Clear();
txtRaceDistance.Clear();
txtRaceDate.Clear();
txtJuniorMaleTime.Clear();
txtJuniorFemaleTime.Clear();
txtSeniorMaleTime.Clear();
txtSeniorFemaleTime.Clear();
}
}
}
catch
{
MessageBox.Show("Race Doesn't Exist");
}
}
/// <summary>
/// uses the getRacesData method from the RacesDatabase
/// class in order to get the names of the races
/// and then populates the cmdViewRaces with the names.
/// </summary>
private void updateRaceInfo()
{
cmbViewRaces.ItemsSource = null;
db = new RacesDatabase();
cmbViewRaces.ItemsSource = db.getRacesData();
}
