public ActionResult DeleteConfirmed(int id)
{
BoardgameArtist boardgameArtist = db.BoardgameArtists.Find(id);
db.BoardgameArtists.Remove(boardgameArtist);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "BoardgameArtistID,LocalBoardgameID,LocalArtistID")] BoardgameArtist boardgameArtist)
{
if (ModelState.IsValid)
{
db.Entry(boardgameArtist).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.LocalArtistID = new SelectList(db.Artists, "LocalArtistID", "ArtistName", boardgameArtist.LocalArtistID);
ViewBag.LocalBoardgameID = new SelectList(db.BoardGames, "LocalBoardgameID", "Thumbnail", boardgameArtist.LocalBoardgameID);
return(View(boardgameArtist));
}
// GET: BoardgameArtists/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BoardgameArtist boardgameArtist = db.BoardgameArtists.Find(id);
if (boardgameArtist == null)
{
return(HttpNotFound());
}
return(View(boardgameArtist));
}
// GET: BoardgameArtists/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BoardgameArtist boardgameArtist = db.BoardgameArtists.Find(id);
if (boardgameArtist == null)
{
return(HttpNotFound());
}
ViewBag.LocalArtistID = new SelectList(db.Artists, "LocalArtistID", "ArtistName", boardgameArtist.LocalArtistID);
ViewBag.LocalBoardgameID = new SelectList(db.BoardGames, "LocalBoardgameID", "Thumbnail", boardgameArtist.LocalBoardgameID);
return(View(boardgameArtist));
}
public static BoardGame GetBoardByID(int id)
{
BoardGame foundBoard = new BoardGame();
var result = from res in db.BoardGames where res.BoardgameID == id select res;
foundBoard = result.FirstOrDefault();
if (foundBoard == null)
{
BGGBoard bggBoard = BGGConnector.Connector.GetBoardById(id.ToString());
if (bggBoard != null)
{
foundBoard = new BoardGame();
foundBoard.BoardgameID = Int32.Parse(bggBoard.Id);
foundBoard.Title = bggBoard.Name[0].Value;
foundBoard.Thumbnail = bggBoard.Thumbnail;
foundBoard.Image = bggBoard.Image;
foundBoard.Description = bggBoard.Description;
foundBoard.MinAge = Int32.Parse(bggBoard.Minage.Value);
foundBoard.PublicationYear = Int32.Parse(bggBoard.Yearpublished.Value);
foundBoard.PlayingTime = Int32.Parse(bggBoard.Playingtime.Value);
foundBoard.MinPlayTime = Int32.Parse(bggBoard.Minplaytime.Value);
foundBoard.MinPlayers = Int32.Parse(bggBoard.Minplayers.Value);
foundBoard.MaxPlayTime = Int32.Parse(bggBoard.Maxplaytime.Value);
foundBoard.MaxPlayers = Int32.Parse(bggBoard.Maxplayers.Value);
db.BoardGames.Add(foundBoard);
db.SaveChanges();
foundBoard = (from bor in db.BoardGames where bor.BoardgameID == foundBoard.BoardgameID select bor).FirstOrDefault();
List <Category> categories = new List <Category>();
List <Designer> designers = new List <Designer>();
List <Artist> artists = new List <Artist>();
List <Publisher> publishers = new List <Publisher>();
List <Family> families = new List <Family>();
List <Expansion> expansions = new List <Expansion>();
List <Mechanic> mechanics = new List <Mechanic>();
List <Implementation> implementations = new List <Implementation>();
foreach (Link link in bggBoard.Link)
{
if (link.Type == "boardgamecategory")
{
categories.Add(new Category()
{
CategoryID = Int32.Parse(link.Id), CategoryName = link.Value
});
}
else if (link.Type == "boardgamedesigner")
{
designers.Add(new Designer()
{
DesignerID = Int32.Parse(link.Id), DesignerName = link.Value
});
}
else if (link.Type == "boardgameartist")
{
artists.Add(new Artist()
{
ArtistID = Int32.Parse(link.Id), ArtistName = link.Value
});
}
else if (link.Type == "boardgamepublisher")
{
publishers.Add(new Publisher()
{
PublisherID = Int32.Parse(link.Id), PublisherName = link.Value
});
}
else if (link.Type == "boardgamefamily")
{
families.Add(new Family()
{
FamilyID = Int32.Parse(link.Id), FamilyName = link.Value
});
}
else if (link.Type == "boardgameexpansion")
{
expansions.Add(new Expansion()
{
ExpansionID = Int32.Parse(link.Id), ExpansionName = link.Value
});
}
else if (link.Type == "boardgamemechanic")
{
mechanics.Add(new Mechanic()
{
MechanicID = Int32.Parse(link.Id), MechanicName = link.Value
});
}
else if (link.Type == "boardgameimplementation")
{
implementations.Add(new Implementation()
{
ImplementationID = Int32.Parse(link.Id), ImplementedBy = link.Value
});
}
}
if (categories.Count != 0)
{
foreach (Category cat in categories)
{
Category foundCategory = (from find in db.Categories where find.CategoryID == cat.CategoryID select find).FirstOrDefault();
if (foundCategory == null)
{
List <BGGBoard> res = BGGConnector.Connector.GetBoardsByName(cat.CategoryName, "boardgamecategory");
if (res.Count > 0)
{
foundCategory = new Category()
{
CategoryID = Int32.Parse(res[0].Id), CategoryName = res[0].Name[0].Value
};
db.Categories.Add(foundCategory);
db.SaveChanges();
foundCategory = (from findCat in db.Categories where findCat.CategoryID == cat.CategoryID select findCat).FirstOrDefault();
}
}
if (foundCategory != null)
{
BoardgameCategory boardgameCategory = new BoardgameCategory()
{
Category = foundCategory, BoardGame = foundBoard
};
db.BoardgameCategories.Add(boardgameCategory);
db.SaveChanges();
}
}
}
if (designers.Count != 0)
{
foreach (Designer des in designers)
{
Designer foundDesigner = (from find in db.Designers where find.DesignerID == des.DesignerID select find).FirstOrDefault();
if (foundDesigner == null)
{
List <BGGBoard> res = BGGConnector.Connector.GetBoardsByName(des.DesignerName, "boardgamedesigner");
if (res.Count > 0)
{
foundDesigner = new Designer()
{
DesignerID = Int32.Parse(res[0].Id), DesignerName = res[0].Name[0].Value
};
db.Designers.Add(foundDesigner);
db.SaveChanges();
foundDesigner = (from findCat in db.Designers where findCat.DesignerID == des.DesignerID select findCat).FirstOrDefault();
}
}
if (foundDesigner != null)
{
BoardgameDesigner boardgameDesigner = new BoardgameDesigner()
{
Designer = foundDesigner, BoardGame = foundBoard
};
db.BoardgameDesigners.Add(boardgameDesigner);
db.SaveChanges();
}
}
}
if (artists.Count != 0)
{
foreach (Artist art in artists)
{
Artist foundArtist = (from find in db.Artists where find.ArtistID == art.ArtistID select find).FirstOrDefault();
if (foundArtist == null)
{
List <BGGBoard> res = BGGConnector.Connector.GetBoardsByName(art.ArtistName, "boardgameartist");
if (res.Count > 0)
{
foundArtist = new Artist()
{
ArtistID = Int32.Parse(res[0].Id), ArtistName = res[0].Name[0].Value
};
db.Artists.Add(foundArtist);
db.SaveChanges();
foundArtist = (from findCat in db.Artists where findCat.ArtistID == art.ArtistID select findCat).FirstOrDefault();
}
}
if (foundBoard != null)
{
BoardgameArtist boardgameArtist = new BoardgameArtist()
{
Artist = foundArtist, BoardGame = foundBoard
};
db.BoardgameArtists.Add(boardgameArtist);
db.SaveChanges();
}
}
}
if (publishers.Count != 0)
{
foreach (Publisher pub in publishers)
{
Publisher foundPublisher = (from find in db.Publishers where find.PublisherID == pub.PublisherID select find).FirstOrDefault();
if (foundPublisher == null)
{
List <BGGBoard> res = BGGConnector.Connector.GetBoardsByName(pub.PublisherName, "boardgamepublisher");
if (res.Count > 0)
{
foundPublisher = new Publisher()
{
PublisherID = Int32.Parse(res[0].Id), PublisherName = res[0].Name[0].Value
};
db.Publishers.Add(foundPublisher);
db.SaveChanges();
foundPublisher = (from findCat in db.Publishers where findCat.PublisherID == pub.PublisherID select findCat).FirstOrDefault();
}
}
if (foundPublisher != null)
{
BoardgamePublisher boardgamePublisher = new BoardgamePublisher()
{
Publisher = foundPublisher, BoardGame = foundBoard
};
db.BoardgamePublishers.Add(boardgamePublisher);
db.SaveChanges();
}
}
}
if (families.Count != 0)
{
foreach (Family fam in families)
{
Family foundFamily = (from find in db.Families where find.FamilyID == fam.FamilyID select find).FirstOrDefault();
if (foundFamily == null)
{
List <BGGBoard> res = BGGConnector.Connector.GetBoardsByName(fam.FamilyName, "boardgamefamily");
if (res.Count > 0)
{
foundFamily = new Family()
{
FamilyID = Int32.Parse(res[0].Id), FamilyName = res[0].Name[0].Value
};
db.Families.Add(foundFamily);
db.SaveChanges();
foundFamily = (from findCat in db.Families where findCat.FamilyID == fam.FamilyID select findCat).FirstOrDefault();
}
}
if (foundFamily != null)
{
BoardgameFamily boardgameFamily = new BoardgameFamily()
{
Family = foundFamily, BoardGame = foundBoard
};
db.BoardgameFamilies.Add(boardgameFamily);
db.SaveChanges();
}
}
}
if (expansions.Count != 0)
{
foreach (Expansion exp in expansions)
{
Expansion foundExpansion = (from find in db.Expansions where find.ExpansionID == exp.ExpansionID select find).FirstOrDefault();
if (foundExpansion == null)
{
List <BGGBoard> res = BGGConnector.Connector.GetBoardsByName(exp.ExpansionName, "boardgameexpansion");
if (res.Count > 0)
{
foundExpansion = new Expansion()
{
ExpansionID = Int32.Parse(res[0].Id), ExpansionName = res[0].Name[0].Value
};
db.Expansions.Add(foundExpansion);
db.SaveChanges();
foundExpansion = (from findCat in db.Expansions where findCat.ExpansionID == exp.ExpansionID select findCat).FirstOrDefault();
}
}
if (foundExpansion != null)
{
BoardgameExpansion boardgameExpansion = new BoardgameExpansion()
{
Expansion = foundExpansion, BoardGame = foundBoard
};
db.BoardgameExpansions.Add(boardgameExpansion);
db.SaveChanges();
}
}
}
if (mechanics.Count != 0)
{
foreach (Mechanic mech in mechanics)
{
Mechanic foundExpansion = (from find in db.Mechanics where find.MechanicID == mech.MechanicID select find).FirstOrDefault();
if (foundExpansion == null)
{
List <BGGBoard> res = BGGConnector.Connector.GetBoardsByName(mech.MechanicName, "boardgamemechanic");
if (res.Count > 0)
{
foundExpansion = new Mechanic()
{
MechanicID = Int32.Parse(res[0].Id), MechanicName = res[0].Name[0].Value
};
db.Mechanics.Add(foundExpansion);
db.SaveChanges();
foundExpansion = (from findCat in db.Mechanics where findCat.MechanicID == mech.MechanicID select findCat).FirstOrDefault();
}
}
if (foundExpansion != null)
{
BoardgameMechanic boardgameMechanic = new BoardgameMechanic()
{
Mechanic = foundExpansion, BoardGame = foundBoard
};
db.BoardgameMechanics.Add(boardgameMechanic);
db.SaveChanges();
}
}
}
if (implementations.Count != 0)
{
foreach (Implementation imp in implementations)
{
Implementation foundImplementation = (from find in db.Implementations where find.ImplementationID == imp.ImplementationID select find).FirstOrDefault();
if (foundImplementation == null)
{
List <BGGBoard> res = BGGConnector.Connector.GetBoardsByName(imp.ImplementedBy, "boardgameimplementation");
if (res.Count > 0)
{
foundImplementation = new Implementation()
{
ImplementationID = Int32.Parse(res[0].Id), ImplementedBy = res[0].Name[0].Value
};
db.Implementations.Add(foundImplementation);
db.SaveChanges();
foundImplementation = (from findCat in db.Implementations where findCat.ImplementationID == imp.ImplementationID select findCat).FirstOrDefault();
}
}
if (foundImplementation != null)
{
BoardgameImplementation boardgameImplementation = new BoardgameImplementation()
{
Implementation = foundImplementation, BoardGame = foundBoard
};
db.BoardgameImplementations.Add(boardgameImplementation);
db.SaveChanges();
}
}
}
}
}
if (foundBoard != null)
{
return(foundBoard);
}
return(null);
}