public static List <WarRanking> SelectRankingsByClanId(int clanId)
{
List <WarRanking> allClanMembersRankings = new List <WarRanking>();
List <int> clanMembers = ClanUserManager.SelectAllByClanId(clanId).Where(p => (Enums.ClanRole)p.userRoleId != Enums.ClanRole.Unknown).OrderBy(o => o.userRoleId).Select(p => p.id).ToList();
using (var dbContext = new HouseOfClansEntities())
{
allClanMembersRankings = dbContext.WarRankings.Where(p => clanMembers.Contains(p.clanUserId)).Select(ranking => ranking).ToList();
}
return(allClanMembersRankings);
}
/// <summary>
/// Updates the current Clan User
/// </summary>
public static void Update(ClanUser updatedClanUser)
{
ClanUser clanUser = ClanUserManager.SelectByClanUserId(updatedClanUser.id);
using (var dbContext = new HouseOfClansEntities())
{
updatedClanUser.updatedOn = DateTime.Now;
dbContext.ClanUsers.Attach(clanUser);
dbContext.Entry(clanUser).CurrentValues.SetValues(updatedClanUser);
dbContext.SaveChanges();
}
}
/// <summary>
/// Deletes the current Clan User
/// </summary>
public static bool Delete(int clanUserId)
{
bool isDeleted = false;
ClanUser deleteCLanUser = ClanUserManager.SelectByClanUserId(clanUserId);
using (var dbContext = new HouseOfClansEntities())
{
dbContext.ClanUsers.Attach(deleteCLanUser);
dbContext.ClanUsers.Remove(deleteCLanUser);
isDeleted = dbContext.SaveChanges() > 0;
}
return(isDeleted);
}
