コード例 #1
0
ファイル: AdminLogin.cs プロジェクト: TeaRX27/Alay-Bank
 private void button1_Click(object sender, EventArgs e)
 {
     Select_account(textBox1.Text);
     if (username == textBox1.Text && password == textBox2.Text)
     {
         if (DateTime.Compare(DateTime.Now, lockdate) >= 0)
         {
             CreateNewCard.Insert("update useraccounts set lockdate ='" + EncryptDecrypt.EncryptString(DateTime.Now.ToString("MM/dd/yy"), CreateNewCard.salt) + "' where username = '******'");
             Form admin = new AdminMenu();
             admin.Show();
             this.Close();
         }
         else
         {
             MessageBox.Show("Account Is Locked please wait till " + lockdate + " or Contact a System Administrator to Unlock you Account", "Account Locked");
         }
     }
     else
     {
         if (tries == 0)
         {
             MessageBox.Show("Your Tries Have Exceeded Allowed Tries\nYour Account is Temporarily Locked till " + DateTime.Now.AddDays(7).ToString("MM/dd/yy"), "Account Locked", MessageBoxButtons.OK, MessageBoxIcon.Error);
             CreateNewCard.Insert("update useraccounts set lockdate ='" + EncryptDecrypt.EncryptString(DateTime.Now.AddDays(7).ToString("MM/dd/yy"), CreateNewCard.salt) + "' where username = '******'");
         }
         else
         {
             MessageBox.Show("Your Password is Incorrect!\nYou Have " + tries + " Left", "Password Incorrect", MessageBoxButtons.OK, MessageBoxIcon.Warning);
             tries--;
             textBox1.Clear();
             textBox2.Clear();
         }
     }
 }
コード例 #2
0
        private void newcard_Click(object sender, EventArgs e)
        {
            Form newcard = new CreateNewCard();

            newcard.Show();
            Hide();
        }
コード例 #3
0
ファイル: Card Logs.cs プロジェクト: TeaRX27/Alay-Bank
        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();
                }
            }
        }
コード例 #4
0
ファイル: Deposit.cs プロジェクト: TeaRX27/Alay-Bank
 private void button1_Click(object sender, EventArgs e)
 {
     if ((maskedTextBox1.Text != "" || maskedTextBox1.Text != "0") && cardnum != "" && Int32.Parse(maskedTextBox1.Text) >= 100)
     {
         MessageBox.Show("asdf" + balance + "asdf");
         int newbalance = (Int32.Parse(balance) + Int32.Parse(maskedTextBox1.Text));
         CreateNewCard.Insert("Update card_list set balance = '" + EncryptDecrypt.EncryptString(newbalance.ToString(), CreateNewCard.salt) + "' where Card_No = '" + encrcardnum + "'");
         CreateNewCard.Initialize("server=localhost;uid=root;pwd=;database=alaybank_cards;sslmode=none;");
         CreateNewCard.Insert("Insert into alay" + cardnum + " (`trans_id`, `trans_details`) VALUES (NULL ,'" + EncryptDecrypt.EncryptString("Deposit on " + DateTime.Now, CreateNewCard.salt) + "');");
         MessageBox.Show("Balance Successfuly Updated");
         maskedTextBox1.Clear();
         cardnum     = "";
         label1.Text = "Deposit To: ";
         encrcardnum = "";
     }
     else
     {
         string error = "";
         if (maskedTextBox1.Text == "" || maskedTextBox1.Text == "0")
         {
             error += "Deposit Amount must be greater than 0\n";
         }
         if (Int32.Parse(maskedTextBox1.Text) < 100)
         {
             error += "Amount Must be 100 Pesos or Greater";
         }
         if (cardnum == "")
         {
             error += "No Card Selected";
         }
         MessageBox.Show(error, "Deposit Cannot Be Processed");
     }
 }
