public void Edit_Admin_ListedUser() { #region try { string sqlQuery1 = $"INSERT INTO dbo.DatabaseHistory" + $" VALUES ('Listed User Record with EmployeeID = {Admin_ListedUsers_ListedUsersDetails_EmployeeID_TextBox.Text} was UPDATED at {DateTime.Now.ToString("MM/dd/yyyy hh:mm tt")}', @Username)"; string sqlQuery2 = "UPDATE dbo.ListedUsers" + " SET Email = @Email," + " PhoneNo = @PhoneNo," + " Department = @Department" + " WHERE EmployeeID = @EmployeeID"; using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd1 = new SqlCommand(sqlQuery1, conn); cmd1.Parameters.AddWithValue("@EmployeeID", Admin_ListedUsers_ListedUsersDetails_EmployeeID_TextBox.Text); cmd1.Parameters.AddWithValue("@Username", Admin_ListedUsers_LoginDetails_LoggedInAs_TextBox.Text); SqlCommand cmd2 = new SqlCommand(sqlQuery2, conn); cmd2.Parameters.AddWithValue("@EmployeeID", Admin_ListedUsers_ListedUsersDetails_EmployeeID_TextBox.Text); cmd2.Parameters.AddWithValue("@Email", Admin_ListedUsers_ListedUsersDetails_Email_TextBox.Text); cmd2.Parameters.AddWithValue("@PhoneNo", Admin_ListedUsers_ListedUsersDetails_PhoneNo_TextBox.Text); cmd2.Parameters.AddWithValue("@Department", Admin_ListedUsers_ListedUsersDetails_Department_Dropdown.Text); DialogResult dialog = MessageBox.Show($"Are you sure you want to make the following changes to this Employee record with EmployeeID = {Admin_ListedUsers_ListedUsersDetails_EmployeeID_TextBox.Text}?:" + $"\n\nEmail:\t\t{Admin_ListedUsers_ListedUsersDetails_Email_TextBox.Text}" + $"\nPhoneNo:\t{Admin_ListedUsers_ListedUsersDetails_PhoneNo_TextBox.Text}" + $"\nDepartment\t{Admin_ListedUsers_ListedUsersDetails_Department_Dropdown.Text}", "Update Record", MessageBoxButtons.YesNo); if (dialog == DialogResult.Yes) { int a = cmd1.ExecuteNonQuery(); if (a > 0) { MessageBox.Show("Record Updated Successfully", "Successful Update", MessageBoxButtons.OK); cmd2.ExecuteNonQuery(); } else { MessageBox.Show("Record Update Failed", "Failed Update", MessageBoxButtons.OK, MessageBoxIcon.Error); } Admin_ListedUsers a_lu = new Admin_ListedUsers(Admin_ListedUsers_LoginDetails_LoggedInAs_TextBox.Text, Admin_ListedUsers_LoginDetails_UserLevel_TextBox.Text); this.Hide(); a_lu.ShowDialog(); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } #endregion }
private void Load_Admin_ListedUsers() { #region Admin_ListedUsers lup = new Admin_ListedUsers(NewUser_LoginDetails_LoggedInAs_TextBox.Text, NewUser_LoginDetails_UserLevel_TextBox.Text); this.Hide(); lup.ShowDialog(); #endregion }
public void Load_Admin_ListedUsers() { #region Admin_ListedUsers a_lup = new Admin_ListedUsers(Admin_LoginDetails_LoggedInAs_TextBox.Text, Admin_LoginDetails_UserLevel_TextBox.Text); this.Hide(); a_lup.ShowDialog(); #endregion }
public void Delete_Admin_ListedUser() { #region try { string sqlQuery1 = $"INSERT INTO dbo.DatabaseHistory" + $" VALUES('ListedUser Record with EmployeeID = {Admin_ListedUsers_ListedUsersDetails_EmployeeID_TextBox.Text} was DELETED at {DateTime.Now.ToString("MM/dd/yyyy hh:mm tt")}', @Username)"; string sqlQuery2 = $"DELETE FROM dbo.LoginDetails WHERE Username = @Username;"; using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd1 = new SqlCommand(sqlQuery1, conn); cmd1.Parameters.AddWithValue("@EmployeeID", Admin_ListedUsers_ListedUsersDetails_EmployeeID_TextBox.Text); cmd1.Parameters.AddWithValue("@Username", Admin_ListedUsers_LoginDetails_LoggedInAs_TextBox.Text); SqlCommand cmd2 = new SqlCommand(sqlQuery2, conn); cmd2.Parameters.AddWithValue("@Username", Admin_ListedUsers_ListedUsersDetails_Username_TextBox.Text); DialogResult dialog = MessageBox.Show("Are you sure you want to delete this Listed User?:" + $"\n\nStudentID:\t{Admin_ListedUsers_ListedUsersDetails_EmployeeID_TextBox.Text}" + $"\nUsername:\t{Admin_ListedUsers_ListedUsersDetails_Username_TextBox.Text}" + $"\nFirst Name:\t{Admin_ListedUsers_ListedUsersDetails_Surname_TextBox.Text}" + $"\nSurname:\t{Admin_ListedUsers_ListedUsersDetails_FirstName_TextBox.Text}" + $"\nEmail:\t\t{Admin_ListedUsers_ListedUsersDetails_Email_TextBox.Text}" + $"\nPhoneNo:\t{Admin_ListedUsers_ListedUsersDetails_PhoneNo_TextBox.Text}", "Delete Record", MessageBoxButtons.YesNo ); if (dialog == DialogResult.Yes) { int a = cmd1.ExecuteNonQuery(); if (a > 0) { MessageBox.Show("Record Deleted Successfully", "Successful Delete", MessageBoxButtons.OK); cmd2.ExecuteNonQuery(); } else { MessageBox.Show("Record Deletion Failed. Please try again", "Failed Delete", MessageBoxButtons.OK, MessageBoxIcon.Error); } Admin_ListedUsers lup = new Admin_ListedUsers(Admin_ListedUsers_LoginDetails_LoggedInAs_TextBox.Text, Admin_ListedUsers_LoginDetails_UserLevel_TextBox.Text); this.Hide(); lup.ShowDialog(); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } #endregion }