public ItemTypeCollection GetInventory()
{
ItemTypeCollection ret = new ItemTypeCollection();
GetMyeBaySellingCall oGetMyeBaySellingCall = new GetMyeBaySellingCall(context);
oGetMyeBaySellingCall.ActiveList = new ItemListCustomizationType();
try
{
oGetMyeBaySellingCall.Execute();
foreach (ItemType oItem in oGetMyeBaySellingCall.ActiveListReturn.ItemArray)
{
if (oItem.Variations?.Variation.Count > 0)
{
foreach (VariationType vr in oItem.Variations.Variation)
{
ItemType i = new ItemType();
i.ItemID = oItem.ItemID;
i.SKU = vr.SKU;
i.Quantity = vr.Quantity - vr.SellingStatus.QuantitySold;
i.BuyItNowPrice = vr.StartPrice;
ret.Add(i);
}
}
else
{
ItemType i = new ItemType();
i.ItemID = oItem.ItemID;
i.SKU = oItem.SKU;
i.Quantity = oItem.QuantityAvailable;
i.BuyItNowPrice = oItem.BuyItNowPrice;
ret.Add(i);
}
}
}
catch (ApiException oApiEx)
{
Console.WriteLine(oApiEx.Message);
}
catch (SdkException oSdkEx)
{
Console.WriteLine(oSdkEx.Message);
}
catch (Exception oEx)
{
Console.WriteLine(oEx.Message);
}
return(ret);
}
public static DataTable GetMySelling(string accoutName, string token, List <string> exceptSKUList)
{
DataTable sellingInventoryDt = CreateSellingInventoryDt();
ApiContext context = new ApiContext();
context.ApiCredential.eBayToken = token;
context.SoapApiServerUrl = "https://api.ebay.com/wsapi";
context.ApiLogManager = new ApiLogManager();
//context.ApiLogManager.ApiLoggerList.Add(new FileLogger("log.txt", false, false, true));
context.ApiLogManager.EnableLogging = true;
context.Version = "861";
context.Site = SiteCodeType.US;
GetMyeBaySellingCall getMyeBaySellingCall = new GetMyeBaySellingCall(context);
getMyeBaySellingCall.ActiveList = new ItemListCustomizationType();
getMyeBaySellingCall.ActiveList.Include = true;
int pageNumber = 1;
while (pageNumber < 100)
{
try
{
PaginationType pagination = new PaginationType();
pagination.EntriesPerPage = 200;
getMyeBaySellingCall.ActiveList.Pagination = pagination;
getMyeBaySellingCall.ActiveList.Sort = ItemSortTypeCodeType.QuantityAvailable;
pagination.PageNumber = pageNumber;
getMyeBaySellingCall.Execute();
int totalPageNumber = getMyeBaySellingCall.ActiveListReturn.PaginationResult.TotalNumberOfPages;
if (pageNumber > totalPageNumber)
{
break;
}
else
{
if (getMyeBaySellingCall.ApiResponse.Ack != AckCodeType.Failure)
{
foreach (ItemType itemType in getMyeBaySellingCall.ActiveListReturn.ItemArray)
{
try
{
string productId = itemType.ItemID;
string productSku = itemType.SKU;
if (productId == "252081524116")
{
Console.WriteLine("");
}
DataRow visionSkuDr = Db.Db.GetVisionSkuInfo(productSku);
if (visionSkuDr != null)
{
int visionQty = ConvertUtility.ToInt(visionSkuDr["qty"]);
if (visionQty <= 2)
{
visionQty = 0;
}
else
{
visionQty = ConvertUtility.ToInt(ConfigurationManager.AppSettings["qtyValue"]);
}
if (itemType.QuantityAvailable != visionQty)
{
DataRow sellingInventoryDr = sellingInventoryDt.NewRow();
sellingInventoryDr["ItemID"] = productId;
sellingInventoryDr["SKU"] = itemType.SKU;
sellingInventoryDr["Name"] = itemType.Title;
sellingInventoryDr["Qty"] = visionQty;
sellingInventoryDr["StartPrice"] = itemType.BuyItNowPrice.Value;
sellingInventoryDr["SoldQty"] = itemType.Quantity - itemType.QuantityAvailable;
sellingInventoryDr["QuantityAvailable"] = itemType.QuantityAvailable;
sellingInventoryDr["IsVariation"] = 0;
sellingInventoryDt.Rows.Add(sellingInventoryDr);
}
else
{
continue;
}
}
else
{
string productName = itemType.Title;
if (exceptSKUList.Contains(productSku))
{
continue;
}
else if (itemType.Variations == null || itemType.Variations.Variation.Count == 0)
{
int quantityAvailable = itemType.QuantityAvailable;
int quantity = itemType.Quantity;
int soldQty = quantity - quantityAvailable;
if (itemType.BuyItNowPrice == null)
{
continue;
}
else
{
double startPrice = itemType.BuyItNowPrice.Value;
if (quantityAvailable <= 2 && quantityAvailable >= 1)
{
DataRow sellingInventoryDr = sellingInventoryDt.NewRow();
sellingInventoryDr["ItemID"] = productId;
sellingInventoryDr["SKU"] = itemType.SKU;
sellingInventoryDr["Name"] = productName;
//sellingInventoryDr["Qty"] = quantity;
sellingInventoryDr["Qty"] = ConvertUtility.ToInt(ConfigurationManager.AppSettings["qtyValue"]);
sellingInventoryDr["StartPrice"] = startPrice;
sellingInventoryDr["SoldQty"] = soldQty;
sellingInventoryDr["QuantityAvailable"] = quantityAvailable;
sellingInventoryDr["IsVariation"] = 0;
sellingInventoryDt.Rows.Add(sellingInventoryDr);
}
else
{
continue;
}
}
}
else
{
foreach (VariationType simpleType in itemType.Variations.Variation)
{
productSku = simpleType.SKU;
int quantity = simpleType.Quantity - simpleType.SellingStatus.QuantitySold;
double startPrice = simpleType.StartPrice.Value;
if (quantity > 0 && quantity > 3)
{
DataRow sellingInventoryDr = sellingInventoryDt.NewRow();
sellingInventoryDr["ItemID"] = productId;
sellingInventoryDr["SKU"] = productSku;
sellingInventoryDr["Name"] = productName;
//sellingInventoryDr["Qty"] = simpleType.Quantity;
sellingInventoryDr["Qty"] = ConvertUtility.ToInt(ConfigurationManager.AppSettings["qtyValue"]);
sellingInventoryDr["StartPrice"] = startPrice;
sellingInventoryDr["SoldQty"] = -1;
sellingInventoryDr["QuantityAvailable"] = -1;
sellingInventoryDr["IsVariation"] = 1;
sellingInventoryDt.Rows.Add(sellingInventoryDr);
}
else
{
continue;
}
}
}
}
}
catch (Exception ex)
{
ExceptionUtility exceptionUtility = new ExceptionUtility();
exceptionUtility.CatchMethod(ex, "GetMyEbaySelling foreach", accoutName + " " + ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum);
continue;
}
}
}
}
pageNumber = pageNumber + 1;
}
catch (Exception ex)
{
ExceptionUtility exceptionUtility = new ExceptionUtility();
exceptionUtility.CatchMethod(ex, "GetMyEbaySelling", accoutName + " " + ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum);
}
}
return(sellingInventoryDt);
}