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