private void btnSubmit_Click(object sender, EventArgs e) { DialogResult r = MessageBox.Show("Confirm Return?", "Confirm", MessageBoxButtons.YesNo); short s = Convert.ToInt16(dgvTransaction.CurrentRow.Cells[0].Value.ToString()); DateTime returndate = this.dateTimePicker1.Value.Date; if (r == DialogResult.Yes) { using (TransactionScope ts = new TransactionScope()) { it = context.IssueTrans.Where(x => x.TransactionID == s).First(); it.BorrowStatus = "IN"; it.DateActualReturn = returndate; context.SaveChanges(); ts.Complete(); UpdateStatusBarText("Return of book completed"); } mtxtID_TextChanged(sender, e); } else if (r == DialogResult.No) { UpdateStatusBarText("Please select Transaction"); } }
private void btnBorrow_Click(object sender, EventArgs e) { //if (b.TotalStock == b.NumberBorrowed) //{ // tssStatus.Text = "Out of Stock"; // return; //} DialogResult r = MessageBox.Show("Confirm Borrow?" + Environment.NewLine + "Member ID: " + m.MemberID + Environment.NewLine + "Member Name: " + m.MemberName + Environment.NewLine + "Book ID: " + b.BookID + Environment.NewLine + "Book Title: " + b.BookTitle + Environment.NewLine, "Borrow", MessageBoxButtons.YesNo); if (r == DialogResult.No) { return; } try { IssueTran trans = new IssueTran(); using (TransactionScope ts = new TransactionScope()) { trans.BookID = b.BookID; trans.MemberID = m.MemberID; trans.DateIssue = dtpIssueDate.Value.Date; trans.DateDue = DateTime.Parse(lblDueDate.Text); trans.Remarks = txtRemarks.Text; b.NumberBorrowed += 1; trans.BorrowStatus = "OUT"; context.IssueTrans.Add(trans); context.SaveChanges(); ts.Complete(); } tssStatus.Text = "Borrow Successful!"; DialogResult print = MessageBox.Show("Would you like to print borrow receipt?", "Print receipt", MessageBoxButtons.YesNo); if (print == DialogResult.Yes) { frmGenerateReport fReceipt = new frmGenerateReport(trans.TransactionID); fReceipt.ShowDialog(); } ClearEntries(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnGo_Click(object sender, EventArgs e) { if (txtBook.Text == "") { lblValid.Text = "Please enter Book ID"; EnableButtons(false); return; } short id; int testId; if (!short.TryParse(txtBook.Text, out id)) { if (int.TryParse(txtBook.Text, out testId)) { lblValid.Text = "Book ID should be number less than 32768"; } else { lblValid.Text = "Book ID should only contain numbers"; EnableButtons(false); } return; } Book b = new Book(); try { b = context.Books.Where(x => x.BookID == id).First(); } catch (Exception ex) { lblValid.Text = "Invalid Book ID"; EnableButtons(false); return; } txtBookType.Text = b.BookType; txtBookTitle.Text = b.BookTitle; txtPublisher.Text = b.Publisher; txtTotalStock.Text = b.TotalStock.ToString(); txtNumberBorrow.Text = b.NumberBorrowed.ToString(); txtAuthor.Text = b.Author; if (b.TotalStock == b.NumberBorrowed && b.TotalStock != 0) { ShowAvailDate(true); IssueTran it = new IssueTran(); it = context.IssueTrans.Where(x => x.BookID == id && x.BorrowStatus == "OUT") .OrderBy(x => x.DateDue).First(); DateTime due = Convert.ToDateTime(it.DateDue); txtAvailDate.Text = due.ToString("dd-MMM-yyyy"); } else { ShowAvailDate(false); } lblValid.Text = ""; EnableButtons(true); }