static ResultTable ExecuteChart <T>(ChartRequest request, DynamicQueryCore <T> dq) { List <Column> columns = request.Columns.Where(c => c.Token != null).Select(t => t.CreateColumn()).ToList(); var multiplications = request.Multiplications;; using (ExecutionMode.UserInterface()) { if (!request.GroupResults) { return(dq.ExecuteQuery(new QueryRequest { QueryName = request.QueryName, Columns = columns, Filters = request.Filters, Orders = request.Orders, Pagination = new Pagination.All(), })); } else { return(dq.ExecuteQueryGroup(new QueryGroupRequest { QueryName = request.QueryName, Columns = columns, Filters = request.Filters, Orders = request.Orders })); } } }
static MenuItem SearchControl_GetCustomMenuItems(SearchControl sc) { if (!ChartPermission.ViewCharting.IsAuthorized()) { return(null); } var miResult = new MenuItem { Header = ChartMessage.Chart.NiceToString(), Icon = ExtensionsImageLoader.GetImageSortName("chartIcon.png").ToSmallImage() }; miResult.Click += delegate { var cr = new ChartRequest(sc.QueryName) { Filters = sc.FilterOptions.Select(fo => fo.ToFilter()).ToList(), }; ChartClient.OpenChartRequest(cr, null, null); }; return(miResult); }
private async void GetAllProducts() { using (var client = new HttpClient()) { client.BaseAddress = new Uri("http://localhost:3199/"); client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); // HTTP POST ChartRequest Data = new ChartRequest { ChartId = 1, FilterDetails = new List <FilterData> { new FilterData { FilterId = 1, SelectedFilterIDs = new List <int>(new int[] { 1, 2, 3 }) } } }; var response = await client.PostAsJsonAsync("getFilteredChart/Data", Data); if (response.IsSuccessStatusCode) { var productJsonString = await response.Content.ReadAsStringAsync(); // MobileBO.Chart c = JsonConvert.DeserializeObject<MobileBO.Chart>(productJsonString); richTextBox1.Text = JsonConvert.DeserializeObject(productJsonString).ToString(); } } }
public ActionResult ViewUserChart(Lite <UserChartEntity> lite, Lite <Entity> currentEntity) { UserChartEntity uc = UserChartLogic.RetrieveUserChart(lite); ChartRequest request = (uc.EntityType == null ? null : CurrentEntityConverter.SetCurrentEntity(currentEntity.Retrieve())) .Using(_ => uc.ToRequest()); return(OpenChartRequest(request, uc.ToLite())); }
static void TestChartRequest() { var chartRequest = new ChartRequest("AMCI", Range.ThreeMonth); var response = chartRequest.SendRequestAsync().GetAwaiter().GetResult(); var average = response.Average(a => a.close); Console.WriteLine("Apple Average close: {0}", average); }
public async Task <ExecuteChartResult> Execute(ChartRequest request, CancellationToken token) { var resultTable = await ChartLogic.ExecuteChartAsync(request, token); var chartTable = ChartUtils.DataJson(request, resultTable); return(new ExecuteChartResult { resultTable = resultTable, chartTable = chartTable }); }
public async Task <HttpResponseMessage> ToPlainExcel(ChartRequest request, CancellationToken token) { var resultTable = await ChartLogic.ExecuteChartAsync(request, token); byte[] binaryFile = PlainExcelGenerator.WritePlainExcel(resultTable, QueryUtils.GetNiceName(request.QueryName)); var fileName = request.ChartScript.ToString() + " " + QueryUtils.GetKey(request.QueryName) + TimeZoneManager.Now.ToString("yyyyMMdd-HHmmss") + ".xlsx"; return(FilesController.GetHttpReponseMessage(new MemoryStream(binaryFile), fileName)); }
static List <Order> ExtractChartOrders(MappingContext <List <Order> > ctx) { var qd = DynamicQueryManager.Current.QueryDescription( Finder.ResolveQueryName(ctx.Controller.ControllerContext.HttpContext.Request.Params["webQueryName"])); ChartRequest chartRequest = (ChartRequest)ctx.Parent.UntypedValue; return(FindOptionsModelBinder.ExtractOrderOptions(ctx.Controller.ControllerContext.HttpContext, qd, canAggregate: true /*chartRequest.GroupResults*/) .Select(fo => fo.ToOrder()).ToList()); }
ViewResult OpenChartRequest(ChartRequest request, Lite <UserChartEntity> currentUserChart) { ViewData[ViewDataKeys.Title] = QueryUtils.GetNiceName(request.QueryName); ViewData[ViewDataKeys.QueryDescription] = DynamicQueryManager.Current.QueryDescription(request.QueryName);; ViewData[ViewDataKeys.FilterOptions] = request.Filters.Select(f => new FilterOption { Token = f.Token, Operation = f.Operation, Value = f.Value }).ToList(); ViewData["UserChart"] = currentUserChart; return(View(ChartClient.ChartRequestView, new TypeContext <ChartRequest>(request, ""))); }
public async Task <ChartResponse> Get( [FromBody] ChartRequest chartRequest, [FromServices] ICurrencySource currencySource) { var res = await currencySource.GetHistory( "verge", DateTime.UtcNow.AddDays(-1), DateTime.UtcNow); return(null); }
public async Task <bool> UpdateEntityByIdAsync(ChartRequest request, int id) { var entity = _mapper.Map <ChartRequest, Chart>(request); entity.Id = id; // In returns updated entity, you could do smth with it or just leave as it is var updated = await _uow.ChartsRepository.UpdateAsync(entity); var result = await _uow.SaveAsync(); return(result); }
public ContentResult AddFilter(string webQueryName, string tokenName, int index) { ChartRequest request = this.ExtractChartRequestCtx(null).Value; QueryDescription qd = DynamicQueryManager.Current.QueryDescription(request.QueryName); var token = QueryUtils.Parse(tokenName, qd, SubTokensOptions.CanAnyAll | SubTokensOptions.CanElement | (request.GroupResults ? SubTokensOptions.CanAggregate : 0)); FilterOption fo = new FilterOption(tokenName, null) { Token = token, Operation = QueryUtils.GetFilterOperations(QueryUtils.GetFilterType(token.Type)).FirstEx(), }; return(Content(FilterBuilderHelper.NewFilter( FinderController.CreateHtmlHelper(this), fo, new Context(null, this.Prefix()), index).ToHtmlString())); }
public virtual async Task <ActionResult> Update([FromRoute] int id, [FromBody] ChartRequest request) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var result = await _chartsService.UpdateEntityByIdAsync(request, id); if (!result) { return(StatusCode(500)); } return(NoContent()); }
public virtual async Task <ActionResult <ChartDto> > Create([FromBody] ChartRequest request) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var dto = await _chartsService.CreateEntityAsync(request); if (dto == null) { return(StatusCode(500)); } return(CreatedAtAction("GetById", new { id = dto.Id }, dto)); }
public async Task <IActionResult> Index(CancellationToken cancellationToken) { var userId = this.GetUserId(); var overviewByCategory = await mediator.Send(new OverviewByCategoryRequest(userId), cancellationToken); ViewData["overviewByCategory"] = overviewByCategory; ViewData["maxExpensiveCategory"] = overviewByCategory .OrderByDescending(it => it.Value.Debet) .FirstOrDefault(); var graphData = await mediator.Send(ChartRequest.Last30Days(userId), cancellationToken); ViewData["lastThirtyDays"] = graphData; return(View()); }
public static JObject ToChartRequest(this ChartRequest request, UrlHelper url, string prefix, ChartRequestMode mode) { return(new JObject { { "prefix", prefix }, { "webQueryName", Finder.ResolveWebQueryName(request.QueryName) }, { "orders", new JArray(request.Orders.Select(o => new JObject { { "orderType", (int)o.OrderType }, { "columnName", o.Token.FullKey() } })) }, { "updateChartBuilderUrl", url.Action <ChartController>(cc => cc.UpdateChartBuilder(prefix)) }, { "fullScreenUrl", url.Action <ChartController>(cc => cc.FullScreen(prefix)) }, { "addFilterUrl", url.Action("AddFilter", "Chart") }, { "drawUrl", url.Action <ChartController>(cc => cc.Draw(prefix)) }, { "openUrl", url.Action <ChartController>(cc => cc.OpenSubgroup(prefix)) }, { "mode", (int)mode } }); }
private void New_Clicked(object sender, RoutedEventArgs e) { e.Handled = true; UserChartEntity userChart = ChartRequest.ToUserChart(); userChart = Navigator.View(userChart, new ViewOptions { AllowErrors = AllowErrors.No, View = new UserChart { QueryDescription = Description } }); Initialize(); if (userChart != null) { CurrentUserChart = userChart; } }
private async void GetAllProducts() { using (var client = new HttpClient()) { client.BaseAddress = new Uri("http://localhost:3199/"); client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); // HTTP POST ChartRequest Data = new ChartRequest { ChartId = 1, FilterDetails = new List<FilterData> { new FilterData { FilterId = 1, SelectedFilterIDs = new List<int>(new int[] { 1, 2, 3 }) } } }; var response = await client.PostAsJsonAsync("getFilteredChart/Data", Data); if (response.IsSuccessStatusCode) { var productJsonString = await response.Content.ReadAsStringAsync(); // MobileBO.Chart c = JsonConvert.DeserializeObject<MobileBO.Chart>(productJsonString); richTextBox1.Text = JsonConvert.DeserializeObject(productJsonString).ToString(); } } }
//Convert the Time to UNIX #region public ChartRequest ConvertTimeToUNIX(Currency currency) { using (var context = new DbInitializer()) { //Converts the time value to UNIX DateTime unixStart = new DateTime(1970, 1, 1, 0, 0, 0, 0, System.DateTimeKind.Utc); long unixTimeStampInTicks = (currency.Time.ToUniversalTime() - unixStart).Ticks; var unix = Convert.ToInt32((double)unixTimeStampInTicks / TimeSpan.TicksPerSecond); ChartRequest chartData = new ChartRequest { Time = unix, Rate = currency.Rate, Name = currency.Name }; return(chartData); } }
internal static ChartRequest ToChartRequest(UserChartEntity userChart) { var cr = new ChartRequest(userChart.Query.ToQueryName()) { ChartScript = userChart.ChartScript, Filters = userChart.Filters.Select(qf => new Filter(qf.Token.Token, qf.Operation, FilterValueConverter.Parse(qf.ValueString, qf.Token.Token.Type, qf.Operation.IsList()))) .ToList(), GroupResults = userChart.GroupResults, Orders = userChart.Orders.Select(qo => new Order(qo.Token.Token, qo.OrderType)).ToList(), Parameters = userChart.Parameters.ToMList(), }; cr.Columns.ZipForeach(userChart.Columns, (a, b) => { a.Token = b.Token == null ? null : new QueryTokenEmbedded(b.Token.Token); a.DisplayName = b.DisplayName; }); return(cr); }
public ActionResult Index(FindOptions findOptions) { ChartPermission.ViewCharting.AssertAuthorized(); if (!Finder.IsFindable(findOptions.QueryName)) { throw new UnauthorizedAccessException(ChartMessage.Chart_Query0IsNotAllowed.NiceToString().FormatWith(findOptions.QueryName)); } QueryDescription queryDescription = DynamicQueryManager.Current.QueryDescription(findOptions.QueryName); FilterOption.SetFilterTokens(findOptions.FilterOptions, queryDescription, false); var request = new ChartRequest(findOptions.QueryName) { ChartScript = ChartScriptLogic.Scripts.Value.Values.FirstEx(() => "No ChartScript loaded in the database"), Filters = findOptions.FilterOptions.Select(fo => fo.ToFilter()).ToList() }; return(OpenChartRequest(request, null)); }
public async Task <ChartDto> CreateEntityAsync(ChartRequest request) { var entity = _mapper.Map <ChartRequest, Chart>(request); entity = await _uow.ChartsRepository.CreateAsync(entity); var result = await _uow.SaveAsync(); if (!result) { return(null); } if (entity == null) { return(null); } var dto = _mapper.Map <Chart, ChartDto>(entity); return(dto); }
private IEnumerator CommunicateWithServer() { string url = BASE_URL + "debug/temperature/"; ChartRequest chartRequest = new ChartRequest(); string jsonString = JsonUtility.ToJson(chartRequest); UnityWebRequest request = UnityWebRequest.Post(url, jsonString); request.SetRequestHeader("Content-Type", "application/json"); request.SetRequestHeader("Accept", "application/json"); yield return(request.SendWebRequest()); if (!request.isNetworkError && request.responseCode == 200) { Debug.Log("Success."); Debug.Log(request.downloadHandler.text); string stringResponse = request.downloadHandler.text; chartResponse = JsonConvert.DeserializeObject <ChartResponse>( stringResponse); } else { Debug.Log("Fail"); Debug.Log(request.responseCode); Debug.Log(request.error); chartResponse = new ChartResponse { success = false, errorMsg = request.error, }; } UpdateUI(); }
public ContentResult NewSubTokensCombo(string webQueryName, string tokenName, int options) { ChartRequest request = this.ExtractChartRequestCtx(null).Value; SubTokensOptions ops = (SubTokensOptions)options; if (request.GroupResults) { ops = ops | SubTokensOptions.CanAggregate; } else { ops = ops & ~SubTokensOptions.CanAggregate; } QueryDescription qd = DynamicQueryManager.Current.QueryDescription(request.QueryName); QueryToken token = QueryUtils.Parse(tokenName, qd, ops); var combo = FinderController.CreateHtmlHelper(this).QueryTokenBuilderOptions(token, new Context(null, this.Prefix()), ChartClient.GetQueryTokenBuilderSettings(qd, ops)); return(Content(combo.ToHtmlString())); }
public MappingContext <ChartRequest> ExtractChartRequestCtx(int?lastTokenChanged) { var ctx = new ChartRequest(Finder.ResolveQueryName(Request.Params["webQueryName"])) .ApplyChanges(this, ChartClient.MappingChartRequest, inputs: Request.Params.ToSortedList(this.Prefix())); ctx.Value.CleanOrderColumns(); ChartRequest chart = ctx.Value; if (lastTokenChanged != null) { if (lastTokenChanged == -1) { chart.ChartScript.SynchronizeColumns(chart); } else { chart.Columns[lastTokenChanged.Value].TokenChanged(); } } return(ctx); }
internal static void OpenChartRequest(ChartRequest chartRequest, UserChartEntity uc, Entity currentEntity) { Navigator.OpenIndependentWindow(() => { var crw = new ChartRequestWindow() { DataContext = chartRequest, Title = ChartMessage.ChartOf0.NiceToString().FormatWith(QueryUtils.GetNiceName(chartRequest.QueryName)), Icon = Finder.Manager.GetFindIcon(chartRequest.QueryName, false) ?? ExtensionsImageLoader.GetImageSortName("chartIcon.png") }; if (uc != null) { SetUserChart(crw, uc); } if (currentEntity != null) { UserAssetsClient.SetCurrentEntity(crw, currentEntity); } return(crw); }); }
public static ResultTable ExecuteChart(ChartRequest request) { IDynamicQueryCore core = DynamicQueryManager.Current.TryGetQuery(request.QueryName).Core.Value; return(miExecuteChart.GetInvoker(core.GetType().GetGenericArguments()[0])(request, core)); }
public UserChartEntity FromQueryRequest(ChartRequest request) { return(request.ToUserChart()); }
public JsonResult GetChartData(ChartRequest request) { var KPIValues = new List <ChartKPIValues>(); using (var dbContext = new DatabaseContext()) { // var kpiName = request.KPIName; // var kpiName = "RACH Preamble Response Success Rate"; // X PLMN KPI = SUM(X KPI Nem, for all the day for all the meneged elements)/ // SUM(Den of X KPI of all the day for all the managed elements) ; if (request.KpiId != null && request.KpiId.Length > 0) { foreach (var id in request.KpiId) { var records = dbContext.ericsson_kpi_data.Where(k => k.KPIId == id && k.ManagedElement == k.ManagedElement).ToList(); var KPI = new ChartKPIValues(); var chartValues = new ChartValues(); chartValues.ChartData = new List <string>(); var date = System.DateTime.Now; if (request.Date != null) { date = Convert.ToDateTime(request.Date); } chartValues.Labels = new List <string>(); if (request.Trend == "Monthly") { //var daysOfMonth = this.GetDays(date.Year, date.Month); //var recordquery = from r in records // group r by new // { // r.CreatedDate.Day, // r.CreatedDate.Month, // r.CreatedDate.Year, // } into gcs // select new // { // Day = gcs.Key.Day, // Numerator = gcs.Sum(x=>x.Numerator), // Denominator = gcs.Sum(x=>x.Denominator) // }; //var dsd = recordquery.ToList(); //var finallist = (from d in daysOfMonth // join rq in recordquery on d equals rq.Day into gj // from days in gj.DefaultIfEmpty() // select new { // Day = d, // KPIValue = days?.Denominator != null && days?.Denominator > 0 ? days?.Numerator / days?.Denominator : days?.Numerator // }).ToList(); //var dd = finallist; foreach (var item in this.GetDays(date.Year, date.Month)) { if (!string.IsNullOrEmpty(Convert.ToString(item))) { var dayRecord = records.Where(g => g.CreatedDate.Day == item && g.CreatedDate.Month == date.Month); var numeratorSum = 0M; var denominatorSum = 0M; var dayKPIValue = numeratorSum; if (dayRecord.Any()) { numeratorSum = dayRecord.Sum(s => s.Numerator); denominatorSum = dayRecord.Sum(s => s.Denominator); if (denominatorSum > 0) { dayKPIValue = numeratorSum / denominatorSum; } } chartValues.ChartData.Add(dayKPIValue.ToString()); chartValues.Labels.Add(string.Format("{0}/{1}/{2}", date.Year, date.Month.ToString("00"), item.ToString("00"))); } } } else { // chartValues.Labels = System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.MonthNames.ToList(); for (var i = 0; i <= 23; i++) { // var dayValue = records.Where(g => DateTime.ParseExact(g.CreatedDate, "dd-MM-yyyy", CultureInfo.InvariantCulture).Month == i).Sum(s => s.KPIValue.ToDecimal()); var hourRecord = records.Where(g => g.CreatedDate.Hour == i); var numeratorSum = 0M; var denominatorSum = 0M; var hourKPIValue = numeratorSum; if (hourRecord.Any()) { numeratorSum = hourRecord.Sum(s => s.Numerator); denominatorSum = hourRecord.Sum(s => s.Denominator); if (denominatorSum > 0) { hourKPIValue = numeratorSum / denominatorSum; } } chartValues.Labels.Add(i.ToString()); chartValues.ChartData.Add(hourKPIValue.ToString()); } } KPI.KPI = dbContext.kpimaster.FirstOrDefault(s => s.KPIId == id).KPIName; KPI.ChartData = chartValues; KPIValues.Add(KPI); } } } return(Json(KPIValues, JsonRequestBehavior.AllowGet)); }
public override void Execute() { WriteLiteral("\r\n\r\n"); #line 11 "..\..\Dashboard\Views\UserChartPart.cshtml" Write(Html.ScriptCss("~/Chart/Content/Chart.css")); #line default #line hidden WriteLiteral("\r\n\r\n"); #line 13 "..\..\Dashboard\Views\UserChartPart.cshtml" using (var tc = Html.TypeContext <UserChartPartEntity>()) { UserChartEntity uc = tc.Value.UserChart; ChartRequest request = uc.ToRequest(); using (var crc = new TypeContext <ChartRequest>(request, tc.Prefix)) { #line default #line hidden WriteLiteral(" <div"); WriteAttribute("id", Tuple.Create(" id=\"", 541), Tuple.Create("\"", 576) #line 20 "..\..\Dashboard\Views\UserChartPart.cshtml" , Tuple.Create(Tuple.Create("", 546), Tuple.Create <System.Object, System.Int32>(crc.Compose("sfChartControl") #line default #line hidden , 546), false) ); WriteLiteral(" class=\"sf-chart-control SF-control-container\""); WriteLiteral(">\r\n <div"); WriteLiteral(" style=\"display: none\""); WriteLiteral(">\r\n"); WriteLiteral(" "); #line 22 "..\..\Dashboard\Views\UserChartPart.cshtml" Write(Html.HiddenRuntimeInfo(crc)); #line default #line hidden WriteLiteral("\r\n"); WriteLiteral(" "); #line 23 "..\..\Dashboard\Views\UserChartPart.cshtml" Write(Html.Hidden(crc.Compose("sfOrders"), request.Orders.IsNullOrEmpty() ? "" : (request.Orders.ToString(oo => (oo.OrderType == OrderType.Ascending ? "" : "-") + oo.Token.FullKey(), ";") + ";"))); #line default #line hidden WriteLiteral("\r\n"); #line 25 "..\..\Dashboard\Views\UserChartPart.cshtml" #line default #line hidden #line 25 "..\..\Dashboard\Views\UserChartPart.cshtml" ViewData[ViewDataKeys.QueryDescription] = DynamicQueryManager.Current.QueryDescription(request.QueryName); ViewData[ViewDataKeys.FilterOptions] = request.Filters.Select(f => new FilterOption { Token = f.Token, Operation = f.Operation, Value = f.Value }).ToList(); #line default #line hidden WriteLiteral("\r\n"); WriteLiteral(" "); #line 29 "..\..\Dashboard\Views\UserChartPart.cshtml" Write(Html.Partial(Finder.Manager.FilterBuilderView, crc)); #line default #line hidden WriteLiteral("\r\n <div"); WriteAttribute("id", Tuple.Create(" id=\"", 1325), Tuple.Create("\"", 1369) #line 30 "..\..\Dashboard\Views\UserChartPart.cshtml" , Tuple.Create(Tuple.Create("", 1330), Tuple.Create <System.Object, System.Int32>(crc.Compose("sfChartBuilderContainer") #line default #line hidden , 1330), false) ); WriteLiteral(" class=\"SF-control-container\""); WriteLiteral(">\r\n"); WriteLiteral(" "); #line 31 "..\..\Dashboard\Views\UserChartPart.cshtml" Write(Html.Partial(ChartClient.ChartBuilderView, crc)); #line default #line hidden WriteLiteral("\r\n </div>\r\n <script"); WriteLiteral(" type=\"text/javascript\""); WriteLiteral(">\r\n require([\""); #line 34 "..\..\Dashboard\Views\UserChartPart.cshtml" Write(ChartClient.Module); #line default #line hidden WriteLiteral("\"], function (Chart) {\r\n var options = "); #line 35 "..\..\Dashboard\Views\UserChartPart.cshtml" Write(MvcHtmlString.Create(uc.ToRequest().ToChartRequest(Url, tc.Prefix, tc.Value.ShowData ? ChartRequestMode.data: ChartRequestMode.chart).ToString())); #line default #line hidden WriteLiteral(";\r\n new Chart.ChartRequest(options);\r\n });\r\n " + " </script>\r\n </div> \r\n <div"); WriteAttribute("id", Tuple.Create(" id=\"", 1919), Tuple.Create("\"", 1952) #line 40 "..\..\Dashboard\Views\UserChartPart.cshtml" , Tuple.Create(Tuple.Create("", 1924), Tuple.Create <System.Object, System.Int32>(Model.Compose("divResults") #line default #line hidden , 1924), false) ); WriteLiteral(" class=\"sf-search-results-container\""); WriteLiteral(">\r\n"); WriteLiteral(" "); #line 41 "..\..\Dashboard\Views\UserChartPart.cshtml" Write(JavascriptMessage.searchForResults.NiceToString()); #line default #line hidden WriteLiteral("\r\n </div>\r\n </div>\r\n"); #line 44 "..\..\Dashboard\Views\UserChartPart.cshtml" } } #line default #line hidden }
public static Task <ResultTable> ExecuteChartAsync(ChartRequest request, CancellationToken token) { IDynamicQueryCore core = DynamicQueryManager.Current.TryGetQuery(request.QueryName).Core.Value; return(miExecuteChartAsync.GetInvoker(core.GetType().GetGenericArguments()[0])(request, core, token)); }