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