public ActionResult DeleteConfirmed(string id)
{
RankHistory rankHistory = db.RankHistories.Find(id);
db.RankHistories.Remove(rankHistory);
db.SaveChanges();
return(RedirectToAction("Index"));
}
/// <summary>
/// Saves a ranking history record for a player
/// </summary>
public Task SaveRankHistory(Team team)
{
var rankHistory = new RankHistory {
Team = team, Rank = team.CurrentRank, Date = DateTime.Now
};
_gameOnContext.RankHistory.Add(rankHistory);
return(_gameOnContext.SaveChangesAsync());
}
public ActionResult Edit([Bind(Include = "HistoryID,StudentID,RankID,RankDate")] RankHistory rankHistory)
{
if (ModelState.IsValid)
{
db.Entry(rankHistory).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.RankID = new SelectList(db.Ranks, "RankID", "BeltColor", rankHistory.RankID);
ViewBag.StudentID = new SelectList(db.Students, "StudentID", "FirstName", rankHistory.StudentID);
return(View(rankHistory));
}
// GET: RankHistories/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RankHistory rankHistory = db.RankHistories.Find(id);
if (rankHistory == null)
{
return(HttpNotFound());
}
return(View(rankHistory));
}
// GET: RankHistories/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RankHistory rankHistory = db.RankHistories.Find(id);
if (rankHistory == null)
{
return(HttpNotFound());
}
ViewBag.RankID = new SelectList(db.Ranks, "RankID", "BeltColor", rankHistory.RankID);
ViewBag.StudentID = new SelectList(db.Students, "StudentID", "FirstName", rankHistory.StudentID);
return(View(rankHistory));
}
public async Task <ActionResult> GetPlayerRanksAsync()
{
foreach (var player in db.Players.ToList())
{
// Get an Overwatch player object from Overwatch.NET
var op = await GetOverwatchPlayer(player);
// Create a new RankHistory row object to be added to dbo.RankHistory
var rh = new RankHistory(short.Parse(op.CompetitiveRank.ToString()), DateTime.Now.AddHours(10));
// Add the RankHistory row
player.RankHistory.Add(rh);
// Update the database
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
/// <summary>
/// Adds a Player, returning the new ID
/// </summary>
/// <param name="player">A Player DTO</param>
public async Task <int> AddPlayer(Player player)
{
if (player.Id != 0)
{
throw new InvalidOperationException("Don't use the AddPlayer method to update a player. Use EditPlayer instead");
}
await _gameOnContext.Players.AddAsync(player);
var newTeam = new Team();
newTeam.CurrentRank = 1000;
newTeam.IsDouble = false;
newTeam.Name = player.Name;
var rankHistory = new RankHistory {
Team = newTeam, Rank = newTeam.CurrentRank, Date = DateTime.Now
};
await _gameOnContext.RankHistory.AddAsync(rankHistory);
await _gameOnContext.SaveChangesAsync();
return(player.Id);
}
public static void Initialize(BoooksContext context)
{
context.Database.EnsureCreated();
// Look for any Books.
if (context.Books.Any())
{
return; // DB has been seeded
}
//Book[] books = new Book[0];
var booksId = 1;
var ISBNId = 1;
var RankID = 1;
// Get json result
// Fetch first 200 responses from API and offset is used to get the next 20 response from the api.
JObject json = GetBooksData.GetBestSellerItems(200);
// Get Results Array from Json
var results = json["results"];
foreach (JObject ele in results)
{
// Data for Books
var title = ele["title"];
var description = ele["description"];
var author = ele["author"];
var publisher = ele["publisher"];
var book = new Book();
book.Title = (String)title;
book.Description = (String)description;
book.Author = (String)author;
book.Publisher = (String)publisher;
book.BookId = booksId.ToString();
Console.WriteLine(book);
context.Books.Add(book);
context.SaveChanges();
// Data for ISBN
var isbns = ele["isbns"];
var isbn = new ISBN();
if (isbns.HasValues)
{
var isbn10 = isbns[0]["isbn10"];
var isbn13 = isbns[0]["isbn13"];
isbn.BookId = booksId.ToString();
isbn.ISBNId = ISBNId.ToString();
isbn.Isbn10 = (String)isbn10;
isbn13 = (String)isbn13;
context.ISBNs.Add(isbn);
context.SaveChanges();
ISBNId += 1;
}
// Data for rank histories
var rankhistories = ele["ranks_history"];
foreach (JObject rankHistoryele in rankhistories)
{
var rank = (String)rankHistoryele["rank"];
var listName = (String)rankHistoryele["list_name"];
var weeksOnList = (String)rankHistoryele["weeks_on_list"];
var rankHistory = new RankHistory();
rankHistory.ID = RankID.ToString();
rankHistory.BookId = booksId.ToString();
rankHistory.Rank = (String)rank;
rankHistory.ListName = (String)listName;
rankHistory.WeeksOnList = (String)weeksOnList;
context.RankHistories.Add(rankHistory);
context.SaveChanges();
RankID += 1;
}
booksId += 1;
}
}
