public static BookTitleBLL getBookTitleItem(BookTitleBLL bookTitleBLL)
{
String sql = "SELECT * FROM [dausach] WHERE madausach=" + bookTitleBLL.BookTitleId;
DataTable dt = BookTitleDAL._condb.getDataTable(sql);
if (dt.Rows.Count > 0)
{
DataRow row = dt.Rows[0];
return new BookTitleBLL(Int32.Parse(row["madausach"].ToString()), Int32.Parse(row["matinhtrang"].ToString()), Int32.Parse(row["manxb"].ToString()), Int32.Parse(row["matheloai"].ToString()), row["tensach"].ToString(), row["tomtat"].ToString());
}
return null;
}
public BookTitleBLL getBookTile(int bookId)
{
BookBLL bookBLL = new BookBLL();
bookBLL = BookDAL.getBookByBookId(bookId);
if (bookBLL != null)
{
BookTitleBLL bookTitleBLL = new BookTitleBLL();
return BookTitleDAL.getBookTitleItem(bookBLL.BookTitleId);
}
return null;
}
public BookTitleBLL getBookTile(int bookId)
{
BookBLL bookBLL = new BookBLL();
bookBLL = BookDAL.getBookByBookId(bookId);
if (bookBLL != null)
{
BookTitleBLL bookTitleBLL = new BookTitleBLL();
return(BookTitleDAL.getBookTitleItem(bookBLL.BookTitleId));
}
return(null);
}
private void LoadDataToDataGridView()
{
this.dgvBook.Rows.Clear();
List<BookBLL> bookList = new List<BookBLL>();
bookList = BookDAL.getBookList(this._bookTitleBLL);
foreach (BookBLL row in bookList)
{
BookTitleBLL bookTitleBLL = new BookTitleBLL();
bookTitleBLL = BookTitleDAL.getBookTitleItem(row.BookTitleId);
BookStatusBLL bookStatusBLL = new BookStatusBLL();
bookStatusBLL = BookStatusDAL.getBookStatusItem(row.BookStatusId);
this.dgvBook.Rows.Add(row.BookId, bookTitleBLL.Name, bookTitleBLL.BookTitleId, bookStatusBLL.Name, bookStatusBLL.BookStatusId);
}
}
public static List<BookTitleBLL> getBookTitleList()
{
string sql = "SELECT * FROM [dausach]";
DataTable dt = BookTitleDAL._condb.getDataTable(sql);
if (dt.Rows.Count > 0)
{
List<BookTitleBLL> bookTitleList = new List<BookTitleBLL>();
foreach (DataRow row in dt.Rows)
{
BookTitleBLL bookTitleBLL = new BookTitleBLL(Int32.Parse(row["madausach"].ToString()), Int32.Parse(row["matinhtrang"].ToString()), Int32.Parse(row["manxb"].ToString()), Int32.Parse(row["matheloai"].ToString()), row["tensach"].ToString(), row["tomtat"].ToString());
bookTitleList.Add(bookTitleBLL);
}
return bookTitleList;
}
return null;
}
public static List<BookBLL> getBookList(BookTitleBLL bookTitleBLL)
{
string sql = "SELECT * FROM [sach] WHERE madausach=" + bookTitleBLL.BookTitleId;
DataTable dt = BookDAL._condb.getDataTable(sql);
if (dt.Rows.Count > 0)
{
List<BookBLL> bookList = new List<BookBLL>();
foreach (DataRow row in dt.Rows)
{
BookBLL bookBLL = new BookBLL(Int32.Parse(row["masach"].ToString()), Int32.Parse(row["madausach"].ToString()), Int32.Parse(row["matinhtrangsach"].ToString()));
bookList.Add(bookBLL);
}
return bookList;
}
return null;
}
private void LoadDataToComboboxBookTitleStatus()
{
BookTitleBLL bookTitleBLL = new BookTitleBLL();
this.cboBookTitleStatus.DataSource = bookTitleBLL.getComboboxItemBookTitleStatus();
this.cboBookTitleStatus.DisplayMember = "Text";
this.cboBookTitleStatus.ValueMember = "Value";
}
public BookGUI(BookTitleBLL bookTitleBLL)
{
this._bookTitleBLL = bookTitleBLL;
InitializeComponent();
}
public static void deleteBookTitle(BookTitleBLL bookTitleBLL)
{
String sql = "DELETE FROM [dausach] WHERE matacgia=" + bookTitleBLL.BookTitleId;
BookTitleDAL._condb.ExecuteNonQuery(sql);
}
public static void addBookTitle(BookTitleBLL bookTitleBLL)
{
String sql = "INSERT INTO [dausach] (matinhtrang, manxb, matheloai, tensach, tomtat) VALUES ( " + bookTitleBLL.BookTitleStatusId + ", " + bookTitleBLL.PublisherId + ", " + bookTitleBLL.TypeOfBookId + ", N'" + bookTitleBLL.Name + "', N'" + bookTitleBLL.Summary + "')";
BookTitleDAL._condb.ExecuteNonQuery(sql);
}
public static void updateBookTitle(BookTitleBLL bookTitleBLL)
{
String sql = "UPDATE [dausach] SET matinhtrang=" + bookTitleBLL.BookTitleStatusId + ", manxb=" + bookTitleBLL.PublisherId + ", matheloai=" + bookTitleBLL.TypeOfBookId + ", tensach=N'" + bookTitleBLL.Name + "', tomtat=N'" + bookTitleBLL.Summary + "' WHERE madausach=" + bookTitleBLL.BookTitleId;
BookTitleDAL._condb.ExecuteNonQuery(sql);
}
private void setAmountOfBook(BookTitleBLL bookTitleBLL)
{
this.txtBookTotal.Text = bookTitleBLL.getAmountOfBook().ToString();
}
private void LoadDataToComboboxTypeOfBook()
{
BookTitleBLL bookTitleBLL = new BookTitleBLL();
this.cboTypeOfBook.DataSource = bookTitleBLL.getComboboxItemTypeOfBook();
//MessageBox.Show((cboTypeOfBook.SelectedItem as ComboboxItem).Value.ToString());
this.cboPublisher.DisplayMember = "Text";
this.cboPublisher.ValueMember = "Value";
}
private void LoadDataToComboboxPublisher()
{
BookTitleBLL bookTitleBLL = new BookTitleBLL();
this.cboPublisher.DataSource = bookTitleBLL.getComboboxItemPublisher();
this.cboPublisher.DisplayMember = "Text";
this.cboPublisher.ValueMember = "Value";
}
private void GetSelectedValueDataGridViewBookTitle()
{
if (this.dgvBookTitle.SelectedCells.Count > 0 && this.dgvBookTitle.CurrentRow.Index < this.dgvBookTitle.Rows.Count - 1)
{
DataGridViewRow selectedRow = this.dgvBookTitle.Rows[this.dgvBookTitle.CurrentRow.Index];
int id = Convert.ToInt32(selectedRow.Cells["clmnBookTitleId"].Value);
string name = Convert.ToString(selectedRow.Cells["clmnBookTitleName"].Value);
int bookTitleStatusId = Convert.ToInt32(selectedRow.Cells["clmnBookTitleStatusId"].Value.ToString());
int publisherId = Convert.ToInt32(selectedRow.Cells["clmnPublisherId"].Value);
int typeOfBookId = Convert.ToInt32(selectedRow.Cells["clmnTypeOfBookId"].Value);
string summary = Convert.ToString(selectedRow.Cells["clmnSummary"].Value);
this.lblInfor.Text = id.ToString() + " / " + name;
this.txtBookName.Text = name;
this.txtSummary.Text = summary;
foreach (ComboboxItem item in this.cboBookTitleStatus.Items)
{
if (Convert.ToInt32(item.Value) == bookTitleStatusId)
cboBookTitleStatus.SelectedItem = item;
}
foreach (ComboboxItem item in this.cboPublisher.Items)
{
if (Convert.ToInt32(item.Value) == publisherId)
this.cboPublisher.SelectedItem = item;
}
foreach (ComboboxItem item in this.cboTypeOfBook.Items)
{
if (Convert.ToInt32(item.Value) == typeOfBookId)
this.cboTypeOfBook.SelectedItem = item;
}
BookTitleBLL bookTitleBLL = new BookTitleBLL(id, bookTitleStatusId, publisherId, typeOfBookId, name, summary);
List<AuthorBLL> authorList = bookTitleBLL.getAuthor();
this.loadDataToDataGridViewAuthor(authorList);
this.setSelectedValueComboboxAuthor(authorList[0]);
this.setAmountOfBook(bookTitleBLL);
}
else
{
this.lblInfor.Text = "Id / Name";
this.txtBookName.Text = "";
this.cboBookTitleStatus.Text = this.cboBookTitleStatus.Items[0].ToString();
this.cboPublisher.Text = this.cboPublisher.Items[0].ToString();
this.cboTypeOfBook.Text = this.cboTypeOfBook.Items[0].ToString();
this.cboAuthor.Text = this.cboAuthor.Items[0].ToString();
this.txtBookTotal.Text = "";
this.txtSummary.Text = "";
this.dgvAuthor.Rows.Clear();
}
}
private void btnViewInStore_Click(object sender, EventArgs e)
{
if (this.dgvBookTitle.SelectedCells.Count > 0 && this.dgvBookTitle.CurrentRow.Index < this.dgvBookTitle.Rows.Count - 1)
{
DataGridViewRow selectedRow = this.dgvBookTitle.Rows[this.dgvBookTitle.CurrentRow.Index];
int id = Convert.ToInt32(selectedRow.Cells["clmnBookTitleId"].Value);
string name = Convert.ToString(selectedRow.Cells["clmnBookTitleName"].Value);
int bookTitleStatusId = Convert.ToInt32(selectedRow.Cells["clmnBookTitleStatusId"].Value.ToString());
int publisherId = Convert.ToInt32(selectedRow.Cells["clmnPublisherId"].Value);
int typeOfBookId = Convert.ToInt32(selectedRow.Cells["clmnTypeOfBookId"].Value);
string summary = Convert.ToString(selectedRow.Cells["clmnSummary"].Value);
BookTitleBLL bookTitleBLL = new BookTitleBLL(id, bookTitleStatusId, publisherId, typeOfBookId, name, summary);
BookGUI bookGUI;
if (IsFormAlreadyOpen(typeof(BookGUI)) == null)
{
bookGUI = new BookGUI(bookTitleBLL);
bookGUI.Show();
}
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
string key = this.txtSearch.Text;
string catalog = "";
if (key == "".Trim())
{
MessageBox.Show("Please enter keyword!", "Notice");
return;
}
if (this.cboSearch.Text == "Book Title Status")
{
catalog = "matinhtrang";
}
else if (this.cboSearch.Text == "Publisher")
{
catalog = "manxb";
}
else if (this.cboSearch.Text == "Type Of Book")
{
catalog = "matheloai";
}
else if (this.cboSearch.Text == "Name")
{
catalog = "tensach";
}
else if (this.cboSearch.Text == "Summary")
{
catalog = "tomtat";
}
BookTitleBLL bookTitleBLL = new BookTitleBLL();
List<BookTitleBLL> bookTitleList = new List<BookTitleBLL>();
bookTitleList = bookTitleBLL.search(catalog, key);
this.dgvBookTitle.Rows.Clear();
if (bookTitleList != null)
{
foreach (BookTitleBLL row in bookTitleList)
{
this.dgvBookTitle.Rows.Add(row.BookTitleId, row.BookTitleStatusId, row.PublisherId, row.TypeOfBookId, row.Name, row.Summary);
}
}
this.GetSelectedValueDataGridViewBookTitle();
this.dgvBookTitle.SelectionChanged += new EventHandler(dgvBookTitle_SelectionChanged);
}
