public ActionResult EditBarcode(BarcodesEditBarcodeVM model) { LibraryManagementSystemContext context = new LibraryManagementSystemContext(); BarcodesRepository barcodesRepository = new BarcodesRepository(context); Barcode barcode = null; if (barcodesRepository.GetAll().Any(b => b.BarcodeNumber == model.BarcodeNumber) && model.ID != barcodesRepository.GetAll(filter: b => b.BarcodeNumber == model.BarcodeNumber).FirstOrDefault().ID) { ModelState.AddModelError("BarcodeNumber", "* barcode already exists"); } if (!ModelState.IsValid) { return View(model); } else { if (model.ID > 0) { barcode = barcodesRepository.GetByID(model.ID); } else { barcode = new Barcode(); } barcode.ID = model.ID; barcode.BookID = model.BookID; barcode.BarcodeNumber = model.BarcodeNumber; barcodesRepository.Save(barcode); } return RedirectToAction("ListBookBarcodes/" + barcode.BookID, "Books"); }
public ActionResult DeleteBarcode(int id) { LibraryManagementSystemContext context = new LibraryManagementSystemContext(); BarcodesRepository barcodesRepository = new BarcodesRepository(context); BarcodesDeleteBarcodeVM model = new BarcodesDeleteBarcodeVM(); Barcode barcode = barcodesRepository.GetByID(id); model.ID = barcode.ID; model.BarcodeNumber = barcode.BarcodeNumber; return View(model); }
public ActionResult DeleteBarcode(int id) { LibraryManagementSystemContext context = new LibraryManagementSystemContext(); BarcodesRepository barcodesRepository = new BarcodesRepository(context); BarcodesDeleteBarcodeVM model = new BarcodesDeleteBarcodeVM(); Barcode barcode = barcodesRepository.GetByID(id); model.ID = barcode.ID; model.BarcodeNumber = barcode.BarcodeNumber; return(View(model)); }
public ActionResult DeleteBarcode(BarcodesDeleteBarcodeVM model) { LibraryManagementSystemContext context = new LibraryManagementSystemContext(); BarcodesRepository barcodesRepository = new BarcodesRepository(context); Barcode barcode = barcodesRepository.GetByID(model.ID); if (barcode == null) { return HttpNotFound(); } else { barcodesRepository.Delete(barcode); } return RedirectToAction("ListBookBarcodes/" + barcode.BookID, "Books"); }
public void InitializeDb() { var connectionString = ConfigurationManager.AppSettings["DbConnectionString"]; var apiUrl = ConfigurationManager.AppSettings["ApiUrl"]; var productsRepository = new ProductsRepository(connectionString); var barcodesRepository = new BarcodesRepository(connectionString); var productsApiService = new ProductsApiService(apiUrl); var allProducts = productsApiService.GetAllProducts(); var context = new RegisterDbContext(connectionString); context.Database.EnsureDeleted(); context.Database.EnsureCreated(); var barcodes = allProducts.Data.SelectMany(s => s.BarCodes); productsRepository.Add(allProducts.Data); barcodesRepository.Add(barcodes); }
public ActionResult DeleteBarcode(BarcodesDeleteBarcodeVM model) { LibraryManagementSystemContext context = new LibraryManagementSystemContext(); BarcodesRepository barcodesRepository = new BarcodesRepository(context); Barcode barcode = barcodesRepository.GetByID(model.ID); if (barcode == null) { return(HttpNotFound()); } else { barcodesRepository.Delete(barcode); } return(RedirectToAction("ListBookBarcodes/" + barcode.BookID, "Books")); }
public ActionResult EditBarcode(int id, int bookID) { LibraryManagementSystemContext context = new LibraryManagementSystemContext(); BarcodesRepository barcodesRepository = new BarcodesRepository(context); BooksRepository booksRepository = new BooksRepository(context); BarcodesEditBarcodeVM model = new BarcodesEditBarcodeVM(); Barcode barcode = barcodesRepository.GetByID(id); if (id > 0) { if (barcode == null) { barcode.BookID = bookID; } model.ID = barcode.ID; model.BookID = barcode.BookID; model.BarcodeNumber = barcode.BarcodeNumber; } return View(model); }
public ActionResult EditBarcode(int id, int bookID) { LibraryManagementSystemContext context = new LibraryManagementSystemContext(); BarcodesRepository barcodesRepository = new BarcodesRepository(context); BooksRepository booksRepository = new BooksRepository(context); BarcodesEditBarcodeVM model = new BarcodesEditBarcodeVM(); Barcode barcode = barcodesRepository.GetByID(id); if (id > 0) { if (barcode == null) { barcode.BookID = bookID; } model.ID = barcode.ID; model.BookID = barcode.BookID; model.BarcodeNumber = barcode.BarcodeNumber; } return(View(model)); }
public ActionResult ListBookBarcodes(int id) { LibraryManagementSystemContext context = new LibraryManagementSystemContext(); BooksRepository booksRepository = new BooksRepository(context); BarcodesRepository barcodesRepository = new BarcodesRepository(context); BooksListBookBarcodesVM model = new BooksListBookBarcodesVM(); this.TryUpdateModel(model); var book = booksRepository.GetByID(id); if (book != null) { model.BookID = book.ID; model.BookTitle = book.Title; model.BarcodesPager = model.BarcodesPager ?? new GenericPagerVM(); model.BarcodesPager.PagesCount = GetPagesCount(); model.BarcodesPager.CurrentPage = model.BarcodesPager.CurrentPage == 0 ? 1 : model.BarcodesPager.CurrentPage; model.Barcodes = barcodesRepository .GetAll(model.BarcodesPager.CurrentPage, ApplicationConfiguration.ItemsPerPage, b => b.BookID == id) .ToList(); model.BarcodesPager.Action = "Index"; model.BarcodesPager.Controller = "Books"; model.BarcodesPager.Prefix = "BarcodesPager"; model.BarcodesPager.CurrentParameters = new Dictionary <string, object>() { { "BarcodesPager.CurrentPage", model.BarcodesPager.CurrentPage } }; return(View(model)); } else { return(RedirectToAction("Index", "Books")); } }
public ActionResult EditBarcode(BarcodesEditBarcodeVM model) { LibraryManagementSystemContext context = new LibraryManagementSystemContext(); BarcodesRepository barcodesRepository = new BarcodesRepository(context); Barcode barcode = null; if (barcodesRepository.GetAll().Any(b => b.BarcodeNumber == model.BarcodeNumber) && model.ID != barcodesRepository.GetAll(filter: b => b.BarcodeNumber == model.BarcodeNumber).FirstOrDefault().ID) { ModelState.AddModelError("BarcodeNumber", "* barcode already exists"); } if (!ModelState.IsValid) { return(View(model)); } else { if (model.ID > 0) { barcode = barcodesRepository.GetByID(model.ID); } else { barcode = new Barcode(); } barcode.ID = model.ID; barcode.BookID = model.BookID; barcode.BarcodeNumber = model.BarcodeNumber; barcodesRepository.Save(barcode); } return(RedirectToAction("ListBookBarcodes/" + barcode.BookID, "Books")); }
public ActionResult ListBookBarcodes(int id) { LibraryManagementSystemContext context = new LibraryManagementSystemContext(); BooksRepository booksRepository = new BooksRepository(context); BarcodesRepository barcodesRepository = new BarcodesRepository(context); BooksListBookBarcodesVM model = new BooksListBookBarcodesVM(); this.TryUpdateModel(model); var book = booksRepository.GetByID(id); if (book != null) { model.BookID = book.ID; model.BookTitle = book.Title; model.BarcodesPager = model.BarcodesPager ?? new GenericPagerVM(); model.BarcodesPager.PagesCount = GetPagesCount(); model.BarcodesPager.CurrentPage = model.BarcodesPager.CurrentPage == 0 ? 1 : model.BarcodesPager.CurrentPage; model.Barcodes = barcodesRepository .GetAll(model.BarcodesPager.CurrentPage, ApplicationConfiguration.ItemsPerPage, b => b.BookID == id) .ToList(); model.BarcodesPager.Action = "Index"; model.BarcodesPager.Controller = "Books"; model.BarcodesPager.Prefix = "BarcodesPager"; model.BarcodesPager.CurrentParameters = new Dictionary<string, object>() { { "BarcodesPager.CurrentPage", model.BarcodesPager.CurrentPage } }; return View(model); } else { return RedirectToAction("Index", "Books"); } }