Esempio n. 1
0
        public void stressFillDataBase()
        {
            stressDS = new StressDataSet();
            rnd      = new Random();

            accountTypeTA = new AccountTypeTableAdapter();
            lineTypeTA    = new LineTypeTableAdapter();
            envGroupTA    = new EnvelopeGroupTableAdapter();
            accountTA     = new AccountTableAdapter();
            envelopeTA    = new EnvelopeTableAdapter();
            lineTA        = new LineItemTableAdapter();
            envLineTA     = new EnvelopeLineTableAdapter();

            // Reset the database
            DBquery.dropTables();
            DBquery.buildTables();

            // Fill the data tables
            accountTypeTA.Fill(stressDS.AccountType);
            lineTypeTA.Fill(stressDS.LineType);
            envGroupTA.Fill(stressDS.EnvelopeGroup);
            accountTA.Fill(stressDS.Account);
            envelopeTA.Fill(stressDS.Envelope);
            lineTA.Fill(stressDS.LineItem);
            envLineTA.Fill(stressDS.EnvelopeLine);

            accountID  = DBquery.getNewID("id", "Account");
            aTypeID    = DBquery.getNewID("id", "AccountType");
            envelopeID = DBquery.getNewID("id", "Envelope");
            eGroupID   = DBquery.getNewID("id", "EnvelopeGroup");
            eLineID    = DBquery.getNewID("id", "EnvelopeLine");
            lTypeID    = DBquery.getNewID("id", "LineType");

            lineID  = DBquery.getNewID("id", "LineItem");
            transID = DBquery.getNewID("transactionID", "LineItem");
            date    = DateTime.Now.AddMonths(-12 * 100).Date;

            addAccount();
            addAccount();
            addAccount();
            addAccount();
            addAccount();
            addAccount();
            addAccount();
            addAccount();
            addAccount();
            addAccount();
            addAccount();
            addAccount();
            addAccount();
            addAccount();
            addAccount();
            addAccount();
            addAccount();
            addAccount();
            addAccount();
            addAccount();
            addAccount();
            addAccount();
            addAccount();
            addAccount();
            addAccount();

            addEnvelope();
            addEnvelope();
            addEnvelope();
            addEnvelope();
            addEnvelope();
            addEnvelope();
            addEnvelope();
            addEnvelope();
            addEnvelope();
            addEnvelope();
            addEnvelope();
            addEnvelope();
            addEnvelope();
            addEnvelope();
            addEnvelope();
            addEnvelope();
            addEnvelope();
            addEnvelope();
            addEnvelope();
            addEnvelope();
            addEnvelope();
            addEnvelope();
            addEnvelope();
            addEnvelope();
            addEnvelope();
            addEnvelope();

            int num;

            // Make alot of entries
            while (date < DateTime.Now.AddMonths(3).Date)
            {
                num = rnd.Next(0, 10000);

                if (num == 0)
                {
                    addAccountType();
                }
                else if (num == 1)
                {
                    addLineType();
                }
                else if (num == 2)
                {
                    addEnvelopeGroup();
                }

                if (10 < num && num < 15)
                {
                    addAccount();
                }

                if (30 < num && num < 34)
                {
                    addEnvelope();
                }


                if (100 < num && num < 200)
                {
                    complexTrans();
                }
                else
                {
                    simpleTrans();
                }
            }

            // Save the data
            accountTypeTA.Update(stressDS.AccountType);
            lineTypeTA.Update(stressDS.LineType);
            envGroupTA.Update(stressDS.EnvelopeGroup);
            accountTA.Update(stressDS.Account);
            envelopeTA.Update(stressDS.Envelope);
            lineTA.Update(stressDS.LineItem);
            envLineTA.Update(stressDS.EnvelopeLine);
        }