/// <summary>
/// Return één Module.
/// </summary>
public Models.BU.Module GetSingleModule(string query)
{
Connect();
try
{
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Models.BU.Module singleModule = new Models.BU.Module(Convert.ToInt32(reader["ModuleId"]), reader["Name"].ToString(), reader["Code"].ToString(), Convert.ToInt32(reader["Period"]), Convert.ToInt32(reader["Year"]), reader["Faculty"].ToString(), reader["Profile"].ToString(), Convert.ToInt32(reader["Credits"]), null, reader["Description"].ToString(), (bool)reader["GeneralModule"], Convert.ToInt32(reader["LectureHours"]), Convert.ToInt32(reader["PracticalHours"]));
Debug.WriteLine("GetSingleModule - Succes.");
return(singleModule);
}
}
catch (Exception)
{
Debug.WriteLine("GetSingleModule - Exception!");
return(null);
}
Debug.WriteLine("GetSingleModule - Niks gevonden.");
return(null);
}
/// <summary>
/// Return een lijst van Modules op basis van userId.
/// </summary>
public List <Models.BU.Module> GetModuleListOfTeacher(string query)
{
Connect();
try
{
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
List <Models.BU.Module> modulesList = new List <Models.BU.Module>();
while (reader.Read())
{
Models.BU.Module tempModule = new Models.BU.Module(Convert.ToInt32(reader["ModuleId"]), reader["Name"].ToString(), reader["Code"].ToString(), Convert.ToInt32(reader["Period"]), Convert.ToInt32(reader["Year"]), reader["Faculty"].ToString(), reader["Profile"].ToString(), Convert.ToInt32(reader["Credits"]), GetSingleExaminer("SELECT * FROM UserAccount WHERE Role = '2' AND UserId = '" + reader["ExaminerId"] + "'"), reader["Description"].ToString(), (bool)reader["GeneralModule"], Convert.ToInt32(reader["LectureHours"]), Convert.ToInt32(reader["PracticalHours"]));
modulesList.Add(tempModule);
}
Debug.WriteLine("GetModuleListOfTeacher - Succes.");
return(modulesList);
}
catch (Exception)
{
Debug.WriteLine("GetModuleListOfTeacher - Exception!");
return(null);
}
}
