// ////////////////////////////////////////////////////////////////////////
        // PUBLIC METHODS - DATASET
        //
        /// <summary>
        /// LoadAll
        /// </summary>
        /// <param name="companyId">companyId</param>
        public void LoadAll(int companyId)
        {
            BondingCompaniesSetupBondingCompaniesSetupGateway bondingCompaniesSetupBondingCompaniesSetupGateway = new BondingCompaniesSetupBondingCompaniesSetupGateway(Data);
            bondingCompaniesSetupBondingCompaniesSetupGateway.LoadAll(companyId);

            UpdateDataForNavigators();
        }
        /// <summary>
        /// Save all bondingCompanies to database (direct)
        /// </summary>
        /// <param name="companyId">companyId</param>        
        public void Save(int companyId)
        {
            BondingCompaniesSetupTDS subcontractorSetupChanges = (BondingCompaniesSetupTDS)Data.GetChanges();

            if (subcontractorSetupChanges != null)
            {
                if (subcontractorSetupChanges.BondingCompaniesSetup.Rows.Count > 0)
                {
                    BondingCompaniesSetupBondingCompaniesSetupGateway bondingCompaniesSetupBondingCompaniesSetupGateway = new BondingCompaniesSetupBondingCompaniesSetupGateway(subcontractorSetupChanges);

                    foreach (BondingCompaniesSetupTDS.BondingCompaniesSetupRow row in (BondingCompaniesSetupTDS.BondingCompaniesSetupDataTable)subcontractorSetupChanges.BondingCompaniesSetup)
                    {

                        // Delete bondingCompanies
                        if (row.Deleted)
                        {
                            BondingCompanies bondingCompanies = new BondingCompanies(null);
                            bondingCompanies.DeleteDirect(row.COMPANIES_ID, row.Date);
                        }
                    }
                }
            }
        }