public GetKpiTargetItemResponse GetKpiTarget(int kpiId, DateTime date, RangeFilter rangeFilter, YtdFormula ytdFormula) { var response = new GetKpiTargetItemResponse(); try { switch (rangeFilter) { case RangeFilter.CurrentDay: { var kpi = DataContext.Kpis.Include(x => x.Measurement).Single(x => x.Id == kpiId); var data = DataContext.KpiTargets.Include(x => x.Kpi).FirstOrDefault(x => x.Kpi.Id == kpiId && x.PeriodeType == PeriodeType.Daily && x.Periode == date); var kpiResponse = new GetKpiTargetItemResponse.KpiResponse { Id = kpi.Id, Measurement = kpi.Measurement.Name, Name = kpi.Name, Remark = kpi.Remark, }; return new GetKpiTargetItemResponse { Value = (data != null) ? data.Value : null, Kpi = kpiResponse, IsSuccess = true }; } case RangeFilter.CurrentMonth: { var kpi = DataContext.Kpis.Include(x => x.Measurement).Single(x => x.Id == kpiId); var data = DataContext.KpiTargets.Include(x => x.Kpi).FirstOrDefault(x => x.Kpi.Id == kpiId && x.PeriodeType == PeriodeType.Monthly && x.Periode.Month == date.Month && x.Periode.Year == date.Year); var kpiResponse = new GetKpiTargetItemResponse.KpiResponse { Id = kpi.Id, Measurement = kpi.Measurement.Name, Name = kpi.Name, Remark = kpi.Remark, }; return new GetKpiTargetItemResponse { Value = (data != null) ? data.Value : null, Kpi = kpiResponse, IsSuccess = true }; } case RangeFilter.CurrentYear: { var kpi = DataContext.Kpis.Include(x => x.Measurement).Single(x => x.Id == kpiId); var data = DataContext.KpiTargets.Include(x => x.Kpi).FirstOrDefault(x => x.Kpi.Id == kpiId && x.PeriodeType == PeriodeType.Yearly && x.Periode.Year == date.Year); var kpiResponse = new GetKpiTargetItemResponse.KpiResponse { Id = kpi.Id, Measurement = kpi.Measurement.Name, Name = kpi.Name, Remark = kpi.Remark, }; return new GetKpiTargetItemResponse { Value = (data != null) ? data.Value : null, Kpi = kpiResponse, IsSuccess = true }; } case RangeFilter.MTD: { var kpi = DataContext.Kpis.Include(x => x.Measurement).Single(x => x.Id == kpiId); var data = DataContext.KpiTargets.Include(x => x.Kpi) .Where(x => x.Kpi.Id == kpiId && x.PeriodeType == PeriodeType.Daily && (x.Periode.Day >= 1 && x.Periode.Day <= date.Day && x.Periode.Month == date.Month && x.Periode.Year == date.Year)).AsQueryable(); double? kpiAchievement = ytdFormula == YtdFormula.Average ? data.Average(x => x.Value) : data.Sum(x => x.Value); var kpiResponse = new GetKpiTargetItemResponse.KpiResponse { Id = kpi.Id, Measurement = kpi.Measurement.Name, Name = kpi.Name, Remark = kpi.Remark, }; return new GetKpiTargetItemResponse { Value = kpiAchievement, Kpi = kpiResponse, IsSuccess = true }; } case RangeFilter.YTD: { var kpi = DataContext.Kpis.Include(x => x.Measurement).Single(x => x.Id == kpiId); var data = DataContext.KpiTargets.Include(x => x.Kpi) .Where(x => x.Kpi.Id == kpiId && x.PeriodeType == PeriodeType.Monthly && x.Value.HasValue && (x.Periode.Month >= 1 && x.Periode.Month <= date.Month && x.Periode.Year == date.Year)).AsQueryable(); double? kpiAchievement = ytdFormula == YtdFormula.Average ? data.Average(x => x.Value) : data.Sum(x => x.Value); var kpiResponse = new GetKpiTargetItemResponse.KpiResponse { Id = kpi.Id, Measurement = kpi.Measurement.Name, Name = kpi.Name, Remark = kpi.Remark, }; return new GetKpiTargetItemResponse { Value = kpiAchievement, Kpi = kpiResponse, IsSuccess = true }; } case RangeFilter.AllExistingYears: { var kpi = DataContext.Kpis.Include(x => x.Measurement).Single(x => x.Id == kpiId); var data = DataContext.KpiTargets.Include(x => x.Kpi) .Where(x => x.Kpi.Id == kpiId && x.PeriodeType == PeriodeType.Yearly && x.Value.HasValue && (x.Periode.Year >= 2011 && x.Periode.Year <= date.Year)).AsQueryable(); double? kpiAchievement = ytdFormula == YtdFormula.Average ? data.Average(x => x.Value) : data.Sum(x => x.Value); var kpiResponse = new GetKpiTargetItemResponse.KpiResponse { Id = kpi.Id, Measurement = kpi.Measurement.Name, Name = kpi.Name, Remark = kpi.Remark, }; return new GetKpiTargetItemResponse { Value = kpiAchievement, Kpi = kpiResponse, IsSuccess = true }; } } } catch (Exception exception) { response.Message = exception.Message; } return response; }
public GetKpiTargetItemResponse GetKpiTargetByValue(GetKpiTargetRequestByValue request) { var response = new GetKpiTargetItemResponse(); PeriodeType periodeType = (PeriodeType)Enum.Parse(typeof(PeriodeType), request.PeriodeType); response.PeriodeType = periodeType; try { var kpiTarget = DataContext.KpiTargets.Include(x => x.Kpi).Single(x => x.Kpi.Id == request.Kpi_Id && x.PeriodeType == periodeType && x.Periode == request.periode); response = kpiTarget.MapTo<GetKpiTargetItemResponse>(); response.IsSuccess = true; } catch (InvalidOperationException invalidOperationException) { response.IsSuccess = false; response.Message = invalidOperationException.Message; } catch (ArgumentNullException argumentNullException) { response.IsSuccess = false; response.Message = argumentNullException.Message; } return response; }
public GetKpiTargetItemResponse GetKpiTarget(int kpiId, DateTime date, RangeFilter rangeFilter) { var response = new GetKpiTargetItemResponse(); try { switch (rangeFilter) { case RangeFilter.CurrentDay: case RangeFilter.CurrentMonth: case RangeFilter.CurrentYear: case RangeFilter.MTD: case RangeFilter.YTD: case RangeFilter.AllExistingYears: { var kpi = DataContext.Kpis .Include(x => x.Measurement) .Single(x => x.Id == kpiId); return GetKpiTarget(kpi.Id, date, rangeFilter, kpi.YtdFormula); } } } catch (Exception exception) { response.Message = exception.Message; } return response; }