public ResponseInsert RunInsertJson(string jdoc)
{
using (var conn = new MySqlConnection(_connectionString))
{
conn.Open();
var cmd = conn.CreateCommand();
cmd.CommandText = @"TRUNCATE json_process;insert into json_process values (@jdoc)";
cmd.Parameters.AddWithValue("@jdoc", jdoc);
var result = cmd.ExecuteNonQuery();
var response = new ResponseInsert();
if (result == 1)
{
response.valid = true;
}
else
{
response.valid = false;
}
return(response);
}
}
//====== Data methods - Методы работы с документами коллекции ======
//@Headers({ "Content-Type: application/json"})
//@POST("api/v1/data/insert")
//Call<ResponseInsert> insert(@Body RequestInsert requestInsert);
/// <summary>
/// Создание нового документа коллекции
/// </summary>
/// <param name="requestInsert">Параметры создаваемого документа</param>
/// <returns>Резулитаты создания документа</returns>
public async Task <ResponseInsert> InsertAsync(RequestInsert requestInsert)
{
var uri = new Uri(baseUri + @"api/v1/data/insert");
// Сформировать JSON данные
string jsonContent = JsonConvert.SerializeObject(requestInsert);
HttpResponseMessage httpResponse = await cmd.PostAsync(uri, jsonContent);
ResponseInsert responseInsert = new ResponseInsert();
if (httpResponse.IsSuccessStatusCode)
{
responseInsert = JsonConvert.DeserializeObject <ResponseInsert>(httpResponse.Content.ToString());
}
else
{
responseInsert.Error = true;
responseInsert.ErrCode = "";
responseInsert.ErrMsg = "Ошибка HttpClient.";
}
return(responseInsert);
}
public IEnumerator RequestInsert(string account, string password, string name)
{
var url = "register/insert";
HttpClient client = new HttpClient();
WWWForm form = new WWWForm();
form.AddField("account", account);
form.AddField("password", password);
form.AddField("name", name);
yield return(App.Util.AppManager.CurrentScene.StartCoroutine(client.Send(url, form)));
responseInsert = client.Deserialize <ResponseInsert>();
if (responseInsert.result)
{
App.Util.Global.ssid = responseInsert.ssid;
App.Util.Global.SUser.self = App.Util.Cacher.UserCacher.Instance.Get(responseInsert.user.id);
PlayerPrefs.SetString("account", account);
PlayerPrefs.SetString("password", password);
PlayerPrefs.Save();
}
}
