public void Populate_ListView(string myquery) { listView1.Items.Clear(); ListViewItem iItem; string query = myquery; if (CreateNewCard.OpenConnection()) { try { MySqlCommand cmd = new MySqlCommand(query, CreateNewCard.conn); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { iItem = new ListViewItem(EncryptDecrypt.DecryptString(dataReader[0].ToString(), CreateNewCard.salt)); listView1.Items.Add(iItem); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { CreateNewCard.CloseConnection(); } listView1.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent); listView1.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize); } }
public void getpin() { string query = "select PIN from card_list where Card_No ='" + CardInsert.encrcardnum + "'"; if (CreateNewCard.OpenConnection()) { try { MySqlCommand cmd = new MySqlCommand(query, CreateNewCard.conn); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { PINCode = EncryptDecrypt.DecryptString(dataReader[0].ToString(), CreateNewCard.salt); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { CreateNewCard.CloseConnection(); } } }
public void Select_Card(string cardnum) { listView1.Items.Clear(); string query = "select Card_No from card_list"; if (CreateNewCard.OpenConnection()) { try { MySqlCommand cmd = new MySqlCommand(query, CreateNewCard.conn); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { if (EncryptDecrypt.DecryptString(dataReader[0].ToString(), CreateNewCard.salt) == cardnum) { CardInsert.encrcardnum = dataReader[0].ToString(); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { CreateNewCard.CloseConnection(); } listView1.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent); listView1.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize); } }
public void Card_Data() { string query = "SELECT Card_No from card_list"; if (CreateNewCard.OpenConnection()) { try { MySqlCommand command = new MySqlCommand(query, CreateNewCard.conn); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Card.Items.Add(EncryptDecrypt.DecryptString(reader[0].ToString(), CreateNewCard.salt)); } } catch (MySqlException ex) { MessageBox.Show(ex.Message); } finally { CreateNewCard.CloseConnection(); } } }
public void Select_account(string cardnum) { string query = "select * from useraccounts"; if (CreateNewCard.OpenConnection()) { try { MySqlCommand cmd = new MySqlCommand(query, CreateNewCard.conn); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { if (EncryptDecrypt.DecryptString(dataReader[0].ToString(), CreateNewCard.salt) == cardnum) { encrusername = dataReader[0].ToString(); username = EncryptDecrypt.DecryptString(dataReader[0].ToString(), CreateNewCard.salt); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { CreateNewCard.CloseConnection(); } } query = "select password,lockdate from useraccounts where username ='******'"; if (CreateNewCard.OpenConnection()) { try { MySqlCommand cmd = new MySqlCommand(query, CreateNewCard.conn); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { password = EncryptDecrypt.DecryptString(dataReader[0].ToString(), CreateNewCard.salt); if (dataReader[1].ToString() != "") { lockdate = DateTime.Parse(EncryptDecrypt.DecryptString(dataReader[1].ToString(), CreateNewCard.salt)); } else { lockdate = DateTime.Now; } } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { CreateNewCard.CloseConnection(); } } }
public void Select_Reward(string rewardname) { string query = "select rewards from rewards"; if (CreateNewCard.OpenConnection()) { try { MySqlCommand cmd = new MySqlCommand(query, CreateNewCard.conn); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { if (EncryptDecrypt.DecryptString(dataReader[0].ToString(), CreateNewCard.salt) == rewardname) { RewardEditor.encrrewardname = dataReader[0].ToString(); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { CreateNewCard.CloseConnection(); } listView1.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent); listView1.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize); } query = "select * from rewards where rewards ='" + RewardEditor.encrrewardname + "'"; if (CreateNewCard.OpenConnection()) { try { MySqlCommand cmd = new MySqlCommand(query, CreateNewCard.conn); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { RewardEditor.rewardname = EncryptDecrypt.DecryptString(dataReader[0].ToString(), CreateNewCard.salt); RewardEditor.pointsrequired = EncryptDecrypt.DecryptString(dataReader[1].ToString(), CreateNewCard.salt); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { CreateNewCard.CloseConnection(); } listView1.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent); listView1.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize); } }
public void CardBlock() { string query = "UPDATE card_list SET BLOCK = '" + EncryptDecrypt.EncryptString("True", CreateNewCard.salt) + "' where Card_No = '" + CardInsert.encrcardnum + "'"; if (CreateNewCard.OpenConnection()) { try { MySqlCommand cmd = new MySqlCommand(query, CreateNewCard.conn); cmd.ExecuteNonQuery(); } catch (MySqlException ex) { MessageBox.Show(ex.Message); } finally { CreateNewCard.CloseConnection(); } } }
public static void createdb(string q) { string query = q; if (CreateNewCard.OpenConnection()) { try { MySqlCommand cmd = new MySqlCommand(query, CreateNewCard.conn); cmd.ExecuteNonQuery(); } catch (MySqlException ex) { MessageBox.Show(ex.Message); } finally { CreateNewCard.CloseConnection(); } } }
public void Populate_ListView(string myquery) { listView1.Items.Clear(); ListViewItem iItem; string query = myquery; if (CreateNewCard.OpenConnection()) { try { MySqlCommand cmd = new MySqlCommand(query, CreateNewCard.conn); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { if (EncryptDecrypt.DecryptString(dataReader[3].ToString(), CreateNewCard.salt) == "True" && DateTime.Compare(DateTime.Now, DateTime.ParseExact("30/" + EncryptDecrypt.DecryptString(dataReader[4].ToString(), CreateNewCard .salt), "dd/MM/yy", System.Globalization.CultureInfo.InvariantCulture)) <= 0) { iItem = new ListViewItem(EncryptDecrypt.DecryptString(dataReader[0].ToString(), CreateNewCard.salt)); fullname = EncryptDecrypt.DecryptString(dataReader[1].ToString(), CreateNewCard.salt) + " " + EncryptDecrypt.DecryptString(dataReader[2].ToString(), CreateNewCard.salt); expiry = EncryptDecrypt.DecryptString(dataReader[4].ToString(), CreateNewCard.salt); iItem.SubItems.Add(fullname); iItem.SubItems.Add(expiry); listView1.Items.Add(iItem); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { CreateNewCard.CloseConnection(); } listView1.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent); listView1.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize); } }
public void checkdb(string ID, string check) { string query = "show databases like '" + ID + "';"; MySqlCommand command; if (CreateNewCard.OpenConnection()) { try { command = new MySqlCommand(query, CreateNewCard.conn); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { if (check == reader[0].ToString()) { if (check == "alaybank") { alaybank = true; } if (check == "alaybank_cards") { alaycards = true; } } } } catch (MySqlException ex) { MessageBox.Show(ex.Message); } finally { CreateNewCard.CloseConnection(); } } }