//Opens Login_Screen private void Logout_Click(object sender, EventArgs e) { this.Hide(); Login_Screen login = new Login_Screen(); login.ShowDialog(); login.Focus(); }
//********************Non Event Methods******************** //Creates New user private void Register_Click(object sender, EventArgs e) { //Error message for not filling in mandatory fields if (string.IsNullOrWhiteSpace(Input_1.Text) == true || string.IsNullOrWhiteSpace(Input_2.Text) == true || string.IsNullOrWhiteSpace(Input_3.Text) == true || string.IsNullOrWhiteSpace(Input_4.Text) == true || string.IsNullOrWhiteSpace(Input_5.Text) == true || string.IsNullOrWhiteSpace(Input_6.Text) == true || string.IsNullOrWhiteSpace(Input_7.Text) == true) { MessageBox.Show("All fields need to be filled in", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //Error message if password doesn't match re enter password if (Input_4.Text != Input_5.Text) { MessageBox.Show("Password and re-enter password don't match", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //Error messages if the username is the same or if the first and last name are the same string query = "SELECT USER_First_Name, USER_Last_Name, USER_Username FROM [USERS];"; using (Global.connection = new SQLiteConnection(Global.connectionString)) using (SQLiteCommand cmd = new SQLiteCommand(query, Global.connection)) { Global.connection.Open(); SQLiteDataReader reader = cmd.ExecuteReader(); try { while (reader.Read()) { string firstName = Convert.ToString(reader["USER_First_Name"]); string lastName = Convert.ToString(reader["USER_Last_Name"]); string userName = Convert.ToString(reader["USER_Username"]); if (Input_3.Text == userName) { MessageBox.Show("This username already exists. Please choose a different username", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //Users may have the same name but is unlikely. Gives user the option to continue if (Input_1.Text == firstName && Input_2.Text == lastName) { DialogResult areYouSure = MessageBox.Show("There is already a user with the same name:\n" + "UserName: "******"\nName: " + firstName + " " + lastName + "\n\n" + "Are you sure you would like to continue?", "Are you sure", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (areYouSure == DialogResult.No) { return; //cancels the event action } } } Global.connection.Close(); } catch (SQLiteException ex) { MessageBox.Show(ex.ToString()); } } //If no error message is prompted user is created UserDatabase.AddUser(Input_1.Text, Input_2.Text, Input_3.Text, Input_4.Text, Input_6.Text, Input_7.Text); MessageBox.Show("User successully created\n\nUsername: "******"\nPassword: "******"Register successful", MessageBoxButtons.OK, MessageBoxIcon.Information); //returns to login screen this.Hide(); Login_Screen login = new Login_Screen(); login.ShowDialog(); login.Focus(); }