public bool Xoa(XepLoaiInfo xeploai) { SqlCommand com = new SqlCommand("Delete XEPLOAI where MAXEPLOAI=@ma"); com.Parameters.Add("@ma", SqlDbType.Int).Value = xeploai.MaXepLoai; try { ser.Load(com); return(true); } catch (Exception e) { e.ToString(); return(false); } }
private void btnCapNhat_Click(object sender, EventArgs e) { XepLoaiInfo nam = new XepLoaiInfo(); nam.MaXepLoai = Convert.ToInt32(txtMa.Text); nam.TenXepLoai = txtTen.Text; nam.DiemCanTren = Convert.ToDecimal(txtCanTren.Text); nam.DiemCanDuoi = Convert.ToDecimal(txtCanDuoi.Text); if (Adding) { control.ThemXepLoai(nam); Adding = false; } else { if (Deleting) { control.XoaXepLoai(nam); Deleting = false; } else { if (Updating) { control.SuaXepLoai(nam); Updating = false; } } } // btnThem.Enabled = true; btnXoa.Enabled = true; btnSua.Enabled = true; btnBoQua.Visible = false; btnCapNhat.Enabled = false; // txtMa.Enabled = false; txtTen.Enabled = false; txtCanTren.Enabled = false; txtCanDuoi.Enabled = false; dataDSXepLoai.Enabled = true; // control.HienThi(dataDSXepLoai, binXepLoai, txtMa, txtTen, txtCanTren, txtCanDuoi); }
public bool Sua(XepLoaiInfo xeploai) { SqlCommand com = new SqlCommand("Update XEPLOAI set TENXEPLOAI=@ten, DIEMCANTREN=@cantren, DIEMCANDUOI=@canduoi where MACAP=@ma"); com.Parameters.Add("@ma", SqlDbType.Int).Value = xeploai.MaXepLoai; com.Parameters.Add("@ten", SqlDbType.NVarChar, 30).Value = xeploai.TenXepLoai; com.Parameters.Add("@cantren", SqlDbType.Decimal).Value = xeploai.DiemCanTren; com.Parameters.Add("@canduoi", SqlDbType.Decimal).Value = xeploai.DiemCanDuoi; try { ser.Load(com); return(true); } catch (Exception e) { e.ToString(); return(false); } }
public bool Them(XepLoaiInfo xeploai) { SqlCommand com = new SqlCommand("Insert into XEPLOAI(MAXEPLOAI,TENXEPLOAI,DIEMCANTREN,DIEMCANDUOI) values(@ma,@ten,@cantren,@canduoi)"); com.Parameters.Add("@ma", SqlDbType.Int).Value = xeploai.MaXepLoai; com.Parameters.Add("@ten", SqlDbType.NVarChar, 30).Value = xeploai.TenXepLoai; com.Parameters.Add("@cantren", SqlDbType.Decimal).Value = xeploai.DiemCanTren; com.Parameters.Add("@canduoi", SqlDbType.Decimal).Value = xeploai.DiemCanDuoi; try { ser.Load(com); return(true); } catch (Exception e) { e.ToString(); return(false); } }
public abstract void UpdateXepLoai(XepLoaiInfo _xepLoaiInfo);
public abstract int InsertXepLoai(XepLoaiInfo _xepLoaiInfo);
public void SuaXepLoai(XepLoaiInfo nam) { Data.SuaXepLoai(nam); }
public void XoaXepLoai(XepLoaiInfo nam) { Data.XoaXepLoai(nam); }
public void ThemXepLoai(XepLoaiInfo nam) { Data.ThemXepLoai(nam); }