public List <StudentMark> Tabulation(object yearId, object classId, object sectionId)
{
var YCSId = new YearClassSectionTable(db).GetYearClassSectionId(yearId, classId, sectionId);
return(db.Query("getMarkByYCSId", new Dictionary <string, object> {
{ "YCSID", YCSId }
}, true).
Select(x => new StudentMark {
Student = new Student {
FirstName = x["firstname"],
LastName = x["lastname"],
ID = x["studentid"],
Roll = int.Parse(x["roll"])
},
Mark = x["mark"],
MarkId = x["markdi"],
PortionId = x["portionId"],
PortionName = x["portionname"],
PortionPercentage = x["portionpercentage"],
Subject = new Subject {
Name = x["subject"],
ID = x["subjectid"],
SubjectCode = x["subjectcode"],
TotalMark = int.Parse(x["totalmark"])
}.ToString(),
Term = x["term"],
TermId = x["termid"]
}).ToList());
}
public TermYearClassSectionTable(MySQLDatabase database)
{
db = database;
YCSTable = new YearClassSectionTable(db);
}
public TeacherSubjectTable(MySQLDatabase database)
{
db = database;
yearClassSectionTable = new YearClassSectionTable(db);
}