コード例 #5
0
 private void button1_Click(object sender, EventArgs e)
 {
     if (buttonmode == "Add")
     {
         if (textBox1.Text != "" && maskedTextBox1.Text != "" && maskedTextBox1.Text != "0")
         {
             CreateNewCard.Insert("Insert into rewards  (`Rewards`, `Points`) VALUES ('" + EncryptDecrypt.EncryptString(textBox1.Text, CreateNewCard.salt) + "','" + EncryptDecrypt.EncryptString(maskedTextBox1.Text, CreateNewCard.salt) + "');");
             MessageBox.Show("Reward Successfully Added");
         }
         else
         {
             string error = "";
             if (textBox1.Text == "")
             {
                 error += "Reward Name must not be Empty\n";
             }
             if (maskedTextBox1.Text == "")
             {
                 error += "Rewards Cost must not be Empty\n";
             }
             if (maskedTextBox1.Text == "0")
             {
                 error += "Rewards Cost must not be Zero";
             }
         }
     }
     else if (buttonmode == "Edit")
     {
         CreateNewCard.Insert("Update rewards set rewards = '" + EncryptDecrypt.EncryptString(textBox1.Text, CreateNewCard.salt) + "', points = '" + EncryptDecrypt.EncryptString(maskedTextBox1.Text, CreateNewCard.salt) + "' where rewards = '" + encrrewardname + "'");
         MessageBox.Show("Reward Successfully Editted");
     }
     Close();
 }
コード例 #6
0
        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();
                }
            }
        }
コード例 #7
0
ファイル: Deposit.cs プロジェクト: TeaRX27/Alay-Bank
        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);
            }
        }
コード例 #8
0
ファイル: Renew.cs プロジェクト: TeaRX27/Alay-Bank
        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);
            }
        }
コード例 #9
0
ファイル: AdminLogin.cs プロジェクト: TeaRX27/Alay-Bank
        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();
                }
            }
        }
コード例 #10
0
 private void button1_Click(object sender, EventArgs e)
 {
     foreach (ListViewItem item in listView1.SelectedItems)
     {
         Select_Reward(item.SubItems[0].Text);
     }
     CreateNewCard.Insert("Delete from rewards where rewards = '" + RewardEditor.encrrewardname + "'");
     Populate_ListView("select * from rewards");
     RewardEditor.encrrewardname = "";
 }
コード例 #11
0
        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);
            }
        }
コード例 #12
0
ファイル: Renew.cs プロジェクト: TeaRX27/Alay-Bank
 private void button2_Click(object sender, EventArgs e)
 {
     if (cardnum != "")
     {
         CreateNewCard.Insert("Update card_list set expiry = '" + EncryptDecrypt.EncryptString(DateTime.Now.AddYears(3).ToString("MM/yy"), CreateNewCard.salt) + "' where Card_No = '" + CardInsert.encrcardnum + "'");
         MessageBox.Show("Card Successfully Renewed!");
         Populate_ListView("select Card_No, FN,LN,Expiry from card_list");
         cardnum = "";
         CardInsert.encrcardnum = "";
         label1.Text            = "Expired Card Selected: ";
     }
     else
     {
         MessageBox.Show("No Card Selected", "Renew Failed!");
     }
 }
コード例 #13
0
 private void button1_Click(object sender, EventArgs e)
 {
     if (cardnum != "")
     {
         CreateNewCard.Insert("Update card_list set block = '" + EncryptDecrypt.EncryptString("True", CreateNewCard.salt) + "' where Card_No = '" + CardInsert.encrcardnum + "'");
         MessageBox.Show("Card Successfully Blocked!");
         Populate_ListView("select Card_No, FN,LN,Block,Expiry from card_list");
         cardnum = "";
         CardInsert.encrcardnum = "";
         label1.Text            = "Card to be Blocked: ";
     }
     else
     {
         MessageBox.Show("Cannot Block Card!\nNo Card Selected", "Card Block Failed");
     }
 }
