public List <StudentScoreDetail> getStudentScoreList(int groupId, int assignmentId)
{
studentScore.Clear();
int retVal = 0;
DataSet ds = Sqlite.ExecuteSQLStatement(Query.getStudentGradeBygidaid(groupId, assignmentId), ref retVal);
for (int i = 0; i < retVal; i++)
{
StudentScoreDetail Temp = new StudentScoreDetail();
//group ID
if (int.TryParse(ds.Tables[0].Rows[i].ItemArray[0].ToString(), out int gid))
{
Temp.groupId = gid;
}
if (int.TryParse(ds.Tables[0].Rows[i].ItemArray[1].ToString(), out int aid))
{
Temp.assignmentId = aid;
}
if (int.TryParse(ds.Tables[0].Rows[i].ItemArray[2].ToString(), out int sid))
{
Temp.studentId = sid;
}
//student name
Temp.FirstName = ds.Tables[0].Rows[i].ItemArray[3].ToString();
//student name
Temp.LastName = ds.Tables[0].Rows[i].ItemArray[4].ToString();
//grade
if (int.TryParse(ds.Tables[0].Rows[i].ItemArray[5].ToString(), out int grade))
{
Temp.grade = grade;
}
if (int.TryParse(ds.Tables[0].Rows[i].ItemArray[6].ToString(), out int gIndex))
{
Temp.gradeIndex = gIndex;
}
//add to list
studentScore.Add(Temp);
}
return(studentScore);
}
