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