ArcGISCompare.msAccProcs.WriteAttributeMapping C# (CSharp) Method

WriteAttributeMapping() public method

public WriteAttributeMapping ( AttributeMappingData theDMap ) : System.Boolean
theDMap AttributeMappingData
return System.Boolean
        public Boolean WriteAttributeMapping(AttributeMappingData theDMap)
        {
            OleDbCommand theCMD;
              String theSQL = "";

              try
              {
            checkOpen();
            theSQL = "INSERT INTO [AttributeMappings] ([SerialNumber], [sourceClass], [destinationClass], [sourceField], [sourceDT], [sourceLength], [sourceEnum], [destinationField], [destinationDT], [destinationLength], [destinationEnum], [valueCount], [constant], [results], [Transform]) VALUES (" + theDMap.serialNumber + ", '" + theDMap.srcFC + "', '" + theDMap.destFC + "', '" + theDMap.srcAtt + "', " + numericDataType(theDMap.srcDT) + ", " + theDMap.srcLen.ToString() + ", '" + theDMap.srcEnum + "', '" + theDMap.destAtt + "', " + numericDataType(theDMap.destDT) + ", " + theDMap.destLen.ToString() + ", '" + theDMap.destEnum + "', " + theDMap.valueCount + ", '" + theDMap.constant + "', '" + theDMap.results + "', " + theDMap.transform + ")";
            theCMD = new OleDbCommand(theSQL, theConn);
            theCMD.ExecuteNonQuery();
            return true;
              }
              catch (Exception ex)
              {
            return false;
              }
        }