예제 #1
0
        public void BorrowBook()
        {
            var borrowbookwindow = new BorrowBooksWindow();

            borrowbookwindow.DataContext = this;
            var result = borrowbookwindow.ShowDialog();

            if (result == true)
            {
                SelectedBook.BookAvailability = Availability.UNAVAILABLE.ToString();
                SelectedBook.BookDateBorrowed = bookdateborrowed;
                if (SelectedBorrower.BorrowerType == "Student")
                {
                    SelectedBook.BookDateDeadline = SelectedBook.BookDateBorrowed.AddDays(7);
                    MessageBox.Show("Date Borrowed: " + SelectedBook.BookDateBorrowed.ToString("MMMM dd, yyyy") + "\n" + "Date Deadline: " + SelectedBook.BookDateDeadline.ToString("MMMM dd, yyyy"));
                }
                else
                {
                    SelectedBook.BookDateDeadline = SelectedBook.BookDateBorrowed.AddDays(14);
                    MessageBox.Show("Date Borrowed: " + SelectedBook.BookDateBorrowed.ToString("MMMM dd, yyyy") + "\n" + "Date Deadline: " + SelectedBook.BookDateDeadline.ToString("MMMM dd, yyyy"));
                }
                SelectedBorrower.BORROWERBOOKSBORROWED.Add(SelectedBook);
                if (SelectedBorrower.BORROWERBOOKSBORROWED.Count > 0)
                {
                    SelectedBorrower.BorrowerCheckBorrowingBooks = CheckBorrowedBook.BORROWING.ToString();
                }
                SelectedBook = null;
            }
        }
예제 #2
0
        public void BorrowBook()
        {
            var borrowbookwindow = new BorrowBooksWindow();

            borrowbookwindow.DataContext = this;
            var result = borrowbookwindow.ShowDialog();

            if (result == true)
            {
                SelectedBorrower.BORROWERBOOKSBORROWED.Add(SelectedBook);
                con.Open();
                SqlCommand command_borrower = new SqlCommand("UPDATE [BORROWER] SET BorrowStatus=@BorrowStatus  WHERE BorrowerID=@BorrowerID", con);
                SqlCommand command_book     = new SqlCommand("UPDATE [BOOK] SET Availability=@Availability WHERE BookID=@BookID", con);
                //SqlCommand command_process = new SqlCommand("INSERT INTO [PROCESS](LastName,FirstName) VALUES(@LastName,@FirstName)", con);
                for (int i = 0; i < dt_book.Rows.Count; i++)
                {
                    if (SelectedBook.BookIDNumber == int.Parse(dt_book.Rows[i]["BookID"].ToString()))
                    {
                        command_book.Parameters.Add("@BookID", SelectedBook.BookIDNumber);
                        command_book.Parameters.Add("@Availability", Availability.UNAVAILABLE.ToString());
                        break;
                    }
                }
                for (int i = 0; i < dt_book.Rows.Count; i++)
                {
                    if (SelectedBook.BookIDNumber == BOOKSLIST[i].BookIDNumber)
                    {
                        BOOKSLIST[i].BookAvailability = Availability.UNAVAILABLE.ToString();
                        break;
                    }
                }

                for (int i = 0; i < dt_borrower.Rows.Count; i++)
                {
                    if (SelectedBorrower.BorrowerIDNumber == int.Parse(dt_borrower.Rows[i]["BorrowerID"].ToString()))
                    {
                        command_borrower.Parameters.Add("@BorrowerID", SelectedBorrower.BorrowerIDNumber);
                        command_borrower.Parameters.Add("@BorrowStatus", CheckBorrowedBook.BORROWING.ToString());
                        break;
                    }
                }
                for (int i = 0; i < dt_borrower.Rows.Count; i++)
                {
                    if (SelectedBorrower.BorrowerIDNumber == BORROWERSLIST[i].BorrowerIDNumber)
                    {
                        BORROWERSLIST[i].BorrowerCheckBorrowingBooks = CheckBorrowedBook.BORROWING.ToString();
                        break;
                    }
                }
                command_book.ExecuteNonQuery();
                command_borrower.ExecuteNonQuery();
                con.Close();
                MessageBox.Show("Successfully borrowed the book");



                //SelectedBook.BookAvailability = Availability.UNAVAILABLE.ToString();
                //SelectedBook.BookDateBorrowed = bookdateborrowed;
                //if(SelectedBorrower.BorrowerType == "Student")
                //{
                //    SelectedBook.BookDateDeadline = SelectedBook.BookDateBorrowed.AddDays(7);
                //    MessageBox.Show("Date Borrowed: " + SelectedBook.BookDateBorrowed.ToString("MMMM dd, yyyy") + "\n" + "Date Deadline: " + SelectedBook.BookDateDeadline.ToString("MMMM dd, yyyy"));
                //}
                //else
                //{
                //    SelectedBook.BookDateDeadline = SelectedBook.BookDateBorrowed.AddDays(14);
                //    MessageBox.Show("Date Borrowed: " + SelectedBook.BookDateBorrowed.ToString("MMMM dd, yyyy") + "\n" + "Date Deadline: " + SelectedBook.BookDateDeadline.ToString("MMMM dd, yyyy"));
                //}
                //SelectedBorrower.BORROWERBOOKSBORROWED.Add(SelectedBook);
                //if(SelectedBorrower.BORROWERBOOKSBORROWED.Count>0)
                //{
                //    SelectedBorrower.BorrowerCheckBorrowingBooks = CheckBorrowedBook.BORROWING.ToString();
                //}
                //SelectedBook = null;
            }
        }