public ActionResult ExperienceDetail(int candidateId) { CandidateProfessional candidate = db.CandidateProfessional.Single(c => c.candidateId == candidateId); Area area = db.Areas.Single(a => a.area_id == candidate.areaId); ViewBag.Area = area.area_name; return(View(candidate)); }
public ActionResult ExperienceEdit(CandidateProfessional canditate) { if (ModelState.IsValid) { int catId; catId = Convert.ToInt32(canditate.industry); var selectedIndustry = db.Categories.Single(i => i.category_id == catId); canditate.industry = selectedIndustry.category_name; db.Entry(canditate).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(RedirectToAction("ExperienceDetail", new { candidateId = canditate.candidateId })); } ViewBag.industry = new SelectList(db.Categories, "category_id", "category_name"); ViewBag.areaId = new SelectList(db.Areas, "area_id", "area_name"); return(View()); }
public ActionResult NewJobSeeker(JobSeeker jobSeeker) { if (ModelState.IsValid) { //insert into users - populate user fields User newUser = new User(); newUser.username = jobSeeker.username; newUser.password = jobSeeker.password; newUser.role = "jobseeker"; db.Users.Add(newUser); db.SaveChanges(); //insert into Candidate Basic CandidateBasic candidateBasic = new CandidateBasic(); //code to copy data from jobSeeker to candidateBasic candidateBasic.username = jobSeeker.username; candidateBasic.quesId = jobSeeker.Question; candidateBasic.ansr = jobSeeker.Answer; candidateBasic.profileDate = System.DateTime.Now; candidateBasic.firstName = jobSeeker.firstName; candidateBasic.lastName = jobSeeker.lastName; candidateBasic.candidateAddr = jobSeeker.candidateAddr; candidateBasic.city = jobSeeker.city; candidateBasic.gender = jobSeeker.gender; candidateBasic.dob = jobSeeker.dob; candidateBasic.contactNo = jobSeeker.contactNo; candidateBasic.emailId = jobSeeker.emailId; db.CandidateBasic.Add(candidateBasic); int newCandidateId = candidateBasic.candidateId; //insert into Candidate Education CandidateEducation candidateEducation = new CandidateEducation(); //code to copy data from jobSeeker to candidateEducation candidateEducation.candidateId = newCandidateId; candidateEducation.aLevelSubject1 = jobSeeker.aLevelSubject1; candidateEducation.aLevelSubject2 = jobSeeker.aLevelSubject2; candidateEducation.aLevelSubject3 = jobSeeker.aLevelSubject3; candidateEducation.aLevelGrade1 = jobSeeker.aLevelGrade1; candidateEducation.aLevelGrade2 = jobSeeker.aLevelGrade2; candidateEducation.aLevelGrade3 = jobSeeker.aLevelGrade3; candidateEducation.graduation = jobSeeker.graduation; candidateEducation.instituteGrad = jobSeeker.instituteGrad; candidateEducation.percentageGrad = jobSeeker.percentageGrad; candidateEducation.postGrad = jobSeeker.postGrad; candidateEducation.institutePostGrad = jobSeeker.institutePostGrad; candidateEducation.percentagePostGrad = jobSeeker.percentagePostGrad; candidateEducation.certification = jobSeeker.certification; db.CandidateEducation.Add(candidateEducation); //insert into Candidate Profiessional CandidateProfessional candidateProfessional = new CandidateProfessional(); //code to copy data from jobSeeker to candidateProfessional candidateProfessional.candidateId = newCandidateId; int catId; catId = Convert.ToInt32(jobSeeker.industry); var selectedIndustry = db.Categories.Single(i => i.category_id == catId); candidateProfessional.industry = selectedIndustry.category_name; candidateProfessional.industryRole = jobSeeker.industryRole; candidateProfessional.skills = jobSeeker.skills; candidateProfessional.areaId = Convert.ToInt32(jobSeeker.Area); db.CandidateProfessional.Add(candidateProfessional); //commit changes to database db.SaveChanges(); //store user name and role in session cookies and redirect to recruiter index page Session["UserName"] = jobSeeker.username; Session["UserRole"] = "jobseeker"; return(RedirectToAction("Index", "JobSeeker", new { area = "JobSeeker" })); } ViewBag.Question = new SelectList(db.Questions, "quesId", "ques"); ViewBag.industry = new SelectList(db.Categories, "category_id", "category_name"); return(View()); }