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.");
}
}
