private void Deletebtn_Click(object sender, EventArgs e) { try { Connect connectObj = new Connect(); con = connectObj.connect(); SqlCommand cmd = new SqlCommand("DELETE FROM PRODUCT WHERE PID = @pid", con); cmd.Parameters.AddWithValue("@pid", ProductID.Text); int i = cmd.ExecuteNonQuery(); con.Close(); //If count is equal to 1, than show frmMain form if (i != 0) { MessageBox.Show("Product Deletion Successful!", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Product Deletion Failed", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error); } ProductName.Clear(); ProductID.Clear(); } catch (Exception ex) { MessageBox.Show(ex.Message); //MessageBox.Show("Product Not found", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { if (con != null) { con.Close(); } } }
private void Clear_Click(object sender, EventArgs e) { ProductName.Clear(); productID.Clear(); VendorID.Clear(); Amount.Clear(); }
private void Clear_textBoxes() { FirstName.Clear(); LastName.Clear(); ProductName.Clear(); wholesalecost.Clear(); SaleCost.Clear(); }
private void Submit_Click(object sender, EventArgs e) { if (ProductName.Text == "" || VendorID.Text == "" || Amount.Text == "" || ProductID.Text == "") { MessageBox.Show("Please provide all the details", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } try { Connect connectObj = new Connect(); con = connectObj.connect(); SqlCommand cmd = new SqlCommand("Insert into PRODUCT (PID,PNAME,AMOUNT,VID) values(@pid,@pname,@amount,@vid);", con); cmd.Parameters.AddWithValue("@pid", ProductID.Text); cmd.Parameters.AddWithValue("@pname", ProductName.Text); cmd.Parameters.AddWithValue("@vid", VendorID.Text); cmd.Parameters.AddWithValue("@amount", Amount.Text); int i = cmd.ExecuteNonQuery(); //If count is equal to 1, than show frmMain form if (i != 0) { MessageBox.Show("Product Insertion Successful!", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Product Insertion Failed", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Information); } con.Close(); ProductName.Clear(); VendorID.Clear(); Amount.Clear(); ProductID.Clear(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (con != null) { con.Close(); } } }
private void SaveProductButton_Click(object sender, RoutedEventArgs e) { Product product = new Product(); product.Name = ProductName.Text; product.Kcal = float.Parse((ProductKCAL.Text).ToString()); product.Quantity = int.Parse((Quan.Text).ToString()); product.Unit = Unit.Text; DataBaseSolution.AddProduct(product); ProductName.Clear(); ProductKCAL.Clear(); Unit.ClearValue(NameProperty); Quan.Clear(); }
private void btnClear_Click(object sender, EventArgs e) { id = 0; FName.Clear(); Surname.Clear(); Email.Clear(); City.Clear(); ProductCategory.Clear(); ProductCode.Clear(); ProductName.Clear(); ProductVolume.Clear(); ProductUnit.Clear(); comboBox1.Items.Clear(); ProductCost.Clear(); }
private void Add_Click(object sender, EventArgs e) { if (ProductID.Text == "" || Quantity.Text == "" || ProductName.Text == "") { MessageBox.Show("Please provide all the details", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } try { Connect connectObj = new Connect(); con = connectObj.connect(); SqlCommand cmd = new SqlCommand("Insert into STOCK (PID,QUANTITY) values(@pID,@quantity);", con); cmd.Parameters.AddWithValue("@pid", ProductID.Text); cmd.Parameters.AddWithValue("@quantity", Quantity.Text); int i = cmd.ExecuteNonQuery(); //If count is equal to 1, than show frmMain form if (i != 0) { MessageBox.Show("Stock Insertion Successful!", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Stock Insertion Failed", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error); } con.Close(); //Clear all the fields ProductID.Clear(); Quantity.Clear(); ProductName.Clear(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { if (con != null) { con.Close(); } } }
private void Update_Click(object sender, EventArgs e) { if (ProductName.Text == "" || productID.Text == "" || VendorID.Text == "" || Amount.Text == "") { MessageBox.Show("Please provide all the details", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } try { Connect conObj = new Connect(); con = conObj.connect(); SqlCommand cmd = new SqlCommand("UPDATE PRODUCT SET pname = @pname,amount = @amount,vid = @vid WHERE pid = @id;", con); cmd.Parameters.AddWithValue("@id", productID.Text); cmd.Parameters.AddWithValue("@pname", ProductName.Text); cmd.Parameters.AddWithValue("@vid", VendorID.Text); cmd.Parameters.AddWithValue("@amount", Amount.Text); //cid += 1; int i = cmd.ExecuteNonQuery(); //If count is equal to 1, than show frmMain form if (i != 0) { MessageBox.Show("Product Updation Successful!", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Product Updation Failed", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error); } con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { if (con != null) { con.Close(); } } ProductName.Clear(); productID.Clear(); VendorID.Clear(); Amount.Clear(); }
private void BtnRefesh_Click(object sender, RoutedEventArgs e) { ProductName.Clear(); ProductPrice.Clear(); ProductDescription.Clear(); ProductDate.Text = null; ProductInitialAmount.Clear(); ProductCapital.Clear(); comboProductTypes.SelectedIndex = -1; BitmapImage image = new BitmapImage(); image.BeginInit(); image.UriSource = new Uri("pack://application:,,/Images/Image.png"); image.EndInit(); imgProduct.Source = image; imgProduct.Tag = null; }
private void addToBasket_Click(object sender, EventArgs e) { string prodPrice = Price.Text; string prodQuant = Quantity.Text; string product = ProductName.Text; decimal quan = Convert.ToDecimal(prodQuant); decimal price = Convert.ToDecimal(prodPrice); string quan2 = Convert.ToString(quan); string price2 = Convert.ToString(price); var item = new ListViewItem(product); item.SubItems.Add(quan2); item.SubItems.Add(price2); basket.Items.Add(item); ProductName.Clear(); Quantity.Value = 0; Price.Clear(); }
private void searchButton_Click(object sender, RoutedEventArgs e) { UserControl usc = null; GridResult.Children.Clear(); Product product = new Product(); product = DataBaseSolution.SearchProduct((ProductName.Text).ToString()); if (product.Name != null) { ProductName.Clear(); usc = new UserControlPositiveSearchResult(product); GridResult.Children.Add(usc); } else { usc = new UserControlNegativeSearchResult(); GridResult.Children.Add(usc); } }
private void clear_Click(object sender, EventArgs e) { ProductID.Clear(); Quantity.Clear(); ProductName.Clear(); }