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