public FacultyModule ReadFacultyModule(SqlDataReader reader)
{
FacultyModule facultyModule = new FacultyModule();
while (reader.Read())
{
facultyModule.ModuleID = reader.GetInt32(0);
facultyModule.ModuleName = reader.GetString(1);
facultyModule.ModuleType = reader.GetString(2);
facultyModule.Credit = reader.GetInt32(3);
facultyModule.FacultyID = reader.GetInt32(4);
facultyModule.FacultyName = reader.GetString(5);
}
return(facultyModule);
}
public FacultyModule GetFacultyModule(int moduleId)
{
string retriveString = "SELECT m.ModuleID, m.ModuleName, m.ModuleType, m.Credit, m.FacultyID, f.FacultyName from Modules m JOIN Faculties f ON m.FacultyID = f.FacultyID AND m.ModuleID = '" + moduleId + "' ;";
SqlCommand cmd = new SqlCommand(retriveString, con);
FacultyModule facultyModule = new FacultyModule();
try
{
con.Open();
using (SqlDataReader oReader = cmd.ExecuteReader())
{
facultyModule = this.ReadFacultyModule(oReader);
con.Close();
}
return(facultyModule);
}
finally
{
con.Close();
}
}
public List <FacultyModule> GetFacultyModule()
{
string retriveStudentList = "SELECT m.ModuleID, m.SemesterID, m.ModuleName, m.ModuleType, m.Credit, m.FacultyID, f.FacultyName FROM Modules m JOIN Faculties f ON m.FacultyID = f.FacultyID AND m.Status = 1 ;";
List <FacultyModule> facultyModuleList = new List <FacultyModule>();
SqlCommand cmd = new SqlCommand(retriveStudentList, con);
try
{
con.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.HasRows)
{
while (reader.Read())
{
FacultyModule facultyModule = new FacultyModule();
facultyModule.ModuleID = reader.GetInt32(0);
facultyModule.SemesterNo = reader.GetInt32(1);
facultyModule.ModuleName = reader.GetString(2);
facultyModule.ModuleType = reader.GetString(3);
facultyModule.Credit = reader.GetInt32(4);
facultyModule.FacultyID = reader.GetInt32(5);
facultyModule.FacultyName = reader.GetString(6);
facultyModuleList.Add(facultyModule);
}
reader.NextResult();
}
con.Close();
}
return(facultyModuleList);
}
finally
{
con.Close();
}
}
