public Address(Guid addressid, Country country, City city, string street, string zipcode, string housenr) { this.addressid= addressid; this.country= country; this.city= city; this.street= street; this.zipcode= zipcode; this.housenr= housenr; }
public static void UpdateCity(City city) { string sqlQuery = "UPDATE City SET Name=@Name WHERE CityID='" + city.CityID+"'"; DbCommand dbCommand = DBHelper.GetDBCommand(sqlQuery); DBHelper.AddInParameter(dbCommand, "Name", DbType.String, city); DBHelper.ExecuteNonQuery(dbCommand); }
public static City InsertCity(City city) { string sqlQuery = "INSERT INTO City(CityID,Name) " + " VALUES(@CityID,@Name)"; if (city.CityID == Guid.Empty) city.CityID = Guid.NewGuid(); else return null; DbCommand dbCommand = DBHelper.GetDBCommand(sqlQuery); DBHelper.AddInParameter(dbCommand, "CityID", DbType.Guid, city.CityID); DBHelper.AddInParameter(dbCommand, "Name", DbType.String, city.Name); return city; }
private static City GetCityFromReader(IDataReader dataReader) { City city = new City(); city.CityID = DBHelper.GetGuid(dataReader, "CityID"); city.Name = DBHelper.GetString(dataReader, "Name"); return city; }
public static City InsertCity(City city) { return CityDB.InsertCity(city); }