private void deleteWorkedPlacesBtn_Click(object sender, EventArgs e)
{
int selectedrowindex = workedPlacesGridView.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = workedPlacesGridView.Rows[selectedrowindex];
WorkedPlace wp;
try
{
wp = new WorkedPlace(Convert.ToString(selectedRow.Cells[0].Value), Convert.ToString(selectedRow.Cells[1].Value), Convert.ToString(selectedRow.Cells[2].Value), Convert.ToString(selectedRow.Cells[3].Value));
}
catch
{
return;
}
try
{
CoacherController.DeleteWorkedPlace(wp);
workedPlacesGridView.DataSource = CoacherController.GetWorkedPlaces(member.AthleticId);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public static int DeleteWorkedPlace(WorkedPlace wp)
{
MySqlConnection connection = DBConnection.getDbConnection().getConnection();
try
{
connection.Open();
}
catch (Exception ex)
{
}
try
{
MySqlCommand command;
string date = "";
string[] dateformat = wp.StartedDate.Split(' ');
date = dateformat[0];
dateformat = date.Split('/');
date = dateformat[2] + "-" + dateformat[0] + "-" + dateformat[1];
String newMemberSql = "DELETE FROM worked_places WHERE Place = '" + wp.Place + "' AND StartedDate = '" + date + "' AND Coacher_member_athleticId = '" + wp.AthleticId + "'";
command = connection.CreateCommand();
command.CommandText = newMemberSql;
return(command.ExecuteNonQuery());
}
catch (Exception ex)
{
throw ex;
}
finally
{
connection.Close();
}
}
public static int AddWorkedPlaces(WorkedPlace wp)
{
MySqlConnection connection = DBConnection.getDbConnection().getConnection();
try
{
connection.Open();
}
catch (Exception ex) { }
try
{
MySqlCommand command;
String newMemberSql = "INSERT INTO worked_places (Place,startedDate,endDate,Coacher_member_athleticId) VALUES (@Place,@startedDate,@endDate,@Coacher_member_atheleticId)";
command = connection.CreateCommand();
command.CommandText = newMemberSql;
command.Parameters.AddWithValue("@Place", wp.Place);
command.Parameters.AddWithValue("@startedDate", wp.StartedDate);
command.Parameters.AddWithValue("@endDate", wp.EndDate);
command.Parameters.AddWithValue("@Coacher_member_atheleticId", wp.AthleticId);
return(command.ExecuteNonQuery());
}
catch (Exception ex)
{
throw ex;
}
finally
{
connection.Close();
}
}