private void button4_Click(object sender, EventArgs e) { i++; con.Open(); com = new SqlCommand("INSERT INTO Selli (Count,Number,Name,quantity,Price) values (@Count,@Number,@Name,@quantity,@Price)", con); com.Parameters.AddWithValue("@Count", i); com.Parameters.AddWithValue("@Number", 1111); com.Parameters.AddWithValue("@quantity", 1); com.Parameters.AddWithValue("@Name", "Offer-1"); com.Parameters.AddWithValue("@Price", 125); // com.ExecuteNonQuery(); dr = com.ExecuteReader(); if (dr.Read()) { MessageBox.Show("An Item Added."); int p = 125; Payment payment = new Payment(); payment.b(p); Close(); } con.Close(); MessageBox.Show("Your Iteam have been added."); try { con.Open(); com = new SqlCommand("INSERT INTO AllSelli (Count,Number,Name,quantity,Price) values (@Count,@Number,@Name,@quantity,@Price)", con); com.Parameters.AddWithValue("@Count", i); com.Parameters.AddWithValue("@Number", 1111); com.Parameters.AddWithValue("@quantity", 1); com.Parameters.AddWithValue("@Name", "Offer-1"); com.Parameters.AddWithValue("@Price", 125); // com.ExecuteNonQuery(); dr = com.ExecuteReader(); if (dr.Read()) { MessageBox.Show("An Item Added."); i++; Close(); } con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); Close(); } }
private void button2_Click(object sender, EventArgs e) { i++; con.Open(); com = new SqlCommand("SELECT * FROM Item WHERE Id= " + int.Parse(textBox2.Text), con); dr = com.ExecuteReader(); if (dr.Read()) { try { String v = (dr["Name"].ToString()); if (v == "Coffee") { name = v; MessageBox.Show("Your Coffee added to cart"); p = 50 * int.Parse(this.textBox1.Text); Payment payment = new Payment(); payment.b(p); } else if (v == "Cake") { name = v; MessageBox.Show("Your Cake added to cart"); p = 75 * int.Parse(this.textBox1.Text); Payment payment = new Payment(); payment.b(p); } else { name = v; MessageBox.Show("Your Burger added to cart"); p = 150 * int.Parse(this.textBox1.Text); Payment payment = new Payment(); payment.b(p); } } catch (Exception ex) { MessageBox.Show(ex.Message); Close(); } } con.Close(); try { if (textBox2.Text == null) { MessageBox.Show("Not selected"); } else { con.Open(); com = new SqlCommand("INSERT INTO Selli (Count,Number,Name,quantity,Price) values (@Count,@Number,@Name,@quantity,@Price)", con); com.Parameters.AddWithValue("@Count", i); com.Parameters.AddWithValue("@Number", int.Parse(textBox2.Text)); com.Parameters.AddWithValue("@quantity", int.Parse(this.textBox1.Text)); com.Parameters.AddWithValue("@Name", name); com.Parameters.AddWithValue("@Price", p); // com.ExecuteNonQuery(); dr = com.ExecuteReader(); if (dr.Read()) { MessageBox.Show("An Item Added."); i++; Close(); } con.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); Close(); } try { if (textBox2.Text == null) { MessageBox.Show("Not selected"); } else { con.Open(); com = new SqlCommand("INSERT INTO AllSelli (Count,Number,Name,quantity,Price) values (@Count,@Number,@Name,@quantity,@Price)", con); com.Parameters.AddWithValue("@Count", i); com.Parameters.AddWithValue("@Number", int.Parse(textBox2.Text)); com.Parameters.AddWithValue("@quantity", int.Parse(this.textBox1.Text)); com.Parameters.AddWithValue("@Name", name); com.Parameters.AddWithValue("@Price", p); // com.ExecuteNonQuery(); dr = com.ExecuteReader(); if (dr.Read()) { MessageBox.Show("An Item Added."); Close(); } con.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); Close(); } }