private void btnThemDiem_Click(object sender, EventArgs e)
{
DiemTKHK d = new DiemTKHK(txtMaDiem.Text, null);
NamHoc n = new NamHoc(null, txtNamHoc.Text);
HocKy hk = new HocKy(null, cbbHocKy.Text, null);
HocSinh h = new HocSinh(txtMaHS.Text, null, null, DateTime.MinValue, null, null, null, null, null, null, null);
if (txtMaHS.Text != "" && txtNamHoc.Text != "" && cbbHocKy.Text != "" && txtMaDiem.Text != "")
{
if (cd.themdiemTKHKCTHS(d, h, n, hk))
{
MessageBox.Show("Thêm thành công");
dgvHienThiCT.DataSource = cd.hienthiDiemTKHKCTHS(n, hk, h);
}
}
else
{
MessageBox.Show("vui lòng nhập đầy đủ thông tin");
}
}
public bool themdiemTKHKCTHS(DiemTKHK d, HocSinh h, NamHoc n, HocKy hk)
{
try
{
conn.Open();
string SQL = string.Format("exec themdiemTKHKCTHS '" + d.MaDiem + "', '" + h.Mahs + "', N'" + n.TenNH + "', N'" + hk.TenHK + "'");
SqlCommand cmd = new SqlCommand(SQL, conn);
int kq = (int)cmd.ExecuteNonQuery();
if (kq > 0)
{
return(true);
}
}
catch
{
}
finally
{
conn.Close();
}
return(false);
}
public bool themdiemTKHKCTHS(DiemTKHK d, HocSinh h, NamHoc n, HocKy hk)
{
return(cnd.themdiemTKHKCTHS(d, h, n, hk));
}
