private void button1_Click(object sender, EventArgs e) { var index = new FrmIndexForm(); if (lstUsers.Text != string.Empty) { Registration = chkListbox.GetItemChecked(0) == false ? "0" : "1"; Verification = chkListbox.GetItemChecked(1) == false ? "0" : "1"; CastVote = chkListbox.GetItemChecked(2) == false ? "0" : "1"; Admin = chkListbox.GetItemChecked(3) == false ? "0" : "1"; Report = chkListbox.GetItemChecked(4) == false ? "0" : "1"; const string @update = "update Privileges set Registration=@reg, Verification=@verify, CastVote=@cast," + "[Admin]=@admin, Report=@report Where Username=@username"; using (_cnn = new SqlConnection(Settings.Default.DBConn)) { _cnn.Open(); using (_cmd = new SqlCommand(update, _cnn)) { _cmd.Parameters.AddWithValue("username", lstUsers.Text); _cmd.Parameters.AddWithValue("@reg", Registration); _cmd.Parameters.AddWithValue("@verify", Verification); _cmd.Parameters.AddWithValue("@cast", CastVote); _cmd.Parameters.AddWithValue("@admin", Admin); _cmd.Parameters.AddWithValue("@report", Report); _cmd.ExecuteNonQuery(); MessageBox.Show(@"Privilege assigned successfully", @"Assign Privilege to Users"); GetUsers(); } } } else MessageBox.Show(@"Please select a username", @"Assign Privilege to Users"); }
private void btnLogin_Click(object sender, System.EventArgs e) { if (string.IsNullOrEmpty(txtUsername.Text) || string.IsNullOrEmpty(txtPassword.Text)) { MessageBox.Show(@"Username or Password must not be empty", @"User Login"); } else { if (CheckUser(txtUsername.Text, txtPassword.Text)) { int x = 0; progressBar1.Visible = true; progressBar1.Minimum = 1; progressBar1.Maximum = 100000; progressBar1.Step = 1; for (x = 1; x <= 100000; x++) { progressBar1.PerformStep(); } Hide(); var form = new FrmIndexForm {Username = txtUsername.Text}; form.Show(); } else { int x = 0; progressBar1.Visible = true; progressBar1.Minimum = 1; progressBar1.Maximum = 100000; progressBar1.Step = 1; for (x = 1; x <= 100000; x++) { progressBar1.PerformStep(); } MessageBox.Show(@"You have entered a wrong username or password", @"User Login"); progressBar1.Value = 1; txtPassword.Clear(); txtUsername.Clear(); txtUsername.Focus(); } } }