public static void FinalUpdateVisionQty() { try { string sql = @" update aa set aa.qty = convert(int, convert(varchar(max),(select case when aa.Reference1 like 'USE%' then isnull((select case when Reference1 like '' then cast(0 as nvarchar) else Reference1 end as reference1 from SKUMap where VendorSKU= cast(replace(cast(aa.Reference1 as nvarchar(max)), 'USE ', '') as nvarchar )),cast(0 as nvarchar)) when aa.Reference1 like '' then cast(0 as nvarchar) else aa.Reference1 end as test )) ) from SKUMap aa"; SqlHelper.ExecuteNonQuery(sql, ConfigurationManager.AppSettings["pebbledon"]); } catch (Exception ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, "FinalUpdateVisionQty", ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); throw ExceptionUtility.GetCustomizeException(ex); } }
public static void AddEbayOrderToDb(EbayOrderType ebayOrderType) { try { List <string> sqlList = new List <string>(); string headerSql = BuildEbayHeaderSql(ebayOrderType.Header); string eoptSql = ""; string eolSql = ""; sqlList.Add(headerSql); foreach (EbayOrderPaymentTransactionType eoptType in ebayOrderType.paymentTransaction) { eoptSql = BuildEbayPaymentTransactionSql(eoptType); sqlList.Add(eoptSql); } foreach (EbayOrderLineType eolType in ebayOrderType.Line) { eolSql = BuildEbayLineSql(eolType); sqlList.Add(eolSql); } SqlHelper.ExecuteNonQuery(sqlList, ConfigurationManager.AppSettings["marketplace"]); } catch (Exception ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, ebayOrderType.Header.SellerUserID + ": AddEbayOrderToDb ", ebayOrderType.Header.OrderID + ": " + ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); throw ExceptionUtility.GetCustomizeException(ex); } }
public static void SaveSingleShipmentInfo(string orderNum, string accountName, string channel, string trackingNum, string carrier) { string sqlUpdate = @"update OrderHeader set TrackingNum='" + trackingNum + "', ShippedDate ='" + System.DateTime.Now + "', ShippingCarrier='" + carrier + "' where OrderNum ='" + orderNum + "' and Channel='" + channel + "'"; try { SqlHelper.ExecuteNonQuery(sqlUpdate, ConfigurationManager.AppSettings["pebbledon"]); } catch (Exception ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, orderNum + ": SaveShipmentInfo ", orderNum + ": " + ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); throw ExceptionUtility.GetCustomizeException(ex); } /*List<string> sqlList = new List<string>(); * string sqlInsert = @"insert into ShipmentInfo * (TrackingNum, AccountName, OrderNum, Channel, Cost, Reference1,LabelCommand) * values ('" + trackingNum + "','" +accountName + "','" + orderNum + "','" + channel + "','" + 0 + "','" + carrier + "','" + "" + "')"; * string sqlUpdate = "update OrderHeader set TrackingNum='" + trackingNum + "' ShippedDate ='" + System.DateTime.Now + "' where OrderNum ='" + orderNum + "' and Channel='" + channel + "'"; * try * { * sqlList.Add(sqlInsert); * sqlList.Add(sqlUpdate); * SqlHelper.ExecuteNonQuery(sqlList, ConfigurationManager.AppSettings["pebbledon"]); * } * catch(Exception ex) * { * ExceptionUtility exceptionUtility = new ExceptionUtility(); * exceptionUtility.CatchMethod(ex, orderNum + ": SaveShipmentInfo ", orderNum + ": " + ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); * throw ExceptionUtility.GetCustomizeException(ex); * }*/ }
public static void UpdateEbayInventory() { DataTable sellerAccountDt = Db.Db.GetEbayDeveloperInfo(); foreach (DataRow sellerAccountDr in sellerAccountDt.Rows) { string accountName = sellerAccountDr["AccountName"].ToString(); try { string token = sellerAccountDr["Token"].ToString(); List <string> exceptList = ConfigurationManager.AppSettings["exceptList"].Split(',').ToList(); List <string> exceptSKUList = ConfigurationManager.AppSettings["exceptSKUList"].Split(',').ToList(); if (exceptList.Contains(accountName)) { continue; } else { DataTable adjustInventoryDt = EbayService.GetMyEbaySelling.GetMySelling(accountName, token, exceptSKUList); foreach (DataRow adjustInventoryDr in adjustInventoryDt.Rows) { string itemId = adjustInventoryDr["ItemID"].ToString(); string sku = adjustInventoryDr["SKU"].ToString(); string name = adjustInventoryDr["Name"].ToString(); try { int qty = ConvertUtility.ToInt(adjustInventoryDr["qty"]); double startPrice = ConvertUtility.ToDouble(adjustInventoryDr["startPrice"]); int soldQty = ConvertUtility.ToInt(adjustInventoryDr["soldQty"]); int quantityAvailable = ConvertUtility.ToInt(adjustInventoryDr["quantityAvailable"]); int isVariation = ConvertUtility.ToInt(adjustInventoryDr["isVariation"]); EbayService.UpdateInventoryByReviseFixedPriceItem.UpdateInventory(accountName, token, itemId, qty, sku, isVariation, soldQty, startPrice); } catch (Exception ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, "UpdateInventoryByReviseFixedPriceItem ", accountName + ":" + itemId + "(" + sku + ")" + " " + ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); continue; } } } } catch (Exception ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, "Filter Account ", accountName + " " + ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); continue; } } }
public static void UpdateVisionReferenceInventory(string visionSku, string visionInventory, string visionNjInventory, string visionTxInventory) { try { string sql = "update SKUMap set Reference1 ='" + visionInventory + "',Reference2 ='" + visionNjInventory + "', Reference3 ='" + visionTxInventory + "' where VendorSKU = '" + visionSku + "'"; SqlHelper.ExecuteNonQuery(sql, ConfigurationManager.AppSettings["pebbledon"]); } catch (Exception ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, "UpdateVisionReferenceInventory", ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); throw ExceptionUtility.GetCustomizeException(ex); } }
public static void SaveCustomizedWeight(string customizedInfo, int customizedWeight) { try { string sql = "insert into CustomizedWeight (ProductInfo, CustomizedWeight) values ('" + customizedInfo + "','" + customizedWeight + "')"; SqlHelper.ExecuteNonQuery(sql, ConfigurationManager.AppSettings["pebbledon"]); } catch (Exception ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, customizedInfo + ": SaveCustomizedWeight ", customizedWeight + ": " + ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); throw ExceptionUtility.GetCustomizeException(ex); } }
public static void UpdateShipmentInfoDt(string orderNum, string accountName, DateTime uploadDate) { string sql = "update OrderHeader set Reference2='" + uploadDate + "' where OrderNum='" + orderNum + "' and AccountName='" + accountName + "'"; try { SqlHelper.ExecuteNonQuery(sql, ConfigurationManager.AppSettings["pebbledon"]); } catch (Exception ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, accountName + ": UpdateShipmentInfoDt ", orderNum + ": " + ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); throw ExceptionUtility.GetCustomizeException(ex); } }
public static void AddAmazonOrderTran(string accountName, AmazonOrderType amazonOrder) { List <string> sqlList = BuildAddAmazonOrderTranSql(amazonOrder); try { SqlHelper.ExecuteNonQuery(sqlList, ConfigurationManager.AppSettings["marketplace"]); } catch (Exception ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, accountName + ": AddAmazonOrderTran ", amazonOrder.Header.order_id + ": " + ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); throw ExceptionUtility.GetCustomizeException(ex); } }
public static void SaveNoteToDb(string orderNum, string channel, string note) { note = note.Replace("'", "''"); string updateSql = "update OrderHeader set Note='" + note + "' where Channel='" + channel + "' and OrderNum='" + orderNum + "'"; try { SqlHelper.ExecuteNonQuery(updateSql, ConfigurationManager.AppSettings["pebbledon"]); } catch (Exception ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, orderNum + ": SaveNoteToDb ", orderNum + ": " + ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); throw ExceptionUtility.GetCustomizeException(ex); } }
public static void UpdateInventory(string accountName, string token, string itemId, int qty, string sku, int isVariation, int soldQty, double startPrice) { 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, false)); context.ApiLogManager.EnableLogging = true; context.Version = "861"; context.Site = SiteCodeType.US; ReviseFixedPriceItemCall reviseFixedPriceItemCall = new ReviseFixedPriceItemCall(context); ItemType item = new ItemType(); try { if (isVariation == 0) { item.ItemID = itemId; item.QuantityAvailable = qty; item.Quantity = qty; //item.StartPrice.Value = startPrice; reviseFixedPriceItemCall.Item = item; reviseFixedPriceItemCall.Execute(); } else { item.ItemID = itemId; VariationType simpleType = new VariationType(); VariationTypeCollection vtc = new VariationTypeCollection(); VariationsType vsType = new VariationsType(); simpleType.SKU = sku; simpleType.Quantity = qty; vtc.Add(simpleType); vsType.Variation = vtc; item.Variations = vsType; reviseFixedPriceItemCall.Item = item; reviseFixedPriceItemCall.Execute(); } } catch (Exception ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, "UpdateInventoryByReviseFixedPriceItem ", accountName + ":" + itemId + "(" + sku + ")" + " " + ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); } }
public static void UploadSingleTrackingNum(string trackingNum, string orderNum, string carrier, string accountName, string token) { string senderEmail = ConfigurationManager.AppSettings["senderEmail"]; string messageFromPassword = ConfigurationManager.AppSettings["messageFromPassword"]; string messageToEmail = ConfigurationManager.AppSettings["messageToEmail"]; string smtpClient = ConfigurationManager.AppSettings["smtpClient"]; int smtpPortNum = ConvertUtility.ToInt(ConfigurationManager.AppSettings["smtpPortNum"]); 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; CompleteSaleCall completeSaleCall = new CompleteSaleCall(context); completeSaleCall.OrderID = orderNum; completeSaleCall.Shipped = true; completeSaleCall.Shipment = new ShipmentType(); completeSaleCall.Shipment.ShipmentTrackingDetails = new ShipmentTrackingDetailsTypeCollection(); ShipmentTrackingDetailsType shpmnt = new ShipmentTrackingDetailsType(); shpmnt.ShipmentTrackingNumber = trackingNum; shpmnt.ShippingCarrierUsed = carrier; completeSaleCall.Shipment.ShipmentTrackingDetails.Add(shpmnt); try { completeSaleCall.Execute(); try { Db.Db.UpdateShipmentInfoDt(orderNum, accountName, System.DateTime.Now); } catch (Exception ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, accountName + ": completeSaleCall " + orderNum, ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); } } catch (Exception ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, accountName + ": completeSaleCall " + orderNum, ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); } }
public static DataSet LoadAmazonTrackingUploadResultXml() { DataSet amazonResultDs = new DataSet(); try { amazonResultDs.ReadXml(ConfigurationManager.AppSettings["AmazonTrackingResult"], XmlReadMode.InferSchema); } catch (Exception ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, "LoadAmazonTrackingUploadResultXml: ", ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); return(null); } return(amazonResultDs); }
public static void CancelOrder(string orderNum, string accountName, string channel) { string sqlUpdate = @"update OrderHeader set TrackingNum='CANCELLED ORDER', Reference2 = 'CANCELLED ORDER', ShippedDate ='2000-01-01 00:00:00.000' where OrderNum ='" + orderNum + "' and Channel='" + channel + "'"; try { SqlHelper.ExecuteNonQuery(sqlUpdate, ConfigurationManager.AppSettings["pebbledon"]); } catch (Exception ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, orderNum + ": CancelOrder ", orderNum + ": " + ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); throw ExceptionUtility.GetCustomizeException(ex); } }
static void Main(string[] args) { string senderEmail = ConfigurationManager.AppSettings["senderEmail"]; string messageFromPassword = ConfigurationManager.AppSettings["messageFromPassword"]; string messageToEmail = ConfigurationManager.AppSettings["messageToEmail"]; string smtpClient = ConfigurationManager.AppSettings["smtpClient"]; int smtpPortNum = ConvertUtility.ToInt(ConfigurationManager.AppSettings["smtpPortNum"]); try { EbayInventoryMdl.Mdl.UpdateEbayInventory(); } catch (Exception ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, "UpdateEbayInventoryCon Main ", ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); } }
static void Main(string[] args) { string senderEmail = ConfigurationManager.AppSettings["senderEmail"]; string messageFromPassword = ConfigurationManager.AppSettings["messageFromPassword"]; string messageToEmail = ConfigurationManager.AppSettings["messageToEmail"]; string smtpClient = ConfigurationManager.AppSettings["smtpClient"]; int smtpPortNum = ConvertUtility.ToInt(ConfigurationManager.AppSettings["smtpPortNum"]); try { AmazonMarketplaceMdl.Mdl.CreateAmazonUploadTrackingXml(); } catch (Exception ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, "UploadAmazonTracking Main ", ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); } }
public static void BuildUpdateTrackingTableTran(string orderId, string note, string accountName) { //string sql = "update ShipmentInfo set UploadNote = '" + note + "', IsUpload ='" + status + "', UploadTime='" + (DateTime)SqlDateTime.MinValue + "' where Channel='Amazon' and OrderID ='" + orderId + "'"; string sql = "update OrderHeader set Reference2='" + System.DateTime.Now + "' where OrderNum='" + orderId + "' and AccountName='" + accountName + "'"; List <string> sqlList = new List <string>(); try { sqlList.Add(sql); SqlHelper.ExecuteNonQuery(sqlList, ConfigurationManager.AppSettings["pebbledon"]); } catch (Exception ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, orderId + ": BuildUpdateTrackingTableTran: ", orderId + ": " + ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); throw ExceptionUtility.GetCustomizeException(ex); } }
public static DataTable LoadAmazonInventoryReport(string accountName) { FileStream fs = new FileStream(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location) + "\\" + accountName + "_AmazonInventoryReport.xml", FileMode.Open, FileAccess.Read); StreamReader sr = new StreamReader(fs); string[] line; string content; DataTable amazonOnboardInventoryDt = new DataTable(); int lineCount = 1; try { while ((content = sr.ReadLine()) != null) { if (lineCount == 1) { line = content.Split('\t'); amazonOnboardInventoryDt.Columns.Add(line[0], typeof(System.String)); //sku amazonOnboardInventoryDt.Columns.Add(line[1], typeof(System.String)); //asin amazonOnboardInventoryDt.Columns.Add(line[2], typeof(System.Decimal)); //price amazonOnboardInventoryDt.Columns.Add(line[3], typeof(System.Int32)); //qty lineCount++; } else { line = content.Split('\t'); DataRow amazonOnboardInventoryDr = amazonOnboardInventoryDt.NewRow(); amazonOnboardInventoryDr["sku"] = line[0].ToString(); amazonOnboardInventoryDr["asin"] = line[1].ToString(); amazonOnboardInventoryDr["price"] = ConvertUtility.ToDecimal(line[2]); amazonOnboardInventoryDr["quantity"] = ConvertUtility.ToInt(line[3]); amazonOnboardInventoryDt.Rows.Add(amazonOnboardInventoryDr); } } } catch (Exception ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, "LoadAmazonInventoryReport Error ", accountName + ": " + ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); throw ExceptionUtility.GetCustomizeException(ex); } return(amazonOnboardInventoryDt); }
public static DataRow GetVisionSkuInfo(string sku) { try { string sql = @"select * from pebbledon.dbo.SKUMap where iteza0923 = '" + sku + "' or motovehicleparts = '" + sku + "' or framegeneration = '" + sku + "' or kalegend = '" + sku + "' or beautyequation = '" + sku + "' or kadepot = '" + sku + "'"; try { return(SqlHelper.GetDataRow(sql, ConfigurationManager.AppSettings["marketplace"])); } catch (Exception ex) { throw new Exception(ex.Message); } } catch (Exception ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, "GetVisionSkuInfo: ", sku + ": " + ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); throw ExceptionUtility.GetCustomizeException(ex); } }
public static void DeleteUncompletedEbayOrder(string orderId) { string sqlLine = "delete from EbayOrderLine where OrderID ='" + orderId + "'"; string sqlHeader = "delete from EbayOrderHeader where OrderID = '" + orderId + "'"; string sqlPaymentTransaction = "delete from EbayPaymentTransaction where OrderID = '" + orderId + "'"; List <string> sqlList = new List <string>(); try { sqlList.Add(sqlLine); sqlList.Add(sqlHeader); sqlList.Add(sqlPaymentTransaction); SqlHelper.ExecuteNonQuery(sqlList, ConfigurationManager.AppSettings["marketplace"]); } catch (Exception ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, orderId + ": DeleteUncompletedEbayOrder: ", orderId + ": " + ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); throw ExceptionUtility.GetCustomizeException(ex); } }
public static void SaveShipmentInfo(string orderNum, string accountName, string channel, string trackingNum, string reference, string reference2, decimal cost, string nativeCommand) { try { List <string> sqlList = new List <string>(); string sqlInsert = @"insert into ShipmentInfo (TrackingNum, AccountName, OrderNum, Channel, Cost, Reference1,Reference2, LabelCommand) values ('" + trackingNum + "','" + accountName + "','" + orderNum + "','" + channel + "','" + cost + "','" + reference + "','" + reference2 + "','" + nativeCommand + "')"; string sqlUpdate = "update OrderHeader set TrackingNum='" + trackingNum + "', ShippedDate ='" + System.DateTime.Now + "' where OrderNum ='" + orderNum + "' and Channel='" + channel + "'"; sqlList.Add(sqlInsert); sqlList.Add(sqlUpdate); SqlHelper.ExecuteNonQuery(sqlList, ConfigurationManager.AppSettings["pebbledon"]); } catch (Exception ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, orderNum + ": SaveShipmentInfo ", orderNum + ": " + ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); throw ExceptionUtility.GetCustomizeException(ex); } }
public static void InsertNewVisionItem(int maxItemId, string vendorSKU, string visionQty, string visionNjQty, string visionTxQty) { try { string sql = @"insert into SKUMap (VendorSKU, ItemID, iteza0923, motovehicleparts, framegeneration, kalegend, beautyequation,kadepot, Reference1, Reference2, Reference3) values ('" + vendorSKU + "','" + maxItemId + "','VIE" + maxItemId + "','VME" + maxItemId + "','VFE" + maxItemId + "','VKA" + maxItemId + "','VBA" + maxItemId + "','VKAA" + maxItemId + "','" + visionQty + "','" + visionNjQty + "','" + visionTxQty + "')"; SqlHelper.ExecuteNonQuery(sql, ConfigurationManager.AppSettings["pebbledon"]); } catch (Exception ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, "InsertNewVisionItem", ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); throw ExceptionUtility.GetCustomizeException(ex); } }
public static string SubmitAmazonTrackingFeed(string filepath, string merchantId, string marketplaceId, string accessKeyId, string secretAccessKey) { string feedSubmissionId = ""; SubmitFeedRequest request = new SubmitFeedRequest(); request.Merchant = merchantId; request.MarketplaceIdList = new IdList(); request.MarketplaceIdList.Id = new List <string>(new string[] { marketplaceId }); request.FeedContent = File.Open(filepath, FileMode.Open, FileAccess.Read); request.ContentMD5 = MarketplaceWebServiceClient.CalculateContentMD5(request.FeedContent); request.FeedContent.Position = 0; request.FeedType = "_POST_ORDER_FULFILLMENT_DATA_"; const string applicationName = "<Your Application Name>"; const string applicationVersion = "<Your Application Version>"; MarketplaceWebServiceConfig config = new MarketplaceWebServiceConfig(); config.ServiceURL = "https://mws.amazonservices.com"; config.SetUserAgentHeader( applicationName, applicationVersion, "C#", "<Parameter 1>", "<Parameter 2>"); MarketplaceWebService.MarketplaceWebService service = new MarketplaceWebServiceClient(accessKeyId, secretAccessKey, config); try { SubmitFeedResponse response = service.SubmitFeed(request); Console.WriteLine("Service Response"); Console.WriteLine("============================================================================="); Console.WriteLine(); Console.WriteLine(" SubmitFeedResponse"); if (response.IsSetSubmitFeedResult()) { Console.WriteLine(" SubmitFeedResult"); SubmitFeedResult submitFeedResult = response.SubmitFeedResult; if (submitFeedResult.IsSetFeedSubmissionInfo()) { Console.WriteLine(" FeedSubmissionInfo"); FeedSubmissionInfo feedSubmissionInfo = submitFeedResult.FeedSubmissionInfo; if (feedSubmissionInfo.IsSetFeedSubmissionId()) { Console.WriteLine(" FeedSubmissionId"); Console.WriteLine(" {0}", feedSubmissionInfo.FeedSubmissionId); feedSubmissionId = feedSubmissionInfo.FeedSubmissionId; } if (feedSubmissionInfo.IsSetFeedType()) { Console.WriteLine(" FeedType"); Console.WriteLine(" {0}", feedSubmissionInfo.FeedType); } if (feedSubmissionInfo.IsSetSubmittedDate()) { Console.WriteLine(" SubmittedDate"); Console.WriteLine(" {0}", feedSubmissionInfo.SubmittedDate); } if (feedSubmissionInfo.IsSetFeedProcessingStatus()) { Console.WriteLine(" FeedProcessingStatus"); Console.WriteLine(" {0}", feedSubmissionInfo.FeedProcessingStatus); } if (feedSubmissionInfo.IsSetStartedProcessingDate()) { Console.WriteLine(" StartedProcessingDate"); Console.WriteLine(" {0}", feedSubmissionInfo.StartedProcessingDate); } if (feedSubmissionInfo.IsSetCompletedProcessingDate()) { Console.WriteLine(" CompletedProcessingDate"); Console.WriteLine(" {0}", feedSubmissionInfo.CompletedProcessingDate); } } } if (response.IsSetResponseMetadata()) { Console.WriteLine(" ResponseMetadata"); ResponseMetadata responseMetadata = response.ResponseMetadata; if (responseMetadata.IsSetRequestId()) { Console.WriteLine(" RequestId"); Console.WriteLine(" {0}", responseMetadata.RequestId); } } Console.WriteLine(" ResponseHeaderMetadata"); Console.WriteLine(" RequestId"); Console.WriteLine(" " + response.ResponseHeaderMetadata.RequestId); Console.WriteLine(" ResponseContext"); Console.WriteLine(" " + response.ResponseHeaderMetadata.ResponseContext); Console.WriteLine(" Timestamp"); Console.WriteLine(" " + response.ResponseHeaderMetadata.Timestamp); } catch (MarketplaceWebServiceException ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, "SubmitAmazonTrackingFeed Error:", ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); Console.WriteLine("Caught Exception: " + ex.Message); Console.WriteLine("Response Status Code: " + ex.StatusCode); Console.WriteLine("Error Code: " + ex.ErrorCode); Console.WriteLine("Error Type: " + ex.ErrorType); Console.WriteLine("Request ID: " + ex.RequestId); Console.WriteLine("XML: " + ex.XML); Console.WriteLine("ResponseHeaderMetadata: " + ex.ResponseHeaderMetadata); } return(feedSubmissionId); }
public static void GetAmazonReport(string accountName, string merchantId, string marketplaceId, string accessKeyId, string secretAccessKey, string reportGenerateId) { string senderEmail = ConfigurationManager.AppSettings["senderEmail"]; string messageFromPassword = ConfigurationManager.AppSettings["messageFromPassword"]; string messageToEmail = ConfigurationManager.AppSettings["messageToEmail"]; string smtpClient = ConfigurationManager.AppSettings["smtpClient"]; int smtpPortNum = ConvertUtility.ToInt(ConfigurationManager.AppSettings["smtpPortNum"]); GetReportRequest request = new GetReportRequest(); request.Merchant = merchantId; request.ReportId = reportGenerateId; //request.Report = File.Open(ConfigurationManager.AppSettings["filePath"], FileMode.OpenOrCreate, FileAccess.ReadWrite); request.Report = new FileStream(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location) + "\\" + accountName + "_AmazonInventoryReport.xml", FileMode.Truncate, FileAccess.ReadWrite); const string applicationName = "<Your Application Name>"; const string applicationVersion = "<Your Application Version>"; MarketplaceWebServiceConfig config = new MarketplaceWebServiceConfig(); config.ServiceURL = "https://mws.amazonservices.com"; config.SetUserAgentHeader( applicationName, applicationVersion, "C#", "<Parameter 1>", "<Parameter 2>"); MarketplaceWebService.MarketplaceWebService service = new MarketplaceWebServiceClient(accessKeyId, secretAccessKey, config); try { GetReportResponse response = service.GetReport(request); Console.WriteLine("Service Response"); Console.WriteLine("============================================================================="); Console.WriteLine(); Console.WriteLine(" GetReportResponse"); if (response.IsSetGetReportResult()) { Console.WriteLine(" GetReportResult"); GetReportResult getReportResult = response.GetReportResult; if (getReportResult.IsSetContentMD5()) { Console.WriteLine(" ContentMD5"); Console.WriteLine(" {0}", getReportResult.ContentMD5); } } if (response.IsSetResponseMetadata()) { Console.WriteLine(" ResponseMetadata"); ResponseMetadata responseMetadata = response.ResponseMetadata; if (responseMetadata.IsSetRequestId()) { Console.WriteLine(" RequestId"); Console.WriteLine(" {0}", responseMetadata.RequestId); } } Console.WriteLine(" ResponseHeaderMetadata"); Console.WriteLine(" RequestId"); Console.WriteLine(" " + response.ResponseHeaderMetadata.RequestId); Console.WriteLine(" ResponseContext"); Console.WriteLine(" " + response.ResponseHeaderMetadata.ResponseContext); Console.WriteLine(" Timestamp"); Console.WriteLine(" " + response.ResponseHeaderMetadata.Timestamp); } catch (MarketplaceWebServiceException ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, "GetAmazonReport ", accountName + " " + ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); } request.Report.Close(); request.Report.Dispose(); }
public static DataTable GetAmazonReportRequestList(string accountName, string merchantId, string marketplaceId, string accessKeyId, string secretAccessKey) { string senderEmail = ConfigurationManager.AppSettings["senderEmail"]; string messageFromPassword = ConfigurationManager.AppSettings["messageFromPassword"]; string messageToEmail = ConfigurationManager.AppSettings["messageToEmail"]; string smtpClient = ConfigurationManager.AppSettings["smtpClient"]; int smtpPortNum = ConvertUtility.ToInt(ConfigurationManager.AppSettings["smtpPortNum"]); DataTable GeneratedReportDt = new DataTable(); GeneratedReportDt.Columns.Add("ReportRequestId", typeof(System.String)); GeneratedReportDt.Columns.Add("ReportGenerateId", typeof(System.String)); GeneratedReportDt.Columns.Add("Status", typeof(System.String)); GetReportRequestListRequest request = new GetReportRequestListRequest(); request.Merchant = merchantId; const string applicationName = "<Your Application Name>"; const string applicationVersion = "<Your Application Version>"; MarketplaceWebServiceConfig config = new MarketplaceWebServiceConfig(); config.ServiceURL = "https://mws.amazonservices.com"; config.SetUserAgentHeader( applicationName, applicationVersion, "C#", "<Parameter 1>", "<Parameter 2>"); request.MaxCount = 3; MarketplaceWebService.MarketplaceWebService service = new MarketplaceWebServiceClient(accessKeyId, secretAccessKey, config); try { GetReportRequestListResponse response = service.GetReportRequestList(request); Console.WriteLine("Service Response"); Console.WriteLine("============================================================================="); Console.WriteLine(); Console.WriteLine(" GetReportRequestListResponse"); if (response.IsSetGetReportRequestListResult()) { Console.WriteLine(" GetReportRequestListResult"); GetReportRequestListResult getReportRequestListResult = response.GetReportRequestListResult; List <ReportRequestInfo> reportRequestInfoList = getReportRequestListResult.ReportRequestInfo; foreach (ReportRequestInfo reportRequestInfo in reportRequestInfoList) { DataRow GeneratedReportDr = GeneratedReportDt.NewRow(); Console.WriteLine(" ReportRequestInfo"); if (reportRequestInfo.IsSetReportProcessingStatus()) { Console.WriteLine(" ReportProcessingStatus"); Console.WriteLine(" {0}", reportRequestInfo.ReportProcessingStatus); GeneratedReportDr["Status"] = reportRequestInfo.ReportProcessingStatus; } if (reportRequestInfo.IsSetReportRequestId()) { Console.WriteLine(" ReportRequestId"); Console.WriteLine(" {0}", reportRequestInfo.ReportRequestId); GeneratedReportDr["ReportRequestId"] = reportRequestInfo.ReportRequestId; } if (reportRequestInfo.IsSetGeneratedReportId()) { Console.WriteLine(" GeneratedReportId"); Console.WriteLine(" {0}", reportRequestInfo.GeneratedReportId); GeneratedReportDr["ReportGenerateId"] = reportRequestInfo.GeneratedReportId; } if (reportRequestInfo.IsSetReportType()) { Console.WriteLine(" ReportType"); Console.WriteLine(" {0}", reportRequestInfo.ReportType); } if (reportRequestInfo.IsSetStartDate()) { Console.WriteLine(" StartDate"); Console.WriteLine(" {0}", reportRequestInfo.StartDate); } if (reportRequestInfo.IsSetEndDate()) { Console.WriteLine(" EndDate"); Console.WriteLine(" {0}", reportRequestInfo.EndDate); } if (reportRequestInfo.IsSetSubmittedDate()) { Console.WriteLine(" SubmittedDate"); Console.WriteLine(" {0}", reportRequestInfo.SubmittedDate); } GeneratedReportDt.Rows.Add(GeneratedReportDr); } } if (response.IsSetResponseMetadata()) { Console.WriteLine(" ResponseMetadata"); ResponseMetadata responseMetadata = response.ResponseMetadata; if (responseMetadata.IsSetRequestId()) { Console.WriteLine(" RequestId"); Console.WriteLine(" {0}", responseMetadata.RequestId); } } Console.WriteLine(" ResponseHeaderMetadata"); Console.WriteLine(" RequestId"); Console.WriteLine(" " + response.ResponseHeaderMetadata.RequestId); Console.WriteLine(" ResponseContext"); Console.WriteLine(" " + response.ResponseHeaderMetadata.ResponseContext); Console.WriteLine(" Timestamp"); Console.WriteLine(" " + response.ResponseHeaderMetadata.Timestamp); } catch (MarketplaceWebServiceException ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, "GetAmazonReportRequestList ", accountName + " " + ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); } return(GeneratedReportDt); }
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); }
public static string RequestAmazonInventoryReport(string accountName, string merchantId, string marketplaceId, string accessKeyId, string secretAccessKey) { string senderEmail = ConfigurationManager.AppSettings["senderEmail"]; string messageFromPassword = ConfigurationManager.AppSettings["messageFromPassword"]; string messageToEmail = ConfigurationManager.AppSettings["messageToEmail"]; string smtpClient = ConfigurationManager.AppSettings["smtpClient"]; int smtpPortNum = ConvertUtility.ToInt(ConfigurationManager.AppSettings["smtpPortNum"]); string ReportRequestId = ""; RequestReportRequest request = new RequestReportRequest(); request.Merchant = merchantId; request.MarketplaceIdList = new IdList(); request.MarketplaceIdList.Id = new List <string>(new string[] { marketplaceId }); request.ReportType = "_GET_FLAT_FILE_OPEN_LISTINGS_DATA_"; const string applicationName = "<Your Application Name>"; const string applicationVersion = "<Your Application Version>"; MarketplaceWebServiceConfig config = new MarketplaceWebServiceConfig(); config.ServiceURL = "https://mws.amazonservices.com"; config.SetUserAgentHeader( applicationName, applicationVersion, "C#", "<Parameter 1>", "<Parameter 2>"); MarketplaceWebService.MarketplaceWebService service = new MarketplaceWebServiceClient(accessKeyId, secretAccessKey, config); try { RequestReportResponse response = service.RequestReport(request); Console.WriteLine("Service Response"); Console.WriteLine("============================================================================="); Console.WriteLine(); Console.WriteLine(" RequestReportResponse"); if (response.IsSetRequestReportResult()) { Console.WriteLine(" RequestReportResult"); RequestReportResult requestReportResult = response.RequestReportResult; ReportRequestInfo reportRequestInfo = requestReportResult.ReportRequestInfo; Console.WriteLine(" ReportRequestInfo"); if (reportRequestInfo.IsSetReportProcessingStatus()) { Console.WriteLine(" ReportProcessingStatus"); Console.WriteLine(" {0}", reportRequestInfo.ReportProcessingStatus); } if (reportRequestInfo.IsSetReportRequestId()) { Console.WriteLine(" ReportRequestId"); Console.WriteLine(" {0}", reportRequestInfo.ReportRequestId); ReportRequestId = reportRequestInfo.ReportRequestId; } if (reportRequestInfo.IsSetReportType()) { Console.WriteLine(" ReportType"); Console.WriteLine(" {0}", reportRequestInfo.ReportType); } if (reportRequestInfo.IsSetStartDate()) { Console.WriteLine(" StartDate"); Console.WriteLine(" {0}", reportRequestInfo.StartDate); } if (reportRequestInfo.IsSetEndDate()) { Console.WriteLine(" EndDate"); Console.WriteLine(" {0}", reportRequestInfo.EndDate); } if (reportRequestInfo.IsSetSubmittedDate()) { Console.WriteLine(" SubmittedDate"); Console.WriteLine(" {0}", reportRequestInfo.SubmittedDate); } } if (response.IsSetResponseMetadata()) { Console.WriteLine(" ResponseMetadata"); ResponseMetadata responseMetadata = response.ResponseMetadata; if (responseMetadata.IsSetRequestId()) { Console.WriteLine(" RequestId"); Console.WriteLine(" {0}", responseMetadata.RequestId); } } Console.WriteLine(" ResponseHeaderMetadata"); Console.WriteLine(" RequestId"); Console.WriteLine(" " + response.ResponseHeaderMetadata.RequestId); Console.WriteLine(" ResponseContext"); Console.WriteLine(" " + response.ResponseHeaderMetadata.ResponseContext); Console.WriteLine(" Timestamp"); Console.WriteLine(" " + response.ResponseHeaderMetadata.Timestamp); } catch (MarketplaceWebServiceException ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, "RequestAmazonInventoryReport ", accountName + " " + ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); } return(ReportRequestId); }
public static List<EbayOrderType> GetOrderFromEbay(string token,string accountNum) { string senderEmail = ConfigurationManager.AppSettings["senderEmail"]; string messageFromPassword= ConfigurationManager.AppSettings["messageFromPassword"]; string messageToEmail = ConfigurationManager.AppSettings["messageToEmail"]; string smtpClient = ConfigurationManager.AppSettings["smtpClient"]; int smtpPortNum = ConvertUtility.ToInt(ConfigurationManager.AppSettings["smtpPortNum"]); List<EbayOrderType> OrderList = new List<EbayOrderType>(); ApiContext context = new ApiContext(); context.ApiCredential.eBayToken = token; context.SoapApiServerUrl = "https://api.ebay.com/wsapi"; context.Site = SiteCodeType.US; DateTime createTimeFrom, createTimeTo; GetOrdersCall GetOrderCall = new GetOrdersCall(context); GetOrderCall.DetailLevelList = new DetailLevelCodeTypeCollection(); GetOrderCall.DetailLevelList.Add(DetailLevelCodeType.ReturnAll); createTimeFrom = DateTime.Now.AddDays(-15).ToUniversalTime(); createTimeTo = DateTime.Now.ToUniversalTime(); int pageNumber = 1; int errorCount = 0; GetOrderCall.CreateTimeFrom = createTimeFrom; GetOrderCall.CreateTimeTo = createTimeTo; GetOrderCall.OrderStatus = OrderStatusCodeType.Completed; while (pageNumber<100) { try { PaginationType pagination = new PaginationType(); pagination.EntriesPerPage = 100; GetOrderCall.Pagination = pagination; pagination.PageNumber = pageNumber; GetOrderCall.Execute(); int totalPageNumber = GetOrderCall.PaginationResult.TotalNumberOfPages; if (pageNumber > totalPageNumber) { break; } else { if (GetOrderCall.ApiResponse.Ack != AckCodeType.Failure) { if (GetOrderCall.ApiResponse.OrderArray.Count != 0) { foreach (OrderType orderType in GetOrderCall.ApiResponse.OrderArray) { try { EbayOrderType ebayOrderType = new EbayOrderType(); string orderId = orderType.OrderID; DataRow checkDuplidatedDr = Db.Db.CheckDuplicatedOrderID(orderId); if (checkDuplidatedDr!=null) { if(checkDuplidatedDr["OrderStatus"].ToString() == "Completed") { continue; // continue if order already exist } else { Db.Db.DeleteUncompletedEbayOrder(orderId); } } else { EbayOrderHeaderType ebayOrderHeaderType = AddOrderHeader(orderType);//add header info foreach (ExternalTransactionType externalTransactionType in orderType.ExternalTransaction)//add external trasnaction info { EbayOrderPaymentTransactionType ebayOrderPaymentTransactionType = AddOrderPaymentTransaction(orderId, externalTransactionType); ebayOrderType.paymentTransaction.Add(ebayOrderPaymentTransactionType); } ebayOrderType.Header = ebayOrderHeaderType; int lineId = 0; foreach (TransactionType transactionType in orderType.TransactionArray)//add line info { lineId = lineId + 1; EbayOrderLineType ebayOrderLineType = AddOrderLine(orderId, transactionType, lineId); ebayOrderType.Line.Add(ebayOrderLineType); } OrderList.Add(ebayOrderType); } } catch(Exception ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, accountNum + ": GetOrderCall--foreach ", ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); continue; //continue next single order if current order error } } } else { continue; // continue next account if no order } } else { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.ErrorWarningMethod("AckCodeType Failure: " + accountNum, "AckCodeType Failure: " + accountNum, senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); continue; // continue next account if ack error } } pageNumber = pageNumber + 1; } catch (Exception ex) { if (errorCount > 4) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex,accountNum+ ": While ",ex.Message.ToString(),senderEmail,messageFromPassword,messageToEmail,smtpClient,smtpPortNum); break; } else { errorCount = errorCount + 1; continue; // continue try if error less 4 times } } } return OrderList; }
public static void GetAmazonTrackingFeedSubmissionResult(string feedSubmissionId, string merchantId, string marketplaceId, string accessKeyId, string secretAccessKey) { GetFeedSubmissionResultRequest request = new GetFeedSubmissionResultRequest(); request.Merchant = merchantId; request.FeedSubmissionId = feedSubmissionId; //request.FeedSubmissionResult = File.Open("feedSubmissionResult.xml", FileMode.OpenOrCreate, FileAccess.ReadWrite); request.FeedSubmissionResult = new FileStream(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location) + "\\AmazonTrackingResult.xml", FileMode.Truncate, FileAccess.ReadWrite); const string applicationName = "<Your Application Name>"; const string applicationVersion = "<Your Application Version>"; MarketplaceWebServiceConfig config = new MarketplaceWebServiceConfig(); config.ServiceURL = "https://mws.amazonservices.com"; config.SetUserAgentHeader( applicationName, applicationVersion, "C#", "<Parameter 1>", "<Parameter 2>"); MarketplaceWebService.MarketplaceWebService service = new MarketplaceWebServiceClient(accessKeyId, secretAccessKey, config); string requestId = ""; try { GetFeedSubmissionResultResponse response = service.GetFeedSubmissionResult(request); Console.WriteLine("Service Response"); Console.WriteLine("============================================================================="); Console.WriteLine(); Console.WriteLine(" GetFeedSubmissionResultResponse"); if (response.IsSetGetFeedSubmissionResultResult()) { Console.WriteLine(" GetFeedSubmissionResult"); GetFeedSubmissionResultResult getFeedSubmissionResultResult = response.GetFeedSubmissionResultResult; if (getFeedSubmissionResultResult.IsSetContentMD5()) { Console.WriteLine(" ContentMD5"); Console.WriteLine(" {0}", getFeedSubmissionResultResult.ContentMD5); } } if (response.IsSetResponseMetadata()) { Console.WriteLine(" ResponseMetadata"); ResponseMetadata responseMetadata = response.ResponseMetadata; if (responseMetadata.IsSetRequestId()) { Console.WriteLine(" RequestId"); Console.WriteLine(" {0}", responseMetadata.RequestId); } } Console.WriteLine(" ResponseHeaderMetadata"); Console.WriteLine(" RequestId"); Console.WriteLine(" " + response.ResponseHeaderMetadata.RequestId); Console.WriteLine(" ResponseContext"); Console.WriteLine(" " + response.ResponseHeaderMetadata.ResponseContext); Console.WriteLine(" Timestamp"); Console.WriteLine(" " + response.ResponseHeaderMetadata.Timestamp); } catch (MarketplaceWebServiceException ex) { ExceptionUtility exceptionUtility = new ExceptionUtility(); exceptionUtility.CatchMethod(ex, "AmazonTrackingResult->GetAmazonTrackingResult: ", feedSubmissionId + ": " + ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum); Console.WriteLine("Caught Exception: " + ex.Message); Console.WriteLine("Response Status Code: " + ex.StatusCode); Console.WriteLine("Error Code: " + ex.ErrorCode); Console.WriteLine("Error Type: " + ex.ErrorType); Console.WriteLine("Request ID: " + ex.RequestId); Console.WriteLine("XML: " + ex.XML); Console.WriteLine("ResponseHeaderMetadata: " + ex.ResponseHeaderMetadata); } request.FeedSubmissionResult.Close(); request.FeedSubmissionResult.Dispose(); }