/* the event for excel button clicks that update the merchant sku */
private void excelButton_Click(object sender, EventArgs e)
{
if (openFileDialog.ShowDialog(this) != DialogResult.OK)
{
return;
}
switch (loadingLabel.Text)
{
case "Sears":
{
// sears case
sears = new Sears();
new Thread(() => sears.Update(openFileDialog.FileName)).Start();
shopCa = null;
amazon = null;
giantTiger = null;
}
break;
case "Shop.ca":
{
// shop.ca case
shopCa = new ShopCa();
new Thread(() => shopCa.Update(openFileDialog.FileName)).Start();
sears = null;
giantTiger = null;
amazon = null;
}
break;
case "Amazon":
{
// amazon case
amazon = new Amazon();
new Thread(() => amazon.Update(openFileDialog.FileName)).Start();
sears = null;
shopCa = null;
giantTiger = null;
}
break;
case "Giant Tiger":
{
// giant tiger case
giantTiger = new GiantTiger();
new Thread(() => giantTiger.Update(openFileDialog.FileName)).Start();
sears = null;
shopCa = null;
amazon = null;
}
break;
}
timer.Start();
}
/* button event for update that refresh the inventory data in giant tiger */
private void updateButton_Click(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
#region Processing
// local fields
List <GiantTigerInventoryValues> list = new List <GiantTigerInventoryValues>();
GiantTiger giantTiger = new GiantTiger();
foreach (DataRow row in table.Rows)
{
// check the discontinue item to udpate database
bool discontinue = Convert.ToBoolean(row[10]);
if (discontinue)
{
giantTiger.Discontinue(row[0].ToString());
}
if (row[2].ToString() == "")
{
continue;
}
GiantTigerInventoryValues value = new GiantTigerInventoryValues(row[1].ToString(), row[0].ToString(), row[3].ToString(), row[4].ToString(), Convert.ToInt32(row[6]), Convert.ToDouble(row[5]),
Convert.ToBoolean(row[9]), discontinue, row[2].ToString(), Convert.ToInt32(row[7]));
list.Add(value);
}
// start updating
try
{
giantTiger.Update(list.ToArray());
}
catch (Exception ex)
{
MessageBox.Show("Error occurs during updating:\n" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
#endregion
Cursor.Current = Cursors.Default;
// show complete message
MessageBox.Show("Inventory update complete to Giant Tiger");
}
