/// <summary> /// add book to client order /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnAddBook_Click(object sender, EventArgs e) { try { if (DM.dtClientOrder.Rows[cmClientOrder.Position]["Status"].ToString() == "Current") { string clientOrderID = DM.dtClientOrder.Rows[cmClientOrder.Position]["ClientOrderID"].ToString(); int aClientOrderID = Convert.ToInt32(clientOrderID); string bookID = dgvUnorderedBooks["BookID", cmUnorderedBooks.Position].Value.ToString(); int aBookID = Convert.ToInt32(bookID); cmBook.Position = DM.bookView.Find(aBookID); DataRow newOrder = DM.dtBook.Rows[cmBook.Position]; newOrder["ClientOrderID"] = aClientOrderID; cmBook.EndCurrentEdit(); DM.UpdateBook(); UpdateOrderedBooks(); UpdateUnorderedBooks(); MessageBox.Show("Book Added to Client Order Successfully!", "Success"); } else { MessageBox.Show("Books can only be added to current orders!", "Error"); } } catch (ConstraintException) { MessageBox.Show("This book has already been added to this client order!", "Error"); } }
/// <summary> /// add a new book record /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSaveBook_Click(object sender, EventArgs e) { DataRow newBookRow = DM.dtBook.NewRow(); if (txtAddCost.Text == "") { MessageBox.Show("You must type in a cost!", "Error"); } else if (txtAddPrice.Text == "") { MessageBox.Show("You must type in a price!", "Error"); } else { newBookRow["Cost"] = txtAddCost.Text; newBookRow["Price"] = txtAddPrice.Text; newBookRow["DatePublished"] = this.dtpAddDatePublished.Text; newBookRow["BookInfoID"] = this.cmbAddBookInfoID.GetItemText(this.cmbAddBookInfoID.SelectedItem); newBookRow["VendorID"] = this.cmbAddVendorID.GetItemText(this.cmbAddVendorID.SelectedItem); DM.dtBook.Rows.Add(newBookRow); DM.UpdateBook(); MessageBox.Show("New Book Added Successfully!", "Success"); } }