public ActionResult GetSubjectwiseResult(int subjectId, int classId)
{
var students = db.Students.Where(i => i.SchoolClassId == classId).ToList();
var viewModel = new AddResultBySubject();
viewModel.Students = students;
viewModel.ClassId = classId;
viewModel.SubjectId = subjectId;
return(PartialView("_AddResultBySubject", viewModel));
}
public ActionResult AddResultBySubject(int SchoolId)
{
ViewBag.ClassList = new SelectList(db.SchoolClasses.Where(i => i.SchoolId == SchoolId), "Id", "Name");
var vModel = new AddResultBySubject()
{
SchoolId = SchoolId
};
return(View(vModel));
}
public ActionResult AddResultBySubject(AddResultBySubject viewModel, FormCollection form)
{
ViewBag.ClassList = new SelectList(db.SchoolClasses.Where(i => i.SchoolId == viewModel.SchoolId), "Id", "Name");
var students = db.Students.Where(i => i.SchoolClassId == viewModel.ClassId).ToList();
foreach (var student in students)
{
var grade = form["Grade_" + student.Id].ToString();
var markString = form["Mark_" + student.Id].ToString();
double mark = 0.0;
double.TryParse(markString, out mark);
var result = new Result()
{
ClassId = viewModel.ClassId, Grade = grade, MarkPercentage = mark, SchoolId = viewModel.SchoolId, StudentId = student.Id, SubjectId = viewModel.SubjectId
};
db.Results.Add(result);
}
db.SaveChanges();
return(View());
}