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);
}
}
