public int Insert_Soa_Trans(List <FileInfo> logFiles, ServiceHelper sh)
{
string query = string.Empty;
int total = 0;
List <string> soatransactionId = new List <string>();
foreach (FileInfo file in logFiles)
{
string id = ReadHelper.GetTransactionId_StreamReader(file);
DateTime modifiedDate = file.LastWriteTime;
if (id != null || id != string.Empty)
{
OracleParameter[] parameters = new OracleParameter[]
{
new OracleParameter("SERVICE_NAME", sh.ServiceName),
new OracleParameter("TRANSID", id),
new OracleParameter("TRANSTIME", modifiedDate)
};
query = string.Format("INSERT into SOA_TRANSACTION (ID, SERVICE, TRANSACTION_ID, TRANSACTION_TIME)" +
"(SELECT SQ_SOA_TRANSACTION.NEXTVAL ID, " +
":SERVICE_NAME SERVICE, " +
":TRANSID TRANSACTION_ID, " +
":TRANSTIME TRANSACTION_TIME " +
"FROM DUAL)");
ExecNonQuery(query, parameters);
PrintHelper.Trace(string.Format(Messages.TransactionId_SUCCESS, id));
total++;
}
}
return(total);
}
/// <summary>
/// test locally without saving to database
/// for debugging purposes only: call this method in Main()
/// </summary>
/// <param name="myService">Service Code</param>
private static void TestTransactionId(ServiceCode myService)
{
PrintHelper.Trace(string.Format(Messages.GetServiceName, myService.ToString()));
ServiceHelper sh = new ServiceHelper(myService);
List <FileInfo> logFiles = ReadHelper.Read_SW_Logs(inputDate, sh);
foreach (FileInfo file in logFiles)
{
DateTime createDate = file.CreationTime;
DateTime modifiedDate = file.LastWriteTime;
string id = ReadHelper.GetTransactionId_StreamReader(file);
PrintHelper.Trace(string.Format("the output transaction ID is {0}", id));
}
}