//ham sua CT dao tao
public bool SuaCTDaoTao(CTDaoTao cTDaoTao)
{
string sql = "Update CTDaoTao set maLop = @maLop, maHP = @maHP, hocKyNamHoc = @hocKyNamHoc where maLop = @maLop and maHP = @maHP";
SqlParameter[] sqlParameters =
{
new SqlParameter("@maLop", cTDaoTao.maLop),
new SqlParameter("@maHP", cTDaoTao.maHP),
new SqlParameter("@hocKyNamHoc", cTDaoTao.hocKyNamHoc)
};
return(dal.myExecute(sql, sqlParameters));
}
//ham xoa CTDaoTao
public bool XoaCTDaoTao(CTDaoTao cTDaoTao)
{
string sql = "delete CTDaoTao where maLop = @maLop and maHP = @maHP and hocKyNamHoc = @hocKyNamHoc";
SqlParameter[] sqlParameters =
{
new SqlParameter("@maLop", cTDaoTao.maLop),
new SqlParameter("@maHP", cTDaoTao.maHP),
new SqlParameter("@hocKyNamHoc", cTDaoTao.hocKyNamHoc)
};
return(dal.myExecute(sql, sqlParameters));
}
//ham them CT dao tao
public bool ThemCTDaoTao(CTDaoTao cTDaoTao)
{
string sql = "insert into CTDaoTao(maLop, maHP, hocKyNamHoc)" + "values (@maLop, @maHP, @hocKyNamHoc)";
SqlParameter[] sqlParameters =
{
new SqlParameter("@maLop", cTDaoTao.maLop),
new SqlParameter("@maHP", cTDaoTao.maHP),
new SqlParameter("@hocKyNamHoc", cTDaoTao.hocKyNamHoc)
};
return(dal.myExecute(sql, sqlParameters));
}
