public ActionResult ViewApplicant(int?MasterlistID) { if (MasterlistID == null) { return(RedirectToAction("ApplicantList")); } UserDropdownEntities userDropdownEntities = new UserDropdownEntities(); var getuserlist = userDropdownEntities.Dropdowns.ToList(); SelectList MaritalStatusList = new SelectList(getuserlist.Where(o => o.DropdownType == "MaritalStatus"), "DropdownName", "DropdownName"); SelectList JobTitleList = new SelectList(getuserlist.Where(o => o.DropdownType == "JobTitle"), "DropdownName", "DropdownName"); ViewBag.MaritalStatusList = MaritalStatusList; ViewBag.JobTitleList = JobTitleList; ViewApplicantModel model = new ViewApplicantModel(); DataTable dtblApplicant = new DataTable(); DataTable dtblWorkExperience = new DataTable(); using (SqlConnection sqlCon = new SqlConnection(connectionString)) { sqlCon.Open(); string query = "SELECT * from Masterlist Where MasterlistID = @MasterlistID"; SqlDataAdapter sqlDa = new SqlDataAdapter(query, sqlCon); sqlDa.SelectCommand.Parameters.AddWithValue("@MasterlistID", MasterlistID); sqlDa.Fill(dtblApplicant); string querys = "SELECT * from WorkExperience Where MasterlistID = @MasterlistID"; SqlDataAdapter sqlDas = new SqlDataAdapter(querys, sqlCon); sqlDas.SelectCommand.Parameters.AddWithValue("@MasterlistID", MasterlistID); sqlDas.Fill(dtblWorkExperience); } if (dtblApplicant.Rows.Count == 1) { model.MasterlistID = Convert.ToInt32(dtblApplicant.Rows[0][0].ToString()); model.FirstName = dtblApplicant.Rows[0][2].ToString(); model.MiddleName = dtblApplicant.Rows[0][3].ToString(); model.LastName = dtblApplicant.Rows[0][4].ToString(); model.Birthday = DateTime.Parse(dtblApplicant.Rows[0][7].ToString()); model.MaritalStatus = dtblApplicant.Rows[0][8].ToString(); model.JobTitle = dtblApplicant.Rows[0][6].ToString(); model.Street_Address1 = dtblApplicant.Rows[0][11].ToString(); model.Street_Address2 = dtblApplicant.Rows[0][12].ToString(); model.City = dtblApplicant.Rows[0][13].ToString(); model.Province = dtblApplicant.Rows[0][14].ToString(); model.ZipCode = dtblApplicant.Rows[0][15].ToString(); model.ContactNumber = dtblApplicant.Rows[0][10].ToString(); model.PersonalEmail = dtblApplicant.Rows[0][4].ToString(); ViewBag.MasterlistID = MasterlistID; model.CompanyName = dtblWorkExperience.Rows[0][2].ToString(); model.WorkExperienceJobTitle = dtblWorkExperience.Rows[0][3].ToString(); model.DateFrom = DateTime.Parse(dtblWorkExperience.Rows[0][4].ToString()); model.DateTo = DateTime.Parse(dtblWorkExperience.Rows[0][5].ToString()); return(View(model)); } else { return(RedirectToAction("ApplicantList")); } }
public ActionResult EditApplicant(ViewApplicantModel ViewApplicantModel) { using (SqlConnection sqlCon = new SqlConnection(connectionString)) { sqlCon.Open(); string query = "UPDATE Masterlist SET FirstName= @FirstName,MiddleName=@MiddleName,LastName=@LastName,Birthday=@Birthday,MaritalStatus=@MaritalStatus,JobTitle=@JobTitle,Street_Address1=@Street_Address1,Street_Address2=@Street_Address2,City=@City,Province=@Province,ZipCode=@ZipCode,ContactNumber=@ContactNumber,PersonalEmail=@PersonalEmail WHERE MasterlistID = @MasterlistID"; SqlCommand sqlCmds = new SqlCommand(query, sqlCon); sqlCmds.Parameters.AddWithValue("@FirstName", ViewApplicantModel.FirstName); sqlCmds.Parameters.AddWithValue("@MiddleName", ViewApplicantModel.MiddleName); sqlCmds.Parameters.AddWithValue("@LastName", ViewApplicantModel.LastName); sqlCmds.Parameters.AddWithValue("@Birthday", ViewApplicantModel.Birthday); sqlCmds.Parameters.AddWithValue("@MaritalStatus", ViewApplicantModel.MaritalStatus); sqlCmds.Parameters.AddWithValue("@JobTitle", ViewApplicantModel.JobTitle); sqlCmds.Parameters.AddWithValue("@Street_Address1", ViewApplicantModel.Street_Address1); sqlCmds.Parameters.AddWithValue("@Street_Address2", ViewApplicantModel.Street_Address2); sqlCmds.Parameters.AddWithValue("@City", ViewApplicantModel.City); sqlCmds.Parameters.AddWithValue("@Province", ViewApplicantModel.Province); sqlCmds.Parameters.AddWithValue("@ZipCode", ViewApplicantModel.ZipCode); sqlCmds.Parameters.AddWithValue("@ContactNumber", ViewApplicantModel.ContactNumber); sqlCmds.Parameters.AddWithValue("@PersonalEmail", ViewApplicantModel.PersonalEmail); sqlCmds.Parameters.AddWithValue("@MasterlistID", ViewApplicantModel.MasterlistID); sqlCmds.ExecuteNonQuery(); string querys = "UPDATE WorkExperience SET CompanyName=@CompanyName,JobTitle=@JobTitle,DateFrom=@DateFrom,DateTo=@DateTo WHERE MasterlistID = @MasterlistID"; SqlCommand cmd = new SqlCommand(querys, sqlCon); cmd.Parameters.AddWithValue("@CompanyName", ViewApplicantModel.CompanyName); cmd.Parameters.AddWithValue("@JobTitle", ViewApplicantModel.WorkExperienceJobTitle); cmd.Parameters.AddWithValue("@DateFrom", ViewApplicantModel.DateFrom); cmd.Parameters.AddWithValue("@DateTo", ViewApplicantModel.DateTo); cmd.Parameters.AddWithValue("@MasterlistID", ViewApplicantModel.MasterlistID); cmd.ExecuteNonQuery(); TempData["success"] = "User: "******" " + ViewApplicantModel.LastName + " Updated!"; } return(RedirectToAction("ApplicantList")); }