Versions Compared

Version Old Version 19 New Version 20
Changes made by

Adam Chang

Adam Chang

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Java Client Example

Code Block
		DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();


System.out.println("\n=======================================isValidKFSVendors()================================");
List<VendorValidation> resultList28 = myBean.isValidKFSVendors(new String[][]{{"1126","1"},{"1127","1"},{"0000","0"}});
if (resultList28 != null) {
	for (Iterator i = resultList28.iterator(); i.hasNext();) {
		VendorValidation element = (VendorValidation)i.next();
		System.out.println("SERVER UNIT TEST-Result List28: " + element.toString());
	}
} else {
	System.out.println("something bad happened...please check your query");
}

 

getValidKFSVendors(List of (kfsVendorHeaderId, kfsVendorDetailId) )

Input Specifications

IndexParameterDescriptionRequired?Data Type (max length)Example
0kfsVendorHeaderIdVendor Header Generated IDYString(10)1126
1kfsVendorDetailIdVendor Detail Assigned IDYString(10)1

DB Query

Code Block
SELECT CONVERT(varchar(10), a.vndr_hdr_gnrtd_id) AS vndr_hdr_gnrtd_id,
       CONVERT(varchar(10), a.vndr_dtl_asnd_id) AS vndr_dtl_asnd_id, 
       a.vndr_nm,
       a.vndr_duns_nbr
