public IEnumerable <BasePatientVM> GetPatient(string hn)
{
var data = new List <BasePatientVM>();
int _hn = 0;
var query = "";
var p = new DynamicParameters();
var trySearch = hn.Replace("-", "");
if (int.TryParse(trySearch, out _hn))
{
query = DBCacheQuery.GetPatientByHN();
p.AddDynamicParams(new { PAPMI_No = _hn + "%" });
}
else
{
query = DBCacheQuery.GetPatientByHN();
p.AddDynamicParams(new { PAPMI_No = trySearch + "%" });
}
using (IDbConnection connection = cacheConnection)
{
try
{
data = connection.QueryAsync <BasePatientVM>(query, p).Result.ToList();
}
catch (Exception ex)
{
throw;
}
}
return(data);
}
public BasePatientVM GetPatientByHN(string hn)
{
var data = new BasePatientVM();
using (IDbConnection connection = cacheConnection)
{
data = connection.QueryFirstOrDefaultAsync <BasePatientVM>(DBCacheQuery.GetPatientByHN(), new { PAPMI_No = hn }).Result;
}
return(data);
}