//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); } }