private void btnDeleteCopy_Click(object sender, EventArgs e) { Copy c = new Copy(); c.CopyNumber = Convert.ToInt32(txtCopyNumber.Text); CopyDAO.Delete(c); dgvCopies.DataSource = CopyDAO.GetDataTable(Convert.ToInt32(txtBookNumber1.Text)); MessageBox.Show("Delete Successful"); display(5); }
private void dgvBooks_CellClick(object sender, DataGridViewCellEventArgs e) { display(1); Book b = BookDAO.GetBook(Convert.ToInt32(dgvBooks.Rows[e.RowIndex].Cells["bookNumber"].Value)); txtBookNumber.Text = b.BookNumber.ToString(); txtTitle.Text = b.Title; txtAuthors.Text = b.Authors; txtPublisher.Text = b.Publisher; dgvCopies.DataSource = CopyDAO.GetDataTable(b.BookNumber); txtBookNumber1.Text = b.BookNumber.ToString(); }
private void ViewCopies() { if (dataGridView1.SelectedRows.Count == 0) { return; } int bookNumber = (int)dataGridView1.SelectedRows[0].Cells["bookNumber"].Value; txtCopyBookNumber.Text = bookNumber.ToString(); dvc = new DataView(CopyDAO.GetDataTable()); dvc.RowFilter = "bookNumber = " + bookNumber; dataGridView2.DataSource = dvc; }
private void btnSave_Click(object sender, EventArgs e) { if (check1 == 1) { if (CopyDAO.ValidateCopy(txtSequenceNumber.Text, txtPrice.Text)) { Copy c = new Copy(); c.BookNumber = Convert.ToInt32(txtBookNumber1.Text); c.SequenceNumber = Convert.ToInt32(txtSequenceNumber.Text); c.Type = Convert.ToInt32(txtType.Text); c.Price = Convert.ToDouble(txtPrice.Text); CopyDAO.Add(c); dgvCopies.DataSource = CopyDAO.GetDataTable(c.BookNumber); MessageBox.Show("Add Successful"); display(5); btnSave.Visible = false; check1 = 0; } } else if (check1 == 2) { if (CopyDAO.ValidateCopy(txtSequenceNumber.Text, txtPrice.Text)) { Copy c = new Copy(); c.CopyNumber = Convert.ToInt32(txtCopyNumber.Text); c.BookNumber = Convert.ToInt32(txtBookNumber1.Text); c.SequenceNumber = Convert.ToInt32(txtSequenceNumber.Text); c.Type = Convert.ToInt32(txtType.Text); c.Price = Convert.ToDouble(txtPrice.Text); CopyDAO.Edit(c); dgvCopies.DataSource = CopyDAO.GetDataTable(c.BookNumber); MessageBox.Show("Edit Successful"); display(5); btnSave.Visible = false; check1 = 0; } } }