private List<FilterLookupType> SetupEncounterTypesIDlist()
{
var etList = new List<FilterLookupType>();
var luType = new FilterLookupType() { ID = 0, Description = "A" };
etList.Add(luType);
luType = new FilterLookupType() { ID = 1, Description = "B" };
etList.Add(luType);
luType = new FilterLookupType() { ID = 2, Description = "C" };
etList.Add(luType);
luType = new FilterLookupType() { ID = 3, Description = "D" };
etList.Add(luType);
return etList;
}
public List<FilterLookupType> GetDiagnosisCodeGroupList()
{
log.Debug("Start GetDiagnosisCodeGroupList()");
var queryResult = new List<FilterLookupType>();
var connectionString = ConfigurationManager.ConnectionStrings["IrmDBContext"].ConnectionString;
using (var connection = GetConnection(connectionString))
{
log.DebugFormat("Connection made using ConnectionString {0}", connectionString);
using (SqlCommand command = new SqlCommand("EXEC Lookup.spDiagnosisCodesGetChapters", connection))
{
try
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
int Id = reader.FieldToInt("DiagnosisCodeID");
var Name = reader.FieldToString("Description");
var item = new FilterLookupType()
{
ID = Id,
Description = Name,
};
queryResult.Add(item);
}
}
}
catch (Exception e)
{
log.ErrorFormat("GetDiagnosisCodeGroupList caused an exception: {0}", e.Message);
throw;
}
}
}
log.DebugFormat("{0} Chapters returned", queryResult.Count());
log.Debug("End GetDiagnosisCodeGroupList()");
return queryResult;
}
private List<FilterLookupType> GetLookupList(string cmdText)
{
//log.DebugFormat("GetLookupList: {0}", cmdText);
var queryResult = new List<FilterLookupType>();
using (var connection = GetConnection())
{
using (SqlCommand command = new SqlCommand(cmdText, connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
int Id = reader.FieldToInt("ID");
var Name = reader.FieldToString("Description");
char charID = reader.FieldToChar("charID");
double double1 = 0;
if (reader.FieldExists("Double1"))
{
double1 = reader.FieldToDouble("Double1");
}
double double2 = 0;
if (reader.FieldExists("Double2"))
{
double2 = reader.FieldToDouble("Double2");
}
string string1 = string.Empty;
if (reader.FieldExists("String1"))
{
reader.FieldToString("String1");
}
var item = new FilterLookupType()
{
ID = Id,
charID = charID,
Description = Name,
DoubleValue1 = double1,
DoubleValue2 = double2,
StringValue1 = string1
};
queryResult.Add(item);
}
}
}
}
return queryResult;
}
