Exemple #1
0
        private void bgwBuyVariant_DoWork(object sender, DoWorkEventArgs e)
        {
            string[] args         = (string[])e.Argument;
            string   fullFileName = args[0];
            string   saveDir      = args[1];

            try
            {
                //Decreasing Credit
                string       sql = "UPDATE phpap_AKusers SET money = @DeductedCash WHERE Username=@User";
                MySqlCommand cmd = new MySqlCommand(sql, Program.AKsqlcon);

                MySqlParameter DeductedCashP = new MySqlParameter();
                DeductedCashP.ParameterName = "@DeductedCash";
                DeductedCashP.Value         = cash - variantCost;
                cmd.Parameters.Add(DeductedCashP);

                MySqlParameter EmailP = new MySqlParameter();
                EmailP.ParameterName = "@User";
                EmailP.Value         = Program.username;
                cmd.Parameters.Add(EmailP);

                cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                if (ex != null)
                {
                    OnBuyLog update = new OnBuyLog(Log.Info);
                    update.Invoke(ex.Message);
                    return;
                }
            }

            cash -= variantCost;

            string finalFilePath = string.Format("{0}\\{1}", saveDir, fullFileName);

            File.Create(finalFilePath).Close();

            StreamWriter sw = new StreamWriter(finalFilePath);

            sw.Write(variant.DumpToString());
            sw.Close();
        }
        private void bgwBuyVariant_DoWork(object sender, DoWorkEventArgs e)
        {
            string[] args = (string[])e.Argument;
            string fullFileName = args[0];
            string saveDir = args[1];

            try
            {
                //Decreasing Credit
                string sql = "UPDATE phpap_AKusers SET money = @DeductedCash WHERE Username=@User";
                MySqlCommand cmd = new MySqlCommand(sql, Program.AKsqlcon);

                MySqlParameter DeductedCashP = new MySqlParameter();
                DeductedCashP.ParameterName = "@DeductedCash";
                DeductedCashP.Value = cash - variantCost;
                cmd.Parameters.Add(DeductedCashP);

                MySqlParameter EmailP = new MySqlParameter();
                EmailP.ParameterName = "@User";
                EmailP.Value = Program.username;
                cmd.Parameters.Add(EmailP);

                cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                if (ex != null)
                {
                    OnBuyLog update = new OnBuyLog(Log.Info);
                    update.Invoke(ex.Message);
                    return;
                }
            }

            cash -= variantCost;

            string finalFilePath = string.Format("{0}\\{1}", saveDir, fullFileName);
            File.Create(finalFilePath).Close();

            StreamWriter sw = new StreamWriter(finalFilePath);
            sw.Write(variant.DumpToString());
            sw.Close();
        }