public GroupModulesSemester ReadGroupSemesterModule(SqlDataReader reader) { GroupModulesSemester groupModule = new GroupModulesSemester(); while (reader.Read()) { groupModule.ID = reader.GetInt32(0); groupModule.GroupID = reader.GetString(1); groupModule.SemesterID = reader.GetInt32(2); groupModule.ModuleID = reader.GetInt32(3); groupModule.ModuleName = reader.GetString(4); groupModule.SemesterNo = reader.GetInt32(5); } return(groupModule); }
public List <GroupModulesSemester> GetGroupSemesterModules() { string retriveStudentList = "SELECT g.ID, g.GroupID, g.SemesterID, g.ModuleID, m.ModuleName, s.SemesterNo FROM ModuleGroups g " + "Join Semesters s ON s.SemesterID = g.SemesterID " + "Join Modules m ON m.ModuleID = g.ModuleID ;"; List <GroupModulesSemester> groupModuleSemesterList = new List <GroupModulesSemester>(); SqlCommand cmd = new SqlCommand(retriveStudentList, con); try { con.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.HasRows) { while (reader.Read()) { GroupModulesSemester groupModule = new GroupModulesSemester(); groupModule.ID = reader.GetInt32(0); groupModule.GroupID = reader.GetString(1); groupModule.SemesterID = reader.GetInt32(2); groupModule.ModuleID = reader.GetInt32(3); groupModule.ModuleName = reader.GetString(4); groupModule.SemesterNo = reader.GetInt32(5); groupModuleSemesterList.Add(groupModule); } reader.NextResult(); } con.Close(); } return(groupModuleSemesterList); } finally { con.Close(); } }
//public List<GroupTimetableBridge> GetGroupModulesBridge() //{ // string retriveStudentList = "SELECT g.GroupID, m.ModuleName, t.ClassStartTime, t.ClassEndTime, t.Day FROM GroupTimetables gt " + // "Join Groups g ON g.GroupID = gt.GroupID " + // "Join Timetables t ON t.TimetableID = gt.TimetableID ;"; // List<ModuleTimetableBridge> moduleTimetables = new List<ModuleTimetableBridge>(); // SqlCommand cmd = new SqlCommand(retriveStudentList, con); // try // { // con.Open(); // using (SqlDataReader reader = cmd.ExecuteReader()) // { // while (reader.HasRows) // { // while (reader.Read()) // { // ModuleTimetableBridge moduleTimetable = new ModuleTimetableBridge(); // moduleTimetable.GroupID = reader.GetInt32(0); // moduleTimetable.GroupID = reader.GetString(1); // moduleTimetable.SemesterID = reader.GetInt32(2); // moduleTimetable.ModuleID = reader.GetInt32(3); // moduleTimetable.ModuleName = reader.GetString(4); // groupModule.SemesterNo = reader.GetInt32(5); // groupModuleSemesterList.Add(groupModule); // } // reader.NextResult(); // } // con.Close(); // } // return groupModuleSemesterList; // } // finally // { // con.Close(); // } //} public GroupModulesSemester GetGroupModulesSemester(int id) { string retriveGroupModuleList = "SELECT g.ID, g.GroupID, g.SemesterID, g.ModuleID, m.ModuleName, s.SemesterNo FROM ModuleGroups g " + "Join Semesters s ON s.SemesterID = g.SemesterID AND g.ID = " + id + " Join Modules m ON m.ModuleID = g.ModuleID ;"; SqlCommand cmd = new SqlCommand(retriveGroupModuleList, con); GroupModulesSemester groupModule = new GroupModulesSemester(); try { con.Open(); using (SqlDataReader oReader = cmd.ExecuteReader()) { groupModule = this.ReadGroupSemesterModule(oReader); con.Close(); } return(groupModule); } finally { con.Close(); } }