public ActionResult Create([Bind(Include = "Id,Name,Designer,PlayTime,CoreMechanic,MinPlayers,MaxPlayers,Weight,Rating")] Game game)
{
if (ModelState.IsValid)
{
db.Games.Add(game);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(game));
}
public IActionResult Deletesong(int id)
{
var song = context.Songs.Find(id);
if (song == null)
{
return(NotFound());
}
context.Songs.Remove(song);
context.SaveChanges();
return(NoContent());
}
public IActionResult DeleteAlbum(int id)
{
var album = context.Albums.Find(id);
if (album == null)
{
return(NotFound());
}
context.Albums.Remove(album);
context.SaveChanges();
return(NoContent());
}
public IActionResult Create([FromBody] Artist artist)
{
if (artist == null)
{
return(BadRequest());
}
// Set created to now
artist.Created = DateTime.Now;
_context.Artist.Add(artist);
_context.SaveChanges();
// Set location in header to the "GetArtist" route. So we return the created object
return(CreatedAtRoute("GetArtist", new { id = artist.Id }, artist));
}
public ArtistController(CollectionContext context)
{
_context = context;
if (_context.Artist.Count() == 0)
{
_context.Artist.Add(new Artist {
Name = "Exodus"
});
_context.SaveChanges();
}
}
public static void CreateDeck()
{
using (var db = new CollectionContext())
{
User demoUser = new User()
{
UserName = "******", Password = "******"
};
db.Users.Add(demoUser);
db.SaveChanges();
}
}
public JsonResult PostCollection([FromBody] Collection collection)
{
try
{
if (collection is not null)
{
db.Collections.Add(collection);
db.SaveChanges();
}
return(Json(collection));
} catch (SqlException e)
{
return(Json(e.Message));
}
}
//TODO: Do at startup
public static void addToDb()
{
using (var db = new CollectionContext())
{
using (var httpclient = new WebClient())
{
var jsonData = httpclient.DownloadString("https://mtgjson.com/json/Standard.json");
var model = JsonConvert.DeserializeObject <Carddata>(jsonData);
var data = from i in model.M19.cards
select i;
foreach (var q in data)
{
db.Cards.Add(new Card()
{
name = q.name,
artist = q.artist,
colors = q.colors,
convertedManaCost = q.convertedManaCost,
manaCost = q.manaCost,
multiverseId = q.multiverseId,
loyalty = q.loyalty,
number = q.number,
rarity = q.rarity,
scryfallId = q.scryfallId,
scryfallIllustrationId = q.scryfallIllustrationId,
scryfallOracleId = q.scryfallOracleId,
subtype = q.subtype,
supertype = q.supertype,
text = q.text,
type = q.type,
types = q.types,
uuid = q.uuid,
uuidV421 = q.uuidV421,
power = q.power,
toughness = q.toughness
});
db.SaveChanges();
}
}
}
}
public ActionResult Create(CreateCollectionModel model)
{
CollectionContext context = new CollectionContext();
Models.Collections collections = new Collections();
LikesContext likesContext = new LikesContext();
Like like = new Like();
List <Collections> listCol = context.Collections.ToList();
List <Like> listLike = likesContext.Like.ToList();
if (context.Collections.Count() >= 1)
{
collections.Id = listCol[listCol.Count - 1].Id + 1;
}
else
{
collections.Id = 1;
}
if (likesContext.Like.Count() >= 1)
{
like.Id = listLike[listLike.Count - 1].Id + 1;
}
else
{
like.Id = 1;
}
like.CollectionId = collections.Id;
like.Count = 0;
likesContext.Like.Add(like);
likesContext.SaveChanges();
collections.ImgUrl = "https://res.cloudinary.com/coursepoject/image/upload/v1585662014/" + model.image + ".jpg";
collections.Topic = model.Topic;
collections.Description = model.Description;
collections.UserId = CurrentUser.Id;
collections.Name = model.Name;
context.Collections.Add(collections);
context.SaveChanges();
return(View("Collections"));
}