//public ActionResult<IEnumerable<LayoutData>> Get()
public ActionResult <IEnumerable <TableProps> > Get()
{
IsaeDwAccessor accessor = new IsaeDwAccessor("192.168.56.130\\ISAESQLSERVER");
List <TableProps> retList = accessor.GetDimensions();
return(retList);
}
//public ActionResult<IEnumerable<LayoutData>> Get()
public ActionResult <Dictionary <string, Dictionary <string, List <string> > > > Get()
{
IsaeDwAccessor accessor = new IsaeDwAccessor("192.168.56.130\\ISAESQLSERVER");
Dictionary <string, Dictionary <string, List <string> > > retDict = accessor.GetConsolidatedHierarchyKpi();
return(retDict);
}
static void Main(string[] args)
{
IsaeDwAccessor accessor = new IsaeDwAccessor();
accessor.GenerateDummyVendorStatusData(new RequestData()
{
Parameters = new List <RequestParam>()
});
}
public ActionResult <IEnumerable <ResultData> > Post(RequestData request)
{
IsaeDwAccessor accessor = new IsaeDwAccessor("192.168.56.130\\ISAESQLSERVER");
Console.WriteLine("Post");
List <ResultData> retData = accessor.queryData(request);
return(null);
}
public ActionResult <IEnumerable <ResultData> > Post(RequestData request)
{
IsaeDwAccessor accessor = new IsaeDwAccessor("localhost");
Console.WriteLine("Post");
//List<ResultData> retData = accessor.queryData(request);
return(null);
}
public Dictionary <string, object> Post(RequestData requestData)
{
//IsaeDwAccessor accessor = new IsaeDwAccessor("192.168.56.130\\ISAESQLSERVER");
IsaeDwAccessor accessor = new IsaeDwAccessor();
Console.WriteLine("Post");
Dictionary <string, object> retDict = accessor.queryData(requestData);
Thread.Sleep(300);
return(retDict);
}
// access via http://localhost:60000/api/Hierarchy/conso
public ActionResult <IEnumerable <HierarchyBase> > GetConsolidated()
{
// Get the "flat" hierarchy from the database first, then call another function to hydrate the children
IsaeDwAccessor accessor = new IsaeDwAccessor("192.168.56.130\\ISAESQLSERVER");
List <HierarchyBase> hierConsoList = accessor.GetConsolidatedHierarchy();
HierarchyHelper.HydrateHierarchyChildren(hierConsoList);
// return the root children only
var rootChildrenQry = hierConsoList.Where(h => h.ParentId == null);
return(rootChildrenQry.ToList());
}
