public IActionResult Search(Icd10SearchRequest Request)
{
Icd10Service Iicd10Service = new Icd10Service(Connection.GetCs().GetConnection());
var res = Iicd10Service.SearchIcd10(Request);
return(View(res));
}
public List <Icd10SearchResponse> SearchIcd10(Icd10SearchRequest request)
{
List <Icd10SearchResponse> res = new List <Icd10SearchResponse>();
using (SqlConnection conn = new SqlConnection(cs))
{
conn.Open();
using (SqlCommand comm = new SqlCommand(@"
SELECT Top 100 ID,Icd10Code,IsHeader,LongDescription FROM ICD10
WHERE
(@Description IS NULL OR (" + request.getCriteria() + @"))
ORDER BY Icd10Code
", conn))
{
comm.Parameters.AddWithValue("@Description", DBN(request.Description));
var reader = comm.ExecuteReader();
object[] o = new object[reader.FieldCount];
while (reader.Read())
{
reader.GetValues(o);
res.Add(new Icd10SearchResponse()
{
ID = float.Parse(o[0].ToString()),
ICD10Code = (o[1].ToString()),
IsHeader = float.Parse(o[2].ToString()),
LongDescription = (o[3].ToString()),
});
}
conn.Close();
}
}
return(res);
}
