private void buttonBuy_Click(object sender, EventArgs e) { string productname = ProductComboBox.GetItemText(ProductComboBox.SelectedItem); string qr = $"SELECT id_product FROM public.inventory WHERE \"productName\" = '{productname}'"; var sl = ConnectionDB.ExecuteQuery(qr); int id = int.Parse(sl.Rows[0][2].ToString()); var q = textBox1.Text; int quantity = int.Parse(q); ConnectionDB.ExecuteNonQuery($"INSERT INTO public.orders(username, id_product, quantity)" + $" VALUES('{username}', {id}, {quantity})"); MessageBox.Show("La orden ha sido registrada!!"); }
private void buttonBuy_Click(object sender, EventArgs e) { int quantity = int.Parse(textBox1.Text); var qr = "SELECT id_product FROM public.inventory WHERE" + $" \"productName\" = '{ProductComboBox.GetItemText(ProductComboBox.SelectedItem)}'"; DataTable dt = ConnectionDB.ExecuteQuery(qr); //var ids = dt.Rows[0][0].ToString(); int id = Convert.ToInt32(dt.Rows[0][0].ToString()); ConnectionDB.ExecuteNonQuery($"INSERT INTO public.orders(username, id_product, quantity)" + $" VALUES('{username}', {id}, {quantity})"); MessageBox.Show("La orden ha sido registrada!!"); }