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(); } }