private void GetActiveListing(MWSUserProfile profile)
{
List <DataTable> TableList = null;
ReportRequestHandler getReportHandler = new ReportRequestHandler(profile);
string sReportType = "_GET_MERCHANT_LISTINGS_DATA_";
string sPeriod = "_15_MINUTES_";
getReportHandler.ScheduleReportRequest(sReportType, sPeriod);
string sMechantID = profile.SSellerId;
DateTime startedDate = new DateTime(DateTime.UtcNow.Year, DateTime.UtcNow.Month, DateTime.UtcNow.Day, DateTime.UtcNow.Hour, 0, 0);
DateTime endDate = new DateTime(DateTime.UtcNow.Year, DateTime.UtcNow.Month, DateTime.UtcNow.Day, DateTime.UtcNow.Hour, 59, 59);
try
{
TableList = getReportHandler.GetScheduledReport(sReportType, startedDate, endDate);
foreach (DataTable InventoryTable in TableList)
{
if (InventoryTable != null & InventoryTable.Rows.Count > 0)
{
}
}
}
catch (Exception ex)
{
DebugLogHandler.DebugLogHandler.WriteLog(sLogPath, sClass, "GetActiveListing() exception message:" + ex.Message);
}
}
private void GetUpdatedInventoryData(MWSUserProfile profile)
{
List <DataTable> InventoryTableList = null;
ReportRequestHandler getReportHandler = new ReportRequestHandler(profile);
string sReportType = "_GET_FBA_MYI_ALL_INVENTORY_DATA_";
string sPeriod = "_15_MINUTES_";
getReportHandler.ScheduleReportRequest(sReportType, sPeriod);
string sMechantID = profile.SSellerId;
DateTime startedDate = new DateTime(DateTime.UtcNow.Year, DateTime.UtcNow.Month, DateTime.UtcNow.Day, DateTime.UtcNow.Hour, 0, 0);
DateTime endDate = new DateTime(DateTime.UtcNow.Year, DateTime.UtcNow.Month, DateTime.UtcNow.Day, DateTime.UtcNow.Hour, 59, 59);
try
{
InventoryTableList = getReportHandler.GetScheduledReport(sReportType, startedDate, endDate);
foreach (DataTable InventoryTable in InventoryTableList)
{
if (InventoryTable != null & InventoryTable.Rows.Count > 0)
{
SqlDataHandler fillDataHandler = new SqlDataHandler(_ConnectionString);
DataSet ds = new DataSet();
DataTable ProductAvailabilityTable = new DataTable();
ProductAvailabilityTable.Columns.Add("FNSKU", typeof(String));
ProductAvailabilityTable.Columns.Add("SellerSKU", typeof(String));
ProductAvailabilityTable.Columns.Add("ASIN", typeof(String));
ProductAvailabilityTable.Columns.Add("ProductName", typeof(String));
ProductAvailabilityTable.Columns.Add("Inbound", typeof(Int32));
ProductAvailabilityTable.Columns.Add("Fulfillable", typeof(Int32));
ProductAvailabilityTable.Columns.Add("Unfulfillable", typeof(Int32));
ProductAvailabilityTable.Columns.Add("Reserved", typeof(Int32));
ProductAvailabilityTable.Columns.Add("MerchantID", typeof(String));
foreach (DataRow row in InventoryTable.Rows)
{
DataRow ProductRow = ProductAvailabilityTable.NewRow();
ProductRow["FNSKU"] = row[1];
ProductRow["SellerSKU"] = row[0];
ProductRow["ASIN"] = row[2];
ProductRow["ProductName"] = row[3];
ProductRow["Inbound"] = Int32.Parse(row[16].ToString());
ProductRow["Fulfillable"] = Int32.Parse(row[10].ToString());
ProductRow["Unfulfillable"] = Int32.Parse(row[11].ToString());
ProductRow["Reserved"] = Int32.Parse(row[12].ToString());
ProductRow["MerchantID"] = sMechantID;
ProductAvailabilityTable.Rows.Add(ProductRow);
}
if (ProductAvailabilityTable.Rows.Count > 0)
{
ds.Tables.Add(ProductAvailabilityTable);
fillDataHandler.UpdateProductAvailabilityData("ProductAvailability", ds, profile.SSellerId);
}
fillDataHandler = null;
ProductAvailabilityTable = null;
ds = null;
}
}
}
catch (Exception ex)
{
DebugLogHandler.DebugLogHandler.WriteLog(sLogPath, sClass, "GetUpdatedInventoryData() exception message:" + ex.Message);
}
}
private List <string> GetTransactionData(MWSUserProfile profile)
{
string sReportType = "_GET_ALT_FLAT_FILE_PAYMENT_SETTLEMENT_DATA_";
string sMechantID = profile.SSellerId;
List <DataTable> srcTableList = null;
List <string> settlement_idList = new List <string>();
ReportRequestHandler getReportHandler = new ReportRequestHandler(profile);
DateTime reportEndDate = SETTLEMENT_PAYMENT_DATA_ENDDATE;
DateTime reportStartDate = SETTLEMENT_PAYMENT_DATA_ENDDATE.AddDays(-89);
try
{
srcTableList = getReportHandler.GetScheduledReport(sReportType, reportStartDate, reportEndDate);
SqlDataHandler fillDataHandler = new SqlDataHandler(_ConnectionString);
if (srcTableList.Count > 0)
{
DateTime defaultDateTime = new DateTime(1900, 1, 1);
foreach (DataTable srcTable in srcTableList)
{
if (null != srcTable && srcTable.Rows.Count > 0)
{
DataTable tableWithMerchantID = new DataTable();
foreach (DataColumn col in srcTable.Columns)
{
if (col.ColumnName.Contains("date"))
{
tableWithMerchantID.Columns.Add(col.ColumnName, typeof(DateTime));
}
else if (col.ColumnName == "total_amount" || col.ColumnName == "amount")
{
tableWithMerchantID.Columns.Add(col.ColumnName, typeof(float));
}
else if (col.ColumnName == "quantity_purchased")
{
tableWithMerchantID.Columns.Add(col.ColumnName, typeof(Int32));
}
else
{
tableWithMerchantID.Columns.Add(col.ColumnName, typeof(String));
}
}
tableWithMerchantID.Columns.Add("MerchantID", typeof(String));
tableWithMerchantID.Columns.Add("last_update_date", typeof(DateTime));
string sOrderID = "";
DateTime dtSettlementStartDate = defaultDateTime;
DateTime dtSettlementEndDate = defaultDateTime;
DateTime dtDepositDate = defaultDateTime;
DateTime dtPostedDate = defaultDateTime;
DateTime dtPostedDate_time = defaultDateTime;
foreach (DataRow row in srcTable.Rows)
{
DataRow rowSettlemnetData = tableWithMerchantID.NewRow();
sOrderID = row["order_id"].ToString();
rowSettlemnetData = tableWithMerchantID.NewRow();
foreach (DataColumn col in tableWithMerchantID.Columns)
{
if (col.ColumnName == "settlement_id")
{
if (!settlement_idList.Contains(row["settlement_id"].ToString()))
{
settlement_idList.Add(row["settlement_id"].ToString());
}
rowSettlemnetData[col.ColumnName] = row["settlement_id"].ToString();
}
else if (col.ColumnName == "posted_date_time")
{
if (!string.IsNullOrEmpty(row[col.ColumnName].ToString()))
{
string temp = row[col.ColumnName].ToString();
//2014-11-30 07:01:39
dtPostedDate_time = PSTTimeString2UTCDateTime(temp);
}
rowSettlemnetData[col.ColumnName] = dtPostedDate_time;
}
else
if (col.ColumnName == "settlement_start_date")
{
if (!string.IsNullOrEmpty(row[col.ColumnName].ToString()))
{
string temp = row[col.ColumnName].ToString();
//2014-11-30 07:01:39
dtSettlementStartDate = PSTTimeString2UTCDateTime(temp);
}
rowSettlemnetData[col.ColumnName] = dtSettlementStartDate;
}
else
if (col.ColumnName == "settlement_end_date")
{
if (!string.IsNullOrEmpty(row[col.ColumnName].ToString()))
{
string temp = row[col.ColumnName].ToString();
dtSettlementEndDate = PSTTimeString2UTCDateTime(temp);
}
rowSettlemnetData[col.ColumnName] = dtSettlementEndDate;
}
else
if (col.ColumnName == "deposit_date")
{
if (!string.IsNullOrEmpty(row[col.ColumnName].ToString()))
{
string temp = row[col.ColumnName].ToString();
dtDepositDate = PSTTimeString2UTCDateTime(temp);
}
rowSettlemnetData[col.ColumnName] = dtDepositDate;
}
else
if (col.ColumnName == "MerchantID")
{
rowSettlemnetData[col.ColumnName] = sMechantID;
}
else
if (col.ColumnName == "last_update_date")
{
rowSettlemnetData[col.ColumnName] = DateTime.UtcNow;
}
else
if (col.ColumnName == "posted_date")
{
if (!string.IsNullOrEmpty(row[col.ColumnName].ToString()))
{
string temp = row[col.ColumnName].ToString();
//2014-11-30 07:01:39
dtPostedDate = PSTTimeString2UTCDateTime(temp);
}
rowSettlemnetData[col.ColumnName] = dtPostedDate;
}
else
if (col.ColumnName == "total_amount" || col.ColumnName == "amount" || col.ColumnName == "quantity_purchased")
{
string temp = row[col.ColumnName].ToString();
if (string.IsNullOrEmpty(temp))
{
rowSettlemnetData[col.ColumnName] = 0;
}
else
{
rowSettlemnetData[col.ColumnName] = row[col.ColumnName];
}
}
else
{
rowSettlemnetData[col.ColumnName] = row[col.ColumnName];
}
}
tableWithMerchantID.Rows.Add(rowSettlemnetData);
}
DataSet ds = new DataSet();
if (tableWithMerchantID.Rows.Count > 0)
{
ds.Tables.Add(tableWithMerchantID);
fillDataHandler.UpdateRawSettlementPaymentData(ds);
}
ds = null;
}
else
{
DebugLogHandler.DebugLogHandler.WriteLog(sLogPath, sClass, "GetTransactionData() no report data.");
}
}
}
fillDataHandler = null;
}
catch (Exception ex)
{
DebugLogHandler.DebugLogHandler.WriteLog(sLogPath, sClass, "GetTransactionData() exception message:" + ex.Message);
}
return(settlement_idList);
}