Exemplo n.º 1
0
        private void update_Click(object sender, RoutedEventArgs e)
        {
            iduser idus = new iduser();
            int    ID   = idus.getiduser();
            String id   = Convert.ToString(ID);
            DB     db   = new DB();

            MySqlCommand command = new MySqlCommand("SELECT `balance` FROM `users` WHERE `id` = @ID", db.GetConnection());

            command.Parameters.Add("@ID", MySqlDbType.VarChar).Value = id;

            db.openConnection();
            string balance = command.ExecuteScalar().ToString();

            balanceuser.Text = balance;
            db.closeConnection();
        }
Exemplo n.º 2
0
        private void Button_Click_11(object sender, RoutedEventArgs e)
        {
            int    cash = Convert.ToInt32(cashuser.Text);
            DB     db   = new DB();
            iduser idus = new iduser();
            int    ID   = idus.getiduser();
            String id   = Convert.ToString(ID);

            MySqlCommand command = new MySqlCommand("SELECT `balance` FROM `users` WHERE `id` = @ID", db.GetConnection());

            command.Parameters.Add("@ID", MySqlDbType.VarChar).Value = id;
            db.openConnection();
            string balanc_user = command.ExecuteScalar().ToString();
            int    cash_user   = Convert.ToInt32(balanc_user);
            Menu   menu        = new Menu();

            if (cash <= cash_user)
            {
                cash_user = cash_user - cash;
                MySqlCommand command_2 = new MySqlCommand("UPDATE `users` SET `balance` = @balance WHERE  `id` = @ID", db.GetConnection());
                command_2.Parameters.Add("@ID", MySqlDbType.VarChar).Value = id;
                command_2.Parameters.AddWithValue("balance", cash_user);
                command_2.ExecuteNonQueryAsync();
                db.closeConnection();
                MessageBox.Show("Операція здійснена успішно!");

                MySqlCommand command_3 = new MySqlCommand("SELECT * FROM `balance`", db.GetConnection());
                db.openConnection();
                string       balanc_bankomat = command_3.ExecuteScalar().ToString();
                MySqlCommand command_4       = new MySqlCommand("UPDATE `balance` SET `balance` = @balance", db.GetConnection());
                int          cash_bankomat   = Convert.ToInt32(balanc_bankomat);
                cash_bankomat = cash_bankomat - cash;
                command_4.Parameters.AddWithValue("balance", cash_bankomat);
                command_4.ExecuteNonQueryAsync();
                db.closeConnection();
                this.Close();
                menu.Show();
            }
            else
            {
                MessageBox.Show("Недостатньо коштів!");
                this.Close();
                menu.Show();
            }
        }
Exemplo n.º 3
0
        public void Button_Click_11(object sender, RoutedEventArgs e)
        {
            String NumberUser = numberuser.Text;
            String PinUser    = pinuser.Password;

            DB        db    = new DB();
            DataTable table = new DataTable();



            MySqlDataAdapter adapter = new MySqlDataAdapter();

            MySqlCommand command = new MySqlCommand("SELECT `id` FROM `users` WHERE `number` = @UN AND `pin` = @UP", db.GetConnection());

            command.Parameters.Add("@UN", MySqlDbType.VarChar).Value = NumberUser;
            command.Parameters.Add("@UP", MySqlDbType.Int64).Value   = PinUser;


            adapter.SelectCommand = command;
            adapter.Fill(table);


            if (table.Rows.Count > 0)
            {
                db.openConnection();
                string update = command.ExecuteScalar().ToString();
                int    iduser = Convert.ToInt32(update);
                iduser idus   = new iduser();
                idus.setiduser(iduser);
                db.closeConnection();
                MessageBox.Show("Успішний вхід!", "Повідомлення");
                Menu Menu = new Menu();
                this.Close();
                Menu.Show();
            }
            else
            {
                MessageBox.Show("Не правильний номер картки або ПІН-код!", "Повідомлення");
                pinuser.Password = "";
                numberuser.Text  = "";
            }
        }