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