private void Update(InterdepartResponse interdepart)
{
try
{
DateTime theDate = DateTime.Now;
string response = theDate.ToString("yyyy-MM-dd H:mm:ss");
string Sql = $"update InterdepartRequests set InterdepartStatusId = {interdepart.InterdepartStatusId}, Request = '{interdepart.Request}', Response = '{response}' where Id = {interdepart.Id}";
MySqlConnection connection = new MySqlConnection("Server=localhost; Database=psychologyDB; Uid=psyappuser; Password=password");
MySqlCommand command = new MySqlCommand(Sql, connection);
connection.Open();
MySqlDataReader reader = command.ExecuteReader();
connection.Close();
}
catch (Exception ex)
{
System.Console.WriteLine(ex.ToString());
}
}
private void Send(InterdepartRequest interdepart, int status)
{
InterdepartResponse interdepartResponse = new InterdepartResponse(interdepart.Id, status);
var factory = new ConnectionFactory();
factory.Uri = new System.Uri(Settings.Uri);
using var connection = factory.CreateConnection();
using var channel = connection.CreateModel();
channel.QueueDeclare(queue: Settings.KeyResponse,
durable: false,
exclusive: false,
autoDelete: false,
arguments: null);
string message = JsonConvert.SerializeObject(interdepartResponse);
var body = System.Text.Encoding.UTF8.GetBytes(message);
channel.BasicPublish(exchange: "", routingKey: Settings.KeyResponse, basicProperties: null, body: body);
}
