private void dateTimePicker1_Leave(object sender, EventArgs e) { dateTimePicker2.Value = dateTimePicker1.Value.AddDays(7); Entities ctx = new Entities(); LoanRecord lr = new LoanRecord(); if (dateTimePicker1.Value < System.DateTime.Today) { MessageBox.Show("Issue Date should not be past!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1, MessageBoxOptions.RightAlign, false); } if (dateTimePicker1.Value > System.DateTime.Now) { MessageBox.Show("Issue Date should not be future!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RightAlign, false); return; } }
private void check_in_Click(object sender, EventArgs e) { int loanNumber = (int)dataGridView1.CurrentRow.Cells[0].Value; LoanRecord checkedIn = ctx.LoanRecords.Where(x => x.LoanNumber == loanNumber).First(); checkedIn.DateReturned = dateTimePicker1.Value; checkedIn.LoanStatus = "in"; ctx.SaveChanges(); }
private void btnSave_Click(object sender, EventArgs e) { if (cboMemberID.Text == "--Select ID--" || cboISBN.Text == "--Select ISBN--") { MessageBox.Show("Select MemberID and ISBN!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RightAlign, false); return; } Entities ctx = new Entities(); LoanRecord lr = new LoanRecord(); string memberID = cboMemberID.Text; string isbn = cboISBN.Text; string issueDate = dateTimePicker1.Value.ToString(); string dueDate = dateTimePicker2.Value.ToString(); string qty = txtQuantityOfBook.Text; string remarks = txtRemarks.Text; lr.MemberID = Convert.ToInt32(memberID); lr.ISBN = isbn; lr.DateBorrowed = Convert.ToDateTime(issueDate); lr.DueDate = Convert.ToDateTime(dueDate); lr.Quantity = Convert.ToInt32(qty); lr.LoanStatus = "out"; lr.Remarks = remarks; ctx.LoanRecords.Add(lr); Book b = ctx.Books.Where(x => x.ISBN == isbn).First(); b.TotalOnLoan += Convert.ToInt32(qty); int mID = Convert.ToInt32(cboMemberID.Text); Member m = ctx.Members.Where(x => x.MemberID == mID).First(); m.BooksBorrowed += Convert.ToInt32(qty); if (b.TotalQty < b.TotalOnLoan) { MessageBox.Show("There has no copy. It cannot be lent."); return; } if (lr.DateBorrowed > System.DateTime.Now) { MessageBox.Show("Issue Date should not be future!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RightAlign, false); return; } if (cboMemberID.Text == "--Select ID--" || cboISBN.Text == "--Select ISBN--") { MessageBox.Show("Select MemberID and ISBN!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RightAlign, false); return; } ctx.SaveChanges(); MessageBox.Show("Record is saved."); }