public int SaveCity(City city)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = @"INSERT INTO City VALUES('" + city.CityName + "','" + city.CityAbout + "','" + city.NoOfDwellers + "','" + city.Location + "','" + city.Weather + "'," + city.CountryID + ")";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int roweffected = command.ExecuteNonQuery();
connection.Close();
return roweffected;
}
protected void submitButton_Click(object sender, EventArgs e)
{
string cityName = cityNameTextBox.Text;
string cityAbout = cityAboutTextBox.Text.Replace("'", "''");
int noOfDwellers = Convert.ToInt32(noOfDwellersTextBox.Text);
string location = locationTextBox.Text;
string weather = weatherTextBox.Text;
int countryID = Convert.ToInt32(counrtyDropDownList.SelectedValue);
City city=new City(cityName,cityAbout,noOfDwellers,location,weather,countryID);
messageBoxLabel.Text = cityManager.SaveCity(city);
cityWiseCountryGridView.DataSource = cityManager.GetCityWiseCountry();
cityWiseCountryGridView.DataBind();
TextClear();
}
public string SaveCity(City city)
{
City acity = cityGateway.IsExist(city);
if (acity == null)
{
int roweffected = cityGateway.SaveCity(city);
if (roweffected > 0)
{
return "Save Successfully";
}
else
{
return "Save Failed";
}
}
else
{
return "City Name must be unique";
}
}
public City IsExist(City city)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM City WHERE CityName='" + city.CityName + "'";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
City aCity = null;
if (reader.HasRows)
{
reader.Read();
aCity = new City();
//aCity.CountryID = (int)reader["CountryID"];
//aCity.CountryName = reader["CountryName"].ToString();
//aCity.CountryAbout = reader["CountryAbout"].ToString();
}
reader.Close();
connection.Close();
return aCity;
}