// Method to Create Users
public static void CreateNewUser()
{
UserInsertion user = new UserInsertion();
Console.WriteLine("Enter your FirstName: ");
user.FirstName = Console.ReadLine();
Console.WriteLine("Enter your LastName: ");
user.LastName = Console.ReadLine();
Console.WriteLine("Enter your UserName: "******"Your UserName already Exists. Please try another: ");
user.UserName = Console.ReadLine();
CheckSameUserName(user);
}
Console.WriteLine("Enter your Password: "******"Your Password doesn't match. Please try another: ");
user.Password = Console.ReadLine();
CheckPasswordExist(user);
}
InsertUserToSql(user);
}
// Method to Log in a User
public static void UserLogin()
{
// Connection with the Database
string connectionString =
@"Server = LAPTOP-7FF4UD5B\SQLEXPRESS;Database = afdeDB; Trusted_Connection = True;";
SqlConnection sqlConnection = new SqlConnection(connectionString);
using (sqlConnection)
{
try
{
// Check if the connection with Database is already open
if (sqlConnection.State == ConnectionState.Open)
{
sqlConnection.Close();
}
sqlConnection.Open();
Console.WriteLine("Enter your UserName: "******"Enter your Password: "******"SELECT ID, UserName, Password FROM UsersInfo WHERE UserName = '******' AND Password = '******'", sqlConnection);
SqlDataReader reader = cmdLogin.ExecuteReader();
UserInsertion user = new UserInsertion();
while (reader.Read())
{
Console.WriteLine("User Logged In Successfully");
user.ID = reader.GetInt32(0);
user.UserName = reader.GetString(1);
user.Password = reader.GetString(2);
Console.WriteLine(user);
Thread.Sleep(3000);
Console.Clear();
LoginMenu.Menu(usernameInserted);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
sqlConnection.Close();
}
}
}
// Validation that the inserted Password Exist
public static bool CheckPasswordExist(UserInsertion user)
{
// Connection with the Database
string connectionString =
@"Server = LAPTOP-7FF4UD5B\SQLEXPRESS;Database = afdeDB; Trusted_Connection = True;";
SqlConnection sqlConnection = new SqlConnection(connectionString);
var check = true;
using (sqlConnection)
{
try
{
// Check if the connection with Database is already open
if (sqlConnection.State == ConnectionState.Open)
{
sqlConnection.Close();
}
sqlConnection.Open();
SqlCommand cmdSelect = new SqlCommand($"SELECT * FROM UsersInfo WHERE Password LIKE '{user.Password}'", sqlConnection);
SqlDataReader reader = cmdSelect.ExecuteReader();
if (reader.Read())
{
while (reader.Read())
{
Console.WriteLine("Password doesn't match.");
check = true;
}
}
else
{
check = false;
}
reader.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
sqlConnection.Close();
}
}
return(check);
}
// Method to Send the Data to SQL Database
public static void InsertUserToSql(UserInsertion user)
{
// Connection with the Database
string connectionString =
@"Server = LAPTOP-7FF4UD5B\SQLEXPRESS;Database = afdeDB; Trusted_Connection = True;";
SqlConnection sqlConnection = new SqlConnection(connectionString);
using (sqlConnection)
{
try
{
// Check if the connection with Database is already open
if (sqlConnection.State == ConnectionState.Open)
{
sqlConnection.Close();
}
sqlConnection.Open();
SqlCommand cmdInsert = new SqlCommand($"INSERT INTO UsersInfo(FirstName, LastName, UserName, Password, Role) VALUES('{user.FirstName}', '{user.LastName}', '{user.UserName}', '{user.Password}', '{(int)Role.CommonUser}')", sqlConnection);
int rowsInserted = cmdInsert.ExecuteNonQuery();
if (rowsInserted > 0)
{
Console.WriteLine("Insertion Successful");
Console.WriteLine($"{rowsInserted} rows inserted Successfully");
}
Thread.Sleep(3000);
Console.Clear();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
sqlConnection.Close();
}
}
}
// Method for the Main Screen of the program
public static void Connection()
{
var now = DateTime.Now;
Console.WriteLine($"***** {now.ToLongDateString()} *****\n");
Console.WriteLine("Press (1) to Sign in.");
Console.WriteLine("Press (2) to Register a new account.");
Console.WriteLine("Press (3) to Exit the program.\n");
int choice = int.Parse(Console.ReadLine());
Console.WriteLine("\n");
switch (choice)
{
case 3:
Console.WriteLine("Good Bye !!!");
Environment.Exit(2);
break;
case 2:
UserInsertion.CreateNewUser();
Connection();
break;
case 1:
UserInsertion.UserLogin();
break;
default:
Console.WriteLine("Not a legal entry. Try again later !!!");
Thread.Sleep(3000);
Console.Clear();
Connection();
break;
}
}
// Super Admin Menu Selection
public static void SuperAdminMenu(string user)
{
Console.WriteLine("(1) -- Assign a Role to a User.");
Console.WriteLine("(2) -- View User's Sent Messages.");
Console.WriteLine("(3) -- View User's Received Messages.");
Console.WriteLine("(4) -- Create a new User Profile.");
Console.WriteLine("(5) -- Update a User's Profile.");
Console.WriteLine("(6) -- Delete a User's Profile.");
Console.WriteLine("(7) -- Edit an Existing Message.");
Console.WriteLine("(8) -- Send a new Message.");
Console.WriteLine("(9) -- View your Sent Messages.");
Console.WriteLine("(10) -- View your Received Messages.");
Console.WriteLine("(11) -- Exit the Program.\n");
int choice = int.Parse(Console.ReadLine());
Console.WriteLine("\n");
switch (choice)
{
case 11:
Console.WriteLine("Good Bye !!!");
Environment.Exit(2);
break;
case 10:
Message.ViewReceivedMessages(user);
SuperAdminMenu(user);
break;
case 9:
Message.ViewSentMessages(user);
SuperAdminMenu(user);
break;
case 8:
Message.SendNewMessage(user);
SuperAdminMenu(user);
break;
case 7: Message.EditExistingMessage();
SuperAdminMenu(user);
break;
case 6:
UserInsertion.DeleteUser();
SuperAdminMenu(user);
break;
case 5:
UserInsertion.UpdateUser();
SuperAdminMenu(user);
break;
case 4:
UserInsertion.CreateNewUser();
SuperAdminMenu(user);
break;
case 3:
Console.WriteLine("Enter UserName to View his Received Messages:");
string usersNameReceivedMessages = Console.ReadLine();
Console.WriteLine("\n");
Message.ViewReceivedMessages(usersNameReceivedMessages);
SuperAdminMenu(user);
break;
case 2:
Console.WriteLine("Enter UserName to View his Sent Messages:");
string usersNameSentMessages = Console.ReadLine();
Console.WriteLine("\n");
Message.ViewSentMessages(usersNameSentMessages);
SuperAdminMenu(user);
break;
case 1:
UserInsertion.AssignRoleToUser();
SuperAdminMenu(user);
break;
default:
Console.WriteLine("Not a legal entry. Try again!!!");
Thread.Sleep(3000);
Console.Clear();
SuperAdminMenu(user);
break;
}
}
// Admin Menu Selection
public static void AdminMenu(string user)
{
Console.WriteLine("(1) -- Create a new User Profile.");
Console.WriteLine("(2) -- Update a User's Profile.");
Console.WriteLine("(3) -- Delete a User's Profile.");
Console.WriteLine("(4) -- Edit an Existing Message.");
Console.WriteLine("(5) -- Send a new Message.");
Console.WriteLine("(6) -- View your Sent Messages.");
Console.WriteLine("(7) -- View your Received Messages.");
Console.WriteLine("(8) -- Exit the Program.\n");
int choice = int.Parse(Console.ReadLine());
Console.WriteLine("\n");
switch (choice)
{
case 8:
Console.WriteLine("Good Bye !!!");
Environment.Exit(2);
break;
case 7:
Message.ViewReceivedMessages(user);
AdminMenu(user);
break;
case 6:
Message.ViewSentMessages(user);
AdminMenu(user);
break;
case 5:
Message.SendNewMessage(user);
AdminMenu(user);
break;
case 4:
Message.EditExistingMessage();
AdminMenu(user);
break;
case 3:
UserInsertion.DeleteUser();
AdminMenu(user);
break;
case 2:
UserInsertion.UpdateUser();
AdminMenu(user);
break;
case 1:
UserInsertion.CreateNewUser();
AdminMenu(user);
break;
default:
Console.WriteLine("Not a legal entry. Try again!!!");
Thread.Sleep(3000);
Console.Clear();
AdminMenu(user);
break;
}
}
