public static TransactionDetail GetDetail(string transactionid)
{
IQuery query = QueryBuilder.GetQuery(Symbols.GET, Symbols.TRANSACTION_DETAIL).Refine(Symbols.TRANSACTION_ID, transactionid);
TransactionDetail detail = new TransactionDetail();
using (OracleConnection connection = new OracleConnection(OracleDataUtil.CONN_STRING)) {
connection.Open();
string dbQuery = query.ToString();
using (OracleCommand command = new OracleCommand(dbQuery, connection)) {
OracleDataReader reader = command.ExecuteReader();
try {
reader.Read();
if (reader.HasRows)
{
detail.TransactionId = OracleDataUtil.ReadString(reader, "TRANS_ID");
detail.ProcessName = OracleDataUtil.ReadString(reader, "PROCESS_NAME");
detail.TransactionType = OracleDataUtil.ReadString(reader, "TRANSACTION_TYPE_NAME");
detail.TransactionTime = OracleDataUtil.ReadDateTime(reader, "TRANS_TIME");
detail.Completed = OracleDataUtil.ReadString(reader, "TRANS_COMPLETED");
detail.ElapsedTime = OracleDataUtil.ReadNullableInt(reader, "TOTAL_ELAPSED_TIME");
detail.URL = OracleDataUtil.ReadString(reader, "URL");
detail.Source = OracleDataUtil.ReadString(reader, "SOURCE");
detail.Destination = OracleDataUtil.ReadString(reader, "DESTINATION");
detail.Ping = OracleDataUtil.ReadString(reader, "PING_FLAG");
detail.ServiceLayer = OracleDataUtil.ReadString(reader, "SERVICE_LAYER");
detail.Successful = OracleDataUtil.ReadString(reader, "IS_SUCCESSFUL");
detail.SessionID = OracleDataUtil.ReadString(reader, "SESSION_ID");
detail.SourceType = OracleDataUtil.ReadString(reader, "SOURCE_CONNECTOR");
detail.DestinationType = OracleDataUtil.ReadString(reader, "DESTINATION_CONNECTOR");
}
} finally {
reader.Close();
}
}
query = QueryBuilder.GetQuery(Symbols.GET, Symbols.XREF_DATA).Refine(Symbols.TRANSACTION_ID, transactionid);
dbQuery = query.ToString();
Dictionary <string, string> xrefData = new Dictionary <string, string>();
using (OracleCommand command = new OracleCommand(dbQuery, connection)) {
OracleDataReader reader = command.ExecuteReader();
while (reader.Read())
{
string key = OracleDataUtil.ReadString(reader, "XREF_FIELD");
string value = OracleDataUtil.ReadString(reader, "XREF_VALUE");
xrefData.Add(key, value);
}
OracleDataUtil.ParseXrefData(xrefData, detail);
}
}
return(detail);
}
/// <summary>
/// Returns a list of strings containing the names of all the processes in the database.
/// </summary>
/// <returns>List of strings containing the names of all the processes in the database</returns>
public static IEnumerable <string> GetProcessNameList()
{
IQuery query = QueryBuilder.GetQuery(Symbols.FINDALL, Symbols.PROCESS_LIST);
return(OracleDataUtil.GetListOfString(query));
}
/// <summary>
/// Returns a list of strings containing the names of all the transaction types in the database.
/// </summary>
/// <returns>
/// List of strings containing the names of all the transaction types in the database
/// </returns>
public static IEnumerable <string> GetTransactionTypeList()
{
IQuery query = QueryBuilder.GetQuery(Symbols.FINDALL, Symbols.TRANSACTION_TYPE_LIST);
return(OracleDataUtil.GetListOfString(query));
}
/// <summary>
/// Returns a list of strings containing the names of all the clients in the database.
/// </summary>
/// <returns>List of strings containing the names of all the clients in the database</returns>
public static IEnumerable <string> GetClientList()
{
IQuery query = QueryBuilder.GetQuery(Symbols.FINDALL, Symbols.CLIENT_LIST);
return(OracleDataUtil.GetListOfString(query));
}
