public void TestJsonDataSourceFindByKey(string key, dynamic val) { // Setup var jsonDataSource = new JsonDataSource <Person>(); // Perform var people = jsonDataSource.Find(key, val); // Assertions Assert.NotNull(people); switch (key) { case "Age": Assert.Equal(3, people.Count); Assert.Equal(val, people[0].Age); Assert.Equal(val, people[1].Age); Assert.Equal(val, people[2].Age); break; case "Id": Assert.Equal(3, people.Count); Assert.Equal(val, people[0].Id); Assert.Equal(val, people[1].Id); Assert.Equal(val, people[2].Id); break; case "Gender": Assert.Equal(2, people.Count); Assert.Equal(val, people[0].Gender); Assert.Equal(val, people[1].Gender); break; } }
public void TestJsonDataSourceAllByKey(string key) { // Setup var jsonDataSource = new JsonDataSource <Person>(); // Perform var people = jsonDataSource.All(key); // Assertions Assert.NotNull(people); switch (key) { case "Age": Assert.Equal(4, people.Count); Assert.Equal(3, people["66"].Count); Assert.Equal(1, people["12"].Count); Assert.Equal(2, people["23"].Count); break; case "Id": Assert.Equal(5, people.Count); Assert.Equal(3, people["31"].Count); Assert.Equal(1, people["53"].Count); Assert.Equal(1, people["62"].Count); break; case "Gender": Assert.Equal(3, people.Count); Assert.Equal(3, people["Unknown"].Count); Assert.Equal(2, people["Male"].Count); Assert.Equal(2, people["Female"].Count); break; } }
void UpdateData() { DataSource = new JsonDataSource() { Source = JsonSource.FromUri(new Uri("https://s3.amazonaws.com/utdmakerspace/events.json")) }; }
public void OnGet() { // Create a SQL data source. // MsSqlConnectionParameters parameters = new MsSqlConnectionParameters("localhost", // "dbName", "userName", "password", MsSqlAuthorizationType.SqlServer); // SqlDataSource dataSource = new SqlDataSource(parameters); // SelectQuery query = SelectQueryFluentBuilder.AddTable("Products").SelectAllColumnsFromTable().Build("Products"); // dataSource.Queries.Add(query); // dataSource.RebuildResultSchema(); // Create a JSON data source. JsonDataSource jsonDataSource = new JsonDataSource(); jsonDataSource.JsonSource = new UriJsonSource(new Uri("https://raw.githubusercontent.com/DevExpress-Examples/DataSources/master/JSON/customers.json")); jsonDataSource.Fill(); DesignerModel = new ReportDesignerModel { Report = new XtraReport(), DataSources = new Dictionary <string, object>() }; // DesignerModel.DataSources.Add("BookStoreDb", dataSource); DesignerModel.DataSources.Add("JsonDataSource", jsonDataSource); }
public MainPage() { InitializeComponent(); using (WebClient wc = new WebClient()) { _json = wc.DownloadString("https://services.odata.org/V3/Northwind/Northwind.svc/Products?$format=json"); } JObject o = JObject.Parse(_json); if (o != null) { List <JToken> tokens = o.Children().ToList(); JToken token1 = tokens[1]; var value = token1.Value <JProperty>(); _json = value.First.ToString(); } JsonDataSource jsonDataSource = new JsonDataSource(); StringJsonSource stringJsonSource = new StringJsonSource(); stringJsonSource.Json = _json; jsonDataSource.Source = stringJsonSource; this.DataSource = jsonDataSource; }
public void JsonDataSourceComplex() { var jsonDataSource = new JsonDataSource(); var json = @"[ { 'Name': 'Kristen Perez', 'Address': 'Ap #325-3386 Ac Av.', 'Phone': '(016977) 7108', 'Title': 'Lorem Ipsum Dolor Incorporated', 'Email': '*****@*****.**', 'List' : [ 'Foo', 'Bar', 'Baz' ] }, { 'Name': 'Murphy Cote', 'Address': '906-6938 Porttitor Ave', 'Phone': '076 9223 8954', 'Title': 'Vulputate Industries', 'Email': '*****@*****.**', 'List' : [ { 'Second' : 'Thing' } ] }, { 'Name': 'Nicole Valdez', 'Address': '485-9530 Ut Rd.', 'Phone': '0800 364 0760', 'Title': 'Diam At Ltd', 'Email': '*****@*****.**' } ]"; jsonDataSource.Source = json; Debug.WriteLine(jsonDataSource); }
public GenericListDataPage(string dataSource) { DataSource = new JsonDataSource() { Source = JsonSource.FromUri(new Uri(dataSource)) }; InitializeComponent(); }
protected JsonDataSource CreateDataSourceFromText() { JsonDataSource jsonDataSource = new JsonDataSource(); jsonDataSource.JsonSource = new CustomJsonSource(jsonData); jsonDataSource.Fill(); return(jsonDataSource); }
static JsonDataSource CreateJsonDataSource(string urlString) { var jsonDataSource = new JsonDataSource(); jsonDataSource.JsonSource = new UriJsonSource(new Uri(urlString)); jsonDataSource.Fill(); return(jsonDataSource); }
private JsonDataSource CreateDataSourceFromFile() { var jsonDataSource = new JsonDataSource(); //Specify the a JSON file's name Uri fileUri = new Uri(@"file:///../../../../customers.txt"); jsonDataSource.JsonSource = new UriJsonSource(fileUri); return(jsonDataSource); }
public TaskDataSource(CrmServiceClient crmServiceClient, string currentDirectory, CommandLineArgs arguments) { this.crmServiceClient = crmServiceClient; this.currentDirectory = currentDirectory; this.arguments = arguments; var jsonFile = Path.Combine(currentDirectory, arguments.Json); this.json = SimpleJson.DeserializeObject <Json>(File.ReadAllText(jsonFile)) .datasources.FirstOrDefault(x => x.profile == arguments.Profile); }
protected virtual JsonCustomerService SetUpSystemUnderTest() { var jsonFile = new Mock <IJsonAccess>(); jsonFile.Setup(x => x.LoadAsync()) .ReturnsAsync(JObject.Parse(Utils.GetDatabaseSeedJson())); var dataSource = new JsonDataSource(jsonFile.Object); return(new JsonCustomerService(dataSource)); }
public static JsonDataSource CreateDataSourceFromFile() { var jsonDataSource = new JsonDataSource(); // Specify the JSON file name. Uri fileUri = new Uri("customers.json", UriKind.RelativeOrAbsolute); jsonDataSource.JsonSource = new UriJsonSource(fileUri); // Populate the data source with data. jsonDataSource.Fill(); return(jsonDataSource); }
private void Awake() { dl = ServiceLocator.Get <DataLoader>(); dtl = ServiceLocator.Get <DataToLoad>(); iSource = dl.LoadedDataSources[dtl.GetLevelToLoad()]; jSonData = iSource as JsonDataSource; InitializeValues(); }
public static void Do() { BsonClassMap.RegisterClassMap <ClimateEntry>().AutoMap(); BsonClassMap.RegisterClassMap <CityDto>().AutoMap(); var client = new MongoClient(); var db = client.GetDatabase("climate"); var cities = db.GetCollection <CityDto>("cities"); var source = new JsonDataSource(); cities.InsertMany(source.Cities); }
private JsonDataSource CreateDataSourceFromText() { var jsonDataSource = new JsonDataSource(); //Specify a string with JSON content string json = "{\"Customers\":[{\"Id\":\"ALFKI\",\"CompanyName\":\"Alfreds Futterkiste\",\"ContactName\":\"Maria Anders\",\"ContactTitle\":\"Sales Representative\",\"Address\":\"Obere Str. 57\",\"City\":\"Berlin\",\"PostalCode\":\"12209\",\"Country\":\"Germany\",\"Phone\":\"030-0074321\",\"Fax\":\"030-0076545\"}],\"ResponseStatus\":{}}"; // Specify the object that retrieves JSON data jsonDataSource.JsonSource = new CustomJsonSource(json); return(jsonDataSource); }
public void JsonDataStringException() { Document doc = new Document(MyDir + "Reporting engine template - JSON data destination.docx"); JsonDataLoadOptions options = new JsonDataLoadOptions(); options.SimpleValueParseMode = JsonSimpleValueParseMode.Strict; JsonDataSource dataSource = new JsonDataSource(MyDir + "List of people.json", options); Assert.Throws <InvalidOperationException>(() => BuildReport(doc, dataSource, "persons")); }
public IActionResult Login(LoginViewModel users) { IDataSource jsonData = new JsonDataSource(); _userData = new UserData(); _userData.DataSource = jsonData; _userData.UserViewModel = users; var checkLogin = _userData.CheckLoginUser(); return(View()); }
public void TestJsonDataSourceAll() { // Setup var jsonDataSource = new JsonDataSource <Person>(); // Perform var people = jsonDataSource.All(); // Assertions Assert.NotNull(people); Assert.Equal(7, people.Count); }
// Use this for initialization void Awake() { dl = ServiceLocator.Get <DataLoader>(); dtl = ServiceLocator.Get <DataToLoad>(); iSource = dl.LoadedDataSources[dtl.GetLevelToLoad()]; jSonData = iSource as JsonDataSource; InitializeValues(); source = GetComponent <AudioSource>(); piecePrefabDict = new Dictionary <PieceType, GameObject>(); for (int i = 0; i < piecePrefabs.Length; ++i) { if (!piecePrefabDict.ContainsKey(piecePrefabs[i].type)) { piecePrefabDict.Add(piecePrefabs[i].type, piecePrefabs[i].prefab); } } for (int x = 0; x < xDim; ++x) { for (int y = 0; y < yDim; ++y) { GameObject backgroung = Instantiate(backGroundPrefab, GetWorldPosition(x, y) * 9.5f, Quaternion.identity); backgroung.transform.parent = transform; } } pieces = new GamePiece [xDim, yDim]; for (int i = 0; i < initialPieces.Length; i++) { if (initialPieces[i].x >= 0 && initialPieces[i].x < xDim && initialPieces[i].y >= 0 && initialPieces[i].y < yDim) { SpawnNewPiece(initialPieces[i].x, initialPieces[i].y, initialPieces[i].type); } } for (int x = 0; x < xDim; ++x) { for (int y = 0; y < yDim; ++y) { if (pieces[x, y] == null) { SpawnNewPiece(x, y, PieceType.EMPTY); } } } }
public void TestJsonDataSourceFirstOrDefault(string key, dynamic val) { // Setup var jsonDataSource = new JsonDataSource <Person>(); // Perform var person = jsonDataSource.FirstOrDefault(key, val); // Assertions Assert.NotNull(person); Assert.Equal(val, person.Id); }
public void JsonDataString() { Document doc = new Document(MyDir + "Reporting engine template - XML data destination.docx"); JsonDataSource dataSource = new JsonDataSource(MyDir + "List of people.json"); BuildReport(doc, dataSource, "persons"); doc.Save(ArtifactsDir + "ReportingEngine.JsonDataString.docx"); Assert.IsTrue(DocumentHelper.CompareDocs(ArtifactsDir + "ReportingEngine.JsonDataString.docx", GoldsDir + "ReportingEngine.DataSource Gold.docx")); }
private JsonDataSource CreateDataSourceFromWeb() { var jsonDataSource = new JsonDataSource(); //Specify the data source location jsonDataSource.JsonSource = new UriJsonSource(new Uri("https://srframework.vercel.app/SRFeature.json")); // jsonDataSource.JsonSource = new UriJsonSource(new Uri("http://northwind.servicestack.net/customers.json")); jsonDataSource.Fill(); //jsonDataSource.FillAsync(); DataJsonSource = jsonDataSource; return(jsonDataSource); }
public void JsonDataString() { Document doc = new Document(MyDir + "ReportingEngine.DataSource.docx"); JsonDataSource dataSource = new JsonDataSource(MyDir + "JsonData.json"); BuildReport(doc, dataSource, "persons"); doc.Save(ArtifactsDir + "ReportingEngine.JsonDataString.docx"); Assert.IsTrue(DocumentHelper.CompareDocs(ArtifactsDir + "ReportingEngine.JsonDataString.docx", GoldsDir + "ReportingEngine.DataSource Gold.docx")); }
public void JsonDataWithNestedElements() { Document doc = new Document(MyDir + "Reporting engine template - Data destination with nested elements.docx"); JsonDataSource dataSource = new JsonDataSource(MyDir + "Nested elements.json"); BuildReport(doc, dataSource, "managers"); doc.Save(ArtifactsDir + "ReportingEngine.JsonDataWithNestedElements.docx"); Assert.IsTrue(DocumentHelper.CompareDocs(ArtifactsDir + "ReportingEngine.JsonDataWithNestedElements.docx", GoldsDir + "ReportingEngine.DataSourceWithNestedElements Gold.docx")); }
private void Awake() { dl = ServiceLocator.Get <DataLoader>(); dtl = ServiceLocator.Get <DataToLoad>(); iSource = dl.LoadedDataSources[dtl.GetLevelToLoad()]; jSonData = iSource as JsonDataSource; InitializeValues(); levelAS = GetComponent <AudioSource>(); gamePlayAS = GameObject.Find("GameplayMusic").GetComponent <AudioSource>(); }
private void Awake() { dataLoader = ServiceLocator.Get <DataLoader>(); if (App.Instance.hasGameLoaded) { towerData = dataLoader.GetDataSourceById(dataSourceId) as JsonDataSource; name = System.Convert.ToString(towerData.DataDictionary["Name"]); } audioSource = GetComponent <AudioSource>(); audioManager = ServiceLocator.Get <AudioManager>(); fullHealth = MaxHealth / 2.0f; InvokeRepeating("UpdateTarget", 0f, 0.1f); animator = GetComponent <Animator>(); }
public void JsonDataStream() { Document doc = new Document(MyDir + "ReportingEngine.DataSource.docx"); using (FileStream stream = File.OpenRead(MyDir + "JsonData.json")) { JsonDataSource dataSource = new JsonDataSource(stream); BuildReport(doc, dataSource, "persons"); } doc.Save(ArtifactsDir + "ReportingEngine.JsonDataStream.docx"); Assert.IsTrue(DocumentHelper.CompareDocs(ArtifactsDir + "ReportingEngine.JsonDataStream.docx", GoldsDir + "ReportingEngine.DataSource Gold.docx")); }
private void CreateReportDataSourceWithAuthenticationInCodeButton_Click(object sender, EventArgs e) { // XtraReport1 does not have assigned data sources var report = new XtraReport1(); // Create JsonDataSource in code JsonDataSource jsonDataSource = CreateReportDataSourceWithAuthenticationInCode(); // Retrieve data to populate the Report Designer's Field List jsonDataSource.Fill(); report.DataSource = jsonDataSource; report.DataMember = "Customers"; new DevExpress.XtraReports.UI.ReportDesignTool(report).ShowDesigner(); }
protected void Page_Load(object sender, EventArgs e) { string apiUrl = WebConfigurationManager.AppSettings["api_url"]; // string df = Request.QueryString["from"]; // string dt = Request.QueryString["to"]; string df = "20190101"; string dt = "20200503"; int d = Convert.ToInt32(Request.QueryString["d"]); string type = Request.QueryString["type"]; if (string.IsNullOrEmpty(type)) { type = "easafcl16"; } string prms = Request.QueryString["prms"]; int reportId = -1; int airlineId = -1; int flightStatusId = -1; int employeeId = 297; JsonDataSource dataSource = null; switch (type) { case "easafcl16": var rptEASAFCL16 = new RptFlight(); dataSource = new JsonDataSource(); dataSource.JsonSource = new UriJsonSource(new Uri(apiUrl + "odata/crew/flights/app2/?id=" + employeeId + "&df=" + df + "&dt=" + dt + "&status=" + flightStatusId + "&airline=" + airlineId + "&report=" + reportId)); dataSource.Fill(); rptEASAFCL16.DataSource = dataSource; ASPxWebDocumentViewer1.OpenReport(rptEASAFCL16); break; default: break; } // var report = new RptTwoPageLogBook(); // var jsonDataSource = new JsonDataSource(); // jsonDataSource.JsonSource = new UriJsonSource(new Uri("http://fleet.flypersia.aero/api.airpocket/odata/fuel/report/?$top=2020&dt=2020-01-12T00:00:00&df=2020-01-12T00:00:00&%24orderby=STDDay%2CSTDLocal&%24filter=(FlightId%20gt%200)")); // jsonDataSource.Fill(); //report.DataSource = jsonDataSource; }
public void JsonDataSourceComplex () { var jsonDataSource = new JsonDataSource (); var json = @"[ { 'Name': 'Kristen Perez', 'Address': 'Ap #325-3386 Ac Av.', 'Phone': '(016977) 7108', 'Title': 'Lorem Ipsum Dolor Incorporated', 'Email': '*****@*****.**', 'List' : [ 'Foo', 'Bar', 'Baz' ] }, { 'Name': 'Murphy Cote', 'Address': '906-6938 Porttitor Ave', 'Phone': '076 9223 8954', 'Title': 'Vulputate Industries', 'Email': '*****@*****.**', 'List' : [ { 'Second' : 'Thing' } ] }, { 'Name': 'Nicole Valdez', 'Address': '485-9530 Ut Rd.', 'Phone': '0800 364 0760', 'Title': 'Diam At Ltd', 'Email': '*****@*****.**' } ]"; jsonDataSource.Source = json; Debug.WriteLine (jsonDataSource); }