public static List<Course> List(bool? availableInRegionalCampus = null) { List<Course> courseList = new List<Course>(); SqlConnection cn = new SqlConnection(Database.ConnectionString); cn.Open(); SqlCommand cm = cn.CreateCommand(); cm.CommandType = CommandType.StoredProcedure; cm.CommandText = "GetCourseList"; cm.Parameters.AddWithValue("@AvailableInRegionalCampus", availableInRegionalCampus); SqlDataReader dr = cm.ExecuteReader(); while (dr.Read()) { Course course = new Course(); course.Id = Convert.ToInt32(dr["Course_ID"]); course.Prefix = dr["Course_Prefix"].ToString(); course.Number = dr["Course_Number"].ToString(); course.Section = dr["Course_Section"].ToString(); course.Title = dr["Title"].ToString(); course.Department = dr["Course_Department"].ToString(); course.AvailableInRegionalCampus = Convert.ToBoolean(dr["availableInRegionalCampus"]); courseList.Add(course); } cn.Close(); return courseList; }
public static Course Get(int id) { SqlConnection cn = new SqlConnection(Database.ConnectionString); cn.Open(); SqlCommand cm = cn.CreateCommand(); cm.CommandType = CommandType.StoredProcedure; cm.CommandText = "GetCourse"; cm.Parameters.AddWithValue("@Id", id); SqlDataReader dr = cm.ExecuteReader(); dr.Read(); Course course = new Course(); course.Id = Convert.ToInt32(dr["Course_ID"]); course.Prefix = dr["Course_Prefix"].ToString(); course.Number = dr["Course_Number"].ToString(); course.Section = dr["Course_Section"].ToString(); course.Title = dr["Title"].ToString(); course.Department = dr["Course_Department"].ToString(); course.AvailableInRegionalCampus = Convert.ToBoolean(dr["availableInRegionalCampus"]); cn.Close(); return course; }
public static List<Test> List(string nid) { List<Test> list = new List<Test>(); SqlConnection cn = new SqlConnection(Database.ConnectionString); cn.Open(); SqlCommand cm = cn.CreateCommand(); cm.CommandType = CommandType.StoredProcedure; cm.CommandText = "GetAvailableTestList"; cm.Parameters.AddWithValue("@NID", nid); SqlDataReader dr = cm.ExecuteReader(); while (dr.Read()) { Test test = new Test(); test.Id = Convert.ToInt32(dr["Test_ID"]); test.Name = dr["Test_Name"].ToString(); Course course = new Course(); course.Prefix = dr["Course_Prefix"].ToString(); course.Number = dr["Course_Number"].ToString(); course.Title = dr["Title"].ToString(); Professor professor = new Professor(); professor.FirstName = dr["First_Name"].ToString(); professor.LastName = dr["Last_Name"].ToString(); course.Professor = professor; test.Course = course; list.Add(test); } cn.Close(); return list; }
public static List<Test> List(int? courseId = null, int? term = null, bool? active = null, bool? availableInRegionalCampus = null, string nid = null, DateTime? endDate = null) { List<Test> list = new List<Test>(); SqlConnection cn = new SqlConnection(Database.ConnectionString); cn.Open(); SqlCommand cm = cn.CreateCommand(); cm.CommandType = CommandType.StoredProcedure; cm.CommandText = "GetTestList"; cm.Parameters.AddWithValue("@CourseId", courseId); cm.Parameters.AddWithValue("@Term", term); cm.Parameters.AddWithValue("@Active", active); cm.Parameters.AddWithValue("@AvailableInRegionalCampus", availableInRegionalCampus); cm.Parameters.AddWithValue("@NID", nid); cm.Parameters.AddWithValue("@EndDate", endDate); SqlDataReader dr = cm.ExecuteReader(); while (dr.Read()) { Test test = new Test(); test.Id = Convert.ToInt32(dr["Test_ID"]); test.Name = dr["Test_Name"].ToString(); test.StartDate = Convert.ToDateTime(dr["Open_Date_Time"]); test.EndDate = Convert.ToDateTime(dr["Close_Date_Time"]); Course course = new Course(); course.Id = Convert.ToInt32(dr["Course_ID"]); course.Prefix = dr["Course_Prefix"].ToString(); course.Number = dr["Course_Number"].ToString(); course.Title = dr["Title"].ToString(); Professor professor = new Professor(); professor.FirstName = dr["First_Name"].ToString(); professor.LastName = dr["Last_Name"].ToString(); course.Professor = professor; test.Course = course; list.Add(test); } cn.Close(); return list; }
public static Test Get(int id) { SqlConnection cn = new SqlConnection(Database.ConnectionString); cn.Open(); SqlCommand cm = cn.CreateCommand(); cm.CommandType = CommandType.StoredProcedure; cm.CommandText = "GetTest"; cm.Parameters.AddWithValue("@Id", id); SqlDataReader dr = cm.ExecuteReader(); dr.Read(); Test test = new Test(); test.Id = Convert.ToInt32(dr["Test_ID"]); test.Name = dr["Test_Name"].ToString(); test.StartDate = Convert.ToDateTime(dr["Open_Date_Time"]); test.EndDate = Convert.ToDateTime(dr["Close_Date_Time"]); Course course = new Course(); course.Id = Convert.ToInt32(dr["Course_ID"]); course.Prefix = dr["Course_Prefix"].ToString(); course.Number = dr["Course_Number"].ToString(); course.Title = dr["Title"].ToString(); Professor professor = new Professor(); professor.FirstName = dr["First_Name"].ToString(); professor.LastName = dr["Last_Name"].ToString(); course.Professor = professor; test.Course = course; cn.Close(); return test; }