public bool suaLopLoaiHB(DTO_LoaiHocBong pLoaiHB)
{
dbConn.Open();
string cmd = "UPDATE LOAIHOCBONG SET MUCHB=N'" + pLoaiHB.MucHB + "',SOTIEN='" + pLoaiHB.SoTien + "',TENHB='" + pLoaiHB.TenHB + "' WHERE MAHB='" + pLoaiHB.MaHB + "'";
SqlCommand sqlCmd = new SqlCommand(cmd, dbConn);
sqlCmd.ExecuteNonQuery();
dbConn.Close();
return(true);
}
public bool themLoaiHB(DTO_LoaiHocBong pLoaiHB)
{
dbConn.Open();
string cmd = "INSERT INTO LOAIHOCBONG VALUES(N'" + pLoaiHB.MaHB + "',N'" + pLoaiHB.MucHB + "',N'" + pLoaiHB.SoTien + "',N'" + pLoaiHB.TenHB + "')";
SqlCommand sqlCmd = new SqlCommand(cmd, dbConn);
sqlCmd.ExecuteNonQuery();
dbConn.Close();
return(true);
}
private void button4_Click(object sender, EventArgs e)
{
try
{
DTO_LoaiHocBong LoaiHB = new DTO_LoaiHocBong(txtMaHB.Text, txtMucHB.Text, txtSoTien.Text, txtTenHB.Text);
bus_LoaiHB.suaLoaiHB(LoaiHB);
txtMaHB.Text = "";
txtTenHB.Text = "";
txtMucHB.Text = "";
txtSoTien.Text = "";
this.HocBong_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 suaLoaiHB(DTO_LoaiHocBong pLoaiHB)
{
return(dal_LoaiHB.suaLopLoaiHB(pLoaiHB));
}
public bool themLoaiHB(DTO_LoaiHocBong pLoaiHB)
{
return(dal_LoaiHB.themLoaiHB(pLoaiHB));
}
