public static void DB_deleteActivity(SomerenModel.Activities newActivity)
{
// make a sql connection
SqlConnection connection = openConnectionDB();
// the sql query for deleting data from DB
string sqlQuery = "DELETE FROM Activities WHERE activity_id = @activity_id";
SqlCommand command = new SqlCommand(sqlQuery, connection);
// execute queries
command.Parameters.AddWithValue("@activity_id", newActivity.getId());
command.ExecuteNonQuery();
// close the connection
connection.Close();
}
public static void DB_uppdateActivity(SomerenModel.Activities newActivity)
{
// make a sql connection
SqlConnection connection = openConnectionDB();
// the sql query for updating data of the DB
string sqlQuery = "UPDATE Activities SET activity_desc = @activity_desc, " +
"numberofStudents = @numberofStudents, numberofSupervisors= @numberofSupervisors " +
"WHERE activity_id = @activity_id ";
SqlCommand command = new SqlCommand(sqlQuery, connection);
// execute queries
command.Parameters.AddWithValue("@activity_id", newActivity.getId());
command.Parameters.AddWithValue("@activity_desc", newActivity.getActivity_desc());
command.Parameters.AddWithValue("@numberofStudents", newActivity.getNumOfStudents());
command.Parameters.AddWithValue("@numberofSupervisors", newActivity.getNumOfSupervisors());
command.ExecuteNonQuery();
// close the connection
connection.Close();
}
