/// <summary>
/// Delete an entry from the PostalCode table
/// </summary>
public static bool Delete(int postalCode)
{
Int32 rowsAffected = 0;
SqlConnection cn = GetConnection();
ZipCode zipCode = Get(cn, postalCode);
if (zipCode != null)
{
using (SqlCommand sqlCmd = cn.CreateCommand())
{
sqlCmd.CommandText = "DELETE FROM ZipCode WHERE ZipCodePostalCode=" + postalCode;
rowsAffected = sqlCmd.ExecuteNonQuery();
}
}
FinishedWithConnection(cn);
return(rowsAffected != 0);
}
/// <summary>
/// Add a new entry to the PostalCode table
/// </summary>
public static ZipCode Add(int postalCode, int cityId)
{
ZipCode result = null;
SqlConnection cn = GetConnection();
using (SqlCommand sqlCmd = cn.CreateCommand())
{
sqlCmd.CommandText = "INSERT INTO ZipCode (ZipCodePostalCode, ZipCodeZipCodeCityId) VALUES (@ZipCodePostalCode, @ZipCodeZipCodeCityId)";
BuildSqlParameter(sqlCmd, "@ZipCodePostalCode", SqlDbType.Int, postalCode);
BuildSqlParameter(sqlCmd, "@ZipCodeZipCodeCityId", SqlDbType.Int, cityId);
if (sqlCmd.ExecuteNonQuery() > 0)
{
result = new ZipCode(postalCode, cityId);
}
}
FinishedWithConnection(cn);
return(result);
}
public bool Update()
{
return(ZipCode.Update(this));
}