private void retrieveinfo() { if (IsBidExist() && txtBookNameUpdate.Text != string.Empty) { var bid = txtBookNameUpdate.Text; BookListing nbook = context.BookListings.Where(x => x.BookID == bid).First(); txtISBNUpdate.Text = nbook.ISBN.ToString(); txtBookTitleUpdate.Text = nbook.BookTitle.ToString(); cboBoxBookTypeUpdate.SelectedItem = nbook.BookType.ToString(); cboBoxLanguageUpdate.SelectedItem = nbook.Language.ToString(); txtCallNoUpdate.Text = nbook.CallNumber.ToString(); cboBoxSectionUpdate.SelectedItem = nbook.Section.ToString(); txtNoteUpdate.Text = nbook.Notes.ToString(); var aid = nbook.AuthorID; Author author = context.Authors.Where(x => x.AuthorID == aid).First(); cboBoxAuthorUpdate.SelectedItem = author.AuthorName.ToString(); var pid = nbook.PublisherID; Publisher publisher = context.Publishers.Where(x => x.PublisherID == pid).First(); cboBoxPublisherUpdate.SelectedItem = publisher.PublisherName.ToString(); } else if (txtBookNameUpdate.Text == string.Empty) { MessageBox.Show("Please input a Book ID."); } }
private void btnUpdate_Click(object sender, EventArgs e) { //Update booklisting table if (!UpdateGotEmptyField()) { var bid = txtBookNameUpdate.Text; BookListing nbook = context.BookListings.Where(x => x.BookID == bid).First(); nbook.ISBN = txtISBNUpdate.Text; nbook.BookTitle = txtBookTitleUpdate.Text; nbook.BookType = cboBoxBookTypeUpdate.SelectedItem.ToString(); nbook.Language = cboBoxLanguageUpdate.SelectedItem.ToString(); nbook.CallNumber = txtCallNoUpdate.Text; nbook.Section = cboBoxSectionUpdate.SelectedItem.ToString(); nbook.Notes = txtNoteUpdate.Text; Author author = context.Authors.Where(x => x.AuthorName == cboBoxAuthorUpdate.SelectedItem.ToString()).First(); nbook.AuthorID = author.AuthorID; Publisher publisher = context.Publishers.Where(x => x.PublisherName == cboBoxPublisherUpdate.SelectedItem.ToString()).First(); nbook.PublisherID = publisher.PublisherID; //Update adjustment table BookAdjustment adjust = new BookAdjustment(); adjust.BookID = nbook.BookID; adjust.DateAdjust = DateTime.Now; adjust.WhoAdjust = Convert.ToInt32("4000"); if (UpdatedataType()) { int quantity = Convert.ToInt32(txtQuantityUpdate.Text); int totalStock = nbook.TotalStock; int noLoaned = nbook.NumberLoaned; if (quantity > 0 || (quantity < 0 && Math.Abs(quantity) < totalStock - noLoaned)) { nbook.TotalStock = Convert.ToInt32(txtQuantityUpdate.Text) + nbook.TotalStock; adjust.AdjustmentQty = Convert.ToInt32(txtQuantityUpdate.Text); MessageBox.Show("Update book Successfully."); } else if (quantity < 0 && Math.Abs(quantity) > totalStock - noLoaned) { MessageBox.Show("Number of books in library is not enough"); } } if (adjust.AdjustmentQty > 0) { adjust.AdjustmentReason = "Buy new books"; } else if (adjust.AdjustmentQty < 0) { adjust.AdjustmentReason = "Book damaged"; } else { adjust.AdjustmentReason = "Update book information"; } //Update ControlNumber //Save Changes context.BookAdjustments.Add(adjust); context.SaveChanges(); } }
private void btnSubmit_Click(object sender, EventArgs e) { lblMIDWarning.Visible = false; if (hasFieldEmpty() == true) { MessageBox.Show("All fields must be filled/selected. Please indicate NA if no remarks to be made. "); } else { using (TransactionScope ts = new TransactionScope()) { try { IssueTran IT = context.IssueTrans.Where(x => x.TransactionID == TransactionID).First(); IT.DateActualReturn = DateActualReturn; IT.LoanStatus = "IN"; IT.Remarks = txtRemark.Text; IT.OverdueFine = fineAmount; IT.FinePaymentStatus = cboBoxPaymentStatus.SelectedItem.ToString(); IT.BookID = bookID; Member ML = context.Members.Where(x => x.MemberID == MemberID).First(); BookListing BL = context.BookListings.Where(x => x.BookID == bookID).First(); if (BL.NumberLoaned > 0 && ML.CurrentNumberOnLoan > 0) { BL.NumberLoaned--; ML.CurrentNumberOnLoan--; MessageBox.Show("Book Return is successful."); } else { MessageBox.Show("There is an error in the number of books on loan. Please check on transaction record."); } context.SaveChanges(); ts.Complete(); } catch (TransactionException ex) { ts.Dispose(); MessageBox.Show("Transaction Exception Occured"); } } } }
private void CommitTransaction() { using (TransactionScope ts = new TransactionScope()) { // 3. Update IssueTrans table IssueTran it = new IssueTran(); it.MemberID = Int32.Parse(txtBoxMemberID.Text); it.BookID = txtBoxBookID.Text; it.DateBorrow = dtpBorrow.Value.Date; it.DateDue = dtpDue.Value.Date; it.LoanStatus = "OUT"; it.Remarks = "NIL"; it.OverdueFine = 0; it.FinePaymentStatus = "NA"; context.IssueTrans.Add(it); //4. Update Member table : CurentNumberOnLoan Member m = context.Members .Where(x => x.MemberID.ToString() == txtBoxMemberID.Text) .First(); int newNumberOnLoan = context .Members .Where(x => x.MemberID.ToString() == txtBoxMemberID.Text) .Select(x => x.CurrentNumberOnLoan).First() + 1; m.CurrentNumberOnLoan = newNumberOnLoan; //5. Update Book Listing table: NumberLoaned ++ BookListing b = context.BookListings .Where(x => x.BookID.ToString() == txtBoxBookID.Text) .First(); b.NumberLoaned++; //Commit Changes context.SaveChanges(); ts.Complete(); } }
private void btnAdd_Click(object sender, EventArgs e) { PGPLibraryEntities context = new PGPLibraryEntities(); BookListing nbook = new BookListing(); BookAdjustment adjust = new BookAdjustment(); if (!GotEmptyField() && AdddataType() && IsAddMore()) { //Update Booklisting Table nbook.ISBN = txtISBNAdd.Text; nbook.BookTitle = txtBookTitleAdd.Text; nbook.CallNumber = txtCallNoAdd.Text; nbook.Notes = txtNoteAdd.Text; nbook.BookType = cboBoxBookTypeAdd.SelectedItem.ToString(); nbook.Language = cboBoxLanguageAdd.SelectedItem.ToString(); Author author = context.Authors.Where(x => x.AuthorName == cboBoxAuthorAdd.SelectedItem.ToString()).First(); nbook.AuthorID = author.AuthorID; Publisher publisher = context.Publishers.Where(x => x.PublisherName == cboBoxPublisherAdd.SelectedItem.ToString()).First(); nbook.PublisherID = publisher.PublisherID; nbook.Section = cboBoxSectionAdd.SelectedItem.ToString(); nbook.BookID = "B00" + context.ControlTables.Where(x => x.NumberType == "BookID").Select(x => x.FirstFreeNo).First(); nbook.NumberLoaned = 0; //Update BookAdjustment Table adjust.BookID = "B00" + context.ControlTables.Where(x => x.NumberType == "BookID").Select(x => x.FirstFreeNo).First(); adjust.DateAdjust = DateTime.Now; //Librarian librarian = context.Librarians.Where(x => x.Username == lblUser.Text).First(); //adjust.WhoAdjust = librarian.LibrarianID; adjust.WhoAdjust = Convert.ToInt32("4000"); adjust.AdjustmentReason = "Buy new books"; adjust.AdjustmentQty = Convert.ToInt32(txtQuantityAdd.Text); nbook.TotalStock = Convert.ToInt32(txtQuantityAdd.Text); ////Update ControlNumber //ControlTable control = context.ControlTables.Where(x => x.NumberType == "BookID").First(); //control.FirstFreeNo += 1; MessageBox.Show("Add book successfully."); context.BookAdjustments.Add(adjust); context.BookListings.Add(nbook); context.SaveChanges(); } }