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