private static CDMCollection Load() { CDMCollection result = new CDMCollection(); MySqlCommand cmd = new MySqlCommand("Select CDMCode, CPTCode, ProcedureName, CDMClient from tblCDM;"); cmd.CommandType = CommandType.Text; using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString)) { cn.Open(); cmd.Connection = cn; using (MySqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { CDM cdms = new Model.CDM(); YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(cdms, dr); sqlDataReaderPropertyWriter.WriteProperties(); result.Add(cdms); } } } return(result); }
public static void Refresh() { instance = null; CDMCollection tmp = CDMCollection.Instance; }