public CUser GetUser(SqlConnection conn, string sNameandSurname) { string sUserName = sNameandSurname.Substring(sNameandSurname.IndexOf('|') + 1); conn = new SqlConnection(@"Data Source=DESKTOP-DPSO24P\GAVIN_SERVER;Initial Catalog=QrScanner;Integrated Security=True"); CUser user = new CUser(); if (conn.State == System.Data.ConnectionState.Closed) { conn.Open(); } using (conn) { SqlCommand cmd = new SqlCommand("sp_GetUser", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserName", sUserName); cmd.Parameters.Add("@ID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@Name", SqlDbType.VarChar, 30).Direction = ParameterDirection.Output; cmd.Parameters.Add("@Surname", SqlDbType.VarChar, 30).Direction = ParameterDirection.Output; cmd.Parameters.Add("@Password", SqlDbType.VarChar, 30).Direction = ParameterDirection.Output; cmd.Parameters.Add("@UserType", SqlDbType.VarChar, 20).Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); user.sID = (int)(cmd.Parameters["@ID"].Value); user.sName = Convert.ToString(cmd.Parameters["@Name"].Value); user.sSurname = Convert.ToString(cmd.Parameters["@Surname"].Value); user.sPassword = Convert.ToString(cmd.Parameters["@Password"].Value); user.sUserType = Convert.ToString(cmd.Parameters["@UserType"].Value); user.sUserName = sUserName; return(user); } }
public static CUser GetInstance() { if (UniqueLogin == null) { UniqueLogin = new CUser(); } return(UniqueLogin); }
private void PopulateUserList() { lstbxUsers.Items.Clear(); User = CUser.GetInstance(); foreach (CUser user in User.getUsers()) { lstbxUsers.Items.Add(user.sName + " " + user.sSurname + user.sUserName); } }
private void listBox1_SelectedIndexChanged(object sender, EventArgs e) { ClearUserText(); btnAdd.Visible = false; btnEdit.Visible = true; grpbxAddUsers.Enabled = true; grpbxAddUsers.Text = "Edit User"; User = CUser.GetInstance(); User = User.GetUser(conn, lstbxUsers.SelectedItem.ToString()); txtUserID.Text = User.sID.ToString(); txtName.Text = User.sName; txtPassword.Text = User.sPassword; txtSurname.Text = User.sSurname; txtUseranme.Text = User.sUserName; cmbUserType.SelectedIndex = cmbUserType.FindStringExact(User.sUserType); }
private void btnEdit_Click(object sender, EventArgs e) { if (txtName.Text != "" && txtPassword.Text != "" && txtSurname.Text != "" && txtUseranme.Text != "") { User = CUser.GetInstance(); int IsValid; IsValid = User.EditUser(conn, Convert.ToInt32(txtUserID.Text), txtName.Text, txtSurname.Text, txtUseranme.Text, txtPassword.Text, cmbUserType.SelectedItem.ToString()); if (IsValid == 1) { MessageBox.Show("User updated successfully!"); } else { MessageBox.Show("There was an error updating this user!"); } PopulateUserList(); } }
private void btnRemove_Click(object sender, EventArgs e) { DialogResult dr = new DialogResult(); dr = MessageBox.Show("Are you sure you want to remove this user?", "OK", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { User = CUser.GetInstance(); int IsValid; IsValid = User.RemoveUser(conn, Convert.ToInt32(txtUserID.Text)); if (IsValid == 1) { MessageBox.Show("User has successfully been removed!"); PopulateUserList(); ClearUserTextBoxes(); lstbxUsers.SelectedIndex = 0; } else { MessageBox.Show("Please select a user to be removed."); } } }
private void btnAdd_Click(object sender, EventArgs e) { if (txtName.Text != "" && txtPassword.Text != "" && txtSurname.Text != "" && txtUseranme.Text != "") { User = CUser.GetInstance(); int IsValid = User.AddNewUser(conn, txtUseranme.Text, txtPassword.Text, txtName.Text, txtSurname.Text, cmbUserType.SelectedItem.ToString()); if (IsValid == 1) { MessageBox.Show("User added successfully!"); PopulateUserList(); ClearUserTextBoxes(); lstbxUsers.SelectedIndex = 0; EnableUserButtons(); } else { MessageBox.Show("User with this username already exists."); } } else { MessageBox.Show("Please fill in all the text boxes available."); } }