public void loadDataFromFTP() { string[] fileList = null; MySQLWrapper s; try { fileList = getFileList(); if (fileList != null) { s = new MySQLWrapper(); foreach (String fileName in fileList) { downloadFile(fileName); deleteFile(fileName); s.loadDataFromFile(fileName); } s.destroy(); changeStatus("Done!"); addLogStatus("Done!"); } else { addLogStatus("No valid files found at FTP!"); } } catch (Exception ex) { addLogStatus("ERROR : " + ex.Message); } }
public void relistItems() { MySQLWrapper s = null; try { changeStatus("Initializing..."); addLogStatus("Initializing..."); if (!initialize()) throw new Exception("ERROR : Unable to connect to eBay Service"); s = new MySQLWrapper(); GetMyeBaySellingCall eBaySelling = new GetMyeBaySellingCall(context); PaginatedItemArrayType pArr = new PaginatedItemArrayType(); eBaySelling.UnsoldList = new ItemListCustomizationType(); eBaySelling.UnsoldList.Include = true; eBaySelling.GetMyeBaySelling(); ItemTypeCollection unsoldItems = new ItemTypeCollection(); pArr = eBaySelling.UnsoldListReturn; if (pArr != null) { string sku = ""; unsoldItems = pArr.ItemArray; RelistItemCall relistItem = new RelistItemCall(context); StringCollection deleteFieldList = new StringCollection(); ItemType tItem = new ItemType(); changeStatus("ReListing..."); addLogStatus("Total Unsold items : " + unsoldItems.Count); for (int i = 0; i < unsoldItems.Count; i++) { tItem.ItemID = unsoldItems[i].ItemID; sku = s.getSKU(unsoldItems[i].ItemID); if(sku != ""){ relistItem.RelistItem(tItem); s.updateReListedItem(sku, relistItem.ItemID); s.addToLogs(sku, "Re-Listed with Item Id : " + relistItem.ItemID); addLogStatus("Item : " + unsoldItems[i].ItemID + " relisted with Item ID : " + relistItem.ItemID); } else{ throw new Exception("ItemId : " + unsoldItems[i].ItemID + " not found in database!"); } } addLogStatus("Done!"); } else { addLogStatus("No Unsold Items!"); } } catch (Exception ex) { addLogStatus("ERROR : " + ex.Message); } finally { s.destroy(); destroy(); } }
private void btnTestMySQLConnection_Click(object sender, EventArgs e) { MySQLWrapper.testConnection(txtHost.Text, txtUsername.Text, txtPassword.Text, txtDatabase.Text); }
public void relistItems() { MySQLWrapper s = null; try { changeStatus("Initializing..."); addLogStatus("Initializing..."); if (!initialize()) { throw new Exception("ERROR : Unable to connect to eBay Service"); } s = new MySQLWrapper(); GetMyeBaySellingCall eBaySelling = new GetMyeBaySellingCall(context); PaginatedItemArrayType pArr = new PaginatedItemArrayType(); eBaySelling.UnsoldList = new ItemListCustomizationType(); eBaySelling.UnsoldList.Include = true; eBaySelling.GetMyeBaySelling(); ItemTypeCollection unsoldItems = new ItemTypeCollection(); pArr = eBaySelling.UnsoldListReturn; if (pArr != null) { string sku = ""; unsoldItems = pArr.ItemArray; RelistItemCall relistItem = new RelistItemCall(context); StringCollection deleteFieldList = new StringCollection(); ItemType tItem = new ItemType(); changeStatus("ReListing..."); addLogStatus("Total Unsold items : " + unsoldItems.Count); for (int i = 0; i < unsoldItems.Count; i++) { tItem.ItemID = unsoldItems[i].ItemID; sku = s.getSKU(unsoldItems[i].ItemID); if (sku != "") { relistItem.RelistItem(tItem); s.updateReListedItem(sku, relistItem.ItemID); s.addToLogs(sku, "Re-Listed with Item Id : " + relistItem.ItemID); addLogStatus("Item : " + unsoldItems[i].ItemID + " relisted with Item ID : " + relistItem.ItemID); } else { throw new Exception("ItemId : " + unsoldItems[i].ItemID + " not found in database!"); } } addLogStatus("Done!"); } else { addLogStatus("No Unsold Items!"); } } catch (Exception ex) { addLogStatus("ERROR : " + ex.Message); } finally { s.destroy(); destroy(); } }
public void startListing() { int itemCount = 0; string eBayItems = "0"; MySQLWrapper s = null; try { s = new MySQLWrapper(); eBayItems = s.getItemCount(); if (eBayItems == "0") { throw new Exception("No items found in database"); } reportTotalItems(eBayItems); changeStatus("Initializing..."); addLogStatus("Initializing..."); if (!initialize()) { throw new Exception("ERROR : Unable to connect to eBay Service"); } MySQLWrapper.eBayData ebayData = new MySQLWrapper.eBayData(); MySQLWrapper.eBayItem item; string listedItemId = "-1"; string generatedItemId = "-1"; while (ebayData.hasNext() && eBayLister.Program.mainForm.listingContinue) { listedItemId = "-1"; generatedItemId = "-1"; itemCount++; reportProgress(itemCount.ToString()); item = ebayData.getItem(); listedItemId = s.checkIfListed(item.SKU); if (listedItemId != "-1") { if (item.Quantity == 0) { addLogStatus("Removing item " + item.SKU); removeItem(listedItemId, item.SKU); s.deleteTempItem(item.SKU); s.deleteListedItem(item.SKU); s.addToLogs(item.SKU, "Deleted"); } else { addLogStatus("Modifying item " + item.SKU); modifyItem(listedItemId, item.SKU, item.Quantity); s.deleteTempItem(item.SKU); s.addToLogs(item.SKU, "Quantity changed to " + item.Quantity); } } else { addLogStatus("Listing item " + item.SKU); generatedItemId = addItem(item); if (generatedItemId != "-1") { s.deleteTempItem(item.SKU); s.addListedItem(item.SKU, generatedItemId); s.addToLogs(item.SKU, "Listed with Item Id : " + generatedItemId); } } } if (eBayLister.Program.mainForm.listingContinue) { addLogStatus("Done!"); } } catch (Exception ex) { addLogStatus("ERROR : " + ex.Message); } finally{ s.destroy(); destroy(); } }
private bool verifyAddItem(MySQLWrapper.eBayItem ebayItem) { bool itemListing = false; TextReader tr = new StreamReader("template.txt"); StringBuilder htmlDescription = new StringBuilder(); htmlDescription.Insert(0,tr.ReadToEnd()); tr.Close(); htmlDescription.Replace("{0}", ebayItem.Title); htmlDescription.Replace("{1}", ebayItem.Author); htmlDescription.Replace("{2}", ebayItem.Publisher); htmlDescription.Replace("{3}", ebayItem.publishDate); htmlDescription.Replace("{4}", ebayItem.Binding); htmlDescription.Replace("{5}", ebayItem.ISBN); if (ebayItem.UPC != "") htmlDescription.Replace("{6}", "<b>UPC : </b>" + ebayItem.UPC + "</br>"); else htmlDescription.Replace("{6}", ""); htmlDescription.Replace("{7}", ebayItem.Weight.ToString()); htmlDescription.Replace("{8}", ebayItem.Notes); htmlDescription.Replace("{9}", ebayItem.Description); ItemType item = new ItemType(); item.SKU = ebayItem.SKU; item.Title = ebayItem.Title; item.Description = htmlDescription.ToString(); item.Currency = CurrencyCodeType.INR; item.Country = CountryCodeType.IN; item.ListingType = ListingTypeCodeType.FixedPriceItem; item.Quantity = ebayItem.Quantity; item.Location = eBayLister.UserSettings.Default.itemCityState; item.ListingDuration = getListingDuration(); item.PrimaryCategory = new CategoryType(); if (eBayLister.UserSettings.Default.ListInCategory.Equals("Other Books")) { item.PrimaryCategory.CategoryID = "268"; } else { item.PrimaryCategory.CategoryID = "37558"; } item.StartPrice = new AmountType(); item.StartPrice.currencyID = CurrencyCodeType.INR; item.StartPrice.Value = ebayItem.Price * Convert.ToDouble(eBayLister.UserSettings.Default.ConversionRate); item.PaymentMethods = new BuyerPaymentMethodCodeTypeCollection(); item.PaymentMethods.Add(BuyerPaymentMethodCodeType.PaisaPayAccepted); item.ShippingDetails = this.getShippingDetails(); item.ReturnPolicy = this.getReturnPolicy(); string handlingTime = eBayLister.UserSettings.Default.handlingTime; handlingTime = handlingTime.Remove(handlingTime.IndexOf(' ')); item.DispatchTimeMax = Convert.ToInt32(handlingTime); AttributeType conditionAttribute = new AttributeType(); conditionAttribute.attributeLabel = "Condition"; ValTypeCollection valueCollection = new ValTypeCollection(); ValType valueType = new ValType(); if(ebayItem.bookCondition.Contains("Used")) valueType.ValueLiteral = "Used"; else valueType.ValueLiteral = "New"; valueCollection.Add(valueType); conditionAttribute.Value = valueCollection; item.AttributeArray = new AttributeTypeCollection(); item.AttributeArray.Add(conditionAttribute); VerifyAddItemCall apiCall = new VerifyAddItemCall(context); try { FeeTypeCollection fees = apiCall.VerifyAddItem(item); foreach (FeeType fee in fees) { if (fee.Name == "ListingFee") addLogStatus("Success! Listing Fee : " + Convert.ToString(fee.Fee.Value)); } itemListing = true; } catch (ApiException ex) { itemListing = false; MessageBox.Show(ex.Message); Console.WriteLine(ex.Message); } return itemListing; }
private string addItem(MySQLWrapper.eBayItem ebayItem) { string listedItemId = "-1"; StringBuilder htmlDescription = new StringBuilder(); TextReader tr = new StreamReader("template.txt"); htmlDescription.Insert(0, tr.ReadToEnd()); tr.Close(); htmlDescription.Replace("{0}", ebayItem.Title); htmlDescription.Replace("{1}", ebayItem.Author); htmlDescription.Replace("{2}", ebayItem.Publisher); htmlDescription.Replace("{3}", ebayItem.publishDate); htmlDescription.Replace("{4}", ebayItem.Binding); htmlDescription.Replace("{5}", ebayItem.ISBN); if (ebayItem.UPC != "") htmlDescription.Replace("{6}", "<b>UPC : </b>" + ebayItem.UPC + "</br>"); else htmlDescription.Replace("{6}", ""); htmlDescription.Replace("{7}", ebayItem.Weight.ToString()); htmlDescription.Replace("{8}", ebayItem.Notes); htmlDescription.Replace("{9}", ebayItem.Description); ItemType item = new ItemType(); item.InventoryTrackingMethod = InventoryTrackingMethodCodeType.SKU; item.SKU = ebayItem.SKU; // Title max length 55 chars if (ebayItem.Title.Length > 55) item.Title = ebayItem.Title.Substring(0, 54); else item.Title = ebayItem.Title; if (ebayItem.Image != "") { item.PictureDetails = new PictureDetailsType(); item.PictureDetails.PictureURL.Add(ebayItem.Image); } item.Description = htmlDescription.ToString(); item.Currency = CurrencyCodeType.INR; item.ListingType = ListingTypeCodeType.FixedPriceItem; item.Quantity = ebayItem.Quantity; item.PostalCode = eBayLister.UserSettings.Default.itemPincode; item.Location = eBayLister.UserSettings.Default.itemCityState; item.Country = (CountryCodeType)Enum.Parse(typeof(CountryCodeType), eBayLister.UserSettings.Default.itemCountry, true); item.ListingDuration = getListingDuration(); item.PrimaryCategory = new CategoryType(); if (eBayLister.UserSettings.Default.ListInCategory.Equals("Other Books")) { item.PrimaryCategory.CategoryID = "268"; } else { item.PrimaryCategory.CategoryID = "37558"; } item.StartPrice = new AmountType(); item.StartPrice.currencyID = CurrencyCodeType.INR; item.StartPrice.Value = ebayItem.Price * Convert.ToDouble(eBayLister.UserSettings.Default.ConversionRate); item.PaymentMethods = new BuyerPaymentMethodCodeTypeCollection(); item.PaymentMethods.Add(BuyerPaymentMethodCodeType.PaisaPayAccepted); item.ShippingDetails = this.getShippingDetails(); item.ReturnPolicy = this.getReturnPolicy(); string handlingTime = eBayLister.UserSettings.Default.handlingTime; handlingTime = handlingTime.Remove(handlingTime.IndexOf(' ')); item.DispatchTimeMax = Convert.ToInt32(handlingTime); AttributeType conditionAttribute = new AttributeType(); conditionAttribute.attributeLabel = "Condition"; ValTypeCollection valueCollection = new ValTypeCollection(); ValType valueType = new ValType(); if (ebayItem.bookCondition.Contains("Used")) valueType.ValueLiteral = "Used"; else valueType.ValueLiteral = "New"; valueCollection.Add(valueType); conditionAttribute.Value = valueCollection; item.AttributeArray = new AttributeTypeCollection(); item.AttributeArray.Add(conditionAttribute); AddItemCall apiCall = new AddItemCall(context); FeeTypeCollection fees = apiCall.AddItem(item); foreach (FeeType fee in fees) { if (fee.Name == "ListingFee") addLogStatus("Success! Listing Fee : " + Convert.ToString(fee.Fee.Value)); } listedItemId = apiCall.ItemID; return listedItemId; }
public void startListing() { int itemCount = 0; string eBayItems = "0"; MySQLWrapper s = null; try { s = new MySQLWrapper(); eBayItems = s.getItemCount(); if (eBayItems == "0") throw new Exception("No items found in database"); reportTotalItems(eBayItems); changeStatus("Initializing..."); addLogStatus("Initializing..."); if (!initialize()) throw new Exception("ERROR : Unable to connect to eBay Service"); MySQLWrapper.eBayData ebayData = new MySQLWrapper.eBayData(); MySQLWrapper.eBayItem item; string listedItemId = "-1"; string generatedItemId = "-1"; while (ebayData.hasNext() && eBayLister.Program.mainForm.listingContinue) { listedItemId = "-1"; generatedItemId = "-1"; itemCount++; reportProgress(itemCount.ToString()); item = ebayData.getItem(); listedItemId = s.checkIfListed(item.SKU); if (listedItemId != "-1") { if (item.Quantity == 0) { addLogStatus("Removing item " + item.SKU); removeItem(listedItemId, item.SKU); s.deleteTempItem(item.SKU); s.deleteListedItem(item.SKU); s.addToLogs(item.SKU, "Deleted"); } else { addLogStatus("Modifying item " + item.SKU); modifyItem(listedItemId, item.SKU, item.Quantity); s.deleteTempItem(item.SKU); s.addToLogs(item.SKU, "Quantity changed to " + item.Quantity); } } else { addLogStatus("Listing item " + item.SKU); generatedItemId = addItem(item); if (generatedItemId != "-1") { s.deleteTempItem(item.SKU); s.addListedItem(item.SKU, generatedItemId); s.addToLogs(item.SKU, "Listed with Item Id : " + generatedItemId); } } } if(eBayLister.Program.mainForm.listingContinue) addLogStatus("Done!"); } catch (Exception ex) { addLogStatus("ERROR : " + ex.Message); } finally{ s.destroy(); destroy(); } }