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 LoadDataToComboboxBookTitleStatus()
{
BookTitleBLL bookTitleBLL = new BookTitleBLL();
this.cboBookTitleStatus.DataSource = bookTitleBLL.getComboboxItemBookTitleStatus();
this.cboBookTitleStatus.DisplayMember = "Text";
this.cboBookTitleStatus.ValueMember = "Value";
}
private void LoadDataToComboboxAuthor()
{
BookTitleBLL bookTitleBLL = new BookTitleBLL();
this.cboAuthor.DataSource = bookTitleBLL.getComboboxItemAuthor();
this.cboAuthor.DisplayMember = "Text";
this.cboAuthor.ValueMember = "Value";
}
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";
}
protected void btnAddBook_Click(object sender, EventArgs e)
{
BookTitleBLL bookTitleBLL = new BookTitleBLL();
BorrowBookBLL borrowBLL = new BorrowBookBLL();
if (ProcessGUI.IsNumeric(this.txtBookId.Text))
{
bookTitleBLL = borrowBLL.getBookTile(Int32.Parse(this.txtBookId.Text));
if (bookTitleBLL != null)
{
if (count <= Int32.Parse(Session["quantity"].ToString()))
{
if (count == 1)
{
this.lblBookTitleFirst.Text = bookTitleBLL.Name;
this.lblBookIdFirst.Text = bookTitleBLL.BookTitleId.ToString();
this.lblIdFirst.Text = this.txtBookId.Text;
count++;
Session["id1"] = this.txtBookId.Text;
Session["bookId1"] = this.lblBookIdFirst.Text;
Session["bookName1"] = this.lblBookTitleFirst.Text;
this.btnRemoveFirst.Visible = true;
}
else if (count == 2)
{
this.lblBookTitleSecond.Text = bookTitleBLL.Name;
this.lblBookIdSecond.Text = bookTitleBLL.BookTitleId.ToString();
this.lblIdSecond.Text = this.txtBookId.Text;
count++;
Session["id2"] = this.txtBookId.Text;
Session["bookId2"] = this.lblBookIdSecond.Text;
Session["bookName2"] = this.lblBookTitleSecond.Text;
this.btnRemoveSecond.Visible = true;
}
else if (count == 3)
{
this.lblBookTitleThird.Text = bookTitleBLL.Name;
this.lblBookIdThird.Text = bookTitleBLL.BookTitleId.ToString();
this.lblIdThird.Text = this.txtBookId.Text;
count++;
Session["id3"] = this.txtBookId.Text;
Session["bookId3"] = this.lblBookIdThird.Text;
Session["bookName3"] = this.lblBookTitleThird.Text;
this.btnRemoveThird.Visible = true;
}
else
{
}
}
}
}
}
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 static List <string> getAuthorId(BookTitleBLL bookTitleBLL)
{
string sql = "SELECT * FROM [tacgia_dausach] WHERE madausach=" + bookTitleBLL.BookTitleId;
DataTable dt = new DataTable();
dt = _condb.getDataTable(sql);
List <string> authorIdList = new List <string>();
foreach (DataRow row in dt.Rows)
{
authorIdList.Add(row["matacgia"].ToString());
}
return(authorIdList);
}
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 <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);
}
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);
}
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);
}
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 setAmountOfBook(BookTitleBLL bookTitleBLL)
{
this.txtBookTotal.Text = bookTitleBLL.getAmountOfBook().ToString();
}
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);
}
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 BookGUI(BookTitleBLL bookTitleBLL)
{
this._bookTitleBLL = bookTitleBLL;
InitializeComponent();
}
