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); } }