public ActionResult DeleteConfirmed(int id) { BoardgamePublisher boardgamePublisher = db.BoardgamePublishers.Find(id); db.BoardgamePublishers.Remove(boardgamePublisher); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "BoardgamePublisherID,LocalBoardgameID,LocalPublisherID")] BoardgamePublisher boardgamePublisher) { if (ModelState.IsValid) { db.Entry(boardgamePublisher).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.LocalBoardgameID = new SelectList(db.BoardGames, "LocalBoardgameID", "Thumbnail", boardgamePublisher.LocalBoardgameID); ViewBag.LocalPublisherID = new SelectList(db.Publishers, "LocalPublisherID", "PublisherName", boardgamePublisher.LocalPublisherID); return(View(boardgamePublisher)); }
// GET: BoardgamePublishers/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BoardgamePublisher boardgamePublisher = db.BoardgamePublishers.Find(id); if (boardgamePublisher == null) { return(HttpNotFound()); } return(View(boardgamePublisher)); }
// GET: BoardgamePublishers/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BoardgamePublisher boardgamePublisher = db.BoardgamePublishers.Find(id); if (boardgamePublisher == null) { return(HttpNotFound()); } ViewBag.LocalBoardgameID = new SelectList(db.BoardGames, "LocalBoardgameID", "Thumbnail", boardgamePublisher.LocalBoardgameID); ViewBag.LocalPublisherID = new SelectList(db.Publishers, "LocalPublisherID", "PublisherName", boardgamePublisher.LocalPublisherID); return(View(boardgamePublisher)); }
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); }