public void CleanUpExistingRecords()
{
using (NemeStatsDbContext dbContext = new NemeStatsDbContext())
{
using (NemeStatsDataContext dataContext = new NemeStatsDataContext(dbContext, new SecuredEntityValidatorFactory()))
{
var games = dataContext.GetQueryable <GameDefinition>()
.Where(game => game.BoardGameGeekGameDefinitionId == null)
.ToList();
var bggSearcher = new BoardGameGeekClient(new ApiDownloaderService());
int updateCount = 0;
foreach (GameDefinition game in games)
{
var bggResults = bggSearcher.SearchBoardGames(game.Name.Trim(), true);
if (bggResults.Count() == 1)
{
game.BoardGameGeekGameDefinitionId = bggResults.First().BoardGameId;
ApplicationUser user = new ApplicationUser
{
CurrentGamingGroupId = game.GamingGroupId
};
dataContext.Save(game, user);
dataContext.CommitAllChanges();
Console.WriteLine(game.Name + " had exactly one match and was updated.");
updateCount++;
}
}
Console.WriteLine("Updated " + updateCount + " records.");
}
}
}
private ApplicationUser UpdateDatefaultGamingGroupOnUser(ApplicationUser user, GamingGroup gamingGroup, NemeStatsDataContext dataContext)
{
user.CurrentGamingGroupId = gamingGroup.Id;
dataContext.CommitAllChanges();
return(user);
}
public void CleanUpExistingRecords()
{
using (NemeStatsDbContext dbContext = new NemeStatsDbContext())
{
using (NemeStatsDataContext dataContext = new NemeStatsDataContext(dbContext, new SecuredEntityValidatorFactory()))
{
var games = dataContext.GetQueryable<GameDefinition>()
.Where(game => game.BoardGameGeekGameDefinitionId == null)
.ToList();
var bggSearcher = new BoardGameGeekClient(new ApiDownloaderService(), new RollbarClient());
int updateCount = 0;
foreach (GameDefinition game in games)
{
var bggResults = bggSearcher.SearchBoardGames(game.Name.Trim(), true);
if (bggResults.Count() == 1)
{
game.BoardGameGeekGameDefinitionId = bggResults.First().BoardGameId;
ApplicationUser user = new ApplicationUser
{
CurrentGamingGroupId = game.GamingGroupId
};
dataContext.Save(game, user);
dataContext.CommitAllChanges();
Console.WriteLine(game.Name + " had exactly one match and was updated.");
updateCount++;
}
}
Console.WriteLine("Updated " + updateCount + " records.");
}
}
}
public virtual ActionResult DeleteConfirmed(int id, ApplicationUser currentUser)
{
playedGameDeleter.DeletePlayedGame(id, currentUser);
//TODO really don't know whether I need to commit here or if it is automatically taken care of when disposing.
dataContext.CommitAllChanges();
return(new RedirectResult(Url.Action(MVC.GamingGroup.ActionNames.Index, MVC.GamingGroup.Name)
+ "#" + GamingGroupController.SECTION_ANCHOR_RECENT_GAMES));
}
private GamingGroup SaveGamingGroup(NemeStatsDataContext dataContext, string gamingGroupName, ApplicationUser owningUser)
{
GamingGroup gamingGroup = new GamingGroup {
Name = gamingGroupName, OwningUserId = owningUser.Id
};
dataContext.Save(gamingGroup, owningUser);
dataContext.CommitAllChanges();
return(gamingGroup);
}
private static void Cleanup(
NemeStatsDataContext dbContext,
GamingGroup gamingGroup,
ApplicationUser currentUser)
{
GamingGroup gamingGroupToDelete = dbContext.GetQueryable<GamingGroup>()
.Where(game => game.Name == gamingGroup.Name).FirstOrDefault();
if (gamingGroupToDelete != null)
{
dbContext.Delete(gamingGroupToDelete, currentUser);
dbContext.CommitAllChanges();
}
}
private static void Cleanup(
NemeStatsDataContext dbContext,
GamingGroup gamingGroup,
ApplicationUser currentUser)
{
GamingGroup gamingGroupToDelete = dbContext.GetQueryable <GamingGroup>()
.Where(game => game.Name == gamingGroup.Name).FirstOrDefault();
if (gamingGroupToDelete != null)
{
dbContext.Delete(gamingGroupToDelete, currentUser);
dbContext.CommitAllChanges();
}
}
public void TheAddOrInsertExtensionMethodSetsTheIdOnNewEntities()
{
using (NemeStatsDataContext dataContext = new NemeStatsDataContext(
new NemeStatsDbContext(),
new SecuredEntityValidatorFactory()))
{
GamingGroup gamingGroup = new GamingGroup()
{
Name = "new gaming group without an ID yet",
OwningUserId = testUserWithDefaultGamingGroup.Id
};
dataContext.Save(gamingGroup, testUserWithDefaultGamingGroup);
dataContext.CommitAllChanges();
Cleanup(dataContext, gamingGroup, testUserWithDefaultGamingGroup);
Assert.AreNotEqual(default(int), gamingGroup.Id);
}
}
public void TheAddOrInsertExtensionMethodSetsTheIdOnNewEntities()
{
using(NemeStatsDataContext dataContext = new NemeStatsDataContext(
new NemeStatsDbContext(),
new SecuredEntityValidatorFactory()))
{
GamingGroup gamingGroup = new GamingGroup()
{
Name = "new gaming group without an ID yet",
OwningUserId = testUserWithDefaultGamingGroup.Id
};
dataContext.Save(gamingGroup, testUserWithDefaultGamingGroup);
dataContext.CommitAllChanges();
Cleanup(dataContext, gamingGroup, testUserWithDefaultGamingGroup);
Assert.AreNotEqual(default(int), gamingGroup.Id);
}
}
private GamingGroup SaveGamingGroup(NemeStatsDataContext dataContext, string gamingGroupName, ApplicationUser owningUser)
{
GamingGroup gamingGroup = new GamingGroup { Name = gamingGroupName, OwningUserId = owningUser.Id };
dataContext.Save(gamingGroup, owningUser);
dataContext.CommitAllChanges();
return gamingGroup;
}
private ApplicationUser UpdateDatefaultGamingGroupOnUser(ApplicationUser user, GamingGroup gamingGroup, NemeStatsDataContext dataContext)
{
user.CurrentGamingGroupId = gamingGroup.Id;
dataContext.CommitAllChanges();
return user;
}
