Advertisement
Guest User

Untitled

a guest
Jun 10th, 2017
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Public Class frmUsers
  2.  
  3.     Dim db As New Objects.Db
  4.     Dim p As New Persist
  5.     Dim user As New User
  6.     Public add As Boolean = False 'is in adding mode?
  7.  
  8.     Private Sub btnMenu_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnMenu.Click
  9.         Me.Hide()
  10.         frmMenu.Show()
  11.         frmMenu.Focus()
  12.     End Sub
  13.  
  14.     Private Sub frmUsers_FormClosed(ByVal sender As Object, ByVal e As System.Windows.Forms.FormClosedEventArgs) Handles Me.FormClosed
  15.         frmMenu.Show()
  16.         frmMenu.Focus()
  17.     End Sub
  18.  
  19.     Private Sub btnUser_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUser.Click
  20.         Dim oldUsername As String = user.Username
  21.         user = p.GetObject(db.SQLSelect("Users", New Collection, "Username = '" & txtUsername.Text & "'"), New User)
  22.  
  23.         If (user.Username <> "") Then 'record found
  24.            txtFirstName.Text = user.FirstName
  25.             txtSurname.Text = user.Surname
  26.             txtPassword.Text = user.Password
  27.             txtComments.Text = user.Comments
  28.             cboUserLevel.SelectedIndex = user.AccessLevel - 1
  29.             UpdateUserObject()
  30.             ToggleReadOnly(False)
  31.         Else
  32.             MsgBox("Error. Could not find user: ''" & txtUsername.Text & "''", MsgBoxStyle.Exclamation, "Error")
  33.             txtUsername.Text = oldUsername
  34.         End If
  35.  
  36.     End Sub
  37.  
  38.     Private Sub UpdateUserObject()
  39.         user.Username = txtUsername.Text
  40.         user.FirstName = txtFirstName.Text
  41.         user.Surname = txtSurname.Text
  42.         user.Password = txtPassword.Text
  43.         user.Comments = txtComments.Text
  44.         user.AccessLevel = cboUserLevel.SelectedIndex + 1
  45.     End Sub
  46.  
  47.     Private Sub ClearInput()
  48.         txtUsername.Text = ""
  49.         txtComments.Text = ""
  50.         txtFirstName.Text = ""
  51.         txtSurname.Text = ""
  52.         txtPassword.Text = ""
  53.         cboUserLevel.Text = ""
  54.     End Sub
  55.  
  56.     Private Sub ToggleReadOnly(ByVal isReadOnly As Boolean)
  57.         txtComments.ReadOnly = isReadOnly
  58.  
  59.         If (isReadOnly) Then
  60.             txtComments.BackColor = Color.Gray
  61.         Else
  62.             txtComments.BackColor = Color.White
  63.         End If
  64.  
  65.         txtFirstName.ReadOnly = isReadOnly
  66.         txtSurname.ReadOnly = isReadOnly
  67.         txtPassword.ReadOnly = isReadOnly
  68.         cboUserLevel.Enabled = Not isReadOnly
  69.     End Sub
  70.  
  71.     Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
  72.  
  73.         If Not (add) Then 'editing
  74.            If (user.Username <> "") Then
  75.                 UpdateUserObject()
  76.                 p.UpdateObject(user)
  77.  
  78.                 If (user.Username = frmLogin.user.Username) Then 'edited current user
  79.                    frmLogin.user = user 'get updated user details
  80.                End If
  81.             End If
  82.         Else 'adding
  83.            UpdateUserObject()
  84.             p.AddObject(user)
  85.            
  86.             'normal mode
  87.            btnUser.Enabled = True
  88.             btnDelete.Enabled = True
  89.             add = False
  90.         End If
  91.  
  92.     End Sub
  93.  
  94.     Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click
  95.         Dim result As MsgBoxResult = MsgBox("Are you sure you want to delete this record?", MsgBoxStyle.YesNo, "Caution")
  96.         If (result = MsgBoxResult.Yes) Then
  97.             UpdateUserObject()
  98.             p.DeleteObject(user)
  99.             ToggleReadOnly(True)
  100.             ClearInput()
  101.         End If
  102.     End Sub
  103.  
  104.     Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
  105.         ClearInput()
  106.         btnUser.Enabled = False
  107.         btnDelete.Enabled = False
  108.         add = True
  109.         ToggleReadOnly(False)
  110.     End Sub
  111. End Class
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement