/* private void loadItems()
* {
* string request = "ItemQueryRq";
* connectToQB();
* int count = getCount(request);
* IMsgSetResponse responseMsgSet = processRequestFromQB(buildItemQueryRq(new string[] { "FullName" }, null));
* string[,] retVal = parseItemQueryRs(responseMsgSet, count, 1);
* disconnectFromQB();
* string[] itemList = getItemFullNames(retVal);
* fillComboBox(comboBox_Item1, itemList);
* fillComboBox(comboBox_Item2, itemList);
* fillComboBox(comboBox_Item3, itemList);
* fillComboBox(comboBox_Item4, itemList);
* fillComboBox(comboBox_Item5, itemList);
* }
*
* private string[] getItemFullNames(string[,] retVal)
* {
* //retVal[countOfRows, arraySize]
* //arraySize is 3 for FullName, Desc, Price but in this case 1 for FullName only
* int countOfRows = retVal.GetUpperBound(0);
* string[] itemList = new string[countOfRows];
* for (int i = 0; i < countOfRows; i++)
* {
* itemList[i] = retVal[i, 0];
* }
* return itemList;
* }
*
* private void loadTerms()
* {
* string request = "TermsQueryRq";
* connectToQB();
* int count = getCount(request);
* IMsgSetResponse responseMsgSet = processRequestFromQB(buildTermsQueryRq());
* string[] termsList = parseTermsQueryRs(responseMsgSet, count);
* disconnectFromQB();
* fillComboBox(this.comboBox_Terms, termsList);
* }
*
* private void loadSalesTaxCodes()
* {
* string request = "SalesTaxCodeQueryRq";
* connectToQB();
* int count = getCount(request);
* IMsgSetResponse responseMsgSet = processRequestFromQB(buildSalesTaxCodeQueryRq());
* string[] salesTaxCodeList = parseSalesTaxCodeQueryRs(responseMsgSet, count);
* disconnectFromQB();
* fillComboBox(this.comboBox_Tax1, salesTaxCodeList);
* fillComboBox(this.comboBox_Tax2, salesTaxCodeList);
* fillComboBox(this.comboBox_Tax3, salesTaxCodeList);
* fillComboBox(this.comboBox_Tax4, salesTaxCodeList);
* fillComboBox(this.comboBox_Tax5, salesTaxCodeList);
* }
*
* private void loadCustomerMsg()
* {
* string request = "CustomerMsgQueryRq";
* connectToQB();
* int count = getCount(request);
* IMsgSetResponse responseMsgSet = processRequestFromQB(buildCustomerMsgQueryRq(new string[] { "Name" }, null));
* string[] customerMsgList = parseCustomerMsgQueryRs(responseMsgSet, count);
* disconnectFromQB();
* fillComboBox(comboBox_CustomerMessage, customerMsgList);
* }
*
* private string getBillShipTo(string customerName, string billOrShip)
* {
* connectToQB();
* IMsgSetResponse responseMsgSet = processRequestFromQB(buildCustomerQueryRq(new string[] { billOrShip }, customerName));
* string[] billShipTo = parseCustomerQueryRs(responseMsgSet, 1);
* if (billShipTo[0] == null) billShipTo[0] = "";
* disconnectFromQB();
* return billShipTo[0];
* }
*
* private string getCurrencyCode(string customerName)
* {
* connectToQB();
* IMsgSetResponse responseMsgSet = processRequestFromQB(buildCustomerQueryRq(new string[] { "CurrencyRef" }, customerName));
* string[] currencyCode = parseCustomerQueryRs(responseMsgSet, 1);
* disconnectFromQB();
* return currencyCode[0];
* }
*
* private string getExchangeRate(string currencyName)
* {
* connectToQB();
* IMsgSetResponse responseMsgSet = processRequestFromQB(buildCurrencyQueryRq(currencyName));
* string[] exrate = parseCurrencyQueryRs(responseMsgSet, 1);
* disconnectFromQB();
* if (exrate[0] == null || exrate[0] == "") exrate[0] = "1.0";
* return exrate[0];
* }
*
* // REQUEST BUILDING
* private IMsgSetRequest buildPreferencesQueryRq(string[] includeRetElement, string fullName)
* {
* IMsgSetRequest requestMsgSet = sessionManager.getMsgSetRequest();
* requestMsgSet.Attributes.OnError = ENRqOnError.roeContinue;
* IPreferencesQuery prefQuery = requestMsgSet.AppendPreferencesQueryRq();
* for (int x = 0; x < includeRetElement.Length; x++)
* {
* prefQuery.IncludeRetElementList.Add(includeRetElement[x]);
* }
* return requestMsgSet;
* }
*/
private IMsgSetRequest buildDataCountQuery(string request)
{
IMsgSetRequest requestMsgSet = sessionManager.getMsgSetRequest();
requestMsgSet.Attributes.OnError = ENRqOnError.roeContinue;
switch (request)
{
case "CustomerQueryRq":
ICustomerQuery custQuery = requestMsgSet.AppendCustomerQueryRq();
custQuery.metaData.SetValue(ENmetaData.mdMetaDataOnly);
break;
case "ItemQueryRq":
IItemQuery itemQuery = requestMsgSet.AppendItemQueryRq();
itemQuery.metaData.SetValue(ENmetaData.mdMetaDataOnly);
break;
case "TermsQueryRq":
ITermsQuery termsQuery = requestMsgSet.AppendTermsQueryRq();
termsQuery.metaData.SetValue(ENmetaData.mdMetaDataOnly);
break;
case "SalesTaxCodeQueryRq":
ISalesTaxCodeQuery salesTaxQuery = requestMsgSet.AppendSalesTaxCodeQueryRq();
salesTaxQuery.metaData.SetValue(ENmetaData.mdMetaDataOnly);
break;
case "CustomerMsgQueryRq":
ICustomerMsgQuery custMsgQuery = requestMsgSet.AppendCustomerMsgQueryRq();
custMsgQuery.metaData.SetValue(ENmetaData.mdMetaDataOnly);
break;
default:
break;
}
return(requestMsgSet);
}
