//clears the login information and disables all controls on the panel. //Used when right username and password is provided in order to transition to the next panel. private void LoginClear() { attempts = 0; Username_txt.Clear(); Password_txt.Clear(); Username_txt.Enabled = false; Password_txt.Enabled = false; Login_submit.Enabled = false; Incorrect_Login_Warning.Visible = false; SignInPage.Visible = false; //TODO: delete red outline on textboxes. }
// Clear button funcionality private void ClearBtn_Click(object sender, RoutedEventArgs e) { Username_txt.Clear(); Password_txt.Clear(); Username_txt.Focus(); }
private void Clear_btn_Click(object sender, EventArgs e) { Username_txt.Clear(); }
private void Accept_btn_Click(object sender, EventArgs e) { var SecretKey = "b14ca5898a4e4133bbce2ea2315a1916"; string SystemUsersquery = "Select [School_Role], [Full_Name], [Surname] FROM [System Users] WHERE [ID_Number] = @Username and [Password] = @Password"; SqlCommand SelectCommand = new SqlCommand(SystemUsersquery, connection); SelectCommand.Parameters.Add("@Username", SqlDbType.VarChar, 8).Value = Username_txt.Text.Trim(); SelectCommand.Parameters.Add("@Password", SqlDbType.VarChar).Value = EncryptString(SecretKey, Password_txt.Text.Trim()); connection.Open(); SqlDataAdapter sda = new SqlDataAdapter(SelectCommand); DataTable dtbl = new DataTable(); sda.Fill(dtbl); connection.Close(); try { if (dtbl.Rows[0][0].ToString() == "Student") { #region Load Student Portal Student_Interface.Student_Portal StudentPortal = new Student_Interface.Student_Portal(dtbl.Rows[0][1].ToString(), dtbl.Rows[0][2].ToString(), Username_txt.Text.Trim()); this.Hide(); connection.Close(); StudentPortal.Show(); #endregion } else if (dtbl.Rows[0][0].ToString() == "Staff Members") { string StaffQuery = "Select [Staff Title] FROM [Staff Members] WHERE [ID Number] = @Username"; SqlCommand SelectStaffCommand = new SqlCommand(StaffQuery, connection); SelectStaffCommand.Parameters.Add("@Username", SqlDbType.VarChar, 8).Value = Username_txt.Text.Trim(); connection.Open(); SqlDataAdapter Staffsda = new SqlDataAdapter(SelectStaffCommand); DataTable Staffdtbl = new DataTable(); Staffsda.Fill(Staffdtbl); connection.Close(); if (Staffdtbl.Rows[0][0].ToString() == "Security") { #region Load Security Portal Staff_Interface.Security_Portal SecurityPortal = new Staff_Interface.Security_Portal(dtbl.Rows[0][1].ToString(), dtbl.Rows[0][2].ToString(), Username_txt.Text.Trim()); this.Hide(); connection.Close(); SecurityPortal.Show(); #endregion } else if (Staffdtbl.Rows[0][0].ToString() == "Lecturer") { #region Load Lecturer Portal Staff_Interface.Lecturer_Portal LecturerPortal = new Staff_Interface.Lecturer_Portal(dtbl.Rows[0][1].ToString(), dtbl.Rows[0][2].ToString(), Username_txt.Text.Trim()); this.Hide(); connection.Close(); LecturerPortal.Show(); #endregion } else if (Staffdtbl.Rows[0][0].ToString() == "Admin") { #region Load Admin Portal Staff_Interface.Administration_Portal AdministrationPortal = new Staff_Interface.Administration_Portal(dtbl.Rows[0][1].ToString(), dtbl.Rows[0][2].ToString(), Username_txt.Text.Trim()); this.Hide(); connection.Close(); AdministrationPortal.Show(); #endregion } else { connection.Close(); DialogResult dialogResult = MessageBox.Show("Your Username or Password is incorrect", "Incorrect", MessageBoxButtons.OK, MessageBoxIcon.Error); if (dialogResult == DialogResult.OK) { Username_txt.Text = ""; Password_txt.Text = ""; Username_txt.Focus(); } } } } catch (Exception) { connection.Close(); DialogResult dialogResult = MessageBox.Show("Your Username or Password is incorrect", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); if (dialogResult == DialogResult.OK) { Username_txt.Text = ""; Password_txt.Text = ""; Username_txt.Focus(); } } }
private void Button1_Click(object sender, EventArgs e) { try { if (Username_txt.Text == "") { MessageBox.Show("Username is empty", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); Username_txt.Focus(); } else if (Password_txt.Text == "") { MessageBox.Show("Password is empty", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); Password_txt.Focus(); } else if (Full_Name_txt.Text == "") { MessageBox.Show("Role is empty", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); Full_Name_txt.Focus(); } else { OleDbCommand command = new OleDbCommand { CommandType = CommandType.Text, CommandText = "INSERT INTO [System_Users_tbl] ([Role],[Username],[Password],[Creation_Date],[Accountant])" + "VALUES (?,?,?,?,?)" }; command.Parameters.AddWithValue("@Role", Full_Name_txt.Text.Trim()); command.Parameters.AddWithValue("@Username", Username_txt.Text.Trim()); command.Parameters.AddWithValue("@Password", Password_txt.Text.Trim()); command.Parameters.AddWithValue("@Creation_Date", Convert.ToString(User_dateTimePicker.Text.Trim())); command.Parameters.AddWithValue("@Accountant", User_txt.Text.Trim()); command.Connection = connection; connection.Open(); command.ExecuteNonQuery(); connection.Close(); MessageBox.Show(Username_txt.Text.Trim() + " is now a System User, with\n" + Full_Name_txt.Text.Trim() + " privillages", "Successful", MessageBoxButtons.OK, MessageBoxIcon.Information); Username_txt.Text = ""; Password_txt.Text = ""; Full_Name_txt.Text = ""; User_dateTimePicker.Value = DateTime.Now; Full_Name_txt.Focus(); connection.Open(); OleDbCommand ViewCommand = connection.CreateCommand(); ViewCommand.CommandType = CommandType.Text; ViewCommand.CommandText = "select * from [System_Users_tbl]"; ViewCommand.ExecuteNonQuery(); DataTable dta = new DataTable(); OleDbDataAdapter adapt = new OleDbDataAdapter(ViewCommand); adapt.Fill(dta); Users_dataGridView.DataSource = dta; connection.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); MessageBox.Show(ex.StackTrace, "Error Location", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }