public static void UpdateCity(City city)
{
string sqlQuery = "UPDATE City SET Name=@Name WHERE CityID=" + city.CityID;
Database db = new SqlDatabase(DBHelper.GetConnectionString());
DbCommand dbCommand = db.GetSqlStringCommand(sqlQuery);
db.AddInParameter(dbCommand, "Name", DbType.String, city);
db.ExecuteNonQuery(dbCommand);
}
public static City InsertCity(City city)
{
string sqlQuery = "INSERT INTO City(Name) " +
" VALUES(@Name);SELECT @@Identity";
Database db = new SqlDatabase(DBHelper.GetConnectionString());
DbCommand dbCommand = db.GetSqlStringCommand(sqlQuery);
db.AddInParameter(dbCommand, "Name", DbType.String, city.Name);
city.CityID = Convert.ToInt32(db.ExecuteScalar(dbCommand));
return city;
}
private static City GetCityFromReader(IDataReader dataReader)
{
City city = new City();
city.CityID = DBHelper.GetInt(dataReader, "CityID");
city.Name = DBHelper.GetString(dataReader, "Name");
return city;
}
public static City InsertCity(City city)
{
return CityDB.InsertCity(city);
}