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());
}
}