public Country CreateCountry(Country country)
{
using (var db = new DataAccess())
{
db.CreateStoredProcCommand("dbo.CreateCountry");
db.AddInputParameter("@Name", DbType.String, country.Name);
db.AddInputParameter("@FullName", DbType.String, country.FullName);
db.AddInputParameter("@Latitude", DbType.Double, country.Latitude);
db.AddInputParameter("@Longitude", DbType.Double, country.Longitude);
db.AddOutputParameter("@CountryId", DbType.Int32);
try
{
db.ExecuteNonQuery();
country.CountryId = db.GetParameterValue<int>("@CountryId");
}
catch (Exception ex)
{
Logger.Error("Error while creating country.", ex);
throw;
}
}
return country;
}
public bool TryGetCountry(string country, out Country match)
{
using (var db = new DataAccess())
{
db.CreateStoredProcCommand("dbo.TryGetCountry");
db.AddInputParameter("@Country", DbType.String, country);
db.AddReturnParameter();
try
{
db.ReadInto(match = new Country());
return Convert.ToBoolean(db.GetReturnValue());
}
catch (Exception ex)
{
Logger.Error("Error while getting country.", ex);
}
}
match = default(Country);
return false;
}