private void btnBack_OnClick(object sender, EventArgs e) { if (navFromTag) { TaggedInForm taggedInForm = new TaggedInForm(dbConnection, securityStatus, memberId); } else { MemberForm secretaryForm = new MemberForm(dbConnection, securityStatus, memberId); secretaryForm.Show(); } otherWindowOpen = true; this.Close(); }
private void btnSignIn_Click(object sender, EventArgs e) { if (txtUsername.TextLength > 0) { if (txtPassword.TextLength > 0) { if (dbConnection.OpenConnection()) { int memberId = 0; String username = ""; String password = ""; int securityStatus = 0; MySqlCommand command = new MySqlCommand(); command.Connection = dbConnection.getConnection(); command.CommandText = "SELECT member_id, username, password, security_status FROM user_login WHERE username=@username"; command.Parameters.AddWithValue("@username", this.txtUsername.Text); using (MySqlDataReader dr = command.ExecuteReader()) { while (dr.Read()) { memberId = Int32.Parse(dr[0].ToString()); username = dr[1].ToString(); password = dr[2].ToString(); securityStatus = Int32.Parse(dr[3].ToString()); } } dbConnection.CloseConnection(); command.Dispose(); if (username.Equals(txtUsername.Text) && password.Equals(txtPassword.Text)) { switch (securityStatus) { case 1: // System administrator SystemAdminForm systemAdminForm = new SystemAdminForm(dbConnection); systemAdminForm.Show(); signIn = true; this.Close(); break; case 2: // Secretary case 3: // member case 4: // chair MemberForm memberForm = new MemberForm(dbConnection, securityStatus, memberId); memberForm.Show(); signIn = true; this.Close(); break; } } else { MessageBox.Show(this, "Invalid username or password.", "Sign In", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } else { MessageBox.Show(this, "Please enter a valid password.", "Invalid Password", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show(this, "Please enter a valid username.", "Invalid Username", MessageBoxButtons.OK, MessageBoxIcon.Error); } }