private void btnDelete_Click(object sender, EventArgs e) { if (this.dgvBookTitleStatus.SelectedCells.Count > 0) { int selectedrowindex = this.dgvBookTitleStatus.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = this.dgvBookTitleStatus.Rows[selectedrowindex]; BookTitleStatusBLL bookTitleStatusBLL = new BookTitleStatusBLL(Convert.ToInt32(selectedRow.Cells["clmnId"].Value), selectedRow.Cells["clmnName"].Value.ToString()); DialogResult result = MessageBox.Show("Do you want to delete book title status: " + selectedRow.Cells["clmnName"].Value + "?", "Warning", MessageBoxButtons.OKCancel); switch (result) { case DialogResult.Cancel: break; case DialogResult.OK: BookTitleStatusBLL bookTitleStatusDLL = new BookTitleStatusBLL(); if (BookTitleStatusDAL.getBookTitleStatusItem(bookTitleStatusBLL) != null) { MessageBox.Show("Can't delete! Please delete all book title has status: '" + selectedRow.Cells["clmnName"].Value + "' before delete this status!", "Error"); break; } else { BookTitleStatusDAL.deleteBookTitleStatus(bookTitleStatusBLL); this.LoadDataToGridView(); break; } } } }
private void LoadDataToGridView() { this.dgvBookTitleStatus.Rows.Clear(); BookTitleStatusBLL bookTitleStatusBLL = new BookTitleStatusBLL(); List <BookTitleStatusBLL> bookTitleStatusArr = new List <BookTitleStatusBLL>(); bookTitleStatusArr = BookTitleStatusDAL.getBookTitleStatusList(); foreach (BookTitleStatusBLL row in bookTitleStatusArr) { this.dgvBookTitleStatus.Rows.Add(row.BookTitleStatusId, row.Name); } this.GetSelectedValue(); this.dgvBookTitleStatus.CellClick += new DataGridViewCellEventHandler(this.dgvBookTitleStatus_CellClick); }
private void btnAdd_Click(object sender, EventArgs e) { BookTitleStatusBLL bookTitleStatusBLL = new BookTitleStatusBLL(); bookTitleStatusBLL.Name = this.txtBookTitleStatusName.Text; if (bookTitleStatusBLL.Name == "") { MessageBox.Show("Author name is not null!", "Notice"); return; } BookTitleStatusDAL.addBookTitleStatus(bookTitleStatusBLL); MessageBox.Show("Add success!", "Success"); this.LoadDataToGridView(); }
public List <ComboboxItem> getComboboxItemBookTitleStatus() { List <BookTitleStatusBLL> bookTitleStatusList = new List <BookTitleStatusBLL>(); bookTitleStatusList = BookTitleStatusDAL.getBookTitleStatusList(); List <ComboboxItem> comboboxItemList = new List <ComboboxItem>(); for (int i = 0; i < bookTitleStatusList.Count; i++) { ComboboxItem item = new ComboboxItem(); item.Value = bookTitleStatusList[i].BookTitleStatusId; item.Text = bookTitleStatusList[i].Name; comboboxItemList.Add(item); } return(comboboxItemList); }
private void btnSave_Click(object sender, EventArgs e) { if (this.dgvBookTitleStatus.SelectedCells.Count > 0) { int selectedrowindex = this.dgvBookTitleStatus.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = this.dgvBookTitleStatus.Rows[selectedrowindex]; BookTitleStatusBLL bookTitleStatusBLL = new BookTitleStatusBLL(Convert.ToInt32(selectedRow.Cells["clmnId"].Value), this.txtBookTitleStatusName.Text); if (bookTitleStatusBLL.Name == "") { MessageBox.Show("Author name is not null!", "Notice"); return; } BookTitleStatusDAL.updateBookTitleStatus(bookTitleStatusBLL); MessageBox.Show("Update success!", "Success"); this.LoadDataToGridView(); } }
private void LoadDataToDataGridViewBookTitle() { this.dgvBookTitle.Rows.Clear(); List <BookTitleBLL> bookTitleList = new List <BookTitleBLL>(); bookTitleList = BookTitleDAL.getBookTitleList(); TypeOfBookBLL typeOfBookBLL = new TypeOfBookBLL(); foreach (BookTitleBLL row in bookTitleList) { typeOfBookBLL = TypeOfBookDAL.getTypeOfBookItem(row.TypeOfBookId); PublisherBLL publisherBLL = new PublisherBLL(); publisherBLL = PublisherDAL.getPublisherItem(row.PublisherId); BookTitleStatusBLL status = new BookTitleStatusBLL(); status = BookTitleStatusDAL.getBookTitleStatusItem(row.BookTitleStatusId); this.dgvBookTitle.Rows.Add(row.BookTitleId, row.Name, row.TypeOfBookId, typeOfBookBLL.Name, row.PublisherId, publisherBLL.Name, row.BookTitleStatusId, status.Name, row.Summary); } GetSelectedValueDataGridViewBookTitle(); this.dgvBookTitle.SelectionChanged += new EventHandler(dgvBookTitle_SelectionChanged); }
private void btnSearch_Click(object sender, EventArgs e) { string catalog = this.cboSearch.Text; string key = this.txtSearch.Text; if (key == "") { MessageBox.Show("Please enter keyword!", "Notice"); return; } BookTitleStatusBLL bookTitleStatusBLL = new BookTitleStatusBLL(); List <BookTitleStatusBLL> bookTitleStatusArr = new List <BookTitleStatusBLL>(); bookTitleStatusArr = BookTitleStatusDAL.search(catalog, key); this.dgvBookTitleStatus.Rows.Clear(); foreach (BookTitleStatusBLL row in bookTitleStatusArr) { this.dgvBookTitleStatus.Rows.Add(row.BookTitleStatusId, row.Name); } this.GetSelectedValue(); this.dgvBookTitleStatus.CellClick += new DataGridViewCellEventHandler(this.dgvBookTitleStatus_CellClick); }
public List <BookTitleBLL> search(string catalog, string key) { if (catalog == "matinhtrang") { List <BookTitleBLL> bookTitleList = new List <BookTitleBLL>(); List <BookTitleStatusBLL> bookTitleStatusList = new List <BookTitleStatusBLL>(); bookTitleStatusList = BookTitleStatusDAL.getBookTitleStatusItem(key); if (bookTitleStatusList != null) { foreach (BookTitleStatusBLL bookTitleStatusBLL in bookTitleStatusList) { List <BookTitleBLL> results = new List <BookTitleBLL>(); results = BookTitleDAL.getBookTitleList(catalog, bookTitleStatusBLL.BookTitleStatusId); if (results != null) { foreach (BookTitleBLL bookTitleBLL in results) { bookTitleList.Add(bookTitleBLL); } } } return(bookTitleList); } return(null); } else if (catalog == "manxb") { List <BookTitleBLL> bookTitleList = new List <BookTitleBLL>(); List <PublisherBLL> publisherList = new List <PublisherBLL>(); publisherList = PublisherDAL.getPublisherItem(key); if (publisherList != null) { foreach (PublisherBLL publisherBLL in publisherList) { List <BookTitleBLL> results = new List <BookTitleBLL>(); results = BookTitleDAL.getBookTitleList(catalog, publisherBLL.PublisherId); if (results != null) { foreach (BookTitleBLL bookTitleBLL in results) { bookTitleList.Add(bookTitleBLL); } } return(bookTitleList); } } return(null); } else if (catalog == "matheloai") { List <BookTitleBLL> bookTitleList = new List <BookTitleBLL>(); List <TypeOfBookBLL> typeOfBookList = new List <TypeOfBookBLL>(); typeOfBookList = TypeOfBookDAL.getTypeOfBookItem(key); if (typeOfBookList != null) { foreach (TypeOfBookBLL typeOfBookBLL in typeOfBookList) { List <BookTitleBLL> results = new List <BookTitleBLL>(); results = BookTitleDAL.getBookTitleList(catalog, typeOfBookBLL.TypeOfBookId); if (results != null) { foreach (BookTitleBLL bookTitleBLL in results) { bookTitleList.Add(bookTitleBLL); } } return(bookTitleList); } } return(null); } else if (catalog == "tensach" || catalog == "tomtat") { List <BookTitleBLL> bookTitleList = new List <BookTitleBLL>(); bookTitleList = BookTitleDAL.search(catalog, key); return(bookTitleList); } return(null); }