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