private void BuildCharacterSkillTable()
{
int CharacterSkillRowCounter = 1;
int iTemp = 0;
string CharacterAKA = "";
string FirstName = "";
string LastName = "";
string World = "";
string DescriptorValue = "";
string SkillName = "";
int SkillTypeID = 0;
int SkillID = 0;
string OrderOrigin = "";
string AttributeDesc = "";
string TeamName = "";
string dq = "\"";
string TableCode = "<table id=" + dq + "events-table" + dq + "class=" + dq + "table table-striped table-bordered table-hover table-condensed" + dq;
TableCode = TableCode + " data-toggle=" + dq + "table" + dq + " data-height=" + dq + "250" + dq + " data-sort-name=" + dq;
TableCode = TableCode + " date-earned" + dq + " data-sort-order=" + dq + " desc" + dq + " data-click-to-select=" + dq + "true" + dq;
TableCode = TableCode + " data-select-item-name=" + dq + "total-point" + dq + "><tr><td>";
Classes.cAdminViews Chars5G = new Classes.cAdminViews();
DataTable dtChars5G = new DataTable();
dtChars5G = Chars5G.FifthGateCharacterSkillList();
if (Chars5G.CharacterSkillCount == 0)
{
// Build table with no records
lblCharacterSkils.Text = TableCode + "There are no Fifth Gate character skills</td></tr></table>";
}
else
{
foreach (DataRow dRow in dtChars5G.Rows)
{
if (CharacterSkillRowCounter == 1)
{
// Build the header row
TableCode = TableCode + "CharacterAKA</td><td>FirstName</td><td>LastName</td><td>World</td><td>Team</td><td>SkillTypeID</td>";
TableCode = TableCode + "<td>Order Origin</td><td>Skill</td><td>Attribute</td><td>DescriptorValue</td><td>SkillID</td></tr>";
}
CharacterAKA = dRow["CharacterAKA"].ToString();
TableCode = TableCode + "<td>" + CharacterAKA + "</td>";
FirstName = dRow["FirstName"].ToString();
TableCode = TableCode + "<td>" + FirstName + "</td>";
LastName = dRow["LastName"].ToString();
TableCode = TableCode + "<td>" + LastName + "</td>";
World = dRow["World"].ToString();
TableCode = TableCode + "<td>" + World + "</td>";
TeamName = dRow["Team"].ToString();
TableCode = TableCode + "<td>" + TeamName + "</td>";
if (int.TryParse(dRow["SkillTypeID"].ToString(), out iTemp))
{
SkillTypeID = iTemp;
}
TableCode = TableCode + "<td>" + SkillTypeID + "</td>";
OrderOrigin = dRow["OrderOrigin"].ToString();
TableCode = TableCode + "<td>" + OrderOrigin + "</td>";
SkillName = dRow["SkillName"].ToString();
TableCode = TableCode + "<td>" + SkillName + "</td>";
AttributeDesc = dRow["AttributeDesc"].ToString();
TableCode = TableCode + "<td>" + AttributeDesc + "</td>";
DescriptorValue = dRow["DescriptorValue"].ToString();
TableCode = TableCode + "<td>" + DescriptorValue + "</td>";
if (int.TryParse(dRow["SkillID"].ToString(), out iTemp))
{
SkillID = iTemp;
}
TableCode = TableCode + "<td>" + SkillID + "</td></tr>";
CharacterSkillRowCounter++;
}
// Build the table close
lblCharacterSkils.Text = TableCode + "</table>";
}
}
private void BuildLoginTable()
{
int LoginAuditRowCounter = 1;
int iTemp = 0;
DateTime dtTemp;
int UserID = 0;
string LoginEST;
string Player = "";
string UsernameUsed = "";
string PasswordUsed = "";
string Browser = "";
string BrowserVersion = "";
string OS = "";
string OSVersion = "";
string IPAddress = "";
string dq = "\"";
string TableCode = "<table id=" + dq + "events-table" + dq + "class=" + dq + "table table-striped table-bordered table-hover table-condensed" + dq;
TableCode = TableCode + " data-toggle=" + dq + "table" + dq + " data-height=" + dq + "250" + dq + " data-sort-name=" + dq;
TableCode = TableCode + " date-earned" + dq + " data-sort-order=" + dq + " desc" + dq + " data-click-to-select=" + dq + "true" + dq;
TableCode = TableCode + " data-select-item-name=" + dq + "total-point" + dq + "><tr><td>";
Classes.cAdminViews AViews = new Classes.cAdminViews();
DataTable dtLoginAudit = new DataTable();
dtLoginAudit = AViews.GetLoginAudit();
if (AViews.LoginAuditCount == 0)
{
// Build table with no records
lblViewLogins.Text = TableCode + "There are no user login records within the past 30 days</td></tr></table>";
}
else
{
foreach (DataRow dRow in dtLoginAudit.Rows)
{
if (LoginAuditRowCounter == 1)
{
// Build the header row
TableCode = TableCode + "UserID</td><td>Login (EST)</td><td>Player</td><td>Username</td><td>Password</td><td>Browser</td>";
TableCode = TableCode + "<td>Version</td><td>OS</td><td>Version</td><td>IP Address</td></tr>";
}
// Build the detail row if the 'To' or 'From' campaign is the drop down list campaign
//RecvFromCampaign = dRow["RecvFromCampaign"].ToString();
//ReceivingCampaign = dRow["ReceivingCampaign"].ToString();
if (int.TryParse(dRow["UserID"].ToString(), out iTemp))
{
UserID = iTemp;
}
TableCode = TableCode + "<td>" + UserID + "</td>";
if (DateTime.TryParse(dRow["LoginEST"].ToString(), out dtTemp))
{
LoginEST = string.Format("{0:MM/d/yyyy hh:mm:ss}", dtTemp);
}
else
{
LoginEST = "";
}
TableCode = TableCode + "<td>" + LoginEST + "</td>";
Player = dRow["Player"].ToString();
TableCode = TableCode + "<td>" + Player + "</td>";
UsernameUsed = dRow["UsernameUsed"].ToString();
TableCode = TableCode + "<td>" + UsernameUsed + "</td>";
PasswordUsed = dRow["PasswordUsed"].ToString();
TableCode = TableCode + "<td>" + PasswordUsed + "</td>";
Browser = dRow["Browser"].ToString();
TableCode = TableCode + "<td>" + Browser + "</td>";
BrowserVersion = dRow["BrowserVersion"].ToString();
TableCode = TableCode + "<td>" + BrowserVersion + "</td>";
OS = dRow["OS"].ToString();
TableCode = TableCode + "<td>" + OS + "</td>";
OSVersion = dRow["OSVersion"].ToString();
TableCode = TableCode + "<td>" + OSVersion + "</td>";
IPAddress = dRow["IPAddress"].ToString();
TableCode = TableCode + "<td>" + IPAddress + "</td></tr>";
LoginAuditRowCounter++;
}
// Build the table close
lblViewLogins.Text = TableCode + "</table>";
}
}
private void BuildCharacterTable()
{
int CharacterRowCounter = 1;
int iTemp = 0;
double dTemp;
string CharacterAKA = "";
string TeamName = "";
string CharacterFirstName = "";
string CharacterMiddleName = "";
string CharacterLastName = "";
int PlotLeadPerson = 0;
string FirstName = "";
string LastName = "";
string DateOfBirth = "";
string WhereFrom = "";
string CurrentHome = "";
double TotalCP = 0;
string PlayerComments = "";
int CharacterSkillSetID = 0;
string dq = "\"";
string TableCode = "<table id=" + dq + "events-table" + dq + "class=" + dq + "table table-striped table-bordered table-hover table-condensed" + dq;
TableCode = TableCode + " data-toggle=" + dq + "table" + dq + " data-height=" + dq + "250" + dq + " data-sort-name=" + dq;
TableCode = TableCode + " date-earned" + dq + " data-sort-order=" + dq + " desc" + dq + " data-click-to-select=" + dq + "true" + dq;
TableCode = TableCode + " data-select-item-name=" + dq + "total-point" + dq + "><tr><td>";
Classes.cAdminViews Chars5G = new Classes.cAdminViews();
DataTable dtChars5G = new DataTable();
dtChars5G = Chars5G.FifthGateCharacterList();
if (Chars5G.CharacterCount == 0)
{
// Build table with no records
lblCharacters.Text = TableCode + "There are no Fifth Gate characters</td></tr></table>";
}
else
{
foreach (DataRow dRow in dtChars5G.Rows)
{
if (CharacterRowCounter == 1)
{
// Build the header row
TableCode = TableCode + "CharacterAKA</td><td>TeamName</td><td>CharacterFirstName</td><td>CharacterMiddleName</td><td>CharacterLastName</td>";
TableCode = TableCode + "<td>PlotLeadPerson</td><td>FirstName</td><td>LastName</td><td>DateOfBirth</td><td>WhereFrom</td>";
TableCode = TableCode + "<td>CurrentHome</td><td>TotalCP</td><td>PlayerComments</td><td>CharacterSkillSetID</td></tr>";
}
CharacterAKA = dRow["CharacterAKA"].ToString();
TableCode = TableCode + "<td>" + CharacterAKA + "</td>";
TeamName = dRow["TeamName"].ToString();
TableCode = TableCode + "<td>" + TeamName + "</td>";
CharacterFirstName = dRow["CharacterFirstName"].ToString();
TableCode = TableCode + "<td>" + CharacterFirstName + "</td>";
CharacterMiddleName = dRow["CharacterMiddleName"].ToString();
TableCode = TableCode + "<td>" + CharacterMiddleName + "</td>";
CharacterLastName = dRow["CharacterLastName"].ToString();
TableCode = TableCode + "<td>" + CharacterLastName + "</td>";
if (int.TryParse(dRow["PlotLeadPerson"].ToString(), out iTemp))
{
PlotLeadPerson = iTemp;
}
TableCode = TableCode + "<td>" + PlotLeadPerson + "</td>";
FirstName = dRow["FirstName"].ToString();
TableCode = TableCode + "<td>" + FirstName + "</td>";
LastName = dRow["LastName"].ToString();
TableCode = TableCode + "<td>" + LastName + "</td>";
DateOfBirth = dRow["DateOfBirth"].ToString();
TableCode = TableCode + "<td>" + DateOfBirth + "</td>";
WhereFrom = dRow["WhereFrom"].ToString();
TableCode = TableCode + "<td>" + WhereFrom + "</td>";
CurrentHome = dRow["CurrentHome"].ToString();
TableCode = TableCode + "<td>" + CurrentHome + "</td>";
if (double.TryParse(dRow["TotalCP"].ToString(), out dTemp))
{
TotalCP = dTemp;
}
TableCode = TableCode + "<td>" + TotalCP + "</td>";
PlayerComments = dRow["PlayerComments"].ToString();
TableCode = TableCode + "<td>" + PlayerComments + "</td>";
if (int.TryParse(dRow["CharacterSkillSetID"].ToString(), out iTemp))
{
CharacterSkillSetID = iTemp;
}
TableCode = TableCode + "<td>" + CharacterSkillSetID + "</td></tr>";
CharacterRowCounter++;
}
// Build the table close
lblCharacters.Text = TableCode + "</table>";
}
}