private void frmBlockDrop_Load(object sender, EventArgs e)
{
this.KeyPreview = false;
GetDataTbBlockDrop();
SetTextLabelMain();
Db.Connection();
UseName = Db.GetAcountUsing(Db.Connec);
lblUseName.Text = UseName;
MaxPoint = Db.MaxScoreBlockDrop(Db.Connec, UseName);
if (MaxPoint >= 10)
{
lblMaxPoint.Text = MaxPoint + "";
}
else
{
lblMaxPoint.Text = "0" + MaxPoint;
}
lbl1.Visible = false;
lbl2.Visible = false;
lbl3.Visible = false;
lbl4.Visible = false;
lbl5.Visible = false;
lbl6.Visible = false;
lbl7.Visible = false;
lblMain.Visible = false;
btnChoi.Visible = true;
btnChoiLai.Visible = false;
}
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 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 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 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 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 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 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 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 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();
}
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();
}