FROM PUR_VNDR_DTL_T a 
WHERE 
(
(a.vndr_hdr_gnrtd_id = '1126' AND a.vndr_dtl_asnd_id = '1') OR 
(a.vndr_hdr_gnrtd_id = '1127' ANDnWSClient-isValidKFSVendors()");
StringArray sa280 = new StringArray();
sa280.getItem().add("1126");
sa280.getItem().add("1");
StringArray sa281 = new StringArray();
sa281.getItem().add("1127");
sa281.getItem().add("1");
StringArray sa282 = new StringArray();
sa282.getItem().add("0000");
sa282.getItem().add("0");
List<VendorValidation> resultList28 = ds.isValidKFSVendors(Arrays.asList(sa280, sa281, sa282));
if (resultList28 != null) {
	for (Iterator i = resultList28.iterator(); i.hasNext();) {
		VendorValidation element = (VendorValidation)i.next();
		System.out.println("\t" + element.getKfsVendorHeaderId() + "/" + element.getKfsVendorDetailId() + " : " + element.isValid());
	}
} else {
	System.out.println("something bad happened...please check your query");
}

 

...

getValidKFSVendors(List of (kfsVendorHeaderId, kfsVendorDetailId) )

Input Specifications

IndexParameterDescriptionRequired?Data Type (max length)Example
0kfsVendorHeaderIdVendor Header Generated IDYString(10)1126
1kfsVendorDetailIdVendor Detail Assigned IDYString(10)1

DB Query

Code Block
SELECT CONVERT(varchar(10), a.vndr_hdr_gnrtd_id) AS vndr_hdr_gnrtd_id,
       CONVERT(varchar(10), a.vndr_dtl_asnd_id = '1') ORAS (a.vndr_hdrdtl_gnrtdasnd_id = '0000' AND, 
       a.vndr_dtl_asnd_id = '0')
);

Result Schema: A list of following elements (VendorDetails.java)

...

nm,
       a.vndr_duns_nbr
FROM PUR_VNDR_DTL_T a 
WHERE 
(
(a.vndr_hdr_gnrtd_id

...

 = '1126' AND a.vndr_dtl_asnd_id

...

vndr_nm

...

vndr_duns_nbr

...

WS Example

Request
Code Block
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
      <adc:getValidKFSVendors>
          = '1') OR 
(a.vndr_hdr_gnrtd_id = '1127' AND a.vndr_dtl_asnd_id = '1') OR
(a.vndr_hdr_gnrtd_id = '0000' AND a.vndr_dtl_asnd_id = '0')
);

Result Schema: A list of following elements (VendorDetails.java)

DB ParameterJava ParameterDescriptionData TypeExample
vndr_hdr_gnrtd_id
kfsVendorHeaderIdVendor Header Generated IDString1126
vndr_dtl_asnd_id
kfsVendorDetailIdVendor Detail Assigned IDString1
vndr_nm
kfsVendorNameVendor NameStringCORNELL UNIVERSITY-ILR
vndr_duns_nbr
kfsVendorDUNSNumberVendor DUNS NumberString0

WS Example

Request
Code Block
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
      <adc:getValidKFSVendors>
         <kfsVendorList>
            <item>1126</item>
            <item>1</item>
         </kfsVendorList>
         <kfsVendorList>
            <item>1127</item>
            <item>1</item>
         </kfsVendorList>
         <kfsVendorList>
            <item>0000</item>
            <item>0</item>
         </kfsVendorList>
      </adc:getValidKFSVendors>
   </soapenv:Body>
</soapenv:Envelope>

...

Code Block
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:getValidKFSVendorsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <kfsVendorDUNSNumber>0</kfsVendorDUNSNumber>
            <kfsVendorDetailId>1</kfsVendorDetailId>
            <kfsVendorHeaderId>1126</kfsVendorHeaderId>
            <kfsVendorName>CORNELL UNIVERSITY-ILR</kfsVendorName>
         </return>
         <return>
            <kfsVendorDUNSNumber>0</kfsVendorDUNSNumber>
            <kfsVendorDetailId>1</kfsVendorDetailId>
            <kfsVendorHeaderId>1127</kfsVendorHeaderId>
            <kfsVendorName>THE CENTER QUICKPRINT</kfsVendorName>
         </return>
      </ns2:getValidKFSVendorsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block
DWHServerService dss = new DWHServerService();
DWHServer ds =   <kfsVendorName>THE CENTER QUICKPRINT</kfsVendorName>
         </return>
      </ns2:getValidKFSVendorsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block
System.out.println("\n=======================================getValidKFSVendors()================================dss.getDWHServerPortCustom();

System.out.println("\nWSClient-getValidKFSVendors()");
StringArray sa290 = new StringArray();
sa290.getItem().add("1126");
sa290.getItem().add("1");
StringArray sa291 = new StringArray();
sa291.getItem().add("1127");
sa291.getItem().add("1");
StringArray sa292 = new StringArray();
sa292.getItem().add("0000");
sa292.getItem().add("0");
List<VendorDetails> resultList29 = myBeands.getValidKFSVendors(new String[][]{{"1126","1"},{"1127","1"},{"0000","0"}}Arrays.asList(sa290, sa291, sa292));
if (resultList29 != null) {
	for (Iterator i = resultList29.iterator(); i.hasNext();) {
		VendorDetails element = (VendorDetails)i.next();
		System.out.println("SERVER UNIT TEST-Result List29: ("\t" + element.getKfsVendorHeaderId() + "/" + element.getKfsVendorDetailId() + " : " + element.getKfsVendorName() + "/" + element.toStringgetKfsVendorDUNSNumber());
	}
} else {
	System.out.println("something bad happened...please check your query");
}

...

Java Client Example

Code Block
System.out.println("\n=======================================DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();


System.out.println("\nWSClient--getAllKFSVendors()================================");
List<VendorDetails> resultList30 = myBeands.getAllKFSVendors();
if (resultList30 != null) {
	//for (Iterator i = resultList26.iterator(); i.hasNext();) {
	//	VendorDetails element = (VendorDetails)i.next();
	//	System.out.println("SERVER UNIT TEST-Result List30getAllVendor-total size: " + elementresultList30.toStringsize());
	//}
	System.out.println("SERVER UNIT TEST-getAllKFSVendors() total size: getAllVendor-1st item HeaderId / DetailId : VendorName / DUNSNumber" + ((VendorDetails)resultList30.sizeget(0));
	System.out.println("SERVER UNIT TEST-getAllKFSVendors() 1st element: " + .getKfsVendorHeaderId() + "/" + ((VendorDetails)resultList30.get(0)).getKfsVendorDetailId() + " : " + ((VendorDetails)resultList30.get(0)).getKfsVendorName() + "/" + ((VendorDetails)resultList30.get(0)).toStringgetKfsVendorDUNSNumber());
} else {
	System.out.println("something bad happened...please check your query");
}

...

Java Client Example

Code Block
System.out.println("\n=======================================isValidKFSVendorAddresses()================================DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();


System.out.println("\nWSClient-isValidKFSVendorAddresses()");
List<VendorAddressValidation> resultList31 = myBeands.isValidKFSVendorAddresses(Arrays.asList(new String[]{"21626", "21627", "0000"}));
if (resultList31 != null) {
	for (Iterator i = resultList31.iterator(); i.hasNext();) {
		VendorAddressValidation element = (VendorAddressValidation)i.next();
		System.out.println("SERVER UNIT TEST-Result List31"\t" + element.getKfsVendorAddrId() + " : " + element.toStringisValid());
	}
} else {
	System.out.println("something bad happened...please check your query");
}

 

...

getValidKFSVendorAddresses(List of (kfsVendorHeaderId, kfsVendorDetailId, kfsVendorAddrType))

...

Code Block
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:getValidKFSVendorAddressesResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <kfsVendorAddr1>338 SO. 4TH STREET</kfsVendorAddr1>
            <kfsVendorAddr2>P.O. BOX 446</kfsVendorAddr2>
            <kfsVendorAddrId>21633</kfsVendorAddrId>
            <kfsVendorAddrType>PO</kfsVendorAddrType>
            <kfsVendorCity>GROVER CITY</kfsVendorCity>
            <kfsVendorCountry>US</kfsVendorCountry>
            <kfsVendorDetailId>0</kfsVendorDetailId>
            <kfsVendorHeaderId>1007</kfsVendorHeaderId>
            <kfsVendorState>CA</kfsVendorState>
            <kfsVendorZip>93483-0446</kfsVendorZip>
         </return>
         <return>
            <kfsVendorAddr1>PO BOX 446</kfsVendorAddr1>
            <kfsVendorAddr2></kfsVendorAddr2>
            <kfsVendorAddrId>21634</kfsVendorAddrId>
            <kfsVendorAddrType>RM</kfsVendorAddrType>
            <kfsVendorCity>GROVER BEACH</kfsVendorCity>
            <kfsVendorCountry>US</kfsVendorCountry>
            <kfsVendorDetailId>0</kfsVendorDetailId>
            <kfsVendorHeaderId>1007</kfsVendorHeaderId>
            <kfsVendorState>CA</kfsVendorState>
            <kfsVendorZip>93483-0446</kfsVendorZip>
         </return>
         <return>
            <kfsVendorAddr1>ONE ZEISS DRIVE</kfsVendorAddr1>
            <kfsVendorAddr2></kfsVendorAddr2>
            <kfsVendorAddrId>21638</kfsVendorAddrId>
            <kfsVendorAddrType>PO</kfsVendorAddrType>
            <kfsVendorCity>THORNWOOD</kfsVendorCity>
            <kfsVendorCountry>US</kfsVendorCountry>
            <kfsVendorDetailId>3</kfsVendorDetailId>
            <kfsVendorHeaderId>13788</kfsVendorHeaderId>
            <kfsVendorState>NY</kfsVendorState>
            <kfsVendorZip>10594-1939</kfsVendorZip>
         </return>
         <return>
            <kfsVendorAddr1>PO BOX 5943</kfsVendorAddr1>
            <kfsVendorAddr2></kfsVendorAddr2>
            <kfsVendorAddrId>21639</kfsVendorAddrId>
            <kfsVendorAddrType>RM</kfsVendorAddrType>
            <kfsVendorCity>NEW YORK</kfsVendorCity>
            <kfsVendorCountry>US</kfsVendorCountry>
            <kfsVendorDetailId>0</kfsVendorDetailId>
            <kfsVendorAddrId>21639<<kfsVendorHeaderId>13788</kfsVendorAddrId>kfsVendorHeaderId>
            <kfsVendorAddrType>RM<<kfsVendorState>NY</kfsVendorAddrType>kfsVendorState>
            <kfsVendorCity>NEW YORK</kfsVendorCity><kfsVendorZip>10087-5943</kfsVendorZip>
            <kfsVendorCountry>US</kfsVendorCountry></return>
      </ns2:getValidKFSVendorAddressesResponse>
     <kfsVendorDetailId>0</kfsVendorDetailId>
            <kfsVendorHeaderId>13788</kfsVendorHeaderId>
            <kfsVendorState>NY</kfsVendorState>
            <kfsVendorZip>10087-5943</kfsVendorZip>
         </return>
      </ns2:getValidKFSVendorAddressesResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block
System.out.println("\n=======================================getValidKFSVendorAddresses()================================</soap:Body>
</soap:Envelope>

Java Client Example

Code Block
DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();


System.out.println("\nWSClient-getValidKFSVendorAddresses()");
StringArray sa320 = new StringArray();
sa320.getItem().add("1007");
sa320.getItem().add("0");
sa320.getItem().add("PO");
StringArray sa321 = new StringArray();
sa321.getItem().add("1007");
sa321.getItem().add("0");
sa321.getItem().add("RM");
StringArray sa322 = new StringArray();
sa322.getItem().add("13788");
sa322.getItem().add("3");
sa322.getItem().add("PO");
StringArray sa323 = new StringArray();
sa323.getItem().add("13788");
sa323.getItem().add("0");
sa323.getItem().add("RM");
StringArray sa324 = new StringArray();
sa324.getItem().add("00000");
sa324.getItem().add("0");
sa324.getItem().add("XX");
List<VendorAddressDetails> resultList32 = myBeands.getValidKFSVendorAddresses(new String[][]{{"1007","0","PO"},{"1007","0","RM"},{"13788","3","PO"},{"13788","0","RM"},{"00000","0","XX"}}(Arrays.asList(sa320, sa321, sa322, sa323, sa324));
if (resultList32 != null) {
	for (Iterator i = resultList32.iterator(); i.hasNext();) {
		VendorAddressDetails element = (VendorAddressDetails)i.next();
		System.out.println("\t" + element.getKfsVendorHeaderId() + "/" + element.getKfsVendorDetailId("SERVER UNIT TEST-Result List32) + "/" + element.getKfsVendorAddrType() + " : " + element.toStringgetKfsVendorAddrId() + "/" + element.getKfsVendorAddrId());
	}
} else {
	System.out.println("something bad happened...please check your query");
}

...