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