public static List <Enrolment> getCourses(String program, String semester, String Ptype)
{
List <Enrolment> offerList = new List <Enrolment>();
String connStr = "data source= LocalHost;Initial Catalog=Unknown; integrated security = true";
SqlConnection dbConn = new SqlConnection(connStr);
SqlCommand sqlStmt = new SqlCommand("SELECT progCode, semCode, type, code, name FROM CourseOffer, Course WHERE Course.courseCode = CourseOffer.code AND @pCode = progCode AND @type=type AND @sCode= semCode", dbConn);
SqlParameter parameter = new SqlParameter("@pCode", program);
SqlParameter parameter2 = new SqlParameter("@sCode", semester);
SqlParameter parameter3 = new SqlParameter("@type", Ptype);
sqlStmt.Parameters.Add(parameter);
sqlStmt.Parameters.Add(parameter3);
sqlStmt.Parameters.Add(parameter2);
SqlDataReader reader = null;
try
{
dbConn.Open();
reader = sqlStmt.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
reader.Read();
String progCode = reader.GetString(0);
String semCode = reader.GetString(1);
String type = reader.GetString(2);
String code = reader.GetString(3);
String name = reader.GetString(4);
Enrolment course = new Enrolment(progCode, semCode, type, code, name);
offerList.Add(course);
}
}
}
catch (SqlException error)
{
Console.WriteLine(error.Message);
}
finally
{
if (reader != null)
{
reader.Close();
}
if (dbConn != null)
{
dbConn.Close();
}
}
return(offerList);
}