public void LoadData()
        {
            //-----------------------------------------------------
            lueIDCompanies.Properties.DataSource = this.LoadListCompaniesByType();
            lueIDCompanies.Properties.ValueMember = "ID";
            lueIDCompanies.Properties.DisplayMember = "Name";
            //-----------------------------------------------------

            this.aListPaymentExt_GetAllDataEN = new List<PaymentExt_GetAllDataEN>();
            List<sp_PaymentExt_GetAllData_Ext_Result> aListData = new List<sp_PaymentExt_GetAllData_Ext_Result>();
            DatabaseDA aDatabaseDA = new DatabaseDA();

            aListData = aDatabaseDA.sp_PaymentExt_GetAllData_Ext().ToList();
            PaymentExt_GetAllDataEN aPaymentExt_GetAllDataEN;

            foreach (sp_PaymentExt_GetAllData_Ext_Result item in aListData)
            {

                aPaymentExt_GetAllDataEN = new PaymentExt_GetAllDataEN();
                aPaymentExt_GetAllDataEN.SetValue(item);
                if (item.Service_PaymentStatus == null)
                {
                    aPaymentExt_GetAllDataEN.DisplayService_PaymentStatus = "";
                }

                else if (item.Service_PaymentStatus == 8 )
                {
                    aPaymentExt_GetAllDataEN.DisplayService_PaymentStatus = "Đã thanh toán";
                }
                else
                {
                    //aPaymentExt_GetAllDataEN.DisplayService_PaymentStatus = "Chưa thanh toán";
                    aPaymentExt_GetAllDataEN.DisplayService_PaymentStatus = "";

                }

                //-----------------------------------------------------------
                if (item.Object_PaymentStatus == null)
                {
                    aPaymentExt_GetAllDataEN.DisplayObject_PaymentStatus = "";
                }

                else if (item.Object_PaymentStatus == 8)
                {
                    aPaymentExt_GetAllDataEN.DisplayObject_PaymentStatus = "Đã thanh toán";
                }
                else
                {
                    //aPaymentExt_GetAllDataEN.DisplayObject_PaymentStatus = "Chưa thanh toán";
                    aPaymentExt_GetAllDataEN.DisplayObject_PaymentStatus = "";

                }
                //------------------------------------------------------------------------------------
                if (item.BillR_PaymentStatus == 8)
                {
                    aPaymentExt_GetAllDataEN.DisplayBillR_PaymentStatus = "Đã thanh toán";
                }
                else
                {
                    //aPaymentExt_GetAllDataEN.DisplayBillR_PaymentStatus = "Chưa thanh toán";
                    aPaymentExt_GetAllDataEN.DisplayBillR_PaymentStatus = "";
                }
                //------------------------------------------------------------
                if (item.Object_InvoiceDate.GetValueOrDefault().Year == 0001 || item.Object_InvoiceDate.GetValueOrDefault().Year == 1900)
                {
                    aPaymentExt_GetAllDataEN.Object_InvoiceDate = "";
                }
                //------------------------------------------------------------
                if (item.Object_AcceptDate.GetValueOrDefault().Year == 0001 || item.Object_AcceptDate.GetValueOrDefault().Year == 1900)
                {
                    aPaymentExt_GetAllDataEN.Object_AcceptDate = null;
                }
                aListPaymentExt_GetAllDataEN.Add(aPaymentExt_GetAllDataEN);
            }
            dgvPaymentViewAll.DataSource = aListPaymentExt_GetAllDataEN;
            dgvPaymentViewAll.RefreshDataSource();
        }