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();
}
