/// <summary>
/// Add a new term to given YearClassSection with given percentage
/// </summary>
/// <param name="termId">Id of term to be added</param>
/// <param name="yearId">Id of corresponding year entry</param>
/// <param name="classId">Id of corresponding class entry</param>
/// <param name="sectionId">Id of corresponding section entry</param>
/// <param name="percentage">percentage of mark of given term that will contribute in final result</param>
/// <returns>Number of entries added</returns>
public int AddTermYearClassSection(string termId, string yearId, string classId, string sectionId, string percentage)
{
return(AddTermYearClassSection(
Convert.ToInt32(termId),
YCSTable.GetYearClassSectionId(yearId, classId, sectionId),
Convert.ToInt32(percentage)
));
}
public List <Student> GetStudents(object yearId, object classId, object sectionId)
{
var YCSId = YCSTable.GetYearClassSectionId(yearId, classId, sectionId);
return(db.Query("getStudentByYCSId", new Dictionary <string, object>()
{
{ "@YCSId", YCSId }
}, true).
Select(x => new Student {
FirstName = x["firstname"],
LastName = x["lastname"],
Roll = int.Parse(x["roll"]),
ID = x["studentid"]
}).ToList());
}
/// <summary>
/// Add a new teacherSubject entry
/// </summary>
/// <param name="teacherId">Id of correspondint teacher</param>
/// <param name="subjectId">Id of correspondint subject</param>
/// <param name="yearId">Id of corresponding year entry</param>
/// <param name="classId">Id of corresponding class entry</param>
/// <param name="sectionId">Id of corresponding section entry</param>
/// <returns>Id of newly added teacherSubject entry</returns>
public int AddTeacherSubject(object teacherId, object subjectId, object yearId, object classId, object sectionId)
{
return(AddTeacherSubject(teacherId, subjectId, yearClassSectionTable.GetYearClassSectionId(yearId, classId, sectionId)));
}