private void loadUserRole() { DataTable dt = AdminSection_Methods.loadUserRole(); userRole_comboBox.DisplayMember = "RoleDescription"; userRole_comboBox.ValueMember = "RoleId"; userRole_comboBox.DataSource = dt; }
private void users_dataGridView_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex != -1 && e.ColumnIndex != -1) { if (e.ColumnIndex == users_dataGridView.Columns.Count - 1) { int id = int.Parse(users_dataGridView.Rows[e.RowIndex].Cells[0].Value.ToString()); int affected = AdminSection_Methods.deleteUser(id); if (affected > 0) { AlertBox.ShowDialog("User Deleted Sucesfully", AlertBox.AlertType.success, false); loadDataGridView(); } } } }
private void Ok_button_Click(object sender, EventArgs e) { if (Valid()) { AdminSectionEntity ce = new AdminSectionEntity() { userName = username_TextBox.Text, password = password_TextBox.Text, userRole = int.Parse(userRole_comboBox.SelectedValue.ToString()) }; bool isNotExists = AdminSection_Methods.insertUsers(ce); if (isNotExists) { AlertBox.ShowDialog("UserName is already Exists.", AlertBox.AlertType.error, false); } else { AlertBox.ShowDialog("User Created", AlertBox.AlertType.success, true); } } }
private void loadDataGridView() { DataTable dt = AdminSection_Methods.loadDataGridView(); if (dt.Rows.Count > 0) { users_dataGridView.DataSource = dt; users_dataGridView.AutoGenerateColumns = false; if (!users_dataGridView.Columns.Contains("delete")) { DataGridViewButtonColumn btn = new DataGridViewButtonColumn() { Name = "delete", HeaderText = "DELETE", UseColumnTextForButtonValue = true, Text = "Remove", Visible = true }; users_dataGridView.Columns.Insert(users_dataGridView.Columns.Count, btn); } } }