private void metroGrid1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (metroGrid1.Columns[e.ColumnIndex].Name == "deleteUsr")
{
String username = metroGrid1.Rows[e.RowIndex].Cells[0].Value.ToString();
DataCon d2 = new DataCon();
String query = "delete from users where username like '" + username + "'";
d2.execInsert(query);
}
}
private void metroGrid2_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (metroGrid2.Columns[e.ColumnIndex].Name == "deleteUsr")
{
String nid1 = metroGrid1.Rows[e.RowIndex].Cells[0].Value.ToString();
int id = System.Convert.ToInt32(nid1);
DataCon d2 = new DataCon();
String query = "delete from email where nid like '" + id + "'";
d2.execInsert(query);
String query2 = "SELECT * FROM email";
fillGrid(query2, 2, 2);
}
}
private void metroButton4_Click(object sender, EventArgs e)
{
if (!((String.IsNullOrEmpty(metroTextBox2.Text)) || (String.IsNullOrEmpty(metroTextBox3.Text)) || (String.IsNullOrEmpty(metroTextBox4.Text)) || (String.IsNullOrEmpty(metroTextBox5.Text))))
{
DataCon d3 = new DataCon();
String command = "UPDATE users set password = '******', access_level = '" + metroTextBox5.Text + "', staff_id = '" + metroTextBox4.Text + "' where username like '" + metroTextBox2.Text + "'";
d3.execInsert(command);
fillGrid("SELECT * FROM users");
}
else
{
MessageBox.Show("One or More fields left empty. Please enter and try again!");
}
}
private void metroButton2_Click(object sender, EventArgs e)
{
if (!((String.IsNullOrEmpty(metroTextBox2.Text) || (String.IsNullOrEmpty(metroTextBox3.Text)) || (String.IsNullOrEmpty(metroTextBox4.Text) || (String.IsNullOrEmpty(metroTextBox5.Text))))))
{
DataCon dc2 = new DataCon();
String command = "INSERT INTO users VALUES('" + metroTextBox2.Text + "', '" + Security.Encript(metroTextBox3.Text) + "', '" + metroTextBox5.Text + "',NULL, '" + metroTextBox4.Text + "');";
dc2.execInsert(command);
fillGrid("SELECT * FROM users");
}
else
{
MessageBox.Show("One or more fields are left empty. Please enter and try again!");
}
}
private void metroGrid1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (metroGrid1.Columns[e.ColumnIndex].Name == "deleteUsr")
{
String nid1 = metroGrid1.Rows[e.RowIndex].Cells[0].Value.ToString();
int nid = 0;
try
{
nid = System.Convert.ToInt32(nid1);
}catch (Exception e0) {
MessageBox.Show(e0.Message);
}
DataCon d2 = new DataCon();
String query = "delete from notification where nid like '" + nid + "'";
d2.execInsert(query);
String query2 = "SELECT * FROM notification";
fillGrid(query2, 1, 2);
}
}
private void metroTile5_Click(object sender, EventArgs e)
{
dc.execInsert("INSERT INTO tempuser VALUES('" + LoggedIn.getlogin() + "', '" + LoggedIn.getUsername() + "','" + LoggedIn.getUID() + "','" + LoggedIn.getAL() + "')");
Application.Restart();
}