public async Task <IActionResult> Create([Bind("FirstName, LastName")] Author author)
{
using (EFCoreWebDemoContext context = new EFCoreWebDemoContext())
{
//context.Add(author);
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter {
ParameterName = "@AuthorId", SqlDbType = SqlDbType.Int, Direction = ParameterDirection.Output
},
new SqlParameter {
ParameterName = "@FirstName", SqlDbType = SqlDbType.VarChar, Size = 50, Direction = ParameterDirection.Input, SqlValue = author.FirstName
},
new SqlParameter {
ParameterName = "@LastName", SqlDbType = SqlDbType.VarChar, Size = 75, Direction = ParameterDirection.Input, SqlValue = author.LastName
}
};
try
{
context.Database.ExecuteSqlRaw("Exec AuthorSave @AuthorId OUT, @FirstName, @LastName", parameters);
}
catch (System.Exception e)
{
//log error
ModelState.TryAddModelError("AddingAuthor", e.Message);
}
object returnvalue = parameters[0].Value;
if (returnvalue != null && int.TryParse(returnvalue.ToString(), out int AuthorId) && AuthorId > 0)
{
//Log success message;
}
//await context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
}
public string[] Get()
{
using (var context = new EFCoreWebDemoContext())
{
return(context.ListName.Select(r => r.Title).ToArray());
}
}
// GET: Books/Edit/5
public async Task <IActionResult> Edit(int?id)
{
if (id == null)
{
return(NotFound());
}
using (var _context = new EFCoreWebDemoContext())
{
var book = await _context.Books.FindAsync(id);
if (book == null)
{
return(NotFound());
}
var authors = await _context.Authors.Select(a => new SelectListItem
{
Value = a.AuthorId.ToString(),
Text = $"{a.FirstName} {a.LastName}"
}).ToListAsync();
ViewBag.Authors = authors;
//ViewData["AuthorId"] = new SelectList(_context.Authors, "AuthorId", "AuthorId", book.AuthorId);
return(View(book));
}
}
public async Task <IActionResult> Edit(int id, [Bind("AuthorId,FirstName,LastName")] Author author)
{
if (id != author.AuthorId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
using (var context = new EFCoreWebDemoContext())
{
context.Update(author);
await context.SaveChangesAsync();
}
}
catch (DbUpdateConcurrencyException)
{
if (!AuthorExists(author.AuthorId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
//return View(author);
return(RedirectToAction("Index"));
}
private bool BookExists(int id)
{
using (var _context = new EFCoreWebDemoContext())
{
return(_context.Books.Any(e => e.BookId == id));
}
}
private bool AuthorExists(int id)
{
using (var context = new EFCoreWebDemoContext())
{
return(context.Authors.Any(e => e.AuthorId == id));
}
}
public ActionResult <string> Get(int id)
{
using (var context = new EFCoreWebDemoContext())
{
return(context.ListName.Where(r => r.ListId == id).Select(r => r.Title).First());
}
}
public async Task <IActionResult> Index()
{
using (var context = new EFCoreWebDemoContext())
{
var model = await _iBookServices.GetAll();
return(View(model));
}
}
public async Task <IActionResult> Index()
{
using (EFCoreWebDemoContext context = new EFCoreWebDemoContext())
{
System.Collections.Generic.List <Author> model = await context.Authors.Include(a => a.Books).AsNoTracking().ToListAsync();
return(View(model));
}
}
public async Task <List <Book> > GetAll()
{
using (var context = new EFCoreWebDemoContext())
{
var model = await context.Books.ToListAsync();
return(model);
}
}
public async Task <IActionResult> Index()
{
using (var context = new EFCoreWebDemoContext())
{
var model = await context.Authors.Include(a => a.Books).AsNoTracking().ToListAsync();
return(View(model));
}
}
public async Task <Book> GetBookById(int id)
{
using (var context = new EFCoreWebDemoContext())
{
var model = await context.Books.FirstOrDefaultAsync(x => x.BookId == id);
return(model);
}
}
public async Task <IActionResult> Create([Bind("Title, AuthorId")] Book book)
{
using (var context = new EFCoreWebDemoContext())
{
context.Books.Add(book);
await context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
}
public async Task <IActionResult> Create([Bind("FirstName, LastName")] Author author)
{
using (var context = new EFCoreWebDemoContext())
{
context.Add(author);
await context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
}
public async Task <IActionResult> DeleteConfirmed(int id)
{
using (var _context = new EFCoreWebDemoContext())
{
var book = await _context.Books.FindAsync(id);
_context.Books.Remove(book);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
}
public async Task <IActionResult> DeleteConfirmed(int id)
{
using (var context = new EFCoreWebDemoContext())
{
var author = await context.Authors.FindAsync(id);
context.Authors.Remove(author);
await context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
}
public async Task <IActionResult> Create()
{
using (var context = new EFCoreWebDemoContext())
{
var authors = await context.Authors.Select(a => new SelectListItem {
Value = a.AuthorId.ToString(),
Text = $"{a.FirstName} {a.LastName}"
}).ToListAsync();
ViewBag.Authors = authors;
}
return(View());
}
// GET: Author/Edit/5
public async Task <IActionResult> Edit(int?id)
{
if (id == null)
{
return(NotFound());
}
using (var context = new EFCoreWebDemoContext())
{
var author = await context.Authors.FindAsync(id);
if (author == null)
{
return(NotFound());
}
return(View(author));
}
}
// GET: Author/Delete/5
public async Task <IActionResult> Delete(int?id)
{
if (id == null)
{
return(NotFound());
}
using (var context = new EFCoreWebDemoContext())
{
var author = await context.Authors
.FirstOrDefaultAsync(m => m.AuthorId == id);
if (author == null)
{
return(NotFound());
}
return(View(author));
}
}
// GET: Books/Details/5
public async Task <IActionResult> Details(int?id)
{
if (id == null)
{
return(NotFound());
}
using (var _context = new EFCoreWebDemoContext())
{
var book = await _context.Books
.Include(b => b.Author)
.FirstOrDefaultAsync(m => m.BookId == id);
if (book == null)
{
return(NotFound());
}
return(View(book));
}
}
protected override void Seed()
{
using (var context = new EFCoreWebDemoContext())
{
context.Add(new AuctionItems
{
auctionItemId = 1234,
BidderName = "XYZ industries",
CurrentBid = 0,
reservePrice = 100,
maxAutoBidAmountmax = 10
});
context.Add(new AuctionItems
{
auctionItemId = 1233,
BidderName = "AMC industries",
CurrentBid = 10,
reservePrice = 1200,
maxAutoBidAmountmax = 1120
});
context.Add(new AuctionItems
{
auctionItemId = 443,
BidderName = "AMC industries",
CurrentBid = 1001,
reservePrice = 12200,
maxAutoBidAmountmax = 11320
});
context.Add(new AuctionItems
{
auctionItemId = 555,
BidderName = "AMC industries",
CurrentBid = 10,
reservePrice = 12010,
maxAutoBidAmountmax = 11220
});
}
}
public async Task <IActionResult> Create([Bind("Title, AuthorId")] Book book)
{
if (ModelState.IsValid)
{
using (var _context = new EFCoreWebDemoContext())
{
_context.Add(book);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
}
using (var _context = new EFCoreWebDemoContext())
{
ViewData["AuthorId"] = new SelectList(_context.Authors, "AuthorId", "AuthorId", book.AuthorId);
}
return(View(book));
//using (var context = new EFCoreWebDemoContext())
//{
// context.Books.Add(book);
// await context.SaveChangesAsync();
// return RedirectToAction("Index");
//}
}
public async Task <IActionResult> Edit(int id, [Bind("BookId,Title,AuthorId")] Book book)
{
if (id != book.BookId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
using (var _context = new EFCoreWebDemoContext())
{
_context.Update(book);
await _context.SaveChangesAsync();
}
}
catch (DbUpdateConcurrencyException)
{
if (!BookExists(book.BookId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
using (var _context = new EFCoreWebDemoContext())
{
ViewData["AuthorId"] = new SelectList(_context.Authors, "AuthorId", "AuthorId", book.AuthorId);
}
return(View(book));
}
public StarWarsEFService(EFCoreWebDemoContext context)
{
_context = context;
}
