private void BtnClear_Click(object sender, EventArgs e) { TxtFirstName.Clear(); TxtLastName.Clear(); TxtGrade.Clear(); TxtAddress.Clear(); TxtContactNo.Clear(); TxtUserID.Clear(); }
private void BtnUpdate_Click(object sender, EventArgs e) { if (TxtFirstName.Text == "") { MessageBox.Show("Please fill empty fields!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else if (TxtLastName.Text == "") { MessageBox.Show("Please fill empty fields!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else if (TxtGrade.Text == "") { MessageBox.Show("Please fill empty fields!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else if (TxtAddress.Text == "") { MessageBox.Show("Please fill empty fields!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else if (TxtContactNo.Text == "") { MessageBox.Show("Please fill empty fields!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { var result = MessageBox.Show("Confirm editing new record?", "Edit New Record", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { using (var con = new MySqlConnection(GetConnection())) { string command = $"UPDATE `lms.sad`.`tblusers`" + $" SET " + $"`First_Name`='{TxtFirstName.Text}',`Last_Name`='{TxtLastName.Text}',`Year_Level`='{TxtGrade.Text}',`Address`='{TxtAddress.Text}',`Contact_Number`='{TxtContactNo.Text}'" + $" WHERE `User_ID`='{TxtUserID.Text}'"; con.Open(); using (var cmd = new MySqlCommand(command, con)) { cmd.CommandType = CommandType.Text; var i = cmd.ExecuteNonQuery(); if (i > 0) { MessageBox.Show("Successfully Updated! Please refresh Book List to view entry!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); TxtFirstName.Clear(); TxtLastName.Clear(); TxtGrade.Clear(); TxtAddress.Clear(); TxtContactNo.Clear(); TxtUserID.Clear(); } } con.Close(); } } } }
private void BtnLogin_Click(object sender, RoutedEventArgs e) { User checkUser = AppState.AllUsers.Find(user => user.Username == TxtUserID.Text.Trim()); if (checkUser != null && checkUser != new User() && PBKDF2.ValidatePassword(PswdPassword.Password.Trim(), checkUser.Password)) { AppState.CurrentUser = checkUser; TxtUserID.Clear(); PswdPassword.Clear(); TxtUserID.Focus(); AppState.Navigate(new TimeClockPage()); AppState.MainWindow.MnuAdmin.IsEnabled = false; } else { AppState.DisplayNotification("Invalid login.", "Time Clock"); } }