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 ViewAllMessage()
{
Console.Clear();
int SenderId;
int receiverId;
string Sender;
string receiver;
string cmd = "select id, username from users";
DatabasesAccess da = new DatabasesAccess();
IEnumerable <User> users = da.UsersDatabase(cmd);
cmd = "SELECT * FROM messages WHERE deleted = 0";
IEnumerable <Message> messages = da.MessagesDatabase(cmd);
foreach (var m in messages)
{
SenderId = m.senderId;
receiverId = m.receiverId;
Sender = HelpMethods.ReturnUsernameFromId(users, SenderId);
receiver = HelpMethods.ReturnUsernameFromId(users, receiverId);
Console.Write("Id: " + m.id + " - From: ");
Console.ForegroundColor = ConsoleColor.Green;
Console.Write(Sender);
Console.ForegroundColor = ConsoleColor.White;
Console.Write(" - To: ");
Console.ForegroundColor = ConsoleColor.Green;
Console.Write(receiver);
Console.ForegroundColor = ConsoleColor.White;
Console.WriteLine(" - Message: " + m.messageData);
}
HelpMethods.ReturnBackMessage();
}
public static void FindUserName(int SenderId, int receiverId, string message)
{
string Sender;
string receiver;
string cmd = "select * from users where deleted = 0";
DatabasesAccess da = new DatabasesAccess();
IEnumerable <User> users = da.UsersDatabase(cmd);
cmd = "SELECT * FROM messages WHERE deleted = 0";
IEnumerable <Message> messages = da.MessagesDatabase(cmd);
Sender = ReturnUsernameFromId(users, SenderId);
receiver = ReturnUsernameFromId(users, receiverId);
FilesAccess.Files(Sender, receiver, message, SenderId, receiverId);
}
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();
}
}
public static void ViewMessage()
{
string cmd = "select id, username from users";
DatabasesAccess da = new DatabasesAccess();
IEnumerable <User> users = da.UsersDatabase(cmd);
Console.Write("Type the username you want to read the messages: ");
string Username = Console.ReadLine();
bool existUser = HelpMethods.CheckExistUser(users, Username);
if (existUser == true)
{
int ReceiverId = HelpMethods.ReturnIdFromUsername(users, Username);
int userId = ApplicationsMenus.userId;
Console.Clear();
cmd = "SELECT * FROM messages WHERE deleted = 0;";
IEnumerable <Message> messages = da.MessagesDatabase(cmd);
var myMessages = messages.Where(m => (m.receiverId == ReceiverId && m.senderId == userId) || (m.senderId == ReceiverId && m.receiverId == userId));
foreach (var m in myMessages)
{
if (m.senderId == userId)
{
Console.ForegroundColor = ConsoleColor.Green;
Console.Write("You: ");
Console.ForegroundColor = ConsoleColor.White;
Console.WriteLine(m.messageData);
}
else
{
Console.ForegroundColor = ConsoleColor.Green;
Console.Write(Username + ": ");
Console.ForegroundColor = ConsoleColor.White;
Console.WriteLine(m.messageData);
}
}
HelpMethods.ReturnBackMessage();
}
}
