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