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)); }