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); }