public add_product(Forms.Inventory inventory1) { InitializeComponent(); inventory = inventory1; populate_supplier(); populate_category(); }
public edit_product(Forms.Inventory inventory1, String prod_id) { InitializeComponent(); product_id = prod_id; inventory = inventory1; populate_supplier(); populate_category(); product_detail(); }
private void btn_save_click(object sender, RoutedEventArgs e) { if (txt_supplierAddress.Text == "" || txt_supplierContact.Text == "" || txt_supplierName.Text == "") { MessageBox.Show("Incomplete details"); return; } try { MessageBoxResult messageBoxResult = System.Windows.MessageBox.Show("Save Supplier details?", "Add Supplier", System.Windows.MessageBoxButton.YesNo); if (messageBoxResult == MessageBoxResult.Yes) { string query = "insert into supplier values ('',@supplier_name,@supplier_contact,@supplier_address) "; String con = System.Configuration.ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString; MySqlConnection connect = new MySqlConnection(con); connect.Open(); MySqlCommand cmd = new MySqlCommand(query, connect); cmd.Prepare(); cmd.Parameters.AddWithValue("@supplier_name", txt_supplierName.Text); cmd.Parameters.AddWithValue("@supplier_address", txt_supplierAddress.Text); cmd.Parameters.AddWithValue("@supplier_contact", txt_supplierContact.Text); cmd.ExecuteNonQuery(); MessageBox.Show("Successfully Saved Data!", "Add Supplier", MessageBoxButton.OK, MessageBoxImage.Information); clear_details(); show_supplier(); Forms.Inventory inventory = new Forms.Inventory(); inventory.show_inventory(); connect.Close(); } else { return; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error); } }