コード例 #14
0
 private void buttonOK_Click(object sender, EventArgs e)
 {
     CreateNewCard.Insert("Update card_list set PIN = '" + EncryptDecrypt.EncryptString(textBox1.Text, CreateNewCard.salt) + "' where Card_No = '" + CardInsert.encrcardnum + "'");
     MessageBox.Show("PIN sucessfully changed!");
     if (MessageBox.Show("Do you want another Transaction?", "Another Transaction", MessageBoxButtons.YesNo) == DialogResult.Yes)
     {
         Form mm = new Menu();
         mm.Show();
         this.Close();
     }
     else
     {
         MessageBox.Show("Thank You for Using Alay Bank ATM");
         Form splash = new Splash_Screen();
         splash.Show();
         this.Close();
     }
 }
コード例 #15
0
ファイル: BlockChangepin.cs プロジェクト: TeaRX27/Alay-Bank
 private void button1_Click(object sender, EventArgs e)
 {
     if (cardnum != "")
     {
         newpin = build();
         CreateNewCard.Insert("Update card_list set pin = '" + EncryptDecrypt.EncryptString(newpin, CreateNewCard.salt) + "' where Card_No = '" + CardInsert.encrcardnum + "'");
         CreateNewCard.Insert("Update card_list set block = '" + EncryptDecrypt.EncryptString("False", CreateNewCard.salt) + "' where Card_No = '" + CardInsert.encrcardnum + "'");
         MessageBox.Show("New PIN Generated!\n The New Pin is " + newpin);
         label1.Text = "Selected Card: ";
         Populate_ListView("select Card_No,FN,LN,Block,Expiry from card_list where Card_No != '" + CardInsert.encrcardnum + "'");
         cardnum = "";
         CardInsert.encrcardnum = "";
     }
     else
     {
         MessageBox.Show("Cannot Change PIN!\nNo Card Selected", "Change PIN Failed");
     }
 }
コード例 #16
0
 private void button1_Click(object sender, EventArgs e)
 {
     if (Int32.Parse(maskedTextBox1.Text) > Int32.Parse(balance))
     {
         MessageBox.Show("Insuffient Balance\n Please Try Again");
         Application.Restart();
     }
     else
     {
         if (Int32.Parse(maskedTextBox1.Text) >= 100)
         {
             string newbalance = (Int32.Parse(balance) - Int32.Parse(maskedTextBox1.Text)).ToString();
             CreateNewCard.Insert("Update card_list set balance = '" + EncryptDecrypt.EncryptString(newbalance, CreateNewCard.salt) + "' where Card_No = '" + CardInsert.encrcardnum + "'");
             CreateNewCard.Initialize("server=localhost;uid=root;pwd=;database=alaybank_cards;sslmode=none;");
             CreateNewCard.Insert("Insert into alay" + CardInsert.cardnum + " (`trans_id`, `trans_details`) VALUES (NULL ,'" + EncryptDecrypt.EncryptString("Withdrew on " + DateTime.Now, CreateNewCard.salt) + "');");
             if (MessageBox.Show("Do you want another Transaction?", "Another Transaction", MessageBoxButtons.YesNo) == DialogResult.Yes)
             {
                 Form mm = new Menu();
                 mm.Show();
                 this.Close();
             }
             else
             {
                 CreateNewCard.Initialize();
                 CreateNewCard.Insert("Insert Into transrec values ('" + CardInsert.cardnum + "','" + newbalance + "')");
                 Form print = new Recieptprint();
                 Recieptprint.source = "cash";
                 print.ShowDialog();
                 MessageBox.Show("Thank You for Using Alay Bank ATM");
                 Form splash = new Splash_Screen();
                 splash.Show();
                 this.Close();
             }
         }
         else
         {
             MessageBox.Show("Withdrawn Amount must be 100 Pesos or greater", "Withdraw Failed");
             Form splashscreen = new Splash_Screen();
             splashscreen.Show();
             this.Hide();
         }
     }
 }
