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;
}
