public IActionResult AccountChartInfo() { var user = _userService?.GetCurrent(); //проект не грузится, если юзер не залогинен if (user != null) { var currencies = user.BankAccounts.Select(x => x.Currency).Distinct(); var chartViewModel = new ChartViewModel(); chartViewModel.Labels = currencies.Select(x => x.ToString()).ToList(); var datasetViewModel = new DatasetViewModel() { Label = "Валюты" }; datasetViewModel.Data = currencies.Select(c => user.BankAccounts .Where(b => b.Currency == c) .Select(b => b.Amount) .Sum()) .ToList(); chartViewModel.Datasets.Add(datasetViewModel); return(Json(chartViewModel)); } return(Json("null user")); }
public ActionResult Create(DatasetViewModel datasetViewModel) { if (ModelState.IsValid) { string currentUserId = User.Identity.GetUserId(); ApplicationUser currentUser = db.Users.FirstOrDefault(y => y.Id == currentUserId); // Prepare metadata file byte[] metadataFileBytes = datasetService.CreateMetadataFile(datasetViewModel.TemporalPropertyID, datasetViewModel.TemporalPropertyName, datasetViewModel.Description); string datasetPath = datasetService.getPath(id); // Create Dataset model Dataset dataset = datasetService.CreateDatasetFromDatasetViewModel(datasetViewModel, id, currentUser, metadataFileBytes, datasetPath); dataset.Size = ((double)Request.Files["datasetFile"].ContentLength / 1024) / 1024; Stream s = Request.Files["datasetFile"].InputStream; BinaryReader br = new BinaryReader(s); byte[] file = br.ReadBytes((Int32)s.Length); dataset.DatasetFile = file; //Save dataset's information in database datasetRepository.Add(dataset); datasetRepository.SaveChanges(); return(RedirectToAction("Index")); } return(Json(new { success = false })); }
public IActionResult AccountsChartInfoDraw() { var user = _userService.GetCurrent(); var currencies = user.BankAccounts.Select(x => x.Currency).Distinct(); var chartViewModel = new ChartViewModel(); chartViewModel.Labels = currencies.Select(x => x.ToString()).ToList(); var datasetViewModel = new DatasetViewModel() { Label = "Валюты" }; datasetViewModel.Data = currencies.Select(c => user.BankAccounts .Where(b => b.Currency == c) .Select(b => b.Amount) .Sum()) .ToList(); chartViewModel.Datasets.Add(datasetViewModel); return(Json(chartViewModel)); }
public IActionResult BankCurrensyChartInfo() { var allCurrency = new List <Currency>() { Currency.EUR, Currency.USD }; var chartViewModel = new ChartViewModel(); chartViewModel.Labels = allCurrency.Select(x => x.ToString()).ToList(); var datasetEURViewModel = new DatasetViewModel() { Label = "Rates" }; datasetEURViewModel.Data = allCurrency .Select(cur => _currencyService.ConvertAmount(cur)) .ToList(); //allCurrency.Select(x => // _currencyService.ConvertAmount(Currency.EUR) // ) //.ToList(); chartViewModel.Datasets.Add(datasetEURViewModel); return(Json(chartViewModel)); }
public async Task <IActionResult> AddFieldDataset(string id) { var dataset = await _queryService.GetDatasetById(id); DatasetViewModel model = _mapper.Map <DatasetViewModel>(dataset); TempData["dataSetName"] = model.Name; return(View(model)); }
public void BestLanguageMatchReturnsUnscopedLiteralWhenNoMatch(string json, string prefLang, string expect) { var uriService = new DataDockUriService("http://datadock.io/"); var testModel = new DatasetViewModel(uriService, new DatasetInfo { CsvwMetadata = JObject.Parse(json) }, prefLang); testModel.Title.Should().Be(expect); }
public DatasetViewModel Map(IEnumerable <Dataset> datasets) { var datasetViewModel = new DatasetViewModel(); foreach (var dataset in datasets) { datasetViewModel.Datasets.Add(Map(dataset)); } return(datasetViewModel); }
public async Task <ActionResult> Index(string workspaceid, string datasetid) { if (string.IsNullOrEmpty(workspaceid) || string.IsNullOrEmpty(datasetid)) { return(RedirectToAction("Index", "Workspaces")); } DatasetViewModel viewModel = await PowerBiServiceApiManager.GetDatasetAsync(workspaceid, datasetid); return(View(viewModel)); }
/// <summary> /// Initializes a new instance of the <see cref="RunBatchProcessingTaskWindowViewModel"/> class. /// </summary> /// <param name="visualizationContainer">The visualization container.</param> /// <param name="datasetViewModel">The dataset view model.</param> /// <param name="batchProcessingTaskMetadata">The batch processing task metadata.</param> public RunBatchProcessingTaskWindowViewModel(VisualizationContainer visualizationContainer, DatasetViewModel datasetViewModel, BatchProcessingTaskMetadata batchProcessingTaskMetadata) { this.visualizationContainer = visualizationContainer; this.datasetViewModel = datasetViewModel; this.batchProcessingTaskMetadata = batchProcessingTaskMetadata; this.Name = batchProcessingTaskMetadata.Name; this.Description = batchProcessingTaskMetadata.Description; this.Target = datasetViewModel.Name; this.DataSize = TimeSpanFormatHelper.FormatTimeSpanApproximate( new TimeSpan(datasetViewModel.SessionViewModels.Sum(svm => svm.OriginatingTimeInterval.Span.Ticks))); this.Configuration = batchProcessingTaskMetadata.GetDefaultConfiguration(); }
public IActionResult Create() { if (!_securityService.CurrrentUserHasAccessToOrganization(CurrentOrganizationId(), AccessLevel.Write)) { return(Forbid()); } SimpleOrganization currentOrganization = CurrentOrganization(); var model = new DatasetViewModel(); model.OrganizationId = currentOrganization.Id; return(View(model)); }
/// <summary> /// The Test. /// </summary> /// <param name="testWindow">The testWindow<see cref="Window"/>.</param> protected override void Test(MetroWindow testWindow) { var globalData = new GlobalData { MainWindow = testWindow }; var viewModel = new DatasetViewModel(globalData) { CsvFilePath = TestData.CountryTestCsv }; var view = new DatasetView { DataContext = viewModel }; WindowFactory.CreateAndShow(view, testWindow); }
public async Task <IActionResult> AnalysisDataSelector(string analysisName) { IEnumerable <Script> scripts = await repository.GetScripts(); AnalysisDataSelectorViewModel viewModel = new AnalysisDataSelectorViewModel(); if (analysisName != null) { viewModel.AnalysisName = analysisName; Script script = scripts.Single(x => x.ScriptFileName == analysisName); if (!script.RequiresDataset) { return(RedirectToAction("Analysis", viewModel)); } viewModel.AnalysisDisplayName = script.ScriptDisplayName; } IEnumerable <DatasetViewModel> theDatasets = await repository.GetDatasetViewModels(); ViewBag.HasDatasets = theDatasets.Any(); if (theDatasets.Any()) { //get the scripts viewModel.Scripts = scripts; //add the last uploaded dataset in first List <DatasetViewModel> datasetInfoList = new List <DatasetViewModel>(); DatasetViewModel lastUploadedDataset = theDatasets.OrderByDescending(x => x.DatasetID).First(); datasetInfoList.Add(lastUploadedDataset); //then add all the other datasets in alphabetical order foreach (DatasetViewModel dvm in theDatasets.Where(x => x.DatasetID != lastUploadedDataset.DatasetID).OrderBy(x => x.DatasetName).ThenBy(x => x.VersionNo)) { datasetInfoList.Add(dvm); } viewModel.Datasets = datasetInfoList.AsEnumerable <DatasetViewModel>(); } return(View(viewModel)); }
public async Task <IActionResult> Create([Bind("Id,Name,Description,Purpose,AccessRight,HasPersonalData,HasSensitivePersonalData,HasMasterData,HostingLocation,PublishedToSharedDataCatalog," + "Application,OrganizationId")] DatasetViewModel dataset) { if (!_securityService.CurrrentUserHasAccessToOrganization(CurrentOrganizationId(), AccessLevel.Write)) { return(Forbid()); } if (ModelState.IsValid) { dataset.OrganizationId = CurrentOrganizationId(); await _datasetService.Create(new DatasetViewModel().Map(dataset)); return(RedirectToAction(nameof(Index))); } return(View(dataset)); }
public async Task <IActionResult> Edit(int id, [Bind("Id,Name,Description,Purpose,AccessRight,HasPersonalData,HasSensitivePersonalData,HasMasterData," + "HostingLocation,PublishedToSharedDataCatalog,Application")] DatasetViewModel dataset) { if (!_securityService.CurrrentUserHasAccessToOrganization(CurrentOrganizationId(), AccessLevel.Write)) { return(Forbid()); } if (id != dataset.Id) { return(NotFound()); } dataset.OrganizationId = CurrentOrganizationId(); await _datasetService.UpdateAsync(id, dataset.Map(dataset)); return(RedirectToAction(nameof(Index))); }
public async Task GetDatasets_ReturnsAnActionResult() { //Arrange System.Threading.Thread.CurrentThread.CurrentCulture = CultureInfo.InvariantCulture; Mock <ISilveRRepository> mock = new Mock <ISilveRRepository>(); mock.Setup(x => x.GetDatasetViewModels()).ReturnsAsync(GetDatasets()); DataController sut = new DataController(mock.Object); //Act IActionResult result = await sut.GetDatasets(); //Assert JsonResult jsonResult = Assert.IsType <JsonResult>(result); IEnumerable <DatasetViewModel> datasetViewModel = (IEnumerable <DatasetViewModel>)jsonResult.Value; DatasetViewModel dataset = datasetViewModel.First(); Assert.Equal("_test dataset.xlsx [doseresponse] v1", dataset.DatasetNameVersion); }
public async Task <ActionResult <Response> > UpdateDataset(Guid projectId, Guid dataSetId, [FromBody] DatasetViewModel dataSetViewModel) { if (!ModelState.IsValid) { return(Ok(new Response { Successful = "true", Msg = ModelState.Values.ToString(), Data = null })); } try { var convertProjectId = projectId.ToString().ToUpper(); var convertDataSetId = dataSetId.ToString().ToUpper(); var currentUserId = HttpContext.User.Claims.First(c => c.Type == "uid").Value.ToString(); var role = await AzureService.FindUserRole(currentUserId); if (role != "admin" && !await AzureService.FindUserIsProjectManager(currentUserId, convertProjectId)) { return(StatusCode(403)); } await AzureService.UpdateDataset(convertProjectId, convertDataSetId, dataSetViewModel); return(Ok(new Response { Msg = "ok" })); } catch (Exception ex) { return(StatusCode(500, ex.Message)); } }
protected override void OnNavigatedTo(NavigationEventArgs e) { _viewModel = new DatasetViewModel(e.Parameter as Dataset); base.OnNavigatedTo(e); }
public IActionResult ExchangesHistoryChartInfo() { var chartViewModel = new ChartViewModel(); chartViewModel.Labels = _exchangeRateToUsdHistoryRepository .GetAll() .Select(x => x.ExchRateDate.ToString()) .Distinct() .ToList(); var datasetBynBuy = new DatasetViewModel() { Label = "BYN покупка", Data = _exchangeRateToUsdHistoryRepository.GetExchangeRateForChart(Currency.BYN, TypeOfExchange.Buy), BackgroundColor = "rgb(173, 255, 47)", BorderColor = "rgb(173, 255, 47)" }; chartViewModel.Datasets.Add(datasetBynBuy); var datasetBynSell = new DatasetViewModel() { Label = "BYN продажа", Data = _exchangeRateToUsdHistoryRepository.GetExchangeRateForChart(Currency.BYN, TypeOfExchange.Sell), BackgroundColor = "rgb(0, 100, 0)", BorderColor = "rgb(0, 100, 0)" }; chartViewModel.Datasets.Add(datasetBynSell); var datasetEurBuy = new DatasetViewModel() { Label = "EUR продажа", Data = _exchangeRateToUsdHistoryRepository.GetExchangeRateForChart(Currency.EUR, TypeOfExchange.Buy), BackgroundColor = "rgb(102, 205, 170)", BorderColor = "rgb(102, 205, 170)" }; chartViewModel.Datasets.Add(datasetEurBuy); var datasetEurSell = new DatasetViewModel() { Label = "EUR продажа", Data = _exchangeRateToUsdHistoryRepository.GetExchangeRateForChart(Currency.EUR, TypeOfExchange.Sell), BackgroundColor = "rgb(0, 128, 128)", BorderColor = "rgb(0, 128, 128)" }; chartViewModel.Datasets.Add(datasetEurSell); var datasetPlnBuy = new DatasetViewModel() { Label = "PLN продажа", Data = _exchangeRateToUsdHistoryRepository.GetExchangeRateForChart(Currency.PLN, TypeOfExchange.Buy), BackgroundColor = "rgb(205, 92, 92)", BorderColor = "rgb(205, 92, 92)" }; chartViewModel.Datasets.Add(datasetPlnBuy); var datasetPlnSell = new DatasetViewModel() { Label = "PLN продажа", Data = _exchangeRateToUsdHistoryRepository.GetExchangeRateForChart(Currency.PLN, TypeOfExchange.Sell), BackgroundColor = "rgb(139, 0, 0)", BorderColor = "rgb(139, 0, 0)" }; chartViewModel.Datasets.Add(datasetPlnSell); var datasetGbpBuy = new DatasetViewModel() { Label = "GBP продажа", Data = _exchangeRateToUsdHistoryRepository.GetExchangeRateForChart(Currency.GBP, TypeOfExchange.Buy), BackgroundColor = "rgb(238, 130, 238)", BorderColor = "rgb(238, 130, 238)" }; chartViewModel.Datasets.Add(datasetGbpBuy); var datasetGbpSell = new DatasetViewModel() { Label = "GBP продажа", Data = _exchangeRateToUsdHistoryRepository.GetExchangeRateForChart(Currency.GBP, TypeOfExchange.Sell), BackgroundColor = "rgb(153, 50, 204)", BorderColor = "rgb(153, 50, 204)" }; chartViewModel.Datasets.Add(datasetGbpSell); return(Json(chartViewModel)); }