Example #1
0
        public async Task <PA_Person> GetPersonByPapmiRowIdAsync(long papmiRowId)
        {
            using (var connection = new OdbcConnection(_connectionStrings.Cache))
            {
                var result = await connection.QueryFirstOrDefaultAsync <PA_Person>(PatientAdmissionQuery.GetPersonByPapmiRowId(), new { PAPER_PAPMI_DR = papmiRowId });

                return(result);
            }
        }
Example #2
0
        public async Task <IEnumerable <PA_Adm> > GetPatientAdmissionsByPapmiRowIdAsync(long papmiRowId)
        {
            using (var connection = new OdbcConnection(_connectionStrings.Cache))
            {
                var result = await connection.QueryAsync <PA_Adm>(PatientAdmissionQuery.GetEpisodeTreeByPapmiRowId(), new { PAADM_PAPMI_DR = papmiRowId });

                return(result);
            }
        }
Example #3
0
        public async Task <PA_PatMas> GetPatientMasterByPapmiNoAsync(string papmiNo)
        {
            using (var connection = new OdbcConnection(_connectionStrings.Cache))
            {
                var result = await connection.QueryFirstOrDefaultAsync <PA_PatMas>(PatientAdmissionQuery.GetPatientMasterByPapmiNo(), new { PAPMI_No = papmiNo });

                return(result);
            }
        }
Example #4
0
        public async Task <PatientAdmViewModel> GetPatientHnByEpiRowIdAsync(long epiRowId)
        {
            using (var connection = new OdbcConnection(_connectionStrings.Cache))
            {
                var result = await connection.QueryFirstOrDefaultAsync <PatientAdmViewModel>(PatientAdmissionQuery.GetPatientHnByEpiRowId(), new { a = epiRowId });

                return(result);
            }
        }