public bool suaLop(LopCoDinh lop)
{
string sql = "update LopCoDinh set tenLopCodinh = N'" + lop.tenLop + "', maKhoa = N'" + lop.maKhoa + "', khoaHoc ='"
+ lop.khoaHoc + "', maGV = N'" + lop.maGV + "' where maLopCoDinh = N'" + lop.maLop + "'";
return(dal.excuteNonQuery(sql));
}
public bool themLop(LopCoDinh lop)
{
string sql = "insert into LopCoDinh(maLopCoDinh, tenLopCoDinh, maKhoa, khoaHoc, maGV) values(N'"
+ lop.maLop + "', N'" + lop.tenLop + "', N'" + lop.maKhoa + "', '"
+ lop.khoaHoc + "', N'" + lop.maGV + "')";
return(dal.excuteNonQuery(sql));
}