public ActionResult _GetCandidateEvaluationForm(int interviewid, int employeeid) { var interviewevaluation = new InterviewEvaluation(); using (var db = new TalentContext()) { var categories = db.EvaluationCategories.Where(x => x.InterviewID == interviewid).ToList(); var dictionary = new Dictionary <string, string>(); foreach (var item in categories) { dictionary[item.EvaluationCode] = item.EvaluationDescription; } ViewBag.Dictionary = dictionary; var existinginterviewevaluation = db.InterviewEvaluations.Where(x => x.InterviewID == interviewid && x.EmployeeID == employeeid); if (existinginterviewevaluation.Any()) { interviewevaluation = existinginterviewevaluation.FirstOrDefault(); } else { int count = db.InterviewEvaluations.Where(x => x.InterviewID == interviewevaluation.InterviewID).Count(); interviewevaluation.EvaluationNo = "TR" + String.Format("{0:D6}", interviewid + count + 6); interviewevaluation.EmployeeID = employeeid; interviewevaluation.InterviewID = interviewid; interviewevaluation.StageID = 1; } } return(PartialView(interviewevaluation)); }
public JsonResult _SubmitInterviewSchedulingForm(Interview data) { bool action = false; if (ModelState.IsValid) { using (var db = new TalentContext()) { var interview = db.Interviews.Find(data.InterviewID); interview.SchedulingFinalNote = data.SchedulingFinalNote; interview.ScheduledDate = data.ScheduledDate; interview.Venue = data.Venue; interview.Time = data.Time; db.Entry(interview).State = System.Data.Entity.EntityState.Modified; //db.Interviews.Add(interview); db.SaveChanges(); var interviewdetail = db.InterviewDetails.Where(o => o.Interview.InterviewID == interview.InterviewID).FirstOrDefault(); var interviewevaluations = new List <InterviewEvaluation>(); int[] employeeids = new int[4] { interviewdetail.TeamMember1ID, interviewdetail.TeamMember2ID, interviewdetail.TeamMember3ID, interviewdetail.TeamMember4ID }; int count = 5; foreach (var item in employeeids) { var tempeval = new InterviewEvaluation { EvaluationNo = "TR" + String.Format("{0:D6}", data.InterviewID + count), InterviewID = data.InterviewID, EmployeeID = item }; interviewevaluations.Add(tempeval); count++; } db.InterviewEvaluations.AddRange(interviewevaluations); db.SaveChanges(); //message interview Team Members } action = true; } return(Json(action, JsonRequestBehavior.AllowGet)); }
public ActionResult _SubmitCandidateEvaluationForm(InterviewEvaluation interviewevaluation, List <Evaluation> evaluations) { if (ModelState.IsValid) { using (var db = new TalentContext()) { foreach (var evaluation in evaluations) { if (evaluation.ID == 0) { db.Evaluations.Add(evaluation); } else { db.Evaluations.Add(evaluation); db.Entry(evaluation).State = System.Data.Entity.EntityState.Modified; } db.SaveChanges(); } // interviewevaluation.EvaluationNo = "TR" + String.Format("{0:D6}", interviewid + db.InterviewEvaluations.Where(x => x.InterviewID == interviewevaluation.InterviewID).Count()); if (interviewevaluation.ID == 0) { db.InterviewEvaluations.Add(interviewevaluation); db.SaveChanges(); } else { db.Entry(interviewevaluation).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } // return PartialView("_getcandidateevaluationform",interviewevaluation); return(RedirectToAction("_getcandidateevaluationform", "Application", new { interviewid = interviewevaluation.InterviewID, employeeid = interviewevaluation.EmployeeID, status = "successful" })); // return RedirectToAction("Dashboard", "Admin"); } // return PartialView(interviewevaluation); return(RedirectToAction("_getcandidateevaluationform", "Application", new { interviewid = interviewevaluation.InterviewID, employeeid = interviewevaluation.EmployeeID })); }
public ActionResult _GetCandidateEvaluationForm(int interviewid, int employeeid, string status) { var interviewevaluation = new InterviewEvaluation(); var dictionary = new Dictionary <string, int>(); using (var db = new TalentContext()) { var categories = db.EvaluationCategories.Where(x => x.InterviewID == interviewid).ToList(); var interview = db.Interviews.Find(interviewid); var officeid = interview.OfficePositionID; ViewBag.OfficeID = officeid; var evaluationss = db.ApplicantEvaluationMetrics.Where(x => x.OfficePositionID == officeid); ViewBag.JobDetails = evaluationss.FirstOrDefault().OfficePosition.Title; foreach (var item in evaluationss) { dictionary[item.EvaluationCode] = item.MaximumScore; } var existinginterviewevaluation = db.InterviewEvaluations.Where(x => x.InterviewID == interviewid && x.EmployeeID == employeeid); if (existinginterviewevaluation.Any()) { interviewevaluation = existinginterviewevaluation.FirstOrDefault(); } else { int count = db.InterviewEvaluations.Where(x => x.InterviewID == interviewevaluation.InterviewID).Count(); interviewevaluation.EvaluationNo = "TR" + String.Format("{0:D6}", interviewid + count + 6); interviewevaluation.EmployeeID = employeeid; interviewevaluation.InterviewID = interviewid; interviewevaluation.StageID = 1; } } ViewBag.Status = false; if (status == "success") { ViewBag.Message = "Successfully Saved Evaluation"; ViewBag.Status = true; } ViewBag.Dictionary = dictionary; return(PartialView(interviewevaluation)); }
public ActionResult _GetCandidateEvaluationForm(int interviewid, int employeeid) { var interviewevaluation = new InterviewEvaluation(); using (var db = new TalentContext()) { var existinginterviewevaluation = db.InterviewEvaluations.Where(x => x.InterviewID == interviewid && x.EmployeeID == employeeid); if (existinginterviewevaluation.Any()) { interviewevaluation = existinginterviewevaluation.FirstOrDefault(); } else { int count = db.InterviewEvaluations.Where(x => x.InterviewID == interviewevaluation.InterviewID).Count(); interviewevaluation.EvaluationNo = "TR" + String.Format("{0:D6}", interviewid + count + 6); interviewevaluation.EmployeeID = employeeid; interviewevaluation.InterviewID = interviewid; interviewevaluation.StageID = 1; } } return(PartialView(interviewevaluation)); }