protected _PonpareEntity GetPet()
{
Base_BL bbl = new Base_BL();
pet = new _PonpareEntity()
{
StoreCD = StoreCD,
APIKey = API_Key,
fromDate = fromDate,
toDate = toDate,
Juchuu = bbl.DataTableToXml(Juchuu).Replace("]", "}").Replace("[", "{"),
JuchuuDetails = bbl.DataTableToXml(JuchuuDetails).Replace("]", "}").Replace("[", "{"),
Coupon = bbl.DataTableToXml(Coupon).Replace("]", "}").Replace("[", "{"),
Enclose = bbl.DataTableToXml(Enclose).Replace("]", "}").Replace("[", "{"),
};
return(pet);
}
protected void Insert_Items(MarketplaceWebServiceOrders.MarketplaceWebServiceOrders client)
{
ListOrderItemsRequest request = new ListOrderItemsRequest();
request.SellerId = SellerId;
Base_BL bbl = new Base_BL();
aml = new Amazon__BL();
Amazon_Juchuu_Items = D_AmazonJuchuuItems();
var dtAmazonOrderId = aml.Select_AllOrderByLastRireki();
int j = 0; int i = 0;
foreach (DataRow dr in dtAmazonOrderId.Rows)
{
j++;
request.AmazonOrderId = dr["AmazonOrderId"].ToString();
ListOrderItemsResponse response = client.ListOrderItems(request);
if (response.IsSetListOrderItemsResult())
{
ListOrderItemsResult listOrderItemsResult = response.ListOrderItemsResult;
if (listOrderItemsResult.IsSetOrderItems())
{
List <OrderItem> orderItems = listOrderItemsResult.OrderItems;
foreach (OrderItem orderItem in orderItems)
{
i++;
Amazon_Juchuu_Items_Add(request.AmazonOrderId, orderItem, j, i);
// strbuff += "商品名：" + orderItem.Title + System.Environment.NewLine;
}
}
}
}
Amazon__Entity ameDetails = new Amazon__Entity();
ameDetails.StoreCD = StoreCD;
ameDetails.APIKey = APIKey;
ameDetails.XmlOrderItems = bbl.DataTableToXml(Amazon_Juchuu_Items);
if (aml.Amazon_InsertOrderItemDetails(ameDetails))
{
Console.Write("All Items are Imported Successffully!!!");
Console.ReadLine();
}
}
public bool InsertData(int i)
{
dgv1.Rows[i].Cells["colStatus"].Value = "Importing.....";
dgv1.Rows[i].Cells["colImage"].Value = SMS.Properties.Resources.dbImport;
// dgv1.Rows[i].Cells["colImage"].Style.BackColor = Color.FromArgb(255, 255, 192);
dgv1.Rows[i].Cells["colReason"].Value = ".....";
dgv1.Rows[i].DefaultCellStyle.BackColor = Color.WhiteSmoke;
dgv1.Rows[i].DefaultCellStyle.ForeColor = Color.Black;
string filePath = dgv1.Rows[i].Cells["colFileName"].Value.ToString();
string ext = Path.GetExtension(filePath);
var dtImport = new DataTable();
if (ext.Equals(".csv") || ext.Equals(".CSV"))
{
dtImport = CSVToDataTable(filePath); ///Wrong csv to datatable
}
else if (ext.Equals(".txt"))
{
dtImport = TXTToDataTable(filePath);
}
else
{
dgv1.Rows[i].Cells["colStatus"].Value = "Invalid File";
dgv1.Rows[i].Cells["colImage"].Value = SMS.Properties.Resources.close;
dgv1.Rows[i].Cells["colReason"].Value = "Choose correct format File!";
dgv1.Rows[i].DefaultCellStyle.BackColor = Color.Red;
dgv1.Rows[i].DefaultCellStyle.ForeColor = Color.White;
return(false);
}
if (dtImport != null)
{
NyuukinMeisai_data.xml = baseBL.DataTableToXml(dtImport);
var check2kanji = GetFirst2Kanji(Path.GetFileNameWithoutExtension(filePath));
if (check2kanji != null) // Chech First 2 kanji
{
if (PETC30303I.CheckExistName1_0303I(NyuukinMeisai_data, LLogEntity, check2kanji))
{
if (PETC30303I.PETC0303I_Insert(NyuukinMeisai_data, LLogEntity, check2kanji)) // Meisai and tetsuyou
{
dgv1.Rows[i].Cells["colStatus"].Value = "Finished!";
dgv1.Rows[i].Cells["colImage"].Value = SMS.Properties.Resources.success;
dgv1.Rows[i].Cells["colReason"].Value = dtImport.Rows.Count.ToString() + " data have been imported!";
dgv1.Rows[i].DefaultCellStyle.BackColor = Color.FromArgb(192, 255, 192);
dgv1.Rows[i].DefaultCellStyle.ForeColor = Color.Black;
}
}
else
{
dgv1.Rows[i].Cells["colStatus"].Value = "Failed!";
dgv1.Rows[i].Cells["colImage"].Value = SMS.Properties.Resources.close;
cmf.DSP_MSG("E137", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); // Error While not Catching first 2 kanjis
dgv1.Rows[i].Cells["colReason"].Value = "No row exist in import field with respect to NyuukinmotoName1!";
dgv1.Rows[i].DefaultCellStyle.BackColor = Color.CornflowerBlue;
dgv1.Rows[i].DefaultCellStyle.ForeColor = Color.White;
}
}
else
{
dgv1.Rows[i].Cells["colStatus"].Value = "Failed!";
dgv1.Rows[i].Cells["colImage"].Value = SMS.Properties.Resources.close;
cmf.DSP_MSG("E137", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); // Error While not Catching first 2 kanjis
dgv1.Rows[i].Cells["colReason"].Value = "Error in getting First two Kanji!";
dgv1.Rows[i].DefaultCellStyle.BackColor = Color.CornflowerBlue;
dgv1.Rows[i].DefaultCellStyle.ForeColor = Color.White;
}
}
else
{
dgv1.Rows[i].Cells["colStatus"].Value = "Failed!";
dgv1.Rows[i].Cells["colImage"].Value = SMS.Properties.Resources.close;
dgv1.Rows[i].Cells["colReason"].Value = "Not importable data file(No data)!";
dgv1.Rows[i].DefaultCellStyle.BackColor = Color.CornflowerBlue;
dgv1.Rows[i].DefaultCellStyle.ForeColor = Color.White;
}
dgv1.Rows[i].Cells["colNo"].Style.ForeColor = Color.Black;
return(true);
}
protected void InsertRirekiDetail(GetOrderNoWsvcRspBean OrderNos) //ABCD OrderNos.orderNoList[0]
{
int i = 0;
foreach (string order in OrderNos.orderNoList)
{
i++;
RirekiDetail.Rows.Add(new object[] { StoreCD, API_Key, i.ToString(), order });
}
Base_BL bbl = new Base_BL();
var InsertRireki = pbl.InsertRirekiDetail(StoreCD, API_Key, fromDate, toDate, bbl.DataTableToXml(RirekiDetail));
}
protected void F12()
{
DialogResult dialogResult = MessageBox.Show("在庫データCSVを作成しますか？", "", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (dialogResult == DialogResult.OK)
{
if (!ErrorCheck())
{
return;
}
Base_BL baseBL = new Base_BL();
Cursor = Cursors.WaitCursor;
if (dtmain == null)
{
MessageBox.Show("Error in reading Files ... ");
return;
}
var de = p10.T_SmileInsert(loginInfo.OperatorCode, baseBL.DataTableToXml(dtmain));
if (de)
{
if (String.IsNullOrEmpty(txtProcessNo.Text) && string.IsNullOrWhiteSpace(txtSlipNo.Text)) // first time to input
{
//
}
else
{
var dtsmile = p10.GetTSmile();
if (dtsmile.Rows.Count > 0)
{
if (Convert.ToInt64(txtProcessNo.Text) >= Convert.ToInt64(dtsmile.Rows[0]["ProcessNo"].ToString()) || Convert.ToDateTime(txtDate.Text) >= Convert.ToDateTime(dtsmile.Rows[0]["Date"].ToString()))
{
var msg = cmf.DSP_MSG("Q328", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty);
if (msg != "1")
{
Cursor = Cursors.Default;;
txtDate.Focus();
return;
}
}
}
}
var ds = p10.T_SmileHistoryInsert_Output();
ConmmaSplit(ds);
var path = @"C:\SMS\PETC0310I\";
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
try
{
var dtnow = DateTime.Now.ToString("yyyyMMdd HHmmss");
var fname = dtnow.Replace(" ", "_") + "_" + loginInfo.OperatorCode + "_" + Path.GetFileNameWithoutExtension(txtInput.Text) + ".CSV";
if (ds.Rows.Count > 0)
{
if (File.Exists(path + "\\" + fname))
{
File.Delete(path + "\\" + fname);
}
ToCSV(ds, path + "\\" + fname);// For tennic
}
cmf.DSP_MSG("I201", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty);
Init();
Process.Start(Path.GetDirectoryName(path));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
Cursor = Cursors.Arrow;
//do something
}
else if (dialogResult == DialogResult.No)
{
return;
//do something else
}
}
public void ListOrders()
{
ame = new Amazon__Entity();
aml = new Amazon__BL();
ame = aml.MAPI_DRequest();
//string SellerId = CommonValue.strMerchantId;
//string MarketplaceId = CommonValue.strMarketplaceId;
//string AccessKeyId = CommonValue.strAccessKeyId;
//string SecretKeyId = CommonValue.strSecretKeyId;
//string ApplicationVersion = CommonValue.strApplicationVersion;
//string ApplicationName = CommonValue.strApplicationName;
//string MWSAuthToken = CommonValue.strMWSAuthToken;
//string strbuff = string.Empty;
SellerId = ame.strMerchantId;
MarketplaceId = ame.strMarketplaceId;
AccessKeyId = ame.strAccessKeyId;
MWSAuthToken = ame.strMWSAuthToken;
SecretKeyId = ame.strSecretKeyId;
APIKey = ame.APIKey;
StoreCD = ame.StoreCD;
string ApplicationVersion = CommonValue.strApplicationVersion;
string ApplicationName = CommonValue.strApplicationName;
DataTable strbuff = new DataTable();
var LastUpdatedBefore = aml.Amazon_DRequest();
if (LastUpdatedBefore != null)
{
UpdatedTimeBefore = Convert.ToDateTime(LastUpdatedBefore).AddDays(-1);
}
else
{
UpdatedTimeBefore = DateTime.Now;;
}
MarketplaceWebServiceOrdersConfig config = new MarketplaceWebServiceOrdersConfig();
config.ServiceURL = CommonValue.strServiceURL;
MarketplaceWebServiceOrders.MarketplaceWebServiceOrders client = new MarketplaceWebServiceOrdersClient(
AccessKeyId,
SecretKeyId,
ApplicationName,
ApplicationVersion,
config);
ListOrdersRequest request = new ListOrdersRequest();
request.SellerId = SellerId;
request.LastUpdatedAfter = UpdatedTimeBefore;
List <string> lstMarketplace = new List <string>();
lstMarketplace.Add(MarketplaceId);
request.MarketplaceId = lstMarketplace;
request.MWSAuthToken = MWSAuthToken;
request.MaxResultsPerPage = 40;
ListOrdersResponse response = client.ListOrders(request);
ListOrdersResult listOrdersResult = new ListOrdersResult();
if (response.IsSetListOrdersResult())
{
listOrdersResult = response.ListOrdersResult;
if (listOrdersResult.IsSetOrders())
{
List <Order> orders = listOrdersResult.Orders;
strbuff.Columns.Add("StoreCD");
strbuff.Columns.Add("APIKey");
strbuff.Columns.Add("SEQ");
strbuff.Columns.Add("OrderId");
int i = 0;
Amazon_Juchuu = D_AmazonJuchuu();
foreach (Order o in orders)
{
i++;
strbuff.Rows.Add(StoreCD, APIKey, i, o.AmazonOrderId);
GetListOrderdata(o, i);
}
}
// txtListOrders.Text = strbuff;
}
Base_BL bbl = new Base_BL();
string OrderDetails = ""; string AmazonOrderId = "";
OrderDetails = bbl.DataTableToXml(Amazon_Juchuu);
AmazonOrderId = bbl.DataTableToXml(strbuff);
TokenNo = TokenNo + 1;
Insert_FirstToken(listOrdersResult, OrderDetails, AmazonOrderId);
if (listOrdersResult.NextToken != null)
{
Insert_NextToken(response.ListOrdersResult.NextToken);
}
Insert_Items(client);
Console.Read();
//
//else
//{
// Console.Write("Order Inserted Successfully!!!");
// Console.Read();
//}
}
public void Insert_NextToken(string token = null)
{
Amazon_Juchuu_NextToken = D_AmazonJuchuu();
Base_BL bbl = new Base_BL();
DataTable strbuff = new DataTable();
strbuff.Columns.Add("StoreCD");
strbuff.Columns.Add("APIKey");
strbuff.Columns.Add("SEQ");
strbuff.Columns.Add("OrderId");
MarketplaceWebServiceOrdersConfig config = new MarketplaceWebServiceOrdersConfig();
config.ServiceURL = CommonValue.strServiceURL;
MarketplaceWebServiceOrders.MarketplaceWebServiceOrders client = new MarketplaceWebServiceOrdersClient(
AccessKeyId,
SecretKeyId,
ApplicationName,
ApplicationVersion,
config);
if (token != null)
{
ListOrdersByNextTokenRequest request1 = new ListOrdersByNextTokenRequest();
ListOrdersByNextTokenResult listOrdersByNextResult = new ListOrdersByNextTokenResult();
request1.SellerId = SellerId;
request1.MWSAuthToken = MWSAuthToken;
request1.NextToken = token;
ListOrdersByNextTokenResponse response1 = client.ListOrdersByNextToken(request1);
if (response1.IsSetListOrdersByNextTokenResult())
{
listOrdersByNextResult = response1.ListOrdersByNextTokenResult;
if (listOrdersByNextResult.IsSetOrders())
{
List <Order> orders = listOrdersByNextResult.Orders;
int i = 0;
foreach (Order o in orders)
{
i++;
strbuff.Rows.Add(StoreCD, APIKey, i, o.AmazonOrderId);
GetListOrderdata(o, i, false);
}
}
}
Amazon__Entity ameDetails = new Amazon__Entity();
ameDetails.StoreCD = StoreCD;
ameDetails.APIKey = APIKey;
ameDetails.LastUpdatedAfter = UpdatedTimeBefore.ToString();
ameDetails.LastUpdatedBefore = listOrdersByNextResult.LastUpdatedBefore.ToString();
ameDetails.Xmldetails = bbl.DataTableToXml(Amazon_Juchuu_NextToken);
ameDetails.XmlOrder = bbl.DataTableToXml(strbuff);
TokenNo = TokenNo + 1;
if (aml.AmazonAPI_Insert_NextToken(ameDetails))
{
Console.WriteLine("Successfully Inserted Token " + (TokenNo).ToString() + "Times");
}
else
{
Console.WriteLine("Unfortunately Inserted Failed Token " + (TokenNo).ToString() + "Times");
}
Insert_NextToken(listOrdersByNextResult.NextToken);
}
else/// To be Continued. . . Insert
{
Console.Write("Order inserted Successfully!!!");
Console.Read();
}
}
