private void Die()
{
Settings.GameOver = true;
// database part of scoreboard (staring ....)
SqlConnection con = new SqlConnection(@"Data Source=(localdb)\Projects;Initial Catalog=gamezone;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False");
string q1 = "select * from snakeboard where nickname='" + nickname_s + "'";
con.Open();
SqlCommand cmdc = new SqlCommand(q1, con);
SqlDataReader sr2 = cmdc.ExecuteReader();
if (sr2.Read())
{
sr2.Close();
string qs = "select score from snakeboard where nickname='" + nickname_s + "'";
SqlCommand cmdh = new SqlCommand(qs, con);
SqlDataReader sr5 = cmdh.ExecuteReader();
if (sr5.Read())
{
int a = Convert.ToInt32(sr5["score"]);
if (a < Settings.Score)
{
sr5.Close();
string query = "update snakeboard set score='" + Settings.Score + "' where nickname='" + nickname_s + "' ";
SqlCommand cmde = new SqlCommand(query, con);
if (cmde.ExecuteNonQuery() != 0)
{
MessageBox.Show("score submitted ! ! ");
}
}
}
}
else
{
sr2.Close();
int scrore_final = Convert.ToInt32(Settings.Score);
string query = "insert into snakeboard(nickname,score) values('" + nickname_s + "','" + scrore_final + "')";
SqlCommand cmdd = new SqlCommand(query, con);
if (cmdd.ExecuteNonQuery() != 0)
{
MessageBox.Show("score submitted ! ! ");
}
}
con.Close();
// database part (end ....)
gpanel gc = new gpanel(nickname_s);
this.Close();
gc.Show();
}
private void Form1_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Escape)
{
int final_score = point;
//////// database part start
// database part of scoreboard (staring ....)
SqlConnection con = new SqlConnection(@"Data Source=(localdb)\Projects;Initial Catalog=gamezone;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False");
string q1 = "select * from pingpongboard where nickname='" + nickname_p + "'";
con.Open();
SqlCommand cmdc = new SqlCommand(q1, con);
SqlDataReader sr2 = cmdc.ExecuteReader();
if (sr2.Read())
{
sr2.Close();
string qs = "select score from pingpongboard where nickname='" + nickname_p + "'";
SqlCommand cmdh = new SqlCommand(qs, con);
SqlDataReader sr5 = cmdh.ExecuteReader();
if (sr5.Read())
{
int final_point = Convert.ToInt32(points_lbl.Text);
int a = Convert.ToInt32(sr5["score"]);
if (a < final_point)
{
sr5.Close();
string query = "update pingpongboard set score='" + final_point + "' where nickname='" + nickname_p + "' ";
SqlCommand cmde = new SqlCommand(query, con);
if (cmde.ExecuteNonQuery() != 0)
{
MessageBox.Show("score submitted ! ! ");
}
}
}
}
else
{
sr2.Close();
int final_point = Convert.ToInt32(points_lbl.Text);
string query = "insert into pingpongboard(nickname,score) values('" + nickname_p + "','" + final_point + "')";
SqlCommand cmdd = new SqlCommand(query, con);
if (cmdd.ExecuteNonQuery() != 0)
{
MessageBox.Show("score submitted ! ! ");
}
}
con.Close();
/////// database part end
this.Close();
gpanel g2 = new gpanel(nickname_p);
g2.Show();
}
if (e.KeyCode == Keys.F1)
{
ball.Top = 400;
ball.Left = 400;
speed_left = 4;
speed_top = 4;
point = 0;
points_lbl.Text = "0";
timer1.Enabled = true;
game_over_lbl.Visible = false;
for (int k = j; k > 0; k--)
{
this.shapeContainer1.Shapes.Add(vectRectShape[k - 1]);
this.vectRectShape[k - 1].Visible = true;
}
this.playground.Controls.Add(shapeContainer1);
}
}
