public static Country Find (int i_iCountryId) { SqlConnection l_sqlConnection = null; SqlCommand l_sqlCommand = null; SqlDataReader l_sqlDataReader = null; Country l_result = null; string l_strSqlToExecute = ""; try { l_sqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings[Common.DbName].ConnectionString); l_sqlConnection.Open(); l_strSqlToExecute = "select * from countries where Id = @param_country_id"; l_sqlCommand = new SqlCommand(l_strSqlToExecute, l_sqlConnection); SqlParameter l_paramCountryId = new SqlParameter("param_country_id", SqlDbType.Int); l_paramCountryId.Value = i_iCountryId; l_sqlCommand.Parameters.Add(l_paramCountryId); l_sqlDataReader = l_sqlCommand.ExecuteReader(); if (l_sqlDataReader.Read()) { l_result = new Country(); l_result.Id = (int)l_sqlDataReader["Id"]; l_result.Name = (string)l_sqlDataReader["Name"]; l_result.Iso2 = (string)l_sqlDataReader["Iso2"]; return l_result; } return l_result; } catch (Exception ex) { throw new Exception("Cannot get country: ex: " + ex); } finally { if (l_sqlDataReader != null) { l_sqlDataReader.Close(); } if (l_sqlCommand != null) { l_sqlCommand.Dispose(); } if (l_sqlConnection != null) { if (l_sqlConnection.State == ConnectionState.Open) { l_sqlConnection.Close(); } l_sqlConnection.Dispose(); } } } // Find ()
} // Find () //----------- public static List<Country> All () { SqlConnection l_sqlConnection = null; SqlCommand l_sqlCommand = null; SqlDataReader l_sqlDataReader = null; List<Country> l_result = new List<Country>(); string l_strSqlToExecute = ""; try { l_sqlConnection =new SqlConnection(ConfigurationManager.ConnectionStrings[Common.DbName].ConnectionString); l_sqlConnection.Open(); l_strSqlToExecute = "select * from countries order by name"; l_sqlCommand = new SqlCommand(l_strSqlToExecute, l_sqlConnection); l_sqlDataReader = l_sqlCommand.ExecuteReader(); while ( l_sqlDataReader.Read() ) { Country l_objectToAdd = new Country(); l_objectToAdd.Id = (int)l_sqlDataReader["Id"]; l_objectToAdd.Name = (string) l_sqlDataReader["Name"]; l_objectToAdd.Iso2 = (string) l_sqlDataReader["Iso2"]; l_result.Add(l_objectToAdd); } return l_result; } catch (Exception ex) { throw new Exception("Cannot get countries: ex: " + ex); } finally { if ( l_sqlDataReader != null ) { l_sqlDataReader.Close(); } if ( l_sqlCommand != null ) { l_sqlCommand.Dispose(); } if ( l_sqlConnection != null) { if ( l_sqlConnection.State == ConnectionState.Open) { l_sqlConnection.Close(); } l_sqlConnection.Dispose(); } } } // All ()