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