public void Numeric_Item(int Item_No) { string query = "select quantity,image from item_list where item_no = " + Item_No + ";"; if (LogIn.OpenConnection()) { try { MySqlCommand cmd = new MySqlCommand(query, LogIn.conn); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { numericUpDown1.Maximum = Convert.ToInt32(AES.AES_Encryption.DecryptString(dataReader[0].ToString(), LogIn.strpass)); pic_add = decode(dataReader[1].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { LogIn.CloseConnection(); } } }
public void LII(int ID) // LII = Load Item Info { string query = "Select * from item_list where item_no = " + ID + ""; if (LogIn.OpenConnection()) { try { MySqlCommand command = new MySqlCommand(query, LogIn.conn); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { edit_Item1.item_number = Convert.ToInt32(reader.GetString("item_no")); edit_Item1.item_name.Text = AES.AES_Encryption.DecryptString(reader.GetString("item_name"), LogIn.strpass); edit_Item1.item_description.Text = AES.AES_Encryption.DecryptString(reader.GetString("description"), LogIn.strpass); edit_Item1.item_quantity.Value = Convert.ToInt32(AES.AES_Encryption.DecryptString(reader.GetString("quantity"), LogIn.strpass)); Image dump = edit_Item1.item_pic.BackgroundImage; if (dump != null) { dump.Dispose(); } edit_Item1.item_pic.BackgroundImage = Image.FromFile(AES.AES_Encryption.DecryptString(reader.GetString("image"), LogIn.strpass)); edit_Item1.item_pic.BackgroundImageLayout = ImageLayout.Stretch; } } catch (MySqlException ex) { MessageBox.Show(ex.Message); } finally { LogIn.CloseConnection(); } } }
public void Populate_ListView(string myquery) { listView1.Items.Clear(); ListViewItem iItem; string query = myquery; if (LogIn.OpenConnection()) { try { MySqlCommand cmd = new MySqlCommand(query, LogIn.conn); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { iItem = new ListViewItem(dataReader[0].ToString()); iItem.SubItems.Add(decode(dataReader[1].ToString())); iItem.SubItems.Add(decode(dataReader[2].ToString())); iItem.SubItems.Add(decode(dataReader[3].ToString())); listView1.Items.Add(iItem); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { LogIn.CloseConnection(); } listView1.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent); listView1.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize); } }
public void Get_Queue_No() { string query = "Select count(*) from borrow_list;"; if (LogIn.OpenConnection()) { try { MySqlCommand cmd = new MySqlCommand(query, LogIn.conn); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { cpEControl1.queue_no = Convert.ToInt32(dataReader[0].ToString()) + 1; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { LogIn.CloseConnection(); } } }
public void getBorrow(string queue) { string query = "select stud_no from borrow_list where queue = " + queue + ";"; if (LogIn.OpenConnection()) { try { MySqlCommand cmd = new MySqlCommand(query, LogIn.conn); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { stud_no = AES.AES_Encryption.DecryptString(dataReader[0].ToString(), LogIn.strpass); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { LogIn.CloseConnection(); } } }
public void Populate_ListView() { listView1.Items.Clear(); ListViewItem iItem; string query = "select queue, room, date from borrow_list where returned = 'Q/H7q5zh6RijRaImEg3zjg==';"; if (LogIn.OpenConnection()) { try { MySqlCommand cmd = new MySqlCommand(query, LogIn.conn); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { iItem = new ListViewItem(dataReader[0].ToString()); iItem.SubItems.Add(decode(dataReader[1].ToString())); iItem.SubItems.Add(decode(dataReader[2].ToString())); listView1.Items.Add(iItem); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { LogIn.CloseConnection(); } listView1.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent); listView1.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize); } }
public void getQuantity(string item) { string query = "SELECT quantity FROM item_list where item_no = " + item + ";"; if (LogIn.OpenConnection()) { try { MySqlCommand command = new MySqlCommand(query, LogIn.conn); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { current_quantity = Convert.ToInt32(AES.AES_Encryption.DecryptString(reader[0].ToString(), LogIn.strpass)); } } catch (MySqlException ex) { MessageBox.Show(ex.Message); } finally { LogIn.CloseConnection(); } } }
public void Load_Items(int table) { listView2.Items.Clear(); ListViewItem iItem; string query = "SELECT * FROM `" + table + "`"; if (LogIn.OpenConnection()) { try { MySqlCommand cmd = new MySqlCommand(query, LogIn.conn); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { iItem = new ListViewItem(dataReader.GetString("item_no")); iItem.SubItems.Add(dataReader.GetString("item_name")); iItem.SubItems.Add(dataReader.GetString("quantity")); listView2.Items.Add(iItem); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { LogIn.CloseConnection(); } listView2.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent); listView2.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize); } }
public void Populate_ListView(string myquery) { queue_listView.Items.Clear(); item_listView.Items.Clear(); defect_listView.Items.Clear(); ListViewItem iItem; string query = myquery; if (LogIn.OpenConnection()) { try { MySqlCommand cmd = new MySqlCommand(query, LogIn.conn); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { if (item_all_items.Checked) { iItem = new ListViewItem(dataReader[0].ToString()); iItem.SubItems.Add(AES.AES_Encryption.DecryptString(dataReader[1].ToString(), LogIn.strpass)); iItem.SubItems.Add(AES.AES_Encryption.DecryptString(dataReader[2].ToString(), LogIn.strpass)); iItem.SubItems.Add(AES.AES_Encryption.DecryptString(dataReader[3].ToString(), LogIn.strpass)); item_listView.Items.Add(iItem); } else if (queue_returned.Checked) { iItem = new ListViewItem(dataReader[0].ToString(), LogIn.strpass); iItem.SubItems.Add(AES.AES_Encryption.DecryptString(dataReader[1].ToString(), LogIn.strpass)); iItem.SubItems.Add(AES.AES_Encryption.DecryptString(dataReader[2].ToString(), LogIn.strpass)); iItem.SubItems.Add(AES.AES_Encryption.DecryptString(dataReader[3].ToString(), LogIn.strpass)); iItem.SubItems.Add(AES.AES_Encryption.DecryptString(dataReader[4].ToString(), LogIn.strpass)); queue_listView.Items.Add(iItem); } else if (queue_not_returned.Checked) { iItem = new ListViewItem(dataReader[0].ToString(), LogIn.strpass); iItem.SubItems.Add(AES.AES_Encryption.DecryptString(dataReader[1].ToString(), LogIn.strpass)); iItem.SubItems.Add(AES.AES_Encryption.DecryptString(dataReader[2].ToString(), LogIn.strpass)); iItem.SubItems.Add(AES.AES_Encryption.DecryptString(dataReader[3].ToString(), LogIn.strpass)); iItem.SubItems.Add(AES.AES_Encryption.DecryptString(dataReader[4].ToString(), LogIn.strpass)); queue_listView.Items.Add(iItem); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { LogIn.CloseConnection(); } } }
private void registerbtn_Click(object sender, EventArgs e) { if ((string.IsNullOrEmpty(usertxt.Text)) || (string.IsNullOrEmpty(passtxt.Text)) || (string.IsNullOrEmpty(conpasstxt.Text)) || (string.IsNullOrEmpty(idnummask.Text)) || (string.IsNullOrEmpty(acctcmb.Text))) { MessageBox.Show("Kindly Complete the Information", "Incomplete"); } else { if (MessageBox.Show("Confirm Registration?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { if ((passtxt.Text.Length >= 8) && (conpasstxt.Text.Length >= 8)) { if (passtxt.Text == conpasstxt.Text) { en_username = AES.AES_Encryption.EncryptString(usertxt.Text, strpass); en_password = AES.AES_Encryption.EncryptString(passtxt.Text, strpass); en_idnum = AES.AES_Encryption.EncryptString(idnummask.Text, strpass); en_accttype = AES.AES_Encryption.EncryptString(acctcmb.Text, strpass); string query = "INSERT INTO users (username, password, id_num, user_type) VALUES ('" + en_username + "', '" + en_password + "', '" + en_idnum + "', '" + en_accttype + "')"; if (LogIn.OpenConnection()) { try { MySqlCommand cmd = new MySqlCommand(query, LogIn.conn); cmd.ExecuteNonQuery(); MessageBox.Show("You're Registered"); Form login = new LogIn(); login.Show(); this.Hide(); usertxt.Text = null; passtxt.Text = null; idnummask.Text = null; acctcmb.Text = null; } catch (MySqlException ex) { MessageBox.Show(ex.Message); } finally { LogIn.CloseConnection(); } } } else { MessageBox.Show("Password Confirmation didn't Match", "Password Unmatched"); conpasstxt.Text = ""; } } else { MessageBox.Show("Password Length must be at least 8 characters.", "Password Length Error"); } } else { } } }