static public ArrayList Read(IDataReader reader)
        {
            ArrayList aCustomerWorkOrderList = new ArrayList();

            while (reader.Read())
            {
                CustomerWorkOrder aCustomerWorkOrder = new CustomerWorkOrder();
                aCustomerWorkOrder.ClientIdentity  = reader.GetString(0);
                aCustomerWorkOrder.OrderNumber     = reader.GetString(1);
                aCustomerWorkOrder.OrderSequence   = reader.GetInt32(2);
                aCustomerWorkOrder.SubSequence     = reader.GetInt32(3);
                aCustomerWorkOrder.OrderStatusCode = reader.GetString(4);
                aCustomerWorkOrder.OrderStatusText = reader.GetString(5);

                aCustomerWorkOrderList.Add(aCustomerWorkOrder);
            }

            reader.Close();

            return(aCustomerWorkOrderList);
        }
Exemple #2
0
        public CustomerOrderInfoDoc GetCustomerOrderInfo(
            string ChannelId,
            string LanguageId,
            string ClientIdentity,
            string OrderNumber,
            Nullable <int> OrderSequence)
        {
            CustomerOrderInfoDoc res = new CustomerOrderInfoDoc();

            try
            {
                BeginWebmethod(ChannelId);

                try
                {
                    WebServicesQuery pkg = new WebServicesQuery(GetDataBase());

                    IDataReader aCustomerOrderRdr     = null;
                    IDataReader aCustomerWorkOrderRdr = null;
                    IDataReader aDepartureRdr         = null;
                    IDataReader aOrderQuantitiesRdr   = null;
                    IDataReader aCustomerOrderRowRdr  = null;

                    pkg.GetCustomerOrderInfo(ClientIdentity,
                                             OrderNumber,
                                             OrderSequence,
                                             LanguageId,
                                             out aCustomerOrderRdr,
                                             out aCustomerWorkOrderRdr,
                                             out aDepartureRdr,
                                             out aOrderQuantitiesRdr,
                                             out aCustomerOrderRowRdr);

                    ArrayList aCustomerOrderList     = CustomerOrder.Read(aCustomerOrderRdr);
                    ArrayList aCustomerWorkOrderList = CustomerWorkOrder.Read(aCustomerWorkOrderRdr);
                    ArrayList aDepartureList         = Departure.Read(aDepartureRdr);
                    ArrayList aOrderQuantitiesList   = OrderQuantities.Read(aOrderQuantitiesRdr);
                    ArrayList aCustomerOrderRowList  = CustomerOrderRow.Read(aCustomerOrderRowRdr);

                    res.aCustomerOrderList     = aCustomerOrderList.ToArray(typeof(CustomerOrder)) as CustomerOrder[];
                    res.aCustomerWorkOrderList = aCustomerWorkOrderList.ToArray(typeof(CustomerWorkOrder)) as CustomerWorkOrder[];
                    res.aDepartureList         = aDepartureList.ToArray(typeof(Departure)) as Departure[];
                    res.aOrderQuantitiesList   = aOrderQuantitiesList.ToArray(typeof(OrderQuantities)) as OrderQuantities[];
                    res.aCustomerOrderRowList  = aCustomerOrderRowList.ToArray(typeof(CustomerOrderRow)) as CustomerOrderRow[];

                    GetDataBase().Commit();
                }
                catch (Exception e)
                {
                    try
                    {
                        GetDataBase().Rollback();
                    }
                    catch (Exception)
                    { }
                    Exception InternalError = new Exception("DataError: Error processing data", e);
                    throw (InternalError);
                }
            }

            finally
            {
                EndWebmethod();
            }

            return(res);
        }