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);
}
}
// פונקציה הזות הופכת מערך דו מימדי למחרוזת
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 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);
}
}
