///////////////////////////////////////////////////////////////////////
// Function Overrides
///////////////////////////////////////////////////////////////////////
public override void EndInit()
{
base.EndInit();
this.TableNewRow += new DataTableNewRowEventHandler(LineTypeDataTable_TableNewRow);
this.ColumnChanged += new DataColumnChangeEventHandler(LineTypeDataTable_ColumnChanged);
this.LTTableAdapter = new LineTypeTableAdapter();
this.LTTableAdapter.ClearBeforeFill = true;
this.newID = 1;
this.stayOut = false;
}
/////////////////////////
// Functions Public
public void myInit()
{
this.currentTransID = -1;
this.AccountTA = new AccountTableAdapter();
this.AccountTA.ClearBeforeFill = true;
this.EnvelopeTA = new EnvelopeTableAdapter();
this.EnvelopeTA.ClearBeforeFill = true;
this.LineTypeTA = new LineTypeTableAdapter();
this.LineTypeTA.ClearBeforeFill = true;
// Setup for traching changes
this.Changes = new List <AEPair>();
}
public void myInit()
{
// Initialize Table Adapters
this.accountTypeTA = new AccountTypeTableAdapter();
this.accountTA = new AccountTableAdapter();
this.envelopeTA = new EnvelopeTableAdapter();
this.lineTypeTA = new LineTypeTableAdapter();
this.lineItemTA = new LineItemTableAdapter();
this.eLineTA = new EnvelopeLineTableAdapter();
// Initialize Maps
this.accountMap = new Dictionary <string, int>();
this.envelopeMap = new Dictionary <string, int>();
// Fillup certain tables (Tables that can allow overlap of imported data)
this.accountTypeTA.Fill(this.AccountType);
this.lineTypeTA.Fill(this.LineType);
// Setup ID Counters
this.AccountID = DBquery.getNewID("id", "Account");
this.AccountTypeID = DBquery.getNewID("id", "AccountType");
this.EnvelopeID = DBquery.getNewID("id", "Envelope");
this.LineTypeID = DBquery.getNewID("id", "LineType");
this.LineItemID = DBquery.getNewID("id", "LineItem");
this.TransactionID = DBquery.getNewID("transactionID", "LineItem");
this.EnvelopeLineID = DBquery.getNewID("id", "EnvelopeLine");
// Subscribe to table events
this.Account.TableNewRow += new System.Data.DataTableNewRowEventHandler(Account_TableNewRow);
this.Account.ColumnChanging += new System.Data.DataColumnChangeEventHandler(ColumnChanging);
this.AccountType.TableNewRow += new System.Data.DataTableNewRowEventHandler(AccountType_TableNewRow);
this.AccountType.ColumnChanging += new System.Data.DataColumnChangeEventHandler(ColumnChanging);
this.Envelope.TableNewRow += new System.Data.DataTableNewRowEventHandler(Envelope_TableNewRow);
this.Envelope.ColumnChanging += new System.Data.DataColumnChangeEventHandler(ColumnChanging);
this.EnvelopeLine.TableNewRow += new System.Data.DataTableNewRowEventHandler(EnvelopeLine_TableNewRow);
this.EnvelopeLine.ColumnChanging += new System.Data.DataColumnChangeEventHandler(ColumnChanging);
this.LineItem.TableNewRow += new System.Data.DataTableNewRowEventHandler(LineItem_TableNewRow);
this.LineItem.ColumnChanging += new System.Data.DataColumnChangeEventHandler(ColumnChanging);
this.LineType.TableNewRow += new System.Data.DataTableNewRowEventHandler(LineType_TableNewRow);
this.LineType.ColumnChanging += new System.Data.DataColumnChangeEventHandler(ColumnChanging);
}
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);
}
