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);
}
}