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;
}
}
}
}
public static BookTitleStatusBLL getBookTitleStatusItem(BookTitleStatusBLL bookTitleStatusBLL)
{
String sql = "SELECT * FROM [dausach] WHERE matinhtrang=" + bookTitleStatusBLL.BookTitleStatusId;
DataTable dt = BookTitleStatusDAL._condb.getDataTable(sql);
if (dt.Rows.Count > 0)
{
DataRow row = dt.Rows[0];
return new BookTitleStatusBLL(Int32.Parse(row["matinhtrang"].ToString()), row["tentinhtrang"].ToString());
}
return null;
}
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 static List<BookTitleStatusBLL> getBookTitleStatusList()
{
String sql = "SELECT * FROM [tinhtrangdausach]";
DataTable dt = new DataTable();
dt = BookTitleStatusDAL._condb.getDataTable(sql);
List<BookTitleStatusBLL> bookTitleStatusBLLList = new List<BookTitleStatusBLL>();
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
BookTitleStatusBLL bookTitleStatusBLL = new BookTitleStatusBLL(Int32.Parse(row["matinhtrang"].ToString()), row["tentinhtrang"].ToString());
bookTitleStatusBLLList.Add(bookTitleStatusBLL);
}
return bookTitleStatusBLLList;
}
return null;
}
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<BookTitleStatusBLL> search(string catalog, string key)
{
string sql = "SELECT * FROM [tinhtrangdausach] WHERE " + catalog + " LIKE '%" + key + "%'";
DataTable dt = new DataTable();
dt = BookTitleStatusDAL._condb.getDataTable(sql);
List<BookTitleStatusBLL> bookTitleStatusBLLList = new List<BookTitleStatusBLL>();
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
BookTitleStatusBLL bookTitleStatusBLL = new BookTitleStatusBLL(Int32.Parse(row["matinhtrang"].ToString()), row["tentinhtrang"].ToString());
bookTitleStatusBLLList.Add(bookTitleStatusBLL);
}
return bookTitleStatusBLLList;
}
return null;
}
public static void deleteBookTitleStatus(BookTitleStatusBLL bookTitleStatus)
{
String sql = "DELETE FROM [tinhtrangdausach] WHERE matinhtrang=" + bookTitleStatus.BookTitleStatusId;
BookTitleStatusDAL._condb.ExecuteNonQuery(sql);
}
public static void addBookTitleStatus(BookTitleStatusBLL bookTitleStatus)
{
String sql = "INSERT INTO [tinhtrangdausach] (tentinhtrang) VALUES ( N'" + bookTitleStatus.Name + "')";
BookTitleStatusDAL._condb.ExecuteNonQuery(sql);
}
public static void updateBookTitleStatus(BookTitleStatusBLL bookTitleStatusBLL)
{
String sql = "UPDATE [tinhtrangdausach] SET tentinhtrang=N'" + bookTitleStatusBLL.Name + "' WHERE matinhtrang=" + bookTitleStatusBLL.BookTitleStatusId;
BookTitleStatusDAL._condb.ExecuteNonQuery(sql);
}
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 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 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);
}