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();
}
}
}
