/// <summary>
/// Inserts or Updates a Clan War depending on the parameters received.
/// </summary>
/// <param name="clanWarViewModel">A ClanWarViewModel object, if its Id is NULL then do an Insert, else Updates.</param>
public static int Upsert(ClanWarUpsertViewModel clanWarViewModel, int userId)
{
Enums.Action action = Enums.Action.Create;
ClanWar clanWar = ClanWarManager.ConvertViewToModel(clanWarViewModel);
using (var dbContext = new HouseOfClansEntities())
{
if (clanWarViewModel.Id == null)
{
clanWar.addedOn = DateTime.Now;
dbContext.ClanWars.Add(clanWar);
if (dbContext.SaveChanges() > 0)
{
ActionLogManager.Log <ClanWarUpsertViewModel>(action, userId, null, null, string.Format("Clan War Id: {0}", clanWar.id));
}
}
else
{
ClanWar original = ClanWarManager.SelectByClanWarId(clanWar.id);
action = Enums.Action.Update;
clanWar.updatedOn = DateTime.Now;
dbContext.Entry(clanWar).State = EntityState.Modified;
if (dbContext.SaveChanges() > 0)
{
List <ActionLog> changes = GetChanges(clanWar, original);
ActionLogManager.Log <ClanWarUpsertViewModel>(action, userId, changes);
}
}
}
return(clanWar.id);
}
public static List <WarRanking> SelectRankingsByClanWarId(int id, bool sortedByPick)
{
List <WarRanking> rankings = new List <WarRanking>();
using (var dbContext = new HouseOfClansEntities())
{
rankings = dbContext.WarRankings.Where(p => p.clanWarId == id && !p.optOut).ToList();
if (sortedByPick)
{
List <ClanWarPick> warMapMembers = ClanWarPicksManager.SelectAllByWarId(id).ToList();
List <WarRanking> sortedRankings = new List <WarRanking>();
warMapMembers.ForEach(delegate(ClanWarPick sortedPick)
{
WarRanking sortedRanking = rankings.Where(p => p.clanUserId == sortedPick.clanUserId).FirstOrDefault();
if (sortedRanking != null && sortedRanking.clanWarId == id)
{
sortedRankings.Add(sortedRanking);
}
});
rankings = new List <WarRanking>();
rankings = sortedRankings;
}
}
return(rankings);
}
/// <summary>
/// Inserts a new ClanGroup
/// </summary>
public static void Insert(ClanGroup clanGroup)
{
using (var dbContext = new HouseOfClansEntities())
{
clanGroup.addedOn = DateTime.Now;
dbContext.ClanGroups.Add(clanGroup);
dbContext.SaveChanges();
}
}
/// <summary>
/// Inserts a new Request record
/// </summary>
public static void Insert(Request req)
{
using (var dbContext = new HouseOfClansEntities())
{
req.addedOn = DateTime.Now;
dbContext.Requests.Add(req);
dbContext.SaveChanges();
}
}
/// <summary>
/// Inserts a new Rule
/// </summary>
public static void Insert(Rule rule)
{
using (var dbContext = new HouseOfClansEntities())
{
rule.addedOn = DateTime.Now;
dbContext.Rules.Add(rule);
dbContext.SaveChanges();
}
}
/// <summary>
/// Inserts a new UserBlackList record
/// </summary>
public static void Insert(UserBlackList bUser)
{
using (var dbContext = new HouseOfClansEntities())
{
bUser.addedOn = DateTime.Now;
dbContext.UserBlackLists.Add(bUser);
dbContext.SaveChanges();
}
}
/// <summary>
/// Gets the list of unprocessed requests based on the clan id
/// </summary>
/// <param name="clanId">Clan Id</param>
public static List <Request> SelectUnprocessedRequestsByClanId(int clanId)
{
List <Request> requests = new List <Request>();
using (var dbContext = new HouseOfClansEntities())
{
requests = dbContext.Requests.Where(p => p.clanId == clanId && p.processed == false).ToList();
}
return(requests);
}
/// <summary>
/// Gets a Request based on the aspnetUserId
/// </summary>
/// <param name="requestId">Aspnet User Id</param>
public static Request SelectByAspnetUserId(string aspnetUserId)
{
Request request = new Request();
using (var dbContext = new HouseOfClansEntities())
{
request = dbContext.Requests.Where(p => p.aspnetUserId == aspnetUserId).FirstOrDefault();
}
return(request);
}
/// <summary>
/// Gets the all the freeagents by clan id
/// </summary>
/// <param name="clanId">Clan Id</param>
public static List <ClanUser> SelectFreeAgentsByClanId(int clanId)
{
List <ClanUser> freeAgents = new List <ClanUser>();
using (var dbContext = new HouseOfClansEntities())
{
freeAgents = dbContext.ClanUsers.Where(p => p.clanId == clanId && p.clanGroupId == null && p.userRoleId != (short)ClanRole.Leader).ToList();
}
return(freeAgents);
}
/// <summary>
/// Gets the clan user information based on the clan user id
/// </summary>
/// <param name="clanUserId">ClanUser Id</param>
public static ClanUser SelectByClanUserId(int userId)
{
ClanUser clanUser = new ClanUser();
using (var dbContext = new HouseOfClansEntities())
{
clanUser = dbContext.ClanUsers.Where(p => p.id == userId).Select(user => user).FirstOrDefault();
}
return(clanUser);
}
/// <summary>
/// Get all logs from db (raw from table). This is meant to be a debug/audit tool for Admins, we don't want it accessible or used by anything/anybody else.
/// Rarely used. Right now only used on the 'hidden' logs page. Might be deprecated soon or moved to its ActionLog Manager/ModelView. //vv
/// </summary>
public static List <ActionLog> GetAll()
{
List <ActionLog> logs = new List <ActionLog>();
using (var dbContext = new HouseOfClansEntities())
{
logs = dbContext.ActionLogs.ToList();
}
return(logs);
}
/// <summary>
/// Gets the list of UserBlackList based on the clan id
/// </summary>
/// <param name="clanId">Clan Id</param>
public static List <UserBlackList> SelectBlackListsByClanId(int clanId)
{
List <UserBlackList> userBlacklists = new List <UserBlackList>();
using (var dbContext = new HouseOfClansEntities())
{
userBlacklists = dbContext.UserBlackLists.Where(p => p.clanId == clanId).ToList();
}
return(userBlacklists);
}
/// <summary>
/// Gets the User Role by id
/// </summary>
/// <returns>A UserRole object</returns>
public static UserRole Get(int id)
{
UserRole userRole = new UserRole();
using (var dbContext = new HouseOfClansEntities())
{
userRole = dbContext.UserRoles.Where(p => p.id == id).FirstOrDefault();
}
return(userRole);
}
/// <summary>
/// Gets the clan war information based on the clan war id
/// </summary>
/// <param name="clanWarId">Clan War Id</param>
public static ClanWar SelectByClanWarId(int clanWarId)
{
ClanWar clanWarInfo = new ClanWar();
using (var dbContext = new HouseOfClansEntities())
{
clanWarInfo = dbContext.ClanWars.Where(p => p.id == clanWarId).Select(clanWar => clanWar).FirstOrDefault();
}
return(clanWarInfo);
}
/// <summary>
/// Gets a rule based on the rule id
/// </summary>
/// <param name="clanId">Clan Id</param>
public static Rule SelectByRuleId(int ruleId)
{
Rule rule = new Rule();
using (var dbContext = new HouseOfClansEntities())
{
rule = dbContext.Rules.Where(p => p.id == ruleId).FirstOrDefault();
}
return(rule);
}
/// <summary>
/// Gets a list of rules based on the clan id
/// </summary>
/// <param name="clanId">Clan Id</param>
public static List <Rule> SelectAllByClanId(int?clanId)
{
List <Rule> rules = new List <Rule>();
using (var dbContext = new HouseOfClansEntities())
{
rules = dbContext.Rules.Where(p => p.clanId == clanId).ToList();
}
return(rules);
}
/// <summary>
/// Gets the Clan Regular Members based on the clan id
/// </summary>
/// <param name="clanId">Clan Id</param>
public static List <ClanUser> SelectClanRegularMembersByClanId(int clanId)
{
List <ClanUser> clanMembers = new List <ClanUser>();
using (var dbContext = new HouseOfClansEntities())
{
clanMembers = dbContext.ClanUsers.Where(p => p.clanId == clanId && (ClanRole)p.userRoleId == ClanRole.Member).ToList();
}
return(clanMembers);
}
/// <summary>
/// Gets the Clan Leader based on the clan id
/// </summary>
/// <param name="clanId">Clan Id</param>
public static ClanUser SelectClanLeaderByClanId(int clanId)
{
ClanUser clanLeader = new ClanUser();
using (var dbContext = new HouseOfClansEntities())
{
clanLeader = dbContext.ClanUsers.Where(p => p.clanId == clanId && (ClanRole)p.userRoleId == ClanRole.Leader).Select(user => user).FirstOrDefault();
}
return(clanLeader);
}
/// <summary>
/// Gets the list of all available User Roles
/// </summary>
/// <returns>A UserRole object list</returns>
public static List <UserRole> GetAll()
{
List <UserRole> userRoles = new List <UserRole>();
using (var dbContext = new HouseOfClansEntities())
{
userRoles = dbContext.UserRoles.Select(userRole => userRole).ToList();
}
return(userRoles);
}
/// <summary>
/// Gets the list of clan wars based on the clan id
/// </summary>
/// <param name="clanId">Clan Id</param>
public static List <ClanWar> SelectClanWarsByClanId(int clanId)
{
List <ClanWar> clanWars = new List <ClanWar>();
using (var dbContext = new HouseOfClansEntities())
{
clanWars = dbContext.ClanWars.Where(p => p.clanId == clanId).Select(wars => wars).ToList();
}
return(clanWars);
}
/// <summary>
/// Gets a UserBlacklist based on the blacklist id
/// </summary>
/// <param name="userBlacklistId">UserBlacklist Id</param>
public static UserBlackList SelectByBlacklistId(int blacklistId)
{
UserBlackList blacklist = new UserBlackList();
using (var dbContext = new HouseOfClansEntities())
{
blacklist = dbContext.UserBlackLists.Where(p => p.id == blacklistId).FirstOrDefault();
}
return(blacklist);
}
/// <summary>
/// Gets the all members based on the clan id
/// </summary>
/// <param name="clanId">Clan Id</param>
public static List <ClanUser> SelectAllByClanId(int clanId)
{
List <ClanUser> clanMembers = new List <ClanUser>();
using (var dbContext = new HouseOfClansEntities())
{
clanMembers = dbContext.ClanUsers.Where(p => p.clanId == clanId).Select(user => user).ToList();
}
return(clanMembers);
}
public static WarType Get(int id)
{
WarType warType = new WarType();
using (var dbContext = new HouseOfClansEntities())
{
warType = dbContext.WarTypes.Where(p => p.id == id).FirstOrDefault();
}
return(warType);
}
/// <summary>
/// Gets a ClanGroup based on the ClanGroup id
/// </summary>
/// <param name="clanId">Clan Id</param>
public static ClanGroup SelectByClanGroupId(int clanGroupId)
{
ClanGroup clanGroup = new ClanGroup();
using (var dbContext = new HouseOfClansEntities())
{
clanGroup = dbContext.ClanGroups.Where(p => p.id == clanGroupId).FirstOrDefault();
}
return(clanGroup);
}
/// <summary>
/// Gets the list of all available war types
/// </summary>
/// <returns>A WarType object list</returns>
public static List <WarType> GetAll()
{
List <WarType> warTypes = new List <WarType>();
using (var dbContext = new HouseOfClansEntities())
{
warTypes = dbContext.WarTypes.Select(warType => warType).OrderBy(p => p.id).ToList();
}
return(warTypes);
}
/// <summary>
/// Get all users of the website. Rarely used. Right now only used on the 'hidden' logs page. Might be deprecated soon or moved to its ActionLog Manager/ModelView. //vv
/// </summary>
/// <returns>A list of all ClanUsers of the website</returns>
public static List <ClanUser> SelectAll()
{
List <ClanUser> clanMembers = new List <ClanUser>();
using (var dbContext = new HouseOfClansEntities())
{
clanMembers = dbContext.ClanUsers.ToList();
}
return(clanMembers);
}
/// <summary>
/// Gets a list of ClanGroups based on the clan id
/// </summary>
/// <param name="clanId">Clan Id</param>
public static List <ClanGroup> SelectAllByClanId(int?clanId)
{
List <ClanGroup> clanGroups = new List <ClanGroup>();
using (var dbContext = new HouseOfClansEntities())
{
clanGroups = dbContext.ClanGroups.Where(p => p.clanId == clanId).ToList();
}
return(clanGroups);
}
public static List <WarRanking> SelectRankingsByUserId(int userId)
{
List <WarRanking> rankings = new List <WarRanking>();
using (var dbContext = new HouseOfClansEntities())
{
rankings = dbContext.WarRankings.Where(p => p.clanUserId == userId).Select(ranking => ranking).OrderByDescending(o => o.addedOn).ToList();
}
return(rankings);
}
/// <summary>
/// Gets a Request based on the request id
/// </summary>
/// <param name="requestId">Request Id</param>
public static Request SelectById(int requestId)
{
Request request = new Request();
using (var dbContext = new HouseOfClansEntities())
{
request = dbContext.Requests.Where(p => p.id == requestId).FirstOrDefault();
}
return(request);
}
/// <summary>
/// Gets a list of War Picks based on the war id
/// </summary>
/// <param name="warId">War Id</param>
public static List <ClanWarPick> SelectAllByWarId(int warId)
{
List <ClanWarPick> warPicks = new List <ClanWarPick>();
using (var dbContext = new HouseOfClansEntities())
{
warPicks = dbContext.ClanWarPicks.Where(p => p.clanWarId == warId).OrderBy(p => p.clanMemberWarPosition).ToList();
}
return(warPicks);
}
