public IList <FindUserLogonDetailsResult> FindUserLogonDetails(FindUserLogonDetailsParameters parameters) { using (TransactionScope scope = new TransactionScope()) { IList <FindUserLogonDetailsResult> result = null; using (IDbConnection connection = new DbConnection(ConnectionString)) { connection.Open(); using (IDbCommand command = connection.CreateCommand()) { command.CommandText = StatementCache.Instance.GetCachedStatement("Imi.SupplyChain.Warehouse.Authentication.DataAccess.Queries.FindUserLogonDetails.sql"); ((OracleCommand)command).BindByName = true; foreach (IDbDataParameter parameter in FindUserLogonDetailsTranslator.TranslateParameters(parameters)) { command.Parameters.Add(parameter); } command.Prepare(); using (IDataReader reader = command.ExecuteReader()) { result = FindUserLogonDetailsTranslator.TranslateResultSet(reader); } } } scope.Complete(); return(result); } }
public IList <FindUserLogonDetailsResult> Execute(FindUserLogonDetailsParameters parameters) { ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings[schemaName]; string connectionString = settings.ConnectionString; IAuthenticationDao dao = new AuthenticationDao(connectionString); return(dao.FindUserLogonDetails(parameters)); }
public static IList <IDbDataParameter> TranslateParameters(FindUserLogonDetailsParameters parameters) { IList <IDbDataParameter> parameterList = new List <IDbDataParameter>(); IDbDataParameter dbParameter; dbParameter = new OracleParameter(); dbParameter.ParameterName = "MAPPED_EMPID"; dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string)); dbParameter.Direction = ParameterDirection.Input; dbParameter.Value = parameters.UserPrincipalIdentity; parameterList.Add(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); }