public List <COMPANIES_RMAGDC> LoadAll()
        {
            DBConnection            objConnection       = new DBConnection();
            COMPANIES_RMAGDA        objCOMPANIES_RMAGDA = new COMPANIES_RMAGDA();
            List <COMPANIES_RMAGDC> objCOMPANIES_RMAGDC = null;

            try
            {
                objConnection.Open(false);
                objCOMPANIES_RMAGDC = objCOMPANIES_RMAGDA.LoadAll(objConnection);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objConnection.Close();
            }
            return(objCOMPANIES_RMAGDC);
        }