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