Ejemplo n.º 1
0
 protected void grd_Show_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
 {
     if (e.CommandName == "Detail")
     {
         Session["Page"] = 2;
         string[] index      = e.CommandArgument.ToString().Split(new char[] { ',' });
         int      Code_Ostad = int.Parse(index[0].ToString());
         //PPD.mobile = index[8].ToString();
         //lbl_Code.Text = Convert.ToString(Code_Ostad);
         DataTable dtProf = FRB.GetInfoPeoByFilter(Code_Ostad);
         Response.Redirect("ShowDetailInfo.aspx?ID=" + dtProf.Rows[0]["ID"].ToString());
     }
 }
Ejemplo n.º 2
0
        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;
                    }
                }
            }
        }