예제 #1
0
        private void updateBookInventory()
        {
            string        bookISBN = context.books.Where(x => x.BookID == returnBookID).First().ISBN;
            BookInventory k        = context.BookInventories.Where(x => x.ISBN == bookISBN).First();

            k.InventoryLibrary++;
            k.InventoryLoan--;
        }
예제 #2
0
 private void updateBookInventory()
 {
     for (int i = 0; i < borrowedBookList.Count; i++)
     {
         int           j        = borrowedBookList[i];
         string        bookISBN = context.books.Where(x => x.BookID == j).First().ISBN;
         BookInventory k        = context.BookInventories.Where(x => x.ISBN == bookISBN).First();
         k.InventoryLibrary--;
         k.InventoryLoan++;
     }
 }
예제 #3
0
        private void button1_Click(object sender, EventArgs e)
        {
            using (TransactionScope ts = new TransactionScope())
            {
                if (BookTitletext.Text == "" || Authortext.Text == "" || Publishertext.Text == "" || BookCategorycomboBox.Text == "" || BookTypetext.Text == "" || ISBNtext.Text == "" || Editiontext.Text == "")
                {
                    MessageBox.Show("Please input all fields");
                    return;
                }

                else
                {
                    DateTime PublishedYear;
                    DateTime.TryParse(PublishedYeartext.Text, out PublishedYear);
                    PublishedYear.ToString();



                    var q = context.BkCategories.Where(x => x.BookCategory == BookCategorycomboBox.Text && x.BookType == BookTypetext.Text).ToList();
                    if (q.Count == 0)
                    {
                        BkCategory bcategory = new BkCategory();
                        bcategory.BookCategory = BookCategorycomboBox.Text;
                        bcategory.BookType     = BookTypetext.Text;
                        context.BkCategories.Add(bcategory);
                        context.SaveChanges();
                    }

                    var m = context.BookInventories.Where(x => x.ISBN == ISBNtext.Text).ToList();
                    if (m.Count == 0)
                    {
                        BookInventory BInventory = new BookInventory();
                        BInventory.ISBN             = ISBNtext.Text;
                        BInventory.InventoryLibrary = 1;
                        BInventory.InventoryLoan    = 0;
                        context.BookInventories.Add(BInventory);
                        context.SaveChanges();
                    }
                    else
                    {
                        BookInventory J = m.First();
                        J.InventoryLibrary++;
                    }



                    book b = new book();


                    b.BookTitle     = BookTitletext.Text;
                    b.Author        = Authortext.Text;
                    b.Publisher     = Publishertext.Text;
                    b.BookCategory  = BookCategorycomboBox.Text;
                    b.BookType      = BookTypetext.Text;
                    b.LoanStatus    = false;
                    b.ISBN          = ISBNtext.Text;
                    b.Edition       = Editiontext.Text;
                    b.Language      = Languagetext.Text;
                    b.PublishedYear = PublishedYear;
                    context.books.Add(b);
                    context.SaveChanges();



                    //insert/update book inventory



                    //insert book category



                    ts.Complete();
                    MessageBox.Show("Book Record Added Successfully");
                }
                //this.Close();
            }
        }