public IEnumerable <PatientVM> GetPatientBCT(string search) { using (IDbConnection connection = mySqlConnection) { var data = new List <PatientVM>(); var p = new DynamicParameters(); p.Add("@Search_Data", search); var patients = connection.QueryAsync <PatientData>("GetPatient", p, commandType: CommandType.StoredProcedure).Result.ToList(); foreach (var pt in patients) { var ptvm = new PatientVM(); var patient = new BasePatientVM() { HN = pt.HN, TitleName = pt.TitileName, FirstName = pt.FirstName, MiddleName = pt.MiddleName, LastName = pt.LastName, DOB = pt.DOB, SexCode = pt.SexCode, SexDesc = pt.SexDesc, IDCard = pt.IDCard }; ptvm.Patient = patient; ptvm.SCT_HN = pt.SCT_HN; data.Add(ptvm); } return(data); } }
private PatientVM GetPatientBCTByHN(string hn) { try { using (IDbConnection connection = mySqlConnection) { var p = new DynamicParameters(); p.Add("@Search_Data", hn); var pt = connection.QueryAsync <PatientData>("GetPatient", p, commandType: CommandType.StoredProcedure).Result.FirstOrDefault(); var ptvm = new PatientVM(); var patient = new BasePatientVM() { HN = pt.HN, TitleName = pt.TitileName, FirstName = pt.FirstName, MiddleName = pt.MiddleName, LastName = pt.LastName, DOB = pt.DOB, SexCode = pt.SexCode, SexDesc = pt.SexDesc, IDCard = pt.IDCard }; ptvm.Patient = patient; ptvm.SCT_HN = pt.SCT_HN; return(ptvm); } } catch (Exception) { return(new PatientVM()); } }
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); }