コード例 #17
0
 private void Splash_Screen_Load(object sender, EventArgs e)
 {
     checkdb("alaybank", "alaybank");
     if (!alaybank)
     {
         createdb("create database alaybank");
         CreateNewCard.Initialize();
         createdb("create table card_list (Card_No varchar(255) , PIN varchar(255) , FN varchar(255) , MI varchar(255) , LN varchar(255) , Balance varchar(255) , Points varchar(255) , Block varchar(255) , primary key(Card_No))");
     }
     checkdb("alaybank_cards", "alaybank_cards");
     if (!alaycards)
     {
         createdb("create database alaybank_cards");
     }
     timer1.Enabled = true;
     code           = "";
     CreateNewCard.Initialize();
     CreateNewCard.Insert("Delete from rewardprint");
     CreateNewCard.Insert("Delete from transrec");
 }
コード例 #18
0
ファイル: ClaimRewards.cs プロジェクト: TeaRX27/Alay-Bank
        private void button1_Click(object sender, EventArgs e)
        {
            foreach (ListViewItem item in listView1.SelectedItems)
            {
                if (Int32.Parse(Balance_Inquiry.balance) >= Int32.Parse(item.SubItems[1].Text))
                {
                    int newbal = Int32.Parse(Balance_Inquiry.balance) - Int32.Parse(item.SubItems[1].Text);
                    CreateNewCard.Insert("Update card_list set points = '" + EncryptDecrypt.EncryptString(newbal.ToString(), CreateNewCard.salt) + "' where Card_No = '" + CardInsert.encrcardnum + "'");
                    CreateNewCard.Initialize("server=localhost;uid=root;pwd=;database=alaybank_cards;sslmode=none;");
                    CreateNewCard.Insert("Insert into alay" + CardInsert.cardnum + " (`trans_id`, `trans_details`) VALUES (NULL ,'" + EncryptDecrypt.EncryptString("Claimed Reward on " + DateTime.Now, CreateNewCard.salt) + "');");
                    MessageBox.Show("Balance Successfuly Updated\n Thank You for Using Alay Bank ATM System");
                    CreateNewCard.Initialize();
                    CreateNewCard.Insert("insert into rewardprint values('" + item.SubItems[0].Text + "','" + BlockChangepin.build() + "')");
                    Form print = new Recieptprint();
                    Recieptprint.source = "reward";
                    print.ShowDialog();
                    if (MessageBox.Show("Do you want another Transaction?", "Another Transaction", MessageBoxButtons.YesNo) == DialogResult.Yes)
                    {
                        Form mm = new Menu();
                        mm.Show();
                        this.Close();
                    }
                    else
                    {
                        CreateNewCard.Insert("Insert Into transrec values ('" + CardInsert.cardnum + "','" + newbal + " Points')");
                        MessageBox.Show("Thank You for Using Alay Bank ATM");
                        Form splash = new Splash_Screen();
                        splash.Show();
                        this.Close();
                    }
                }
                else
                {
                    MessageBox.Show("Transaction cannot be processed!\n Insufficient Reward Points\n Thank you for using Alay Bank ATM");
                }
            }
            Form splashscreen = new Splash_Screen();

            splashscreen.Show();
            this.Hide();
        }
コード例 #19
0
        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();
                }
            }
        }
コード例 #20
0
ファイル: Balance Inquiry.cs プロジェクト: TeaRX27/Alay-Bank
 private void button1_Click(object sender, EventArgs e)
 {
     if (MessageBox.Show("Do you want another Transaction?", "Another Transaction", MessageBoxButtons.YesNo) == DialogResult.Yes)
     {
         Form mm = new Menu();
         mm.Show();
         this.Close();
     }
     else
     {
         CreateNewCard.Initialize();
         CreateNewCard.Insert("Insert Into transrec values ('" + CardInsert.cardnum + "','" + balance + "')");
         Form print = new Recieptprint();
         Recieptprint.source = "cash";
         print.ShowDialog();
         MessageBox.Show("Thank You for Using Alay Bank ATM");
         Form splash = new Splash_Screen();
         splash.Show();
         this.Close();
     }
 }
