// retrieves saved notification values from DB private void runLatestSet() { string constring2 = "datasource=localhost; port=3306; username=root; password=5011"; string Query2 = "SELECT expirydays,levels FROM apms.notifications WHERE nid = 1;"; MySqlConnection conDataBase2 = new MySqlConnection(constring2); MySqlCommand cmdDataBase2 = new MySqlCommand(Query2, conDataBase2); MySqlDataReader myReader2; try { conDataBase2.Open(); myReader2 = cmdDataBase2.ExecuteReader(); string daExpirydays = ""; string daLevels = ""; while (myReader2.Read()) { daExpirydays = myReader2["expirydays"].ToString(); daLevels = myReader2["levels"].ToString(); } // instance the event args and pass it each value NotifyUpdateEventArgs args = new NotifyUpdateEventArgs(daExpirydays, daLevels); // raise the event with the updated arguments NotifyUpdated(this, args); this.Dispose(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void NotifyForm_ButtonClicked(object sender, NotifyUpdateEventArgs e) { ExpiryThreshold = Convert.ToInt32(e.getExpiryDays); LevelsThreshold = Convert.ToInt32(e.getLevels); }