public static IList <FindUserLogonDetailsResult> TranslateResultSet(IDataReader reader) { IList <FindUserLogonDetailsResult> resultList = new List <FindUserLogonDetailsResult>(); object data; while (reader.Read()) { FindUserLogonDetailsResult result = new FindUserLogonDetailsResult(); data = reader["EMPID"]; if (data != DBNull.Value) { result.UserIdentity = DbTypeConvertor.Convert <string>(data); } data = reader["EMPNAME"]; if (data != DBNull.Value) { result.UserName = DbTypeConvertor.Convert <string>(data); } data = reader["RECENT_NODE_ID"]; if (data != DBNull.Value) { result.RecentNodeIdentity = DbTypeConvertor.Convert <string>(data); } data = reader["LASTLOGONDTM"]; if (data != DBNull.Value) { result.LastLogonTime = DbTypeConvertor.Convert <DateTime>(data); } resultList.Add(result); } return(resultList); }
public DateTime?FindConfigUpdateTime(string outputManagerID) { using (TransactionScope scope = new TransactionScope()) { DateTime?result = null; using (IDbConnection connection = new DbConnection(ConnectionString)) { connection.Open(); using (IDbCommand command = connection.CreateCommand()) { command.CommandText = StatementCache.Instance.GetCachedStatement("Imi.SupplyChain.OM.OutputHandler.ConfigDataAccess.Queries.FindUpdateTime.sql"); ((OracleCommand)command).BindByName = true; IDataParameter dbParameter = new OracleParameter(); dbParameter.ParameterName = "OMID"; dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string)); dbParameter.Direction = ParameterDirection.Input; dbParameter.Value = outputManagerID; command.Parameters.Add(dbParameter); //LogDbCommand(command); command.Prepare(); object upddtm = command.ExecuteScalar(); if (upddtm != null && upddtm != DBNull.Value) { result = DbTypeConvertor.Convert <DateTime>(upddtm); } } } scope.Complete(); return(result); } }
public static IDictionary <string, Printer> TranslateResultSet(IDataReader reader) { IDictionary <string, Printer> resultList = new Dictionary <string, Printer>(); object data; while (reader.Read()) { Printer result = new Printer(); data = reader["PRTID"]; if (data != DBNull.Value) { result.PrinterID = DbTypeConvertor.Convert <string>(data); } data = reader["PRT_DEVICE"]; if (data != DBNull.Value) { result.PrinterDevice = DbTypeConvertor.Convert <string>(data); } data = reader["PRT_TYPE"]; if (data != DBNull.Value) { result.PrinterType = DbTypeConvertor.Convert <string>(data); } data = reader["UPDDTM"]; if (data != DBNull.Value) { result.LatestUpdate = DbTypeConvertor.Convert <DateTime>(data); } if (!resultList.ContainsKey(result.PrinterID)) { resultList.Add(result.PrinterID, result); } } return(resultList); }
public static IList <FindAlarmTextResult> TranslateResultSet(IDataReader reader) { IList <FindAlarmTextResult> resultList = new List <FindAlarmTextResult>(); object data; while (reader.Read()) { FindAlarmTextResult result = new FindAlarmTextResult(); data = reader["ALMTXT"]; if (data != DBNull.Value) { result.AlarmText = DbTypeConvertor.Convert <string>(data); } resultList.Add(result); } return(resultList); }
public static IList <PrinterAssociation> TranslateResultSet(IDataReader reader) { IList <PrinterAssociation> resultList = new List <PrinterAssociation>(); object data; while (reader.Read()) { PrinterAssociation result = new PrinterAssociation(); data = reader["PRTID"]; if (data != DBNull.Value) { result.PrinterID = DbTypeConvertor.Convert <string>(data); } data = reader["TERGRPID"]; if (data != DBNull.Value) { result.TerminalGroupID = DbTypeConvertor.Convert <string>(data); } data = reader["RPTGRPID"]; if (data != DBNull.Value) { result.ReportGroupID = DbTypeConvertor.Convert <string>(data); } data = reader["UPDDTM"]; if (data != DBNull.Value) { result.LatestUpdate = DbTypeConvertor.Convert <DateTime>(data); } resultList.Add(result); } return(resultList); }
public static IList <DocumentType> TranslateResultSet(IDataReader reader) { IList <DocumentType> resultList = new List <DocumentType>(); object data; while (reader.Read()) { DocumentType result = new DocumentType(); data = reader["DOCTYPID"]; if (data != DBNull.Value) { result.DocumentTypeID = DbTypeConvertor.Convert <string>(data); } data = reader["DOCSUBTYPID"]; if (data != DBNull.Value) { result.SubDocmentTypeID = DbTypeConvertor.Convert <string>(data); } data = reader["RPTID"]; if (data != DBNull.Value) { result.ReportID = DbTypeConvertor.Convert <string>(data); } data = reader["UPDDTM"]; if (data != DBNull.Value) { result.LatestUpdate = DbTypeConvertor.Convert <DateTime>(data); } resultList.Add(result); } return(resultList); }
public static IDictionary <string, Report> TranslateResultSet(IDataReader reader) { IDictionary <string, Report> resultList = new Dictionary <string, Report>(); object data; while (reader.Read()) { string reportID = string.Empty; data = reader["RPTID"]; if (data != DBNull.Value) { reportID = DbTypeConvertor.Convert <string>(data); } if (!resultList.ContainsKey(reportID)) { Report result = new Report(); result.ReportID = reportID; data = reader["RPTGRPID"]; if (data != DBNull.Value) { result.ReportGroupID = DbTypeConvertor.Convert <string>(data); } data = reader["RPT_FILE"]; if (data != DBNull.Value) { result.ReportFile = DbTypeConvertor.Convert <byte[]>(data); } data = reader["UPDDTM"]; if (data != DBNull.Value) { result.LatestUpdate = DbTypeConvertor.Convert <DateTime>(data); } result.AdapterIDs = new List <string>(); resultList.Add(result.ReportID, result); } data = reader["ADAPTER_ID"]; if (data != DBNull.Value) { resultList[reportID].AdapterIDs.Add(DbTypeConvertor.Convert <string>(data)); } data = reader["ADAPTERUPDDTM"]; if (data != DBNull.Value) { DateTime adpUpd = DbTypeConvertor.Convert <DateTime>(data); if (adpUpd > resultList[reportID].LatestUpdate) { resultList[reportID].LatestUpdate = adpUpd; } } } return(resultList); }
public static IDictionary <string, Adapter> TranslateResultSet(IDataReader reader) { IDictionary <string, Adapter> resultList = new Dictionary <string, Adapter>(); object data; while (reader.Read()) { Adapter result = null; data = reader["ADAPTER_ID"]; if (data != DBNull.Value) { string adapterId = DbTypeConvertor.Convert <string>(data); if (!resultList.ContainsKey(adapterId)) { resultList.Add(adapterId, new Adapter()); result = resultList[adapterId]; result.AdapterID = adapterId; result.AdapterParameters = new Dictionary <string, string>(); data = reader["UPDDTMADT"]; if (data != DBNull.Value) { result.LatestUpdate = DbTypeConvertor.Convert <DateTime>(data); } } data = reader["PARAM_NAME"]; if (data != DBNull.Value) { result = resultList[adapterId]; string parameterName = DbTypeConvertor.Convert <string>(data); string parameterValue = string.Empty; data = reader["PARAM_VALUE"]; if (data != DBNull.Value) { parameterValue = DbTypeConvertor.Convert <string>(data); } result.AdapterParameters.Add(parameterName, parameterValue); data = reader["UPDDTMCONF"]; if (data != DBNull.Value) { DateTime confUpd = DbTypeConvertor.Convert <DateTime>(data); if (confUpd > result.LatestUpdate) { result.LatestUpdate = confUpd; } } } } } return(resultList); }