public bool delete(thanhphodto thanhpho)
{
string delete = string.Format("delete from THANHPHO where MATP= @matp");
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("@matp", SqlDbType.NVarChar, 15);
sqlParameters[0].Value = thanhpho.Mathanhpho;
return(conn.executeDeleteQuery(delete, sqlParameters));
}
public bool update(thanhphodto thanhpho)
{
string update = string.Format("update THANHPHO SET TENTP = @tentp WHERE MATP = @matp");
SqlParameter[] sqlParameters = new SqlParameter[2];
sqlParameters[0] = new SqlParameter("@tentp", SqlDbType.NVarChar, 100);
sqlParameters[0].Value = Convert.ToString(thanhpho.Tenthanhpho);
sqlParameters[1] = new SqlParameter("@matp", SqlDbType.NVarChar, 15);
sqlParameters[1].Value = Convert.ToString(thanhpho.Mathanhpho);
return(conn.executeUpdateQuery(update, sqlParameters));
}
public bool add(thanhphodto thanhpho)
{
string insert = string.Format("insert into THANHPHO (MATP,TENTP) values (@matp,@tentp)");
SqlParameter[] sqlParameters = new SqlParameter[2];
sqlParameters[0] = new SqlParameter("@matp", SqlDbType.NVarChar, 15);
sqlParameters[0].Value = Convert.ToString(thanhpho.Mathanhpho);
sqlParameters[1] = new SqlParameter("@tentp", SqlDbType.NVarChar, 100);
sqlParameters[1].Value = Convert.ToString(thanhpho.Tenthanhpho);
return(conn.executeInsertQuery(insert, sqlParameters));
}
public bool delete(thanhphodto thanhpho)
{
return(tpd.delete(thanhpho));
}
public bool update(thanhphodto thanhpho)
{
return(tpd.update(thanhpho));
}
public bool add(thanhphodto thanhpho)
{
return(tpd.add(thanhpho));
}
