public void deleteCostumerGymClass(GymClass gymclass, Customer customer) { string query = "DELETE FROM client_activity WHERE client_id = '" + customer.getDBid() + "' AND activity_id = '" + gymclass.getDBid() + "';"; MySqlCommand cmd = new MySqlCommand(query, this.connection); cmd.ExecuteNonQuery(); string query2 = "UPDATE activity SET listed=listed - 1 WHERE id='" + gymclass.getDBid() + "';"; MySqlCommand cmd2 = new MySqlCommand(query2, this.connection); cmd2.ExecuteNonQuery(); }
public void updateCostumerGymClass(GymClass gymclass, Customer customer) { string query = "INSERT INTO client_activity (client_id, activity_id) VALUES('"+customer.getDBid()+"', '"+gymclass.getDBid()+"');"; MySqlCommand cmd = new MySqlCommand(query, this.connection); cmd.ExecuteNonQuery(); string query2 = "UPDATE activity SET listed=listed + 1 WHERE id='" + gymclass.getDBid() + "';"; MySqlCommand cmd2 = new MySqlCommand(query2, this.connection); cmd2.ExecuteNonQuery(); }