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); }