public IList <FindUserWarehousesResult> FindUserWarehouses(FindUserWarehousesParameters parameters)
{
using (TransactionScope scope = new TransactionScope())
{
IList <FindUserWarehousesResult> 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.FindUserWarehouses.sql");
((OracleCommand)command).BindByName = true;
foreach (IDbDataParameter parameter in FindUserWarehousesTranslator.TranslateParameters(parameters))
{
command.Parameters.Add(parameter);
}
command.Prepare();
using (IDataReader reader = command.ExecuteReader())
{
result = FindUserWarehousesTranslator.TranslateResultSet(reader);
}
}
}
scope.Complete();
return(result);
}
}
public IList <FindUserWarehousesResult> FindAllWarehouses()
{
using (TransactionScope scope = new TransactionScope())
{
IList <FindUserWarehousesResult> 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.FindAllWarehouses.sql");
command.Prepare();
using (IDataReader reader = command.ExecuteReader())
{
result = FindUserWarehousesTranslator.TranslateResultSet(reader);
}
}
}
scope.Complete();
return(result);
}
}