protected void Page_Load(object sender, EventArgs e)
{
data = new UserAccountsEntities("metadata=res://*;provider=System.Data.SqlClient;provider connection string='Data Source=mmodsql1.orcsweb.com;Initial Catalog=UserAccounts;User ID=mmod_report_user;Password=\"MarchMadness;1\";MultipleActiveResultSets=True;Network Library=dbmssocn'");
//If it's the user is just entering the page, attempt to log in via cookie
if (!IsPostBack)
{
string username = ReadCookie();
if (username != null)
{
User user = data.User.First(x => x.UserName == username);
LoginSuccessful(user);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
data = new MediaAxEntities("metadata=res://*;provider=System.Data.SqlClient;provider connection string='Data Source=mmodsql1.orcsweb.com;Initial Catalog=MediaAx;User ID=mmod_report_user;Password=\"MarchMadness;1\";MultipleActiveResultSets=True;Network Library=dbmssocn'");
data.CommandTimeout = 300;
//If there isn't a user logged in yet, I'll need the accounts database.
if (loginDiv.Visible)
{
accounts = new UserAccountsEntities("metadata=res://*;provider=System.Data.SqlClient;provider connection string='Data Source=mmodsql1.orcsweb.com;Initial Catalog=UserAccounts;User ID=mmod_report_user;Password=\"MarchMadness;1\";MultipleActiveResultSets=True;Network Library=dbmssocn'");
accounts.CommandTimeout = 300;
}
if (!IsPostBack)
{
//set properties for the main datagrid.
myDataGrid.AutoGenerateColumns = true;
myDataGrid.BorderWidth = 2;
myDataGrid.CellSpacing = 1;
myDataGrid.GridLines = GridLines.Both;
myDataGrid.BackColor = System.Drawing.Color.Beige;
myDataGrid.HeaderStyle.BackColor = System.Drawing.Color.BurlyWood;
myDataGrid.AlternatingItemStyle.BackColor = System.Drawing.Color.Gainsboro;
var browsers = from item in data.LogBrowsers
orderby item.LogBrowserId
select new
{
ID = item.LogBrowserId,
Name = item.LogBrowserName,
Version = item.LogBrowserVersion
};
var browserNames = (from item in browsers select item.Name).Distinct();
//Populate the TreeView
TreeNode root = new TreeNode(currentApp);
TreeNode osNode = new TreeNode("Operating Systems");
TreeNode browserNode = new TreeNode("Browsers");
foreach (string br in browserNames)
{
TreeNode tempNode = new TreeNode(br);
tempNode.SelectAction = TreeNodeSelectAction.Select;
browserNode.ChildNodes.Add(tempNode);
}
browserNode.Expanded = false;
var osNames = from item in data.LogPlatforms select item.LogPlatformName;
foreach (string os in osNames)
{
TreeNode tempNode = new TreeNode(os);
tempNode.SelectAction = TreeNodeSelectAction.Select;
osNode.ChildNodes.Add(tempNode);
}
foreach (TreeNode node in browserNode.ChildNodes)
{
TreeNode OSes = new TreeNode("Operating Systems");
foreach (string os in osNames)
{
TreeNode tempNode = new TreeNode(os);
tempNode.SelectAction = TreeNodeSelectAction.Select;
OSes.ChildNodes.Add(tempNode);
}
OSes.Expanded = false;
node.ChildNodes.Add(OSes);
node.Expanded = false;
}
foreach (TreeNode node in osNode.ChildNodes)
{
TreeNode brs = new TreeNode("Browsers");
foreach (string br in browserNames)
{
TreeNode tempNode = new TreeNode(br);
tempNode.SelectAction = TreeNodeSelectAction.Select;
brs.ChildNodes.Add(tempNode);
}
brs.Expanded = false;
node.ChildNodes.Add(brs);
node.Expanded = false;
}
osNode.Expanded = false;
root.ChildNodes.Add(osNode);
root.ChildNodes.Add(browserNode);
root.Selected = true;
SearchTree.Nodes.Add(root);
//Check the cookie for auto-login
string username = ReadCookie();
if (username != null)
{
try
{
User user = accounts.User.First(x => x.UserName == username);
LoginSuccessful(user);
}
catch
{
}
}
StartCalendar.SelectedDate = DateTime.Today;
EndCalendar.SelectedDate = DateTime.Today;
}
//Anytime something is clicked, we hit this on post-back.
if (!loginDiv.Visible)
{
//Change the app at the root of the tree view to match the one chosen in the dropdown.
if (currentApp != AppIDList.SelectedItem.Text)
{
SearchTree.Nodes[0].Value = AppIDList.SelectedItem.Value;
SearchTree.Nodes[0].Text = AppIDList.SelectedItem.Text;
Submitted(sender, e);
}
//Enable the calendars for custom dates.
if (TimeSelection.SelectedIndex == 4)
{
StartCalendar.Enabled = true;
EndCalendar.Enabled = true;
}
else
{
StartCalendar.Enabled = false;
EndCalendar.Enabled = false;
}
//Submitted(sender, e);
}
}
