コード例 #1
0
ファイル: Frm_Employee.cs プロジェクト: TerlanQurbanov/HRMS
        private void btn_ƏlavəEt_Click(object sender, EventArgs e)
        {
            Frm_EmployeeFunc FrmEmployeeFunc = new Frm_EmployeeFunc();

            DataTable      dtDepart = new DataTable();
            SqlDataAdapter daDepart = new SqlDataAdapter("Select DepartmentID,Name from Tbl_Department", Tools.Con);

            daDepart.Fill(dtDepart);

            FrmEmployeeFunc.cmb_Departament.DataSource    = dtDepart;
            FrmEmployeeFunc.cmb_Departament.ValueMember   = "DepartmentID";
            FrmEmployeeFunc.cmb_Departament.DisplayMember = "Name";

            DataTable      dtSpecialty = new DataTable();
            SqlDataAdapter daSpecialty = new SqlDataAdapter("Select SpecialtyID,SpecialtyName from Tbl_Specialty", Tools.Con);

            daSpecialty.Fill(dtSpecialty);

            FrmEmployeeFunc.cmb_Specialty.DataSource    = dtSpecialty;
            FrmEmployeeFunc.cmb_Specialty.ValueMember   = "SpecialtyID";
            FrmEmployeeFunc.cmb_Specialty.DisplayMember = "SpecialtyName";

            Tools.page = 0;

            FrmEmployeeFunc.btn_DaxilEt_Deyis.Text = "Daxil Et";



            FrmEmployeeFunc.lbl_IsdenCixiwVaxti.Visible = false;
            FrmEmployeeFunc.dtp_IsdenCixisT.Visible     = false;
            FrmEmployeeFunc.ShowDialog();

            dataGridView_Employee.DataSource = EORM.Select();
        }
