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