public bool ExistNeedy(Needys needy)
{
using var connection = new SqliteConnection(_connectionString);
connection.Open();
var command = new SqliteCommand(SqlExitNeedy, connection);
var nameParam = new SqliteParameter("@name", needy.NeedysName);
command.Parameters.Add(nameParam);
using var reader = command.ExecuteReader();
return(!reader.HasRows);
}
private void Send_Button_Click(object sender, RoutedEventArgs e)
{
if (Validations.IsNull(needy_name.Text, needy_status.Text, needy_help.Text,
service_list.SelectedItem.ToString()))
{
return;
}
var settings = new ServerMetaDats()
{
TypeClassSend = "Needys",
SendMessage = true,
FuncAddBd = "Add"
};
var needy = new Needys()
{
NeedysName = needy_name.Text,
NeedysStatus = needy_status.Text,
NeedysRoleId = 2,
NeedysServiceId = _services[service_list.SelectedItem.ToString()],
NeedysHelp = needy_help.Text
};
DataSender.OperationDataSend(JsonSerializer.Serialize(settings));
DataSender.OperationDataSend(JsonSerializer.Serialize(needy));
var settings1 = new ServerMetaDats()
{
TypeClassSend = "Help",
SendMessage = true,
FuncAddBd = "Add"
};
var helpSend = new Help()
{
HelpServiceId = _services[service_list.SelectedItem.ToString()],
HelpDate = Convert.ToDateTime(DateTime.Now.ToShortDateString()),
HelpMark = "Ожидается",
HelpEmployeesName = curator_list.SelectedItem.ToString(),
HelpNeedyName = needy_name.Text
};
DataSender.OperationDataSend(JsonSerializer.Serialize(settings1));
DataSender.OperationDataSend(JsonSerializer.Serialize(helpSend));
}
public void Add(Needys needy)
{
using var connection = new SqliteConnection(_connectionString);
connection.Open();
var command = new SqliteCommand(SqlGetNeedy, connection);
var roleParam = new SqliteParameter("@role", needy.NeedysRoleId);
command.Parameters.Add(roleParam);
var helpParam = new SqliteParameter("@help", needy.NeedysHelp);
command.Parameters.Add(helpParam);
var statusParam = new SqliteParameter("@status", needy.NeedysStatus);
command.Parameters.Add(statusParam);
var nameParam = new SqliteParameter("@name", needy.NeedysName);
command.Parameters.Add(nameParam);
var serviceParam = new SqliteParameter("@service", needy.NeedysServiceId);
command.Parameters.Add(serviceParam);
command.ExecuteNonQuery();
}
