public JsonResult Assessment(int termId)
{
string studentId = User.Identity.GetUserId();
bool Submited_flag;
try
{
var check = db.AspNetStudent_Term_Assessment.Where(x => x.TermID == termId && x.StudentID == StudentID && x.Status == "Principle_submit").Select(x => x.Id).ToList();
if (check.Count == 0)
{
Submited_flag = false;
}
else
{
Submited_flag = true;
}
}
catch (Exception ex)
{
Submited_flag = false;
}
Student_data Assessment_DATA = new Student_data();
Assessment_DATA.assessment_data = new List <subject>();
if (Submited_flag)
{
var STAID = db.AspNetStudent_Term_Assessment.Where(x => x.TermID == termId && x.StudentID == StudentID).Select(x => x.Id).ToList();
Assessment_DATA.PrincipleComment = db.AspNetStudent_Term_Assessment.Where(x => x.TermID == termId && x.StudentID == StudentID).Select(x => x.PrincipalComments).FirstOrDefault();
var catageory = db.AspNetStudent_Term_Assessments_Answers.Where(x => x.AspNetStudent_Term_Assessment.TermID == termId && x.AspNetStudent_Term_Assessment.StudentID == StudentID).Select(x => x.Catageory).Distinct().ToList();
foreach (var item in STAID)
{
subject Subject = new subject();
Subject.SubjectName = db.AspNetStudent_Term_Assessments_Answers.Where(x => x.STAID == item).Select(x => x.AspNetStudent_Term_Assessment.AspNetSubject.SubjectName).First();
Subject.TeacherComment = db.AspNetStudent_Term_Assessment.Where(x => x.Id == item).Select(x => x.TeacherComments).FirstOrDefault();
Subject.CatageoryList = new List <Catageory>();
foreach (var Catag in catageory)
{
Catageory Catageory = new Catageory();
Catageory.catageoryName = Catag;
Catageory.QuestionList = new List <Questions>();
var AQID = db.AspNetStudent_Term_Assessments_Answers.Where(x => x.STAID == item && x.Catageory == Catag).ToList();
if (AQID.Count != 0)
{
foreach (var aqid in AQID)
{
Questions question = new Questions();
question.Question = aqid.Question;
question.Answer = aqid.Answer;
Catageory.QuestionList.Add(question);
}
Subject.CatageoryList.Add(Catageory);
}
}
Assessment_DATA.assessment_data.Add(Subject);
}
}
return(Json(Assessment_DATA, JsonRequestBehavior.AllowGet));
}
public string StudentAssessment(string ChildId, int termID)
{
bool Submited_flag;
try
{
var check = db.AspNetStudent_Term_Assessment.Where(x => x.TermID == termID && x.StudentID == ChildId && x.Status == "Principle_submit").Select(x => x.Id).ToList();
if (check.Count == 0)
{
Submited_flag = false;
}
else
{
Submited_flag = true;
}
}
catch
{
Submited_flag = false;
}
Student_data Assessment_DATA = new Student_data();
Assessment_DATA.assessment_data = new List <subject>();
if (Submited_flag)
{
var STAID = db.AspNetStudent_Term_Assessment.Where(x => x.TermID == termID && x.StudentID == ChildId).Select(x => x.Id).ToList();
Assessment_DATA.PrincipleComment = db.AspNetStudent_Term_Assessment.Where(x => x.TermID == termID && x.StudentID == ChildId).Select(x => x.PrincipalComments).FirstOrDefault();
var catageory = db.AspNetStudent_Term_Assessments_Answers.Where(x => x.AspNetStudent_Term_Assessment.TermID == termID && x.AspNetStudent_Term_Assessment.StudentID == ChildId).Select(x => x.Catageory).Distinct().ToList();
foreach (var item in STAID)
{
subject Subject = new subject();
Subject.SubjectName = db.AspNetStudent_Term_Assessments_Answers.Where(x => x.STAID == item).Select(x => x.AspNetStudent_Term_Assessment.AspNetSubject.SubjectName).First();
Subject.TeacherComment = db.AspNetStudent_Term_Assessment.Where(x => x.Id == item).Select(x => x.TeacherComments).FirstOrDefault();
Subject.CatageoryList = new List <Catageory>();
foreach (var Catag in catageory)
{
Catageory Catageory = new Catageory();
Catageory.catageoryName = Catag;
Catageory.QuestionList = new List <Questions>();
var AQID = db.AspNetStudent_Term_Assessments_Answers.Where(x => x.STAID == item && x.Catageory == Catag).ToList();
if (AQID.Count != 0)
{
foreach (var aqid in AQID)
{
Questions question = new Questions();
question.Question = aqid.Question;
question.Answer = aqid.Answer;
Catageory.QuestionList.Add(question);
}
Subject.CatageoryList.Add(Catageory);
}
}
Assessment_DATA.assessment_data.Add(Subject);
}
}
var javaScriptSerializer = new
System.Web.Script.Serialization.JavaScriptSerializer();
string jsonString = javaScriptSerializer.Serialize(Assessment_DATA);
return(jsonString);
}
