private IItemInventoryRet GetInventoryItem(string fullName)
{
IItemInventoryRetList itemInventoryRetList = null;
IItemInventoryRet InventoryItem = null;
try
{
QBItemInventory _QBItemInventory = new QBItemInventory();
IResponseList responseList = _QBItemInventory.GetItemInventor(fullName, sessionManager);
//if we sent only one request, there is only one response.
for (int i = 0; i < responseList.Count; i++)
{
IResponse response = responseList.GetAt(i);
//check the status code of the response, 0=ok, >0 is warning
if (response.StatusCode >= 0)
{
//the request-specific response is in the details, make sure we have some
if (response.Detail != null)
{
//make sure the response is the type we're expecting
ENResponseType responseType = (ENResponseType)response.Type.GetValue();
if (responseType == ENResponseType.rtItemInventoryQueryRs)
{
//upcast to more specific type here, this is safe because we checked with response.Type check above
itemInventoryRetList = (IItemInventoryRetList)response.Detail;
if (itemInventoryRetList != null && itemInventoryRetList.Count > 0)
{
for (int j = 0; j < itemInventoryRetList.Count; j++)
{
InventoryItem = itemInventoryRetList.GetAt(j);
}
}
}
}
}
else
{
int statusCode = response.StatusCode;
string statusMessage = response.StatusMessage;
string statusSeverity = response.StatusSeverity;
}
}
}
catch (Exception e)
{
}
return(InventoryItem);
}
public static string[,] extractItemQueryResponses(String response, Session sess)
{
string[,] items;
QBSessionManager sessionManager = new QBSessionManager();
IMsgSetResponse responseSet = sessionManager.ToMsgSetResponse(response, sess.getCountry(), sess.getMajorVers(), sess.getMinorVers());
IItemInventoryRetList itemRetList = responseSet.ResponseList.GetAt(0).Detail as IItemInventoryRetList;
int length = itemRetList.Count;
items = new string[length, 3];
if (length > 0)
{
for (int ndx = 0; ndx < length; ndx++)
{
IItemInventoryRet itemRet = itemRetList.GetAt(ndx);
items[ndx, 0] = itemRet.FullName.GetValue();
items[ndx, 1] = itemRet.SalesPrice.GetValue().ToString();
items[ndx, 2] = itemRet.QuantityOnHand.GetValue().ToString();
}
}
return(items);
}
void RequestInventory()
{
requestMsgSet.ClearRequests();
IItemInventoryQuery Inventory = requestMsgSet.AppendItemInventoryQueryRq();
responseMsgSet = sessionManager.DoRequests(requestMsgSet);
IResponseList responseList = responseMsgSet.ResponseList;
IResponse response = responseMsgSet.ResponseList.GetAt(0);
if (response.StatusCode >= 0)
{
//the request-specific response is in the details, make sure we have some
if (response.Detail != null)
{
//make sure the response is the type we're expecting
ENResponseType responseType = (ENResponseType)response.Type.GetValue();
if (responseType == ENResponseType.rtItemInventoryQueryRs)
{
//upcast to more specific type here, this is safe because we checked with response.Type check above
IItemInventoryRetList ItemInventoryRetList = (IItemInventoryRetList)response.Detail;
int count = ItemInventoryRetList.Count;
if (count > 0 && ItemList == null)
{
ItemList = new List <Items>();
}
for (int a = 0; a < count; a++)
{
ItemList.Add(WalkInventoryItem(ItemInventoryRetList.GetAt(a)));
}
}
}
}
else
{
throw new QBException(response.StatusCode, response.StatusMessage.ToString(), requestMsgSet.ToXMLString());
}
}
public TrackableCollection <ItemInventoryRet> WalkItemInventoryQueryRs(IMsgSetResponse responseMsgSet)
{
if (responseMsgSet == null)
{
return(null);
}
IResponseList responseList = responseMsgSet.ResponseList;
if (responseList == null)
{
return(null);
}
//if we sent only one request, there is only one response, we'll walk the list for this sample
for (int i = 0; i < responseList.Count; i++)
{
IResponse response = responseList.GetAt(i);
//check the status code of the response, 0=ok, >0 is warning
if (response.StatusCode >= 0)
{
//the request-specific response is in the details, make sure we have some
if (response.Detail != null)
{
//make sure the response is the type we're expecting
ENResponseType responseType = (ENResponseType)response.Type.GetValue();
if (responseType == ENResponseType.rtItemInventoryQueryRs)
{
//upcast to more specific type here, this is safe because we checked with response.Type check above
IItemInventoryRetList ItemInventoryRet = (IItemInventoryRetList)response.Detail;
return(WalkItemInventoryRet(ItemInventoryRet));
}
}
}
}
return(null);
}
public void Execute(IJobExecutionContext context)
{
IAccountRetList AccountList = null;
IPreferencesRet PreferencesRet = null;
IItemInventoryRetList itemInventoryRetList = null;
int maxRecords = 0;
try
{
//** 1. To Get TDS Data Using Entity Frame Work.
//TDSService _tdsService = new TDSService();
TDSItemInventoryList = GetMetrialData();
//** 2. If TDS data is grater than zero. than need to creat QBD session.
if (TDSItemInventoryList != null && TDSItemInventoryList.Any())
{
qbRequestItemSet = new QBRequestItemSet();
qbRequestItemSet.QBRequestItemList = new List <QBRequestItem>();
var bSessionResult = CreateQBsession();
if (bSessionResult)
{
//** 3. Using the QBD session to get AccountInfo.
AccountList = GetQBAccountDetails();
if (AccountList != null && AccountList.Count > 0)
{
qbRequestItemSet.AccountList = AccountList;
//** 4. Using the QBD session to get GetPreferences.
PreferencesRet = GetQBPreferencesDetails();
if (PreferencesRet != null)
{
qbRequestItemSet.PreferencesRet = PreferencesRet;
}
//** 5. Using the QBD session to get qbd invertory item list.
itemInventoryRetList = GetItemInventoryRetList(maxRecords);
if (itemInventoryRetList != null && itemInventoryRetList.Count > 0)
{
//Parallel.ForEach(itemInventoryRetList,item=>)
for (int i = 0; i < itemInventoryRetList.Count; i++)
{
var reqdata = itemInventoryRetList.GetAt(i);
if (TDSItemInventoryList.Where(x => x.TRC_CODE.Trim() == reqdata.FullName.GetValue()).SingleOrDefault() != null)
{
var reqitem = TDSItemInventoryList.Where(x => x.TRC_CODE.Trim() == reqdata.FullName.GetValue()).SingleOrDefault();
//var reqitem=itemInventoryRetList.GetAt(i);
double hh = reqdata.QuantityOnHand.GetValue();
if (reqitem.Quantity != reqdata.QuantityOnHand.GetValue())
{
QBRequestItem requestItem = new QBRequestItem();
requestItem.Action = QBAction.Modify;
reqdata.QuantityOnHand.SetValue(Convert.ToDouble(reqitem.Quantity));
requestItem.ItemInventoryRet = reqdata;
qbRequestItemSet.QBRequestItemList.Add(requestItem);
}
}
else
{
}
}
//** 4. To compare TDS and QBD item list using TRC_CODE code to asume as Name/Number in QBD item inventory list.
//** 5. If TRC_CODE is not match in QBD. than need to add to QBD as a new inventory item.
//** 6. If TRC_CODE is match in QBD. than need to ajust the quantity in QBD.
//** 7. final status need to send to client using email.
}
else
{
//** 5. If TRC_CODE is not match in QBD. than need to add to QBD as a new inventory item.
}
}
}
}
else
{
//ServiceLog.log.Fatal("TDS Data is empty " + DateTime.Now.ToLongDateString());
}
//ServiceLog.GetUserInfo();
//Email("Execution Execution");
}
catch (Exception ex)
{
// ServiceLog.Email(ex.ToString());
}
finally
{
_QBSession.CloseQBConnection(sessionManager);
}
}
POSAI_mvvm.QuickBooks.TrackableCollection <ItemInventoryRet> WalkItemInventoryRet(IItemInventoryRetList ItemInventoryRetList)
{
TrackableCollection <ItemInventoryRet> itmList = new TrackableCollection <QuickBooks.ItemInventoryRet>(null);
for (int i = 0; i < ItemInventoryRetList.Count; i++)
{
IItemInventoryRet positm = ItemInventoryRetList.GetAt(i);
ItemInventoryRet itm = new ItemInventoryRet();
if (positm == null)
{
continue;
}
//Go through all the elements of IpositmList
//Get value of ListID
if (positm.ListID != null)
{
itm.ListID = (string)positm.ListID.GetValue();
}
//Get value of ALU
if (positm.ALU != null)
{
itm.ALU = (string)positm.ALU.GetValue();
}
//Get value of Attribute
if (positm.Attribute != null)
{
itm.Attribute = (string)positm.Attribute.GetValue();
}
//Get value of DepartmentCode
if (positm.DepartmentCode != null)
{
itm.DepartmentCode = (string)positm.DepartmentCode.GetValue();
}
//Get value of Desc1
if (positm.Desc1 != null)
{
itm.Desc1 = (string)positm.Desc1.GetValue();
}
//Get value of Desc2
if (positm.Desc2 != null)
{
itm.Desc2 = (string)positm.Desc2.GetValue();
}
//Get value of ItemNumber
if (positm.ItemNumber != null)
{
itm.ItemNumber = (int)positm.ItemNumber.GetValue();
}
//Get value of ItemType
if (positm.ItemType != null)
{
itm.ItemType = ((ENItemType)positm.ItemType.GetValue()).ToString();
}
//Get value of Size
if (positm.Size != null)
{
itm.Size = (string)positm.Size.GetValue();
}
#region "More Properties"
// //Get value of TimeCreated
//if (ItemInventoryRet.TimeCreated != null)
//{
//DateTime TimeCreated78 = (DateTime)ItemInventoryRet.TimeCreated.GetValue();
//}
////Get value of TimeModified
//if (ItemInventoryRet.TimeModified != null)
//{
//DateTime TimeModified79 = (DateTime)ItemInventoryRet.TimeModified.GetValue();
//}
////Get value of COGSAccount
//if (ItemInventoryRet.COGSAccount != null)
//{
//string COGSAccount82 = (string)ItemInventoryRet.COGSAccount.GetValue();
//}
////Get value of Cost
//if (ItemInventoryRet.Cost != null)
//{
//double Cost83 = (double)ItemInventoryRet.Cost.GetValue();
//}
////Get value of DepartmentListID
//if (ItemInventoryRet.DepartmentListID != null)
//{
//string DepartmentListID85 = (string)ItemInventoryRet.DepartmentListID.GetValue();
//}
////Get value of IncomeAccount
//if (ItemInventoryRet.IncomeAccount != null)
//{
//string IncomeAccount88 = (string)ItemInventoryRet.IncomeAccount.GetValue();
//}
////Get value of IsBelowReorder
//if (ItemInventoryRet.IsBelowReorder != null)
//{
//bool IsBelowReorder89 = (bool)ItemInventoryRet.IsBelowReorder.GetValue();
//}
////Get value of IsEligibleForCommission
//if (ItemInventoryRet.IsEligibleForCommission != null)
//{
//bool IsEligibleForCommission90 = (bool)ItemInventoryRet.IsEligibleForCommission.GetValue();
//}
////Get value of IsPrintingTags
//if (ItemInventoryRet.IsPrintingTags != null)
//{
//bool IsPrintingTags91 = (bool)ItemInventoryRet.IsPrintingTags.GetValue();
//}
////Get value of IsUnorderable
//if (ItemInventoryRet.IsUnorderable != null)
//{
//bool IsUnorderable92 = (bool)ItemInventoryRet.IsUnorderable.GetValue();
//}
////Get value of HasPictures
//if (ItemInventoryRet.HasPictures != null)
//{
//bool HasPictures93 = (bool)ItemInventoryRet.HasPictures.GetValue();
//}
////Get value of IsEligibleForRewards
//if (ItemInventoryRet.IsEligibleForRewards != null)
//{
//bool IsEligibleForRewards94 = (bool)ItemInventoryRet.IsEligibleForRewards.GetValue();
//}
////Get value of IsWebItem
//if (ItemInventoryRet.IsWebItem != null)
//{
//bool IsWebItem95 = (bool)ItemInventoryRet.IsWebItem.GetValue();
//}
////Get value of LastReceived
//if (ItemInventoryRet.LastReceived != null)
//{
//DateTime LastReceived98 = (DateTime)ItemInventoryRet.LastReceived.GetValue();
//}
////Get value of MarginPercent
//if (ItemInventoryRet.MarginPercent != null)
//{
//int MarginPercent99 = (int)ItemInventoryRet.MarginPercent.GetValue();
//}
////Get value of MarkupPercent
//if (ItemInventoryRet.MarkupPercent != null)
//{
//int MarkupPercent100 = (int)ItemInventoryRet.MarkupPercent.GetValue();
//}
////Get value of MSRP
//if (ItemInventoryRet.MSRP != null)
//{
//double MSRP101 = (double)ItemInventoryRet.MSRP.GetValue();
//}
////Get value of OnHandStore01
//if (ItemInventoryRet.OnHandStore01 != null)
//{
//int OnHandStore01102 = (int)ItemInventoryRet.OnHandStore01.GetValue();
//}
////Get value of OnHandStore02
//if (ItemInventoryRet.OnHandStore02 != null)
//{
//int OnHandStore02103 = (int)ItemInventoryRet.OnHandStore02.GetValue();
//}
////Get value of OnHandStore03
//if (ItemInventoryRet.OnHandStore03 != null)
//{
//int OnHandStore03104 = (int)ItemInventoryRet.OnHandStore03.GetValue();
//}
////Get value of OnHandStore04
//if (ItemInventoryRet.OnHandStore04 != null)
//{
//int OnHandStore04105 = (int)ItemInventoryRet.OnHandStore04.GetValue();
//}
////Get value of OnHandStore05
//if (ItemInventoryRet.OnHandStore05 != null)
//{
//int OnHandStore05106 = (int)ItemInventoryRet.OnHandStore05.GetValue();
//}
////Get value of OnHandStore06
//if (ItemInventoryRet.OnHandStore06 != null)
//{
//int OnHandStore06107 = (int)ItemInventoryRet.OnHandStore06.GetValue();
//}
////Get value of OnHandStore07
//if (ItemInventoryRet.OnHandStore07 != null)
//{
//int OnHandStore07108 = (int)ItemInventoryRet.OnHandStore07.GetValue();
//}
////Get value of OnHandStore08
//if (ItemInventoryRet.OnHandStore08 != null)
//{
//int OnHandStore08109 = (int)ItemInventoryRet.OnHandStore08.GetValue();
//}
////Get value of OnHandStore09
//if (ItemInventoryRet.OnHandStore09 != null)
//{
//int OnHandStore09110 = (int)ItemInventoryRet.OnHandStore09.GetValue();
//}
////Get value of OnHandStore10
//if (ItemInventoryRet.OnHandStore10 != null)
//{
//int OnHandStore10111 = (int)ItemInventoryRet.OnHandStore10.GetValue();
//}
////Get value of OnHandStore11
//if (ItemInventoryRet.OnHandStore11 != null)
//{
//int OnHandStore11112 = (int)ItemInventoryRet.OnHandStore11.GetValue();
//}
////Get value of OnHandStore12
//if (ItemInventoryRet.OnHandStore12 != null)
//{
//int OnHandStore12113 = (int)ItemInventoryRet.OnHandStore12.GetValue();
//}
////Get value of OnHandStore13
//if (ItemInventoryRet.OnHandStore13 != null)
//{
//int OnHandStore13114 = (int)ItemInventoryRet.OnHandStore13.GetValue();
//}
////Get value of OnHandStore14
//if (ItemInventoryRet.OnHandStore14 != null)
//{
//int OnHandStore14115 = (int)ItemInventoryRet.OnHandStore14.GetValue();
//}
////Get value of OnHandStore15
//if (ItemInventoryRet.OnHandStore15 != null)
//{
//int OnHandStore15116 = (int)ItemInventoryRet.OnHandStore15.GetValue();
//}
////Get value of OnHandStore16
//if (ItemInventoryRet.OnHandStore16 != null)
//{
//int OnHandStore16117 = (int)ItemInventoryRet.OnHandStore16.GetValue();
//}
////Get value of OnHandStore17
//if (ItemInventoryRet.OnHandStore17 != null)
//{
//int OnHandStore17118 = (int)ItemInventoryRet.OnHandStore17.GetValue();
//}
////Get value of OnHandStore18
//if (ItemInventoryRet.OnHandStore18 != null)
//{
//int OnHandStore18119 = (int)ItemInventoryRet.OnHandStore18.GetValue();
//}
////Get value of OnHandStore19
//if (ItemInventoryRet.OnHandStore19 != null)
//{
//int OnHandStore19120 = (int)ItemInventoryRet.OnHandStore19.GetValue();
//}
////Get value of OnHandStore20
//if (ItemInventoryRet.OnHandStore20 != null)
//{
//int OnHandStore20121 = (int)ItemInventoryRet.OnHandStore20.GetValue();
//}
////Get value of ReorderPointStore01
//if (ItemInventoryRet.ReorderPointStore01 != null)
//{
//int ReorderPointStore01122 = (int)ItemInventoryRet.ReorderPointStore01.GetValue();
//}
////Get value of ReorderPointStore02
//if (ItemInventoryRet.ReorderPointStore02 != null)
//{
//int ReorderPointStore02123 = (int)ItemInventoryRet.ReorderPointStore02.GetValue();
//}
////Get value of ReorderPointStore03
//if (ItemInventoryRet.ReorderPointStore03 != null)
//{
//int ReorderPointStore03124 = (int)ItemInventoryRet.ReorderPointStore03.GetValue();
//}
////Get value of ReorderPointStore04
//if (ItemInventoryRet.ReorderPointStore04 != null)
//{
//int ReorderPointStore04125 = (int)ItemInventoryRet.ReorderPointStore04.GetValue();
//}
////Get value of ReorderPointStore05
//if (ItemInventoryRet.ReorderPointStore05 != null)
//{
//int ReorderPointStore05126 = (int)ItemInventoryRet.ReorderPointStore05.GetValue();
//}
////Get value of ReorderPointStore06
//if (ItemInventoryRet.ReorderPointStore06 != null)
//{
//int ReorderPointStore06127 = (int)ItemInventoryRet.ReorderPointStore06.GetValue();
//}
////Get value of ReorderPointStore07
//if (ItemInventoryRet.ReorderPointStore07 != null)
//{
//int ReorderPointStore07128 = (int)ItemInventoryRet.ReorderPointStore07.GetValue();
//}
////Get value of ReorderPointStore08
//if (ItemInventoryRet.ReorderPointStore08 != null)
//{
//int ReorderPointStore08129 = (int)ItemInventoryRet.ReorderPointStore08.GetValue();
//}
////Get value of ReorderPointStore09
//if (ItemInventoryRet.ReorderPointStore09 != null)
//{
//int ReorderPointStore09130 = (int)ItemInventoryRet.ReorderPointStore09.GetValue();
//}
////Get value of ReorderPointStore10
//if (ItemInventoryRet.ReorderPointStore10 != null)
//{
//int ReorderPointStore10131 = (int)ItemInventoryRet.ReorderPointStore10.GetValue();
//}
////Get value of ReorderPointStore11
//if (ItemInventoryRet.ReorderPointStore11 != null)
//{
//int ReorderPointStore11132 = (int)ItemInventoryRet.ReorderPointStore11.GetValue();
//}
////Get value of ReorderPointStore12
//if (ItemInventoryRet.ReorderPointStore12 != null)
//{
//int ReorderPointStore12133 = (int)ItemInventoryRet.ReorderPointStore12.GetValue();
//}
////Get value of ReorderPointStore13
//if (ItemInventoryRet.ReorderPointStore13 != null)
//{
//int ReorderPointStore13134 = (int)ItemInventoryRet.ReorderPointStore13.GetValue();
//}
////Get value of ReorderPointStore14
//if (ItemInventoryRet.ReorderPointStore14 != null)
//{
//int ReorderPointStore14135 = (int)ItemInventoryRet.ReorderPointStore14.GetValue();
//}
////Get value of ReorderPointStore15
//if (ItemInventoryRet.ReorderPointStore15 != null)
//{
//int ReorderPointStore15136 = (int)ItemInventoryRet.ReorderPointStore15.GetValue();
//}
////Get value of ReorderPointStore16
//if (ItemInventoryRet.ReorderPointStore16 != null)
//{
//int ReorderPointStore16137 = (int)ItemInventoryRet.ReorderPointStore16.GetValue();
//}
////Get value of ReorderPointStore17
//if (ItemInventoryRet.ReorderPointStore17 != null)
//{
//int ReorderPointStore17138 = (int)ItemInventoryRet.ReorderPointStore17.GetValue();
//}
////Get value of ReorderPointStore18
//if (ItemInventoryRet.ReorderPointStore18 != null)
//{
//int ReorderPointStore18139 = (int)ItemInventoryRet.ReorderPointStore18.GetValue();
//}
////Get value of ReorderPointStore19
//if (ItemInventoryRet.ReorderPointStore19 != null)
//{
//int ReorderPointStore19140 = (int)ItemInventoryRet.ReorderPointStore19.GetValue();
//}
////Get value of ReorderPointStore20
//if (ItemInventoryRet.ReorderPointStore20 != null)
//{
//int ReorderPointStore20141 = (int)ItemInventoryRet.ReorderPointStore20.GetValue();
//}
////Get value of OrderByUnit
//if (ItemInventoryRet.OrderByUnit != null)
//{
//string OrderByUnit142 = (string)ItemInventoryRet.OrderByUnit.GetValue();
//}
////Get value of OrderCost
//if (ItemInventoryRet.OrderCost != null)
//{
//double OrderCost143 = (double)ItemInventoryRet.OrderCost.GetValue();
//}
////Get value of Price1
//if (ItemInventoryRet.Price1 != null)
//{
//double Price1144 = (double)ItemInventoryRet.Price1.GetValue();
//}
////Get value of Price2
//if (ItemInventoryRet.Price2 != null)
//{
//double Price2145 = (double)ItemInventoryRet.Price2.GetValue();
//}
////Get value of Price3
//if (ItemInventoryRet.Price3 != null)
//{
//double Price3146 = (double)ItemInventoryRet.Price3.GetValue();
//}
////Get value of Price4
//if (ItemInventoryRet.Price4 != null)
//{
//double Price4147 = (double)ItemInventoryRet.Price4.GetValue();
//}
////Get value of Price5
//if (ItemInventoryRet.Price5 != null)
//{
//double Price5148 = (double)ItemInventoryRet.Price5.GetValue();
//}
////Get value of QuantityOnCustomerOrder
//if (ItemInventoryRet.QuantityOnCustomerOrder != null)
//{
//int QuantityOnCustomerOrder149 = (int)ItemInventoryRet.QuantityOnCustomerOrder.GetValue();
//}
////Get value of QuantityOnHand
//if (ItemInventoryRet.QuantityOnHand != null)
//{
//int QuantityOnHand150 = (int)ItemInventoryRet.QuantityOnHand.GetValue();
//}
////Get value of QuantityOnOrder
//if (ItemInventoryRet.QuantityOnOrder != null)
//{
//int QuantityOnOrder151 = (int)ItemInventoryRet.QuantityOnOrder.GetValue();
//}
////Get value of QuantityOnPendingOrder
//if (ItemInventoryRet.QuantityOnPendingOrder != null)
//{
//int QuantityOnPendingOrder152 = (int)ItemInventoryRet.QuantityOnPendingOrder.GetValue();
//}
//if (ItemInventoryRet.AvailableQtyList != null)
//{
//for (int i153 = 0; i153 < ItemInventoryRet.AvailableQtyList.Count; i153++)
//{
//IAvailableQty AvailableQty = ItemInventoryRet.AvailableQtyList.GetAt(i153);
////Get value of StoreNumber
//if (AvailableQty.StoreNumber != null)
//{
//int StoreNumber154 = (int)AvailableQty.StoreNumber.GetValue();
//}
////Get value of QuantityOnOrder
//if (AvailableQty.QuantityOnOrder != null)
//{
//int QuantityOnOrder155 = (int)AvailableQty.QuantityOnOrder.GetValue();
//}
////Get value of QuantityOnCustomerOrder
//if (AvailableQty.QuantityOnCustomerOrder != null)
//{
//int QuantityOnCustomerOrder156 = (int)AvailableQty.QuantityOnCustomerOrder.GetValue();
//}
////Get value of QuantityOnPendingOrder
//if (AvailableQty.QuantityOnPendingOrder != null)
//{
//int QuantityOnPendingOrder157 = (int)AvailableQty.QuantityOnPendingOrder.GetValue();
//}
//}
//}
////Get value of ReorderPoint
//if (ItemInventoryRet.ReorderPoint != null)
//{
//int ReorderPoint158 = (int)ItemInventoryRet.ReorderPoint.GetValue();
//}
////Get value of SellByUnit
//if (ItemInventoryRet.SellByUnit != null)
//{
//string SellByUnit159 = (string)ItemInventoryRet.SellByUnit.GetValue();
//}
////Get value of SerialFlag
//if (ItemInventoryRet.SerialFlag != null)
//{
//ENSerialFlag SerialFlag160 = (ENSerialFlag)ItemInventoryRet.SerialFlag.GetValue();
//}
////Get value of StoreExchangeStatus
//if (ItemInventoryRet.StoreExchangeStatus != null)
//{
//ENStoreExchangeStatus StoreExchangeStatus162 = (ENStoreExchangeStatus)ItemInventoryRet.StoreExchangeStatus.GetValue();
//}
////Get value of TaxCode
//if (ItemInventoryRet.TaxCode != null)
//{
//string TaxCode163 = (string)ItemInventoryRet.TaxCode.GetValue();
//}
////Get value of UnitOfMeasure
//if (ItemInventoryRet.UnitOfMeasure != null)
//{
//string UnitOfMeasure164 = (string)ItemInventoryRet.UnitOfMeasure.GetValue();
//}
////Get value of UPC
//if (ItemInventoryRet.UPC != null)
//{
//string UPC165 = (string)ItemInventoryRet.UPC.GetValue();
//}
////Get value of VendorCode
//if (ItemInventoryRet.VendorCode != null)
//{
//string VendorCode166 = (string)ItemInventoryRet.VendorCode.GetValue();
//}
////Get value of VendorListID
//if (ItemInventoryRet.VendorListID != null)
//{
//string VendorListID167 = (string)ItemInventoryRet.VendorListID.GetValue();
//}
////Get value of WebDesc
//if (ItemInventoryRet.WebDesc != null)
//{
//string WebDesc168 = (string)ItemInventoryRet.WebDesc.GetValue();
//}
////Get value of WebPrice
//if (ItemInventoryRet.WebPrice != null)
//{
//double WebPrice169 = (double)ItemInventoryRet.WebPrice.GetValue();
//}
////Get value of Manufacturer
//if (ItemInventoryRet.Manufacturer != null)
//{
//string Manufacturer170 = (string)ItemInventoryRet.Manufacturer.GetValue();
//}
////Get value of Weight
//if (ItemInventoryRet.Weight != null)
//{
//IQBFloatType Weight171 = (IQBFloatType)ItemInventoryRet.Weight.GetValue();
//}
////Get value of WebSKU
//if (ItemInventoryRet.WebSKU != null)
//{
//string WebSKU172 = (string)ItemInventoryRet.WebSKU.GetValue();
//}
////Get value of Keywords
//if (ItemInventoryRet.Keywords != null)
//{
//string Keywords173 = (string)ItemInventoryRet.Keywords.GetValue();
//}
////Get value of WebCategories
//if (ItemInventoryRet.WebCategories != null)
//{
//string WebCategories174 = (string)ItemInventoryRet.WebCategories.GetValue();
//}
//if (ItemInventoryRet.UnitOfMeasure1 != null)
//{
////Get value of ALU
//if (ItemInventoryRet.UnitOfMeasure1.ALU != null)
//{
//string ALU175 = (string)ItemInventoryRet.UnitOfMeasure1.ALU.GetValue();
//}
////Get value of MSRP
//if (ItemInventoryRet.UnitOfMeasure1.MSRP != null)
//{
//double MSRP176 = (double)ItemInventoryRet.UnitOfMeasure1.MSRP.GetValue();
//}
////Get value of NumberOfBaseUnits
//if (ItemInventoryRet.UnitOfMeasure1.NumberOfBaseUnits != null)
//{
//int NumberOfBaseUnits177 = (int)ItemInventoryRet.UnitOfMeasure1.NumberOfBaseUnits.GetValue();
//}
////Get value of Price1
//if (ItemInventoryRet.UnitOfMeasure1.Price1 != null)
//{
//double Price1178 = (double)ItemInventoryRet.UnitOfMeasure1.Price1.GetValue();
//}
////Get value of Price2
//if (ItemInventoryRet.UnitOfMeasure1.Price2 != null)
//{
//double Price2179 = (double)ItemInventoryRet.UnitOfMeasure1.Price2.GetValue();
//}
////Get value of Price3
//if (ItemInventoryRet.UnitOfMeasure1.Price3 != null)
//{
//double Price3180 = (double)ItemInventoryRet.UnitOfMeasure1.Price3.GetValue();
//}
////Get value of Price4
//if (ItemInventoryRet.UnitOfMeasure1.Price4 != null)
//{
//double Price4181 = (double)ItemInventoryRet.UnitOfMeasure1.Price4.GetValue();
//}
////Get value of Price5
//if (ItemInventoryRet.UnitOfMeasure1.Price5 != null)
//{
//double Price5182 = (double)ItemInventoryRet.UnitOfMeasure1.Price5.GetValue();
//}
////Get value of UnitOfMeasure
//if (ItemInventoryRet.UnitOfMeasure1.UnitOfMeasure != null)
//{
//string UnitOfMeasure183 = (string)ItemInventoryRet.UnitOfMeasure1.UnitOfMeasure.GetValue();
//}
////Get value of UPC
//if (ItemInventoryRet.UnitOfMeasure1.UPC != null)
//{
//string UPC184 = (string)ItemInventoryRet.UnitOfMeasure1.UPC.GetValue();
//}
//}
//if (ItemInventoryRet.UnitOfMeasure2 != null)
//{
////Get value of ALU
//if (ItemInventoryRet.UnitOfMeasure2.ALU != null)
//{
//string ALU185 = (string)ItemInventoryRet.UnitOfMeasure2.ALU.GetValue();
//}
////Get value of MSRP
//if (ItemInventoryRet.UnitOfMeasure2.MSRP != null)
//{
//double MSRP186 = (double)ItemInventoryRet.UnitOfMeasure2.MSRP.GetValue();
//}
////Get value of NumberOfBaseUnits
//if (ItemInventoryRet.UnitOfMeasure2.NumberOfBaseUnits != null)
//{
//int NumberOfBaseUnits187 = (int)ItemInventoryRet.UnitOfMeasure2.NumberOfBaseUnits.GetValue();
//}
////Get value of Price1
//if (ItemInventoryRet.UnitOfMeasure2.Price1 != null)
//{
//double Price1188 = (double)ItemInventoryRet.UnitOfMeasure2.Price1.GetValue();
//}
////Get value of Price2
//if (ItemInventoryRet.UnitOfMeasure2.Price2 != null)
//{
//double Price2189 = (double)ItemInventoryRet.UnitOfMeasure2.Price2.GetValue();
//}
////Get value of Price3
//if (ItemInventoryRet.UnitOfMeasure2.Price3 != null)
//{
//double Price3190 = (double)ItemInventoryRet.UnitOfMeasure2.Price3.GetValue();
//}
////Get value of Price4
//if (ItemInventoryRet.UnitOfMeasure2.Price4 != null)
//{
//double Price4191 = (double)ItemInventoryRet.UnitOfMeasure2.Price4.GetValue();
//}
////Get value of Price5
//if (ItemInventoryRet.UnitOfMeasure2.Price5 != null)
//{
//double Price5192 = (double)ItemInventoryRet.UnitOfMeasure2.Price5.GetValue();
//}
////Get value of UnitOfMeasure
//if (ItemInventoryRet.UnitOfMeasure2.UnitOfMeasure != null)
//{
//string UnitOfMeasure193 = (string)ItemInventoryRet.UnitOfMeasure2.UnitOfMeasure.GetValue();
//}
////Get value of UPC
//if (ItemInventoryRet.UnitOfMeasure2.UPC != null)
//{
//string UPC194 = (string)ItemInventoryRet.UnitOfMeasure2.UPC.GetValue();
//}
//}
//if (ItemInventoryRet.UnitOfMeasure3 != null)
//{
////Get value of ALU
//if (ItemInventoryRet.UnitOfMeasure3.ALU != null)
//{
//string ALU195 = (string)ItemInventoryRet.UnitOfMeasure3.ALU.GetValue();
//}
////Get value of MSRP
//if (ItemInventoryRet.UnitOfMeasure3.MSRP != null)
//{
//double MSRP196 = (double)ItemInventoryRet.UnitOfMeasure3.MSRP.GetValue();
//}
////Get value of NumberOfBaseUnits
//if (ItemInventoryRet.UnitOfMeasure3.NumberOfBaseUnits != null)
//{
//int NumberOfBaseUnits197 = (int)ItemInventoryRet.UnitOfMeasure3.NumberOfBaseUnits.GetValue();
//}
////Get value of Price1
//if (ItemInventoryRet.UnitOfMeasure3.Price1 != null)
//{
//double Price1198 = (double)ItemInventoryRet.UnitOfMeasure3.Price1.GetValue();
//}
////Get value of Price2
//if (ItemInventoryRet.UnitOfMeasure3.Price2 != null)
//{
//double Price2199 = (double)ItemInventoryRet.UnitOfMeasure3.Price2.GetValue();
//}
////Get value of Price3
//if (ItemInventoryRet.UnitOfMeasure3.Price3 != null)
//{
//double Price3200 = (double)ItemInventoryRet.UnitOfMeasure3.Price3.GetValue();
//}
////Get value of Price4
//if (ItemInventoryRet.UnitOfMeasure3.Price4 != null)
//{
//double Price4201 = (double)ItemInventoryRet.UnitOfMeasure3.Price4.GetValue();
//}
////Get value of Price5
//if (ItemInventoryRet.UnitOfMeasure3.Price5 != null)
//{
//double Price5202 = (double)ItemInventoryRet.UnitOfMeasure3.Price5.GetValue();
//}
////Get value of UnitOfMeasure
//if (ItemInventoryRet.UnitOfMeasure3.UnitOfMeasure != null)
//{
//string UnitOfMeasure203 = (string)ItemInventoryRet.UnitOfMeasure3.UnitOfMeasure.GetValue();
//}
////Get value of UPC
//if (ItemInventoryRet.UnitOfMeasure3.UPC != null)
//{
//string UPC204 = (string)ItemInventoryRet.UnitOfMeasure3.UPC.GetValue();
//}
//}
//if (ItemInventoryRet.VendorInfo2 != null)
//{
////Get value of ALU
//if (ItemInventoryRet.VendorInfo2.ALU != null)
//{
//string ALU205 = (string)ItemInventoryRet.VendorInfo2.ALU.GetValue();
//}
////Get value of OrderCost
//if (ItemInventoryRet.VendorInfo2.OrderCost != null)
//{
//double OrderCost206 = (double)ItemInventoryRet.VendorInfo2.OrderCost.GetValue();
//}
////Get value of UPC
//if (ItemInventoryRet.VendorInfo2.UPC != null)
//{
//string UPC207 = (string)ItemInventoryRet.VendorInfo2.UPC.GetValue();
//}
////Get value of VendorListID
//string VendorListID208 = (string)ItemInventoryRet.VendorInfo2.VendorListID.GetValue();
//}
//if (ItemInventoryRet.VendorInfo3 != null)
//{
////Get value of ALU
//if (ItemInventoryRet.VendorInfo3.ALU != null)
//{
//string ALU209 = (string)ItemInventoryRet.VendorInfo3.ALU.GetValue();
//}
////Get value of OrderCost
//if (ItemInventoryRet.VendorInfo3.OrderCost != null)
//{
//double OrderCost210 = (double)ItemInventoryRet.VendorInfo3.OrderCost.GetValue();
//}
////Get value of UPC
//if (ItemInventoryRet.VendorInfo3.UPC != null)
//{
//string UPC211 = (string)ItemInventoryRet.VendorInfo3.UPC.GetValue();
//}
////Get value of VendorListID
//string VendorListID212 = (string)ItemInventoryRet.VendorInfo3.VendorListID.GetValue();
//}
//if (ItemInventoryRet.VendorInfo4 != null)
//{
////Get value of ALU
//if (ItemInventoryRet.VendorInfo4.ALU != null)
//{
//string ALU213 = (string)ItemInventoryRet.VendorInfo4.ALU.GetValue();
//}
////Get value of OrderCost
//if (ItemInventoryRet.VendorInfo4.OrderCost != null)
//{
//double OrderCost214 = (double)ItemInventoryRet.VendorInfo4.OrderCost.GetValue();
//}
////Get value of UPC
//if (ItemInventoryRet.VendorInfo4.UPC != null)
//{
//string UPC215 = (string)ItemInventoryRet.VendorInfo4.UPC.GetValue();
//}
////Get value of VendorListID
//string VendorListID216 = (string)ItemInventoryRet.VendorInfo4.VendorListID.GetValue();
//}
//if (ItemInventoryRet.VendorInfo5 != null)
//{
////Get value of ALU
//if (ItemInventoryRet.VendorInfo5.ALU != null)
//{
//string ALU217 = (string)ItemInventoryRet.VendorInfo5.ALU.GetValue();
//}
////Get value of OrderCost
//if (ItemInventoryRet.VendorInfo5.OrderCost != null)
//{
//double OrderCost218 = (double)ItemInventoryRet.VendorInfo5.OrderCost.GetValue();
//}
////Get value of UPC
//if (ItemInventoryRet.VendorInfo5.UPC != null)
//{
//string UPC219 = (string)ItemInventoryRet.VendorInfo5.UPC.GetValue();
//}
////Get value of VendorListID
//string VendorListID220 = (string)ItemInventoryRet.VendorInfo5.VendorListID.GetValue();
//}
//if (ItemInventoryRet.DataExtRetList != null)
//{
//for (int i221 = 0; i221 < ItemInventoryRet.DataExtRetList.Count; i221++)
//{
//IDataExtRet DataExtRet = ItemInventoryRet.DataExtRetList.GetAt(i221);
////Get value of OwnerID
//string OwnerID222 = (string)DataExtRet.OwnerID.GetValue();
////Get value of DataExtName
//string DataExtName223 = (string)DataExtRet.DataExtName.GetValue();
////Get value of DataExtType
//ENDataExtType DataExtType224 = (ENDataExtType)DataExtRet.DataExtType.GetValue();
////Get value of DataExtValue
//string DataExtValue225 = (string)DataExtRet.DataExtValue.GetValue();
//}
//}
#endregion
itmList.Add(itm);
}
return(itmList);
}
public static void Main()
{
QBSessionManager sessionManager = new QBSessionManager();
try
{
IMsgSetRequest requestMsgSet = sessionManager.CreateMsgSetRequest("US", 13, 0);
sessionManager.OpenConnection("", "TEST");
sessionManager.BeginSession("", ENOpenMode.omDontCare);
requestMsgSet.Attributes.OnError = ENRqOnError.roeContinue;
IItemInventoryQuery ItemInventoryQueryRq = requestMsgSet.AppendItemInventoryQueryRq();
IMsgSetResponse responseMsgSet = sessionManager.DoRequests(requestMsgSet);
if (responseMsgSet == null)
{
return;
}
IResponseList responseList = responseMsgSet.ResponseList;
if (responseList == null)
{
return;
}
for (int i = 0; i < responseList.Count; i++)
{
IResponse response = responseList.GetAt(i);
if (response.StatusCode >= 0)
{
if (response.Detail != null)
{
ENResponseType responseType = (ENResponseType)response.Type.GetValue();
if (responseType == ENResponseType.rtItemInventoryQueryRs)
{
IItemInventoryRetList ItemInventoryRet = (IItemInventoryRetList)response.Detail;
for (int j = 0; j < ItemInventoryRet.Count; j++)
{
if (ItemInventoryRet.GetAt(j).UnitOfMeasureSetRef != null)
{
string itemListId = ItemInventoryRet.GetAt(j).ListID.GetValue();
string itemFullName = ItemInventoryRet.GetAt(j).FullName.GetValue();
short ItemType = ItemInventoryRet.GetAt(j).Type.GetValue();
string unitOfMeasurementRefListId = ItemInventoryRet.GetAt(j).UnitOfMeasureSetRef.ListID.GetValue();
string unitOfMeasurementRefFullName = ItemInventoryRet.GetAt(j).UnitOfMeasureSetRef.FullName.GetValue();
short unitOfMeasurementRefType = ItemInventoryRet.GetAt(j).UnitOfMeasureSetRef.Type.GetValue();
Console.WriteLine($"Item Id: {itemListId}\r\nItem Full Name: {itemFullName}\r\n{ItemType}\r\nUnit of Measurement List Id: {unitOfMeasurementRefListId}\r\nUnit of Measurement Full Name: {unitOfMeasurementRefFullName}\r\nUnit of Measurement Type: {unitOfMeasurementRefType}\r\n");
IMsgSetRequest uomRequestMsgSet = sessionManager.CreateMsgSetRequest("US", 13, 0);
IUnitOfMeasureSetQuery UnitOfMeasureSetQueryRq = uomRequestMsgSet.AppendUnitOfMeasureSetQueryRq();
UnitOfMeasureSetQueryRq.ORListQuery.ListIDList.Add(ItemInventoryRet.GetAt(j).UnitOfMeasureSetRef.ListID.GetValue());
IMsgSetResponse unitOfMeaurementResponseMsgSet = sessionManager.DoRequests(uomRequestMsgSet);
WalkUnitOfMeasureSetQueryRs(unitOfMeaurementResponseMsgSet);
}
}
}
}
}
}
sessionManager.EndSession();
sessionManager.CloseConnection();
Console.ReadLine();
}
catch (Exception e)
{
Console.WriteLine(e.Message, "Error");
sessionManager.EndSession();
sessionManager.CloseConnection();
Console.ReadLine();
}
}
