public List<Country> GetAll()
{
try
{
List<Country> countries = new List<Country>();
string query = "SELECT * FROM t_Country ORDER BY Name";
CommandObj.CommandText = query;
ConnectionObj.Open();
SqlDataReader reader = CommandObj.ExecuteReader();
while (reader.Read())
{
Country aCountry = new Country();
aCountry.Id = Convert.ToInt32(reader["Id"].ToString());
aCountry.Name = reader["Name"].ToString();
aCountry.About = reader["About"].ToString();
countries.Add(aCountry);
}
reader.Close();
return countries;
}
catch (Exception exception)
{
throw new Exception("Unable to get the coutries information.",exception);
}
finally
{
ConnectionObj.Close();
CommandObj.Dispose();
}
}
public Country GetCountryInformationByName(string countryName)
{
try
{
string query = "SELECT * FROM t_Country WHERE Name=@countryName";
CommandObj.CommandText = query;
CommandObj.Parameters.Clear();
CommandObj.Parameters.AddWithValue("@countryName", countryName);
Country country = null;
ConnectionObj.Open();
SqlDataReader reader = CommandObj.ExecuteReader();
if (reader.Read())
{
country = new Country();
country.Id = Convert.ToInt32(reader["Id"].ToString());
country.Name = reader["Name"].ToString();
country.About = reader["About"].ToString();
}
reader.Close();
return country;
}
catch (Exception exception)
{
throw new Exception("Unable to get country information",exception);
}
finally
{
ConnectionObj.Close();
CommandObj.Dispose();
}
}
protected void saveButton_Click(object sender, EventArgs e)
{
try
{
if (countryNameTextBox.Text.Length > 50)
{
messageLabel.ForeColor = System.Drawing.Color.Red;
messageLabel.Text = "Please! Enter a Country Name within 50 character and then try";
return;
}
string name = countryNameTextBox.Text;
string about = aboutCountryTextBox.Text;
Country country = new Country(name, about);
message = countryManager.Save(country);
messageLabel.ForeColor = System.Drawing.Color.Black;
messageLabel.Text = message;
LoadAllCountry();
ClearAllTextBox();
}
catch (Exception exceptionObj)
{
message = exceptionObj.Message;
if (exceptionObj.InnerException != null)
{
message += "<br/>System Error:" + exceptionObj.InnerException.Message;
}
messageLabel.ForeColor = System.Drawing.Color.Red;
messageLabel.Text = message;
}
}
protected void saveButton_Click(object sender, EventArgs e)
{
try
{
if (nameTextBox.Text != "")
{
messageLabel.Text = "";
string name = nameTextBox.Text;
string about = Request.Form["edit"];
Country country = new Country(name, about);
string message = countryManager.Save(country);
messageLabel.Text = message;
ClearAll();
LoadAllCountryInformation();
}
}
catch (Exception exception)
{
string mgs = exception.Message;
if (exception.InnerException != null)
{
mgs += "<br/>System Error:" + exception.InnerException.Message;
}
messageLabel.Text = mgs;
}
}
private bool IsCountryExits(Country country)
{
Country aCountry = countryGateway.GetCountryInformationByName(country.Name);
if (aCountry != null)
{
return true;
}
return false;
}
public string Save(Country country)
{
if (IsCountryExits(country))
{
return "Country name must be unique";
}
if (countryGateway.Insert(country) > 0)
{
return "Save Sucessfully!";
}
return "Failed to save";
}
public int Insert(Country country)
{
try
{
string query = "INSERT INTO t_Country VALUES(@name,@about)";
CommandObj.CommandText = query;
CommandObj.Parameters.Clear();
CommandObj.Parameters.AddWithValue("@name", country.Name);
CommandObj.Parameters.AddWithValue("@about", country.About);
ConnectionObj.Open();
int rowAffected = CommandObj.ExecuteNonQuery();
return rowAffected;
}
catch (Exception exception)
{
throw new Exception("Could not save.",exception);
}
finally
{
ConnectionObj.Close();
CommandObj.Dispose();
}
}
protected void saveButton_Click(object sender, EventArgs e)
{
try
{
string name = countryNameTextBox.Text;
string about = aboutCountryTextBox.Text;
Country country = new Country(name, about);
message = countryManager.Save(country);
messageLabel.Text = message;
LoadAllCountry();
ClearAllTextBox();
}
catch (Exception exceptionObj)
{
message = exceptionObj.Message;
if (exceptionObj.InnerException != null)
{
message += "<br/>System Error:" + exceptionObj.InnerException.Message;
}
messageLabel.Text = message;
}
}
public List<Country> GetAll(int pageIndex, int pageSise, out int totalRecords)
{
//string cs = WebConfigurationManager.ConnectionStrings["countryInformaitonDb"].ConnectionString;
List<Country> countries=new List<Country>();
//using (SqlConnection connection = new SqlConnection(cs))
//{
SqlCommand command = new SqlCommand("spGetCityInformaiton", ConnectionObj);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@PageIndex", pageIndex);
command.Parameters.AddWithValue("@PageSize", pageSise);
SqlParameter totalrecord = new SqlParameter();
totalrecord.ParameterName = "@TotalRecord";
totalrecord.Direction = ParameterDirection.Output;
totalrecord.SqlDbType = SqlDbType.Int;
command.Parameters.Add(totalrecord);
ConnectionObj.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Country aCountry = new Country();
aCountry.Id = Convert.ToInt32(reader["Id"].ToString());
aCountry.Name = reader["Name"].ToString();
aCountry.About = reader["About"].ToString();
countries.Add(aCountry);
}
reader.Close();
totalRecords = (int)command.Parameters["@TotalRecord"].Value;
// }
ConnectionObj.Close();
return countries;
}