public EvaluateStudentModel LoadDataEvaluateStudent(int idClassroom, int idStudent)
{
appEvaluateStudent = new EvaluateStudentApplication();
EvaluateStudentModel evaluateStudentModel = new EvaluateStudentModel();
evaluateStudentModel.ClassroomModel = new ClassroomModel();
evaluateStudentModel.StudentModel = new StudentModel();
evaluateStudentModel.listEvaluateStudentGrade = new List <EvaluateStudentGrade>();
try
{
foreach (DataRow linha in appEvaluateStudent.QuerieEvaluateStudentGrade(idClassroom, idStudent).Rows)
{
if (!linha["idClassroom"].ToString().Equals(""))
{
if (!linha["idEvaluateStudent"].ToString().Equals(""))
{
evaluateStudentModel.idEvaluateStudent = Convert.ToInt32(linha["idEvaluateStudent"]);
}
evaluateStudentModel.idClassroom = Convert.ToInt32(linha["idClassroom"]);
evaluateStudentModel.ClassroomModel.nameClassroom = Convert.ToString(linha["nameClassroom"]);
evaluateStudentModel.idStudent = Convert.ToInt32(linha["idStudent"]);
evaluateStudentModel.StudentModel.registrationNumber = Convert.ToString(linha["registrationNumber"]);
evaluateStudentModel.StudentModel.nameStudent = Convert.ToString(linha["nameStudent"]);
}
else
{
EvaluateStudentGrade obj = new EvaluateStudentGrade();
obj.TeachingPlan = new TeachingPlan();
obj.idTeachingPlan = Convert.ToInt32(linha["idTeachingPlan"]);
obj.TeachingPlan.activityDescription = Convert.ToString(linha["activityDescription"]);
if (!linha["grade"].ToString().Equals(""))
{
obj.grade = Convert.ToDecimal(linha["grade"]);
}
evaluateStudentModel.listEvaluateStudentGrade.Add(obj);
}
}
return(evaluateStudentModel);
}
catch (Exception)
{
throw;
}
}
public EvaluateStudentModel LoadDataEvaluateClassroom(int idClassroom)
{
appEvaluateStudent = new EvaluateStudentApplication();
EvaluateStudentModel evaluateStudentModel = new EvaluateStudentModel();
evaluateStudentModel.ClassroomModel = new ClassroomModel();
evaluateStudentModel.listEvaluateStudentModel = new List <EvaluateStudentModel>();
EvaluateStudentModel obj = new EvaluateStudentModel();
try
{
foreach (DataRow linha in appEvaluateStudent.QuerieDataEvaluateStudentReport(idClassroom).Rows)
{
if (!linha["idClassroom"].ToString().Equals(""))
{
evaluateStudentModel.idClassroom = Convert.ToInt32(linha["idClassroom"]);
evaluateStudentModel.ClassroomModel.nameClassroom = Convert.ToString(linha["nameClassroom"]);
}
else if (!linha["idStudent"].ToString().Equals(""))
{
if (!linha["registrationNumber"].ToString().Equals(""))
{
if (obj.listEvaluateStudentGrade != null && obj.listEvaluateStudentGrade.Count > 0)
{
evaluateStudentModel.listEvaluateStudentModel.Add(obj);
}
obj = new EvaluateStudentModel();
obj.StudentModel = new StudentModel();
obj.listEvaluateStudentGrade = new List <EvaluateStudentGrade>();
obj.idStudent = Convert.ToInt32(linha["idStudent"]);
obj.StudentModel.registrationNumber = Convert.ToString(linha["registrationNumber"]);
obj.StudentModel.nameStudent = Convert.ToString(linha["nameStudent"]);
if (!linha["countGrade"].ToString().Equals(""))
{
int countGrade = Convert.ToInt32(linha["countGrade"]);
int countTeachingPlan = Convert.ToInt32(linha["countTeachingPlan"]);
obj.percEvaluateModel = countGrade * 100 / countTeachingPlan;
}
}
else
{
EvaluateStudentGrade evaluateStudentGrade = new EvaluateStudentGrade();
evaluateStudentGrade.TeachingPlan = new TeachingPlan();
evaluateStudentGrade.idTeachingPlan = Convert.ToInt32(linha["idTeachingPlan"]);
evaluateStudentGrade.TeachingPlan.activityDescription = Convert.ToString(linha["activityDescription"]);
if (!linha["grade"].ToString().Equals(""))
{
evaluateStudentGrade.grade = Convert.ToDecimal(linha["grade"]);
}
obj.listEvaluateStudentGrade.Add(evaluateStudentGrade);
}
}
}
if (evaluateStudentModel.idClassroom > 0)
{
evaluateStudentModel.listEvaluateStudentModel.Add(obj);
}
return(evaluateStudentModel);
}
catch (Exception)
{
throw;
}
}
