private void btnA_Click(object sender, EventArgs e) { if (checkNull()) { DTO_Book b = new DTO_Book(); b.ID = int.Parse(txtID.Text); b.Name = txtName.Text; b.Price = int.Parse(txtPrice.Text); b.Publication_date = DateTime.Parse(dpPubDate.Value.ToShortDateString()); b.Publisher_id = int.Parse(cbPub.SelectedValue.ToString()); b.Author_id = int.Parse(cbAuthor.SelectedValue.ToString()); b.Category_id = int.Parse(cbCate.SelectedValue.ToString()); b.Quantity = int.Parse(txtQuanity.Text); if (bus_book.InsertBook(b) == 1) { MessageBox.Show("Thành công"); frmBook_Load(sender, e); } else { MessageBox.Show("Không thành công"); } } else { MessageBox.Show("Hãy nhập đủ thông tin"); } }
private void btnSeach_Click(object sender, EventArgs e) { if (txtID.Text != "") { DTO_Book dto_book = new DTO_Book(); String id = txtID.Text; dto_book = bus_book.SearchBook("b_id", txtID.Text); if (dto_book != null) { txtName.Text = dto_book.Name; txtPrice.Text = dto_book.Price.ToString(); txtQuanity.Text = dto_book.Quantity.ToString(); dpPubDate.Text = dto_book.Publication_date.ToShortDateString(); cbCate.Text = dto_book.Category_id.ToString(); cbAuthor.Text = dto_book.Author_id.ToString(); cbPub.Text = dto_book.Publisher_id.ToString(); } else { MessageBox.Show("Không tìm thấy!"); } } else { MessageBox.Show("Hãy nhập mã sách cần tìm!"); } }
public int Insert(DTO_Book book) { string sql = "INSERT INTO Book(b_id, b_name, b_publication_date, b_price, b_quanity, category_id, author_id, publisher_id)" + " VALUES('" + book.ID + "',N'" + book.Name + "','" + book.Publication_date.ToShortDateString() + "', " + book.Price + ", " + book.Quantity + ", '" + book.Category_id + "', '" + book.Author_id + "', '" + book.Publisher_id + "');"; return(this.ExecuteNonQuery(sql)); }
public int Update(DTO_Book book) { string sql = "UPDATE Book SET b_name = N'" + book.Name + "', b_publication_date = '" + book.Publication_date + "', b_price = " + book.Price + ", b_quanity = " + book.Quantity + ", category_id = '" + book.Category_id + "', author_id = '" + book.Author_id + "', publisher_id = '" + book.Publisher_id + "' WHERE b_id = '" + book.ID + "';"; return(this.ExecuteNonQuery(sql)); }
public int UpdateBook(DTO_Book book) { try { if (book.Name.Contains("'")) { book.Name = checkString(book.Name); } return(bookDAO.Update(book)); } catch (Exception) { return(-1); } }
public int InsertBook(DTO_Book book) { if (book.Name.Contains("'")) { book.Name = checkString(book.Name); } if (checkID(book.ID)) { return(-5); } int res = bookDAO.Insert(book); if (res == 1) { listID.Add(book.ID); } return(res); }