public string Find(string name)
{
var result = _dbExecutor.QueryProc <dynamic>("[EPONS_API].[FindSetting]", new
{
name = name,
});
return(result.Count == 0? null : result[0].Value);
}
public IList <EntityViews.CompletedMeasurementTool.CompletedMeasurementTool> ListCompletedMeasurementTools(Guid patientId, DateTime startDate, DateTime endDate)
{
var result = _dbExecutor.QueryProc <dynamic>("[EPONS_API].[FindCompletedMeasurementToolsByPatientIdAndDateRange]", new
{
patientId = patientId,
startDate = startDate,
endDate = endDate
});
return(result
.GroupBy(x => x.DataSetId)
.Select(x => new EntityViews.CompletedMeasurementTool.CompletedMeasurementTool()
{
EndDate = x.First().EndDate,
StartDate = x.First().StartDate,
MeasurementTool = new ValueObjects.MeasurementTool()
{
Id = x.First().MeasurementToolId,
Name = x.First().MeasurementTool,
},
ScoreItems = x.OrderBy(y => y.ScoreItemSortOrder).ToDictionary(y => (string)y.ScoreItem, y => (int)y.ScoreValue)
}).ToList());
}