private void back_Click(object sender, EventArgs e)
{
if (sound)
{
System.Media.SoundPlayer player = new System.Media.SoundPlayer();
player.Stream = Properties.Resources.πίσω_woman;
player.Play();
}
Hall hall = new Hall(sound);
this.Close();
hall.Show();
}
private void button1_Click(object sender, EventArgs e)
{
string number = textBox1.Text;
string date = textBox2.Text;
string ccv = textBox3.Text;
string name = textBox4.Text;
if (Globals.IsCreditCardInfoValid(number, date, ccv, name) == true)
{
SQLiteCommand cmd = new SQLiteCommand(m_dbConnection);
m_dbConnection.Open();
cmd.Parameters.AddWithValue("@name", name);
for (int i = 0; i < 50; i++)
{
if (iarray[i] == 1)
{
cmd.CommandText = $"UPDATE ID{Globals.id} SET Name=@name WHERE ROWID={i+1}";
cmd.ExecuteNonQuery();
}
}
SQLiteCommand cmd2 = new SQLiteCommand(m_dbConnection);
SQLiteCommand cmd3 = new SQLiteCommand(m_dbConnection);
SQLiteCommand cmd4 = new SQLiteCommand(m_dbConnection);
cmd2.Parameters.AddWithValue("@name", name);
cmd2.CommandText = $"SELECT count(*) FROM ROBOTMESSAGE WHERE NAME=@name";
int count = Convert.ToInt32(cmd2.ExecuteScalar());
if (count == 1)
{
cmd3.Parameters.AddWithValue("@name", name);
cmd3.CommandText = $"SELECT BARITEM FROM ROBOTMESSAGE WHERE NAME=@name";
string item = cmd3.ExecuteScalar().ToString();
MessageBox.Show("Πιθανόν να λερώσατε την προηγούμενη φορά με\n" + item + ", θα παρακαλούσαμε να είσαστε πιο προσεκτικός αυτή τη φόρα.\nΕυχαριστούμε για την αγοράς σας.");
cmd4.Parameters.AddWithValue("@name", name);
cmd4.CommandText = $"DELETE FROM ROBOTMESSAGE WHERE NAME=@name";
cmd4.ExecuteNonQuery();
this.Hide();
Hall hall = new Hall();
hall.Show();
}
else
{
MessageBox.Show("Ευχαριστούμε για την αγοράς σας");
this.Hide();
Hall hall = new Hall();
hall.Show();
}
m_dbConnection.Close();
}
}
private void πΙΣΩToolStripMenuItem_Click(object sender, EventArgs e)
{
Globals.value = 0;
Globals.value1 = 0;
Globals.value2 = 0;
Globals.value3 = 0;
Globals.value4 = 0;
Globals.value5 = 0;
Globals.value6 = 0;
Globals.value7 = 0;
Hall hall = new Hall();
hall.Show();
this.Hide();
}
