public AddNewProduct(int iProductID)
{
InitializeComponent();
ProductID = iProductID;
IsUpdateMode = true;
InventoryStoreDataSet.tblProductsDataTable dt = taProducts.GetProductByID(ProductID);
if (dt.Rows.Count > 0)
{
trProductsRow = dt.Rows[0] as InventoryStoreDataSet.tblProductsRow;
}
}
private void btnImportStock_Click(object sender, EventArgs e)
{
string connString = "Dsn=SageLine50v10;uid=manager;Pwd=eplslrc;";
OdbcConnection conn = new OdbcConnection(connString);
OdbcCommand comm = new OdbcCommand();
comm.Connection = conn;
comm.CommandTimeout = 300;
comm.CommandText = "SELECT STOCK_CODE AS ProductName, DESCRIPTION, WEB_DESCRIPTION AS ProductTag1, WEB_DETAILS, WEB_CATEGORY_1, SALES_PRICE, 1 AS Discontinued FROM STOCK";
conn.Open();
OdbcDataAdapter da = new OdbcDataAdapter(comm);
DataSet ds = new DataSet();
da.Fill(ds);
//var prds = this.inventoryStoreDataSet.tblProducts;
//prds.Merge(ds.Tables[0],true);
InventoryStoreDataSetTableAdapters.tblProductsTableAdapter taProducts = new InventoryStoreDataSetTableAdapters.tblProductsTableAdapter();
InventoryStoreDataSet.tblProductsRow trProductsRow;
foreach (DataRow dr in ds.Tables[0].Rows)
{
trProductsRow = dr as InventoryStoreDataSet.tblProductsRow;
InventoryStoreDataSet.tblProductsDataTable dt = taProducts.GetProductByID(ProductID);
if (dt.Rows.Count > 0)
{
trProductsRow = dt.Rows[0] as InventoryStoreDataSet.tblProductsRow;
}
if (taProducts.Update(trProductsRow) > 0)
{
//MessageBox.Show("Product updated successfully", "Product Updated", MessageBoxButtons.OK, MessageBoxIcon.Information);
//return true;
}
else
{
taProducts.Insert(dr[0].ToString(), dr[1].ToString(),
dr[2].ToString(), dr[3].ToString(), dr[4].ToString(),
decimal.Parse(dr[5].ToString()), false);
}
}
this.tblProductsTableAdapter.FillActiveProducts(this.inventoryStoreDataSet.tblProducts);
}
