Esempio n. 1
0
        public string getValuePair(string id, string param)
        {
            if (param.isNull())
            {
            }

            var pairs = new List <ValuePair>();
            WarehouseInterface warehouse = new InlaksBIContext().getWarehouse(new Settings().warehousedbtype);

            switch (id.CleanUp())
            {
            case "resources":
                int mid = param.toInt();

                var res = new InlaksBIContext().Resources.Where(r => r.Module.ModuleID == mid).ToList();

                foreach (var re in res)
                {
                    ValuePair pair = new ValuePair();
                    pair.ID    = re.ResourceID.ToString();
                    pair.Value = re.ResourceName;
                    pairs.Add(pair);
                }

                return(JsonConvert.SerializeObject(pairs));


            case "dataset":
                int modid  = param.toInt();
                var module = new InlaksBIContext().Modules.FirstOrDefault(m => m.ModuleID == modid);

                pairs = warehouse.getDataSets(module.value);
                return(JsonConvert.SerializeObject(pairs));

            case "datasetcolumns":

                pairs = warehouse.getViewColumns(param);
                return(JsonConvert.SerializeObject(pairs));


            default:
                return("");
            }
        }
Esempio n. 2
0
        public string getFilterColumns(string id)
        {
            WarehouseInterface warehouse = new InlaksBIContext().getWarehouse(new Settings().warehousedbtype);
            var pairs   = warehouse.getViewColumns(id);
            var filters = new List <DataSetFilter>();

            foreach (var pair in pairs)
            {
                var filter = new DataSetFilter();
                filter.ColumnName  = pair.ID;
                filter.ColumnValue = pair.Value;

                filter.IsIncluded = false;
                filters.Add(filter);
            }


            return(JsonConvert.SerializeObject(filters));
        }