private void BT_back_Click(object sender, EventArgs e) { Rendszergazdavalasztofelulet chwindow = new Rendszergazdavalasztofelulet(); this.Hide(); chwindow.Closed += (s, args) => this.Close(); chwindow.Show(); }
private void BT_start_Click(object sender, EventArgs e) { if (RB_showmessage.Checked == true) { for (int i = 0; i < ids.Count; i++) { if (Convert.ToString(ids[i]) == TB_id.Text) { TB_longreporttext.Text = Convert.ToString(longreports[i]); break; } else if (i == (ids.Count - 1)) { MessageBox.Show("Nincs ilyen azonosítójú jelentés!"); } } } else if (RB_closereport.Checked == true) { for (int i = 0; i < ids.Count; i++) { if (Convert.ToString(ids[i]) == TB_id.Text) { try { string myConnection = "datasource=127.0.0.1;port=3306;username=root;password=root;database=hibanaplo;"; MySqlConnection myConn = new MySqlConnection(myConnection); myConn.Open(); MySqlCommand sqlcmd = myConn.CreateCommand(); sqlcmd.CommandType = CommandType.Text; string command = "INSERT INTO closedreports (typeofreport,nameofreporter,emailofreporter,phonenumberofreporter,dateofperception,timeofperception,longreport) VALUES ('" + Convert.ToString(typeofreports[i]) + "','" + Convert.ToString(nameofreporters[i]) + "','" + Convert.ToString(emailofreporters[i]) + "','" + Convert.ToString(phonenumberofreporters[i]) + "','" + Convert.ToString(dateofperceptions[i]) + "','" + Convert.ToString(timeofperceptions[i]) + "','" + Convert.ToString(longreports[i]) + "')"; sqlcmd.CommandText = command; sqlcmd.ExecuteNonQuery(); command = "DELETE FROM reports WHERE ID='" + Convert.ToString(ids[i]) + "'"; sqlcmd.CommandText = command; sqlcmd.ExecuteNonQuery(); myConn.Close(); MessageBox.Show("A művelet végre lett hajtva!"); Rendszergazdavalasztofelulet chwindow = new Rendszergazdavalasztofelulet(); this.Hide(); chwindow.Closed += (s, args) => this.Close(); chwindow.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message); } TB_longreporttext.Text = Convert.ToString(longreports[i]); break; } else if (i == (ids.Count - 1)) { MessageBox.Show("Nincs ilyen azonosítójú jelentés!"); } } } }
private void BT_change_Click(object sender, EventArgs e) { try { string myConnection = "datasource=127.0.0.1;port=3306;username=root;password=root;database=hibanaplo;"; MySqlConnection myConn = new MySqlConnection(myConnection); myConn.Open(); MySqlCommand sqlcmd = myConn.CreateCommand(); sqlcmd.CommandType = CommandType.Text; string command = "UPDATE email SET sysadminsemail = '" + TB_newsysemail.Text + "', senderemail = '" + TB_newsenderemail.Text + "', senderpassword = '******' WHERE senderemail = '" + TB_actualsenderemail.Text + "'"; sqlcmd.CommandText = command; sqlcmd.ExecuteNonQuery(); myConn.Close(); MessageBox.Show("Az adatok sikeresen meg lettek változtatva!"); Rendszergazdavalasztofelulet chwindow = new Rendszergazdavalasztofelulet(); this.Hide(); chwindow.Closed += (s, args) => this.Close(); chwindow.Show(); } catch (Exception) { MessageBox.Show("Nem sikerült kapcsolódni az adatbázishoz!"); } }
private void BT_login_Click(object sender, EventArgs e) { if (LBL_message.Text == "Ön a felhasználói belépést választotta!") { try { string myConnection = "datasource=127.0.0.1;port=3306;username=root;password=root;database=hibanaplo;"; MySqlConnection myConn = new MySqlConnection(myConnection); myConn.Open(); MySqlCommand sqlcmd = myConn.CreateCommand(); sqlcmd.CommandType = CommandType.Text; string command = "SELECT * FROM users WHERE username='******' and password ='******'";; sqlcmd.CommandText = command; DataTable datatable = new DataTable(); MySqlDataAdapter dataadapter = new MySqlDataAdapter(sqlcmd); sqlcmd.ExecuteNonQuery(); dataadapter.Fill(datatable); int i = datatable.Rows.Count; if (i == 0) { MessageBox.Show("Hibás felhasználónév vagy jelszó!"); } else { MessageBox.Show("A belépés sikeres! "); felhasznaloibejelento userreporter = new felhasznaloibejelento(); this.Hide(); userreporter.Closed += (s, args) => this.Close(); userreporter.Show(); } myConn.Close(); } catch (Exception) { MessageBox.Show("Nem sikerült kapcsolódni az adatbázishoz!"); } } else { try { string myConnection = "datasource=127.0.0.1;port=3306;username=root;password=root;database=hibanaplo;"; MySqlConnection myConn = new MySqlConnection(myConnection); myConn.Open(); MySqlCommand sqlcmd = myConn.CreateCommand(); sqlcmd.CommandType = CommandType.Text; string command = "SELECT * FROM sysadmins WHERE username='******' and password ='******'";; sqlcmd.CommandText = command; DataTable datatable = new DataTable(); MySqlDataAdapter dataadapter = new MySqlDataAdapter(sqlcmd); sqlcmd.ExecuteNonQuery(); dataadapter.Fill(datatable); int i = datatable.Rows.Count; if (i == 0) { MessageBox.Show("Hibás felhasználónév vagy jelszó!"); } else { MessageBox.Show("A belépés sikeres!"); Rendszergazdavalasztofelulet sysadminchoise = new Rendszergazdavalasztofelulet(); this.Hide(); sysadminchoise.Closed += (s, args) => this.Close(); sysadminchoise.Show(); } myConn.Close(); } catch (Exception) { MessageBox.Show("Nem sikerült kapcsolódni az adatbázishoz!"); } } }