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 ActionResult ApplyEvaluation(EvaluateStudentModel form)
{
string msgReturn = "";
appEvaluateStudent = new EvaluateStudentApplication();
try
{
form.evaluationDate = DateTime.Now;
//First Evaluation
if (form.idEvaluateStudent == 0)
{
msgReturn = appEvaluateStudent.InsertEvaluateStudent(form);
}
//More Evaluation
else
{
msgReturn = appEvaluateStudent.UpdateEvaluateStudent(form);
}
int number;
bool result = int.TryParse(msgReturn, out number);
if (result)
{
ViewBag.MessageType = MessageType.Success;
ViewBag.Message = Message.SuccessEvaluate;
}
else
{
ViewBag.MessageType = MessageType.Error;
ViewBag.Message = Message.ErrorUnknown;
}
return(Json(new { msg = ViewBag.Message, type = ViewBag.MessageType }, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
throw;
}
}
public List <EvaluateStudentModel> ListEvaluateStudent(int idClassroom)
{
appEvaluateStudent = new EvaluateStudentApplication();
List <EvaluateStudentModel> listEvaluateStudentModel = new List <EvaluateStudentModel>();
try
{
foreach (DataRow linha in appEvaluateStudent.QuerieEvaluateStudent(idClassroom).Rows)
{
EvaluateStudentModel obj = new EvaluateStudentModel();
obj.ClassroomModel = new ClassroomModel();
obj.ClassroomModel.ClassroomStudent = new ClassroomStudent();
obj.ClassroomModel.ClassroomStudent.Student = new Student();
obj.idClassroom = Convert.ToInt32(linha["idClassroom"]);
obj.idStudent = Convert.ToInt32(linha["idStudent"]);
obj.ClassroomModel.nameClassroom = Convert.ToString(linha["nameClassroom"]);
obj.ClassroomModel.ClassroomStudent.Student.registrationNumber = Convert.ToString(linha["registrationNumber"]);
obj.ClassroomModel.ClassroomStudent.Student.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;
}
listEvaluateStudentModel.Add(obj);
}
return(listEvaluateStudentModel);
}
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;
}
}
