/*
*/
IDataReadble IDataReadble.Read(IDataReader reader)
{
Route x = new Route();
int i = 0;
string DepartureIdentity = ReaderHelper.GetString(reader, i++);
x.VehicleIdentity = ReaderHelper.GetString(reader, i++);
Nullable <DateTime> dtm = ReaderHelper.GetDateTime(reader, i++);
if (dtm != null)
{
x.EstimatedTimeOfDeparture = (DateTime)dtm;
}
else
{
x.EstimatedTimeOfDeparture = DateTime.MinValue;
}
x.RouteIdentity = ReaderHelper.GetString(reader, i++);
x.Name = ReaderHelper.GetString(reader, i++);
x.TotalUnloadingTimeInSeconds = ReaderHelper.GetInt32(reader, i++);
x.TotalDrivingTimeInSeconds = ReaderHelper.GetInt32(reader, i++);
x.TotalTimeInSeconds = ReaderHelper.GetInt32(reader, i++);
x.TotalDistance = (double?)ReaderHelper.GetDecimal(reader, i++);
return(x);
}
IDataReadble IDataReadble.Read(IDataReader reader)
{
vendorPartNos x = new vendorPartNos();
int i = 0;
x.vendorPartNo = ReaderHelper.GetString(reader, i++);
return(x);
}
/*
* type WarehouseRow_Type is record
* ( stockNo WH.WHID%type
* ,name WH.WHNAME%type );
*/
IDataReadble IDataReadble.Read(IDataReader reader)
{
warehouse x = new warehouse();
int i = 0;
x.stockNo = ReaderHelper.GetString(reader, i++);
x.name = ReaderHelper.GetString(reader, i++);
return(x);
}
/*
* type BarcodeRow_Type is record
* ( type EAN.BARCODETYPE%type
* ,value EAN.EANDUN%type );
*/
IDataReadble IDataReadble.Read(IDataReader reader)
{
barcode x = new barcode();
int i = 0;
x.type = ReaderHelper.GetString(reader, i++);
x.value = ReaderHelper.GetString(reader, i++);
return(x);
}
IDataReadble IDataReadble.Read(IDataReader reader)
{
methodOfShipment x = new methodOfShipment();
int i = 0;
x.methodOfShipmentId = ReaderHelper.GetString(reader, i++);
x.methodOfShipmentName = ReaderHelper.GetString(reader, i++);
return(x);
}
IDataReadble IDataReadble.Read(IDataReader reader)
{
customerOrderType x = new customerOrderType();
int i = 0;
x.customerOrderTypeId = ReaderHelper.GetString(reader, i++);
x.customerOrderTypeName = ReaderHelper.GetString(reader, i++);
return(x);
}
IDataReadble IDataReadble.Read(IDataReader reader)
{
customer x = new customer();
int i = 0;
x.id = ReaderHelper.GetString(reader, i++);
x.name = ReaderHelper.GetString(reader, i++);
x.city = ReaderHelper.GetString(reader, i++);
x.organizationNumber = ReaderHelper.GetString(reader, i++);
x.phone = ReaderHelper.GetString(reader, i++);
x.fax = ReaderHelper.GetString(reader, i++);
x.customerRef = ReaderHelper.GetString(reader, i++);
return(x);
}
IDataReadble IDataReadble.Read(IDataReader reader)
{
product x = new product();
int i = 0;
x.partNo = ReaderHelper.GetString(reader, i++);
x.partDescr1 = ReaderHelper.GetString(reader, i++);
x.partDescr2 = ReaderHelper.GetString(reader, i++);
x.unit = ReaderHelper.GetString(reader, i++);
x.unitDescr = ReaderHelper.GetString(reader, i++);
x.numbDec = ReaderHelper.GetInt32NotNull(reader, i++);
x.vendPartNo = ReaderHelper.GetString(reader, i++);
return(x);
}
/*
* type WarehouseRow_Type is record
* ( stockNo WH.WHID%type
* ,name WH.WHNAME%type );
*/
IDataReadble IDataReadble.Read(IDataReader reader)
{
RouteStop x = new RouteStop();
int i = 0;
x.StopSequence = ReaderHelper.GetInt32(reader, i++);
x.DistanceFromPreviousStop = ReaderHelper.GetInt32(reader, i++);
Nullable <DateTime> dtm = ReaderHelper.GetDateTime(reader, i++);
if (dtm != null)
{
x.EstimatedArrivalTime = (DateTime)dtm;
}
else
{
x.EstimatedArrivalTime = DateTime.MinValue;
}
x.Instructions = ReaderHelper.GetString(reader, i++);
x.TotalUnloadingTimeInSeconds = ReaderHelper.GetInt32(reader, i++);
x.TotalDrivingTimeInSeconds = ReaderHelper.GetInt32(reader, i++);
x.TotalTimeInSeconds = ReaderHelper.GetInt32(reader, i++);
x.Country = ReaderHelper.GetString(reader, i++);
x.NodeIdentity = ReaderHelper.GetString(reader, i++);
x.CustomerIdentity = ReaderHelper.GetString(reader, i++);
x.Name1 = ReaderHelper.GetString(reader, i++);
x.Name2 = ReaderHelper.GetString(reader, i++);
x.Name3 = ReaderHelper.GetString(reader, i++);
x.Name4 = ReaderHelper.GetString(reader, i++);
x.Name5 = ReaderHelper.GetString(reader, i++);
x.Address1 = ReaderHelper.GetString(reader, i++);
x.Address2 = ReaderHelper.GetString(reader, i++);
x.Address3 = ReaderHelper.GetString(reader, i++);
x.Address4 = ReaderHelper.GetString(reader, i++);
x.City = ReaderHelper.GetString(reader, i++);
x.ZipCode = ReaderHelper.GetString(reader, i++);
x.CountryCode = ReaderHelper.GetString(reader, i++);
x.Region = ReaderHelper.GetString(reader, i++);
x.Latitude = ReaderHelper.GetString(reader, i++);
x.Longitude = ReaderHelper.GetString(reader, i++);
x.ContactPerson = ReaderHelper.GetString(reader, i++);
x.ContactPhone = ReaderHelper.GetString(reader, i++);
x.ContactEmail = ReaderHelper.GetString(reader, i++);
return(x);
}
IDataReadble IDataReadble.Read(IDataReader reader)
{
address x = new address();
int i = 0;
x.name1 = ReaderHelper.GetString(reader, i++);
x.name2 = ReaderHelper.GetString(reader, i++);
x.street1 = ReaderHelper.GetString(reader, i++);
x.street2 = ReaderHelper.GetString(reader, i++);
x.street3 = ReaderHelper.GetString(reader, i++);
x.zipCode = ReaderHelper.GetString(reader, i++);
x.city = ReaderHelper.GetString(reader, i++);
x.stateCd = ReaderHelper.GetString(reader, i++);
x.countryCd = ReaderHelper.GetString(reader, i++);
return(x);
}
IDataReadble IDataReadble.Read(IDataReader reader)
{
order x = new order();
int i = 0;
string ot = ReaderHelper.GetString(reader, i++); // orderType
if (ot == "CO3PL")
{
x.orderType = orderType.CO3PL;
}
else if (ot == "PO")
{
x.orderType = orderType.PO;
}
else
{
throw new Exception("Order type <" + ot + "> not supported");
}
x.orderTypeSpecified = true;
x.coNo = ReaderHelper.GetString(reader, i++);
x.customer = ReaderHelper.GetString(reader, i++);
x.cuRef = ReaderHelper.GetString(reader, i++);
x.yourCono = ReaderHelper.GetString(reader, i++);
x.reqDelDate = ReaderHelper.GetDateTime(reader, i++);
x.text = ReaderHelper.GetString(reader, i++);
x.coMark = ReaderHelper.GetString(reader, i++);
x.poid = ReaderHelper.GetString(reader, i++);
x.poSeq = ReaderHelper.GetInt32(reader, i++);
x.receivingWhid = ReaderHelper.GetString(reader, i++);
x.shipFromPartyid = ReaderHelper.GetString(reader, i++);
x.shipFromPartyQualifier = ReaderHelper.GetString(reader, i++);
x.whName = ReaderHelper.GetString(reader, i++);
x.methodOfShipmentId = ReaderHelper.GetString(reader, i++);
x.methodOfShipmentName = ReaderHelper.GetString(reader, i++);
x.customerOrderTypeId = ReaderHelper.GetString(reader, i++);
x.customerOrderTypeName = ReaderHelper.GetString(reader, i++);
return(x);
}
private int GetLineStatus(IDataReader reader, orderLine x, int i)
{
string lineStatus = ReaderHelper.GetString(reader, i++);
try
{
if (lineStatus != null)
{
x.lineStatus = Convert.ToInt32(lineStatus);
}
else
{
x.lineStatus = null;
}
}
catch
{
x.lineStatus = null;
}
return(i);
}
IDataReadble IDataReadble.Read(IDataReader reader)
{
orderLine x = new orderLine();
int i = 0;
x.partNo = ReaderHelper.GetString(reader, i++);
x.partDescr1 = ReaderHelper.GetString(reader, i++);
x.partDescr2 = ReaderHelper.GetString(reader, i++);
x.custPartNo = ReaderHelper.GetString(reader, i++);
x.custPartDescr1 = ReaderHelper.GetString(reader, i++);
x.custPartDescr2 = ReaderHelper.GetString(reader, i++);
x.text = ReaderHelper.GetString(reader, i++);
x.qtyUnit = ReaderHelper.GetDecimal(reader, i++);
x.originalQtyUnit = ReaderHelper.GetDecimal(reader, i++);
x.unit = ReaderHelper.GetString(reader, i++);
x.unitDescr = ReaderHelper.GetString(reader, i++);
x.linePos = ReaderHelper.GetInt32(reader, i++);
x.lineSeq = ReaderHelper.GetInt32(reader, i++);
x.lineId = ReaderHelper.GetInt32(reader, i++);
x.sellingUnit = ReaderHelper.GetString(reader, i++);
x.sellingUnitDesc = ReaderHelper.GetString(reader, i++);
x.delDate = ReaderHelper.GetDateTime(reader, i++);
i = GetLineStatus(reader, x, i);
x.rcvQtyUnit = ReaderHelper.GetDecimal(reader, i++);
/*
* x.blockCod = ReaderHelper.GetString(reader, i++);
* x.serial = ReaderHelper.GetString(reader, i++);
* x.serNumb = ReaderHelper.GetString(reader, i++);
* x.prodLot = ReaderHelper.GetString(reader, i++);
* x.promotn = ReaderHelper.GetString(reader, i++);
* x.storBat = ReaderHelper.GetString(reader, i++);
* x.prodLotReq = ReaderHelper.GetString(reader, i++);
*/
return(x);
}