public static void DB_addActivity(SomerenModel.Activities newActivity) { // make a sql connection SqlConnection connection = openConnectionDB(); // the sql query for inserting new data to the DB string sqlQuery = "INSERT INTO Activities(activity_desc, numberofStudents, numberofSupervisors) VALUES(@activity_desc, @numberofStudents, @numberofSupervisors)"; SqlCommand command = new SqlCommand(sqlQuery, connection); // execute queries 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(); }
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(); }