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