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