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