void InsertData(string reqName, string reqPhone)
{
string[] name = reqName.Split('=');
string[] phone = reqPhone.Split('=');
//Проверка на пустой запрос. Если запрос пуст, слушаем дальше!!!
if (name[1] != "" && phone[1] != "")
{
ClassDataSet classDataSet = new ClassDataSet(myDatabase.databaseConnection);
classDataSet.PostDataSet($"INSERT INTO PERSONS_DATA VALUES ({"'" + name[1] + "'"}, {phone[1]})");
}
}
void SelectData(NetworkStream stream)
{
DataSet dataSet = new DataSet();
dataSet.Tables.Add("PersonData");
ClassDataSet classDataSet = new ClassDataSet(myDatabase.databaseConnection);
classDataSet.FillDataSet(dataSet, 0, "Select * From PERSONS_DATA");
string json = JsonConvert.SerializeObject(dataSet, Formatting.Indented);
Byte[] responseData = Encoding.UTF8.GetBytes(json);
stream.Write(responseData, 0, responseData.Length);
}
