private void BindData() { using (DataAccess.CSSDataContext db = new Allegiance.CommunitySecuritySystem.DataAccess.CSSDataContext()) { var allSquads = db.Groups.Where(p => p.IsSquad == true).OrderBy(p => p.Name); List <Data.SquadData> squadDatas = new List <Allegiance.CommunitySecuritySystem.Management.Stats.Data.SquadData>(); foreach (var squad in allSquads) { Data.SquadData squadData = new Allegiance.CommunitySecuritySystem.Management.Stats.Data.SquadData(); squadData.SquadName = squad.Name; foreach (var gagr in squad.Group_Alias_GroupRoles) { squadData.Members.Add(new Data.MemberData() { Token = gagr.GroupRole.Token.ToString(), Callsign = gagr.Alias.Callsign, IsActive = gagr.Alias.Login.Identity.DateLastLogin > DateTime.Now.AddDays(-30) }); } //squadData.Members.OrderBy(p => p.IsActive).ThenBy(p => p.Token); if (squadData.Members.Count > 0) { squadDatas.Add(squadData); } } SquadList = squadDatas; rptHeaders.DataSource = squadDatas.ToArray(); rptHeaders.DataBind(); rptSquads.DataSource = squadDatas.ToArray(); rptSquads.DataBind(); rptFooter.DataSource = squadDatas.ToArray(); rptFooter.DataBind(); } }
private void BindData() { using (DataAccess.CSSDataContext db = new Allegiance.CommunitySecuritySystem.DataAccess.CSSDataContext()) { var allSquads = db.Groups.Where(p => p.IsSquad == true).OrderBy(p => p.Name); List<Data.SquadData> squadDatas = new List<Allegiance.CommunitySecuritySystem.Management.Stats.Data.SquadData>(); foreach (var squad in allSquads) { Data.SquadData squadData = new Allegiance.CommunitySecuritySystem.Management.Stats.Data.SquadData(); squadData.SquadName = squad.Name; foreach (var gagr in squad.Group_Alias_GroupRoles) { squadData.Members.Add(new Data.MemberData() { Token = gagr.GroupRole.Token.ToString(), Callsign = gagr.Alias.Callsign, IsActive = gagr.Alias.Login.Identity.DateLastLogin > DateTime.Now.AddDays(-30) }); } //squadData.Members.OrderBy(p => p.IsActive).ThenBy(p => p.Token); if(squadData.Members.Count > 0) squadDatas.Add(squadData); } SquadList = squadDatas; rptHeaders.DataSource = squadDatas.ToArray(); rptHeaders.DataBind(); rptSquads.DataSource = squadDatas.ToArray(); rptSquads.DataBind(); rptFooter.DataSource = squadDatas.ToArray(); rptFooter.DataBind(); } }