コード例 #21
0
        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();
                }
            }
        }
コード例 #22
0
ファイル: Paybills.cs プロジェクト: TeaRX27/Alay-Bank
        private void button2_Click(object sender, EventArgs e)
        {
            if (Int32.Parse(Balance_Inquiry.balance) >= Int32.Parse(Amount.Text))
            {
                int rbalance;
                rbalance = Int32.Parse(Balance_Inquiry.balance) - Int32.Parse(Amount.Text);
                if (Int32.Parse(Amount.Text) >= 1000)
                {
                    int rewardpoint = Int32.Parse(Amount.Text) / 1000;
                    int newpoints   = Int32.Parse(Balance_Inquiry.points) + rewardpoint;
                    CreateNewCard.Insert("Update card_list set ponts = '" + EncryptDecrypt.EncryptString(newpoints.ToString(), CreateNewCard.salt) + "' where Card_No = '" + CardInsert.encrcardnum + "'");
                }
                CreateNewCard.Insert("Update card_list set balance = '" + EncryptDecrypt.EncryptString(rbalance.ToString(), CreateNewCard.salt) + "' where Card_No = '" + CardInsert.encrcardnum + "'");

                CreateNewCard.Initialize("server=localhost;uid=root;pwd=;database=alaybank_cards;sslmode=none;");
                CreateNewCard.Insert("Insert into alay" + CardInsert.cardnum + " (`trans_id`, `trans_details`) VALUES (NULL ,'" + EncryptDecrypt.EncryptString("Paid bill on " + DateTime.Now, CreateNewCard.salt) + "');");
                if (MessageBox.Show("Do you want another Transaction?", "Another Transaction", MessageBoxButtons.YesNo) == DialogResult.Yes)
                {
                    Form mm = new Menu();
                    mm.Show();
                    this.Close();
                }
                else
                {
                    CreateNewCard.Initialize();
                    CreateNewCard.Insert("Insert Into transrec values ('" + CardInsert.cardnum + "','" + rbalance + "')");
                    Form print = new Recieptprint();
                    Recieptprint.source = "cash";
                    print.ShowDialog();
                    MessageBox.Show("Thank You for Using Alay Bank ATM");
                    Form splash = new Splash_Screen();
                    splash.Show();
                    this.Close();
                }
            }
            else
            {
                MessageBox.Show("Transaction cannot be processed!\n Insufficient Balance\n Thank you for using Alay Bank ATM");
            }
        }
コード例 #23
0
ファイル: BlockChangepin.cs プロジェクト: TeaRX27/Alay-Bank
        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);
            }
        }
コード例 #24
0
        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();
                }
            }
        }
コード例 #25
0
 public CardInsert()
 {
     InitializeComponent();
     CreateNewCard.Initialize();
 }
コード例 #26
0
ファイル: Deposit.cs プロジェクト: TeaRX27/Alay-Bank
 public Deposit()
 {
     InitializeComponent();
     CreateNewCard.Initialize();
 }
コード例 #27
0
 public PIN()
 {
     InitializeComponent();
     CreateNewCard.Initialize();
 }
コード例 #28
0
ファイル: Renew.cs プロジェクト: TeaRX27/Alay-Bank
 public Renew()
 {
     InitializeComponent();
     CreateNewCard.Initialize();
 }
コード例 #29
0
 public RewardEditor()
 {
     InitializeComponent();
     CreateNewCard.Initialize();
 }
コード例 #30
0
 public ChangePin()
 {
     InitializeComponent();
     CreateNewCard.Initialize();
 }