public static IList <IDbDataParameter> TranslateParameters(ModifyUserDetailsParameters parameters)
{
IList <IDbDataParameter> parameterList = new List <IDbDataParameter>();
IDbDataParameter dbParameter;
dbParameter = new OracleParameter();
dbParameter.ParameterName = "EMPID";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.UserIdentity;
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "NODE_ID";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.RecentNodeIdentity;
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "LASTLOGONDTM";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(DateTime));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.LastLogonTime;
parameterList.Add(dbParameter);
return(parameterList);
}
public static void TranslateParameters(IDataParameterCollection parameterList, string outputManagerID, bool mainService, string URL)
{
IDbDataParameter dbParameter;
dbParameter = new OracleParameter();
dbParameter.ParameterName = "OMID_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = outputManagerID;
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "URL_TYPE_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
if (mainService)
{
dbParameter.Value = "MAIN";
}
else
{
dbParameter.Value = "FALLBACK";
}
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "URL_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = URL;
parameterList.Add(dbParameter);
}
public static void TranslateParameters(IDataParameterCollection parameterList, string outputManagerID)
{
IDbDataParameter dbParameter;
dbParameter = new OracleParameter();
dbParameter.ParameterName = "OMID";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = outputManagerID;
parameterList.Add(dbParameter);
}
public static IList <IDbDataParameter> TranslateParameters(FindUserNodesParameters parameters)
{
IList <IDbDataParameter> parameterList = new List <IDbDataParameter>();
IDbDataParameter dbParameter;
dbParameter = new OracleParameter();
dbParameter.ParameterName = "EMPID";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.UserIdentity;
parameterList.Add(dbParameter);
return(parameterList);
}
public static IList <IDbDataParameter> TranslateParameters(LogonParameters parameters)
{
IList <IDbDataParameter> parameterList = new List <IDbDataParameter>();
IDbDataParameter dbParameter;
dbParameter = new OracleParameter();
dbParameter.ParameterName = "EMPID_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.UserIdentity;
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "WHID_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.WarehouseIdentity;
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "COMPANY_ID_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.CompanyIdentity;
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "TERID_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.TerminalIdentity;
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "PRODUCT_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.ApplicationIdentity;
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "ALMID_O";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Output;
dbParameter.Size = 35;
parameterList.Add(dbParameter);
return(parameterList);
}
public static IList <IDbDataParameter> TranslateParameters(GetInformationXMLParameters parameters)
{
IList <IDbDataParameter> parameterList = new List <IDbDataParameter>();
OracleParameter dbParameter;
dbParameter = new OracleParameter();
dbParameter.ParameterName = "NLANGCOD_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.LanguageCode;
parameterList.Add(dbParameter);
dbParameter = new OracleParameter("XML_O", OracleDbType.Clob);
dbParameter.Direction = ParameterDirection.ReturnValue;
parameterList.Add(dbParameter);
return(parameterList);
}
public static IList <IDbDataParameter> TranslateParameters(StartDatabaseTracingParameters parameters)
{
IList <IDbDataParameter> parameterList = new List <IDbDataParameter>();
IDbDataParameter dbParameter;
dbParameter = new OracleParameter();
dbParameter.ParameterName = "EMPID_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.UserId;
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "TERID_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.TerminalId;
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "THREAD_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = "0";
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "WriteHeader_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
if (parameters.WriteHeader)
{
dbParameter.Value = "1";
}
else
{
dbParameter.Value = "0";
}
parameterList.Add(dbParameter);
return(parameterList);
}
public static void TranslateParameters(IDataParameterCollection parameterList, string outputManagerID, string errorMessage)
{
IDbDataParameter dbParameter;
dbParameter = new OracleParameter();
dbParameter.ParameterName = "OMID_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = outputManagerID;
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "ERROR_MSG_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
((OracleParameter)dbParameter).OracleDbType = OracleDbType.Clob;
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = errorMessage;
parameterList.Add(dbParameter);
}
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 IList <IDbDataParameter> TranslateParameters(FindRowIdentityParameters parameters)
{
IList <IDbDataParameter> parameterList = new List <IDbDataParameter>();
IDbDataParameter dbParameter;
dbParameter = new OracleParameter();
dbParameter.ParameterName = "ID_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.Id;
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "ROWIDENTITY_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Output;
dbParameter.Size = 255;
parameterList.Add(dbParameter);
return(parameterList);
}
public static IList <IDbDataParameter> TranslateParameters(FindAlarmTextParams parameters)
{
IList <IDbDataParameter> parameterList = new List <IDbDataParameter>();
IDbDataParameter dbParameter;
dbParameter = new OracleParameter();
dbParameter.ParameterName = "ALMID";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.AlarmId;
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "NLANGCOD";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.LanguageCode;
parameterList.Add(dbParameter);
return(parameterList);
}
public static IList <IDbDataParameter> TranslateParameters(ModifyInterfaceTracingParameters parameters)
{
IList <IDbDataParameter> parameterList = new List <IDbDataParameter>();
IDbDataParameter dbParameter;
dbParameter = new OracleParameter();
dbParameter.ParameterName = "LOGG_ON_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.LoggOn ? "1" : "0";
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "LOGG_INTVL_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(int));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.LoggInterval;
parameterList.Add(dbParameter);
return(parameterList);
}
