private void button1_Click(object sender, EventArgs e) { string skuMapColumnName = MarketplaceMdl.Mdl.GetSKUMapColumnName(); List <string> skuMapColumnNameList = skuMapColumnName.Split(',').ToList(); OpenFileDialog openFileDialog1 = new OpenFileDialog(); if (openFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK) { DataTable csvTable = new DataTable(); csvTable = CsvUtility.LoadCsvFileAsDataTable(openFileDialog1.FileName); var csvColumnName = csvTable.Columns.Cast <DataColumn>() .Select(x => x.ColumnName) .ToArray(); List <string> csvColumnNameList = csvColumnName.ToList(); bool isFileOk = true; foreach (string columName in csvColumnName) { if (!skuMapColumnNameList.Contains(columName)) { isFileOk = false; MessageBox.Show("Error, unknow column from CSV file: " + columName); break; } } if (isFileOk == true) { Dictionary <string, string> d = new Dictionary <string, string>(); foreach (DataRow dr in csvTable.Rows) { string vendorSku = dr["vendorSku"].ToString().Trim(); DataRow vendorSKUInfoDr = MarketplaceMdl.Mdl.CheckIsVendorSKUExist(vendorSku); if (vendorSKUInfoDr == null || vendorSKUInfoDr["VendorSKU"].ToString() == "") { //insert foreach (string csvTableColumnName in csvColumnNameList) { } } else { //update } } } } }
private void importVisionInventoryToolStripMenuItem_Click(object sender, EventArgs e) { pictureBox1.Visible = true; try { OpenFileDialog openFileDialog1 = new OpenFileDialog(); if (openFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK) { DataTable csvTable = new DataTable(); csvTable = CsvUtility.LoadCsvFileAsDataTable(openFileDialog1.FileName); foreach (DataRow csvDr in csvTable.Rows) { string visionSku = csvDr["Vision Item #"].ToString().Trim(); string visionQty = csvDr["CA Inventory"].ToString().Trim(); string visionNjQty = csvDr["NJ Inventory"].ToString().Trim(); string visionTxQty = csvDr["TX Inventory"].ToString().Trim(); DataRow isNewVisionSkuDr = MarketplaceDb.Db.CheckNewVisionSKU(visionSku); if (isNewVisionSkuDr == null || isNewVisionSkuDr["VendorSKU"].ToString() == "") { DataRow dr = MarketplaceDb.Db.GetMaxItemID(); int nextMaxItemId = ConvertUtility.ToInt(dr["maxItemID"].ToString()) + 1; MarketplaceDb.Db.InsertNewVisionItem(nextMaxItemId, visionSku, visionQty, visionNjQty, visionTxQty); } else { MarketplaceDb.Db.UpdateVisionReferenceInventory(visionSku, visionQty, visionNjQty, visionTxQty); } } MarketplaceDb.Db.FinalUpdateVisionQty(); MessageBox.Show("Done"); pictureBox1.Visible = false; } else { pictureBox1.Visible = false; } } catch (Exception ex) { MessageBox.Show("Error: " + ex.Message.ToString()); } }