// private TADEDBEntities db = new TADEDBEntities(); // GET: ExamResults public ActionResult ExamResultWithGrade() { if (Session["CandidateId"] == null) { return(RedirectToAction("Index", "Home")); } int CandidateId = Convert.ToInt32(Session["CandidateId"]); var jsobj = TD.ExamResults.Include(e => e.CandidateDetail).Include(e => e.ExamType).Where(r => r.CandidateId == CandidateId).Select(x => new { FirstName = x.CandidateDetail.FirstName, MiddleName = x.CandidateDetail.MiddleName, LastName = x.CandidateDetail.LastName, Email = x.CandidateDetail.Email, Date = x.Date, IPAddress = x.CandidateDetail.IPAddress, ExamId = x.CandidateDetail.ExamId, DateOfBirth = x.CandidateDetail.DateOfBirth, DrivingLicense = x.CandidateDetail.DrivingLicenseNumber, Address = x.CandidateDetail.AddressLine1 + "<br />" + x.CandidateDetail.AddressLine2 + "<br />" + x.CandidateDetail.AddressLine3 + "<br />" + x.CandidateDetail.PostCode, TotalScore = x.Score, Grade = x.Grade, Explanation = x.Explanation }).ToList(); DrivingTestResult DR = new Models.DrivingTestResult(); DR.Date = jsobj[0].Date; DR.IPAddress = jsobj[0].IPAddress; DR.ExamId = Convert.ToInt32(jsobj[0].ExamId); DR.DateOfBirth = jsobj[0].DateOfBirth; DR.FirstName = jsobj[0].FirstName; DR.MiddleName = jsobj[0].MiddleName; DR.LastName = jsobj[0].LastName; DR.Email = jsobj[0].Email; DR.Address = jsobj[0].Address; DR.DrivingLicense = jsobj[0].DrivingLicense; DR.Explanation = jsobj[0].Explanation; DR.TotalScore = 0; DR.Grade = 0; foreach (var item in jsobj) { DR.TotalScore = DR.TotalScore + item.TotalScore; DR.Grade = DR.Grade + item.Grade; } SendMail(DR); TADEDBEntities candUpd = new TADEDBEntities(); CandidateDetail cd = candUpd.CandidateDetails.Find(CandidateId); cd.Status = false; cd.ExamAttended = true; candUpd.Entry(cd).State = EntityState.Modified; candUpd.SaveChanges(); Session["CandidateId"] = null; return(View(DR)); }