private void FrmEditEmployees_Load(object sender, EventArgs e)
        {
            label1.Text = _id.ToString();
            Employee employee;
            JobTitle title;

            using (Context context = new Context())
            {
                employee = context.Employees.SingleOrDefault(a => a.ID == _id);
                jobtitle = context.JobTitles;
                title    = jobtitle.SingleOrDefault(a => a.ID == employee.JobID);
                combodepartment.DataSource    = context.Department;
                combodepartment.ValueMember   = "ID";
                combodepartment.DisplayMember = "DepartmentName";
                combojob.DataSource           = context.JobTitles;
                combojob.ValueMember          = "ID";
                combojob.DisplayMember        = "Name";
            }
            txtname.Text         = employee.Name;
            topdownNumic.Maximum = Convert.ToDecimal(title.RangMax);
            topdownNumic.Minimum = Convert.ToDecimal(title.RangMin);
            topdownNumic.Value   = Convert.ToDecimal(employee.Salary);
            ImageConverter converter = new ImageConverter();

            orignalImage                  = employee.Picture;
            pictureBox1.Image             = (Image)converter.ConvertFrom(orignalImage);
            hiredate.Value                = employee.HiredDate;
            birthdate.Value               = employee.DateOfBirth;
            combodepartment.SelectedValue = employee.DepartmentID;
            combojob.SelectedValue        = employee.JobID;
            comboGender.Text              = employee.Geneder;
            comboStatus.Text              = employee.MaritalStatus;
            txtusername.Text              = employee.username;
            txtpassword.Text              = EncryptionAndDescrption.DecryptString(employee.password);
        }
        private void btnEdit_Click(object sender, EventArgs e)
        {
            Employee employees = new Employee();

            using (EncryptionAndDescrption cn = new EncryptionAndDescrption())
            {
                employees.password = cn.Encryption(txtpassword.Text);
            }
            employees.ID   = _id;
            employees.Name = txtname.Text;

            employees.username      = txtusername.Text;
            employees.DateOfBirth   = birthdate.Value;
            employees.HiredDate     = hiredate.Value;
            employees.JobID         = Convert.ToInt32(combojob.SelectedValue);
            employees.DepartmentID  = Convert.ToInt32(combodepartment.SelectedValue);
            employees.Geneder       = comboGender.Text;
            employees.MaritalStatus = comboStatus.Text;
            employees.Salary        = Convert.ToDouble(topdownNumic.Value);
            if (picture != null)
            {
                employees.Picture = picture;
            }
            else
            {
                employees.Picture = orignalImage;
            }

            if (employees.EditEmployees(employees))
            {
                MessageBox.Show("لقد تم التعديل", "رسالة", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }
 private void btnAdd_Click(object sender, EventArgs e)
 {
     try
     {
         if (image == null)
         {
             throw new Exception("قم باضافة الصورة");
         }
         using (Employee employee = new Employee())
         {
             employee.Name          = txtname.Text;
             employee.Salary        = Convert.ToDouble(minandMax.Value);
             employee.DepartmentID  = Convert.ToInt32(comboDepartment.SelectedValue);
             employee.HiredDate     = dateHire.Value;
             employee.DateOfBirth   = dateBirth.Value;
             employee.Picture       = image;
             employee.MaritalStatus = comboStatus.Text;
             employee.Geneder       = comboGender.Text;
             employee.JobID         = Convert.ToInt32(comboJobTitle.SelectedValue);
             employee.username      = txtusername.Text;
             using (EncryptionAndDescrption cn = new EncryptionAndDescrption())
             {
                 employee.password = cn.Encryption(txtpassword.Text);
             }
             if (employee.InsertEmployees(employee))
             {
                 MessageBox.Show("لقد تم اضافة الموظفين", "رسالة ", MessageBoxButtons.OK, MessageBoxIcon.Information);
                 SelectInformation();
             }
             else
             {
                 MessageBox.Show("يوجد خطاء في ادخال البيانات", "رسالة ", MessageBoxButtons.OK, MessageBoxIcon.Error);
             }
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message, "رسالة ", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }