예제 #1
0
 public BookTitleBLL getBookTile(int bookId)
 {
     BookBLL bookBLL = new BookBLL();
     bookBLL = BookDAL.getBookByBookId(bookId);
     if (bookBLL != null)
     {
         BookTitleBLL bookTitleBLL = new BookTitleBLL();
         return BookTitleDAL.getBookTitleItem(bookBLL.BookTitleId);
     }
     return null;
 }
예제 #2
0
        public BookTitleBLL getBookTile(int bookId)
        {
            BookBLL bookBLL = new BookBLL();

            bookBLL = BookDAL.getBookByBookId(bookId);
            if (bookBLL != null)
            {
                BookTitleBLL bookTitleBLL = new BookTitleBLL();
                return(BookTitleDAL.getBookTitleItem(bookBLL.BookTitleId));
            }
            return(null);
        }
예제 #3
0
 public static List<BookBLL> getBookList(BookTitleBLL bookTitleBLL)
 {
     string sql = "SELECT * FROM [sach] WHERE madausach=" + bookTitleBLL.BookTitleId;
     DataTable dt = BookDAL._condb.getDataTable(sql);
     if (dt.Rows.Count > 0)
     {
         List<BookBLL> bookList = new List<BookBLL>();
         foreach (DataRow row in dt.Rows)
         {
             BookBLL bookBLL = new BookBLL(Int32.Parse(row["masach"].ToString()), Int32.Parse(row["madausach"].ToString()), Int32.Parse(row["matinhtrangsach"].ToString()));
             bookList.Add(bookBLL);
         }
         return bookList;
     }
     return null;
 }
예제 #4
0
        private void btnBookAdd_Click(object sender, EventArgs e)
        {
            if (this.dgvBookTitle.SelectedCells.Count > 0 && this.dgvBookTitle.CurrentRow.Index < this.dgvBookTitle.Rows.Count - 1)
            {
                DataGridViewRow selectedRow = this.dgvBookTitle.Rows[this.dgvBookTitle.CurrentRow.Index];

                int bookTitleId = Convert.ToInt32(selectedRow.Cells["clmnBookTitleId"].Value);
                int quantity = Convert.ToInt32(this.txtBookTotal.Text);
                if (quantity < 1)
                {
                    MessageBox.Show("The quantity can't less than 1");
                    return;
                }
                BookBLL bookBLL = new BookBLL();
                bookBLL.BookTitleId = bookTitleId;
                bookBLL.BookStatusId = 1; //Điều này có thể thay đổi
                for (int i = 0; i < quantity; i++ )
                    BookDAL.addBook(bookBLL);
                MessageBox.Show("Add success!");
            }
        }
예제 #5
0
 public static void addBook(BookBLL bookBLL)
 {
     String sql = "INSERT INTO [sach] (madausach, matinhtrangsach) VALUES ( '" + bookBLL.BookTitleId + "', '" + bookBLL.BookStatusId + "')";
     BookDAL._condb.ExecuteNonQuery(sql);
 }