public ActionResult Create([Bind(Include = "TestimonialId,CandidateId,Name,Title,Description,AddedDate")] Testimonial testimonial)
{
if (ModelState.IsValid)
{
testimonial.CandidateId = Convert.ToInt32(Session["CandidateId"]);
testimonial.AddedDate = DateTime.Now;
db.Testimonials.Add(testimonial);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CandidateId = new SelectList(db.CandidateDetails, "CandidateId", "Email", testimonial.CandidateId);
return(View(testimonial));
}
public ActionResult Create([Bind(Include = "Title,NewsScreenshotPath,SourceLink")] LatestNew latestNew)
{
if (ModelState.IsValid)
{
latestNew.UserId = Convert.ToString(Session["Administrator"]);
latestNew.DateAdded = DateTime.Now;
db.LatestNews.Add(latestNew);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.UserId = new SelectList(db.AspNetUsers, "Id", "Email", latestNew.UserId);
return(View(latestNew));
}
public bool SaveCandidateverification([Bind(Include = "CandidateId,Photo,DrivingLicense,FrontCamera,Microphone,BackCamera,LipMovement")] CandidateVerification candidateVerification)
{
// int candidateId = Convert.ToInt32(ViewBag.CandidateId);
// candidateVerification.CandidateId = candidateId;
try
{
// candidateVerification.CandidateId = CandidateId;
int examinerId = Convert.ToInt32(Session["ExaminerId"]);
candidateVerification.VerifiedBy = examinerId;
candidateVerification.VerifiedOn = DateTime.Now;
if (candidateVerification.Photo == true && candidateVerification.DrivingLicense == true && candidateVerification.FrontCamera == true && candidateVerification.Microphone == true && candidateVerification.BackCamera == true && candidateVerification.LipMovement == true)
{
candidateVerification.EligibleForStartExam = true;
}
else
{
candidateVerification.EligibleForStartExam = false;
}
db.CandidateVerifications.Add(candidateVerification);
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
// 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));
}
