public int Insert(List <COMPANIES_RMAGDC> objCOMPANIES_RMAGs)
        {
            int              insertedCount       = 0;
            DBConnection     objConnection       = new DBConnection();
            COMPANIES_RMAGDA objCOMPANIES_RMAGDA = new COMPANIES_RMAGDA();

            try
            {
                objConnection.Open(true);
                insertedCount = objCOMPANIES_RMAGDA.Insert(objConnection, objCOMPANIES_RMAGs);
                objConnection.Commit();
            }
            catch (Exception ex)
            {
                objConnection.Rollback();
                throw ex;
            }
            finally
            {
                objConnection.Close();
            }
            return(insertedCount);
        }