//Add candidate feedback for position public void addcandidatefeedbackposition(candidatefeedback CF) { using (RecrutmentsysEntities db = new RecrutmentsysEntities()) { CANDIDATE_POSITION cp = db.CANDIDATE_POSITION.Where(o => o.CandidateCode == CF.candidatecode).FirstOrDefault(); CANDIDATE_FEEDBACK_POSITION cfp = new CANDIDATE_FEEDBACK_POSITION(); cfp.CandidateCode = cp.CandidateCode; cfp.CandidateEmail = cp.CandidateEmail; cfp.Candidate_Yof_exp = cp.Candidate_Yof_exp; cfp.CompanyId = cp.CompanyId; cfp.DepartmentCode = cp.DepartmentCode; COMPANY_JOB_OPENING cjo = db.COMPANY_JOB_OPENING.Where(o => o.DepartmentCode == cp.DepartmentCode).FirstOrDefault(); cfp.DepartmentName = cjo.DepartmentName; cfp.RequestedBy = cjo.RequestedBy; cfp.HrId = cjo.HrId; cfp.HrEmail = cjo.HrEmail; cfp.Name_of_Vacancy = cjo.Name_of_Vacancy; cfp.Number_of_Position = cjo.Number_of_Position; cfp.Required_Technical_Skill = cjo.Required_Technical_Skill; cfp.Special_Technical_Skill = cjo.Special_Technical_Skill; cfp.Min_Yearof_Experience = cjo.Min_Yearof_Experience; cfp.Min_Qualification = cjo.Min_Qualification; cfp.Deadline_Date = cjo.Deadline_Date; cfp.Requested_Date = cjo.Requested_Date; cfp.RoundingPercentage = CF.rounding_percent; cfp.OfferLatter = "No"; cfp.Feedbackprocess = false; db.CANDIDATE_FEEDBACK_POSITION.Add(cfp); db.SaveChanges(); Round_Detail_feedback rdf = new Round_Detail_feedback(); rdf.CompanyId = cfp.CompanyId; rdf.CandidateCode = cfp.CandidateCode; rdf.DepartmentCode = cfp.DepartmentCode; rdf.HrId = cfp.HrId; rdf.RoundOne = CF.round1; rdf.RoundOne_per = CF.round1P; rdf.RoundTwo = CF.round2; rdf.RoundTwo_per = CF.round2P; rdf.RoundThree = CF.round3; rdf.RoundThree_per = CF.round3P; rdf.totalround_per = CF.rounding_percent; db.Round_Detail_feedback.Add(rdf); db.SaveChanges(); CANDIDATE_POSITION canp = db.CANDIDATE_POSITION.Find(cp.CandidateId); canp.ISActive = false; db.SaveChanges(); } }
public ActionResult AddCandidateFeedback() { string loginname = HttpContext.User.Identity.Name; RecrutmentsysEntities db = new RecrutmentsysEntities(); var id = db.COMPANY_HR_REGISTER.Where(o => o.HrEmail == loginname); int hrid = id.FirstOrDefault().HrId; List <CANDIDATE_POSITION> CNP = (from data in db.CANDIDATE_POSITION where data.HrId == hrid && data.ISActive == true select data).ToList(); CANDIDATE_POSITION CANP = new CANDIDATE_POSITION(); CANP.CandidateCode = "Select"; CNP.Insert(0, CANP); SelectList Obj = new SelectList(CNP, "CandidateCode", "CandidateCode", 0); candidatefeedback addcanfeedback = new candidatefeedback(); addcanfeedback.candicode = Obj; return(View(addcanfeedback)); }
public ActionResult AddCandidateFeedback(candidatefeedback cfb) { //string loginname = HttpContext.User.Identity.Name; //RecrutmentsysEntities db = new RecrutmentsysEntities(); //var id = db.COMPANY_HR_REGISTER.Where(o => o.HrEmail == loginname); //int hrid = id.FirstOrDefault().HrId; //List<CANDIDATE_POSITION> CNP = (from data in db.CANDIDATE_POSITION // where data.HrId == hrid && data.ISActive == true // select data).ToList(); //CANDIDATE_POSITION CANP = new CANDIDATE_POSITION(); //CANP.CandidateCode = "Select"; //CNP.Insert(0, CANP); //SelectList Obj = new SelectList(CNP, "CandidateCode", "CandidateCode", 0); feedbackselect(); candidatefeedback addcanfeedback = new candidatefeedback(); addcanfeedback.candicode = ViewBag.obj; if (ModelState.IsValid) { if (cfb.candidatecode == "Select") { ModelState.AddModelError("", "Please select First"); return(View(addcanfeedback)); } else { UserManager UM = new UserManager(); UM.addcandidatefeedbackposition(cfb); ModelState.Clear(); TempData["msg"] = "Insert successfully"; feedbackselect(); addcanfeedback.candicode = ViewBag.obj; } } return(View(addcanfeedback)); }
public List <candidatefeedback> getoffer(string Loginname) { List <candidatefeedback> offerforcandi = new List <candidatefeedback>(); using (RecrutmentsysEntities db = new RecrutmentsysEntities()) { var id = db.COMPANY_REGISTER_REFRENCES.Where(o => o.CompanyEmailRef == Loginname); int compid = Convert.ToInt32(id.FirstOrDefault().CompanyId); var listusers = (from cjo in db.CANDIDATE_FEEDBACK_POSITION join rdf in db.Round_Detail_feedback on cjo.CandidateCode equals rdf.CandidateCode where cjo.CompanyId == compid select new { cjo.CandidateCode, cjo.DepartmentCode, cjo.CandidateEmail, cjo.Candidate_Yof_exp, cjo.DepartmentName, cjo.Name_of_Vacancy, cjo.Number_of_Position, cjo.Required_Technical_Skill, cjo.Special_Technical_Skill, cjo.Min_Qualification, cjo.Min_Yearof_Experience, cjo.Deadline_Date, rdf.RoundOne, rdf.RoundOne_per, rdf.RoundTwo, rdf.RoundTwo_per, rdf.RoundThree, rdf.RoundThree_per, rdf.totalround_per }).ToList(); if (listusers != null) { candidatefeedback cf; foreach (var i in listusers) { cf = new candidatefeedback(); cf.candidatecode = i.CandidateCode; cf.candidateemail = i.CandidateEmail; cf.yerofexperience = Convert.ToString(i.Candidate_Yof_exp); cf.Depetcode = i.DepartmentCode; cf.Departmentname = i.DepartmentName; cf.nameofvacancy = i.Name_of_Vacancy; cf.numberofpostion = i.Number_of_Position; cf.reqtechnicalskill = i.Required_Technical_Skill; cf.specialskill = i.Special_Technical_Skill; cf.minyerofexp = Convert.ToString(i.Min_Yearof_Experience); cf.minqualifi = i.Min_Qualification; cf.deadlinedate = Convert.ToString(i.Deadline_Date); cf.round1 = i.RoundOne; cf.round1P = Convert.ToInt32(i.RoundOne_per); cf.round2 = i.RoundTwo; cf.round2P = Convert.ToInt32(i.RoundTwo_per); cf.round3 = i.RoundThree; cf.round3P = Convert.ToInt32(i.RoundThree_per); cf.rounding_percent = Convert.ToInt32(i.totalround_per); offerforcandi.Add(cf); } } } return(offerforcandi); }