public void countold() //count old member { string query = "Select count(membership) from member_list where Membership = '0oJH9mE2Sm4=';"; if (MainMenu.OpenConnection()) { try { MySqlCommand command = new MySqlCommand(query, MainMenu.conn); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { MessageBox.Show(reader[0].ToString() + " old members.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (MySqlException ex) { MessageBox.Show(ex.Message); } finally { MainMenu.CloseConnection(); } } }
public void Populate_ListView(string myquery) { listView1.Items.Clear(); ListViewItem iItem; string query = myquery; if (MainMenu.OpenConnection()) { try { MySqlCommand cmd = new MySqlCommand(query, MainMenu.conn); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { iItem = new ListViewItem(dataReader[0].ToString()); iItem.SubItems.Add(decode(dataReader[1].ToString())); fullname = decode(dataReader[2].ToString()) + " " + decode(dataReader[3].ToString()); iItem.SubItems.Add(fullname); listView1.Items.Add(iItem); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { MainMenu.CloseConnection(); } listView1.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent); listView1.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize); } }
public void LEI(string ID) // LEI = Load Event Info { string query = "Select Event_Name, Event_Location, Event_Pubmat from event_list where Event_Name = '" + EnCryptDecrypt.CryptorEngine.Encrypt(ID, true) + "'"; if (MainMenu.OpenConnection()) { try { MySqlCommand command = new MySqlCommand(query, MainMenu.conn); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { textBox1.Text = EnCryptDecrypt.CryptorEngine.Decrypt(reader[0].ToString(), true); textBox2.Text = EnCryptDecrypt.CryptorEngine.Decrypt(reader[1].ToString(), true); Image dump = pictureBox1.BackgroundImage; if (dump != null) { dump.Dispose(); } pictureBox1.BackgroundImage = Image.FromFile(EnCryptDecrypt.CryptorEngine.Decrypt(reader[2].ToString(), true)); pictureBox1.BackgroundImageLayout = ImageLayout.Stretch; } } catch (MySqlException ex) { MessageBox.Show(ex.Message); } finally { MainMenu.CloseConnection(); } } }
public void Populate_Combobox(string myquery) { comboBox2.Items.Clear(); comboBox2.Text = ""; string query = myquery; if (MainMenu.OpenConnection()) { try { MySqlCommand cmd = new MySqlCommand(query, MainMenu.conn); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { comboBox2.Items.Add(dataReader[0].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { MainMenu.CloseConnection(); } listView1.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent); listView1.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize); } }
public void GetEname(string ename) { int dup = 1; string query = "select count(Event_Name) from event_list where Event_name = '" + EnCryptDecrypt.CryptorEngine.Encrypt(ename, true) + "';"; if (MainMenu.OpenConnection()) { try { MySqlCommand cmd = new MySqlCommand(query, MainMenu.conn); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { if (Convert.ToInt32(dataReader[0].ToString()) >= dup) { duplicate = true; } } } catch (MySqlException ex) { MessageBox.Show(ex.Message); } finally { MainMenu.CloseConnection(); } } }
public static void GetSN(int id) { int dup = 1; string query = "select count(*) from " + Event_List.event_name + " where ID_No = " + id + ";"; if (MainMenu.OpenConnection()) { try { MySqlCommand cmd = new MySqlCommand(query, MainMenu.conn); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { if (dup == Convert.ToInt32(dataReader[0].ToString())) { duplicate = true; } else { duplicate = false; } } } catch (MySqlException ex) { MessageBox.Show(ex.Message); } finally { MainMenu.CloseConnection(); } } }
public void Max_ID() { string query = "select max(ID_No) from member_list;"; if (MainMenu.OpenConnection()) { try { MySqlCommand cmd = new MySqlCommand(query, MainMenu.conn); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { query_ID = Convert.ToInt32(dataReader[0]); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { MainMenu.CloseConnection(); } } }
public void checkuser() { string query = "select count(user) from mysql.user where user = '******'"; if (MainMenu.OpenConnection()) { try { MySqlCommand command = new MySqlCommand(query, MainMenu.conn); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { user_accounts = Convert.ToInt32(reader[0].ToString()); } } catch (MySqlException ex) { MessageBox.Show(ex.Message); } finally { MainMenu.CloseConnection(); } } }
public void LMI(string ID) // LMI = Load Member Info { string query = "Select * from member_list where ID_NO = '" + ID + "'"; if (MainMenu.OpenConnection()) { try { MySqlCommand command = new MySqlCommand(query, MainMenu.conn); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { lastname = EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("LN"), true); firstname = EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("FN"), true); mi = EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("MI"), true); textBox1.Text = EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("FN"), true) + " " + EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("MI"), true) + " " + EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("LN"), true); textBox2.Text = EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("Address"), true); textBox3.Text = EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("Contact_No"), true); textBox4.Text = EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("Year_Level"), true); textBox5.Text = EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("Gender"), true); textBox6.Text = EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("Age"), true); textBox7.Text = EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("Email"), true); textBox8.Text = EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("BDay"), true); } } catch (MySqlException ex) { MessageBox.Show(ex.Message); } finally { MainMenu.CloseConnection(); } } }
public void checkdb(string ID, string check) { string query = "show databases like '" + ID + "';"; MySqlCommand command; if (MainMenu.OpenConnection()) { try { if (ID == "report_table_1") { command = new MySqlCommand("show tables where tables_in_coess = 'report_table_1';", MainMenu.conn); } else { command = new MySqlCommand(query, MainMenu.conn); } MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { if (check == reader[0].ToString()) { if (check == "coess") { coessdb = true; } if (check == "coess_events") { coess_eventsdb = true; } if (check == "report_table_1") { report_table = true; } } } } catch (MySqlException ex) { MessageBox.Show(ex.Message); } finally { MainMenu.CloseConnection(); } } }
public void LMI(string ID) // LMI = Load Member Info { string query = "Select * from member_list where ID_NO = '" + ID + "'"; if (MainMenu.OpenConnection()) { try { MySqlCommand command = new MySqlCommand(query, MainMenu.conn); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Member_List.lastname = EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("LN"), true); Member_List.firstname = EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("FN"), true); Member_List.mi = EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("MI"), true); textBox1.Text = EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("FN"), true) + " " + EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("MI"), true) + " " + EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("LN"), true); textBox2.Text = EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("Address"), true); textBox3.Text = EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("Contact_No"), true); textBox4.Text = EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("Year_Level"), true); textBox5.Text = EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("Guard_Name"), true); textBox6.Text = EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("Guard_Contact"), true); textBox7.Text = EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("Age"), true); textBox8.Text = EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("SN"), true); textBox9.Text = EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("Comm"), true); textBox10.Text = EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("Membership"), true); textBox11.Text = EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("BDay"), true); // MessageBox.Show(EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("Email"), true)); Image dump = pictureBox1.BackgroundImage; if (dump != null) { dump.Dispose(); } pictureBox1.BackgroundImage = Image.FromFile(EnCryptDecrypt.CryptorEngine.Decrypt(reader.GetString("ID_Address"), true)); pictureBox1.BackgroundImageLayout = ImageLayout.Stretch; } } catch (MySqlException ex) { MessageBox.Show(ex.Message); } finally { MainMenu.CloseConnection(); } } }
public void LA(string event_name) // LA=Load Attendees { if (event_name == null) { MessageBox.Show("No Event Selected!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { string query = "Select FN, LN, SN, ID_No, Time_In, Time_Out from " + event_name + ";"; listView2.Items.Clear(); ListViewItem iItem; if (MainMenu.OpenConnection()) { try { MySqlCommand cmd = new MySqlCommand(query, MainMenu.conn); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { iItem = new ListViewItem(EnCryptDecrypt.CryptorEngine.Decrypt(dataReader[0].ToString(), true)); iItem.SubItems.Add(EnCryptDecrypt.CryptorEngine.Decrypt(dataReader[1].ToString(), true)); iItem.SubItems.Add(EnCryptDecrypt.CryptorEngine.Decrypt(dataReader[2].ToString(), true)); iItem.SubItems.Add(dataReader[3].ToString()); iItem.SubItems.Add(dataReader[4].ToString()); iItem.SubItems.Add(dataReader[5].ToString()); listView2.Items.Add(iItem); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { MainMenu.CloseConnection(); } listView2.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent); listView2.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize); label5.Text = listView2.Items.Count.ToString(); listView2.Items[listView2.Items.Count - 1].EnsureVisible(); } } }
public static void Updated(string col, string data, string ID) //col = column to be edited, data = member info changed, ID = member ID number { string query = "UPDATE member_list SET " + col + " = '" + EnCryptDecrypt.CryptorEngine.Encrypt(data, true) + "' WHERE ID_No = " + ID + ";"; if (MainMenu.OpenConnection()) { try { MySqlCommand cmd = new MySqlCommand(query, MainMenu.conn); cmd.ExecuteNonQuery(); } catch (MySqlException ex) { MessageBox.Show(ex.Message); } finally { MainMenu.CloseConnection(); } } }
public static void Insert(string q) { string query = q; if (MainMenu.OpenConnection()) { try { MySqlCommand cmd = new MySqlCommand(query, MainMenu.conn); cmd.ExecuteNonQuery(); } catch (MySqlException ex) { MessageBox.Show(ex.Message); } finally { MainMenu.CloseConnection(); } } }