private List <Icd9> MapReaderToIcd9List(SqlDataReader reader, bool includePlanStatus) { var data = new List <Icd9>(); Icd9 icd9 = null; if (reader != null && !reader.IsClosed) { while (reader.Read()) { var code = reader.GetString(reader.GetOrdinal("Icd9")); var description = reader.GetString(reader.GetOrdinal("Description")); var icd10Codes = reader.GetString(reader.GetOrdinal("Icd10Codes")); //var insPlanCount = !reader.IsDBNull(reader.GetOrdinal("InsPlanCount")) ? reader.GetInt32(reader.GetOrdinal("InsPlanCount")) : null; var insPlanCount = reader.GetInt32(reader.GetOrdinal("InsPlanCount")); var enabledOnPlan = includePlanStatus ? reader.GetInt32(reader.GetOrdinal("EnabledOnPlan")) : 0; icd9 = new Icd9() { code = code, description = description, icd10Codes = icd10Codes, insPlanCount = insPlanCount, enabledOnPlan = enabledOnPlan == 1 ? true : false }; data.Add(icd9); } reader.Close(); } return(data); }
public Icd9 GetIcd9(string icd9) { Icd9 data = null; using (var connection = new SqlConnection(SqlDbConnectionString)) { var sql = "sp_LMN_GetIcd9"; var cmd = new SqlCommand(sql, connection); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add("@Icd9", System.Data.SqlDbType.NVarChar).Value = icd9; connection.Open(); SqlDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.SingleResult); data = MapReaderToIcd9(reader); } return(data); }
private Icd9 MapReaderToIcd9(SqlDataReader reader) { Icd9 data = null; if (reader != null && !reader.IsClosed && reader.Read()) { var code = reader.GetString(reader.GetOrdinal("Icd9")); var description = reader.GetString(reader.GetOrdinal("Description")); var icd10Codes = reader.GetString(reader.GetOrdinal("Icd10Codes")); var insPlanCount = reader.GetInt32(reader.GetOrdinal("InsPlanCount")); data = new Icd9() { code = code, description = description, icd10Codes = icd10Codes, insPlanCount = insPlanCount }; reader.Close(); } return(data); }