public ForecastItemValue GetForecastItemValue(Entity itemValue) { var forecastItemValue = new ForecastItemValue() { Id = GetEntityPrimaryColumnValue(itemValue), Value = (decimal)itemValue.GetColumnValue("Value"), ForecastIndicatorCode = itemValue.GetColumnValue("ForecastIndicator_Code").ToString(), PeriodName = itemValue.GetColumnValue("PeriodName").ToString(), ForecastIndicatorId = (Guid)itemValue.GetColumnValue("ForecastIndicatorId"), ForecastItemId = (Guid)itemValue.GetColumnValue("ForecastItemId"), PeriodId = (Guid)itemValue.GetColumnValue("PeriodId") }; return(forecastItemValue); }
private ForecastItemValue FindItemValueByPeriodAndIndicator(EntityCollection itemValuesCollection, Guid periodId, Guid indicatorId) { ForecastItemValue searchItem = null; foreach (Entity itemValue in itemValuesCollection) { if ((periodId == (Guid)itemValue.GetColumnValue("PeriodId")) && (indicatorId == (Guid)itemValue.GetColumnValue("ForecastIndicatorId"))) { searchItem = GetForecastItemValue(itemValue); break; } } return(searchItem); }
public ForecastItemValueResponse GetForecastValue(Guid forecastItemValueId) { var response = new ForecastItemValueResponse(); ForecastItemValue forecastItemValue = null; try { Entity itemValue = ForecastHelper.GetForecastValueEntity(forecastItemValueId); Guid forecastItemId = (Guid)itemValue.GetColumnValue("ForecastItemId"); bool canRead = ForecastHelper.CheckForecastItemRights(forecastItemId, SchemaRecordRightLevels.CanRead); if (canRead) { forecastItemValue = ForecastHelper.GetForecastItemValue(itemValue); } response.Success = true; } catch (Exception ex) { response.Success = false; response.Message = ex.Message; } response.ForecastItemValue = forecastItemValue; return(response); }
private ForecastHelper.ForecastItem[] GetDataCollection(ForecastData data) { return(data.Rows.Select(row => { var item = new ForecastHelper.ForecastItem { Name = row.Value, Id = row.Id, RowId = row.Cells.First().RowId, CanEdit = true }; List <ForecastItemValue> values = new List <ForecastItemValue>(); foreach (var column in data.Columns) { var cell = row.Cells.FirstOrDefault(e => e.PeriodId == column.Period.Id && e.IndicatorId == column.Indicator.Id); ForecastItemValue currentCellValue = cell == null ? CreateEmptyValue(column.Indicator.Id, column.Indicator.Code, column.Period.Id) : CreateValueFromCell(cell, column.Indicator.Code); values.Add(currentCellValue); } item.ForecastItemValues = values.ToArray(); return item; }).ToArray()); }