public void TruncateQueueTable(string DataObject = "")
        {
            var sql = "TRUNCATE TABLE DataIntegrationQueue.dbo.AuditPOSync";

            var connString = ConfigurationManager.ConnectionStrings["QueueDbContext"].ConnectionString;

            _sqlClient.NonQueryADO(sql, connString);
        }
Beispiel #2
0
 public void InsertLog(int workflowRID, string sqlOperation, string sqlQuery, string status)
 {
     try
     {
         string sql        = CreateLogTransactionSQL(workflowRID, sqlOperation, sqlQuery, status);
         string connection = ConfigurationManager.ConnectionStrings["SWAPI"].ConnectionString.ToString();
         _sqlClient.NonQueryADO(sql, connection);
     }
     catch (Exception ex)
     {
         throw new Exception("Failure inserting API call into the log. " + ex.InnerException);
     }
 }