private void btnTinhdiem_Click(object sender, EventArgs e)
{
string sql;
double Diem = 0, BanThangDN, BanThangDK;
BanThangDK = Convert.ToDouble(DAO.GetFieldValues("select sobanthuadoinha from trandau where matrandau = N'" + txtMaTran.Text + "'"));
BanThangDN = Convert.ToDouble(DAO.GetFieldValues("select sobanthangdoinha from trandau where matrandau = N'" + txtMaTran.Text + "'"));
//Diem = Convert.ToDouble(DAO.GetFieldValues("select diem from doibong where diem = N'" + txtDiem.Text + "'"));
if (BanThangDN > BanThangDK)
{
Diem = Diem + 3;
}
else if (BanThangDN == BanThangDK)
{
Diem = Diem + 1;
}
DAO.OpenConnection();
sql = "UPDATE CapNhatĐB SET diem =" + Diem + " WHERE madoi = N'" + cmbMaDoiNha.SelectedValue + "'";
sql = "UPDATE CapNhatĐB SET diem =" + Diem + " WHERE madoi = N'" + cmbMaDoiKhach.SelectedValue + "'";
txtDiem.Text = Diem.ToString();
DAO.LoadDataToTable(sql);
LoadDataToGrivew();
DAO.CloseConnetion();
}
