public async Task <IActionResult> Update(Series series) { if (!ModelState.IsValid) { return(BadRequest()); } using (var db = new SakurAniLibContext(this.ConnectionString)) { var updatedSeries = await db.Series.FirstOrDefaultAsync(s => s.Id == series.Id); if (updatedSeries == null) { return(NotFound()); } // update values updatedSeries.Id = series.Id; updatedSeries.Name = series.Name; updatedSeries.Amount = series.Amount; // Save await db.SaveChangesAsync(); return(Ok(series)); } }
public async Task <IEnumerable <Series> > Get() { using (var db = new SakurAniLibContext(this.ConnectionString)) { return(await db.Series.ToListAsync()); } }
public async Task <IActionResult> Update(Genre genre) { if (!ModelState.IsValid) { return(BadRequest()); } using (var db = new SakurAniLibContext(this.ConnectionString)) { var updatedGenre = await db.Genre.FirstOrDefaultAsync(g => g.Id == genre.Id); if (updatedGenre == null) { return(NotFound()); } // update values updatedGenre.Id = genre.Id; updatedGenre.Name = genre.Name; // Save await db.SaveChangesAsync(); return(Ok(genre)); } }
public async Task <IActionResult> Update(Author author) { if (!ModelState.IsValid) { return(BadRequest()); } using (var db = new SakurAniLibContext(this.ConnectionString)) { var updatedAuthor = await db.Author.FirstOrDefaultAsync(a => a.Id == author.Id); if (updatedAuthor == null) { return(NotFound()); } // update values updatedAuthor.Id = author.Id; updatedAuthor.Name = author.Name; updatedAuthor.IsArtist = author.IsArtist; // Save await db.SaveChangesAsync(); return(Ok(author)); } }
public async Task <IActionResult> GetBooksByGenre(string id) { using (var db = new SakurAniLibContext(this.ConnectionString)) { var booksByGenre = new List <Book>(); // Query BookGenre Info from Intersection Table var bookGenreList = await(from b in db.Book_Genre where b.GenreId == id select b).ToListAsync(); if (bookGenreList.Count == 0) { return(NoContent()); } // Get detailed Book info for each isbn foreach (var bookGenre in bookGenreList) { var book = await db.Book.FirstOrDefaultAsync(b => b.Isbn == bookGenre.Isbn); booksByGenre.Add(book); } return(Ok(booksByGenre)); } }
public async Task <IActionResult> Update(Book book) { if (!ModelState.IsValid) { return(BadRequest()); } using (var db = new SakurAniLibContext(this.ConnectionString)) { var updatedBook = await db.Book.FirstOrDefaultAsync(b => b.Isbn == book.Isbn); if (updatedBook == null) { return(NotFound()); } // update values updatedBook.Isbn = book.Isbn; updatedBook.Title = book.Title; updatedBook.Price = book.Price; updatedBook.Picture = book.Picture; updatedBook.SeriesNumber = book.SeriesNumber; updatedBook.Currency = book.Currency; updatedBook.Type = book.Type; // Save await db.SaveChangesAsync(); return(Ok(book)); } }
public async Task <IActionResult> GetAuthor(string id) { using (var db = new SakurAniLibContext(this.ConnectionString)) { var author = await db.Author.FirstOrDefaultAsync(a => a.Id == id); if (author == null) { return(NotFound()); } return(Ok(author)); } }
public async Task <IActionResult> GetBook(string isbn) { using (var db = new SakurAniLibContext(this.ConnectionString)) { var book = await db.Book.FirstOrDefaultAsync(b => b.Isbn == isbn); if (book == null) { return(NotFound()); } return(Ok(book)); } }
public async Task <IActionResult> Create(Series series) { if (!ModelState.IsValid) { return(BadRequest()); } using (var db = new SakurAniLibContext(this.ConnectionString)) { await db.Series.AddAsync(series); await db.SaveChangesAsync(); return(Created($"/api/series/{series.Id}", series)); } }
public async Task <IActionResult> Create(Book_Author book_author) { if (!ModelState.IsValid) { return(BadRequest()); } using (var db = new SakurAniLibContext(this.ConnectionString)) { await db.Book_Author.AddAsync(book_author); await db.SaveChangesAsync(); return(Created($"/api/book_author/{book_author.Id}", book_author)); } }
public async Task <IActionResult> Create(Genre genre) { if (!ModelState.IsValid) { return(BadRequest()); } using (var db = new SakurAniLibContext(this.ConnectionString)) { await db.Genre.AddAsync(genre); await db.SaveChangesAsync(); return(Created($"/api/genre/{genre.Id}", genre)); } }
public async Task <IActionResult> Delete(string id) { using (var db = new SakurAniLibContext(this.ConnectionString)) { var series = await db.Series.FirstOrDefaultAsync(s => s.Id == id); if (series == null) { return(NotFound()); } db.Series.Remove(series); await db.SaveChangesAsync(); return(new NoContentResult()); } }
public async Task <IActionResult> Delete(int id) { using (var db = new SakurAniLibContext(this.ConnectionString)) { var book_author = await db.Book_Author.FirstOrDefaultAsync(b => b.Id == id); if (book_author == null) { return(NotFound()); } db.Book_Author.Remove(book_author); await db.SaveChangesAsync(); return(new NoContentResult()); } }
public async Task <IActionResult> Delete(string id) { using (var db = new SakurAniLibContext(this.ConnectionString)) { var genre = await db.Genre.FirstOrDefaultAsync(g => g.Id == id); if (genre == null) { return(NotFound()); } db.Genre.Remove(genre); await db.SaveChangesAsync(); return(new NoContentResult()); } }
public async Task <IActionResult> Delete(string isbn) { using (var db = new SakurAniLibContext(this.ConnectionString)) { var book = await db.Book.FirstOrDefaultAsync(b => b.Isbn == isbn); if (book == null) { return(NotFound()); } db.Book.Remove(book); await db.SaveChangesAsync(); return(new NoContentResult()); } }