private void frmFlappyBird_Load(object sender, EventArgs e)
{
if (strLevel == "Easy")
{
KhoangCach2Thanh = 450;
KhoangCach2Cot = 210;
}
if (strLevel == "Medium")
{
KhoangCach2Thanh = 350;
KhoangCach2Cot = 210;
}
if (strLevel == "Hard")
{
KhoangCach2Thanh = 250;
KhoangCach2Cot = 200;
}
Db.Connection();
UseName = Db.GetAcountUsing(Db.Connec);
maxPoint = Db.MaxScoreFlappyBird(Db.Connec, UseName);
if (maxPoint >= 10)
{
lblMaxPoint.Text = maxPoint + "";
}
else
{
lblMaxPoint.Text = "0" + maxPoint;
}
Db.Connec.Close();
}
private void btnDangNhap_Click(object sender, EventArgs e)
{
if (txtPassword.Text == "")
{
lblPassWordNull.Visible = true;
}
else
{
lblPassWordNull.Visible = false;
}
if (txtUsename.Text == "")
{
lblUseNameNull.Visible = true;
}
else
{
lblUseNameNull.Visible = false;
}
Db.Connection();
string SQL = "SELECT UseName FROM TbDataAccount WHERE UseName='" + txtUsename.Text + "' AND PassWord= '******'";
string SQLRemmemberPassWord = "******" + txtUsename.Text + "' ,'" + txtPassword.Text + "')";
string SQLUser = "******" + txtUsename.Text + "' ,'" + txtPassword.Text + "')";
string SQLREMOVEALL = "DELETE FROM TbRemmemberPassWord";
string SQLREMOVEALLUser = "******";
OleDbCommand Cmd = new OleDbCommand(SQL, Db.Connec);
OleDbCommand Cmd1 = new OleDbCommand(SQLRemmemberPassWord, Db.Connec);
OleDbCommand Cmd2 = new OleDbCommand(SQLREMOVEALL, Db.Connec);
OleDbDataReader ReadDb = Cmd.ExecuteReader();
if (ReadDb.Read())
{
Cmd2.ExecuteNonQuery();
if (chkRememberPass.Checked)
{
Cmd1.ExecuteNonQuery();
}
Cmd2 = new OleDbCommand(SQLREMOVEALLUser, Db.Connec);
Cmd2.ExecuteNonQuery();
Cmd1 = new OleDbCommand(SQLUser, Db.Connec);
Cmd1.ExecuteNonQuery();
Db.Connec.Close();
lblFaillLogin.Visible = false;
this.Hide();
frmMenu frm = new frmMenu();
frm.ShowDialog();
}
else
{
lblFaillLogin.Visible = true;
}
}
private void GetDataTbBlockDrop()
{
Db.Connection();
string SQL = "SELECT * FROM TbBlockDrop";
string strs = "";
OleDbCommand cmd = new OleDbCommand(SQL, Db.Connec);
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
strs = dr["Animal"].ToString();
}
str = strs.Split(new char[] { '-' });
}
private void GameOver()
{
MessageBox.Show("Bạn đạt được số điểm là: " + dem, "Kết thúc", MessageBoxButtons.OK);
Db.Connection();
maxPoint = Db.MaxScoreCharFallOut(Db.Connec, UseName);
if (dem > maxPoint)
{
Db.SaveMaxCharFallOut(Db.Connec, UseName, dem);
}
textBox1.Text = "";
lblChar.Visible = false;
btnChoi.Visible = false;
btnChoiLai.Visible = true;
btnChoiLai.Focus();
Db.Connec.Close();
}
private void frmEggDrop_Load2(object sender, EventArgs e)
{
Db.Connection();
UseName = Db.GetAcountUsing(Db.Connec);
maxPoint = Db.MaxScoreEggDrop(Db.Connec, UseName);
if (maxPoint >= 10)
{
lblMaxPoint.Text = maxPoint + "";
}
else
{
lblMaxPoint.Text = "0" + maxPoint;
}
Db.Connec.Close();
}
private void frmTextFallOut_Load(object sender, EventArgs e)
{
Database Db = new Database();
Db.Connection();
lblUseName.Text = Db.GetAcountUsing(Db.Connec);
frmTextFallOut_Load1(sender, e);
lblChar.Text = "";
btnChoiLai.Visible = false;
}
private void frmIntroduce_Load(object sender, EventArgs e)
{
Db.Connection();
string introduce = Db.Introduce(Db.Connec, IDGame);
lblHuongDan.Visible = true;
lblHuongDan.Text = introduce;
Db.Connec.Close();
}
private void btnDangki_Click(object sender, EventArgs e)
{
Db.Connection();
bool KT = true;
if (txtPassword.Text == "")
{
lblPassWordNull.Visible = true;
KT = false;
}
else
{
lblPassWordNull.Visible = false;
}
if (txtUsename.Text == "")
{
lblUseNameNull.Visible = true;
KT = false;
}
else
{
lblUseNameNull.Visible = false;
}
if (txtPassword.Text != txtPasswordagaint.Text)
{
lblPassWordCompare.Visible = true;
KT = false;
}
else
{
lblPassWordCompare.Visible = false;
}
if (KT)
{
string SQL1 = "INSERT INTO TbDataAccount VALUES('" + txtUsename.Text + "' ,'" + txtPassword.Text + "')";
string SQL2 = "SELECT *FROM TbDataAccount WHERE UseName='" + txtUsename.Text + "'";
OleDbCommand Cmd1 = new OleDbCommand(SQL2, Db.Connec);
OleDbDataReader ReadDb = Cmd1.ExecuteReader();
if (ReadDb.Read())
{
lblUseNameInvalid.Visible = true;
}
else
{
OleDbCommand Cmd2 = new OleDbCommand(SQL1, Db.Connec);
Cmd2.ExecuteNonQuery();
MessageBox.Show("Đăng kí thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
lblUseNameInvalid.Visible = false;
}
Db.Connec.Close();
}
}
private void frmMenu_Load(object sender, EventArgs e)
{
Database Db = new Database();
Db.Connection();
lblUseName.Text = Db.GetAcountUsing(Db.Connec);
btnCharFallOut.Visible = false;
btnFlappyBird.Visible = false;
btnEggDrop.Visible = false;
btnTestABC.Visible = false;
btnTextPractice.Visible = false;
}
private void frmTextFallOut_Load(object sender, EventArgs e)
{
Db.Connection();
string UseName;
UseName = Db.GetAcountUsing(Db.Connec);
int max = Db.MaxScorePointCharFallOut(Db.Connec, UseName);
lblMaxPoint.Text = max + "";
lblChar.Text = "";
btnChoiLai.Visible = false;
}
private void frmTypingTest_Load(object sender, EventArgs e)
{
Db.Connection();
btnChoiLai.Visible = false;
txtTyping.Enabled = false;
string SQL = "SELECT * FROM TbTypingTest WHERE NameSong='Thằng điên'";
OleDbCommand cmd = new OleDbCommand(SQL, Db.Connec);
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
txtTest.Text = dr["Lyrics"].ToString();
}
}
private void frmSpeedTestABC_Load_MaxSpeed(object sender, EventArgs e)
{
Db.Connection();
UseName = Db.GetAcountUsing(Db.Connec);
lblUseName.Text = UseName;
MaxSpeed = Db.MaxScoreSpeedTestABC(Db.Connec, UseName);
if (MaxSpeed >= 60)
{
lblMaxMinute.Text = "0" + (MaxSpeed / 60);
if (MaxSpeed % 60 >= 10)
{
lblMaxSencond.Text = (MaxSpeed % 60).ToString();
}
else
{
lblMaxSencond.Text = (MaxSpeed % 60) + "0";
}
}
else
{
lblMaxMinute.Text = "00";
if (MaxSpeed >= 10)
{
lblMaxSencond.Text = MaxSpeed.ToString();
}
else
{
lblMaxSencond.Text = MaxSpeed + "0";
}
}
Db.Connec.Close();
}
private void frmFlappyBird_Load_1(object sender, EventArgs e)
{
Database Db = new Database();
Db.Connection();
lblUseName.Text = Db.GetAcountUsing(Db.Connec);
frmFlappyBird_Load(sender, e);
yBird = 200;
xBird = 400;
this.KeyPreview = false;
char[] c1 = txtTu.Text.ToCharArray();
char[] c2 = txtDen.Text.ToCharArray();
Random rd1 = new Random();
int a = Convert.ToInt32(c1[0]);
int b = Convert.ToInt32(c2[0]);
lblBird.Text = Convert.ToString((char)rd1.Next(100, 100));
KhoangCach2Cot = 200;
KhoangCach2Thanh = 250;
lblBird.Location = new Point(xBird, yBird);
xCot1 = 900;
xCot2 = xCot1 + lblCotTren1.Width + KhoangCach2Thanh;
xCot3 = xCot2 + lblCotTren1.Width + KhoangCach2Thanh;
Random rd = new Random();
yCotTren1 = rd.Next(-lblCotTren1.Height + KhoangCach2Cot + 10, 0);
yCotTren2 = rd.Next(-lblCotTren1.Height + KhoangCach2Cot + 10, 0);
yCotTren3 = rd.Next(-lblCotTren1.Height + KhoangCach2Cot + 10, 0);
yCotDuoi1 = lblCotDuoi1.Height + KhoangCach2Cot + yCotTren1;
yCotDuoi2 = lblCotDuoi1.Height + KhoangCach2Cot + yCotTren2;
yCotDuoi3 = lblCotDuoi1.Height + KhoangCach2Cot + yCotTren3;
//Cột 1
lblCotTren1.Location = new Point(xCot1, yCotTren1);
lblCotDuoi1.Location = new Point(xCot1, yCotDuoi1);
//Cột 2
lblCotTren2.Location = new Point(xCot2, yCotTren2);
lblCotDuoi2.Location = new Point(xCot2, yCotDuoi2);
//Cột 3
lblCotTren3.Location = new Point(xCot3, yCotTren3);
lblCotDuoi3.Location = new Point(xCot3, yCotDuoi3);
}
private void frmScore_Load(object sender, EventArgs e)
{
Database Db = new Database();
Db.Connection();
string UseName;
UseName = Db.GetAcountUsing(Db.Connec);
lblUseName.Text = Db.GetAcountUsing(Db.Connec);
if (Db.MaxScoreCharFallOut(Db.Connec, UseName) >= 10)
{
lblMaxPointCharFallOut.Text = Db.MaxScoreCharFallOut(Db.Connec, UseName).ToString();
}
else
{
lblMaxPointCharFallOut.Text = "0" + Db.MaxScoreCharFallOut(Db.Connec, UseName).ToString();
}
if (Db.MaxScoreEggDrop(Db.Connec, UseName) >= 10)
{
lblMaxPointEggDrop.Text = Db.MaxScoreEggDrop(Db.Connec, UseName).ToString();
}
else
{
lblMaxPointEggDrop.Text = "0" + Db.MaxScoreEggDrop(Db.Connec, UseName).ToString();
}
if (Db.MaxScoreFlappyBird(Db.Connec, UseName) >= 10)
{
lblMaxPointFlappyBird.Text = Db.MaxScoreFlappyBird(Db.Connec, UseName).ToString();
}
else
{
lblMaxPointFlappyBird.Text = "0" + Db.MaxScoreFlappyBird(Db.Connec, UseName).ToString();
}
lblUseName.Text = Db.GetAcountUsing(Db.Connec);
Db.Connec.Close();
}
private void frmEggDrop_Load(object sender, EventArgs e)
{
Database Db = new Database();
Db.Connection();
lblUseName.Text = Db.GetAcountUsing(Db.Connec);
frmEggDrop_Load2(sender, e);
Score = 0;
Heart = 3;
xBasket = 359;
yBasket = 429;
picBasket.Location = new Point(xBasket, yBasket);
lblScore.Text = "00";
picHeart1.Visible = true;
picHeart2.Visible = true;
picHeart3.Visible = true;
this.KeyPreview = false;
btnChoiLai.Visible = false;
xEgg1 = 20;
xEgg2 = 210;
xEgg3 = 400;
xEgg4 = 590;
xEgg5 = 780;
yEgg1 = yEgg2 = yEgg3 = yEgg4 = yEgg5 = 0 - picEgg1.Height;
picEgg1.Location = new Point(xEgg1, yEgg1);
picEgg2.Location = new Point(xEgg2, yEgg2);
picEgg3.Location = new Point(xEgg3, yEgg3);
picEgg4.Location = new Point(xEgg4, yEgg4);
picEgg5.Location = new Point(xEgg5, yEgg5);
lblLeft.Text = Convert.ToString((char)rd.Next(98, 122));
lblRight.Text = Convert.ToString((char)rd.Next(98, 122));
while (lblLeft.Text == lblRight.Text)
{
lblRight.Text = Convert.ToString((char)rd.Next(98, 122));
}
}
private void frmMenu_Load(object sender, EventArgs e)
{
Database Db = new Database();
Db.Connection();
cmbGame.SelectedIndex = 0;
lblUseName.Text = Db.GetAcountUsing(Db.Connec);
lblLevel.Visible = false;
btnCharFallOut.Visible = false;
btnFlappyBird.Visible = false;
btnEggDrop.Visible = false;
btnTestABC.Visible = false;
cmbGame.Visible = false;
btnTextPractice.Visible = false;
btnBlockDrop.Visible = false;
cmbTestABC.Visible = false;
cmbTextPractice.Visible = false;
Db.Connec.Close();
}
private void frmRank_Load(object sender, EventArgs e)
{
Db.Connection();
string UseName = Db.GetAcountUsing(Db.Connec);
lblUseName.Text = UseName;
string sql;
if (strName == "PointTestABC")
{
sql = "SELECT UseName , " + strName + " FROM TbDataAccount ORDER BY " + strName + " ASC ";
}
else
{
sql = "SELECT UseName , " + strName + " FROM TbDataAccount ORDER BY " + strName + " DESC ";
}
OleDbDataAdapter da = new OleDbDataAdapter(sql, Db.Connec);
DataTable dt = new DataTable();
da.Fill(dt);
da.Dispose();
dgvRank.DataSource = dt;
for (int i = 0; i < dgvRank.Rows.Count; i++)
{
dgvRank.Rows[i].Cells[0].Value = i + 1;
}
int index = 0;
for (int i = 0; i < dgvRank.Rows.Count; i++)
{
if (dgvRank.Rows[i].Cells[1].Value.ToString() == UseName)
{
index = i; break;
}
}
dgvRank.Rows[index].DefaultCellStyle.BackColor = Color.Yellow; dgvRank.Rows[0].Selected = false;
Db.Connec.Close();
}
private void frmScore_Load(object sender, EventArgs e)
{
Db.Connection();
UseName = Db.GetAcountUsing(Db.Connec);
lblUseName.Text = Db.GetAcountUsing(Db.Connec);
if (Db.MaxScoreCharFallOut(Db.Connec, UseName) >= 10)
{
lblMaxPointCharFallOut.Text = Db.MaxScoreCharFallOut(Db.Connec, UseName).ToString();
}
else
{
lblMaxPointCharFallOut.Text = "0" + Db.MaxScoreCharFallOut(Db.Connec, UseName).ToString();
}
if (Db.MaxScoreEggDrop(Db.Connec, UseName) >= 10)
{
lblMaxPointEggDrop.Text = Db.MaxScoreEggDrop(Db.Connec, UseName).ToString();
}
else
{
lblMaxPointEggDrop.Text = "0" + Db.MaxScoreEggDrop(Db.Connec, UseName).ToString();
}
if (Db.MaxScoreFlappyBird(Db.Connec, UseName) >= 10)
{
lblMaxPointFlappyBird.Text = Db.MaxScoreFlappyBird(Db.Connec, UseName).ToString();
}
else
{
lblMaxPointFlappyBird.Text = "0" + Db.MaxScoreFlappyBird(Db.Connec, UseName).ToString();
}
if (Db.MaxScoreBlockDrop(Db.Connec, UseName) >= 10)
{
lblMaxPointBlockDrop.Text = Db.MaxScoreBlockDrop(Db.Connec, UseName).ToString();
}
else
{
lblMaxPointBlockDrop.Text = "0" + Db.MaxScoreBlockDrop(Db.Connec, UseName).ToString();
}
if (Db.MaxScoreTypingTest(Db.Connec, UseName) >= 10)
{
lblFastestSpeedTestPractice.Text = Db.MaxScoreTypingTest(Db.Connec, UseName).ToString();
}
else
{
lblFastestSpeedTestPractice.Text = "0" + Db.MaxScoreTypingTest(Db.Connec, UseName).ToString();
}
int MaxSpeed = Db.MaxScoreSpeedTestABC(Db.Connec, UseName);
if (MaxSpeed >= 60)
{
lblMaxMinuteTestABC.Text = "0" + (MaxSpeed / 60);
if (MaxSpeed % 60 >= 10)
{
lblMaxSecondTestABC.Text = (MaxSpeed % 60).ToString();
}
else
{
lblMaxSecondTestABC.Text = (MaxSpeed % 60) + "0";
}
}
else
{
lblMaxMinuteTestABC.Text = "00";
if (MaxSpeed >= 10)
{
lblMaxSecondTestABC.Text = MaxSpeed.ToString();
}
else
{
lblMaxSecondTestABC.Text = MaxSpeed + "0";
}
}
Db.Connec.Close();
}
private void frmTypingTest_Load(object sender, EventArgs e)
{
Db.Connection();
if (strTime == "1 minute")
{
minute = 1;
second = 0;
}
if (strTime == "5 minute")
{
minute = 5;
second = 0;
}
if (strTime == "10 minute")
{
minute = 10;
second = 0;
}
if (minute >= 10)
{
lblMinute.Text = minute + "";
}
else
{
lblMinute.Text = "0" + minute;
}
Db.Connection();
UseName = Db.GetAcountUsing(Db.Connec);
lblUseName.Text = UseName;
FastestSpeed = Db.MaxScoreTypingTest(Db.Connec, UseName);
if (FastestSpeed >= 10)
{
lblFastestSpeed.Text = FastestSpeed + "";
}
else
{
lblFastestSpeed.Text = "0" + FastestSpeed;
}
frmTypingTest_Load_KePreviewFalse(sender, e);
txtTypingTest.Focus();
txtTypingTest.Clear();
txtTypingTest.Enabled = false;
btnChoiLai.Visible = false;
string SQL = "SELECT NameSong FROM TbTypingTest";
OleDbCommand cmd = new OleDbCommand(SQL, Db.Connec);
OleDbDataAdapter da = new OleDbDataAdapter(SQL, Db.Connec);
DataSet ds = new DataSet();
da.Fill(ds);
cmd.ExecuteNonQuery();
cmdTypingTest.DisplayMember = ds.Tables[0].Columns[0].ToString();
cmdTypingTest.DataSource = ds.Tables[0];
Db.Connec.Close();
}
