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);
}
