public async Task <DataJson> GetJsonAsync(int id_contribuyente) { using (var connection = _connectionFactory.GetConnection) { var query = "sps_mae_contribuyente_json"; var parameters = new DynamicParameters(); parameters.Add("@pi_id_contribuyente", id_contribuyente); parameters.Add("@pi_id_usuario_login", 0); parameters.Add("@po_error_number", 0, direction: ParameterDirection.Output); parameters.Add("@po_error_message", "", direction: ParameterDirection.Output); var dataJson = await connection.QuerySingleOrDefaultAsync <DataJson>(query, param : parameters, commandType : CommandType.StoredProcedure); if (dataJson == null) { DataJson dataJsonError = new DataJson(); dataJsonError.error_number = parameters.Get <int>("@po_error_number"); dataJsonError.error_message = parameters.Get <string>("@po_error_message"); return(dataJsonError); } else { return(dataJson); } } }
private void show_place() { DataJson daJson = new DataJson(); daJson.data.name = kw.ToString(); daJson.data.data_count = count; MySqlConnection mysql = new MySqlConnection("Database=gazetteer;Data Source=127.0.0.1;User Id=root;Password=zhangruijie;pooling=false;CharSet=utf8;port=3306"); string sqlStr = "select geocodes8,barygeocode8 from show_place where name = '" + kw + "'"; mysql.Open(); MySqlCommand comm = new MySqlCommand(sqlStr, mysql); MySqlDataReader reader = comm.ExecuteReader(); if (reader.Read()) { daJson.data.geocodes8 = reader[0].ToString(); daJson.data.barygeocode8 = reader[1].ToString(); } mysql.Close(); daJson.status = "ok"; // string sw = "{ \n" +"data:"+"{"+"name:"+das+"}"+ "\n }"; string text = JsonConvert.SerializeObject(daJson); FileStream fs = new FileStream(@"E:\users\zhang Ruijie\codes\Toponym-disambiguation\search\站内搜索\jason.txt", FileMode.Create); StreamWriter sw = new StreamWriter(fs, Encoding.UTF8); sw.Write(text); sw.Close(); fs.Close(); }
private void viewdata(DataJson data, RichTextBox richTextBox) { richTextBox.Clear(); foreach (var item in data) { richTextBox.AppendText(item); } }
public DataJson Load() { data = new DataJson(); string json = ReadFromFile(fileName); JsonUtility.FromJsonOverwrite(json, data); return(data); }
public DataVelocityDb2Tests() { DataJson dataJson = new DataJson(ResourceHelper.GetResourceStream(@"cities.json")); _dataVelocityDb = new DataVelocityDb(@"dbvel" + Guid.NewGuid()); // _dataVelocityDb.Dispose(); // if (Directory.Exists(_dataVelocityDb.SystemDir)) // Directory.Delete(_dataVelocityDb.SystemDir, true); // remove our current systemDir and all its databases. _dataVelocityDb.AddCity(dataJson.All()); }
public DataJson SaveInJsonFormat(Data data) { DataJson dataJson = new DataJson(); foreach (var item in data) { dataJson.Add(JsonConvert.SerializeObject(item)); } return(dataJson); }
IEnumerator GetRequest(string uri) { Debug.Log("---Get request"); //отправляем гет реквест с получением даты UnityWebRequest uwr = UnityWebRequest.Get(uri); yield return(uwr.SendWebRequest()); //проверяем на ошибку подключения if (uwr.isNetworkError) { Debug.Log("---Error While Sending: " + uwr.error); GoToVebViewLByUrl(defaultUrl); } else { Debug.Log("---Received: " + uwr.downloadHandler.text); //считываем данные в строку string s = uwr.downloadHandler.text; DataJson d = new DataJson("", "", -1); //записываем в данные в обьект d = JsonUtility.FromJson <DataJson>(s); if (d == null) { //переход на дефолтный экран если обьект нулл GoToVebViewLByUrl(defaultUrl); } else { Debug.Log("serverStatus = " + d.status); //если в обьекте есть данные проверяем статус if (!String.IsNullOrEmpty(d.status)) { //и присваеваем переменной его значение serverStatus = d.status; } //проверяем значение статуса и строки с url if (CheckStatus(d.status) && !String.IsNullOrEmpty(d.url)) { //присваиваем значение в переменную url = d.url; //выполняем действие в зависимости от d.wv RedOrWv(d.wv, d.url); } } } }
public JsonResult HandlerData() { ResponseClient responseClient = new ResponseClient(); try { byte[] buffer = new byte[2000]; StringBuilder builder = new StringBuilder(); while (true) { var bytesRemaining = Request.Body.Read(buffer, offset: 0, buffer.Length); if (bytesRemaining == 0) { break; } var encodedString = Encoding.UTF8.GetString(buffer, 0, bytesRemaining); builder.Append(encodedString); } DataJson dataJson = JsonSerializer.Deserialize <DataJson>(builder.ToString()); if (String.IsNullOrEmpty(dataJson.DataText) && String.IsNullOrEmpty(dataJson.DataText)) { responseClient.Errors.Add("Input data is empty"); responseClient.Errors.Add("File data is empty"); return(Json(JsonSerializer.Serialize(responseClient))); } dataJson.Key = String.IsNullOrEmpty(dataJson.Key) ? "Скорпион" : dataJson.Key; responseClient.Key = dataJson.Key; if (!String.IsNullOrEmpty(dataJson.DataText)) { responseClient.DataTextOld = dataJson.DataText; responseClient.DataTextNew = VigenerСipher.GetDataCipher(dataJson.FlagAction, dataJson.DataText, dataJson.Key); } if (!String.IsNullOrEmpty(dataJson.DataFile)) { responseClient.DataTextOld = dataJson.DataText; dataJson.DataText = VigenerСipher.GetDataCipher(dataJson.FlagAction, dataJson.DataFile, dataJson.Key); } return(Json(JsonSerializer.Serialize(responseClient))); } catch (Exception) { responseClient.Errors.Add("Data is not valid"); return(Json(JsonSerializer.Serialize(responseClient))); } }
public void list() { try { int id = listViewSelectedItems(name_list); DataJson dataListView = editSettings.setElementsListView; textBox_name.Text = dataListView.data[id].name; textBox_prefix.Text = dataListView.data[id].prefix; label_openPath.Content = dataListView.data[id].path; textBox_startNumber.Text = dataListView.data[id].startNumber; } catch { } }
public async Task InsertDataJson(DataJson dataJson) { await using var conn = await OpenConnectionAsync(); await conn.ExecuteAsync("dbo.InsertDataJson", new { dataJson.DataSetId, dataJson.Stamp, dataJson.Json }, commandType : System.Data.CommandType.StoredProcedure); }
public void TestDefaultConstructor() { int sensNr = 1; int instNr = 20; int bRet = 30; int[] array = { 11, 20 }; DataJson dataJson = new DataJson(sensNr, instNr, bRet, array); Assert.AreEqual(dataJson.SensNr, sensNr); Assert.AreEqual(dataJson.InstNr, instNr); Assert.AreEqual(dataJson.BRet, bRet); Assert.AreEqual(dataJson.Data, array); }
public CityRepositoryVelocityDbTest() { // string file = @"c:\temp\velecityDb"; // if (Directory.Exists(file)) // Directory.Delete(file, true); // remove our current systemDir and all its databases. DataJson dataJson = new DataJson(ResourceHelper.GetResourceStream(@"cities.json")); var dataVelocityDb = new DataVelocityDb(@"dbvel" + Guid.NewGuid()); // dataVelocityDb.Dispose(); dataVelocityDb.AddCity(dataJson.All()); _repository = new CityRepository(dataVelocityDb); }
public DataJson Post() { int Id = 1; try { DataJson val = null; TerminalbdManager configdb = new TerminalbdManager(); val = configdb.Get(Id); return(val); } catch { throw; } }
//En este metodo se realiza la lectura del archivo JSON //primero creamos un objeto te tipo "DataJson" (el cual contiene un Header y una lista de strings que corresponde al contenido) //ContentList es donde almacenaremos el contenido de cada columna para despues asignarlo a nuestro objeto DataJson y añadirlo a nuestra lista final void Read(int index, JsonData item) { DataJson d = new DataJson(); string content; List <string> contentList = new List <string>(); d.header = item[headerKey][index].ToString(); for (int i = 0; i < item[dataKey].Count; i++) { content = item[dataKey][i][index]?.ToString(); contentList.Add(content); } d.content = contentList; data.Add(d); }
public void APiTest() { DataJson dataJson = new DataJson(); dataJson.Key = "скорпион"; dataJson.FlagAction = false; dataJson.DataText = "тест"; dataJson.DataFile = ""; var httpContext = new DefaultHttpContext(); httpContext.Request.Headers["X-Custom-Header"] = "88-test-tcb"; httpContext.Request.Method = "POST"; httpContext.Request.ContentType = "application/json"; using (MemoryStream memoryStream = new MemoryStream(Encoding.UTF8.GetBytes(JsonSerializer.Serialize(dataJson)))) { controller.ControllerContext.HttpContext.Request.Body = memoryStream; controller.ControllerContext.HttpContext.Request.ContentLength = memoryStream.Length; } var mock = new Mock <ILogger <HomeController> >(); ILogger <HomeController> logger = mock.Object; logger = Mock.Of <ILogger <HomeController> >(); controller = new HomeController(logger) { ControllerContext = new ControllerContext() { HttpContext = httpContext, } }; JsonResult result = controller.HandlerData() as JsonResult; Assert.IsNotNull(result); }
public void ReloadJson() { var jsonData = File.ReadAllText($@"{PluginDirectory}\data\OtherData.json"); DataList = JsonConvert.DeserializeObject <DataJson>(jsonData); }
private void InitData() { DataJson dataJson = new DataJson(); int total = 0; dataJson.rows = GetProducts(out total); dataJson.total = total; string json = Newtonsoft.Json.JsonConvert.SerializeObject(dataJson); Response.Write(json); Response.End(); }
protected string GetDataJson(int total, DataTable data) { DataJson jsonObj = new DataJson(); jsonObj.total = total; jsonObj.rows = data; string json = Newtonsoft.Json.JsonConvert.SerializeObject(jsonObj); return json; }
private void DecodeJson(string jsonString) { string[] jsonObjects = jsonString.Split('|'); jsonObjects[0] = '{' + jsonObjects[0]; foreach (string jsonObject in jsonObjects) { Debug.Log(jsonObject); } Debug.Log("Decode Json"); DataJson jsonData = JsonUtility.FromJson <DataJson>(jsonObjects[0]); Debug.Log("After DataJson"); int numberOfEnzymes = jsonData.enzymes.Length; int numberOfMultiDigests = jsonData.numberOfMultiDigests; DataManager.getInstance().SetEnzymes(numberOfEnzymes); DataManager.getInstance().SetNumberOfMultiDigests(numberOfMultiDigests); for (int i = 0; i < numberOfEnzymes; i++) { DataManager.getInstance().SetEnzymeName(i, jsonData.enzymes[i]); } SingleDigestJson singleDigest; for (int i = 0; i < numberOfEnzymes; i++) { singleDigest = JsonUtility.FromJson <SingleDigestJson>(jsonObjects[i + 1]); DataManager.getInstance().SetEnzymeNumberOfFragments(i, singleDigest.fragmentSizes.Length); } for (int i = 0; i < numberOfEnzymes; i++) { singleDigest = JsonUtility.FromJson <SingleDigestJson>(jsonObjects[i + 1]); DataManager.getInstance().SetEnzymeFragmentSizes(i, singleDigest.fragmentSizes); Debug.Log("SINGLE DIGEST FRAGMENT SIZES"); Debug.Log(singleDigest.fragmentSizes); } Debug.Log("After SingleDigestJson"); MultiDigestJson multiDigest; for (int i = 0; i < numberOfMultiDigests; i++) { multiDigest = JsonUtility.FromJson <MultiDigestJson>(jsonObjects[i + 1 + numberOfEnzymes]); DataManager.getInstance().SetMultiDigestNumberOfFragments(i, multiDigest.fragmentSizes.Length); } for (int i = 0; i < numberOfMultiDigests; i++) { multiDigest = JsonUtility.FromJson <MultiDigestJson>(jsonObjects[i + 1 + numberOfEnzymes]); DataManager.getInstance().SetMultiDigestFragmentSizes(i, multiDigest.fragmentSizes); } //Correct enzymes ID as they're zero based for (int i = 0; i < numberOfMultiDigests; i++) { multiDigest = JsonUtility.FromJson <MultiDigestJson>(jsonObjects[i + 1 + numberOfEnzymes]); for (int x = 0; x < multiDigest.enzymesInDigest.Length; x++) { multiDigest.enzymesInDigest[x]--; } DataManager.getInstance().SetMultiDigestEnzymes(i, multiDigest.enzymesInDigest); } Debug.Log("After MultiDigestJson"); UIManager.getInstance().DataLoaded(); //PopulateTextFields(); }
//protected T Get(object item) //{ // return JsonMapper.ToObject<T>(JsonMapper.ToJson(item)); //} protected T Get(object item) { return(DataJson.ToObject <T>(JsonMapper.ToJson(item))); }