private void addFieldsToControls()
{
DataTable dtResault = FRB.GetInfoPeoByFilter(int.Parse(Request.QueryString["ID"].ToString()));
if (dtResault.Rows.Count > 0 && dtResault.Rows[0]["scan_document"] != DBNull.Value)
{
Div1.Visible = true;
rlv.DataSource = dtResault;
rlv.DataBind();
}
if (dtResault.Rows.Count == 0)
{
return;
}
addPersonalInfToControls(dtResault);
addWorkInfoToControls(dtResault);
addContactInfoToControls(dtResault);
try
{
DataTable dt4 = FRB.GetFilePDF(int.Parse(Request.QueryString["ID"].ToString()));
if (dt4.Rows.Count > 0)
{
btn_ShowPDF.Visible = true;
}
else
{
btn_ShowPDF.Visible = false;
}
if (lbl_Taeed2.Text != string.Empty)
{
lbl_Taeed2.Text = string.Empty;
}
}
catch (Exception ex1) { }
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Session[prvPage] = Request.UrlReferrer != null?Request.UrlReferrer.ToString() : Session[prvPage];
if ((!string.IsNullOrWhiteSpace(Request.QueryString["ID"].ToString())))
{
DataTable dtResault = FRB.GetInfoPeoByFilter(int.Parse(Request.QueryString["ID"].ToString()));
if (dtResault.Rows.Count > 1 && dtResault.Rows[0]["scan_document"] != DBNull.Value)
{
Div1.Visible = true;
rlv.DataSource = dtResault;
rlv.DataBind();
}
DataTable cityList = CB.GetNameCity_fcoding();
txtFirstName.Text = dtResault.Rows[0]["name"].ToString();
txtFamily.Text = dtResault.Rows[0]["family"].ToString();
txtFatherName.Text = dtResault.Rows[0]["namep"].ToString();
txtLivingZipCode.Text = dtResault.Rows[0]["code_posti"].ToString();
txtShCode.Text = dtResault.Rows[0]["idd"].ToString();
txtCodeMeli.Text = dtResault.Rows[0]["idd_meli"].ToString();
if (dtResault.Rows[0]["sex"].ToString() == "1")
{
rdblGender.Items[0].Selected = true;
}
else
{
rdblGender.Items[1].Selected = true;
}
txtYearBorn.Text = dtResault.Rows[0]["sal_tav"].ToString();
drpLastMaghta.SelectedValue = dtResault.Rows[0]["idmadrak"].ToString();
if (dtResault.Rows[0]["IsRetired"].ToString() == "1")
{
chk_IsRetired.Checked = true;
}
if (dtResault.Rows[0]["Cooperation"].ToString() == "3")
{
chk_Cooperation.Items[0].Selected = true;
chk_Cooperation.Items[1].Selected = true;
}
if (dtResault.Rows[0]["Cooperation"].ToString() == "1")
{
chk_Cooperation.Items[0].Selected = true;
}
if (dtResault.Rows[0]["Cooperation"].ToString() == "2")
{
chk_Cooperation.Items[1].Selected = true;
}
txtYearGetMadrak.Text = dtResault.Rows[0]["sal_madrak"].ToString();
txtSanavat.Text = dtResault.Rows[0]["sanavat_tadris"].ToString();
rdblMarriage.SelectedValue = dtResault.Rows[0]["marital_status"].ToString();
if (dtResault.Rows[0]["marital_status"].ToString() == "1")
{
rdblMarriage.Items[0].Selected = true;
}
else
{
rdblMarriage.Items[1].Selected = true;
}
if (dtResault.Rows[0]["BimehTypeId"] != DBNull.Value)
{
if (Convert.ToInt16(dtResault.Rows[0]["BimehTypeId"]) > 0)
{
rdblBimehStatus.SelectedValue = "1";
drpBimehType.SelectedValue = dtResault.Rows[0]["BimehTypeId"].ToString();
txtInsuranceNumber.Text = dtResault.Rows[0]["num_bime"].ToString();
}
}
txtHomePhone.Text = dtResault.Rows[0]["tel_home"].ToString();
txtWorkPhone.Text = dtResault.Rows[0]["tel_kar"].ToString();
txtMobileNumber.Text = dtResault.Rows[0]["mobile"].ToString();
txtLivingAddress.Text = dtResault.Rows[0]["add_home"].ToString();
txtWorkingAddress.Text = dtResault.Rows[0]["add_kar"].ToString();
txtLivingZipCode.Text = dtResault.Rows[0]["code_posti"].ToString();
txtEmail.Text = dtResault.Rows[0]["add_email"].ToString();
if (dtResault.Rows[0]["martabeh"].ToString() == "-2" ||
dtResault.Rows[0]["martabeh"].ToString() == "0" ||
dtResault.Rows[0]["martabeh"].ToString() == "8")
{
dvHeiatElmi.Visible = false;
pnlSabeghe.Enabled = false;
}
else
{
dvHeiatElmi.Visible = true;
pnlSabeghe.Enabled = true;
drpMartabe.SelectedValue = dtResault.Rows[0]["martabeh"].ToString();
txtPaye.Text = dtResault.Rows[0]["payeh"].ToString();
drpHireType.SelectedValue = dtResault.Rows[0]["type_estekhdam"].ToString();
drpPastUni.DataSource = CB.GetNameUni_fcoding();
drpPastUni.DataTextField = "namecoding";
drpPastUni.DataValueField = "ID";
drpPastUni.DataBind();
if (dtResault.Rows[0]["uni_khedmat"].ToString() == "0")
{
drpPastUni.Items.Add(new ListItem("انتخاب کنید", "0"));
drpPastUni.Items[drpPastUni.Items.Count - 1].Selected = true;
}
else
{
drpPastUni.SelectedValue = dtResault.Rows[0]["uni_khedmat"].ToString();
}
if (dtResault.Rows[0]["nahveh_hamk"].ToString() == "44")
{
rdblHireType.Items[0].Selected = true;
}
else if (dtResault.Rows[0]["nahveh_hamk"].ToString() == "8")
{
rdblHireType.Items[2].Selected = true;
}
else if (dtResault.Rows[0]["nahveh_hamk"].ToString() == "32")
{
rdblHireType.Items[1].Selected = true;
}
else if (dtResault.Rows[0]["nahveh_hamk"].ToString() == "12")
{
rdblHireType.Items[3].Selected = true;
}
txtDateSodoorHokm.Text = dtResault.Rows[0]["date_hokm"].ToString();
txtDateEjraHokm.Text = dtResault.Rows[0]["date_runhokm"].ToString();
txtHokmNumber.Text = dtResault.Rows[0]["number_hokm"].ToString();
}
txtSiba.Text = dtResault.Rows[0]["siba"].ToString();
drpBirthCity.DataSource = cityList;
drpBirthCity.DataTextField = "title";
drpBirthCity.DataValueField = "ID";
drpBirthCity.DataBind();
if (dtResault.Rows[0]["mahal_tav"].ToString() == "0")
{
drpBirthCity.Items.Add(new ListItem("انتخاب کنید", "0"));
drpBirthCity.Items[drpBirthCity.Items.Count - 1].Selected = true;
}
else
{
drpBirthCity.SelectedValue = dtResault.Rows[0]["mahal_tav"].ToString();
}
drpMahalSodoor.DataSource = cityList;
drpMahalSodoor.DataTextField = "title";
drpMahalSodoor.DataValueField = "ID";
drpMahalSodoor.DataBind();
if (dtResault.Rows[0]["mahal_sodor"].ToString() == "0")
{
drpMahalSodoor.Items.Add(new ListItem("انتخاب کنید", "0"));
drpMahalSodoor.Items[drpMahalSodoor.Items.Count - 1].Selected = true;
}
else
{
drpMahalSodoor.SelectedValue = dtResault.Rows[0]["mahal_sodor"].ToString();
}
drpLivingCity.DataSource = cityList;
drpLivingCity.DataTextField = "Title";
drpLivingCity.DataValueField = "ID";
drpLivingCity.DataBind();
drpLivingCity.Items.Insert(0, new ListItem("انتخاب کنید"));
if (dtResault.Rows[0]["code_city_home"] != null)
{
drpLivingCity.SelectedValue = dtResault.Rows[0]["code_city_home"].ToString();
}
drpWorkingCity.DataSource = cityList;
drpWorkingCity.DataTextField = "Title";
drpWorkingCity.DataValueField = "ID";
drpWorkingCity.DataBind();
if (dtResault.Rows[0]["code_city_work"] != null)
{
if (dtResault.Rows[0]["code_city_work"].ToString() == "0")
{
drpWorkingCity.DataSource = cityList;
drpWorkingCity.DataTextField = "Title";
drpWorkingCity.DataValueField = "ID";
drpWorkingCity.DataBind();
drpWorkingCity.Items.Add(new ListItem("انتخاب کنید", "0"));
drpWorkingCity.Items[drpWorkingCity.Items.Count - 1].Selected = true;
}
else
{
drpWorkingCity.SelectedValue = dtResault.Rows[0]["code_city_work"].ToString();
}
}
else
{
drpWorkingCity.DataSource = cityList;
drpWorkingCity.DataTextField = "Title";
drpWorkingCity.DataValueField = "ID";
drpWorkingCity.DataBind();
drpWorkingCity.Items.Add(new ListItem("انتخاب کنید", "0"));
drpWorkingCity.Items[drpWorkingCity.Items.Count - 1].Selected = true;
}
drpNezam.DataSource = CB.GetStatusMilitary_fcoding();
drpNezam.DataTextField = "namecoding";
drpNezam.DataValueField = "id";
drpNezam.DataBind();
if (dtResault.Rows[0]["status_nezam"].ToString() == "0")
{
drpNezam.Items.Add(new ListItem("سایر", "0"));
drpNezam.Items[drpNezam.Items.Count - 1].Selected = true;
}
else
{
drpNezam.SelectedValue = dtResault.Rows[0]["status_nezam"].ToString();
}
drpCountry.DataSource = CB.GetNameCountry_fcoding();
drpCountry.DataTextField = "namecoding";
drpCountry.DataValueField = "id";
drpCountry.DataBind();
if (dtResault.Rows[0]["country"].ToString() == "0")
{
drpCountry.Items.Add(new ListItem("سایر", "0"));
drpCountry.Items[drpCountry.Items.Count - 1].Selected = true;
}
else
{
drpCountry.SelectedValue = dtResault.Rows[0]["country"].ToString();
}
drpReshte.DataSource = CB.SelectField_fcoding();
drpReshte.DataTextField = "nameresh";
drpReshte.DataValueField = "id";
drpReshte.DataBind();
ListItem other = new ListItem("سایر");
if (dtResault.Rows[0]["idresh"] != DBNull.Value)
{
if (dtResault.Rows[0]["idresh"].ToString() == "0")
{
drpReshte.Items.Add(new ListItem("سایر", "0"));
drpReshte.Items[drpReshte.Items.Count - 1].Selected = true;
}
else
{
drpReshte.SelectedValue = dtResault.Rows[0]["idresh"].ToString();
}
}
drpUniName.DataSource = CB.GetNameUni_fcoding();
drpUniName.DataTextField = "namecoding";
drpUniName.DataValueField = "id";
drpUniName.DataBind();
if (dtResault.Rows[0]["university"].ToString() == "0")
{
drpUniName.Items.Add(new ListItem("سایر", "0"));
drpUniName.Items[drpUniName.Items.Count - 1].Selected = true;
}
else
{
drpUniName.SelectedValue = dtResault.Rows[0]["university"].ToString();
}
drpProvince1.DataSource = CB.GetOstan();
drpProvince1.DataTextField = "Title";
drpProvince1.DataValueField = "ID";
drpProvince1.DataBind();
drpProvince1.Items.Insert(0, new ListItem("انتخاب کنید"));
if (dtResault.Rows[0]["code_ostan_home"] != null)
{
drpProvince1.SelectedValue = dtResault.Rows[0]["code_ostan_home"].ToString();
}
drpProvince2.DataSource = CB.GetOstan();
drpProvince2.DataTextField = "Title";
drpProvince2.DataValueField = "ID";
drpProvince2.DataBind();
if (dtResault.Rows[0]["code_ostan_work"] != null)
{
if (dtResault.Rows[0]["code_ostan_work"].ToString() == "0")
{
drpProvince2.DataSource = CB.GetOstan();
drpProvince2.DataTextField = "Title";
drpProvince2.DataValueField = "ID";
drpProvince2.DataBind();
drpProvince2.Items.Add(new ListItem("انتخاب کنید", "0"));
drpProvince2.Items[drpProvince2.Items.Count - 1].Selected = true;
}
else
{
drpProvince2.SelectedValue = dtResault.Rows[0]["code_ostan_work"].ToString();
}
}
else
{
drpProvince2.DataSource = CB.GetOstan();
drpProvince2.DataTextField = "Title";
drpProvince2.DataValueField = "ID";
drpProvince2.DataBind();
drpProvince2.Items.Add(new ListItem("انتخاب کنید", "0"));
drpProvince2.Items[drpProvince2.Items.Count - 1].Selected = true;
}
DataTable dtDanesh = CB.SelectAllDaneshkade();
chbkDaneshkade.DataSource = dtDanesh;
chbkDaneshkade.DataValueField = "ID";
chbkDaneshkade.DataTextField = "namedanesh";
chbkDaneshkade.DataBind();
addDepratements(int.Parse(dtResault.Rows[0]["ID"].ToString()));
DataTable dt4 = FRB.GetFilePDF(int.Parse(Request.QueryString["ID"].ToString()));
if (dt4.Rows.Count > 0)
{
btn_ShowPDF.Visible = true;
}
else
{
btn_ShowPDF.Visible = false;
}
if (lbl_Taeed2.Text != string.Empty)
{
lbl_Taeed2.Text = string.Empty;
}
}
}
}