public static void GenerateDiagnoses() { List <DiagnosisItem> diagnosisItems = new List <DiagnosisItem>(); List <ICD10_Item> icdItems = new List <ICD10_Item>(); icdItems = GetICD10Items(); foreach (Admission a in allAdmissions) { DiagnosisItem di = new DiagnosisItem(); di.PatientID = a.PatientID; di.AdmissionID = a.AdmissionID; //In 70% of the time pick some random diagnosis int int3070 = Convert.ToInt16(GetRandomNumber(1, 10)); // main diagnosis ICD10_Item icd = new ICD10_Item(); if (int3070 >= 4) { int randInt = Convert.ToInt16(GetRandomNumber(0, icdItems.Count - 1)); di.ICD_Code = icdItems[randInt].Code; di.ICD_Description = icdItems[randInt].Description; } else { int int_copd_rand = Convert.ToInt16(GetRandomNumber(1, 4)); if (int_copd_rand == 1) { di.ICD_Code = "J41"; di.ICD_Description = "Simple and mucopurulent chronic bronchitis"; } if (int_copd_rand == 2) { di.ICD_Code = "J42"; di.ICD_Description = "Unspecified chronic bronchitis"; } if (int_copd_rand == 3) { di.ICD_Code = "J43"; di.ICD_Description = "Emphysema"; } if (int_copd_rand == 4) { di.ICD_Code = "J44"; di.ICD_Description = "Other chronic obstructive pulmonary disease"; } } diagnosisItems.Add(di); } InsertDiagnosisItems(diagnosisItems); }
public static List <ICD10_Item> GetICD10Items() { List <ICD10_Item> icdItems = new List <ICD10_Item>(); OpenConnectionMain(DATABASE_CONFIGURATION); SqlDataReader reader = null; try { StringBuilder sb = new StringBuilder(); sb.Append("SELECT [Code], [Description] FROM [" + DATABASE_CONFIGURATION + "].[dbo].[v_ICD10Table]"); SqlCommand cmdIns = new SqlCommand(sb.ToString(), myConnectionMain); cmdIns.CommandTimeout = 600; reader = cmdIns.ExecuteReader(); int i = 0; if (reader.HasRows) { while (reader.Read()) { ICD10_Item item = new ICD10_Item(); item.Code = reader["Code"].ToString(); item.Description = reader["Description"].ToString(); icdItems.Add(item); } } } catch (Exception ex) { throw ex; } finally { if ((reader != null) && !reader.IsClosed) { reader.Close(); } } CloseConnectionMain(); return(icdItems); }