public UsersController( BookStoresDBContext context, IOptions <JWTSettings> jWTSettings) { _context = context; _jWTSettings = jWTSettings.Value; }
public IEnumerable <Author> Get() { using (var context = new BookStoresDBContext()) { //Get all authors //return context.Author.ToList(); //Add author //Author author = new Author(); //author.FirstName = "Kaustubh"; //author.LastName = "Sonar"; //author.EmailAddress = "*****@*****.**"; //context.Author.Add(author); //context.SaveChanges(); //Update //Author author1 = context.Author.Where(auth => auth.FirstName == "Kaustubh").FirstOrDefault(); //author1.Phone = "123-131-131"; //context.SaveChanges(); //delete //Author author2 = context.Author.Where(auth => auth.FirstName == "Kaustubh").FirstOrDefault(); //context.Remove(author2); //context.SaveChanges(); //Get by Id return(context.Authors.Where(auth => auth.FirstName == "Kaustubh").ToList()); } }
public IEnumerable <Author> Get() { using (var _context = new BookStoresDBContext()) // Instans { //get all authors //return context.Author.ToList(); // add an author in my database //Author author = new Author(); // add an author in my database //author.FirstName = "John"; // add an author in my database //author.LastName = "Smith"; // add an author in my database //context.Author.Add(author); // add an author in my database Author author = _context.Author.Where(auth => auth.FirstName == "John").FirstOrDefault(); author.Phone = "777-777-7777"; _context.SaveChanges(); // add an author in my database // get author by id return(_context.Author.Where(auth => auth.FirstName == "John").ToList()); } }
public BasicAuthenticationHandlers( IOptionsMonitor <AuthenticationSchemeOptions> options, ILoggerFactory logger, UrlEncoder encoder, ISystemClock clock, BookStoresDBContext context) : base(options, logger, encoder, clock) { _context = context; }
public IEnumerable <Publisher> Get() { //CRUD using (var _context = new BookStoresDBContext()) { //Publisher publisher = new Publisher(); //publisher.PublisherName = "Egmont Book"; //_context.Publishers.Add(publisher); //_context.SaveChanges(); Publisher publisher = _context.Publishers.FirstOrDefault(); //publisher.PublisherName = "Egmond Books"; _context.Publishers.Remove(publisher); _context.SaveChanges(); return(_context.Publishers.ToList()); } }
public IEnumerable <Publisher> Get() { using (var _context = new BookStoresDBContext()) { //Publisher publisher = new Publisher(); //publisher.PublisherName = "Max Payne"; //_context.Publishers.Add(publisher); //_context.SaveChanges(); //Update first publisher always......................................... //Publisher publisher = _context.Publishers.FirstOrDefault(); //publisher.PublisherName = "Max Payne II"; //_context.SaveChanges(); //Remove the first publisher in the list always...................................... Publisher publisher = _context.Publishers.FirstOrDefault(); _context.Publishers.Remove(publisher); _context.SaveChanges(); return(_context.Publishers.ToList()); } }
public IEnumerable <Author> Get() { using (var context = new BookStoresDBContext()) { // Get All // return context.Author.ToList(); // Add an author /*Author author = new Author(); * * author.FirstName = "John"; * author.LastName = "Smith"; * author.Phone = "123-456-7890"; * author.State = "FL"; * author.Zip = "12345"; * * context.Author.Add(author); * * context.SaveChanges();*/ Author author = context.Author.Where(auth => auth.AuthorId == 25).FirstOrDefault(); /* author.Phone = "111-111-1111"; * * context.Author.Update(author); * * context.SaveChanges();*/ // Get bi Id // return context.Author.Where(auth => auth.AuthorId == 4).ToList(); context.Author.Remove(author); context.SaveChanges(); return(context.Author.ToList()); } }
public IEnumerable <Author> Get() { using (var context = new BookStoresDBContext()) { // Get all authors ****************** return(context.Authors.ToList()); // Get author by id ****************** //return context.Authors.Where(auth => auth.AuthorId == 1).ToList(); // To add an author ****************** //Author author = new Author(); //author.FirstName = "John"; //author.LastName = "Smith"; //context.Authors.Add(author); //context.SaveChanges(); // return context.Authors.Where(auth => auth.FirstName == "John").ToList(); // To update the author ****************** //Author author = context.Authors.Where(auth => auth.FirstName == "John").FirstOrDefault(); //author.Phone = "777-777-7777"; //context.SaveChanges(); // return context.Authors.Where(auth => auth.FirstName == "John").ToList(); // To remove author //Author author = context.Authors.Where(auth => auth.FirstName == "John").FirstOrDefault(); //context.Authors.Remove(author); //context.SaveChanges(); //return context.Authors.Where(auth => auth.FirstName == "John").ToList(); } }
public PublishersController(BookStoresDBContext context) { _context = context; }
public StoresController(BookStoresDBContext context) { _context = context; }
public AuthorsController(BookStoresDBContext context) { this._context = context; }
public AuthorController(BookStoresDBContext context) { _context = context; }
public UsersController(BookStoresDBContext context, JWTSettings jwtSettings) { _context = context; _jWTSettings = jwtSettings; }
public BooksController(BookStoresDBContext context, IDistributedCache distributedCache) { _context = context; this.distributedCache = distributedCache; }
public AuthorController(BookStoresDBContext bookStoresDBContext) { _bookStoresDBContext = bookStoresDBContext; }
public BooksAuthorsController(BookStoresDBContext context) { _context = context; }