protected void btnCreateUpdateLogTables_Click(object sender, EventArgs e)
{
TrackerTools _TT = new TrackerTools();
_TT.ClearTrackerSessionErrorString();
TrackerDb _TDB = new TrackerDb();
// create LogTbl if it does not exist
_TDB.CreateIfDoesNotExists(TrackerDb.SQLTABLENAME_LOGTBL);
ltrlStatus.Visible = true;
ltrlStatus.Text = "Log table checked";
if (_TT.IsTrackerSessionErrorString())
{
ltrlStatus.Text += " - Error: " + _TT.GetTrackerSessionErrorString();
_TT.ClearTrackerSessionErrorString();
}
// list all the users that are not added
PersonsTbl _PersonsTbl = new PersonsTbl();
List <string> _SecurityUsersNotInPeopleTbl = _PersonsTbl.SecurityUsersNotInPeopleTbl();
pnlSetClinetType.Visible = true;
gvCustomerTypes.Visible = false;
gvResults.DataSource = _SecurityUsersNotInPeopleTbl;
ResultsTitleLabel.Text = "Security Users not in People Table ";
if (_TT.IsTrackerSessionErrorString())
{
ltrlStatus.Text += " - Error: " + _TT.GetTrackerSessionErrorString();
_TT.ClearTrackerSessionErrorString();
}
gvResults.DataBind();
// create SectionTypesTbl if it does not exist
if (_TDB.CreateIfDoesNotExists(TrackerDb.SQLTABLENAME_SECTIONTYPESTBL))
{
ltrlStatus.Text += "; Section Types table checked";
if (_TT.IsTrackerSessionErrorString())
{
ltrlStatus.Text += " - Error: " + _TT.GetTrackerSessionErrorString();
_TT.ClearTrackerSessionErrorString();
}
// add sections that do
SectionTypesTbl _SectionTypeTbl = new SectionTypesTbl();
if (_SectionTypeTbl.InsertDefaultSections())
{
ltrlStatus.Text += " - default sections added.";
}
if (_TT.IsTrackerSessionErrorString())
{
ltrlStatus.Text += " - Error: " + _TT.GetTrackerSessionErrorString();
_TT.ClearTrackerSessionErrorString();
}
}
// create TransactionTypesTbl if it does not exists
if (_TDB.CreateIfDoesNotExists(TrackerDb.SQLTABLENAME_TRANSACTIONTYPESTBL))
{
ltrlStatus.Text += "; Transaction Types table checked";
if (_TT.IsTrackerSessionErrorString())
{
ltrlStatus.Text += " - Error: " + _TT.GetTrackerSessionErrorString();
_TT.ClearTrackerSessionErrorString();
}
// add Transactions that do
TransactionTypesTbl _TransactionTypeTbl = new TransactionTypesTbl();
if (_TransactionTypeTbl.InsertDefaultTransactions())
{
ltrlStatus.Text += " - default Transactions added.";
}
if (_TT.IsTrackerSessionErrorString())
{
ltrlStatus.Text += " - Error: " + _TT.GetTrackerSessionErrorString();
_TT.ClearTrackerSessionErrorString();
}
}
_TDB.Close();
}