public List <string> GetPreRequisiteCourses(string courseNum) { List <string> CList = new List <string>(); try { string sql = "select PreReqCourseNum from CoursePreRequisites where CourseNum=@CourseNum"; List <SqlParameter> PList = new List <SqlParameter>(); DBHelper.AddSqlParam(PList, "@CourseNum", SqlDbType.VarChar, courseNum, 50); DataTable dt = DataLayer.DataAccess.GetManyRowsCols(sql, PList); CList = DBList.GetListValueType <string>(dt, "PreReqCourseNum"); } catch (Exception) { throw; } return(CList); }
public List <string> GetCoursesOfferedForASemester(string semester) { List <string> CList = new List <string>(); try { string sql = "select CourseNum from CoursesOffered where SemesterId=@SemesterId"; List <SqlParameter> PList = new List <SqlParameter>(); DBHelper.AddSqlParam(PList, "@SemesterId", SqlDbType.VarChar, semester, 20); DataTable dt = DataAccess.GetManyRowsCols(sql, PList); // convert dt to List<string> //foreach (DataRow dr in dt.Rows) // CList.Add(dr["CourseNum"].ToString()); CList = DBList.GetListValueType <string>(dt, "CourseNum"); } catch (Exception) { throw; } return(CList); }
public List <CourseEnrollmentVM> GetCourseEnrollment(string semester, string courseNum) { List <CourseEnrollmentVM> CList = new List <CourseEnrollmentVM>(); try { string sql = "select s.StudentId, s.FirstName, s.LastName, s.Email, c.Credits," + "d.DepartmentName as Major from Students s " + "inner join CourseEnrollments ce on s.StudentId=ce.StudentId " + "inner join Courses c on ce.CourseNum=c.CourseNum " + "inner join StudentDepartments sd on s.StudentId=sd.StudentId " + "inner join Departments d on sd.DepartmentId=d.DepartmentId " + "where ce.SemesterId=@SemesterId and ce.CourseNum=@CourseNum"; List <SqlParameter> PList = new List <SqlParameter>(); DBHelper.AddSqlParam(PList, "@SemesterId", SqlDbType.VarChar, semester, 20); DBHelper.AddSqlParam(PList, "@CourseNum", SqlDbType.VarChar, courseNum, 50); DataTable dt = DataAccess.GetManyRowsCols(sql, PList); // convert datatable to List<CurseEnrollmentVM> CList = DBList.GetList <CourseEnrollmentVM>(dt); //foreach (DataRow dr in dt.Rows) //{ // CourseEnrollmentVM cevm = new CourseEnrollmentVM(); // cevm.StudentId = (long)dr["StudentId"]; // cevm.FirstName = (string)dr["FirstName"]; // cevm.LastName = (string)dr["LastName"]; // cevm.Email = (string)dr["Email"]; // cevm.Major = (string)dr["Major"]; // cevm.Credits = (int)dr["Credits"]; // CList.Add(cevm); //} } catch (Exception) { throw; } return(CList); }