public bool suaSVHB(DTO_SVHocBong pHB)
{
dbConn.Open();
string cmd = "UPDATE LOP SET MAHB=N'" + pHB.MaHB + "',MASV='" + pHB.MaSV + "',HOCKY='" + pHB.HocKy + "' WHERE MAHB='" + pHB.MaHB + "' and MASV='" + pHB.MaSV + "' and HOCKY='" + pHB.HocKy + "'";
SqlCommand sqlCmd = new SqlCommand(cmd, dbConn);
sqlCmd.ExecuteNonQuery();
dbConn.Close();
return(true);
}
public bool themSVHB(DTO_SVHocBong pHB)
{
dbConn.Open();
string cmd = "INSERT INTO HOCBONG VALUES(N'" + pHB.MaHB + "',N'" + pHB.MaSV + "',N'" + pHB.HocKy + "')";
SqlCommand sqlCmd = new SqlCommand(cmd, dbConn);
sqlCmd.ExecuteNonQuery();
dbConn.Close();
return(true);
}
private void btnSua_Click(object sender, EventArgs e)
{
try
{
DTO_SVHocBong svHB = new DTO_SVHocBong(combMaHB.SelectedValue.ToString(), txtMaSV.Text, txtHocKy.Text);
bus_HB.suaSVHB(svHB);
combMaHB.Text = "--Chọn--";
txtMaSV.Text = "";
txtHocKy.Text = "";
this.svHocBong_Load(sender, e);
}
catch
{
MessageBox.Show("Sửa không thành công. Vui lòng kiểm tra lại", "Thông báo");
}
}
public bool suaSVHB(DTO_SVHocBong pSVHB)
{
return(dal_SVHB.suaSVHB(pSVHB));
}
public bool themSVHB(DTO_SVHocBong pSVHB)
{
return(dal_SVHB.themSVHB(pSVHB));
}