private void ManageUsers_Load(object sender, EventArgs e) { dc = new DataCon(); String defQuery = "SELECT * FROM users"; fillGrid(defQuery); }
private void metroButton3_Click(object sender, EventArgs e) { if (!((DateTime.Compare(Convert.ToDateTime(metroDateTime1.Text), DateTime.Now) < 0) || (String.IsNullOrEmpty(metroTextBox2.Text) || (String.IsNullOrEmpty(metroTextBox13.Text) || (String.IsNullOrEmpty(metroTextBox3.Text)))))) { String fd = metroDateTime1.Value.ToString("yyyy-MM-dd"); DataCon dc1 = new DataCon(); SqlDataReader dr = dc1.execSelect("SELECT staff_id from users where access_level like '" + metroTextBox13.Text + "'"); List <String> rec = new List <string>(); try { while (dr.Read()) { rec.Add((String)dr[0]); //MessageBox.Show("Read :Line"); } }catch (Exception ex2) { MessageBox.Show(ex2.Message); } dc1.closeCon(); for (int i = 0; i < rec.Count; i++) { String command = "INSERT INTO notification VALUES ('" + fd + "',GETDATE(), '" + metroTextBox2.Text + "','" + metroTextBox3.Text + "','" + rec[i] + "')"; new DataCon().execInsert(command); MessageBox.Show("Added"); fillGrid("SELECT * FROM notification", 1, 1); } } else { MessageBox.Show("Empty or Invalid fields. Please Correct and try again!"); } }
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 Communication_Load(object sender, EventArgs e) { dc = new DataCon(); metroTabControl2.SelectedTab = tabPage4; String query = "SELECT * FROM notification"; String query2 = "SELECT * FROM email"; fillGrid(query, 1); fillGrid(query2, 2); }
void dispTableLog(String query) { DataCon dc = new DataCon(); SqlDataAdapter da = dc.selectTable(query); DataTable dt = new DataTable(); da.Fill(dt); metroGrid2.DataSource = dt; }
private void metroButton5_Click(object sender, EventArgs e) { String command = "RESTORE DATABASE bisdb FROM DISK ='" + metroTextBox1.Text + "' WITH REPLACE"; DataCon dc4 = new DataCon(); dc4.openCon(); SqlCommand cmd = new SqlCommand(command, dc4.getCon()); dc4.closeCon(); dc4.dispCon(); MessageBox.Show("SuccessFully Restored"); }
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 metroButton12_Click(object sender, EventArgs e) { if (!((DateTime.Compare(Convert.ToDateTime(metroDateTime1.Text), DateTime.Now) < 0) || (String.IsNullOrEmpty(metroTextBox2.Text) || (String.IsNullOrEmpty(metroTextBox13.Text) || (String.IsNullOrEmpty(metroTextBox3.Text) || (String.IsNullOrEmpty(metroTextBox12.Text))))))) { String fd = metroDateTime1.Value.ToString("yyyy-MM-dd"); DataCon d3 = new DataCon(); DataCon dc1 = new DataCon(); SqlDataReader dr = dc1.execSelect("SELECT staff_id from users where access_level like '" + metroTextBox13.Text + "'"); List <String> rec = new List <string>(); try { while (dr.Read()) { rec.Add((String)dr[0]); // MessageBox.Show("Read :Line"); } } catch (Exception ex2) { MessageBox.Show(ex2.Message); } dc1.closeCon(); for (int i = 0; i < rec.Count; i++) { String command = "UPDATE notification set date = '" + fd + "', subject = '" + metroTextBox2.Text + "', message = '" + metroTextBox3.Text + "', staff_id = '" + rec[i] + "' WHERE nid = '" + System.Convert.ToInt32(metroTextBox12.Text) + "'"; new DataCon().execInsert(command); MessageBox.Show("Updated"); } fillGrid("SELECT * from notification", 1, 1); } else { MessageBox.Show("Invalid or incomplete fields. Please complete and try agian."); } }
private void Form1_Load(object sender, EventArgs e) { dc = new DataCon(); }
public BackupRestore() { dc = new DataCon(); InitializeComponent(); }