static public ArrayList Read(IDataReader reader)
{
ArrayList aOrderQuantitiesList = new ArrayList();
while (reader.Read())
{
OrderQuantities aOrderQuantities = new OrderQuantities();
aOrderQuantities.ClientIdentity = reader.GetString(0);
aOrderQuantities.OrderNumber = reader.GetString(1);
aOrderQuantities.OrderSequence = reader.GetInt32(2);
aOrderQuantities.SubSequence = reader.GetInt32(3);
aOrderQuantities.TotalNoOfLines = Convert.ToDouble(reader.GetDecimal(4));
aOrderQuantities.PickedNoOfLines = Convert.ToDouble(reader.GetDecimal(5));
aOrderQuantities.EstimatedWeight = Convert.ToDouble(reader.GetDecimal(6));
aOrderQuantities.EstimatedVolume = Convert.ToDouble(reader.GetDecimal(7));
aOrderQuantities.PlannedNoOfPallets = Convert.ToDouble(reader.GetDecimal(8));
aOrderQuantities.PlannedNoOfLowestUM = Convert.ToDouble(reader.GetDecimal(9));
aOrderQuantities.PlannedVolume = Convert.ToDouble(reader.GetDecimal(10));
aOrderQuantities.PlannedWeight = Convert.ToDouble(reader.GetDecimal(11));
aOrderQuantities.PickedNoOfPallets = Convert.ToDouble(reader.GetDecimal(12));
aOrderQuantities.PickedNoOfLowestUM = Convert.ToDouble(reader.GetDecimal(13));
aOrderQuantities.PickedVolume = Convert.ToDouble(reader.GetDecimal(14));
aOrderQuantities.PickedWeight = Convert.ToDouble(reader.GetDecimal(15));
aOrderQuantitiesList.Add(aOrderQuantities);
}
reader.Close();
return(aOrderQuantitiesList);
}
static public ArrayList MakeTestData()
{
ArrayList aOrderQuantitiesList = new ArrayList();
for (int i = 0; i < 10; i++)
{
OrderQuantities aOrderQuantities = new OrderQuantities();
aOrderQuantities.ClientIdentity = "IMISTD";
aOrderQuantities.OrderNumber = "1234";
aOrderQuantities.OrderSequence = i;
aOrderQuantities.SubSequence = i;
aOrderQuantities.TotalNoOfLines = 4;
aOrderQuantities.PickedNoOfLines = 5;
aOrderQuantities.EstimatedWeight = 6;
aOrderQuantities.EstimatedVolume = 7;
aOrderQuantities.PlannedNoOfPallets = 8;
aOrderQuantities.PlannedNoOfLowestUM = 9;
aOrderQuantities.PlannedVolume = 10;
aOrderQuantities.PlannedWeight = 11;
aOrderQuantities.PickedNoOfPallets = 12;
aOrderQuantities.PickedNoOfLowestUM = 13;
aOrderQuantities.PickedVolume = 14;
aOrderQuantities.PickedWeight = 15;
aOrderQuantitiesList.Add(aOrderQuantities);
}
return(aOrderQuantitiesList);
}
public CustomerOrderInfoDoc GetCustomerOrderInfo(
string PartnerName,
string LanguageId,
string ClientIdentity,
string OrderNumber,
Nullable <int> OrderSequence)
{
if ((PartnerName == "") || (PartnerName == null))
{
// test mode!
CustomerOrderInfoDoc testres = new CustomerOrderInfoDoc();
ArrayList aCustomerOrderList = CustomerOrder.MakeTestData();
ArrayList aCustomerWorkOrderList = CustomerWorkOrder.MakeTestData();
ArrayList aDepartureList = Departure.MakeTestData();
ArrayList aOrderQuantitiesList = OrderQuantities.MakeTestData();
ArrayList aCustomerOrderRowList = CustomerOrderRow.MakeTestData();
testres.aCustomerOrderList = aCustomerOrderList.ToArray(typeof(CustomerOrder)) as CustomerOrder[];
testres.aCustomerWorkOrderList = aCustomerWorkOrderList.ToArray(typeof(CustomerWorkOrder)) as CustomerWorkOrder[];
testres.aDepartureList = aDepartureList.ToArray(typeof(Departure)) as Departure[];
testres.aOrderQuantitiesList = aOrderQuantitiesList.ToArray(typeof(OrderQuantities)) as OrderQuantities[];
testres.aCustomerOrderRowList = aCustomerOrderRowList.ToArray(typeof(CustomerOrderRow)) as CustomerOrderRow[];
return(testres);
}
CustomerOrderInfoDoc res = new CustomerOrderInfoDoc();
using (DBHelper dbHelper = new DBHelper(PartnerName))
{
try
{
WebServicesQuery pkg = new WebServicesQuery(dbHelper.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[];
dbHelper.GetDataBase().Commit();
}
catch (Exception e)
{
try
{
dbHelper.GetDataBase().Rollback();
}
catch (Exception)
{ }
Exception InternalError = new Exception("DataError: Error processing data", e);
throw (InternalError);
}
}
return(res);
}
