public async Task <IEnumerable <QBWCPANDT> > GetTreatmentAsync(long epiRowId) { using (var connection = new OdbcConnection(_connectionStrings.Cache)) { var result = await connection.QueryAsync <QBWCPANDT>(QuestionnaireQuery.GetPlanAndTreatmentByEpiRowId(), new { QUESPAAdmDR = epiRowId }); return(result); } }
public async Task <IEnumerable <QBWCPEANTI> > GetPhysicalExamAntiAgingAsync(long epiRowId) { using (var connection = new OdbcConnection(_connectionStrings.Cache)) { var result = await connection.QueryAsync <QBWCPEANTI>(QuestionnaireQuery.GetPhysicalExamAntiAgingQueryByEpiRowId(), new { QUESPAAdmDR = epiRowId }); return(result.ToList()); } }
public async Task <IEnumerable <QNURINFO> > GetNutriInfoBehavioralAsync(long epiRowId) { using (var connection = new OdbcConnection(_connectionStrings.Cache)) { var result = await connection.QueryAsync <QNURINFO>(QuestionnaireQuery.GetDietBehavioralQueryByEpiRowId(), new { QUESPAAdmDR = epiRowId }); return(result.ToList()); } }
public async Task <IEnumerable <QBWCPANDTQQMedication> > GetMedicationAsync(long quesParRefDR) { using (var connection = new OdbcConnection(_connectionStrings.Cache)) { var result = await connection.QueryAsync <QBWCPANDTQQMedication>(QuestionnaireQuery.GetMedicationQueryByQUESParRefDR(), new { QUESParRefDR = quesParRefDR }); return(result); } }
public async Task <IEnumerable <QBWCEXERC> > GetExerciseAsync(long epiRowId) { using (var connection = new OdbcConnection(_connectionStrings.Cache)) { var result = await connection.QueryAsync <QBWCEXERC>(QuestionnaireQuery.GetExerciseQueryByEpiRowId(), new { QUESPAAdmDR = epiRowId }); return(result); } }
public async Task <IActionResult> GetQuestionnaire([FromRoute] int id) { var query = new QuestionnaireQuery { QuestionnaireId = id }; query.Validate(); var result = await _Mediator.Send(query); return(Ok(result)); }
public async Task <IActionResult> Page(QuestionnaireQuery questionnaireQuery) { return(Success(await _questionnaireService.PageAsync(questionnaireQuery))); }
public async Task <IActionResult> Get(QuestionnaireQuery questionnaireQuery) { return(Success(await _questionnaireService.RetrieveAsync(questionnaireQuery))); }
public async Task <IEnumerable <QNURINFOQQUsualConsumption> > GetNutriInfoDietaryPatternAsync(long quesParRefDR) { using (var connection = new OdbcConnection(_connectionStrings.Cache)) { var result = await connection.QueryAsync <QNURINFOQQUsualConsumption>(QuestionnaireQuery.GetDietaryPatternQueryByQUESParRefDR(), new { QUESParRefDR = quesParRefDR }); return(result.ToList()); } }