public static void UpdateUser()
{
try
{
DatabaseAccess.DBConnectionOpen();
Console.WriteLine("Enter a UserID for Update");
int userID = int.Parse(Console.ReadLine());
Console.WriteLine("Which information do you want to Update");
string updateInfo = Console.ReadLine();
Console.WriteLine($"Enter a new {updateInfo} for User");
string newUpdateInfo = Console.ReadLine();
DatabaseAccess.DBUpdateUserInfo(updateInfo, userID, newUpdateInfo);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
DatabaseAccess.DBConnectionClose();
DatabaseAccess.DBConnectionDispose();
}
}
public static void EditMessage(string senderUserName)
{
try
{
DatabaseAccess.DBConnectionOpen();
Console.WriteLine("Write the username of the receiver that you want to Edit: ");
string receiverUserName = Console.ReadLine();
Console.WriteLine("Enter the Date and time of the message.");
var dateOfSubmission = DateTime.Parse(Console.ReadLine());
Console.WriteLine("Write the new Message: ");
string newMessage = Console.ReadLine();
DatabaseAccess.DBExistentUsernameInMessages(senderUserName, receiverUserName, dateOfSubmission);
DatabaseAccess.DBUpdateMessage(senderUserName, receiverUserName, dateOfSubmission, newMessage);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
DatabaseAccess.DBConnectionClose();
DatabaseAccess.DBConnectionDispose();
}
}
public static void DeleteMessage(string userName)
{
try
{
DatabaseAccess.DBConnectionOpen();
//Console.WriteLine("Enter a UserName to Delete the message!");
//string senderUserName = Console.ReadLine();
Console.WriteLine("Write the username of the receiver that you want to Delete: ");
string receiverUserName = Console.ReadLine();
Console.WriteLine("Enter the Date and time of the message.");
var dateOfSubmission = DateTime.Parse(Console.ReadLine());
DatabaseAccess.DBDeleteMessage(userName, receiverUserName, dateOfSubmission);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
DatabaseAccess.DBConnectionClose();
DatabaseAccess.DBConnectionDispose();
}
}
public static void CreateMessage(string senderUserName)
{
try
{
DatabaseAccess.DBConnectionOpen();
Message message = new Message();
DatabaseAccess.DBViewUsersforMessage(senderUserName);
Console.WriteLine("Write the UserName of the receiver for your message!");
message.ReceiverUserName = Console.ReadLine();
DatabaseAccess.DBExistentUserToSendMessage(senderUserName, message.ReceiverUserName);
message.SenderUserName = senderUserName;
message.DateOfSubmission = DateTime.Now;
Console.WriteLine("Write your Message:");
message.MessageData = Console.ReadLine();
DatabaseAccess.DBInsertMessage(message.DateOfSubmission, message.SenderUserName, message.ReceiverUserName, message.MessageData);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
DatabaseAccess.DBConnectionClose();
DatabaseAccess.DBConnectionDispose();
}
}
public static User Login()
{
User user = new User();
try
{
DatabaseAccess.DBConnectionOpen();
Console.WriteLine("Enter username and password to Login:");
string usernameInserted = Console.ReadLine();
string passwordInserted = Console.ReadLine();
user = DatabaseAccess.DBLogin(usernameInserted, passwordInserted);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
DatabaseAccess.DBConnectionClose();
DatabaseAccess.DBConnectionDispose();
}
return(user);
}
public static void ViewAllUsers()
{
try
{
DatabaseAccess.DBConnectionOpen();
DatabaseAccess.DBViewAllUsers();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
DatabaseAccess.DBConnectionClose();
DatabaseAccess.DBConnectionDispose();
}
}
public static void ViewMessage(string senderUserName)
{
try
{
DatabaseAccess.DBConnectionOpen();
DatabaseAccess.DBViewMessage(senderUserName);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
DatabaseAccess.DBConnectionClose();
DatabaseAccess.DBConnectionDispose();
}
}
public static void DeleteUser()
{
try
{
DatabaseAccess.DBConnectionOpen();
Console.WriteLine("Enter a user to DELETE");
string nameForDelete = Console.ReadLine();
DatabaseAccess.DBDeleteUser(nameForDelete);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
DatabaseAccess.DBConnectionClose();
DatabaseAccess.DBConnectionDispose();
}
}
public static void CreateUser()
{
try
{
DatabaseAccess.DBConnectionOpen();
Console.WriteLine("Enter a Name and LastName");
string name = Console.ReadLine();
string lastname = Console.ReadLine();
Console.WriteLine("Enter Age and Telephone");
int age = int.Parse(Console.ReadLine());
string telephone = Console.ReadLine();
Console.WriteLine("Enter an Email");
string email = Console.ReadLine();
Console.WriteLine("Enter a UserName and Password");
string username = Console.ReadLine();
string password = Console.ReadLine();
Console.WriteLine("Enter the Users Role");
int role = int.Parse(Console.ReadLine());
DatabaseAccess.DBInsertUser(name, lastname, age, telephone, email, username, password, role);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
DatabaseAccess.DBConnectionClose();
DatabaseAccess.DBConnectionDispose();
}
}
