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