Exemplo n.º 1
0
        public IList <CheckInterfaceTracingResult> CheckInterfaceTracing(CheckInterfaceTracingParameters parameters)
        {
            using (TransactionScope scope = new TransactionScope())
            {
                IList <CheckInterfaceTracingResult> result = null;

                using (IDbConnection connection = new DbConnection(ConnectionString))
                {
                    connection.Open();

                    using (IDbCommand command = connection.CreateCommand())
                    {
                        command.CommandText = StatementCache.Instance.GetCachedStatement("Imi.SupplyChain.Transportation.Tracing.DataAccess.Queries.CheckLogg.sql");
                        ((OracleCommand)command).BindByName = true;

                        foreach (IDbDataParameter parameter in CheckInterfaceTracingTranslator.TranslateParameters(parameters))
                        {
                            command.Parameters.Add(parameter);
                        }

                        LogDbCommand(command);

                        command.Prepare();

                        using (IDataReader reader = command.ExecuteReader())
                        {
                            result = CheckInterfaceTracingTranslator.TranslateResultSet(reader);
                        }
                    }
                }

                scope.Complete();

                return(result);
            }
        }
Exemplo n.º 2
0
 public static IList <IDbDataParameter> TranslateParameters(CheckInterfaceTracingParameters parameters)
 {
     return(new List <IDbDataParameter>());
 }