public bool Delete(BanCanSu bancansu)
{
string query = "DELETE FROM BanCanSu " +
"WHERE MaSV=@MaSV";
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("@MaSV", SqlDbType.VarChar);
sqlParameters[0].Value = bancansu.MaSV;
return(executeDeleteQuery(query, sqlParameters));
}
public bool Insert(BanCanSu bancansu)
{
string query = "INSERT INTO BanCanSu (MaSV,ChucVu) " +
"VALUES (@MaSV,@ChucVu)";
SqlParameter[] sqlParameters = new SqlParameter[2];
sqlParameters[0] = new SqlParameter("@MaSV", SqlDbType.VarChar);
sqlParameters[0].Value = bancansu.MaSV;
sqlParameters[1] = new SqlParameter("@ChucVu", SqlDbType.NVarChar);
sqlParameters[1].Value = bancansu.ChucVu;
return(executeInsertQuery(query, sqlParameters));
}
public bool Update(BanCanSu bancansu)
{
string query = "UPDATE BanCanSu " +
"SET ChucVu=@ChucVu " +
"WHERE MaSV=@MaSV";
SqlParameter[] sqlParameters = new SqlParameter[2];
sqlParameters[0] = new SqlParameter("@MaSV", SqlDbType.VarChar);
sqlParameters[0].Value = bancansu.MaSV;
sqlParameters[1] = new SqlParameter("@ChuVu", SqlDbType.NVarChar);
sqlParameters[1].Value = bancansu.ChucVu;
return(executeUpdateQuery(query, sqlParameters));
}
public bool Sua(BanCanSu banCanSu)
{
bool result = false;
return(result);
}
