/// <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> /// 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 Clan record /// </summary> public static void Insert(Clan clan) { using (var dbContext = new HouseOfClansEntities()) { clan.addedOn = DateTime.Now; dbContext.Clans.Add(clan); dbContext.SaveChanges(); } }
/// <summary> /// Deletes a rule /// </summary> public static bool Delete(int ruleId) { bool isDeleted = false; Rule deleteRule = RuleManager.SelectByRuleId(ruleId); using (var dbContext = new HouseOfClansEntities()) { dbContext.Rules.Attach(deleteRule); dbContext.Rules.Remove(deleteRule); isDeleted = dbContext.SaveChanges() > 0; } return isDeleted; }
/// <summary> /// Deletes the current Clan /// </summary> public static bool Delete(int clanId) { bool isDeleted = false; Clan deleteClan = ClanManager.SelectByClanId(clanId); using (var dbContext = new HouseOfClansEntities()) { dbContext.Clans.Attach(deleteClan); dbContext.Clans.Remove(deleteClan); isDeleted = dbContext.SaveChanges() > 0; } return isDeleted; }
/// <summary> /// Deletes the Picks of the current Clan War /// </summary> public static bool Delete(int warId) { bool isDeleted = false; using (var dbContext = new HouseOfClansEntities()) { dbContext.ClanWarPicks.RemoveRange(dbContext.ClanWarPicks.Where(p => p.clanWarId == warId)); dbContext.SaveChanges(); } isDeleted = !ClanWarPicksManager.SelectAllByWarId(warId).Any(); return isDeleted; }
/// <summary> /// Deletes a UserBlackList /// </summary> public static bool Delete(int blacklistId) { bool isDeleted = false; UserBlackList deleteBlacklist = BlacklistManager.SelectByBlacklistId(blacklistId); using (var dbContext = new HouseOfClansEntities()) { dbContext.UserBlackLists.Attach(deleteBlacklist); dbContext.UserBlackLists.Remove(deleteBlacklist); isDeleted = dbContext.SaveChanges() > 0; } return isDeleted; }
public static void UpdateMemberWarPosition(string[] sortedPicks) { string idParsed = string.Empty; using (var dbContext = new HouseOfClansEntities()) { for (short i = 0; i < sortedPicks.Length; i++) { idParsed = sortedPicks[i].Replace(_clanWarPickSortedName, ""); ClanWarPick pick = new ClanWarPick() { id = int.Parse(idParsed), clanMemberWarPosition = (short)(i + 1), updatedOn = DateTime.Now }; dbContext.ClanWarPicks.Attach(pick); dbContext.Entry(pick).Property(p => p.clanMemberWarPosition).IsModified = true; dbContext.Entry(pick).Property(p => p.updatedOn).IsModified = true; dbContext.SaveChanges(); } } }
/// <summary> /// Updates a Rule /// </summary> public static void Update(Rule rule) { using (var dbContext = new HouseOfClansEntities()) { Rule ruleInfo = RuleManager.SelectByRuleId(rule.id); ruleInfo.updatedOn = DateTime.Now; dbContext.Rules.Attach(ruleInfo); dbContext.Entry(ruleInfo).CurrentValues.SetValues(rule); dbContext.SaveChanges(); } }
/// <summary> /// Updates the current Clan /// </summary> public static void Update(Clan clan) { using (var dbContext = new HouseOfClansEntities()) { Clan clanInfo = ClanManager.SelectByClanId(clan.id); clanInfo.updatedOn = DateTime.Now; dbContext.Clans.Attach(clanInfo); dbContext.Entry(clanInfo).CurrentValues.SetValues(clan); dbContext.SaveChanges(); } }
/// <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> /// Inserts or Updates the Clan War Picks depending on the parameters received. /// </summary> /// <param name="clanWarPickViewModel">A ClanWarPickViewModel object, if its Id is NULL then do an Insert, else Updates.</param> public static void Upsert(List<ClanWarPickViewModel> clanWarPicksList) { using (var dbContext = new HouseOfClansEntities()) { foreach (ClanWarPickViewModel pick in clanWarPicksList) { ClanWarPick clanWarPick = ClanWarPicksManager.ConvertViewToModel(pick); if (pick.Id == null) { clanWarPick.addedOn = DateTime.Now; dbContext.ClanWarPicks.Add(clanWarPick); } else { clanWarPick.updatedOn = DateTime.Now; dbContext.Entry(clanWarPick).State = EntityState.Modified; dbContext.Entry(clanWarPick).Property(p => p.clanMemberWarPosition).IsModified = false; } dbContext.SaveChanges(); } } }
/// <summary> /// Updates a UserBlackList /// </summary> public static void Update(UserBlackList updatedBUser) { UserBlackList bUser = BlacklistManager.SelectByBlacklistId(updatedBUser.id); using (var dbContext = new HouseOfClansEntities()) { //TODO: Add updatedOn for the UserBlackList entity in the database //updatedBUser.updatedOn = DateTime.Now; dbContext.UserBlackLists.Attach(bUser); dbContext.Entry(bUser).CurrentValues.SetValues(updatedBUser); dbContext.SaveChanges(); } }
public static void Upsert(List<WarRanking> rankings) { using (var dbContext = new HouseOfClansEntities()) { //vv The next line helps debugging. It will write to the Output window the sql statements //vv dbContext.Database.Log = s => System.Diagnostics.Debug.WriteLine(s); foreach (WarRanking ranking in rankings) { if (ranking.id == 0) { ranking.addedOn = DateTime.Now; dbContext.WarRankings.Add(ranking); } else { ranking.updatedOn = DateTime.Now; dbContext.Entry(ranking).State = EntityState.Modified; } dbContext.SaveChanges(); } } }