private void btnSearch_Click_1(object sender, EventArgs e)
{
//string catalog = this.cboSearch.Text;
string key = this.txtSearch.Text;
if (key == "")
{
MessageBox.Show("Please enter keyword!", "Notice");
return;
}
string catalog = "tentheloai";
TypeOfBookBLL typeOfBookBLL = new TypeOfBookBLL();
List <TypeOfBookBLL> typeOfBookArr = new List <TypeOfBookBLL>();
//MessageBox.Show(catalog + " " + key);
typeOfBookArr = TypeOfBookDAL.search(catalog, key);
this.dgvTypeOfBook.Rows.Clear();
foreach (TypeOfBookBLL row in typeOfBookArr)
{
this.dgvTypeOfBook.Rows.Add(row.TypeOfBookId, row.Name);
}
this.GetSelectedValue();
this.dgvTypeOfBook.CellClick += new DataGridViewCellEventHandler(dgvTypeOfBook_CellClick);
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (this.dgvTypeOfBook.SelectedCells.Count > 0)
{
int selectedrowindex = this.dgvTypeOfBook.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = this.dgvTypeOfBook.Rows[selectedrowindex];
TypeOfBookBLL typeOfBookBLL = new TypeOfBookBLL(Convert.ToInt32(selectedRow.Cells["clmnId"].Value), selectedRow.Cells["clmnId"].Value.ToString());
DialogResult result = MessageBox.Show("Do you want to delete type of book: " + selectedRow.Cells["clmnName"].Value + "?", "Warning", MessageBoxButtons.OKCancel);
switch (result)
{
case DialogResult.Cancel:
break;
case DialogResult.OK:
if (TypeOfBookDAL.getTypeOfBookItem(typeOfBookBLL) != null)
{
MessageBox.Show("Can't delete! Please delete all book title has type " + selectedRow.Cells["clmnName"].Value + " before delete this type!", "Error");
break;
}
else
{
TypeOfBookDAL.deleteTypeOfBook(typeOfBookBLL);
MessageBox.Show("Delete complete!", "Success");
this.LoadDataToGridView();
break;
}
}
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
TypeOfBookBLL typeOfBookBLL = new TypeOfBookBLL();
typeOfBookBLL.Name = this.txtTypeOfBookName.Text;
if (typeOfBookBLL.Name == "")
{
MessageBox.Show("Author name is not null!", "Notice");
return;
}
TypeOfBookDAL.addTypeOfBook(typeOfBookBLL);
MessageBox.Show("Add success!", "Success");
this.LoadDataToGridView();
}
private void LoadDataToGridView()
{
this.dgvTypeOfBook.Rows.Clear();
TypeOfBookBLL typeOfBookBLL = new TypeOfBookBLL();
List <TypeOfBookBLL> typeOfBookArr = new List <TypeOfBookBLL>();
typeOfBookArr = TypeOfBookDAL.getTypeOfBookList();
foreach (TypeOfBookBLL row in typeOfBookArr)
{
this.dgvTypeOfBook.Rows.Add(row.TypeOfBookId, row.Name);
}
this.GetSelectedValue();
this.dgvTypeOfBook.CellClick += new DataGridViewCellEventHandler(this.dgvTypeOfBook_CellClick);
}
public static TypeOfBookBLL getTypeOfBookItem(TypeOfBookBLL typeOfBookBLL)
{
String sql = "SELECT * FROM [theloai] WHERE matheloai=" + typeOfBookBLL.TypeOfBookId;
DataTable dt = TypeOfBookDAL._condb.getDataTable(sql);
if (dt.Rows.Count > 0)
{
DataRow row = dt.Rows[0];
return(new TypeOfBookBLL(Int32.Parse(row["matheloai"].ToString()), row["tentheloai"].ToString()));
}
else
{
return(null);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (this.dgvTypeOfBook.SelectedCells.Count > 0)
{
int selectedrowindex = this.dgvTypeOfBook.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = this.dgvTypeOfBook.Rows[selectedrowindex];
TypeOfBookBLL typeOfBookBLL = new TypeOfBookBLL(Convert.ToInt32(selectedRow.Cells["clmnId"].Value), txtTypeOfBookName.Text);
if (typeOfBookBLL.Name == "")
{
MessageBox.Show("Author name is not null!", "Notice");
return;
}
TypeOfBookDAL.updateTypeOfBook(typeOfBookBLL);
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);
}
public static List <TypeOfBookBLL> search(string catalog, string keyword)
{
String sql = "SELECT * FROM [theloai] WHERE " + catalog + " LIKE '%" + keyword + "%'";
DataTable dt = new DataTable();
dt = TypeOfBookDAL._condb.getDataTable(sql);
List <TypeOfBookBLL> typeOfBookBLLList = new List <TypeOfBookBLL>();
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
TypeOfBookBLL typeOfBookBLL = new TypeOfBookBLL(Int32.Parse(row["matheloai"].ToString()), row["tentheloai"].ToString());
typeOfBookBLLList.Add(typeOfBookBLL);
}
return(typeOfBookBLLList);
}
else
{
return(null);
}
}
public static List <TypeOfBookBLL> getTypeOfBookList()
{
String sql = "SELECT * FROM [theloai]";
DataTable dt = new DataTable();
dt = TypeOfBookDAL._condb.getDataTable(sql);
List <TypeOfBookBLL> typeOfBookBLLList = new List <TypeOfBookBLL>();
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
TypeOfBookBLL typeOfBookBLL = new TypeOfBookBLL(Int32.Parse(row["matheloai"].ToString()), row["tentheloai"].ToString());
typeOfBookBLLList.Add(typeOfBookBLL);
}
return(typeOfBookBLLList);
}
else
{
return(null);
}
}
public static void updateTypeOfBook(TypeOfBookBLL typeOfBookBLL)
{
String sql = "UPDATE [theloai] SET tentheloai=N'" + typeOfBookBLL.Name + "' WHERE matheloai=" + typeOfBookBLL.TypeOfBookId;
TypeOfBookDAL._condb.ExecuteNonQuery(sql);
}
public static void deleteTypeOfBook(TypeOfBookBLL typeOfBookBLL)
{
String sql = "DELETE FROM [theloai] WHERE matheloai=" + typeOfBookBLL.TypeOfBookId;
TypeOfBookDAL._condb.ExecuteNonQuery(sql);
}
public static void addTypeOfBook(TypeOfBookBLL typeOfBookBLL)
{
String sql = "INSERT INTO [theloai] (tentheloai) VALUES ( N'" + typeOfBookBLL.Name + "')";
TypeOfBookDAL._condb.ExecuteNonQuery(sql);
}
