public static void DBExistentUserToSendMessage(string senderUserName, string userName)
{
SqlCommand cmdSelect = new SqlCommand($"SELECT COUNT(*) FROM UserNames WHERE UserName = @username", sqlConnection);
cmdSelect.Parameters.AddWithValue("@username", $"{userName}");
int result = (int)cmdSelect.ExecuteScalar();
if (result > 0)
{
Console.WriteLine("Existent Username.");
}
else
{
Console.WriteLine("Non existent username.");
DBMessageHandle.CreateMessage(senderUserName);
}
}
public static void DBExistentUsernameInMessages(string senderUserName, string userName, DateTime dateOfSubmission)
{
SqlCommand cmdSelect = new SqlCommand($"SELECT COUNT(*) FROM Messages WHERE Receiver = @username AND DateOfSubmission = @dateOfSubmission", sqlConnection);
cmdSelect.Parameters.AddWithValue("@username", $"{userName}");
cmdSelect.Parameters.AddWithValue("@dateOfSubmission", $"{dateOfSubmission}");
int result = (int)cmdSelect.ExecuteScalar();
if (result > 0)
{
Console.WriteLine("Existent Log.");
}
else
{
Console.WriteLine("Non existent Log.");
DBMessageHandle.EditMessage(senderUserName);
}
}
public static void DisplayMenu(Role role, User user)
{
Console.WriteLine();
Console.WriteLine("Welcome!");
Console.WriteLine();
Console.WriteLine("What do yo want to do?");
Console.WriteLine();
Console.WriteLine("1. Send Message to another User.");
Console.WriteLine("2. View your Messages.");
Console.WriteLine("3. Edit your Messages.");
Console.WriteLine("4. Delete your Messages.");
if (role.viewAllMessages)
{
Console.WriteLine("5. View All the Messages of the other Users.");
}
if (role.editAllMessages)
{
Console.WriteLine("6. Edit All the Messages of the other Users.");
}
if (role.deleteAllMessages)
{
Console.WriteLine("7. Delete All the Messages of the other Users.");
}
Console.WriteLine("8. Exit.");
string choise = Console.ReadLine();
switch (choise)
{
case "1":
do
{
GoBackToMenu(role, user);
DBMessageHandle.CreateMessage(user.UserName);
DisplayAfterFirstAction("Create", 1);
keyPressed = Console.ReadKey();
if (keyPressed.Key == ConsoleKey.D1 || keyPressed.Key == ConsoleKey.NumPad1)
{
repeat = true;
Console.Clear();
}
else
{
repeat = false;
}
}while (repeat == true);
Console.Clear();
DisplayMenu(role, user);
break;
case "2":
do
{
GoBackToMenu(role, user);
DBMessageHandle.ViewMessage(user.UserName);
DisplayAfterFirstAction("View", 2);
keyPressed = Console.ReadKey();
if (keyPressed.Key == ConsoleKey.D2 || keyPressed.Key == ConsoleKey.NumPad2)
{
repeat = true;
Console.Clear();
}
else
{
repeat = false;
}
}while (repeat == true);
Console.Clear();
DisplayMenu(role, user);
break;
case "3":
do
{
GoBackToMenu(role, user);
DBMessageHandle.ViewMessage(user.UserName);
DBMessageHandle.EditMessage(user.UserName);
DisplayAfterFirstAction("Edit", 3);
keyPressed = Console.ReadKey();
if (keyPressed.Key == ConsoleKey.D3 || keyPressed.Key == ConsoleKey.NumPad3)
{
repeat = true;
Console.Clear();
}
else
{
repeat = false;
}
}while (repeat == true);
Console.Clear();
DisplayMenu(role, user);
break;
case "4":
do
{
GoBackToMenu(role, user);
DBMessageHandle.ViewMessage(user.UserName);
DBMessageHandle.DeleteMessage(user.UserName);
DisplayAfterFirstAction("Delete", 4);
keyPressed = Console.ReadKey();
if (keyPressed.Key == ConsoleKey.D1 || keyPressed.Key == ConsoleKey.NumPad1)
{
repeat = true;
Console.Clear();
}
else
{
repeat = false;
}
}while (repeat == true);
Console.Clear();
DisplayMenu(role, user);
break;
case "5":
if (role.viewAllMessages)
{
do
{
GoBackToMenu(role, user);
DBMessageHandle.ViewAllMessages();
DisplayAfterFirstAction("View", 5);
keyPressed = Console.ReadKey();
if (keyPressed.Key == ConsoleKey.D5 || keyPressed.Key == ConsoleKey.NumPad5)
{
repeat = true;
Console.Clear();
}
else
{
repeat = false;
}
}while (repeat == true);
Console.Clear();
DisplayMenu(role, user);
}
else
{
Console.WriteLine("Choose another option....");
DisplayMenu(role, user);
}
break;
case "6":
if (role.editAllMessages)
{
do
{
GoBackToMenu(role, user);
DBMessageHandle.ViewAllMessages();
DBMessageHandle.EditAllMessages();
DisplayAfterFirstAction("Edit", 6);
keyPressed = Console.ReadKey();
if (keyPressed.Key == ConsoleKey.D6 || keyPressed.Key == ConsoleKey.NumPad6)
{
repeat = true;
Console.Clear();
}
else
{
repeat = false;
}
}while (repeat == true);
Console.Clear();
DisplayMenu(role, user);
}
else
{
Console.WriteLine("Choose another option....");
DisplayMenu(role, user);
}
break;
case "7":
if (role.deleteAllMessages)
{
do
{
GoBackToMenu(role, user);
DBMessageHandle.ViewAllMessages();
DBMessageHandle.DeleteAllMessages();
DisplayAfterFirstAction("Delete", 7);
keyPressed = Console.ReadKey();
if (keyPressed.Key == ConsoleKey.D7 || keyPressed.Key == ConsoleKey.NumPad7)
{
repeat = true;
Console.Clear();
}
else
{
repeat = false;
}
}while (repeat == true);
Console.Clear();
DisplayMenu(role, user);
}
else
{
Console.WriteLine("Choose another option....");
DisplayMenu(role, user);
}
break;
case "8":
do
{
Console.WriteLine("Are you sure? Press 8");
Console.WriteLine("Go back to main menu? Press any other button.");
keyPressed = Console.ReadKey();
if (keyPressed.Key == ConsoleKey.D8 || keyPressed.Key == ConsoleKey.Escape)
{
repeat = true;
Console.Clear();
Environment.Exit(2);
}
else
{
repeat = false;
DisplayMenu(role, user);
}
}while (repeat == true);
Console.Clear();
break;
default:
Console.WriteLine("Choose one of the valid options!");
DisplayMenu(role, user);
break;
}
}