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"));
}
