private SalesReportIndexViewModel BuildIndexModel() { _dax.OpenConnection(); string daxQuery = @" EVALUATE VALUES(Calendario[Año]) ORDER BY Calendario[Año] DESC"; var reader = _dax.GetDaxResult(daxQuery); List <SelectListItem> years = new(); while (reader.Read()) { string year = reader[0].ToString(); years.Add(new SelectListItem(year, year)); } reader.Close(); _dax.CloseConnection(); return(new SalesReportIndexViewModel { Years = years }); }
private HomeIndexViewModel BuildIndexModel() { _dax.OpenConnection(); var model = new HomeIndexViewModel(); string daxQuery = @" DEFINE VAR maxYear = MAX ( Calendario[Año] ) EVALUATE CALCULATETABLE ( ROW ( ""Unidades Vendidas"", [Unidades Vendidas], ""Importe"", [Importe], ""% Beneficiario"", [% Beneficio] ), Calendario[Año] = maxYear )"; using (var reader = _dax.GetDaxResult(daxQuery)) { if (reader.Read()) { model.UnidadesVendidas = reader.GetInt64(0); model.Importe = reader.GetDecimal(1); model.Beneficio = reader.GetDecimal(2); } reader.Close(); } _dax.CloseConnection(); return(model); }