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("");
}
}
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));
}