public string SaveCountry(Countries acountry)
{
if (!countryGateway.ISCountryNameAlreadyExists(acountry))
{
if ((countryGateway.SaveCountryInfo(acountry) > 0))
{
return "Country Information Saved Succesfully";
}
else
{
return "Country Information Saving Failed";
}
}
else
{
return "Country Name Already Exists";
}
}
public List<Countries> GetAllCountry()
{
List<Countries> countryList=new List<Countries>();
SqlConnection connection=new SqlConnection(connectionString);
string query = string.Format("SELECT * FROM Countries");
//SqlDataAdapter adapter=new SqlDataAdapter();
connection.Open();
SqlCommand command=new SqlCommand(query,connection);
//adapter.SelectCommand=new SqlCommand(query,connection);
SqlDataReader reader = command.ExecuteReader();
int serial = 1;
while (reader.Read())
{
Countries aCountries=new Countries();
aCountries.ID = serial;
aCountries.Name = reader["Name"].ToString();
aCountries.About = reader["About"].ToString();
countryList.Add(aCountries);
serial++;
}
reader.Close();
connection.Close();
return countryList;
}
public int SaveCountryInfo(Countries aCountry)
{
string query = string.Format("INSERT INTO Countries VALUES('{0}','{1}')",aCountry.Name,aCountry.About);
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int rowAffected = command.ExecuteNonQuery();
connection.Close();
return rowAffected;
// INSERT INTO Countries VALUES('{0}','{1}')", aCountry.Name, aCountry.About
}
public bool ISCountryNameAlreadyExists(Countries acountry)
{
bool isCountryNameAlreadyExists = false;
string query = string.Format("Select * From Countries Where Name='{0}'", acountry.Name);
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
isCountryNameAlreadyExists = true;
break;
}
reader.Close();
connection.Close();
return isCountryNameAlreadyExists;
}
public List<Countries> PopulateDropDownList()
{
//List<Countries> countryList = new List<Countries>();
//SqlConnection connection = new SqlConnection(connectionString);
//string query = string.Format("SELECT * FROM Countries");
////SqlDataAdapter adapter=new SqlDataAdapter();
//connection.Open();
//SqlCommand command = new SqlCommand(query, connection);
////adapter.SelectCommand=new SqlCommand(query,connection);
//SqlDataReader reader = command.ExecuteReader();
//connection.Close();
//return reader;
List<Countries> countryList = new List<Countries>();
SqlConnection connection = new SqlConnection(connectionString);
string query = string.Format("SELECT * FROM Countries");
//SqlDataAdapter adapter=new SqlDataAdapter();
connection.Open();
SqlCommand command = new SqlCommand(query, connection);
//adapter.SelectCommand=new SqlCommand(query,connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Countries aCountries = new Countries();
aCountries.ID = Convert.ToInt32(reader["ID"]);
aCountries.Name = reader["Name"].ToString();
aCountries.About = reader["About"].ToString();
countryList.Add(aCountries);
}
reader.Close();
connection.Close();
return countryList;
}