public void ReloadData()
 {
     try
     {
         CertificatesBO aCertificatesBO = new CertificatesBO();
         dgvCertificates.DataSource = aCertificatesBO.Select_All();
         dgvCertificates.RefreshDataSource();
     }
     catch (Exception ex)
     {
         MessageBox.Show("frmLst_Certificates.ReloadData\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }
        public void ReloadCertificate()
        {
            try
            {
                CertificatesBO aCertificatesBO = new CertificatesBO();
                List<Certificates> aListCertificates = new List<Certificates>();
                aListCertificates = aCertificatesBO.Select_All();
                lueCertificates.Properties.DataSource = aListCertificates;
                lueCertificates.Properties.DisplayMember = "Organization";
                lueCertificates.Properties.ValueMember = "ID";

            }
            catch (Exception ex)
            {
                MessageBox.Show("frmTsk_SystemUser_Infromation.ReloadCertificate\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
 private void btnDelete_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
 {
     try
     {
         int ID = int.Parse(grvCertificates.GetFocusedRowCellValue("ID").ToString());
         DialogResult result = MessageBox.Show("Bạn có muốn xóa Certificates " + ID + " này không?", "Xóa Certificates", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
         if (result == DialogResult.Yes)
         {
             CertificatesBO aCertificatesBO = new CertificatesBO();
             aCertificatesBO.Delete(ID);
             MessageBox.Show("Xóa thành công");
             this.ReloadData();
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show("frmLst_Certificates.btnDelete_ButtonClick\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }
        private void btnAddSystemUsers_Certificates_Click(object sender, EventArgs e)
        {
            try
            {
                if (this.CheckDataBeforeAddSystemUsers_Certificates() == true)
                {
                    List<SystemUsers_CertificatesEN> aListTemp = aSystemUsersEN.aListSystemUsers_CertificatesEN.Where(s => s.ID == SystemUsers_CertificatesID).ToList();
                    if (aListTemp.Count > 0)
                    {
                        SystemUsers_CertificatesEN aItem = aSystemUsersEN.aListSystemUsers_CertificatesEN.Where(s => s.ID == SystemUsers_CertificatesID).ToList()[0];
                        aSystemUsersEN.aListSystemUsers_CertificatesEN.Remove(aItem);
                    }

                    SystemUsers_CertificatesEN aSystemUsers_CertificatesEN = new SystemUsers_CertificatesEN();
                    CertificatesBO aCertificatesBO = new CertificatesBO();
                    Count = Count + 1;
                    aSystemUsers_CertificatesEN.ID = Count;

                    aSystemUsers_CertificatesEN.IDCertificate = Convert.ToInt32(lueCertificates.EditValue);
                    if (Convert.ToInt32(lueCertificates.EditValue) > 0)
                    {
                        aSystemUsers_CertificatesEN.Certificate = aCertificatesBO.Select_ByID(Convert.ToInt32(lueCertificates.EditValue)).Organization;
                    }
                    aSystemUsers_CertificatesEN.TrainingType = Convert.ToString(lueSystemUsers_CertificatesTrainningType.EditValue);

                    if (dtpSystemUsers_CertificatesCreatedDate.EditValue != null)
                    {
                        aSystemUsers_CertificatesEN.CreatedDate = dtpSystemUsers_CertificatesCreatedDate.DateTime;
                    }

                    if (dtpSystemUsers_CertificatesExpirationDate.EditValue != null)
                    {
                        aSystemUsers_CertificatesEN.ExpirationDate = dtpSystemUsers_CertificatesExpirationDate.DateTime;
                    }

                    aSystemUsers_CertificatesEN.Level = Convert.ToString(lueSystemUsers_CertificatesLevel.EditValue);

                    if (Convert.ToInt32(lueSystemUsers_CertificatesLevel.EditValue) > 0)
                    {
                        aSystemUsers_CertificatesEN.LevelDisplay = CORE.CONSTANTS.SelectedSystemUsers_Certificates_Level(Convert.ToInt32(lueSystemUsers_CertificatesLevel.EditValue)).Name;
                    }

                    aSystemUsersEN.aListSystemUsers_CertificatesEN.Add(aSystemUsers_CertificatesEN);

                    dgvSystemUsers_Certificates.DataSource = aSystemUsersEN.aListSystemUsers_CertificatesEN;
                    dgvSystemUsers_Certificates.RefreshDataSource();

                    lueCertificates.EditValue = 0;
                    lueCertificates.Properties.NullText = "  Chọn lựa ";
                    lueSystemUsers_CertificatesLevel.EditValue = 0;
                    lueSystemUsers_CertificatesLevel.Properties.NullText = " Chọn lựa ";
                    dtpSystemUsers_CertificatesCreatedDate.EditValue = null;
                    dtpSystemUsers_CertificatesExpirationDate.EditValue = null;
                    lueSystemUsers_CertificatesTrainningType.EditValue = 0;
                    lueSystemUsers_CertificatesTrainningType.Properties.NullText = " Chọn lựa ";
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("frmTsk_SystemUser_Infromation.btnAddSystemUsers_Certificates_Click\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }