private void button3_Click(object sender, EventArgs e)
{
this.Hide();
ActOne a1 = new ActOne(MyVal);
a1.ShowDialog();
}
private void button1_Click(object sender, EventArgs e)
{
MySqlConnection sqlcon = new MySqlConnection(@"server=localhost;user id=root;database=seproject;password=rootpassword");
MySqlCommand cmd = null;
MySqlDataReader reader = null;
try
{
string sql = "SELECT inGameCurrency FROM seproject.user WHERE username = '******';";
//sqlcon = new MySqlConnection(Properties.Settings.Default.ConnectionString);
cmd = new MySqlCommand(sql, sqlcon);
sqlcon.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
val = reader.GetInt32("inGameCurrency");
//lblContinent.Text = reader.GetInt32("continent");
//lblRegion.Text = reader.GetString("region");
//lblSurfaceArea.Text = string.Format("{0:0.00}", reader.GetFloat("surfacearea"));
}
Console.WriteLine(val);
}
catch (Exception ex)
{
MessageBox.Show(string.Format("An error occurred {0}", ex.Message), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (reader != null)
{
reader.Close();
}
if (sqlcon != null)
{
sqlcon.Close();
}
}
if (x <= 10)
{
button1.Enabled = false;
button1.Text = "Next song";
x++;
unlockButtons();
startRoundTimer();
displayTimer();
soundPlayer(x);
scoreLabel.Text = score.ToString();
}
switch (x)
{
case 1:
button2.Text = "Queen - Don't Stop Me Now";
button3.Text = "The Rolling Stones - Gimme Shelter";
button4.Text = "The Beatles - Strawberry Fields";
button5.Text = "Guns 'n Roses - Civil War";
break;
case 2:
button2.Text = "Subcarpati - Folclor Nemuritor";
button3.Text = "Holograf - Primara Incepe Cu Tine";
button4.Text = "Tudor Gheorghe - Au Innebunit Salcamii";
button5.Text = "Spike - Salcamii";
break;
case 3:
button2.Text = "Led Zeppelin - Whole Lotta Love";
button3.Text = "Jimi Hendrix - Hey Joe";
button4.Text = "Eric Clapton - Cocaine";
button5.Text = "Carlos Santana - Black Magic Woman";
break;
case 4:
button2.Text = "Arctic Monkeys - Flourescent Adolescent";
button3.Text = "Nothing But Thieves - Amsterdam";
button4.Text = "Cage The Elephant - Ain't No Rest For The Wicked";
button5.Text = "Red Hot Chili Peppers - Dani California";
break;
case 5:
button2.Text = "Sia - Unstoppable";
button3.Text = "Billie Eilish ft. Khalid - Lovely";
button4.Text = "Nelly Furtado - Say It Right";
button5.Text = "Rihanna - Love On The Brain";
break;
case 6:
button2.Text = "Lana Del Rey - Young And Beautiful";
button3.Text = "Miley Cyrus - We Can't Stop";
button4.Text = "Katy Perry - Firework";
button5.Text = "Taylor Swift - Blank Space";
break;
case 7:
button2.Text = "Panic! At The Disco - Emperor's New Clothes";
button3.Text = "The Black Eyed Peas - Boom Boom Pow";
button4.Text = "Bring Me The Horizon - Teardrops";
button5.Text = "Mark Ranson ft. Bruno Mars - Uptown Funk";
break;
case 8:
button2.Text = "The Prodigy - Omen";
button3.Text = "Noisia - Alpha Centauri";
button4.Text = "Modestep - Another Day ft. Popeska";
button5.Text = "Sub Focus - Rock It";
break;
case 9:
button2.Text = "Alice In Chains - Rooster";
button3.Text = "Nirvana - In Bloom";
button4.Text = "Soundgarden - Black Hole Sun";
button5.Text = "Pearl Jam - Garden";
break;
case 10:
button2.Text = "Suie Paparude - A Fost Odata";
button3.Text = "Dragonu' x Kaxi Ploae x Bean - Miles";
button4.Text = "Subcarpati cu Motanu' si Calin Han - Da-i Foale";
button5.Text = "Faust cu Motanu' - Acelasi Feeling";
break;
default:
MessageBox.Show("All done! Your score is " + score.ToString());
sum = val + score;
try
{
sqlcon.Open();
string Query = "update seproject.user set inGameCurrency = " + "'" + sum + "' where (username = '******');";
MySqlCommand cmdInsert = new MySqlCommand(Query, sqlcon);
MySqlDataReader reader1 = cmdInsert.ExecuteReader();
MessageBox.Show("Saved");
while (reader1.Read())
{
}
sqlcon.Close();
}
catch (Exception ex)
{
MessageBox.Show("Insertion failed");
}
this.Hide();
ActOne a1 = new ActOne(MyVal);
a1.ShowDialog();
break;
}
}
private void button1_Click_1(object sender, EventArgs e)
{
MySqlConnection sqlcon = new MySqlConnection(@"server=localhost;user id=root;database=seproject;password=rootpassword");
MySqlCommand cmd = null;
MySqlDataReader reader = null;
try
{
string sql = "SELECT inGameCurrency FROM seproject.user WHERE username = '******';";
//sqlcon = new MySqlConnection(Properties.Settings.Default.ConnectionString);
cmd = new MySqlCommand(sql, sqlcon);
sqlcon.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
val = reader.GetInt32("inGameCurrency");
//lblContinent.Text = reader.GetInt32("continent");
//lblRegion.Text = reader.GetString("region");
//lblSurfaceArea.Text = string.Format("{0:0.00}", reader.GetFloat("surfacearea"));
}
Console.WriteLine(val);
}
catch (Exception ex)
{
MessageBox.Show(string.Format("An error occurred {0}", ex.Message), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (reader != null)
{
reader.Close();
}
if (sqlcon != null)
{
sqlcon.Close();
}
}
if (x <= 10)
{
button1.Enabled = false;
button1.Text = "Next question";
x++;
unlockButtons();
startRoundTimer();
displayTimer();
scoreLabel.Text = score.ToString();
}
switch (x)
{
case 1:
label2.Text = "In 'The Matrix', what's the color of the pull that Neo takes?";
button2.Text = "Red";
button3.Text = "Greeb";
button4.Text = "Blue";
button5.Text = "Cyan";
break;
case 2:
label2.Text = "The head of what kind of animal is front-and-center in an infamous scene from The Godfather?";
button2.Text = "A buck";
button3.Text = "An ostrich";
button4.Text = "A horse";
button5.Text = "A wolf";
break;
case 3:
label2.Text = "Who is the only actor to receive an Oscar nomination for acting in a Lord of the Rings movie?";
button2.Text = "Orlando Bloom";
button3.Text = "Ian McKellen";
button4.Text = "Vigo Mortensen";
button5.Text = "Elijah Wood";
break;
case 4:
label2.Text = "Which Alfred Hitchcock movie is notorious for its shocking “shower scene”?";
button2.Text = "Strangers on a train";
button3.Text = "The Birds";
button4.Text = "Vertigo";
button5.Text = "Psycho";
break;
case 5:
label2.Text = "What was Quentin Tarantino‘s first feature as writer/director?";
button2.Text = "Reservoir Dogs";
button3.Text = "Pulp Fiction";
button4.Text = "Planet Terror";
button5.Text = "Jackie Brown";
break;
case 6:
label2.Text = "Which Friends star appeared in the movie Scream?";
button2.Text = "Phobe";
button3.Text = "Chandler";
button4.Text = "Monica";
button5.Text = "Joey";
break;
case 7:
label2.Text = "Who is Harry Potter’s godfather?";
button2.Text = "Remus Lupin";
button3.Text = "Sirius Black";
button4.Text = "Severus Snape";
button5.Text = "Alastor Moody";
break;
case 8:
label2.Text = "What is the name of Andy’s neighbor in Toy Story?";
button2.Text = "Sid";
button3.Text = "Diego";
button4.Text = "Zeke";
button5.Text = "Manfred";
break;
case 9:
label2.Text = "Approximately how many languages can C-3PO speak in Star Wars?";
button2.Text = "600 thousand";
button3.Text = "100";
button4.Text = "3 thousand";
button5.Text = "6 million";
break;
case 10:
label2.Text = "What is the symbolism of the crow crowing three times in the Godfather movies?";
button2.Text = "Famine";
button3.Text = "Pestilence";
button4.Text = "Death";
button5.Text = "War";
break;
default:
MessageBox.Show("All done! Your score is " + score.ToString());
sum = val + score;
try
{
sqlcon.Open();
string Query = "update seproject.user set inGameCurrency = " + "'" + sum + "' where (username = '******');";
MySqlCommand cmdInsert = new MySqlCommand(Query, sqlcon);
MySqlDataReader reader1 = cmdInsert.ExecuteReader();
MessageBox.Show("Saved");
while (reader1.Read())
{
}
sqlcon.Close();
}
catch (Exception ex)
{
MessageBox.Show("Insertion failed");
}
this.Hide();
ActOne a1 = new ActOne(MyVal);
a1.ShowDialog();
break;
}
}