//Author : LinhTing
 public List<SystemUsers_CertificatesEN> GetCertificateInfo(int IDSystemUser)
 {
     List<vw__CertificatesInfo__SystemUsers_Certificates> aListTemp = new List<vw__CertificatesInfo__SystemUsers_Certificates>();
     aListTemp = aDatabaseDA.vw__CertificatesInfo__SystemUsers_Certificates.Where(a => a.SystemUsers_ID == IDSystemUser).ToList();
     List<SystemUsers_CertificatesEN> aListReturn = new List<SystemUsers_CertificatesEN>();
     SystemUsers_CertificatesEN aSystemUsers_CertificatesEN;
     for (int i = 0; i < aListTemp.Count; i++)
     {
         aSystemUsers_CertificatesEN = new SystemUsers_CertificatesEN();
         aSystemUsers_CertificatesEN.Name = aListTemp[i].SystemUsers_Name;
         aSystemUsers_CertificatesEN.Certificate = aListTemp[i].Certificates_Certificates;
         aSystemUsers_CertificatesEN.CreatedDate = aListTemp[i].SystemUsers_Certificates_CreatedDate;
         aSystemUsers_CertificatesEN.ExpirationDate = aListTemp[i].SystemUsers_Certificates_ExpirationDate;
         aSystemUsers_CertificatesEN.Organization_SystemUsers_Certificates = aListTemp[i].Certificates_Organization;
         aListReturn.Add(aSystemUsers_CertificatesEN);
     }
     return aListReturn;
 }
        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);
            }
        }