public ModuleTimetableBridge GetModuleTimetable(int TimetableID)
{
string retriveModuleTimetable = "SELECT t.TimeTableID, t.ClassStartTime, t.ClassEndTime, t.Day, t.Room, t.Year, t.ClassType, m.ModuleID, m.ModuleName, f.FacultyName, s.SemesterNo " +
"FROM Timetables t " +
"JOIN Semesters s ON s.SemesterID = t.SemesterID " +
"JOIN Modules m On t.ModuleID = m.ModuleID AND t.TimetableID = " + TimetableID + " AND t.Status = 1" +
"JOIN Faculties f ON m.FacultyID = f.FacultyID ;";
SqlCommand cmd = new SqlCommand(retriveModuleTimetable, con);
ModuleTimetableBridge moduleTimetable = new ModuleTimetableBridge();
try
{
con.Open();
using (SqlDataReader oReader = cmd.ExecuteReader())
{
moduleTimetable = this.ReadModuleTimetable(oReader);
con.Close();
}
return(moduleTimetable);
}
finally
{
con.Close();
}
}
public List <ModuleTimetableBridge> GetModuleTimetable()
{
string retriveTimetableList = "SELECT t.TimeTableID, t.ClassStartTime, t.ClassEndTime, t.Day, t.Room, t.Year, t.ClassType, m.ModuleID, m.ModuleName, f.FacultyName, s.SemesterNo " +
"FROM Timetables t " +
"JOIN Semesters s ON s.SemesterID = t.SemesterID " +
"JOIN Modules m On t.ModuleID = m.ModuleID AND t.Status = 1 " +
"JOIN Faculties f ON m.FacultyID = f.FacultyID ;";
List <ModuleTimetableBridge> moduleTimetableList = new List <ModuleTimetableBridge>();
SqlCommand cmd = new SqlCommand(retriveTimetableList, con);
try
{
con.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.HasRows)
{
while (reader.Read())
{
int TimeTableId = reader.GetInt32(0);
TimeSpan ClassStartTime = reader.GetTimeSpan(1);
TimeSpan ClassEndTime = reader.GetTimeSpan(2);
string Day = reader.GetString(3);
string Room = reader.GetString(4);
int Year = reader.GetInt32(5);
string ClassType = reader.GetString(6);
int ModuleID = reader.GetInt32(7);
string ModuleName = reader.GetString(8);
string FacultyName = reader.GetString(9);
int Semester = reader.GetInt32(10);
ModuleTimetableBridge moduleTimetable = new ModuleTimetableBridge(TimeTableId, ClassStartTime, ClassEndTime, Day, Room, Year, ModuleID, ModuleName, ClassType, FacultyName, Semester);
moduleTimetableList.Add(moduleTimetable);
}
reader.NextResult();
}
con.Close();
}
return(moduleTimetableList);
}
finally
{
con.Close();
}
}
public ModuleTimetableBridge ReadModuleTimetable(SqlDataReader reader)
{
ModuleTimetableBridge moduleTimetable = new ModuleTimetableBridge();
while (reader.Read())
{
moduleTimetable.TimeTableId = reader.GetInt32(0);
moduleTimetable.ClassStartTime = reader.GetTimeSpan(1);
moduleTimetable.ClassEndTime = reader.GetTimeSpan(2);
moduleTimetable.Day = reader.GetString(3);
moduleTimetable.Room = reader.GetString(4);
moduleTimetable.Year = reader.GetInt32(5);
moduleTimetable.ClassType = reader.GetString(6);
moduleTimetable.ModuleID = reader.GetInt32(7);
moduleTimetable.ModuleName = reader.GetString(8);
moduleTimetable.FacultyName = reader.GetString(9);
moduleTimetable.Semester = reader.GetInt32(10);
}
return(moduleTimetable);
}
