private YellowstonePathology.Business.Search.PathologistSearchResultCollection BuildResultList(MySqlCommand cmd)
{
YellowstonePathology.Business.Search.PathologistSearchResultCollection result = new Search.PathologistSearchResultCollection();
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Search.PathologistSearchResult pathologistSearchResult = new Search.PathologistSearchResult();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderProperyWriter = new Persistence.SqlDataReaderPropertyWriter(pathologistSearchResult, dr);
sqlDataReaderProperyWriter.WriteProperties();
result.Add(pathologistSearchResult);
}
}
}
return(result);
}
private YellowstonePathology.Business.Search.PathologistSearchResultCollection BuildResultList(SqlCommand cmd)
{
YellowstonePathology.Business.Search.PathologistSearchResultCollection result = new Search.PathologistSearchResultCollection();
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Search.PathologistSearchResult pathologistSearchResult = new Search.PathologistSearchResult();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderProperyWriter = new Persistence.SqlDataReaderPropertyWriter(pathologistSearchResult, dr);
sqlDataReaderProperyWriter.WriteProperties();
result.Add(pathologistSearchResult);
}
}
}
return result;
}
