public static void UpdateAddress(Address address)
{
string sqlQuery = "UPDATE Address SET CountryID=@CountryID, CityID=@CityID, Street=@Street, ZipCode=@ZipCode, HouseNr=@HouseNr, ApartmentNr=@AparmentNr WHERE AddressID=" + address.AddressID;
Database db = new SqlDatabase(DBHelper.GetConnectionString());
DbCommand dbCommand = db.GetSqlStringCommand(sqlQuery);
db.AddInParameter(dbCommand, "CountryID", DbType.Int32, address.CountryID);
db.AddInParameter(dbCommand, "CityID", DbType.String, address.City.CityID);
db.AddInParameter(dbCommand, "Street", DbType.String, address.Street);
db.AddInParameter(dbCommand, "ZipCode", DbType.String, address.ZipCode);
db.AddInParameter(dbCommand, "HouseNr", DbType.String, address.HouseNr);
db.AddInParameter(dbCommand, "ApartmentNr", DbType.String, address.ApartmentNr);
db.AddInParameter(dbCommand, "AddressID", DbType.Int32, address.AddressID);
db.ExecuteNonQuery(dbCommand);
}
public static Address InsertAddress(Address address)
{
string sqlQuery = "INSERT INTO Address(CountryID,CityID,Street,ZipCode,HouseNr,ApartmentNr) " +
" VALUES(@CountryID,@CityID,@Street,@ZipCode,@HouseNr,@ApartmentNr);SELECT @@Identity";
Database db = new SqlDatabase(DBHelper.GetConnectionString());
DbCommand dbCommand = db.GetSqlStringCommand(sqlQuery);
db.AddInParameter(dbCommand, "CountryID", DbType.Int32, address.CountryID);
db.AddInParameter(dbCommand, "CityID", DbType.Int32, address.CityID);
db.AddInParameter(dbCommand, "Street", DbType.String, address.Street);
db.AddInParameter(dbCommand, "ZipCode", DbType.String, address.ZipCode);
db.AddInParameter(dbCommand, "HouseNr", DbType.String, address.HouseNr);
db.AddInParameter(dbCommand, "ApartmentNr", DbType.String, address.ApartmentNr);
address.AddressID = Convert.ToInt32(db.ExecuteScalar(dbCommand));
return address;
}
private static Address GetAddressFromReader(IDataReader dataReader)
{
Address address = new Address();
address.AddressID = DBHelper.GetInt(dataReader, "AddressID");
address.ZipCode = DBHelper.GetString(dataReader, "ZipCode");
address.Street = DBHelper.GetString(dataReader, "Street");
address.HouseNr = DBHelper.GetString(dataReader, "HouseNr");
address.ApartmentNr = DBHelper.GetString(dataReader, "ApartmentNr");
//address.City = DBHelper.GetString(dataReader, "City");
address.CityID = DBHelper.GetInt(dataReader, "CityID");
address.CountryID = DBHelper.GetInt(dataReader, "CountryID");
return address;
}
public static void UpdateAddress(Address address)
{
AddressDB.UpdateAddress(address);
}
public static Address InsertAddress(Address address)
{
return AddressDB.InsertAddress(address);
}
