public ActionResult TableResult(string Filter, string Value)
        {
            AD_GetQueryResultDL gr = new AD_GetQueryResultDL();

            ViewBag.TableResult = gr.Get(Filter, Value, null);
            return(PartialView("~/Views/AdminDashboard/_TableResult.cshtml"));
        }
        public ActionResult Chart(string Filter, string Value)
        {
            AD_GetQueryResultDL gr = new AD_GetQueryResultDL();

            ViewBag.Result = gr.Get(Filter, Value, null);
            //var dt= gr.Get(Filter, Value);
            //if (dt.Columns.Contains("x"))
            //{

            //}

            AV_WidgetsBL wb  = new AV_WidgetsBL();
            var          rec = wb.ToSingle("ByWidgetId", Value);

            return(PartialView("~/Views/AdminDashboard/_Chart.cshtml", rec));
        }