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 ViewNewMessage()
{
Console.Clear();
int SenderId;
int userId = ApplicationsMenus.userId;
string cmd = "select id, username from users";
DatabasesAccess da = new DatabasesAccess();
IEnumerable <User> users = da.UsersDatabase(cmd);
cmd = "SELECT * FROM messages WHERE deleted = 0 AND readed = 0;";
IEnumerable <Message> messages = da.MessagesDatabase(cmd);
var myMessage = messages.Where(m => m.receiverId == userId).ToList();
foreach (var m in myMessage)
{
SenderId = m.senderId;
string Sender = HelpMethods.ReturnUsernameFromId(users, SenderId);
Console.Write("From: ");
Console.ForegroundColor = ConsoleColor.Green;
Console.Write(Sender);
Console.ForegroundColor = ConsoleColor.White;
Console.Write(" - Message: " + m.messageData);
da.ProcessMessagesDatabase(m.id, "Read_messages");
}
HelpMethods.ReturnBackMessage();
}
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();
}
}
