Example #1
0
 private YellowstonePathology.YpiConnect.Contract.Search.SearchResultCollection BuildSearchResultCollection(SqlCommand cmd)
 {
     YellowstonePathology.YpiConnect.Contract.Search.SearchResultCollection searchResultCollection = new Contract.Search.SearchResultCollection();
     using (SqlConnection cn = new SqlConnection(YpiConnect.Service.Properties.Settings.Default.ServerSqlConnectionString))
     {
         cn.Open();
         cmd.Connection = cn;
         using (SqlDataReader dr = cmd.ExecuteReader())
         {
             while (dr.Read())
             {
                 YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
                 YellowstonePathology.YpiConnect.Contract.Search.SearchResult searchResult = new Contract.Search.SearchResult();
                 searchResult.WriteProperties(propertyWriter);
                 searchResultCollection.Add(searchResult);
             }
         }
     }
     return(searchResultCollection);
 }
Example #2
0
 private YellowstonePathology.YpiConnect.Contract.Search.SearchResultCollection BuildSearchResultCollection(SqlCommand cmd)
 {
     YellowstonePathology.YpiConnect.Contract.Search.SearchResultCollection searchResultCollection = new Contract.Search.SearchResultCollection();
     using (SqlConnection cn = new SqlConnection(YpiConnect.Service.Properties.Settings.Default.ServerSqlConnectionString))
     {
         cn.Open();
         cmd.Connection = cn;
         using (SqlDataReader dr = cmd.ExecuteReader())
         {
             while (dr.Read())
             {
                 YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
                 YellowstonePathology.YpiConnect.Contract.Search.SearchResult searchResult = new Contract.Search.SearchResult();
                 searchResult.WriteProperties(propertyWriter);
                 searchResultCollection.Add(searchResult);
             }
         }
     }
     return searchResultCollection;
 }