public void FillHubEdgeGridfromSession() { DataTable DataServers = new DataTable(); try { if (Session["HubEdgeGrid"] != null && Session["HubEdgeGrid"] != "") { DataServers = Session["HubEdgeGrid"] as DataTable; } if (DataServers.Rows.Count > 0) { //7/21/2014 NS modified //DataServers.PrimaryKey = new DataColumn[] { DataServers.Columns["ID"] }; DataServers.PrimaryKey = new DataColumn[] { DataServers.Columns["CID"] }; DataView dv = new DataView((DataTable)Session["HubEdgeGrid"]); //HUBList.Text = "0"; //EDGEList.Text = "0"; var result = from row in DataServers.AsEnumerable() group row by row.Field <string>("RoleName") into grp select new { RoleName = grp.Key, MemberCount = grp.Count() }; foreach (var t in result) { if (t.RoleName.ToString().ToLower() == "hub") { //HUBList.Text = t.MemberCount.ToString(); } if (t.RoleName.ToString().ToLower() == "edge") { //EDGEList.Text = t.MemberCount.ToString(); } } } HubEdgeGridView.DataSource = DataServers; HubEdgeGridView.DataBind(); } catch (Exception ex) { Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); throw ex; } }
public void FillHubEdgeGrid() { string HUBList = ""; string EDGEList = ""; DataTable dt = new DataTable(); dt = VSWebBL.ExchangeBAL.Ins.GetHubEdgeStatus(); Session["HubEdgeGrid"] = dt; //HUBList.Text = "0"; //EDGEList.Text = "0"; HUBList = "0"; EDGEList = "0"; var result = from row in dt.AsEnumerable() group row by row.Field <string>("RoleName") into grp select new { RoleName = grp.Key, MemberCount = grp.Count() }; foreach (var t in result) { if (t.RoleName.ToString().ToLower() == "hub") { //HUBList.Text = t.MemberCount.ToString(); HUBList = t.MemberCount.ToString(); } if (t.RoleName.ToString().ToLower() == "edge") { //EDGEList.Text = t.MemberCount.ToString(); EDGEList = t.MemberCount.ToString(); } } HubEdgeGridView.DataSource = dt; HubEdgeGridView.DataBind(); //7/18/2014 NS added DataRow rolerow = srvroles.Rows.Add(); rolerow["Role"] = "HUB"; rolerow["RoleCount"] = Convert.ToInt32(HUBList); rolerow = srvroles.Rows.Add(); rolerow["Role"] = "EDGE"; rolerow["RoleCount"] = Convert.ToInt32(EDGEList); }