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