コード例 #2
0
ファイル: Frm_Employee.cs プロジェクト: TerlanQurbanov/HRMS
        private void btn_Deyis_Click(object sender, EventArgs e)
        {
            Frm_EmployeeFunc FrmEmployeeFunc = new Frm_EmployeeFunc();

            DataTable      dtDepart = new DataTable();
            SqlDataAdapter daDepart = new SqlDataAdapter("Select DepartmentID,Name from Tbl_Department", Tools.Con);

            daDepart.Fill(dtDepart);

            FrmEmployeeFunc.cmb_Departament.DataSource    = dtDepart;
            FrmEmployeeFunc.cmb_Departament.ValueMember   = "DepartmentID";
            FrmEmployeeFunc.cmb_Departament.DisplayMember = "Name";

            DataTable      dtSpecialty = new DataTable();
            SqlDataAdapter daSpecialty = new SqlDataAdapter("Select SpecialtyID,SpecialtyName from Tbl_Specialty", Tools.Con);

            daSpecialty.Fill(dtSpecialty);

            FrmEmployeeFunc.cmb_Specialty.DataSource    = dtSpecialty;
            FrmEmployeeFunc.cmb_Specialty.ValueMember   = "SpecialtyID";
            FrmEmployeeFunc.cmb_Specialty.DisplayMember = "SpecialtyName";

            Tools.page = 1;

            FrmEmployeeFunc.id     = (int)dataGridView_Employee.CurrentRow.Cells["EmployeeID"].Value;
            FrmEmployeeFunc.active = (bool)dataGridView_Employee.CurrentRow.Cells["Active"].Value;

            FrmEmployeeFunc.txt_Adi.Text              = dataGridView_Employee.CurrentRow.Cells["Adı"].Value.ToString();
            FrmEmployeeFunc.txt_Soyadi.Text           = dataGridView_Employee.CurrentRow.Cells["Soyadı"].Value.ToString();
            FrmEmployeeFunc.txt_Adress.Text           = dataGridView_Employee.CurrentRow.Cells["Ünvan"].Value.ToString();
            FrmEmployeeFunc.txt_IstifadeciAdi.Text    = dataGridView_Employee.CurrentRow.Cells["İstifadəçi Adı"].Value.ToString();
            FrmEmployeeFunc.txt_Parol.Text            = dataGridView_Employee.CurrentRow.Cells["Şifrə"].Value.ToString();
            FrmEmployeeFunc.cmb_Specialty.Text        = dataGridView_Employee.CurrentRow.Cells["İxtisası"].Value.ToString();
            FrmEmployeeFunc.txt_IsdenCixmaSebebi.Text = dataGridView_Employee.CurrentRow.Cells["Qeyd"].Value.ToString();
            FrmEmployeeFunc.mskt_ElaqeNomresi.Text    = dataGridView_Employee.CurrentRow.Cells["Əlaqə.No"].Value.ToString();
            FrmEmployeeFunc.nud_IsTecrubesi.Text      = dataGridView_Employee.CurrentRow.Cells["İş Təcrübəsi(İL)"].Value.ToString();
            FrmEmployeeFunc.dtp_DogumT.Text           = dataGridView_Employee.CurrentRow.Cells["Doğum T"].Value.ToString();
            FrmEmployeeFunc.dtp_IseGirisT.Text        = dataGridView_Employee.CurrentRow.Cells["İşə B.T"].Value.ToString();
            FrmEmployeeFunc.gender               = dataGridView_Employee.CurrentRow.Cells["Cinsiyət"].Value.ToString();
            FrmEmployeeFunc.maritalstatus        = dataGridView_Employee.CurrentRow.Cells["Ailə Vəziyyəti"].Value.ToString();
            FrmEmployeeFunc.txt_FINKOD.Text      = dataGridView_Employee.CurrentRow.Cells["FIN Kod"].Value.ToString();
            FrmEmployeeFunc.cmb_Departament.Text = dataGridView_Employee.CurrentRow.Cells["Departament"].Value.ToString();

            FrmEmployeeFunc.mt_SHVN.Text          = dataGridView_Employee.CurrentRow.Cells["ŞV №"].Value.ToString();
            FrmEmployeeFunc.txt_AtaAdi.Text       = dataGridView_Employee.CurrentRow.Cells["Ata Adı"].Value.ToString();
            FrmEmployeeFunc.txt_DogulduguYer.Text = dataGridView_Employee.CurrentRow.Cells["Doğulduğu Yer"].Value.ToString();
            FrmEmployeeFunc.txt_Milliyeti.Text    = dataGridView_Employee.CurrentRow.Cells["Milliyəti"].Value.ToString();

            FrmEmployeeFunc.txt_EvTeli.Text = dataGridView_Employee.CurrentRow.Cells["Ev Telefonu"].Value.ToString();
            FrmEmployeeFunc.txt_EPosta.Text = dataGridView_Employee.CurrentRow.Cells["Email"].Value.ToString();
            FrmEmployeeFunc.mt_TeciliZngEdilecekSexsNo.Text         = dataGridView_Employee.CurrentRow.Cells["Təcili Zng Ediləcək.No"].Value.ToString();
            FrmEmployeeFunc.txt_TeciliZngEdilecekSexsinTelName.Text = dataGridView_Employee.CurrentRow.Cells["Təcili Zəng Ediləcək Şəxs"].Value.ToString();
            FrmEmployeeFunc.txt_XariciSHVNo.Text        = dataGridView_Employee.CurrentRow.Cells["Xarici PasportNo"].Value.ToString();
            FrmEmployeeFunc.txt_SigortaNo.Text          = dataGridView_Employee.CurrentRow.Cells["SığortaNo"].Value.ToString();
            FrmEmployeeFunc.cmb_İslemeNovu.Text         = dataGridView_Employee.CurrentRow.Cells["İşləmə Növü"].Value.ToString();
            FrmEmployeeFunc.txt_EmekHaqqi.Text          = dataGridView_Employee.CurrentRow.Cells["Əməkhaqqı"].Value.ToString();
            FrmEmployeeFunc.cmb_IstirahetGunleri.Text   = dataGridView_Employee.CurrentRow.Cells["İstirahət Günü"].Value.ToString();
            FrmEmployeeFunc.txt_IsdenCixmaSebebi.Text   = dataGridView_Employee.CurrentRow.Cells["İşdən Çıxma Səbəbi"].Value.ToString();
            FrmEmployeeFunc.cmb_EmrinNo.Text            = dataGridView_Employee.CurrentRow.Cells["ƏmrNo"].Value.ToString();
            FrmEmployeeFunc.txt_EmrdeGosterilenler.Text = dataGridView_Employee.CurrentRow.Cells["Əmr"].Value.ToString();
            FrmEmployeeFunc.txt_SelahiyyetliSexs.Text   = dataGridView_Employee.CurrentRow.Cells["Səlahiyyətli Şəxs"].Value.ToString();

            FrmEmployeeFunc.txt_BankaAdi.Text           = dataGridView_Employee.CurrentRow.Cells["Bankın Adı"].Value.ToString();
            FrmEmployeeFunc.txt_BankaSobeKodu.Text      = dataGridView_Employee.CurrentRow.Cells["Bankın Şöbə Kodu"].Value.ToString();
            FrmEmployeeFunc.txt_BankaHesabNo.Text       = dataGridView_Employee.CurrentRow.Cells["Bankın Hesab №"].Value.ToString();
            FrmEmployeeFunc.txt_IBANNo.Text             = dataGridView_Employee.CurrentRow.Cells["IBAN"].Value.ToString();
            FrmEmployeeFunc.cmb_Tehsili.Text            = dataGridView_Employee.CurrentRow.Cells["Təhsil"].Value.ToString();
            FrmEmployeeFunc.txt_TehsilAldigi_M.Text     = dataGridView_Employee.CurrentRow.Cells["Təhsil Müəssisəsi"].Value.ToString();
            FrmEmployeeFunc.cmb_HerbiMukellefiyyet.Text = dataGridView_Employee.CurrentRow.Cells["Hərbi Mükəlləfiyyət"].Value.ToString();



            DataTable dt = EORM.SqlReader((int)dataGridView_Employee.CurrentRow.Cells["EmployeeID"].Value);

            byte[]       sekil = (byte[])dt.Rows[0][1];
            MemoryStream ms    = new MemoryStream(sekil);

            FrmEmployeeFunc.pictureBox_Employee.Image = Image.FromStream(ms);

            FrmEmployeeFunc.btn_DaxilEt_Deyis.Text = "Dəyiş";
            FrmEmployeeFunc.ShowDialog();
            dataGridView_Employee.DataSource = EORM.Select();
        }