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