public int Insert(HocKyDTO Hk)
{
string sql = "insert into HOCKY values (@MaHK,@HocKy,@MaNam)";
SqlParameter[] sp = new SqlParameter[3];
sp[0] = new SqlParameter("@MaHK", Hk.MaHK);
sp[1] = new SqlParameter("@HocKy", Hk.Ten_HocKy);
sp[2] = new SqlParameter("@MaNam", Hk.MaNam);
return conectData.Insert_Update_Delete(sql, sp);
}
public int Update(HocKyDTO Hk)
{
string sql = "update HOCKY set HocKy=@HocKy,MaNam=@MaNam where MaHK=@MaHK";
SqlParameter[] sp = new SqlParameter[3];
sp[0] = new SqlParameter("@MaHK", Hk.MaHK);
sp[1] = new SqlParameter("@HocKy", Hk.Ten_HocKy);
sp[2] = new SqlParameter("@MaNam", Hk.MaNam);
return conectData.Insert_Update_Delete(sql, sp);
}