private void btnAddMember_Click(object sender, EventArgs e)
        {
            try
            {
                if (this.CheckDataBeforeAddFamilyMembers() == true)
                {
                    List<FamilyMembersExtEN> aListTemp = aSystemUsersEN.aListFamilyMembersExtEN.Where(f => f.ID == FamilyMemberID).ToList();
                    if (aListTemp.Count > 0)
                    {
                        FamilyMembersExtEN aItem = aSystemUsersEN.aListFamilyMembersExtEN.Where(f => f.ID == FamilyMemberID).ToList()[0];
                        aSystemUsersEN.aListFamilyMembersExtEN.Remove(aItem);
                    }

                    FamilyMembersExtEN aFamilyMembersExtEN = new FamilyMembersExtEN();

                    Count = Count + 1;
                    aFamilyMembersExtEN.ID = Count;
                    aFamilyMembersExtEN.Name = txtFamilyMembersName.Text;
                    aFamilyMembersExtEN.RelationType = Convert.ToInt32(lueFamilyMembersRelationType.EditValue);
                    if (Convert.ToInt32(lueFamilyMembersRelationType.EditValue) > 0)
                    {
                        aFamilyMembersExtEN.RelationDisplay = CORE.CONSTANTS.SelectedRelationType(Convert.ToInt32(lueFamilyMembersRelationType.EditValue)).Name;
                    }

                    if (dtpFamilyMembersBirthday.EditValue != null)
                    {
                        aFamilyMembersExtEN.Birthday = dtpFamilyMembersBirthday.DateTime;
                    }
                    aFamilyMembersExtEN.Info = txaFamilyMembersInfo.Text;

                    aSystemUsersEN.aListFamilyMembersExtEN.Add(aFamilyMembersExtEN);
                    dgvFamilyMembers.DataSource = aSystemUsersEN.aListFamilyMembersExtEN;
                    dgvFamilyMembers.RefreshDataSource();

                    txtFamilyMembersName.Text = "";
                    lueFamilyMembersRelationType.EditValue = 0;
                    lueFamilyMembersRelationType.Properties.NullText = " Chọn lựa ";
                    dtpFamilyMembersBirthday.EditValue = null;
                    txaFamilyMembersInfo.Text = "";
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("frmTsk_SystemUser_Infromation.btnAddMember_Click\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
        private void btnPrint_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
        {
            SystemUsersBO aSysUserBO = new SystemUsersBO();
            UserInfomationEN aUserInfomationEN = new UserInfomationEN();
             int IDSystemUser = int.Parse(grvSystemUser.GetFocusedRowCellValue("ID").ToString());
            // Thong tin cua SystemUser
            SystemUsers aSystemUsers = aSysUserBO.Select_ByID(IDSystemUser);
             aUserInfomationEN.ID = IDSystemUser;
             aUserInfomationEN.Name = aSystemUsers.Name;
             aUserInfomationEN.Gender = aSystemUsers.Gender;
             aUserInfomationEN.Birthday = aSystemUsers.Birthday;
             aUserInfomationEN.Identifier1 = aSystemUsers.Identifier1;
             aUserInfomationEN.Identifier1CreatedDate = aSystemUsers.Identifier1CreatedDate;
             aUserInfomationEN.PlaceOfIssue1 = aSystemUsers.PlaceOfIssue1;
             aUserInfomationEN.Image = aSystemUsers.Image;
            // Thong tin cua SystemUserExt
             SystemUserExts aSystemUserExts = aSystemUserExtsBO.Select_ByIDSystemUser(IDSystemUser);
             aUserInfomationEN.aSystemUserExts = aSystemUserExts;

             // Thong tin bang chinh quy
             List<CertificateExtInfoEN> aListCertificateExt_Regular = new List<CertificateExtInfoEN>();
             List<vw__CertificatesInfo__SystemUsers_Certificates> aTemp_Regular = aCertificatesBO.GetRegularCertificate(IDSystemUser);
             CertificateExtInfoEN aCertificateExtInfoEN_Regular;
             for (int i = 0; i < aTemp_Regular.Count; i++)
             {
                 aCertificateExtInfoEN_Regular = new CertificateExtInfoEN();
                 aCertificateExtInfoEN_Regular.Certificates_Organization = aTemp_Regular[i].Certificates_Organization;
                 aCertificateExtInfoEN_Regular.Certificates_Certificates = aTemp_Regular[i].Certificates_Certificates;
                 if (aTemp_Regular[i].SystemUsers_Certificates_Level == "1")
                 {
                     aCertificateExtInfoEN_Regular.SystemUsers_Certificates_Level = "Giỏi";
                 }
                 else if (aTemp_Regular[i].SystemUsers_Certificates_Level == "2")
                 {
                     aCertificateExtInfoEN_Regular.SystemUsers_Certificates_Level = "Khá";
                 }
                 else
                 {
                     aCertificateExtInfoEN_Regular.SystemUsers_Certificates_Level = "Trung bình";
                 }
                 aCertificateExtInfoEN_Regular.SystemUsers_Certificates_CreatedDate = aTemp_Regular[i].SystemUsers_Certificates_CreatedDate;
                 aCertificateExtInfoEN_Regular.SystemUsers_Certificates_ExpirationDate = aTemp_Regular[i].SystemUsers_Certificates_ExpirationDate;

                 if (aTemp_Regular[i].SystemUsers_Certificates_TrainingType == "1")
                 {
                     aCertificateExtInfoEN_Regular.TrainingTypeDisplay = "Chính Quy";
                 }
                 else if (aTemp_Regular[i].SystemUsers_Certificates_TrainingType == "2")
                 {
                     aCertificateExtInfoEN_Regular.TrainingTypeDisplay = "Tại chức";
                 }
                 else if (aTemp_Regular[i].SystemUsers_Certificates_TrainingType == "3")
                 {
                     aCertificateExtInfoEN_Regular.TrainingTypeDisplay = "Văn bằng 2";
                 }
                 else if (aTemp_Regular[i].SystemUsers_Certificates_TrainingType == "4")
                 {
                     aCertificateExtInfoEN_Regular.TrainingTypeDisplay = "Liên thông";
                 }
                 else if (aTemp_Regular[i].SystemUsers_Certificates_TrainingType == "5")
                 {
                     aCertificateExtInfoEN_Regular.TrainingTypeDisplay = "Chứng chỉ";
                 }
                 else
                 {
                     aCertificateExtInfoEN_Regular.TrainingTypeDisplay = "Từ xa";
                 }

                 aListCertificateExt_Regular.Add(aCertificateExtInfoEN_Regular);
             }
             aUserInfomationEN.aListCertificateExt_Regular = aListCertificateExt_Regular;
             // Thong tin chung chi phu
             List<CertificateExtInfoEN> aListCertificateExt_Sub = new List<CertificateExtInfoEN>();
             List<vw__CertificatesInfo__SystemUsers_Certificates> aTemp_Sub = aCertificatesBO.GetSubCertificate(IDSystemUser);
             CertificateExtInfoEN aCertificateExtInfoEN_Sub;
             for (int i = 0; i < aTemp_Sub.Count; i++)
             {
                 aCertificateExtInfoEN_Sub = new CertificateExtInfoEN();
                 aCertificateExtInfoEN_Sub.Certificates_Organization = aTemp_Sub[i].Certificates_Organization;
                 aCertificateExtInfoEN_Sub.Certificates_Certificates = aTemp_Sub[i].Certificates_Certificates;
                 if (aTemp_Sub[i].SystemUsers_Certificates_Level == "1")
                 {
                     aCertificateExtInfoEN_Sub.SystemUsers_Certificates_Level = "Giỏi";
                 }
                 else if (aTemp_Sub[i].SystemUsers_Certificates_Level == "2")
                 {
                     aCertificateExtInfoEN_Sub.SystemUsers_Certificates_Level = "Khá";
                 }
                 else
                 {
                     aCertificateExtInfoEN_Sub.SystemUsers_Certificates_Level = "Trung bình";
                 }
                 aCertificateExtInfoEN_Sub.SystemUsers_Certificates_CreatedDate = aTemp_Sub[i].SystemUsers_Certificates_CreatedDate;
                 aCertificateExtInfoEN_Sub.SystemUsers_Certificates_ExpirationDate = aTemp_Sub[i].SystemUsers_Certificates_ExpirationDate;
                 aCertificateExtInfoEN_Sub.SystemUsers_Certificates_TrainingType = aTemp_Sub[i].SystemUsers_Certificates_TrainingType;
                 if (aTemp_Sub[i].SystemUsers_Certificates_TrainingType == "1")
                 {
                     aCertificateExtInfoEN_Sub.TrainingTypeDisplay = "Chính Quy";
                 }
                 else if (aTemp_Sub[i].SystemUsers_Certificates_TrainingType == "2")
                 {
                     aCertificateExtInfoEN_Sub.TrainingTypeDisplay = "Tại chức";
                 }
                 else if (aTemp_Sub[i].SystemUsers_Certificates_TrainingType == "3")
                 {
                     aCertificateExtInfoEN_Sub.TrainingTypeDisplay = "Văn bằng 2";
                 }
                 else if (aTemp_Sub[i].SystemUsers_Certificates_TrainingType == "4")
                 {
                     aCertificateExtInfoEN_Sub.TrainingTypeDisplay = "Liên thông";
                 }
                 else if (aTemp_Sub[i].SystemUsers_Certificates_TrainingType == "5")
                 {
                     aCertificateExtInfoEN_Sub.TrainingTypeDisplay = "Chứng chỉ";
                 }
                 else
                 {
                     aCertificateExtInfoEN_Sub.TrainingTypeDisplay = "Từ xa";
                 }
                 aListCertificateExt_Sub.Add(aCertificateExtInfoEN_Sub);
             }
             aUserInfomationEN.aListCertificateExt_Sub = aListCertificateExt_Sub;
             // Thong tin chung chi Ly luan chinh tri + Quan ly nha nuoc
             List<CertificateExtInfoEN> aListCertificateExt_PoliticGorvenmentManager = new List<CertificateExtInfoEN>();
             List<vw__CertificatesInfo__SystemUsers_Certificates> aTemp_PoliticGorvenmentManager = aCertificatesBO.GetPoliticalGorvenmentManagerCertificate(IDSystemUser);
             CertificateExtInfoEN aCertificateExtInfoEN_PoliticGorvenmentManager;
             for (int i = 0; i < aTemp_PoliticGorvenmentManager.Count; i++)
             {
                 aCertificateExtInfoEN_PoliticGorvenmentManager = new CertificateExtInfoEN();
                 aCertificateExtInfoEN_PoliticGorvenmentManager.Certificates_Organization = aTemp_PoliticGorvenmentManager[i].Certificates_Organization;
                 aCertificateExtInfoEN_PoliticGorvenmentManager.Certificates_Certificates = aTemp_PoliticGorvenmentManager[i].Certificates_Certificates;
                 if (aTemp_PoliticGorvenmentManager[i].SystemUsers_Certificates_Level == "1")
                 {
                     aCertificateExtInfoEN_PoliticGorvenmentManager.SystemUsers_Certificates_Level = "Giỏi";
                 }
                 else if (aTemp_PoliticGorvenmentManager[i].SystemUsers_Certificates_Level == "2")
                 {
                     aCertificateExtInfoEN_PoliticGorvenmentManager.SystemUsers_Certificates_Level = "Khá";
                 }
                 else
                 {
                     aCertificateExtInfoEN_PoliticGorvenmentManager.SystemUsers_Certificates_Level = "Trung bình";
                 }
                 aCertificateExtInfoEN_PoliticGorvenmentManager.SystemUsers_Certificates_CreatedDate = aTemp_PoliticGorvenmentManager[i].SystemUsers_Certificates_CreatedDate;
                 aCertificateExtInfoEN_PoliticGorvenmentManager.SystemUsers_Certificates_ExpirationDate = aTemp_PoliticGorvenmentManager[i].SystemUsers_Certificates_ExpirationDate;
                 aCertificateExtInfoEN_PoliticGorvenmentManager.SystemUsers_Certificates_TrainingType = aTemp_PoliticGorvenmentManager[i].SystemUsers_Certificates_TrainingType;
                 if (aTemp_PoliticGorvenmentManager[i].SystemUsers_Certificates_TrainingType == "1")
                 {
                     aCertificateExtInfoEN_PoliticGorvenmentManager.TrainingTypeDisplay = "Chính Quy";
                 }
                 else if (aTemp_PoliticGorvenmentManager[i].SystemUsers_Certificates_TrainingType == "2")
                 {
                     aCertificateExtInfoEN_PoliticGorvenmentManager.TrainingTypeDisplay = "Tại chức";
                 }
                 else if (aTemp_PoliticGorvenmentManager[i].SystemUsers_Certificates_TrainingType == "3")
                 {
                     aCertificateExtInfoEN_PoliticGorvenmentManager.TrainingTypeDisplay = "Văn bằng 2";
                 }
                 else if (aTemp_PoliticGorvenmentManager[i].SystemUsers_Certificates_TrainingType == "4")
                 {
                     aCertificateExtInfoEN_PoliticGorvenmentManager.TrainingTypeDisplay = "Liên thông";
                 }
                 else if (aTemp_PoliticGorvenmentManager[i].SystemUsers_Certificates_TrainingType == "5")
                 {
                     aCertificateExtInfoEN_PoliticGorvenmentManager.TrainingTypeDisplay = "Chứng chỉ";
                 }
                 else
                 {
                     aCertificateExtInfoEN_PoliticGorvenmentManager.TrainingTypeDisplay = "Từ xa";
                 }
                 aListCertificateExt_PoliticGorvenmentManager.Add(aCertificateExtInfoEN_PoliticGorvenmentManager);
             }
             aUserInfomationEN.aListCertificateExt_PoliticGorvenmentManager = aListCertificateExt_PoliticGorvenmentManager;
            // Thong tin gia dinh
             List<FamilyMembersExtEN> aListFamilyMembersExtEN = new List<FamilyMembersExtEN>();
             List<FamilyMembers> aTemp_FamilyMembers = aFamilyMembersBO.Select_ByIDSystemUser(IDSystemUser);
             FamilyMembersExtEN aFamilyMembersExtEN;
             for (int i = 0; i < aTemp_FamilyMembers.Count; i++)
             {
                 aFamilyMembersExtEN = new FamilyMembersExtEN();
                 aFamilyMembersExtEN.Name = aTemp_FamilyMembers[i].Name;
                 aFamilyMembersExtEN.Birthday = aTemp_FamilyMembers[i].Birthday;
                 aFamilyMembersExtEN.Info = aTemp_FamilyMembers[i].Info;
                 if (aTemp_FamilyMembers[i].RelationType == 1)
                 {
                     aFamilyMembersExtEN.RelationDisplay = "Bố";
                 }
                 else if (aTemp_FamilyMembers[i].RelationType == 2)
                 {
                     aFamilyMembersExtEN.RelationDisplay = "Mẹ";
                 }
                 else if (aTemp_FamilyMembers[i].RelationType == 3)
                 {
                     aFamilyMembersExtEN.RelationDisplay = "Anh/Chị/Em";
                 }
                 else if (aTemp_FamilyMembers[i].RelationType == 4)
                 {
                     aFamilyMembersExtEN.RelationDisplay = "Con cái";
                 }
                 aListFamilyMembersExtEN.Add(aFamilyMembersExtEN);
             }
             aUserInfomationEN.aListFamilyMembers = aListFamilyMembersExtEN;
            // Thong tin qua trinh cong tac
             aUserInfomationEN.aListAuditHistories = aAuditHistoriesBO.Select_ByIDSystemUser(IDSystemUser);
            // Thong tin khen thuong
             aUserInfomationEN.aListReward = aRewardAndPunishmentsBO.Select_ByIDSystemUser_ByType(IDSystemUser,1);
             // Thong tin khen thuong
             aUserInfomationEN.aListPunishments = aRewardAndPunishmentsBO.Select_ByIDSystemUser_ByType(IDSystemUser, 2);
            // Thong tin giay to #
             aUserInfomationEN.aListDocumentSystemUsers = aDocumentSystemUsersBO.Select_ByIDSystemUser(IDSystemUser);
             frmRpt_SystemUserInfo aReport = new frmRpt_SystemUserInfo(aUserInfomationEN);
             ReportPrintTool tool = new ReportPrintTool(aReport);
             tool.ShowPreview();
        }