private void button2_Click(object sender, EventArgs e)
{
string db, sql1;
db = "\\chess.mdb";
sql1 = (" SELECT TOP 5 * FROM winerstowplayers order by mintetime ;");
dataGridView2.DataSource = Dbase.SelectFromTable(sql1, db);
}
private void exitToolStripMenuItem_Click(object sender, EventArgs e)
{
timer1.Stop();
timer2.Stop();
string sql1, sql2, sql3, inser1, inser2, inser3, stmatcom, wt, db, winername;
int x1, x2, x3, resulttime;
Form1 f1 = new Form1();
stmatcom = f1.convertmat(mat);
db = "\\chess.mdb";
sql1 = "select max (id_user) from users";
x1 = idselect.selectid(sql1, db);
sql2 = "select max (a) from hhh";
x2 = idselect.selectid(sql2, db);
inser1 = "INSERT INTO users(id_user,fname,lname,id_game,colorGame,Date_Game,id_gmaecomputer) VALUES (" + x1 + ",'" + fname + "','" + lname + "'," + 0 + "," + colorplay + ",'" + date + "'," + x2 + ")";
Dbase.ChangeTable(inser1, db);
inser2 = "insert into hhh(a,b,c,d,e,f,g,h,i,j)values (" + x2 + "," + x1 + ",'" + level + "','" + stmatcom + "','" + label2.Text + "','" + label1.Text + "'," + x2 + ",'" + label5.Text + "','" + lossw + "','" + lossb + "')";
Dbase.SelectFromTable(inser2, db);
if (savegame == false)
{
if (winer == 1)
{
wt = label2.Text;
}
else
{
wt = label1.Text;
}
resulttime = f1.cnvrtnum(wt);
if (winer == 3)
{
winername = "draw";
}
else
{
if (winer == colorplay)
{
winername = fname;
}
else
{
winername = "Computer";
}
}
sql3 = "select max (id_winercomputer) from winerstocomputer";
x3 = idselect.selectid(sql3, db);
inser3 = "INSERT INTO winerstocomputer(id_winercomputer,id_user,fname,time_winer,id_gmaecomputer,result,minttime) VALUES ('" + x3 + "','" + x1 + "','" + fname + "','" + wt + "','" + x2 + "','" + winername + "','" + resulttime + "')";
Dbase.ChangeTable(inser3, db);
}
}
public static int selectid(string sql, string db)
{
int x1;
try
{
x1 = int.Parse(Dbase.SelectFromTable(sql, db).Rows[0][0].ToString());
x1 = x1 + 1;
}
catch (Exception)
{
x1 = 0;
}
return(x1);
}
// פונקציה הזות הופכת מערך דו מימדי למחרוזת
private void button5_Click(object sender, EventArgs e)
{
string wt;
if (winer == 1)
{
wt = label9.Text;
}
else
{
wt = label7.Text;
}
string str = "\\chess.accdb";
string sql = "INSERT INTO winerstowplayers(id_winertowplayers,id_user,fname,time_winer,id_gametowplayers,result) VALUES ('" + 12 + "','" + 51 + "','" + fname + "','" + wt + "','" + 2 + "','" + result + "')";
Dbase.ChangeTable(sql, str);
}
private void button1_Click(object sender, EventArgs e)
{
string db = "\\chess.mdb";
string sql = ("Select * from users" + " where fname ='" + textBox1.Text + "';");
dataGridView1.DataSource = Dbase.SelectFromTable(sql, db);
if (radioButton1.Checked == true)
{
playwithcomputer = true;
}
else if (radioButton2.Checked == true)
{
playwithcomputer = false;
}
else
{
MessageBox.Show("chosse kind of game");
}
}
private void exitToolStripMenuItem_Click(object sender, EventArgs e)
{
timer1.Stop();
timer2.Stop();
int x1, x2, x3, x4, resutmin;
string db, sql1, sql2, sql3, inser1, inser2, inser3, stmat, wt, winername;
stmat = convertmat(mat);
db = "\\chess.mdb";
sql1 = "select max (id_user) from users";
try
{
x1 = int.Parse(Dbase.SelectFromTable(sql1, db).Rows[0][0].ToString());
x1 = x1 + 1;
}
catch (Exception)
{
x1 = 0;
}
sql2 = "select max (id_gametowply) from gamepp";
try
{
x2 = int.Parse(Dbase.SelectFromTable(sql2, db).Rows[0][0].ToString());
x2 = x2 + 1;
}
catch (Exception)
{
x2 = 0;
}
inser1 = "INSERT INTO users(id_user,fname,lname,id_game,colorGame,Date_Game,id_gmaecomputer) VALUES (" + x1 + ",'" + fname + "','" + lname + "'," + x2 + "," + colorplay + ",'" + date + "'," + 0 + ")";
Dbase.SelectFromTable(inser1, db);
x4 = idselect.selectid(sql1, db);
inser2 = "insert into gamepp(id_gametowply,id_user1,matofGame,time_white,time_black,history_of_steps,id_user2,Chess_piecesw,Chess_piecesb)values ('" + x2 + "','" + x1 + "','" + stmat + "','" + label7.Text + "','" + label9.Text + "','" + label5.Text + "','" + 0 + "','" + lossw + "','" + lossb + "')";
Dbase.ChangeTable(inser2, db);
if (savegame == false)
{
sql3 = "select max (id_winertowplayers) from winerstowplayers";
try
{
x3 = int.Parse(Dbase.SelectFromTable(sql3, db).Rows[0][0].ToString());
x3 = x3 + 1;
}
catch (Exception)
{
x3 = 0;
}
if (winer == 1)
{
wt = label9.Text;
}
else
{
wt = label7.Text;
}
resutmin = cnvrtnum(wt);
if (winer == 3)
{
winername = "draw";
}
else
{
if (winer == colorplay)
{
winername = fname;
}
else
{
winername = "No" + fname;
}
}
inser3 = "INSERT INTO winerstowplayers(id_winertowplayers,id_user,fname,time_winer,id_gametowplayers,result,mintetime) VALUES ('" + x3 + "','" + x1 + "','" + fname + "','" + wt + "','" + x2 + "','" + winername + "','" + resutmin + "')";
Dbase.ChangeTable(inser3, db);
}
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
int i = e.RowIndex;
int id;
string db = "\\chess.mdb";
DataGridViewRow roww = dataGridView1.Rows[i];
colorplay = int.Parse(roww.Cells[4].Value.ToString());
if (playwithcomputer == false)
{
id = int.Parse(roww.Cells[3].Value.ToString());
}
else
{
id = int.Parse(roww.Cells[6].Value.ToString());
}
//label2.Text = id.ToString();
if (playwithcomputer == false)
{
string sql1 = ("Select * from gamepp" + " where id_gametowply =" + id + ";");
getmat = Dbase.SelectFromTable(sql1, db).Rows[0][2].ToString();
replaymat(getmat);
timew = Dbase.SelectFromTable(sql1, db).Rows[0][3].ToString();
timw = timew;
timeb = Dbase.SelectFromTable(sql1, db).Rows[0][4].ToString();
timb = timeb;
gsteps = Dbase.SelectFromTable(sql1, db).Rows[0][5].ToString();
step2p = gsteps;
pacisew = Dbase.SelectFromTable(sql1, db).Rows[0][7].ToString();
setpacess(pacisew, -1);
pacieb = Dbase.SelectFromTable(sql1, db).Rows[0][8].ToString();
setpacess(pacieb, 1);
putmat.pushmat = reeemat;
putmat.check = 1;
putmat.pushpace = pac;
putmat.checkpace = 1;
// label7.Text = "";
// for(int y=0;y<putmat.pushpace.Length;y++)
// label7.Text+= putmat.pushpace[y].ToString();
Form1 f1 = new Form1();
f1.Show();
this.Hide();
}
else
{
string sql2 = ("Select * from hhh" + " where a =" + id + ";");
level = Dbase.SelectFromTable(sql2, db).Rows[0][2].ToString();
getmat = Dbase.SelectFromTable(sql2, db).Rows[0][3].ToString();
replaymat(getmat);
timew = Dbase.SelectFromTable(sql2, db).Rows[0][4].ToString();
timw = timew;
timeb = Dbase.SelectFromTable(sql2, db).Rows[0][5].ToString();
timb = timeb;
gsteps = Dbase.SelectFromTable(sql2, db).Rows[0][7].ToString();
step1p = gsteps;
pacisew = Dbase.SelectFromTable(sql2, db).Rows[0][8].ToString();
setpacess(pacisew, -1);
pacieb = Dbase.SelectFromTable(sql2, db).Rows[0][9].ToString();
setpacess(pacieb, 1);
putmat.pushmat = reeemat;
putmat.pushpace = pac;
putmat.checkpace = 2;
if (level == "diffuclt")
{
putmat.check = 3;
Form2 f2 = new Form2();
f2.Show();
this.Hide();
}
else
{
putmat.check = 2;
Form8 f8 = new Form8();
f8.Show();
this.Hide();
}
}
int[,] gg = new int[2, 16];
}
