public static YellowstonePathology.Business.Search.ReportSearchList BuildReportSearchList(MySqlCommand cmd) { Search.ReportSearchList result = new Search.ReportSearchList(); using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString)) { cn.Open(); cmd.Connection = cn; using (MySqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { Search.ReportSearchItem reportSearchItem = new Search.ReportSearchItem(); YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(reportSearchItem, dr); sqlDataReaderPropertyWriter.WriteProperties(); result.Add(reportSearchItem); } } } return(result); }
private static YellowstonePathology.Business.Search.ReportSearchList BuildReportSearchList(SqlCommand cmd) { Search.ReportSearchList result = new Search.ReportSearchList(); using (SqlConnection cn = new SqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString)) { cn.Open(); cmd.Connection = cn; using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { Search.ReportSearchItem reportSearchItem = new Search.ReportSearchItem(); YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(reportSearchItem, dr); sqlDataReaderPropertyWriter.WriteProperties(); result.Add(reportSearchItem); } } } return result; }