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