public static void AddEducationDetails(CandidateModel candidate) { SqlConnection con = DBUtils.getDBConnection(); con.Open(); candidate.newUgQualification = getQualificationsNameToId()[candidate.newUgQualification]; candidate.newPgQualification = getQualificationsNameToId()[candidate.newPgQualification]; String query = ""; string graduation =""; string postGraduation = ""; SqlCommand command = new SqlCommand("select graduation, post_graduation from dbo.Applicant where candidate_id = " + candidate.user_id + ";" , con); SqlDataReader reader = command.ExecuteReader(); if (reader.Read()) { try { graduation = reader.GetString(0); } catch (Exception) { graduation = ""; } try { postGraduation = reader.GetString(1); } catch (Exception) { postGraduation = ""; } } reader.Close(); if (graduation.Equals("") && !candidate.newUgQualification.Equals("0")) { graduation = candidate.newUgQualification; } else if (!graduation.Equals("") && !candidate.newUgQualification.Equals("0")) { graduation += "," + candidate.newUgQualification; } if (postGraduation.Equals("") && !candidate.newPgQualification.Equals("0")) { postGraduation = candidate.newPgQualification; } else if (!postGraduation.Equals("") && !candidate.newPgQualification.Equals("0")) { postGraduation += "," + candidate.newPgQualification; } query = "update dbo.Applicant set " + "graduation = '" + graduation + "'" + ", " + "post_graduation = '" + postGraduation + "'" + " where candidate_id = " + candidate.user_id; command = new SqlCommand(query, con); command.ExecuteNonQuery(); con.Close(); }
public static void UpdatePersonalInfo(CandidateModel can) { SqlConnection con = DBUtils.getDBConnection(); con.Open(); SqlCommand command = new SqlCommand("update dbo.Applicant set address = '" + can.Address + "', " + "contact_num = '" + can.ContactNo + "', email_id = '" + can.EmailID + "' where candidate_id = " + can.user_id, con); command.ExecuteNonQuery(); con.Close(); }
public static CandidateModel GetCandidateDetails(int userId) { SqlConnection con = DBUtils.getDBConnection(); con.Open(); SqlCommand command = new SqlCommand("select candidate_id, name, email_id, contact_num, gender, dob, address," + " graduation, post_graduation from dbo.Applicant where candidate_id=" + userId + ";", con); SqlDataReader reader = command.ExecuteReader(); CandidateModel can = new CandidateModel(); if (reader == null || !reader.Read()) { return null; } can.user_id = Convert.ToInt32(reader[0]); can.Name = Convert.ToString(reader[1]); can.EmailID = Convert.ToString(reader[2]); can.ContactNo = Convert.ToString(reader[3]); can.gender = Convert.ToString(reader[4]); can.dob = Convert.ToDateTime(reader[5]); can.Address = Convert.ToString(reader[6]); String[] ugList = Convert.ToString(reader[7]).Split(','); can.ugQualifications = new List<string>(); foreach (var item in ugList) { if(item.Length > 0) can.ugQualifications.Add(item); } String[] pgList = Convert.ToString(reader[8]).Split(','); can.pgQualifications = new List<string>(); foreach (var item in pgList) { if (item.Length > 0) can.pgQualifications.Add(item); } con.Close(); return can; }
public ActionResult ViewJobDetails() { if (!Navigator.IsUserLoggedIn(Session)) { @ViewBag.Message = "Sorry! You need to login to view this page."; return View("Message"); //return RedirectToAction("Login", "Account"); } else if (!Navigator.UserRoleValidation(Session, "candidate")) { @ViewBag.Message = "Access Denied ! You are not allowed to visit this page."; return View("Message"); //return RedirectToAction("Login", "Account"); } User user = (User)Session["user"]; CandidateModel candidate = new CandidateModel(); candidate = CandidateDAL.GetCandidateDetails(user.user_id); candidate.experienceDetails = CandidateDAL.GetCandidateExperienceDetails(user.user_id); int totalExperience = 0; foreach (var item in candidate.experienceDetails) { totalExperience += item.experience; } JobViewModel jobViewModel = new JobViewModel(); jobViewModel.jobs = CandidateDAL.GetApplicableJobs(user.user_id);; jobViewModel.qualifications = CandidateDAL.GetQualificationsIdToName(); jobViewModel.candidateUgQualification = candidate.ugQualifications; jobViewModel.candidatePgQualification = candidate.pgQualifications; jobViewModel.totalExperience = totalExperience; jobViewModel.jobsAlreadyApplied = CandidateDAL.GetNumJobsAppliedFor(user.user_id); jobViewModel.appliedJobs = CandidateDAL.GetAppliedJobs(user.user_id); return View(jobViewModel); }
public string UpdateQualificationDetails(CandidateModel candidate) { CandidateDAL.AddEducationDetails(candidate); return ""; }
public ActionResult UpdateProfile() { if (!Navigator.IsUserLoggedIn(Session)) { @ViewBag.Message = "Sorry! You need to login to view this page."; return View("Message"); //return RedirectToAction("Login", "Account"); } else if (!Navigator.UserRoleValidation(Session, "candidate")) { @ViewBag.Message = "Access Denied ! You are not allowed to visit this page."; return View("Message"); //return RedirectToAction("Login", "Account"); } CandidateModel candidate = new CandidateModel(); int user_id = ((User)Session["user"]).user_id; candidate = CandidateDAL.GetCandidateDetails(user_id); candidate.experienceDetails = CandidateDAL.GetCandidateExperienceDetails(user_id); List<QualificationModel> qualifications = CandidateDAL.GetQualificationDetails(); List<SelectListItem> ugQualifications = new List<SelectListItem>(); List<SelectListItem> pgQualifications = new List<SelectListItem>(); ugQualifications.Add(new SelectListItem { Selected = true, Text = "<-Select->", Value = "0" }); pgQualifications.Add(new SelectListItem { Selected = true, Text = "<-Select->", Value = "0" }); foreach (var item in qualifications) { if (candidate.ugQualifications.Contains(Convert.ToString(item.qualification_id))) continue; if (candidate.pgQualifications.Contains(Convert.ToString(item.qualification_id))) continue; if (item.type.Equals("UG")) ugQualifications.Add(new SelectListItem { Text = item.qualification, Value = item.qualification }); else pgQualifications.Add(new SelectListItem { Text = item.qualification, Value = item.qualification }); } ViewBag.ugListData = ugQualifications; ViewBag.pgListData = pgQualifications; return View(candidate); }
public string UpdatePersonalInfo(CandidateModel candidate) { CandidateDAL.UpdatePersonalInfo(candidate); return ""; }