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