private void btnOk_Click(object sender, RoutedEventArgs e) { try { Product pro = new Product(); pro.Name = txtNameProduct.Text; pro.Price = float.Parse(txtPrice.Text); ProductBLL.InsertProduct(pro); System.Windows.Forms.MessageBox.Show("Successfully"); if (AddFinished != null) { AddFinished(pro); } } catch (Exception g) { System.Windows.Forms.MessageBox.Show("Error: " + g.Message); } finally { this.Close(); } }
public InvoiceDetail(int invoiceID, Product product, int quantity) { InvoiceID = invoiceID; ProductID = product.ProductID; Quantity = quantity; SubTotal = product.Price * Quantity; }
public static List<Product> SelectAllProduct() { List<Product> list = new List<Product>(); string sql = "spGetAllProduct"; try { SqlDataReader rd = DataProvider.ExecuteQueryWithDataReader(sql, System.Data.CommandType.StoredProcedure); if (rd.HasRows) { while(rd.Read()) { Product p = new Product() { ProductID = rd.GetInt32(0), Name = rd.GetString(1), Price = rd.GetDouble(2) }; list.Add(p); } } }catch(Exception g) { throw new Exception(g.Message); } return list; }
public static bool InsertProduct(Product pro) { string sql = "spInsertProduct"; SqlParameter Name = new SqlParameter("Name", pro.Name); SqlParameter Price = new SqlParameter("Price", pro.Price); return DataProvider.ExecuteNonQuery(sql, System.Data.CommandType.StoredProcedure, Name, Price); }
public static bool UpdateProduct(Product Pro) { string sql = "spUpdateProduct"; SqlParameter ProID = new SqlParameter("ProductID", Pro.ProductID); SqlParameter Name = new SqlParameter("Name", Pro.Name); SqlParameter Price = new SqlParameter("Price", Pro.Price); return DataProvider.ExecuteNonQuery(sql, CommandType.StoredProcedure, ProID,Name,Price); }
private void btnEditProduct_Click(object sender, RoutedEventArgs e) { try { if (dtgProduct.SelectedIndex >= 0) { DataRow dr = dt.Rows[dtgProduct.SelectedIndex]; Product pro = new Product(); pro.ProductID = (int)dr["ProductID"]; pro.Name = dr["Name"].ToString(); pro.Price = (double)dr["Price"]; Edit_Product product = new Edit_Product(pro); product.EditFinished += new HD(EditCurRow); product.ShowDialog(); } } catch (Exception g) { System.Windows.Forms.MessageBox.Show(g.Message); } }
public static bool UpdateProductByID(Product pro) { return ProductData.UpdateProduct(pro); }
public static bool InsertProduct(Product pro) { return ProductData.InsertProduct(pro); }
private void UpdateTable(Product pro) { dt.Rows.Add(pro.ProductID, pro.Name, pro.Price); }
private void EditCurRow(Product a) { DataRow dr = dt.Rows.Find(a.ProductID); dr["Name"] = a.Name; dr["Price"] = a.Price; }