private void button3_Click(object sender, EventArgs e)
{
try
{
con_db deleteone = new con_db();
string sql = "";
ListViewItem record = listView1.SelectedItems[0];
if (record.SubItems[7].Text == "Root user")
{
MessageBox.Show("You cannot remove this user from the system");
}
else if (record.SubItems[7].Text == "Admin")
{
if (DialogResult.Yes == MessageBox.Show("Are you sure u want to delete this user?", "Confirm deletion", MessageBoxButtons.YesNo))
{
sql = "DELETE FROM admns WHERE usrname='" + record.SubItems[1].Text + "'";
if (deleteone.Delete(sql))
{
MessageBox.Show("user deleted success!!");
Refreshall();
}
}
}
else if (record.SubItems[7].Text == "G/User")
{
if (DialogResult.Yes == MessageBox.Show("Are you sure u want to delete this user?", "Confirm deletion", MessageBoxButtons.YesNo))
{
sql = "DELETE FROM gnrlusers WHERE usrname='" + record.SubItems[1].Text + "'";
if (deleteone.Delete(sql))
{
MessageBox.Show("user deleted success!!");
Refreshall();
}
}
}
else
{
MessageBox.Show("User not found");
}
}
catch (Exception)
{
MessageBox.Show("Cant perform operation. Make sure you have selected a specific user!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button3_Click(object sender, EventArgs e)
{
try
{
con_db deleteone = new con_db();
string sql = "";
ListViewItem record = listView1.SelectedItems[0];
sql = "DELETE FROM stations WHERE st_code='" + record.SubItems[2].Text + "'";
if (DialogResult.Yes == MessageBox.Show("Are you sure you want to delete this station?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
if (deleteone.Delete(sql))
{
MessageBox.Show("user deleted success!!");
}
}
else
{
MessageBox.Show("User not found");
}
}
catch (Exception)
{
MessageBox.Show("Cant perform operation. Make sure you have selected a specific user!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}