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