public static void InsertUserTest() { ExitExamApp.DatabaseManager db = new ExitExamApp.DatabaseManager(); String firstName = ""; String lastName = ""; String userName = ""; String passWord = ""; Char userType = 'S'; User user = null; Console.WriteLine("**********************************************************************************"); Console.WriteLine("INSERT USER TEST"); Console.WriteLine("**********************************************************************************"); Console.WriteLine("First Name: "); firstName = Console.ReadLine(); Console.WriteLine("Last Name: "); lastName = Console.ReadLine(); Console.WriteLine("Username: "******"Password: "******"UserType: "); userType = Console.ReadLine().ToCharArray()[0]; try { user = new User() { FirstName = firstName , LastName = lastName , UserName = userName , PassWord = passWord , UserType = userType }; if (db.InsertUser(user)) { Console.WriteLine("User Entered. Press Enter to Continue"); Console.ReadLine(); Console.Clear(); } else { Console.WriteLine("User Insert Failed."); } } catch (Exception ex) { Console.WriteLine(ex.Message); Console.ReadLine(); Console.Clear(); } }
public static void DeleteUserTest() { Console.WriteLine("**********************************************************************************"); Console.WriteLine("DELETE USER TEST"); Console.WriteLine("**********************************************************************************"); Console.WriteLine("UserID: "); int userID = Int32.Parse(Console.ReadLine()); Console.WriteLine(String.Format("Are you sure that you would like to delete user {0} (Y/N).", userID)); char ch = (char)Console.Read(); if (ch == 'Y' || ch == 'y') { try { ExitExamApp.DatabaseManager db = new ExitExamApp.DatabaseManager(); if (db.DeleteUser(userID)) { Console.WriteLine("User Deleted. Press Enter to continue."); Console.ReadLine(); Console.Clear(); } else { Console.WriteLine("Error Deleting User"); Console.ReadLine(); Console.Clear(); } } catch (Exception ex) { Console.WriteLine(ex.Message); } } else { Console.WriteLine("Press Enter to return to the Main Menu."); Console.ReadLine(); Console.Clear(); } }