/// <summary>
/// add a single game entry
/// </summary>
/// <param name="game"></param>
public static void AddGame(MOBY_Game game)
{
using (var aG = new AsniScrapeAdminDbContext())
{
aG.MOBY_Game.Add(game);
aG.SaveChanges();
aG.Dispose();
}
}
/// <summary>
/// update a single game entry
/// </summary>
/// <param name="game"></param>
public static void UpdateGame(MOBY_Game game)
{
using (var uG = new AsniScrapeAdminDbContext())
{
uG.MOBY_Game.Update(game);
uG.SaveChanges();
uG.Dispose();
}
}
public static void UpdateDoc(Game_Doc doc)
{
using (var aG = new AsniScrapeAdminDbContext())
{
// check whether doc url already exists
Game_Doc doc1 = (from a in aG.Game_Doc.AsNoTracking()
where a.id == doc.id
select a).FirstOrDefault();
if (doc1 != null)
{
aG.Game_Doc.Update(doc);
aG.SaveChanges();
aG.Dispose();
}
}
}
public static void AddDoc(Game_Doc doc)
{
using (var aG = new AsniScrapeAdminDbContext())
{
// check whether doc url already exists
List <Game_Doc> docs = (from a in aG.Game_Doc
where a.downloadUrl == doc.downloadUrl
select a).ToList();
if (docs.Count == 0)
{
aG.Game_Doc.Add(doc);
aG.SaveChanges();
aG.Dispose();
}
}
}
