public JsonResult EvaluationChecking_Subject(int[] Id)
{
Evaluationchecking Evaluation_checking = new Evaluationchecking();
Evaluation_checking.answer = new List<Answers>();
if (Id != null)
{
int STAA = Id[0];
int STAID = (int)db.AspNetStudent_Term_Assessments_Answers.Where(x => x.Id == STAA).Select(x => x.STAID).Single();
for (int i = 0; i < Id.Length; i++)
{
Answers Answer = new Answers();
Answer.id = Id[i];
Answer.answer = db.AspNetStudent_Term_Assessments_Answers.Where(x => x.Id == Answer.id).Select(x => x.Answer).Single();
Evaluation_checking.answer.Add(Answer);
}
Evaluation_checking.status = db.AspNetStudent_Term_Assessment.Where(x => x.Id == STAID).Select(x => x.Status).Single();
Evaluation_checking.comment = db.AspNetStudent_Term_Assessment.Where(x => x.Id == STAID).Select(x => x.TeacherComments).Single();
Evaluation_checking.PrincipleComment = db.AspNetStudent_Term_Assessment.Where(x => x.Id == STAID).Select(x => x.PrincipalComments).Single();
}
return Json(Evaluation_checking, JsonRequestBehavior.AllowGet);
}
public JsonResult EvaluationChecking_Class(int[] Id, int[] STA_ID)
{
Evaluationchecking Evaluation_checking = new Evaluationchecking();
Evaluation_checking.answer = new List<Answers>();
Evaluation_checking.Comment = new List<Comment>();
int P_Comment = 0;
if (Id != null)
P_Comment = STA_ID[0];
try
{
Evaluation_checking.PrincipleComment = db.AspNetStudent_Term_Assessment.Where(x => x.Id == P_Comment).Select(x => x.PrincipalComments).Single();
}
catch (Exception ex)
{
Evaluation_checking.PrincipleComment = "";
}
Evaluation_checking.savebtn = "false";
if (Id != null)
{
int current_term = db.AspNetTerms.Select(x => x.Id).Max();
int ID = STA_ID[0];
var StudentId = db.AspNetStudent_Term_Assessment.Where(x => x.Id == ID).Select(x => x.StudentID).First();
var STAID = db.AspNetStudent_Term_Assessment.Where(x => x.StudentID == StudentId && x.TermID == current_term).Select(x => x.Id).ToList();
int count = 0;
int submit = 0;
int Principle = 0;
foreach (var item in STAID)
{
string status = db.AspNetStudent_Term_Assessment.Where(x => x.Id == item).Select(x => x.Status).Single();
if (status == "submit" || status == "Teacher_submit" || status == "Principle_submit")
count++;
if (status == "Teacher_submit")
submit++;
if (status == "Principle_submit")
Principle++;
}
if (count == STAID.Count)
Evaluation_checking.savebtn = "true";
if (submit != 0)
Evaluation_checking.savebtn = "submit";
if (Principle != 0)
Evaluation_checking.savebtn = "Teacher_submit";
for (int i = 0; i < STA_ID.Length; i++)
{
Comment Comment = new Comment();
Comment.id = STA_ID[i];
Comment.comment = db.AspNetStudent_Term_Assessment.Where(x => x.Id == Comment.id).Select(x => x.TeacherComments).Single();
Evaluation_checking.Comment.Add(Comment);
}
for (int i = 0; i < Id.Length; i++)
{
Answers Answer = new Answers();
Answer.id = Id[i];
Answer.answer = db.AspNetStudent_Term_Assessments_Answers.Where(x => x.Id == Answer.id).Select(x => x.Answer).Single();
Evaluation_checking.answer.Add(Answer);
}
}
return Json(Evaluation_checking, JsonRequestBehavior.AllowGet);
}
