private void BookTable_RowHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            int bookId = Convert.ToInt32(bookTable.Rows[e.RowIndex].Cells[0].Value);

            using (LibraryEntities db = new LibraryEntities())
            {
                bookFound = db.Books.Where(b => b.Id == bookId).FirstOrDefault();
                List <Models.AuthorsBooks> abList = db.AuthorsBooks.ToList();

                if (bookFound != null)
                {
                    nameBox.Text = bookFound.Name;
                    //foreach(var y in abList)
                    //{
                    //    if(bookFound.Id == y.BookId)
                    //    {
                    //        authorDrop.SelectedText = y.Authors.Name;
                    //    }
                    //}
                    priceBox.Text             = Convert.ToString(bookFound.Price);
                    quantityBox.Text          = Convert.ToString(bookFound.Quantity);
                    categoryDrop.SelectedItem = bookFound.Categories.Name;
                }
                saveBtn.Text      = "Update";
                deleteBtn.Enabled = true;
            }
        }
예제 #2
0
        public ActionResult AddBookSubmit()
        {
            HttpPostedFileBase file = Request.Files["picture"];

            // Initiate a class instance
            Books book = new Books();

            // Save the book added
            string title = Request.Form["title"];
            string auteur = Request.Form["author"];
            int authorNum = Int32.Parse(auteur);
            string synopsis = Request.Form["synopsis"];

            string picture = "";
            if (file != null && file.ContentLength > 0)
            {
                string fname = System.IO.Path.GetFileName(file.FileName);
                file.SaveAs(Server.MapPath(System.IO.Path.Combine("~/Content/img", fname)));
                picture = "../Content/img/" + fname;

                book.AddBooks(title, authorNum, picture, synopsis);
            }
            else
            {
                book.AddBooks(title, authorNum, synopsis);
            }

            return RedirectToAction("Books");
        }
        private void DeleteCategory(object sender, EventArgs e)
        {
            using (LibraryEntities db = new LibraryEntities())
            {
                int          bookId = Convert.ToInt32(bookTable.SelectedRows[0].Cells[0].Value);
                Models.Books b1     = db.Books.Where(b => b.Id == bookId).FirstOrDefault();
                db.Books.Remove(b1);
                db.SaveChanges();
            }

            FillBooks();
            Reset();
        }
예제 #4
0
        // GET: Books
        public ActionResult Books()
        {
            // Initiate a class instance
            Books book = new Books();

            // Get all the books from the database
            var books = new List<Tuple<string, string, string, string>>();
            books = book.GetAllBooks();

            ViewBag.Books = books;
            ViewBag.BookObject = book;

            return View();
        }
예제 #5
0
        public ActionResult AuthorBooks(string id)
        {
            // Initiate a class instance
            Authors author = new Authors();

            // Get author's books
            var authorBooks = new List<Tuple<string, string, string, string>>();
            authorBooks = author.GetAuthorBooks(id);

            Books book = new Books();
            string authorName;
            authorName = book.GetNameAuthor(id);

            ViewBag.AuthorBooks = authorBooks;
            ViewBag.AuthorName = authorName;

            return View();
        }
예제 #6
0
        public ActionResult Book(string id)
        {
            // Initiate a class instance
            Books book = new Books();

            // Get the book's data
            var dataBook = new List<Tuple<string, string, string, string, string>>();
            dataBook = book.GetBookById(id);

            string title = book.GetBookTitle(id);

            string author = book.GetNameAuthor(id);

            ViewBag.DataBook = dataBook;
            ViewBag.Title = title;
            ViewBag.Author = author;
            ViewBag.BookObject = book;

            return View();
        }
        private void AddBook(object sender, EventArgs e)
        {
            if (saveBtn.Text == "Save")
            {
                Regex letters       = new Regex(@"^[A-Za-z ]+$");
                Match bookNameMatch = letters.Match(nameBox.Text);

                Regex price      = new Regex(@"^[0-9.]*$");
                Match priceMatch = price.Match(priceBox.Text);

                Regex numbers       = new Regex(@"^[0-9]*$");
                Match quantityMatch = numbers.Match(quantityBox.Text);

                if (!bookNameMatch.Success)
                {
                    MessageBox.Show("Book name contains only letters");
                }
                else if (!priceMatch.Success)
                {
                    MessageBox.Show("Price contains only numbers and dot");
                }
                else if (!quantityMatch.Success)
                {
                    MessageBox.Show("Quantity contains only numbers");
                }
                else
                {
                    using (LibraryEntities db = new LibraryEntities())
                    {
                        Models.AuthorsBooks ab  = new AuthorsBooks();
                        int          categoryId = (db.Categories.Where(c => c.Name == categoryDrop.SelectedItem.ToString()).FirstOrDefault()).Id;
                        int          authorId   = (db.Authors.Where(a => a.Name + " " + a.Surname == authorDrop.SelectedItem.ToString()).FirstOrDefault()).Id;
                        Models.Books b1         = new Models.Books();
                        b1.Name     = nameBox.Text;
                        ab.BookId   = b1.Id;
                        ab.AuthorId = authorId;
                        db.AuthorsBooks.Add(ab);
                        b1.Price      = Convert.ToDecimal(priceBox.Text);
                        b1.CategoryId = categoryId;
                        b1.Quantity   = Convert.ToInt32(quantityBox.Text);
                        db.Books.Add(b1);
                        db.SaveChanges();
                    }
                    FillBooks();
                    nameBox.Clear();
                    priceBox.Clear();
                    quantityBox.Clear();
                    categoryDrop.SelectedIndex = -1;
                    authorDrop.SelectedIndex   = -1;
                }
            }
            else
            {
                using (LibraryEntities db = new LibraryEntities())
                {
                    int bookId = Convert.ToInt32(bookTable.SelectedRows[0].Cells[0].Value);

                    Models.Books newBook = db.Books.Where(b => b.Id == bookFound.Id).FirstOrDefault();

                    newBook.Id = bookId;
                    Regex letters       = new Regex(@"^[A-Za-z ]+$");
                    Match bookNameMatch = letters.Match(nameBox.Text);

                    Regex price      = new Regex(@"^[0-9.]*$");
                    Match priceMatch = price.Match(priceBox.Text);

                    Regex numbers       = new Regex(@"^[0-9]*$");
                    Match quantityMatch = numbers.Match(quantityBox.Text);

                    if (!bookNameMatch.Success)
                    {
                        MessageBox.Show("Book name contains only letters");
                    }
                    else if (!priceMatch.Success)
                    {
                        MessageBox.Show("Price contains only numbers and dot");
                    }
                    else if (!quantityMatch.Success)
                    {
                        MessageBox.Show("Quantity contains only numbers");
                    }
                    else
                    {
                        newBook.Name            = nameBox.Text;
                        newBook.Categories.Name = (db.Categories.Where(c => c.Name == categoryDrop.SelectedItem.ToString()).FirstOrDefault()).Name;
                        newBook.Price           = Convert.ToDecimal(priceBox.Text);
                        newBook.Quantity        = Convert.ToInt32(quantityBox.Text);
                    }

                    db.SaveChanges();
                    FillBooks();
                    Reset();
                }
            }
        }