public GetKpiAchievementResponse GetKpiAchievementByValue(GetKpiAchievementRequestByValue request) { PeriodeType periodeType = (PeriodeType)Enum.Parse(typeof(PeriodeType), request.PeriodeType); var response = new GetKpiAchievementResponse(); response.PeriodeType = periodeType; try { var kpiAchievement = DataContext.KpiAchievements.Include(x => x.Kpi).Single(x => x.Kpi.Id == request.Kpi_Id && x.PeriodeType == periodeType && x.Periode == request.periode); response = kpiAchievement.MapTo<GetKpiAchievementResponse>(); 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 GetKpiAchievementResponse GetKpiAchievement(int kpiId, DateTime date, RangeFilter rangeFilter, YtdFormula ytdFormula) { var response = new GetKpiAchievementResponse(); try { switch (rangeFilter) { case RangeFilter.CurrentDay: { var kpi = DataContext.Kpis.Include(x => x.Measurement).Single(x => x.Id == kpiId); var data = DataContext.KpiAchievements.Include(x => x.Kpi).FirstOrDefault(x => x.Kpi.Id == kpiId && x.PeriodeType == PeriodeType.Daily && x.Periode == date); var kpiResponse = new GetKpiAchievementResponse.KpiResponse { Id = kpi.Id, Measurement = kpi.Measurement.Name, Name = kpi.Name, Remark = kpi.Remark, }; return new GetKpiAchievementResponse { 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.KpiAchievements.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 GetKpiAchievementResponse.KpiResponse { Id = kpi.Id, Measurement = kpi.Measurement.Name, Name = kpi.Name, Remark = kpi.Remark, }; return new GetKpiAchievementResponse { 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.KpiAchievements.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 GetKpiAchievementResponse.KpiResponse { Id = kpi.Id, Measurement = kpi.Measurement.Name, Name = kpi.Name, Remark = kpi.Remark, }; return new GetKpiAchievementResponse { 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.KpiAchievements.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 GetKpiAchievementResponse.KpiResponse { Id = kpi.Id, Measurement = kpi.Measurement.Name, Name = kpi.Name, Remark = kpi.Remark, }; return new GetKpiAchievementResponse { Value = kpiAchievement, Kpi = kpiResponse, IsSuccess = true }; } case RangeFilter.CurrentWeek: { DateTime lastWednesday = date; while (lastWednesday.DayOfWeek != DayOfWeek.Wednesday) lastWednesday = lastWednesday.AddDays(-1); var kpi = DataContext.Kpis.Include(x => x.Measurement).Single(x => x.Id == kpiId); var data = DataContext.KpiAchievements.Include(x => x.Kpi) .Where(x => x.Kpi.Id == kpiId && x.PeriodeType == PeriodeType.Daily && x.Value.HasValue && ((x.Periode.Year == lastWednesday.Year && x.Periode.Month == lastWednesday.Month && x.Periode.Day >= lastWednesday.Day) && (x.Periode.Year == date.Year && x.Periode.Month == date.Month && x.Periode.Day <= date.Day))).AsQueryable(); double? kpiAchievement = ytdFormula == YtdFormula.Average ? data.Average(x => x.Value) : data.Sum(x => x.Value); var kpiResponse = new GetKpiAchievementResponse.KpiResponse { Id = kpi.Id, Measurement = kpi.Measurement.Name, Name = kpi.Name, Remark = kpi.Remark, }; return new GetKpiAchievementResponse { Value = kpiAchievement, Kpi = kpiResponse, IsSuccess = true }; } } } catch (Exception exception) { response.Message = exception.Message; } return response; }
public GetKpiAchievementResponse GetKpiAchievement(int kpiId, DateTime date, RangeFilter rangeFilter) { var response = new GetKpiAchievementResponse(); try { switch (rangeFilter) { case RangeFilter.CurrentDay: case RangeFilter.MTD: case RangeFilter.YTD: case RangeFilter.AllExistingYears: case RangeFilter.CurrentWeek: { var kpi = DataContext.Kpis .Include(x => x.Measurement) .Single(x => x.Id == kpiId); return GetKpiAchievement(kpi.Id, date, rangeFilter, kpi.YtdFormula); } } } catch (Exception exception) { response.Message = exception.Message; } return response; }