public TestTranscriptRepository()
{
_studentRepository = new Dictionary <int, Transcript>();
for (int i = 0; i < 5; ++i)
{
var transcript = new Transcript();
for (int j = 0; j < 3; ++j)
{
string[] grades = { "D", "C", "B", "A" };
var term = new Term();
for (int k = 0; k < 4; ++k)
{
var course = new RegisteredCourse();
course.GpaWeight = (k != 0? k : 1);
course.GpaValue = k;
course.Grade = grades[k];
course.NumberGrade = k;
course.UnitsAttempted = 3;
course.UnitsCompleted = 3;
course.UnitsInProgress = 3;
term.Courses.Add(course);
}
term.Session = "D";
term.SessionNo = 1;
term.StartDate = DateTime.Now;
transcript.Terms.Add(term);
}
transcript.Code = "TRANS" + i;
_studentRepository.Add(i, transcript);
}
}
public ActionResult RegisteredCourse(RegisteredCourse aRegisteredCourse)
{
ViewBag.Message = aRegisteredCourseManager.Save(aRegisteredCourse);
ViewBag.RegistrationNo = aRegisteredCourseManager.GetRegistrationNo();
return(View());
}
public Transcript GetTranscript(int studentNo)
{
Transcript transcript = new Transcript();
var query = new StringBuilder();
query.AppendFormat("SELECT StudentNo, SortOrder, TermID, TermBeginDate, TranscriptCode, TermDescription ")
.AppendFormat(" , CourseCode, CourseDescription, Session, SessionNo, TranCourseCode, ClassHours, Units")
.AppendFormat(" , Grade, NumberGrade, StudentGPAValue, StudentGPAWeight, StudentUnitsInProgress ")
.AppendFormat(" , StudentUnitsAttempted, StudentUnitsCompleted, Student, CourseNo ")
.AppendFormat(" FROM vWebAcademics ")
.AppendFormat(" WHERE StudentNo={0}", studentNo)
.AppendFormat(" ORDER BY TermBeginDate ASC");
using (var reader = this.ExecuteReader(CommandType.Text, query.ToString()))
{
string prevTermId = "";
string termDescription = "";
DateTime?termStartDate = null;
var term = new Term();
while (reader.Read())
{
var course = new RegisteredCourse();
//int colIndex = -1;
course.Code = reader[6] as string;
course.ClassHours = (double)reader[11];
course.Description = reader[7] as string;
course.GpaValue = (double)reader[15];
course.GpaWeight = (double)reader[16];
course.Grade = reader[13] as string;
course.NumberGrade = (double)reader[14];
course.UnitsAttempted = (double)reader[18];
course.UnitsInProgress = (double)reader[17];
course.UnitsCompleted = (double)reader[19];
term.StudentName = reader[20] as string;
term.Courses.Add(course);
string termId = reader[2].ToString();
if (!termId.Equals(prevTermId) && prevTermId != "")
{
if (termStartDate.HasValue)
{
term.StartDate = termStartDate.Value.Date;
term.Description = termDescription;
}
// All courses have been added into the term so add it into transcript
transcript.Terms.Add(term);
// & get new instance of term to place the other courses in it
term = new Term();
}
termDescription = reader[5] as string;
termStartDate = reader[3] as DateTime?;
prevTermId = termId;
}
// Adding the last term but avoiding the addition of term in case where no rows were returned.
if (!prevTermId.Equals(""))
{
if (termStartDate.HasValue)
{
term.StartDate = termStartDate.Value.Date;
term.Description = termDescription;
}
transcript.Terms.Add(term);
}
}
return(transcript);
}
