private void btnDelete_Click(object sender, EventArgs e) { if (!DeleteGotEmptyField() && IsMidExist2() && !DeleteGotEmptyField()) { if (MessageBox.Show("Confirm to delete?", "Delete Confirmation", MessageBoxButtons.YesNo) == DialogResult.Yes) { var mid = Convert.ToInt32(txtMIDDelete.Text); Member nMember = context.Members.Where(x => x.MemberID == mid).First(); IssueTran issue = context.IssueTrans.Where(x => x.MemberID == mid).First(); context.IssueTrans.Remove(issue); context.Members.Remove(nMember); MessageBox.Show("Delete Successfully."); } } 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(); } }