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);
        }
Ejemplo n.º 3
0
        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);
        }
Ejemplo n.º 6
0
        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);
        }
Ejemplo n.º 8
0
        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));
        }
Ejemplo n.º 9
0
        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"));
            }
        }
Ejemplo n.º 10
0
        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");
            }
        }