private bool SaveProduct() { try { TrimTextBoxes(); if (IsProductValid()) { Decimal dSalePrice = 0; if (salePriceTextBox.Text != string.Empty) { dSalePrice = Decimal.Parse(salePriceTextBox.Text); } if (IsUpdateMode) { if (taProducts.Update(trProductsRow) > 0) { MessageBox.Show("Product updated successfully", "Product Updated", MessageBoxButtons.OK, MessageBoxIcon.Information); return(true); } else { MessageBox.Show("Product Updation failed", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } } else { if (taProducts.Insert(productNameTextBox.Text, descriptionTextBox.Text, manufacturerTextBox.Text, productTag1TextBox.Text, productTag2TextBox.Text, dSalePrice, false) > 0) { MessageBox.Show("Product inserted successfully", "Product Inserted", MessageBoxButtons.OK, MessageBoxIcon.Information); return(true); } else { MessageBox.Show("Product insertion failed", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } } } else { return(false); } } catch (Exception ex) { MessageBox.Show("Product insertion failed due to following error:" + Environment.NewLine + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }
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); }