private void button1_Click(object sender, EventArgs e) { try { PermissionsQueries a = new PermissionsQueries(); string ask = "can"; if (textBox1.Text != String.Empty) { for (int i = 0; i < listView1.Items.Count; i++) { if (textBox1.Text == listView1.Items[i].SubItems[1].Text) { ask = "can not"; MessageBox.Show("Entry can not be same", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } if (ask == "can") { a.addCountry(textBox1.Text, comboBox1.Text); a.displayPermisisons(listView1); Permissions_Load(sender, e); } } } catch (Exception ex) { } }
private void Permissions_Load(object sender, EventArgs e) { PermissionsQueries a = new PermissionsQueries(); a.displayPermisisons(listView1); allowed = 0; forbid = 0; tot = 0; for (int i = 0; i < listView1.Items.Count; i++) { tot++; if (listView1.Items[i].SubItems[2].Text == "Allowed") { allowed++; } else if (listView1.Items[i].SubItems[2].Text == "Forbid") { forbid++; } } toolStripStatusLabel1.Text = "Allowed : " + allowed; toolStripStatusLabel2.Text = "Forbid : " + forbid; toolStripStatusLabel3.Text = "Total : " + tot; }
private void button3_Click(object sender, EventArgs e) { try { int id = int.Parse(listView1.SelectedItems[0].Text); PermissionsQueries a = new PermissionsQueries(); a.updatePermissions(id, textBox1.Text, comboBox1.Text); a.displayPermisisons(listView1); Permissions_Load(sender, e); } catch (Exception ex) { } }
private void button2_Click(object sender, EventArgs e) { try { int id = int.Parse(listView1.SelectedItems[0].Text); PermissionsQueries a = new PermissionsQueries(); a.deleteCountry(id); a.displayPermisisons(listView1); Permissions_Load(sender, e); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button5_Click(object sender, EventArgs e) { try { textBox1.Clear(); comboBox1.SelectedIndex = 0; listView1.Items.Clear(); listView1.Refresh(); PermissionsQueries a = new PermissionsQueries(); a.displayPermisisons(listView1); Permissions_Load(sender, e); } catch (Exception ex) { } }