public static void DeleteMessage()
{
Console.Write("Type the id of message you want to delete: ");
int id;
string ID = Console.ReadLine();
bool result = int.TryParse(ID, out id);
DatabasesAccess da = new DatabasesAccess();
if (result)
{
bool MessageExist = HelpMethods.CheckExistMessage(id);
if (MessageExist == true)
{
Console.Clear();
da.ProcessMessagesDatabase(id, "Delete_messages");
}
else
{
HelpMethods.MessageDoesNotExist();
}
}
else
{
HelpMethods.IncorrectMessage();
}
}
public static void EditMessage()
{
string cmd = "SELECT * FROM messages WHERE deleted = 0";
DatabasesAccess da = new DatabasesAccess();
IEnumerable <Message> messages = da.MessagesDatabase(cmd);
Console.Write("Type the id of message you want to update: ");
int id;
string ID = Console.ReadLine();
bool result = int.TryParse(ID, out id);
if (result)
{
bool MessageExist = HelpMethods.CheckExistMessage(id);
if (MessageExist == true)
{
var senderId = messages
.Where(x => x.id == id)
.Select(x => x.senderId);
int SenderId = Convert.ToInt32(senderId.FirstOrDefault());
var receiverId = messages
.Where(x => x.id == id)
.Select(x => x.receiverId);
int ReceiverId = Convert.ToInt32(receiverId.FirstOrDefault());
da.ProcessMessagesDatabase(id, "Delete_messages");
Console.Clear();
Console.WriteLine($"Write the new message the maximun text limited to 250 characters");
Console.WriteLine("\n");
HelpMethods.SendMessage(SenderId, ReceiverId);
}
else
{
HelpMethods.MessageDoesNotExist();
}
}
else
{
HelpMethods.IncorrectMessage();
}
}
