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