public async Task <ActionResult <Publisher> > GetPublisherDetails(string PublisherId)
{
//Eager Loading
//var publisher = await _context.Publishers
// .Include(pub => pub.Users)
// .Include(pub => pub.Books)
// .ThenInclude(book => book.Sales)
// .Where(pub => pub.PubId == id)
// .FirstOrDefaultAsync();
//Explicit Loading
var publisher = await _context.Publishers.SingleAsync(pub => pub.PubId == Convert.ToInt32(PublisherId));
_context.Entry(publisher)
.Collection(pub => pub.Users)
.Query()
.Where(usr => usr.EmailAddress.Contains("karin"))
.Load();
_context.Entry(publisher)
.Collection(pub => pub.Books)
.Query()
.Include(book => book.Sales)
.Load();
if (publisher == null)
{
return(NotFound());
}
return(publisher);
}
public bool Edit(Guid id, Company item)
{
var company = Detail(id);
if (company != null)
{
company.IsActive = item.IsActive;
_context.Entry(company).State = EntityState.Modified;
return _context.SaveChanges() > 0;
}
return false;
}
public async Task <IActionResult> PutUsers(int id, Users users)
{
if (id != users.Id)
{
return(BadRequest());
}
_dbContext.Entry(users).State = EntityState.Modified;
try
{
await _dbContext.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!UsersExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> PutAuthor(int id, Author author)
{
if (id != author.Id)
{
return(BadRequest());
}
_context.Entry(author).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AuthorExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> PutSale(int id, Sale sale)
{
if (id != sale.SaleId)
{
return(BadRequest());
}
_context.Entry(sale).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SaleExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public ActionResult Edit([Bind(Include = "Id,Name")] Author author)
{
if (ModelState.IsValid)
{
db.Entry(author).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(author));
}
public ActionResult Edit([Bind(Include = "Id,Title,Year,AuthorId")] Book book)
{
if (ModelState.IsValid)
{
db.Entry(book).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AuthorId = new SelectList(db.Authors, "Id", "Id", book.AuthorId);
return(View(book));
}
public async Task <IActionResult> PutBook(int id, Book book)
{
if (id != book.Id)
{
return(BadRequest());
}
_context.Entry(book).State = EntityState.Modified;
await _context.SaveChangesAsync();
return(NoContent());
}
public IActionResult Update(int id, string phonenumber)
{
try
{
var author = new Author()
{
AuthorId = id,
Phone = phonenumber
};
_context.Author.Attach(author);
_context.Entry(author).Property(a => a.Phone).IsModified = true;
_context.SaveChanges();
}
catch (Exception ex)
{
_logger.LogInformation($"HELLO FROM api/authos/{id}/update/{phonenumber}");
return(BadRequest(ex.Message));
}
return(Ok());
}
public bool UpdateUserToken(int id, string token, DateTime expiredDate)
{
if (id > 0 && string.IsNullOrEmpty(token))
{
return(false);
}
var getUser = _context.Users.SingleOrDefault(x => x.Id == id);
if (getUser == null)
{
return(false);
}
getUser.Token = token;
getUser.ExpiredDate = expiredDate;
_context.Entry(getUser).State = EntityState.Modified;
return(_context.SaveChanges() > 0);
}
public ActionResult Edit(order order)
{
BookStoreDB.Entry(order).State = System.Data.Entity.EntityState.Modified;
BookStoreDB.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <int> Update(int?id, Books books)
{
_dbContext.Entry(books).State = EntityState.Modified;
return(await _dbContext.SaveChangesAsync());
}