public orderSearchResult getOpenOrders(ISyncWSParameter dataParam,
System.Nullable <orderType> ot,
string clientId,
string orderNo,
string yourCono,
System.Nullable <System.DateTime> from,
System.Nullable <System.DateTime> to,
string mark,
string ordersFromHistory,
string ordersFromProduction)
{
IDataReader reader = null;
int totalRows;
orderSearchResult res = new orderSearchResult();
switch (ot)
{
case orderType.CO:
throw new Exception("ordertype CO not supported");
case orderType.CO3PL:
Getco(
clientId,
orderNo,
yourCono,
from,
to,
mark,
ordersFromHistory,
ordersFromProduction,
out reader);
break;
case orderType.PO:
Getpo(
clientId,
orderNo,
from,
to,
ordersFromHistory,
ordersFromProduction,
out reader);
break;
default:
throw new Exception("unknown ordertype");
}
ArrayList list = ReaderHelper.Read(
reader,
new order(),
dataParam.GetSkipNoFirstRows(),
dataParam.GetMaxRows(),
out totalRows);
res.list = list.ToArray(typeof(order)) as order[];
res.SetTotalRows(totalRows);
return(res);
}
public ISyncWSResult find(ISyncWSParameter dataParameter)
{
warehouseSearchResult res = new warehouseSearchResult();
ArrayList list = ReaderHelper.MakeTestData(10, new warehouse());
res.list = list.ToArray(typeof(warehouse)) as warehouse[];
res.totalHits = res.list.GetLength(0);
return((searchResult)res);
}
public ISyncWSResult findProducts(ISyncWSParameter dataParameter)
{
productSearchResult res = new productSearchResult();
ArrayList list = ReaderHelper.MakeTestData(10, new product());
res.list = list.ToArray(typeof(product)) as product[];
res.totalHits = res.list.GetLength(0);
return((searchResult)res);
}
public ISyncWSResult getAddresses(Database database, ISyncWSParameter dataParameter)
{
customerSearchParameters customerSearchParameters = (customerSearchParameters)dataParameter;
WebServices3pl pkg = new WebServices3pl(database);
addressSearchResult res = pkg.getAddresses(dataParameter, customerSearchParameters.clientId, customerSearchParameters.customerId);
return((searchResult)res);
}
public ISyncWSResult getCustomerOrderTypes(Database database, ISyncWSParameter dataParameter)
{
customerOrderSearchParameters customerOrderSearchParameters = (customerOrderSearchParameters)dataParameter;
WebServices3pl pkg = new WebServices3pl(database);
customerOrderTypeSearchResult res = pkg.Findcustomerordertype(dataParameter);
return(res);
}
public ISyncWSResult findByClient(Database database, ISyncWSParameter dataParameter)
{
warehouseSearchParameters warehouseSearchParameters = (warehouseSearchParameters)dataParameter;
WebServices3pl pkg = new WebServices3pl(database);
warehouseSearchResult res = pkg.Findwarehousebyclient(dataParameter, warehouseSearchParameters.clientId);
return((searchResult)res);
}
public ISyncWSResult getMethodOfShipments(Database database, ISyncWSParameter dataParameter)
{
methodOfShipmentSearchParameters methodOfShipmentSearchParameters = (methodOfShipmentSearchParameters)dataParameter;
WebServices3pl pkg = new WebServices3pl(database);
methodOfShipmentSearchResult res = (methodOfShipmentSearchResult)pkg.Findmethodofshipmentbyclient(dataParameter,
methodOfShipmentSearchParameters.clientId);
return(res);
}
public ISyncWSResult SignalProcess(Database database, ISyncWSParameter dataParameter)
{
orderSaveParameters orderSaveParameters = (orderSaveParameters)dataParameter;
orderSaveResult res = new orderSaveResult();
WebServices3pl pkg = new WebServices3pl(database);
pkg.SignalProcess("CO");
res.totalHits = 0;
return(res);
}
public ISyncWSResult findProductsByDescription(Database database, ISyncWSParameter dataParameter)
{
productSearchParameters productSearchParameters = (productSearchParameters)dataParameter;
WebServices3pl pkg = new WebServices3pl(database);
productSearchResult res = pkg.Findproductbydescription(dataParameter, productSearchParameters.clientId, productSearchParameters.searchString);
Details(res.list, pkg, dataParameter, productSearchParameters);
return((searchResult)res);
}
private void Details(product[] list, WebServices3pl pkg, ISyncWSParameter dataParameter, productSearchParameters productSearchParameters)
{
if (dataParameter.GetReturnDetails())
{
foreach (product item in list)
{
productSearchParameters subParams = new productSearchParameters();
subParams.firstResult = null;
subParams.maxResult = null;
item.barcodes = pkg.Findbarcodebyproduct(subParams, productSearchParameters.clientId, item.partNo);
vendorPartNos[] vendorPartNo = pkg.Getvendorpartno(subParams, productSearchParameters.clientId, item.partNo);
// build vendor part no string
item.vendPartNo = "";
foreach (vendorPartNos vpn in vendorPartNo)
{
if (!String.IsNullOrEmpty(vpn.vendorPartNo))
{
if (item.vendPartNo != "")
{
item.vendPartNo += ", ";
}
item.vendPartNo += vpn.vendorPartNo;
}
}
if (String.IsNullOrEmpty(item.vendPartNo))
{
item.vendPartNo = null;
}
// build product availability
if (!String.IsNullOrEmpty(productSearchParameters.stockNo))
{
productAvails[] productAvail = pkg.Getproductavail(subParams, productSearchParameters.clientId, productSearchParameters.stockNo, item.partNo);
int qty = 0;
foreach (productAvails pa in productAvail)
{
if (pa.productAvail != null)
{
qty += (int)pa.productAvail;
}
}
item.availability = qty;
}
}
}
}
public orderLine[] GetOrderLines(ISyncWSParameter dataParam,
System.Nullable <orderType> ot,
string clientId,
string coNo,
string poid,
Nullable <int> poSeq,
string ordersFromHistory,
string ordersFromProduction)
{
IDataReader reader = null;
int totalRows;
switch (ot)
{
case orderType.CO:
throw new Exception("ordertype CO not supported");
case orderType.CO3PL:
Getcoline(
clientId,
coNo,
ordersFromHistory,
ordersFromProduction,
out reader);
break;
case orderType.PO:
Getpoline(
clientId,
poid,
poSeq,
ordersFromHistory,
ordersFromProduction,
out reader);
break;
default:
throw new Exception("unknown ordertype");
}
ArrayList list = ReaderHelper.Read(
reader,
new orderLine(),
dataParam.GetSkipNoFirstRows(),
dataParam.GetMaxRows(),
out totalRows);
return(list.ToArray(typeof(orderLine)) as orderLine[]);
}
public ISyncWSResult getOrderDetails(Database database, ISyncWSParameter dataParameter)
{
orderSearchParameters orderSearchParameters = (orderSearchParameters)dataParameter;
WebServices3pl pkg = new WebServices3pl(database);
orderSearchResult res = pkg.getOrderDetails(dataParameter,
orderSearchParameters.orderType,
orderSearchParameters.clientId,
orderSearchParameters.orderNo,
boolToYesNo(orderSearchParameters.ordersFromHistory),
boolToYesNo(orderSearchParameters.ordersFromProduction));
Details(dataParameter, orderSearchParameters, res, pkg);
return((searchResult)res);
}
public RouteStop[] Finddepartureroutestops(ISyncWSParameter dataParam, string DepartureIdentity)
{
IDataReader reader = null;
int totalRows;
Finddepartureroutestops(
DepartureIdentity,
out reader);
ArrayList list = ReaderHelper.Read(
reader,
new RouteStop(),
dataParam.GetSkipNoFirstRows(),
dataParam.GetMaxRows(),
out totalRows);
return(list.ToArray(typeof(RouteStop)) as RouteStop[]);
}
public address[] getAddresses(ISyncWSParameter dataParam, string clientId, string customerId)
{
IDataReader reader = null;
int totalRows;
Getaddresses(
clientId,
customerId,
out reader);
ArrayList list = ReaderHelper.Read(
reader,
new address(),
dataParam.GetSkipNoFirstRows(),
dataParam.GetMaxRows(),
out totalRows);
return(list.ToArray(typeof(address)) as address[]);
}
public vendorPartNos[] Getvendorpartno(ISyncWSParameter dataParam, string clientId, string partNo)
{
IDataReader reader = null;
int totalRows;
Getvendorpartno(
clientId,
partNo,
out reader);
ArrayList list = ReaderHelper.Read(
reader,
new vendorPartNos(),
dataParam.GetSkipNoFirstRows(),
dataParam.GetMaxRows(),
out totalRows);
return(list.ToArray(typeof(vendorPartNos)) as vendorPartNos[]);
}
public barcode[] Findbarcodebyproduct(ISyncWSParameter dataParam, string clientId, string partNo)
{
IDataReader reader = null;
int totalRows;
Findbarcodebyproduct(
clientId,
partNo,
out reader);
ArrayList list = ReaderHelper.Read(
reader,
new barcode(),
dataParam.GetSkipNoFirstRows(),
dataParam.GetMaxRows(),
out totalRows);
return(list.ToArray(typeof(barcode)) as barcode[]);
}
public orderSearchResult getOrderDetails(ISyncWSParameter dataParam,
System.Nullable <orderType> ot,
string clientId,
string orderNo,
string ordersFromHistory,
string ordersFromProduction)
{
return(getOpenOrders(
dataParam,
ot,
clientId,
orderNo,
null,
null,
null,
null,
ordersFromHistory,
ordersFromProduction));
}
public addressSearchResult getPartyAddress(ISyncWSParameter dataParam, string clientId, string partyId, partyType pt)
{
IDataReader reader = null;
int totalRows;
addressSearchResult res = new addressSearchResult();
Getpartyaddress(partyId, ConvertPartyType(pt), clientId, out reader);
ArrayList list = ReaderHelper.Read(
reader,
new address(),
dataParam.GetSkipNoFirstRows(),
dataParam.GetMaxRows(),
out totalRows);
res.list = list.ToArray(typeof(address)) as address[];
res.SetTotalRows(totalRows);
return(res);
}
public productAvails[] Getproductavail(ISyncWSParameter dataParam, string clientId, string stockNo, string partNo)
{
IDataReader reader = null;
int totalRows;
Getproductavail(
clientId,
stockNo,
partNo,
out reader);
ArrayList list = ReaderHelper.Read(
reader,
new productAvails(),
dataParam.GetSkipNoFirstRows(),
dataParam.GetMaxRows(),
out totalRows);
return(list.ToArray(typeof(productAvails)) as productAvails[]);
}
public customerOrderTypeSearchResult Findcustomerordertype(ISyncWSParameter dataParam)
{
IDataReader reader = null;
customerOrderTypeSearchResult res = new customerOrderTypeSearchResult();
int totalRows;
Findcustomerordertype(
out reader);
ArrayList list = ReaderHelper.Read(
reader,
new customerOrderType(),
dataParam.GetSkipNoFirstRows(),
dataParam.GetMaxRows(),
out totalRows);
res.list = list.ToArray(typeof(customerOrderType)) as customerOrderType[];
res.SetTotalRows(totalRows);
return(res);
}
public ISyncWSResult FindDepartureRoute(Database database, ISyncWSParameter dataParameter)
{
internalFindDepartureRouteSearchParameters internalFindDepartureRouteSearchParameters = (internalFindDepartureRouteSearchParameters)dataParameter;
WebServicesTransport pkg = new WebServicesTransport(database);
internalFindDepartureRouteResult res = pkg.Finddepartureroute(dataParameter, internalFindDepartureRouteSearchParameters.DepartureIdentity);
foreach (Route item in res.list)
{
// use same parameter structure
internalFindDepartureRouteSearchParameters subParams = new internalFindDepartureRouteSearchParameters();
subParams.DepartureIdentity = internalFindDepartureRouteSearchParameters.DepartureIdentity;
subParams.firstResult = null;
subParams.maxResult = null;
item.RouteStops = pkg.Finddepartureroutestops(subParams, subParams.DepartureIdentity);
}
return(res);
}
public ISyncWSResult findCustomerById(Database database, ISyncWSParameter dataParameter)
{
customerSearchParameters customerSearchParameters = (customerSearchParameters)dataParameter;
WebServices3pl pkg = new WebServices3pl(database);
customerSearchResult res = pkg.findCustomerById(dataParameter, customerSearchParameters.clientId, customerSearchParameters.customerId);
if (dataParameter.GetReturnDetails())
{
foreach (customer item in res.list)
{
customerSearchParameters subParams = new customerSearchParameters();
subParams.firstResult = null;
subParams.maxResult = null;
addressSearchResult addressResult;
if (customerSearchParameters.customerId != null)
{
addressResult = pkg.getAddresses(subParams, customerSearchParameters.clientId, item.id);
}
else
{
addressResult = pkg.getAddresses(subParams, customerSearchParameters.clientId, null);
}
int i = 0;
foreach (address address in addressResult.list)
{
item.shippingAddress = new shippingAddress();
item.shippingAddress.shipCustNo = item.id;
item.shippingAddress.shiptoNo = Convert.ToString(i);
item.shippingAddress.address = address;
}
}
}
return((searchResult)res);
}
public warehouseSearchResult Findwarehousebyclient(ISyncWSParameter dataParam, string clientId)
{
IDataReader reader = null;
int totalRows;
warehouseSearchResult res = new warehouseSearchResult();
Findwarehousebyclient(
clientId,
out reader);
ArrayList list = ReaderHelper.Read(
reader,
new warehouse(),
dataParam.GetSkipNoFirstRows(),
dataParam.GetMaxRows(),
out totalRows);
res.list = list.ToArray(typeof(warehouse)) as warehouse[];
res.SetTotalRows(totalRows);
return(res);
}
public methodOfShipmentSearchResult Findmethodofshipmentbyclient(ISyncWSParameter dataParam, string clientId)
{
IDataReader reader = null;
methodOfShipmentSearchResult res = new methodOfShipmentSearchResult();
int totalRows;
Findmethodofshipmentbyclient(
clientId,
out reader);
ArrayList list = ReaderHelper.Read(
reader,
new methodOfShipment(),
dataParam.GetSkipNoFirstRows(),
dataParam.GetMaxRows(),
out totalRows);
res.list = list.ToArray(typeof(methodOfShipment)) as methodOfShipment[];
res.SetTotalRows(totalRows);
return(res);
}
public internalFindDepartureRouteResult Finddepartureroute(ISyncWSParameter dataParam, string DepartureIdentity)
{
IDataReader reader = null;
int totalRows;
internalFindDepartureRouteResult res = new internalFindDepartureRouteResult();
Finddepartureroute(
DepartureIdentity,
out reader);
ArrayList list = ReaderHelper.Read(
reader,
new Route(),
dataParam.GetSkipNoFirstRows(),
dataParam.GetMaxRows(),
out totalRows);
res.list = list.ToArray(typeof(Route)) as Route[];
res.SetTotalRows(totalRows);
return(res);
}
public partySearchResult findPartyById(ISyncWSParameter dataParam, string clientId, string partyId, partyType pt)
{
IDataReader reader = null;
int totalRows;
partySearchResult res = new partySearchResult();
string partyQualifier = ConvertPartyType(pt);
Findpartybyid(partyId, partyQualifier, clientId, out reader);
ArrayList list = ReaderHelper.Read(
reader,
new customer(),
dataParam.GetSkipNoFirstRows(),
dataParam.GetMaxRows(),
out totalRows);
res.list = list.ToArray(typeof(customer)) as customer[];
res.SetTotalRows(totalRows);
return(res);
}
public productSearchResult Findproductbydescription(ISyncWSParameter dataParam, string clientId, string partDescr)
{
IDataReader reader = null;
int totalRows;
productSearchResult res = new productSearchResult();
Findproductbydescription(
clientId,
partDescr,
out reader);
ArrayList list = ReaderHelper.Read(
reader,
new product(),
dataParam.GetSkipNoFirstRows(),
dataParam.GetMaxRows(),
out totalRows);
res.list = list.ToArray(typeof(product)) as product[];
res.SetTotalRows(totalRows);
return(res);
}
public customerSearchResult findCustomerById(ISyncWSParameter dataParam, string clientId, string customerId)
{
IDataReader reader = null;
int totalRows;
customerSearchResult res = new customerSearchResult();
Findcustomersbyid(
clientId,
customerId,
out reader);
ArrayList list = ReaderHelper.Read(
reader,
new customer(),
dataParam.GetSkipNoFirstRows(),
dataParam.GetMaxRows(),
out totalRows);
res.list = list.ToArray(typeof(customer)) as customer[];
res.SetTotalRows(totalRows);
return(res);
}
public ISyncWSResult findPartyById(Database database, ISyncWSParameter dataParameter)
{
partySearchParameters partySearchParameters = (partySearchParameters)dataParameter;
WebServices3pl pkg = new WebServices3pl(database);
partySearchResult res = pkg.findPartyById(
dataParameter,
partySearchParameters.clientId,
partySearchParameters.partyId,
partySearchParameters.partyType);
if (dataParameter.GetReturnDetails())
{
foreach (customer item in res.list)
{
partySearchParameters subParams = new partySearchParameters();
subParams.firstResult = null;
subParams.maxResult = null;
addressSearchResult addressResult;
addressResult = pkg.getPartyAddress(subParams, partySearchParameters.clientId, item.id, partySearchParameters.partyType);
int i = 0;
foreach (address address in addressResult.list)
{
item.shippingAddress = new shippingAddress();
item.shippingAddress.shipCustNo = item.id;
item.shippingAddress.shiptoNo = Convert.ToString(i);
item.shippingAddress.address = address;
}
}
}
return((searchResult)res);
}
public ISyncWSResult saveOrder(Database database, ISyncWSParameter dataParameter)
{
orderSaveParameters orderSaveParameters = (orderSaveParameters)dataParameter;
orderSaveResult res = null;
switch (orderSaveParameters.order.orderType)
{
case orderType.CO:
throw new Exception("orderType CO not supported");
case orderType.CO3PL:
res = saveCO3PL(database, orderSaveParameters);
break;
case orderType.PO:
res = savePO(database, orderSaveParameters);
break;
default:
throw new Exception("unknown orderType");
}
return(res);
}
