/**************************************************************************************************/ public override void BackgroundLoadWork() { using (SqlConnection connection = new SqlConnection(BCDB2.Instance.getConnectionString())) { connection.Open(); SqlCommand cmdProcedure = new SqlCommand("sp_3_LoadFollowupCohort", connection); cmdProcedure.CommandType = CommandType.StoredProcedure; try { SqlDataReader reader = cmdProcedure.ExecuteReader(CommandBehavior.CloseConnection); if (reader != null) { while (reader.Read()) { FollowupCohortEntry hrbqe = new FollowupCohortEntry(); for (int i = 0; i < reader.FieldCount; i++) { if (reader.IsDBNull(i) == false) { foreach (FieldInfo fi in hrbqe.GetType().GetFields(BindingFlags.Instance | BindingFlags.Public)) { string name = fi.Name; if (name == reader.GetName(i)) { fi.SetValue(hrbqe, reader.GetValue(i)); } } } } FollowupCohortPeople.Add(hrbqe); } reader.Close(); } } catch (Exception e) { Logger.Instance.WriteToLog(e.ToString()); } } }
/**************************************************************************************************/ public override void BackgroundLoadWork() { using (SqlConnection connection = new SqlConnection(BCDB2.Instance.getConnectionString())) { connection.Open(); SqlCommand cmdProcedure = new SqlCommand("sp_3_LoadFollowupCohort", connection); cmdProcedure.CommandType = CommandType.StoredProcedure; try { SqlDataReader reader = cmdProcedure.ExecuteReader(CommandBehavior.CloseConnection); if (reader != null) { while (reader.Read()) { FollowupCohortEntry hrbqe = new FollowupCohortEntry(); for (int i = 0; i < reader.FieldCount; i++) { if (reader.IsDBNull(i) == false) { foreach (FieldInfo fi in hrbqe.GetType().GetFields(BindingFlags.Instance | BindingFlags.Public)) { string name = fi.Name; if (name == reader.GetName(i)) { fi.SetValue(hrbqe, reader.GetValue(i)); } } } } FollowupCohortPeople.Add(hrbqe); } reader.Close(); } } catch (Exception e) { Logger.Instance.WriteToLog(e.ToString()); } } }