public static ICDCodeCollection GetBillingCodeList()
{
ICDCodeCollection collection = ICDCodeCollection.GetByCategory("Cytology");
List <ICDCode> list = collection.ToList <ICDCode>();
collection = ICDCodeCollection.GetByCategory("NGCT");
list.AddRange(collection);
collection = ICDCodeCollection.GetByCategory("Routine HPV");
list.AddRange(collection);
collection = ICDCodeCollection.GetByCategory("Trichomonas/Cervx");
list.AddRange(collection);
collection = ICDCodeCollection.GetByCategory("Trichomonas");
list.AddRange(collection);
collection = ICDCodeCollection.GetByCategory(string.Empty);
list.AddRange(collection);
ICDCodeCollection result = new Model.ICDCodeCollection();
foreach (ICDCode code in list)
{
result.Add(code);
}
result = ICDCodeCollection.GetSortedByCode(result);
return(result);
}
private static ICDCodeCollection Load()
{
ICDCodeCollection result = new Model.ICDCodeCollection();
MySqlCommand cmd = new MySqlCommand("Select JSONValue from tblICDCode;");
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())
{
YellowstonePathology.Business.Billing.Model.ICDCode icdCode = YellowstonePathology.Business.Billing.Model.ICDCodeFactory.FromJson(dr[0].ToString());
result.Add(icdCode);
}
}
}
return(result);
}