public Exception GetSemesterLog(ref ICollection <SemesterLog> semesterLogs) { using (OracleConnection oracleConnection = Connection.GetInstance().ConnectionDB()) { OracleCommand oracleCommand = new OracleCommand(); oracleCommand.Connection = oracleConnection; oracleCommand.CommandText = "PACK_SEMESTER_LOG.GET_SEMESTER_LOG"; oracleCommand.CommandType = CommandType.StoredProcedure; OracleDataReader oracleDataReader; Exception exceptionToReturn = null; try { oracleConnection.Open(); oracleDataReader = oracleCommand.ExecuteReader(); while (oracleDataReader.Read()) { SemesterLog semesterLog = new SemesterLog(); semesterLog = Mapping(oracleDataReader); semesterLogs.Add(semesterLog); } return(exceptionToReturn); } catch (Exception exception) { exceptionToReturn = exception; return(exceptionToReturn); } } }
public Exception GetScoresBySemester(ref SemesterLog semesterLog) { using (OracleConnection oracleConnection = Connection.GetInstance().ConnectionDB()) { OracleCommand oracleCommand = new OracleCommand(); oracleCommand.Connection = oracleConnection; oracleCommand.CommandText = "PACK_SCORE.GET_SCORES_BY_SEMESTER"; oracleCommand.CommandType = CommandType.StoredProcedure; oracleCommand.Parameters.Add("SEMESTER_ID_PARAMETER", OracleDbType.Byte).Value = semesterLog.SemesterLogId; OracleDataReader oracleDataReader; Exception exceptionToReturn = null; try { oracleConnection.Open(); oracleDataReader = oracleCommand.ExecuteReader(); while (oracleDataReader.Read()) { Score score = new Score(); score = Mapping(oracleDataReader); semesterLog.Score.Add(score); } return(exceptionToReturn); } catch (Exception exception) { exceptionToReturn = exception; return(exceptionToReturn); } } }
public SemesterLog Mapping(OracleDataReader oracleDataReader) { SemesterLog semesterLog = new SemesterLog(); semesterLog.SemesterLogId = Convert.ToByte(oracleDataReader["SEMESTER_LOG_ID"]); semesterLog.Semester = Convert.ToChar(oracleDataReader["SEMESTER"]); semesterLog.Startdate = Convert.ToDateTime(oracleDataReader["STARTDATE"]); semesterLog.Enddate = Convert.ToDateTime(oracleDataReader["ENDDATE"]); semesterLog.Status = Convert.ToBoolean(oracleDataReader["STATUS"]); return(semesterLog); }
public Exception GetMattersByTeacherFilterBySemester(Teacher teacher, SemesterLog semesterLog) { return(RTeacherMatterRepository.GetInstance().GetMattersByTeacherFilterBySemester(ref teacher, semesterLog.SemesterLogId)); }
public Exception AddRTeacherMatter(Matter matter, SemesterLog semesterLog, Teacher teacher) { return(RTeacherMatterRepository.GetInstance().AddRTeacherMatter(matter.MatterId, semesterLog.SemesterLogId, teacher.TeacherId)); }
public Exception GetReviewsBySemester(ref SemesterLog semesterLog) { return(ReviewRepository.GetInstance().GetReviewsBySemester(ref semesterLog)); }
public Exception GetScoresBySemester(ref SemesterLog semesterLog) { return(ScoreRepository.GetInstance().GetScoresBySemester(ref semesterLog)); }