//Xoa du lieu
public void delHocsinh(EC_tblHocsinh et)
{
bus.delHocsinh(et);
}
//Sua du lieu
public void updateHocsinh(EC_tblHocsinh et)
{
bus.updateHocsinh(et);
}
public void addHocsinh(EC_tblHocsinh et)
{
bus.addHocsinh(et);
}
//Xoa du lieu
public void delHocsinh(EC_tblHocsinh et)
{
cn.ThucThiCauLenhSQL(@"DELETE FROM tblHocsinh WHERE MaHS = '" + et.MaHS + "'");
}
//Sua du lieu
public void updateHocsinh(EC_tblHocsinh et)
{
cn.ThucThiCauLenhSQL(@"UPDATE tblHocsinh SET Ho = N'"+ et.Ho + "', Ten ='" + et.Ten + "', GT ='" + et.GT + "', NgaySinh =N'" + et.NgaySinh + "', DiaChi ='" + et.DiaChi + "', DanToc =N'" + et.DanToc + "', TonGiao =N'" + et.TonGiao + "'where MaHS = '" + et.MaHS + "'");
}
//Them du lieu
public void addHocsinh(EC_tblHocsinh et)
{
cn.ThucThiCauLenhSQL(@"INSERT INTO tblHocsinh ( MaHS, Ho, Ten, GT,MaLop, NgaySinh, DiaChi, DanToc, TonGiao)
values (N'" + et.MaHS + "',N'" + et.Ho + "',N'" + et.Ten + "',N'" + et.GT + "', '" + et.MaLop + "' ,N'" + et.NgaySinh + "',N'" + et.DiaChi + "',N'" + et.DanToc + "',N'" + et.TonGiao + "')");
}
