private void BilgileriGetir()
        {
            TxtTc.Enabled = false;

            var sonucTip       = tip_veritabani.Listele();
            var sonucDepartman = departman_veritabani.Listele();

            DrpTip.DataSource     = sonucTip.Veri;
            DrpTip.DataTextField  = "ad";
            DrpTip.DataValueField = "tip_id";
            DrpTip.DataBind();

            DrpDepartman.DataSource     = sonucDepartman.Veri;
            DrpDepartman.DataTextField  = "ad";
            DrpDepartman.DataValueField = "departman_id";
            DrpDepartman.DataBind();

            divBilgiMesaji.Visible = false;

            string tc    = Request.QueryString["tc"].ToString();
            var    sonuc = personel_veritabani.DetayGetir(tc);

            if (sonuc.basariliMi)
            {
                Personel personel = sonuc.Veri;
                spanAdSoyad.InnerText = personel.ad + " " + personel.soyad;
                TxtAd.Text            = personel.ad;
                TxtSoyad.Text         = personel.soyad;
                TxtSicil.Text         = personel.sicil_no;
                TxtTc.Text            = personel.personel_tc;
                TxtAdres.Text         = personel.adres;
                TxtEkMesaiUcret.Text  = personel.ek_mesai_ucret.ToString();
                TxtMaas.Text          = personel.guncel_maas.ToString();
                TxtMail.Text          = personel.mail;
                TxtTelefon.Text       = personel.telefon;
                TxtUnvan.Text         = personel.unvan;
                DateDogum.Value       = Convert.ToDateTime(personel.dogum_tarih).ToString("yyyy-MM-dd");
                DateIseGiris.Value    = Convert.ToDateTime(personel.ise_giris_tarih).ToString("yyyy-MM-dd");
                TimeGiris.Value       = personel.varsayilan_giris_saat.ToString();
                TimeCikis.Value       = personel.varsayilan_cikis_saat.ToString();
                if (personel.cinsiyet == "Erkek")
                {
                    RdErkek.Checked = true;
                }
                else
                {
                    RdKadin.Checked = true;
                }
                DrpDepartman.SelectedValue = personel.departman_id.ToString();
                DrpTip.SelectedValue       = personel.tip_id.ToString();
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                var sonucTip       = tip_veritabani.Listele();
                var sonucDepartman = departman_veritabani.Listele();

                DrpTip.DataSource     = sonucTip.Veri;
                DrpTip.DataTextField  = "ad";
                DrpTip.DataValueField = "tip_id";
                DrpTip.DataBind();

                DrpDepartman.DataSource     = sonucDepartman.Veri;
                DrpDepartman.DataTextField  = "ad";
                DrpDepartman.DataValueField = "departman_id";
                DrpDepartman.DataBind();

                divBilgiMesaji.Visible = false;
            }
        }