public int Insert(MonHocDTO Mh)
{
string sql = "insert into MONHOC values (@MaMon,@TenMon,@HeSo)";
SqlParameter[] sp = new SqlParameter[3];
sp[0] = new SqlParameter("@MaMon", Mh.MaMon);
sp[1] = new SqlParameter("@TenMon", Mh.TenMon);
sp[2] = new SqlParameter("@HeSo",Mh.HeSo);
return conectData.Insert_Update_Delete(sql, sp);
}
public int Update(MonHocDTO Mh)
{
string sql = "update MONHOC set TenMon=@TenMon,HeSo=@HeSo where MaMon=@MaMon";
SqlParameter[] sp = new SqlParameter[3];
sp[0] = new SqlParameter("@MaMon", Mh.MaMon);
sp[1] = new SqlParameter("@TenMon", Mh.TenMon);
sp[2] = new SqlParameter("@HeSo", Mh.HeSo);
return conectData.Insert_Update_Delete(sql, sp);
}