public static LibTran getLastTransationByBookID(int _book_id) { LibraryDBEntities entity = new LibraryDBEntities(); var q = from t in entity.LibTrans where t.BookID == _book_id group t by t.BookID into g select new { Max = g.Max(b => b.TransactionID), }; int i = 0; foreach (var data in q) { i = data.Max; break; } LibTran tranObj = new LibTran(); if (i > 1) { tranObj = entity.LibTrans.Where(x => x.TransactionID == i).First(); } return(tranObj); }
/// <summary> /// Create a new LibTran object. /// </summary> /// <param name="transactionID">Initial value of the TransactionID property.</param> /// <param name="bookID">Initial value of the BookID property.</param> /// <param name="memberID">Initial value of the MemberID property.</param> /// <param name="lendDate">Initial value of the LendDate property.</param> /// <param name="returnDate">Initial value of the ReturnDate property.</param> /// <param name="chargeAmount">Initial value of the ChargeAmount property.</param> public static LibTran CreateLibTran(global::System.Int32 transactionID, global::System.Int32 bookID, global::System.Int32 memberID, global::System.DateTime lendDate, global::System.DateTime returnDate, global::System.Decimal chargeAmount) { LibTran libTran = new LibTran(); libTran.TransactionID = transactionID; libTran.BookID = bookID; libTran.MemberID = memberID; libTran.LendDate = lendDate; libTran.ReturnDate = returnDate; libTran.ChargeAmount = chargeAmount; return(libTran); }
public static int updateTransaction(LibTran tran) { LibraryDBEntities entity = new LibraryDBEntities(); var tran_row = entity.LibTrans.Where(x => x.TransactionID == tran.TransactionID).SingleOrDefault(); tran_row.ReturnDate = tran.ReturnDate; tran_row.ChargeAmount = tran.ChargeAmount; int i = entity.SaveChanges(); return(i); }
public void fillBookList() { try { lblBookTitlePageTitle.Text = bookmodel.BookTitle; txtBookTitle.Text = bookmodel.BookTitle; txtBookDescription.Text = bookmodel.BookDescription; txtAuthor.Text = bookmodel.Author; txtBookCategory.Text = bookmodel.BookCategory; txtPublisherName.Text = bookmodel.PublisherName; dtpPublishDate.Value = bookmodel.PublishDate.Value; txtRentalPricePerDay.Text = bookmodel.RentalPricePerDay.ToString(); maxAvaiableDaysToRent.Text = bookmodel.MaxAvailableDayToRent.ToString(); } catch { } dt.Rows.Clear(); var books = EntityBroker.getBooksByBookModelID(bookmodel.BookModelId); dgvListOfCopies.DataSource = null; foreach (Book book in books) { string lend_date_str = "-"; string due_date_str = "-"; string status = (book.BookStatus == 0) ? "Rented" : (book.BookStatus == 1) ? "Avaiable" : "Not Avaiable"; LibTran t = EntityBroker.getLastTransationByBookID(book.BookID); if (book.BookStatus == 0) { lend_date_str = t.LendDate.ToString("dd MM yyyy"); DateTime DueDate = t.LendDate.AddDays(Convert.ToDouble(bookmodel.MaxAvailableDayToRent)); due_date_str = DueDate.ToString("dd MM yyyy"); } dt.Rows.Add( book.BookID, status, lend_date_str, due_date_str ); } }
public Window_Popup_ReturnBook(int _book_id) { InitializeComponent(); this.FormBorderStyle = FormBorderStyle.FixedSingle; //make unresizable transaction = EntityBroker.getLastTransationByBookID(_book_id); book = EntityBroker.getBookByBookID(_book_id); member = EntityBroker.getMemberByMemberID(transaction.MemberID); bookmodel = EntityBroker.getBookModelByID(book.BookModelID); calculateCharge(); lblBookTitle.Text = bookmodel.BookTitle; lblBookIDValue.Text = book.BookID.ToString(); lblMemberNameValue.Text = member.MemberName; lblMemberIDValue.Text = member.MemberID.ToString(); lblRentDateValue.Text = transaction.LendDate.ToString("dd MM, yyyy"); lblChargeValue.Text = charge.ToString(); }
/// <summary> /// Deprecated Method for adding a new object to the LibTrans EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToLibTrans(LibTran libTran) { base.AddObject("LibTrans", libTran); }
private void btnRent_Click(object sender, EventArgs e) { //#TODO::ExceptionHandle LibraryDBEntities entity = new LibraryDBEntities(); LibTran t = new LibTran(); int member_id = 0; int book_id = 0; try { book_id = Convert.ToInt32(txtBookID.Text); } catch { MessageBox.Show("BookID you entered is not valid type."); return; } try { member_id = Convert.ToInt32(txtMemberID.Text); } catch { MessageBox.Show("MemberID you entered is not valid type."); return; } Book book = EntityBroker.getBookByBookID(book_id); if (book == null) { MessageBox.Show("BookID doesn't exit."); return; } if (book.BookStatus != 1) { MessageBox.Show("Book is not avaiable to rent."); return; } Member member; member = EntityBroker.getMemberByMemberID(member_id); if (member == null) { MessageBox.Show("MemberID doesn't exit."); return; } t.MemberID = member_id; t.BookID = book_id; t.LendDate = DateTime.Now; entity.AddToLibTrans(t); try { entity.SaveChanges(); }catch { MessageBox.Show("User not exit"); } Book b = entity.Books.Where(x => x.BookID == t.BookID).SingleOrDefault(); b.BookStatus = 0; int i = entity.SaveChanges(); if (i == 1) { try { ucListBooks booklist = new ucListBooks(); booklist.setMainWindowRefrence(MainWindowObject); MainWindowObject.RequestContentChange(booklist); } catch { MessageBox.Show("Exception. Please close the window manually. Sorry for inconvenience"); } } this.Close(); }