Example #1
0
 private static YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogCollection BuildMaterialTrackingLogCollection(SqlCommand cmd)
 {
     YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogCollection materialTrackingLogCollection = new YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogCollection();
     using (SqlConnection cn = new SqlConnection(Properties.Settings.Default.ProductionConnectionString))
     {
         cn.Open();
         cmd.Connection = cn;
         using (SqlDataReader dr = cmd.ExecuteReader())
         {
             while (dr.Read())
             {
                 YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLog materialTrackingLog = new YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLog();
                 YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter    propertyWriter      = new Persistence.SqlDataReaderPropertyWriter(materialTrackingLog, dr);
                 propertyWriter.WriteProperties();
                 materialTrackingLogCollection.Add(materialTrackingLog);
             }
         }
     }
     return(materialTrackingLogCollection);
 }
 private static YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogCollection BuildMaterialTrackingLogCollection(SqlCommand cmd)
 {
     YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogCollection materialTrackingLogCollection = new YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLogCollection();
     using (SqlConnection cn = new SqlConnection(Properties.Settings.Default.ProductionConnectionString))
     {
         cn.Open();
         cmd.Connection = cn;
         using (SqlDataReader dr = cmd.ExecuteReader())
         {
             while (dr.Read())
             {
                 YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLog materialTrackingLog = new YellowstonePathology.Business.MaterialTracking.Model.MaterialTrackingLog();
                 YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new Persistence.SqlDataReaderPropertyWriter(materialTrackingLog, dr);
                 propertyWriter.WriteProperties();
                 materialTrackingLogCollection.Add(materialTrackingLog);
             }
         }
     }
     return materialTrackingLogCollection;
 }