public List<Country> GetAllCountries() { SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT * FROM Country ORDER BY CountryName ASC"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); List<Country> countries = new List<Country>(); while (reader.Read()) { int id = Convert.ToInt32(reader["Id"].ToString()); string countryName = reader["CountryName"].ToString(); string countryAbout = reader["CountryAbout"].ToString(); Country country = new Country(); country.CountryID = id; country.CountryName = countryName; country.CountryAbout = countryAbout; countries.Add(country); } reader.Close(); connection.Close(); return countries; }
public Country IsExistConCountry(Country aCountry) { SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT * FROM Country WHERE CountryName='" + aCountry.CountryName + "'"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); Country country = null; while (reader.Read()) { string countryName = reader["CountryName"].ToString(); string countryAbout = reader["CountryAbout"].ToString(); country = new Country(); country.CountryName = countryName; country.CountryAbout = countryAbout; } reader.Close(); connection.Close(); return country; }
public bool AddCountry(Country country) { SqlConnection connection = new SqlConnection(connectionString); string quiry = "INSERT INTO Country VALUES('" + country.CountryName + "','" + country.CountryAbout + "')"; SqlCommand command = new SqlCommand(quiry, connection); connection.Open(); int rowAffectedCount = command.ExecuteNonQuery(); if (rowAffectedCount > 0) { return true; } return false; }
public string AddCountry(Country country) { Country aCountry = gateway.IsExistConCountry(country); if (aCountry == null) { gateway.AddCountry(country); return "Country added successfully."; } else if (aCountry != null) { return "Exist country."; } else { return "No data has been Added."; } }
protected void saveButton_Click(object sender, EventArgs e) { Country country = new Country(nameTextBox.Text, aboutTextBox.Text); showMessageLable.Text = manager.AddCountry(country); LoadAllCountries(); }