using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data.SqlClient;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.IO;

namespace EMP_INFO.PL
{
    public partial class FRM_UPD_DEL_EMP : Form
    {
        DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
        BL.CLS_UPD_DEL_EMP dirEditDeleteEmp = new BL.CLS_UPD_DEL_EMP();
        DataTable Dt = new DataTable();
        SqlDataAdapter Da = new SqlDataAdapter();
        SqlCommandBuilder cmdb;
        CurrencyManager cm;

        public FRM_UPD_DEL_EMP()
        {

            InitializeComponent();

            dataBindings();
            this.ShowInTaskbar = false;
            this.FormBorderStyle = FormBorderStyle.FixedToolWindow;
            this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;//لمنع التغيير في حجم الفورم
            getListBoxItems();
            doNothingMouseWheel();
            selectZeroCmbIndex();
            cmbFullEmpName.SelectedIndex = -1;
            cmbFullEmpName.Select();
            btnEditOrSaveEmp.Enabled = false;
            btnDeleteAllEmpInfo.Enabled = false;
            btnPictureEmp.Enabled = false;
        }
        public void dataBindings()//للربط بين الحقول والقيم الاتية من الصنف الذي جلب بيانات الموظف
        {
            Da = dirEditDeleteEmp.DIR_EMP_INFO("0");
            txtEmpName1.DataBindings.Add("Text", Dt, "EMP_NAME_1");
            txtEmpName2.DataBindings.Add("Text", Dt, "EMP_NAME_2");
            txtEmpName3.DataBindings.Add("Text", Dt, "EMP_NAME_3");
            txtEmpName4.DataBindings.Add("Text", Dt, "EMP_NAME_4");
            txtEmpName5.DataBindings.Add("Text", Dt, "EMP_NAME_5");
            txtEmpName6.DataBindings.Add("Text", Dt, "EMP_NAME_6");
            dtpEmpBirthday.DataBindings.Add("Text", Dt, "EMP_BIRTHDAY");
            cmbEmpBirthPlace1.DataBindings.Add("Text", Dt, "EMP_BIRTH_PLACE_1");
            cmbEmpBirthPlace2.DataBindings.Add("Text", Dt, "EMP_BIRTH_PLACE_2");
            txtMotherName1.DataBindings.Add("Text", Dt, "MOTHER_NAME_1");
            txtMotherName2.DataBindings.Add("Text", Dt, "MOTHER_NAME_2");
            txtMotherName3.DataBindings.Add("Text", Dt, "MOTHER_NAME_3");
            txtMotherName4.DataBindings.Add("Text", Dt, "MOTHER_NAME_4");
            cmbGender.DataBindings.Add("Text", Dt, "GENDER");
            cmbMaritalStatus.DataBindings.Add("Text", Dt, "MARITAL_STATUS");
            cmbChildrenNumbers.DataBindings.Add("Text", Dt, "CHILDREN_NUMBERS");
            txtHusbandName1.DataBindings.Add("Text", Dt, "HUSBAND_NAME_1");
            txtHusbandName2.DataBindings.Add("Text", Dt, "HUSBAND_NAME_2");
            txtHusbandName3.DataBindings.Add("Text", Dt, "HUSBAND_NAME_3");
            txtHusbandName4.DataBindings.Add("Text", Dt, "HUSBAND_NAME_4");
            txtWifeName11.DataBindings.Add("Text", Dt, "WIFE_NAME_1_1");
            txtWifeName12.DataBindings.Add("Text", Dt, "WIFE_NAME_1_2");
            txtWifeName13.DataBindings.Add("Text", Dt, "WIFE_NAME_1_3");
            txtWifeName14.DataBindings.Add("Text", Dt, "WIFE_NAME_1_4");
            txtWifeName21.DataBindings.Add("Text", Dt, "WIFE_NAME_2_1");
            txtWifeName22.DataBindings.Add("Text", Dt, "WIFE_NAME_2_2");
            txtWifeName23.DataBindings.Add("Text", Dt, "WIFE_NAME_2_3");
            txtWifeName24.DataBindings.Add("Text", Dt, "WIFE_NAME_2_4");
            txtWifeName31.DataBindings.Add("Text", Dt, "WIFE_NAME_3_1");
            txtWifeName32.DataBindings.Add("Text", Dt, "WIFE_NAME_3_2");
            txtWifeName33.DataBindings.Add("Text", Dt, "WIFE_NAME_3_3");
            txtWifeName34.DataBindings.Add("Text", Dt, "WIFE_NAME_3_4");
            txtWifeName41.DataBindings.Add("Text", Dt, "WIFE_NAME_4_1");
            txtWifeName42.DataBindings.Add("Text", Dt, "WIFE_NAME_4_2");
            txtWifeName43.DataBindings.Add("Text", Dt, "WIFE_NAME_4_3");
            txtWifeName44.DataBindings.Add("Text", Dt, "WIFE_NAME_4_4");
            cmbEmpHomeAddress1.DataBindings.Add("Text", Dt, "EMP_HOME_ADDRESS_1");
            cmbEmpHomeAddress2.DataBindings.Add("Text", Dt, "EMP_HOME_ADDRESS_2");
            txtEmpHomeAddress3.DataBindings.Add("Text", Dt, "EMP_HOME_ADDRESS_3");
            txtEmpHomeAddress4.DataBindings.Add("Text", Dt, "EMP_HOME_ADDRESS_4");
            txtEmpHomeAddress5.DataBindings.Add("Text", Dt, "EMP_HOME_ADDRESS_5");
            txtMayorName.DataBindings.Add("Text", Dt, "MAYOR_NAME");
            txtClosestPlace.DataBindings.Add("Text", Dt, "CLOSEST_PLACE");
            txtPhoneNumber1.DataBindings.Add("Text", Dt, "PHONE_NUMBER_1");
            txtPhoneNumber2.DataBindings.Add("Text", Dt, "PHONE_NUMBER_2");
            txtEMaile.DataBindings.Add("Text", Dt, "E_MAIL");
            txtNationalCardNumber.DataBindings.Add("Text", Dt, "NATIONAL_CARD_NUMBER");
            cmbNationalCardExport.DataBindings.Add("Text", Dt, "NATIONAL_CARD_EXPORT");
            dtpNationalCardDateExport.DataBindings.Add("Text", Dt, "NATIONAL_CARD_DATE_EXPORT");
            dtpNationalCardDateExpire.DataBindings.Add("Text", Dt, "NATIONAL_CARD_DATE_EXPIRE");
            txtResidenceCardNumber.DataBindings.Add("Text", Dt, "RESIDENCE_CARD_NUMBER");
            cmbResidenceCardOfficeName.DataBindings.Add("Text", Dt, "RESIDENCE_CARD_OFFICE_NAME");
            dtpResidenceCardExportDate.DataBindings.Add("Text", Dt, "RESIDENCE_CARD_EXPORT_DATE");
            txtSupplyCardNumber.DataBindings.Add("Text", Dt, "SUPPLY_CARD_NUMBER");
            txtSupplyCenterCardNumber.DataBindings.Add("Text", Dt, "SUPPLY_CENTER_CARD_NUMBER");
            cmbSupplyCardName.DataBindings.Add("Text", Dt, "SUPPLY_CARD_NAME");
            txtPassportNumber.DataBindings.Add("Text", Dt, "PASSPORT_NUMBER");
            cmbPassportLssuingAuthority.DataBindings.Add("Text", Dt, "PASSPORT_LSSUING_AUTHORITY");
            dtpPassportDateExport.DataBindings.Add("Text", Dt, "PASSPORT_DATE_EXPORT");
            dtpPassportDateExpire.DataBindings.Add("Text", Dt, "PASSPORT_DATE_EXPIRE");
            cmbStudyCertificate.DataBindings.Add("Text", Dt, "STUDY_CERTIFICATE");
            cmbStudySpecialization.DataBindings.Add("Text", Dt, "STUDY_SPECIALIZATION");
            cmbStudyCompletionYear.DataBindings.Add("Text", Dt, "STUDY_COMPLETION_YEAR");
            txtRegNumber.DataBindings.Add("Text", Dt, "REG_NUMBER");
            txtIdNumber.DataBindings.Add("Text", Dt, "ID_NUMBER");
            dtpAppointmentDate.DataBindings.Add("Text", Dt, "APPOINTMENT_DATE");
            dtpDirectWorkDate.DataBindings.Add("Text", Dt, "DIRECT_WORK_DATE");
            cmbJopTitle.DataBindings.Add("Text", Dt, "JOP_TITLE");
            cmbJopType.DataBindings.Add("Text", Dt, "JOP_TYPE");
            cmbWorkSection1.DataBindings.Add("Text", Dt, "WORK_SECTION_1");
            cmbWorkSection2.DataBindings.Add("Text", Dt, "WORK_SECTION_2");
            cmbWorkSection3.DataBindings.Add("Text", Dt, "WORK_SECTION_3");
            cmbWorkType.DataBindings.Add("Text", Dt, "WORK_TYPE");
            cmbWorkQuotaName.DataBindings.Add("Text", Dt, "WORK_QUOTA_NAME");
            cmbPlaceWork.DataBindings.Add("Text", Dt, "PLACE_WORK");
            cm = (CurrencyManager)this.BindingContext[Dt];
        }
        private void btnEmpSearch_Click(object sender, EventArgs e)//زر البحث وعرض معلومات موظف معين
        {
            btnEditOrSaveEmp.Text = "تعديل";
            Dt.Clear();
            Da = dirEditDeleteEmp.DIR_EMP_INFO(cmbFullEmpName.Text);
            Da.Fill(Dt);

            if (Dt.Rows.Count > 0)
            {
                string EmpPicture = Dt.Rows[0].Field<string>("EMP_PICTURE");
                btnEditOrSaveEmp.Enabled = true;
                btnDeleteAllEmpInfo.Enabled = true;
            }
            else
            {
                btnEditOrSaveEmp.Enabled = false;
                btnDeleteAllEmpInfo.Enabled = false;
                MessageBox.Show("لا توجد نتائج بحث", "معلومات الموظف", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            disableFormFields();

    }
}