private void DataBindItems()
{
afeVO = afeBLO.SelectAFEOfCandidate(candidateId);
lblApplicationDate.Text = DateTime.Parse(afeVO.ApplicationDate).
ToString("MMMM d, yyyy");
lblPositionAppliedFor.Text = afeVO.PositionAppliedFor;
lblInterviewerName.Text = afeVO.InterviewerName;
file1VO = file1BLO.SelectFile1OfCandidateForPrint(candidateId);
lblName.Text = file1VO.FirstName
+ " “"
+ file1VO.NickName
+ "” "
+ file1VO.MiddleName
+ " "
+ file1VO.LastName
+ " "
+ file1VO.Affix;
lblApplicantMobileNumber.Text = file1VO.PresentTelephoneMobile;
lblApplicantEmailAddress.Text = candidateBLO.SelectCandidateEmail(candidateId);
lblApplicantDateOfBirth.Text = DateTime.Parse(file1VO.DateOfBirth).
ToString("MMMM d, yyyy");
lblApplicantPlaceOfBirth.Text = file1VO.PlaceOfBirth;
lblApplicantGender.Text = file1VO.Gender;
if (file1VO.CivilStatus != "Single")
{
lblApplicantCivilStatus.Text = file1VO.CivilStatus + " since " +
DateTime.Parse(file1VO.CivilStatusDate).ToString("MMMM d, yyyy");
}
else
{
lblApplicantCivilStatus.Text = file1VO.CivilStatus;
}
lblApplicantPresentAddress.Text =
file1VO.PresentAddress
+ ", "
+ file1VO.PresentCity
+ ", "
+ file1VO.PresentDistrict
+ ", "
+ file1VO.PresentCountry;
lblApplicantProvincialAddress.Text =
file1VO.ProvincialAddress
+ ", "
+ file1VO.ProvincialCity
+ ", "
+ file1VO.ProvincialDistrict
+ ", "
+ file1VO.ProvincialCountry;
lblApplicantHeight.Text = file1VO.Height;
lblApplicantWeight.Text = file1VO.Weight;
lblApplicantBloodType.Text = file1VO.BloodType;
gvEmployers.DataSource = file3BLO.SelectFile3OfCandidate(candidateId);
gvEmployers.DataBind();
gvOtherQualifications.DataSource = qualificationBLO.SelectQualificationOfAFE(afeId);
gvOtherQualifications.DataBind();
if (qualificationBLO.QualificationOfAFEHasOthers(afeId) == false)
{
gvOtherQualifications.Columns[2].Visible = false;
}
List <Label> answers = new List <Label>();
answers.Add(lblAnswer1);
answers.Add(lblAnswer2);
answers.Add(lblAnswer3);
answers.Add(lblAnswer4);
answers.Add(lblAnswer5);
answers.Add(lblAnswer6);
answers.Add(lblAnswer7);
List <Label> questions = new List <Label>();
questions.Add(lblQuestion1);
questions.Add(lblQuestion2);
questions.Add(lblQuestion3);
questions.Add(lblQuestion4);
questions.Add(lblQuestion5);
questions.Add(lblQuestion6);
questions.Add(lblQuestion7);
DataTable dt = new DataTable();
dt = answerBLO.SelectAnswerWithQuestionOfAFE(afeId);
for (int i = 0; i < dt.Rows.Count; i++)
{
questions[i].Text = dt.Rows[i]["question"].ToString();
if (dt.Rows[i]["answer"].ToString() == "False")
{
answers[i].Text = "No";
}
else if (dt.Rows[i]["answer"].ToString() == "True")
{
if (dt.Rows[i]["value"].ToString() != "")
{
answers[i].Text = "Yes: " + dt.Rows[i]["value"].ToString();
}
else if (dt.Rows[i]["relative_name"].ToString() != "" &&
dt.Rows[i]["company_name"].ToString() != "")
{
answers[i].Text = "Yes: " + dt.Rows[i]["relative_name"].ToString() +
" at " + dt.Rows[i]["company_name"].ToString();
}
}
}
gvDependents.DataSource = file5BLO.SelectFile5OfCandidate(candidateId);
gvDependents.DataBind();
gvProfessionalReferences.DataSource =
professionalReferenceBLO.SelectProfessionalReferenceOfAFE(afeId);
gvProfessionalReferences.DataBind();
gvPersonalReferences.DataSource =
personalReferenceBLO.SelectPersonalReferenceOfAFE(afeId);
gvPersonalReferences.DataBind();
}
private void DataBindItems()
{
if (Session["Candidate"] != null || Request.Cookies["Candidate"] != null)
{
afeVO = afeBLO.SelectAFEOfCandidate(candidateId);
lblApplicationDate.Text = DateTime.Parse(afeVO.ApplicationDate).
ToString("MMMM d, yyyy");
lblPositionAppliedFor.Text = afeVO.PositionAppliedFor;
lblInterviewerName.Text = afeVO.InterviewerName;
file1VO = file1BLO.SelectFile1OfCandidateForPrint(candidateId);
lblName.Text = file1VO.FirstName
+ " “"
+ file1VO.NickName
+ "” "
+ file1VO.MiddleName
+ " "
+ file1VO.LastName
+ " "
+ file1VO.Affix;
lblDateOfBirth.Text = DateTime.Parse(file1VO.DateOfBirth).ToString("MMMM d, yyyy");
lblPlaceOfBirth.Text = file1VO.PlaceOfBirth;
lblNationality.Text = file1VO.Nationality;
lblGender.Text = file1VO.Gender;
lblCivilStatus.Text = file1VO.CivilStatus;
lblReligion.Text = file1VO.Religion;
lblBloodType.Text = file1VO.BloodType;
lblSSS.Text = file1VO.SSS;
lblTIN.Text = file1VO.TIN;
lblPresentAddress.Text =
file1VO.PresentAddress
+ ", "
+ file1VO.PresentCity
+ ", "
+ file1VO.PresentDistrict
+ ", "
+ file1VO.PresentCountry;
lblPermanentAddress.Text =
file1VO.PermanentAddress
+ ", "
+ file1VO.PermanentCity
+ ", "
+ file1VO.PermanentDistrict
+ ", "
+ file1VO.PermanentCountry;
lblProvincialAddress.Text =
file1VO.ProvincialAddress
+ ", "
+ file1VO.ProvincialCity
+ ", "
+ file1VO.ProvincialDistrict
+ ", "
+ file1VO.ProvincialCountry;
lblHomeNumber.Text = file1VO.PresentTelephoneHome;
lblAdditionalNumber.Text = file1VO.PresentTelephoneAdditional;
lblMobileNumber.Text = file1VO.PresentTelephoneMobile;
lblFaxNumber.Text = file1VO.PresentFax;
lblProvincialNumber.Text = file1VO.ProvincialTelephone;
gvEducations.DataSource = file2BLO.SelectFile2OfCandidate(candidateId);
gvEducations.DataBind();
if (file2BLO.File2OfCandidateHasSchoolOthers(candidateId) == false)
{
gvEducations.Columns[2].Visible = false;
}
gvOrganizations.DataSource = file4BLO.SelectFile4OfCandidate(candidateId);
gvOrganizations.DataBind();
gvEmployers.DataSource = file3BLO.SelectFile3OfCandidate(candidateId);
gvEmployers.DataBind();
gvOtherQualifications.DataSource = qualificationBLO.SelectQualificationOfAFE(afeId);
gvOtherQualifications.DataBind();
if (qualificationBLO.QualificationOfAFEHasOthers(afeId) == false)
{
gvOtherQualifications.Columns[2].Visible = false;
}
List <Label> answers = new List <Label>();
answers.Add(lblAnswer1);
answers.Add(lblAnswer2);
answers.Add(lblAnswer3);
answers.Add(lblAnswer4);
answers.Add(lblAnswer5);
answers.Add(lblAnswer6);
answers.Add(lblAnswer7);
List <Label> questions = new List <Label>();
questions.Add(lblQuestion1);
questions.Add(lblQuestion2);
questions.Add(lblQuestion3);
questions.Add(lblQuestion4);
questions.Add(lblQuestion5);
questions.Add(lblQuestion6);
questions.Add(lblQuestion7);
DataTable dt = new DataTable();
dt = answerBLO.SelectAnswerWithQuestionOfAFE(afeId);
for (int i = 0; i < dt.Rows.Count; i++)
{
questions[i].Text = dt.Rows[i]["question"].ToString();
if (dt.Rows[i]["answer"].ToString() == "False")
{
answers[i].Text = "No";
}
else if (dt.Rows[i]["answer"].ToString() == "True")
{
if (dt.Rows[i]["value"].ToString() != "")
{
answers[i].Text = "Yes: " + dt.Rows[i]["value"].ToString();
}
else if (dt.Rows[i]["relative_name"].ToString() != "" &&
dt.Rows[i]["company_name"].ToString() != "")
{
answers[i].Text = "Yes: " + dt.Rows[i]["relative_name"].ToString() +
" at " + dt.Rows[i]["company_name"].ToString();
}
}
}
gvDependents.DataSource = file5BLO.SelectFile5OfCandidate(candidateId);
gvDependents.DataBind();
gvProfessionalReferences.DataSource =
professionalReferenceBLO.SelectProfessionalReferenceOfAFE(afeId);
gvProfessionalReferences.DataBind();
gvPersonalReferences.DataSource =
personalReferenceBLO.SelectPersonalReferenceOfAFE(afeId);
gvPersonalReferences.DataBind();
}
}
private void FillControlsWithData()
{
if (candidateId > 0)
{
file1VO = file1BLO.SelectFile1OfCandidate(candidateId);
if (file1VO != null)
{
hidFile1ID.Value = file1VO.File1Id.ToString();
txtFirstName.Text = file1VO.FirstName;
txtLastName.Text = file1VO.LastName;
txtNickName.Text = file1VO.NickName;
txtMiddleName.Text = file1VO.MiddleName;
txtDateOfBirth.Text = DateTime.Parse(file1VO.DateOfBirth).ToString("yyyy-MM-dd");
txtPlaceOfBirth.Text = file1VO.PlaceOfBirth;
ddlNationality.SelectedValue = file1VO.Nationality;
ddlGender.SelectedValue = file1VO.Gender;
ddlCivilStatus.SelectedValue = file1VO.CivilStatus;
if (!ddlCivilStatus.SelectedValue.Equals("0"))
{
pnlCivilStatusDate.Visible = true;
}
else
{
pnlCivilStatusDate.Visible = false;
}
if (file1VO.CivilStatusDate != "")
{
txtCivilStatusDate.Text =
DateTime.Parse(file1VO.CivilStatusDate).ToString("yyyy-MM-dd");
}
ddlAffix.SelectedValue = file1VO.Affix;
ddlReligion.SelectedValue = file1VO.Religion;
if (file1VO.Height != "")
{
txtHeightFeet.Text = file1VO.Height.Substring(0, 1);
txtHeightInches.Text = file1VO.Height.Substring(1);
}
txtWeight.Text = file1VO.Weight;
ddlBloodType.SelectedValue = file1VO.BloodType;
txtSSS.Text = file1VO.SSS;
txtTIN.Text = file1VO.TIN;
txtPresentAddress.Text = file1VO.PresentAddress;
txtPresentCity.Text = file1VO.PresentCity;
txtPresentDistrict.Text = file1VO.PresentDistrict;
ddlPresentCountry.SelectedValue = file1VO.PresentCountry;
txtPresentTelephoneHome.Text = file1VO.PresentTelephoneHome;
txtPresentTelephoneAdditional.Text = file1VO.PresentTelephoneAdditional;
txtPresentMobileNumber.Text = file1VO.PresentTelephoneMobile;
txtPresentFax.Text = file1VO.PresentFax;
txtPermanentAddress.Text = file1VO.PermanentAddress;
txtPermanentCity.Text = file1VO.PermanentCity;
txtPermanentDistrict.Text = file1VO.PermanentDistrict;
ddlPermanentCountry.SelectedValue = file1VO.PermanentCountry;
txtProvincialAddress.Text = file1VO.ProvincialAddress;
txtProvincialCity.Text = file1VO.ProvincialCity;
txtProvincialDistrict.Text = file1VO.ProvincialDistrict;
ddlProvincialCountry.SelectedValue = file1VO.ProvincialCountry;
txtProvincialTelephone.Text = file1VO.ProvincialTelephone;
}
}
}
