public void TruncateQueueTable(string DataObject = "") { var sql = "TRUNCATE TABLE DataIntegrationQueue.dbo.AuditPOSync"; var connString = ConfigurationManager.ConnectionStrings["QueueDbContext"].ConnectionString; _sqlClient.NonQueryADO(sql, connString); }
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); } }