public static List <SomerenModel.Activities> DB_getActivities() { // make a sql connection SqlConnection connection = openConnectionDB(); // make a list to store data from DB into it List <SomerenModel.Activities> activityList = new List <SomerenModel.Activities>(); // sql query string sqlQuery = "SELECT activity_id, activity_desc, numberofStudents, numberofSupervisors " + "FROM Activities"; // execute the sql query SqlCommand command = new SqlCommand(sqlQuery, connection); SqlDataReader reader = command.ExecuteReader(); // read data from DB while (reader.Read()) { SomerenModel.Activities activities = new SomerenModel.Activities(); activities.setId((int)reader["activity_id"]); activities.setActivity_desc((string)reader["activity_desc"]); activities.setNumOfStudents((int)reader["numberofStudents"]); activities.setNumOfSupervisors((int)reader["numberofSupervisors"]); activityList.Add(activities); } // close all connections reader.Close(); connection.Close(); return(activityList); }
public static void deleteActivity(int id) { // make a new variable of type SomerenModel.Activities in order to store data to it SomerenModel.Activities newActivity = new SomerenModel.Activities(); // store data to the newActivity variable newActivity.setId(id); // passing data to the DB layer SomerenDB.DB_deleteActivity(newActivity); }
public static void uppdateActivity(int id, string desc, int numOfStudents, int numberOfSupervisor) { // make a new variable of type SomerenModel.Activities in order to store data to it SomerenModel.Activities newActivity = new SomerenModel.Activities(); // store data to the newActivity variable newActivity.setId(id); newActivity.setActivity_desc(desc); newActivity.setNumOfStudents(numOfStudents); newActivity.setNumOfSupervisors(numberOfSupervisor); // passing data to the DB layer SomerenDB.DB_uppdateActivity(newActivity); }