public async Task <IActionResult> Edit(int id, [Bind("RentedBookID,StudentID,BookID,RentDate,ReturnDate")] RentedBook rentedBook) { if (id != rentedBook.RentedBookID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(rentedBook); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!RentedBookExists(rentedBook.RentedBookID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["BookID"] = new SelectList(_context.Books, "BookID", "BookID", rentedBook.BookID); ViewData["StudentID"] = new SelectList(_context.Students, "StudentID", "StudentID", rentedBook.StudentID); return(View(rentedBook)); }
public async Task <IActionResult> Create([Bind("RentedBookID,StudentID,BookID,RentDate,ReturnDate")] RentedBook rentedBook) { Book book = _context.Books.Find(rentedBook.BookID); var checkBook = _context.RentedBooks .Include(r => r.Book) .Include(r => r.Student).ToList(); // if there are more than 1, book will be issued if (book.AvailableQuantity >= 1) { book.AvailableQuantity -= 1; _context.Entry(book).State = EntityState.Modified; if (ModelState.IsValid) { _context.Add(rentedBook); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } } // if none, give a message telling user that the book is current unavailable else { ModelState.AddModelError(string.Empty, "The book is unavailable! It is rented by other students."); } ViewData["BookID"] = new SelectList(_context.Books, "BookID", "BookID", rentedBook.BookID); ViewData["StudentID"] = new SelectList(_context.Students, "StudentID", "StudentID", rentedBook.StudentID); return(View(rentedBook)); }
public void Add(RentedBook rentedBook) { using (context = new LibraryDBContext()) { context.RentedBooks.Add(rentedBook); context.SaveChanges(); } }
public void Remove(RentedBook rentedBook) { using (context = new LibraryDBContext()) { RentedBook newRentedBook = context.RentedBooks.FirstOrDefault(x => x.Id == rentedBook.Id); context.RentedBooks.Remove(newRentedBook); context.SaveChanges(); } }
public ActionResult Rent([Bind(Include = "Id,BookId,UserId,DateRented,DateToReturn,IsDeleted")] RentedBook rentedBook) { if (ModelState.IsValid) { _rentedBookRepo.Create(Mapper.Map <RentedBookBusiness>(rentedBook)); return(RedirectToAction("Index")); } return(View(rentedBook)); }
public ActionResult DeleteConfirmed(int id) { RentedBook rentedBook = db.RentedBooks.Find(id); Book book = db.Books.Find(rentedBook.BookId); book.Available = true; db.RentedBooks.Remove(rentedBook); db.Entry(book).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); }
public void ReturnBook(int id, int orderId, decimal price) { Book book = _context.Books.Find(id); book.CountNow += 1; _context.SaveChanges(); RentedBook rentedBook = _context.RentedBooks.Find(orderId); rentedBook.isReturn = true; rentedBook.CalcPrice = price; _context.SaveChanges(); }
// GET: Users/Rent/5 public ActionResult Rent() { //User user = Mapper.Map<User>(_userRepo.Read(id)); var rentedBookView = new RentedBook { DateRented = DateTime.Now, DateToReturn = DateTime.Now.AddMonths(1) }; ViewBag.BookId = new SelectList(_bookRepo.ReadAll(), "Id", "Name"); ViewBag.UserId = new SelectList(_userRepo.ReadAll(), "Id", "Name"); return(View(rentedBookView)); }
public async Task <IActionResult> Create([Bind("RentedBookID,StudentID,BookID,RentDate,ReturnDate")] RentedBook rentedBook) { if (ModelState.IsValid) { _context.Add(rentedBook); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["BookID"] = new SelectList(_context.Books, "BookID", "BookID", rentedBook.BookID); ViewData["StudentID"] = new SelectList(_context.Students, "StudentID", "StudentID", rentedBook.StudentID); return(View(rentedBook)); }
public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } RentedBook rentedBook = db.RentedBooks.Find(id); if (rentedBook == null) { return(HttpNotFound()); } return(View(rentedBook)); }
public ActionResult RentConfirmation(int id) { Book book = db.Books.Find(id); if (book == null) { return(HttpNotFound()); } var model = new RentedBook(); model.BookId = id; model.RentDate = DateTime.Now; model.ReturnDate = model.RentDate.AddDays(14); model.Penalty = 0; return(View(book)); }
public ActionResult <CreateRentedBook> RentBook(CreateRentedBook rentedBook) { RentedBook rented = _mapper.Map <RentedBook>(rentedBook); try { var test = _repository.RentBook(rented); _repository.SaveChanges(); CreateRentedBook rentBookDto = _mapper.Map <CreateRentedBook>(test); return(Ok(rentBookDto)); } catch (KeyNotFoundException e) { return(NotFound(e.Data["Error"])); } }
public ActionResult RentConfirmation([Bind(Include = "RentedBookId,BookId,UserId,RentDate,ReturnDate,Penalty")] RentedBook rentedBook) { rentedBook.UserName = User.Identity.GetUserName(); rentedBook.RentDate = DateTime.Now; rentedBook.ReturnDate = rentedBook.RentDate.AddDays(14); Book book = db.Books.Find(rentedBook.BookId); book.Available = false; db.Entry(book).State = EntityState.Modified; if (ModelState.IsValid) { db.RentedBooks.Add(rentedBook); db.SaveChanges(); return(RedirectToAction("Index", "Books")); } return(View(rentedBook)); }
private void BtnSaveOrder_Click(object sender, RoutedEventArgs e) { if (customer != null) { if (selectedBooks.Any()) { if (MessageBox.Show("Do you want to add this order?", "Question", MessageBoxButton.YesNo, MessageBoxImage.Information) == MessageBoxResult.Yes) { Order order = new Order(); order.CustomerId = customer.Id; order.TakedDate = DateTime.Today; dr.AddOrder(order); RentedBook rentedBook = new RentedBook(); foreach (SelectedBook book in selectedBooks) { rentedBook.BookId = book.Id; rentedBook.OrderId = order.Id; rentedBook.ReturnDate = book.ReturnDate; rentedBook.CalcPrice = book.CalcPrice; rentedBook.Price = book.Price; dr.RentBook(book.Id); dr.AddRentBook(rentedBook); } } this.Close(); } else { MessageBox.Show("You not selected Book!!!"); } } else { MessageBox.Show("You not selected Customer!!!"); } }
public async Task <IActionResult> DeleteConfirmed(int id) { RentedBook rentedBook = await _context.RentedBooks.FindAsync(id); var book = _context.Books.Find(rentedBook.BookID); if (book == null) { return(RedirectToAction(nameof(Index))); } try { // when a book is returned, book is back to stock => quantity + 1 book.AvailableQuantity += 1; _context.RentedBooks.Remove(rentedBook); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } catch { return(RedirectToAction(nameof(Delete), new { id = id, saveChangesError = true })); } }
public RentedBook RentBook(RentedBook rentBook) { if (_context.Book.FirstOrDefault(b => b.BookId == rentBook.BookId) == null) { KeyNotFoundException e = new KeyNotFoundException(""); e.Data["Error"] = new { Errors = new { BookId = $"Book with id {rentBook.BookId} could not be found" }, Type = "https://tools.ietf.org/html/rfc7231#section-6.5.4", Status = 404 }; throw e; } if (_context.Users.FirstOrDefault(u => u.UserId == rentBook.UserId) == null) { KeyNotFoundException e = new KeyNotFoundException(""); e.Data["Error"] = new { Errors = new { BookId = $"User with id {rentBook.UserId} could not be found" }, Type = "https://tools.ietf.org/html/rfc7231#section-6.5.4", Status = 404 }; throw e; } _context.RentedBook.Add(rentBook); SaveChanges(); return(rentBook); }
/* Called just after creating this rental */ private void StartRental() { RentedBook.BorrowBook(); AssociatedUser.AddBook(); }
public static void Initialize(DatabaseContext context) { context.Database.EnsureCreated(); // Look for any students. if (context.Books.Any()) { return; // DB has been seeded } var books = new Book[] { new Book { BookName = "The Hiding Place", Author = "Corrie ten Boom", Edition = "35th", ISBN = 9780800794057, Subject = "Literature", PublicDate = DateTime.Parse("2016-01-01"), Format = "Paperback", NumofPages = 144 }, new Book { BookName = "The Common Core Mathematics Companion: The Standards Decoded", Author = " Linda M. Gojak", Edition = "1st", ISBN = 9781483381602, Subject = "Math", PublicDate = DateTime.Parse("2015-07-05"), Format = "Paperback", NumofPages = 320 } }; foreach (Book b in books) { context.Books.Add(b); } context.SaveChanges(); var students = new Student[] { new Student { StudentFirstName = "Thuan", StudentLastName = "Ho", StudentEmail = "*****@*****.**" }, new Student { StudentFirstName = "John", StudentLastName = "Henry", StudentEmail = "*****@*****.**" } }; foreach (Student c in students) { context.Students.Add(c); } context.SaveChanges(); var rentedBooks = new RentedBook[] { new RentedBook { BookID = 2, StudentID = 2, RentDate = DateTime.Now, ReturnDate = DateTime.Parse("2019-10-02") }, new RentedBook { BookID = 1, StudentID = 1, RentDate = DateTime.Now, ReturnDate = DateTime.Parse("2019-09-02") } }; foreach (RentedBook r in rentedBooks) { context.RentedBooks.Add(r); } context.SaveChanges(); }
public static void Initialize(LibDbContext context) { context.Database.EnsureCreated(); // initial data for BOOK if (context.Books.Any()) { return; } var books = new Book[] { new Book { BookName = "Book 1", Author = "Author 1", Edition = "1st", ISBN = 111111111, Subject = "Math", PublicDate = DateTime.Parse("2005-09-01"), Format = "Paperback", NumofPages = 111, AvailableQuantity = 1 }, new Book { BookName = "Book 2", Author = "Author 2", Edition = "2nd", ISBN = 222222222, Subject = "Physic", PublicDate = DateTime.Parse("2002-09-01"), Format = "Paperback", NumofPages = 222, AvailableQuantity = 2 }, new Book { BookName = "Book 3", Author = "Author 3", Edition = "3rd", ISBN = 333333333, Subject = "Chemistry", PublicDate = DateTime.Parse("2003-09-01"), Format = "Paperback", NumofPages = 333, AvailableQuantity = 3 }, new Book { BookName = "Book 4", Author = "Author 4", Edition = "4th", ISBN = 444444444, Subject = "Psychology", PublicDate = DateTime.Parse("2005-09-01"), Format = "Paperback", NumofPages = 444, AvailableQuantity = 4 }, new Book { BookName = "Book 5", Author = "Author 5", Edition = "5th", ISBN = 555555555, Subject = "Math", PublicDate = DateTime.Parse("2007-08-02"), Format = "Paperback", NumofPages = 555, AvailableQuantity = 5 }, new Book { BookName = "Book 6", Author = "Author 6", Edition = "6th", ISBN = 666666666, Subject = "Accounting", PublicDate = DateTime.Parse("2010-09-01"), Format = "Paperback", NumofPages = 666, AvailableQuantity = 6 }, new Book { BookName = "Book 7", Author = "Author 7", Edition = "7th", ISBN = 777777777, Subject = "Architecture", PublicDate = DateTime.Parse("2012-09-05"), Format = "Paperback", NumofPages = 777, AvailableQuantity = 7 }, new Book { BookName = "Book 8", Author = "Author 8", Edition = "8th", ISBN = 888888888, Subject = "Film Making", PublicDate = DateTime.Parse("2006-09-01"), Format = "Paperback", NumofPages = 888, AvailableQuantity = 8 }, }; foreach (Book b in books) { context.Books.Add(b); } context.SaveChanges(); // initial data for STUDENT var students = new Student[] { new Student { StudentFirstName = "First Name 1", StudentLastName = "Last Name 1", StudentEmail = "*****@*****.**", StudentPhoneNumber = "1111111111" }, new Student { StudentFirstName = "First Name 2", StudentLastName = "Last Name 2", StudentEmail = "*****@*****.**", StudentPhoneNumber = "2222222222" }, new Student { StudentFirstName = "First Name 3", StudentLastName = "Last Name 3", StudentEmail = "*****@*****.**", StudentPhoneNumber = "3333333333" }, new Student { StudentFirstName = "First Name 4", StudentLastName = "Last Name 4", StudentEmail = "*****@*****.**", StudentPhoneNumber = "4444444444" }, new Student { StudentFirstName = "First Name 5", StudentLastName = "Last Name 5", StudentEmail = "*****@*****.**", StudentPhoneNumber = "5555555555" } }; foreach (Student s in students) { context.Students.Add(s); } context.SaveChanges(); // initial data for LIST OF RENTED BOOKS var rentedbooks = new RentedBook[] { new RentedBook { StudentID = 1, BookID = 2, RentDate = DateTime.Parse("2019-08-17"), ReturnDate = DateTime.Parse("2019-08-21") }, new RentedBook { StudentID = 1, BookID = 1, RentDate = DateTime.Parse("2019-08-20"), ReturnDate = DateTime.Parse("2019-08-27") }, new RentedBook { StudentID = 3, BookID = 4, RentDate = DateTime.Parse("2019-08-10"), ReturnDate = DateTime.Parse("2019-08-17") }, new RentedBook { StudentID = 2, BookID = 5, RentDate = DateTime.Parse("2019-08-16"), ReturnDate = DateTime.Parse("2019-08-26") }, }; foreach (RentedBook rb in rentedbooks) { context.RentedBooks.Add(rb); } context.SaveChanges(); }
public void AddRentBook(RentedBook rentedBook) { _context.RentedBooks.Add(rentedBook); _context.SaveChanges(); }
protected override void Seed(Library_Managment.DAL.AppContext context) { //Books Book book1 = new Book { Name = "The Lion, the Witch and the Wardrobe", Author = "C. S. Lewis", Count = 8, CountNow = 6, Price = 55.5M }; Book book2 = new Book { Name = "She: A History of Adventure", Author = "H. Rider Haggard", Count = 4, CountNow = 2, Price = 109.8M }; Book book3 = new Book { Name = "The Adventures of Pinocchio", Author = "Carlo Collodi", Count = 2, CountNow = 1, Price = 87.5M }; Book book4 = new Book { Name = "Vardi Wala Gunda", Author = "Ved Prakash Sharma", Count = 12, CountNow = 11, Price = 95.0M }; Book book5 = new Book { Name = "The Da Vinci Code", Author = "Dan Brown", Count = 23, CountNow = 21, Price = 25.8M }; Book book6 = new Book { Name = "Harry Potter and the Chamber of Secrets", Author = "J. K. Rowling", Count = 48, CountNow = 47, Price = 89.9M }; Book book7 = new Book { Name = "Harry Potter and the Prisoner of Azkaban", Author = "J. K. Rowling", Count = 48, CountNow = 47, Price = 89.9M }; Book book8 = new Book { Name = "The Alchemist", Author = "Paulo Coelho", Count = 9, CountNow = 7, Price = 94.7M }; Book book9 = new Book { Name = "The Catcher in the Rye", Author = " J. D. Salinger", Count = 38, CountNow = 37, Price = 23.8M }; Book book10 = new Book { Name = "Think and Grow Rich", Author = "Napoleon Hill", Count = 81, CountNow = 79, Price = 25.2M }; Book book11 = new Book { Name = "The Bridges of Madison County", Author = "Robert James Waller", Count = 21, CountNow = 20, Price = 17.4M }; Book book12 = new Book { Name = "Ben-Hur: A Tale of the Christ", Author = "Lew Wallace", Count = 19, CountNow = 18, Price = 38M }; Book book13 = new Book { Name = "Harry Potter and the Goblet of Fire", Author = "J. K. Rowling", Count = 48, CountNow = 47, Price = 89.9M }; Book book14 = new Book { Name = "Harry Potter and the Order of the Phoenix", Author = "J. K. Rowling", Count = 48, CountNow = 46, Price = 89.9M }; Book book15 = new Book { Name = "Harry Potter and the Half-Blood Prince", Author = "J. K. Rowling", Count = 48, CountNow = 47, Price = 89.9M }; Book book16 = new Book { Name = "Harry Potter and the Deathly Hallows", Author = "J. K. Rowling", Count = 48, CountNow = 47, Price = 89.9M }; context.Books.AddOrUpdate(book1); context.Books.AddOrUpdate(book2); context.Books.AddOrUpdate(book3); context.Books.AddOrUpdate(book4); context.Books.AddOrUpdate(book5); context.Books.AddOrUpdate(book6); context.Books.AddOrUpdate(book7); context.Books.AddOrUpdate(book8); context.Books.AddOrUpdate(book9); context.Books.AddOrUpdate(book10); context.Books.AddOrUpdate(book11); context.Books.AddOrUpdate(book12); context.Books.AddOrUpdate(book13); context.Books.AddOrUpdate(book14); context.Books.AddOrUpdate(book15); context.Books.AddOrUpdate(book16); context.SaveChanges(); //Customers Customer cust1 = new Customer { FullName = "Memmedli Agasef", CreateDate = DateTime.Today.AddDays(-5), PhoneNumber = "+994552995921", Address = "Baku,Nizami,Naxcivaski 72", }; Customer cust2 = new Customer { FullName = "Ehmedov Behruz", CreateDate = DateTime.Today.AddDays(-28), PhoneNumber = "+994556965575", Address = "Tovuz,Qovlar kendi", }; Customer cust3 = new Customer { FullName = "Memmedov Teymur", CreateDate = DateTime.Today.AddDays(-95), PhoneNumber = "+994772456372", Address = "Masalli,Hacitepe k", }; Customer cust4 = new Customer { FullName = "Veliyev Xudaverdi", CreateDate = DateTime.Today.AddDays(-16), PhoneNumber = "+994502993756", Address = "Sumqayit,7 microray", }; Customer cust5 = new Customer { FullName = "Isgenderov Aynur", CreateDate = DateTime.Today.AddDays(-51), PhoneNumber = "+994709938282", Address = "Gence,Nizami", }; Customer cust6 = new Customer { FullName = "Hesenov Ates", CreateDate = DateTime.Today.AddDays(-45), PhoneNumber = "+9948922121", Address = "Baki,Binegedi,Eliaga Shix 21", }; Customer cust7 = new Customer { FullName = "Baxisov Xamid", CreateDate = DateTime.Today.AddDays(-15), PhoneNumber = "+994552913425", Address = "Baki,Sabuncu, Oskar Efendiyev 1a", }; Customer cust8 = new Customer { FullName = "Isgenderov Serxan", CreateDate = DateTime.Today.AddDays(-102), PhoneNumber = "+9945565353", Address = "Baki,Ehmedli,Nesreddin Tusi 38", }; context.Customers.AddOrUpdate(cust1); context.Customers.AddOrUpdate(cust2); context.Customers.AddOrUpdate(cust3); context.Customers.AddOrUpdate(cust4); context.Customers.AddOrUpdate(cust5); context.Customers.AddOrUpdate(cust6); context.Customers.AddOrUpdate(cust7); context.Customers.AddOrUpdate(cust8); context.SaveChanges(); //Administrators Administrator admin = new Administrator { Login = "******", Password = "******", FullName = "Yolcu Nasib", CreateDate = DateTime.Today.AddDays(-309), PhoneNumber = "+9942995922", Address = "Baku,Nizami,Naxcivaski 72", }; context.Administrators.AddOrUpdate(admin); context.SaveChanges(); //orders Order order1 = new Order { CustomerId = cust3.Id, TakedDate = DateTime.Today }; Order order2 = new Order { CustomerId = cust4.Id, TakedDate = DateTime.Today }; Order order3 = new Order { CustomerId = cust5.Id, TakedDate = DateTime.Today.AddDays(-58) }; Order order4 = new Order { CustomerId = cust1.Id, TakedDate = DateTime.Today.AddDays(-158) }; Order order5 = new Order { CustomerId = cust2.Id, TakedDate = DateTime.Today.AddDays(-88) }; Order order6 = new Order { CustomerId = cust8.Id, TakedDate = DateTime.Today.AddDays(-8) }; Order order7 = new Order { CustomerId = cust6.Id, TakedDate = DateTime.Today.AddDays(-24) }; Order order8 = new Order { CustomerId = cust7.Id, TakedDate = DateTime.Today.AddDays(-32) }; context.Orders.AddOrUpdate(order1); context.Orders.AddOrUpdate(order2); context.Orders.AddOrUpdate(order3); context.Orders.AddOrUpdate(order4); context.Orders.AddOrUpdate(order5); context.Orders.AddOrUpdate(order6); context.Orders.AddOrUpdate(order7); context.Orders.AddOrUpdate(order8); context.SaveChanges(); //rented book RentedBook rentedBook1 = new RentedBook { BookId = book1.Id, OrderId = order1.Id, ReturnDate = DateTime.Today.AddDays(10), isReturn = false, CalcPrice = Convert.ToDecimal(DateTime.Today.AddDays(10).Subtract(order1.TakedDate).TotalDays) * (book1.Price / 28), Price = book1.Price }; RentedBook rentedBook2 = new RentedBook { BookId = book6.Id, OrderId = order1.Id, ReturnDate = DateTime.Today.AddDays(17), isReturn = false, CalcPrice = Convert.ToDecimal(DateTime.Today.AddDays(17).Subtract(order1.TakedDate).TotalDays) * (book6.Price / 28), Price = book6.Price }; RentedBook rentedBook3 = new RentedBook { BookId = book2.Id, OrderId = order1.Id, ReturnDate = DateTime.Today.AddDays(28), isReturn = false, CalcPrice = Convert.ToDecimal(DateTime.Today.AddDays(28).Subtract(order1.TakedDate).TotalDays) * (book2.Price / 28), Price = book2.Price }; RentedBook rentedBook4 = new RentedBook { BookId = book1.Id, OrderId = order2.Id, ReturnDate = DateTime.Today.AddDays(4), isReturn = false, CalcPrice = Convert.ToDecimal(DateTime.Today.AddDays(4).Subtract(order2.TakedDate).TotalDays) * (book1.Price / 28), Price = book1.Price }; RentedBook rentedBook5 = new RentedBook { BookId = book5.Id, OrderId = order2.Id, ReturnDate = DateTime.Today.AddDays(7), isReturn = false, CalcPrice = Convert.ToDecimal(DateTime.Today.AddDays(7).Subtract(order2.TakedDate).TotalDays) * (book5.Price / 28), Price = book5.Price }; RentedBook rentedBook6 = new RentedBook { BookId = book9.Id, OrderId = order2.Id, ReturnDate = DateTime.Today.AddDays(8), isReturn = false, CalcPrice = Convert.ToDecimal(DateTime.Today.AddDays(8).Subtract(order2.TakedDate).TotalDays) * (book9.Price / 28), Price = book9.Price }; RentedBook rentedBook7 = new RentedBook { BookId = book16.Id, OrderId = order3.Id, ReturnDate = DateTime.Today.AddDays(-10), isReturn = true, CalcPrice = Convert.ToDecimal(DateTime.Today.AddDays(-10).Subtract(order3.TakedDate).TotalDays) * (book16.Price / 28), Price = book16.Price }; RentedBook rentedBook8 = new RentedBook { BookId = book7.Id, OrderId = order3.Id, ReturnDate = DateTime.Today.AddDays(-1), isReturn = true, CalcPrice = Convert.ToDecimal(DateTime.Today.AddDays(-1).Subtract(order3.TakedDate).TotalDays) * (book7.Price / 28), Price = book7.Price }; RentedBook rentedBook9 = new RentedBook { BookId = book3.Id, OrderId = order3.Id, ReturnDate = DateTime.Today.AddDays(18), isReturn = false, CalcPrice = Convert.ToDecimal(DateTime.Today.AddDays(18).Subtract(order3.TakedDate).TotalDays) * (book3.Price / 28), Price = book3.Price }; RentedBook rentedBook10 = new RentedBook { BookId = book4.Id, OrderId = order4.Id, ReturnDate = DateTime.Today.AddDays(1), isReturn = false, CalcPrice = Convert.ToDecimal(DateTime.Today.AddDays(1).Subtract(order4.TakedDate).TotalDays) * (book4.Price / 28), Price = book4.Price }; RentedBook rentedBook11 = new RentedBook { BookId = book15.Id, OrderId = order4.Id, ReturnDate = DateTime.Today.AddDays(57), isReturn = false, CalcPrice = Convert.ToDecimal(DateTime.Today.AddDays(57).Subtract(order4.TakedDate).TotalDays) * (book15.Price / 28), Price = book15.Price }; RentedBook rentedBook12 = new RentedBook { BookId = book11.Id, OrderId = order4.Id, ReturnDate = DateTime.Today.AddDays(28), isReturn = false, CalcPrice = Convert.ToDecimal(DateTime.Today.AddDays(28).Subtract(order4.TakedDate).TotalDays) * (book11.Price / 28), Price = book11.Price }; RentedBook rentedBook13 = new RentedBook { BookId = book8.Id, OrderId = order4.Id, ReturnDate = DateTime.Today.AddDays(-1), isReturn = false, CalcPrice = Convert.ToDecimal(DateTime.Today.AddDays(-1).Subtract(order4.TakedDate).TotalDays) * (book8.Price / 28), Price = book8.Price }; RentedBook rentedBook14 = new RentedBook { BookId = book8.Id, OrderId = order5.Id, ReturnDate = DateTime.Today.AddDays(17), isReturn = false, CalcPrice = Convert.ToDecimal(DateTime.Today.AddDays(17).Subtract(order5.TakedDate).TotalDays) * (book8.Price / 28), Price = book8.Price }; RentedBook rentedBook15 = new RentedBook { BookId = book14.Id, OrderId = order5.Id, ReturnDate = DateTime.Today.AddDays(8), isReturn = false, CalcPrice = Convert.ToDecimal(DateTime.Today.AddDays(8).Subtract(order5.TakedDate).TotalDays) * (book14.Price / 28), Price = book14.Price }; RentedBook rentedBook16 = new RentedBook { BookId = book13.Id, OrderId = order6.Id, ReturnDate = DateTime.Today.AddDays(2), isReturn = false, CalcPrice = Convert.ToDecimal(DateTime.Today.AddDays(2).Subtract(order6.TakedDate).TotalDays) * (book13.Price / 28), Price = book13.Price }; RentedBook rentedBook17 = new RentedBook { BookId = book10.Id, OrderId = order7.Id, ReturnDate = DateTime.Today, isReturn = false, CalcPrice = Convert.ToDecimal(DateTime.Today.Subtract(order7.TakedDate).TotalDays) * (book10.Price / 28), Price = book10.Price }; RentedBook rentedBook18 = new RentedBook { BookId = book10.Id, OrderId = order7.Id, ReturnDate = DateTime.Today.AddDays(18), isReturn = false, CalcPrice = Convert.ToDecimal(DateTime.Today.AddDays(18).Subtract(order7.TakedDate).TotalDays) * (book10.Price / 28), Price = book10.Price }; RentedBook rentedBook19 = new RentedBook { BookId = book2.Id, OrderId = order8.Id, ReturnDate = DateTime.Today.AddDays(18), isReturn = false, CalcPrice = Convert.ToDecimal(DateTime.Today.AddDays(18).Subtract(order8.TakedDate).TotalDays) * (book2.Price / 28), Price = book2.Price }; RentedBook rentedBook20 = new RentedBook { BookId = book12.Id, OrderId = order8.Id, ReturnDate = DateTime.Today.AddDays(-2), isReturn = true, CalcPrice = Convert.ToDecimal(DateTime.Today.AddDays(-2).Subtract(order8.TakedDate).TotalDays) * (book12.Price / 28), Price = book12.Price }; RentedBook rentedBook21 = new RentedBook { BookId = book14.Id, OrderId = order8.Id, ReturnDate = DateTime.Today.AddDays(-4), isReturn = true, CalcPrice = Convert.ToDecimal(DateTime.Today.AddDays(-4).Subtract(order8.TakedDate).TotalDays) * (book14.Price / 28), Price = book14.Price }; RentedBook rentedBook22 = new RentedBook { BookId = book5.Id, OrderId = order8.Id, ReturnDate = DateTime.Today.AddDays(18), isReturn = false, CalcPrice = Convert.ToDecimal(DateTime.Today.AddDays(18).Subtract(order8.TakedDate).TotalDays) * (book5.Price / 28), Price = book5.Price }; context.RentedBooks.AddOrUpdate(rentedBook1); context.RentedBooks.AddOrUpdate(rentedBook2); context.RentedBooks.AddOrUpdate(rentedBook3); context.RentedBooks.AddOrUpdate(rentedBook4); context.RentedBooks.AddOrUpdate(rentedBook5); context.RentedBooks.AddOrUpdate(rentedBook6); context.RentedBooks.AddOrUpdate(rentedBook7); context.RentedBooks.AddOrUpdate(rentedBook8); context.RentedBooks.AddOrUpdate(rentedBook9); context.RentedBooks.AddOrUpdate(rentedBook10); context.RentedBooks.AddOrUpdate(rentedBook11); context.RentedBooks.AddOrUpdate(rentedBook12); context.RentedBooks.AddOrUpdate(rentedBook13); context.RentedBooks.AddOrUpdate(rentedBook14); context.RentedBooks.AddOrUpdate(rentedBook15); context.RentedBooks.AddOrUpdate(rentedBook16); context.RentedBooks.AddOrUpdate(rentedBook17); context.RentedBooks.AddOrUpdate(rentedBook18); context.RentedBooks.AddOrUpdate(rentedBook19); context.RentedBooks.AddOrUpdate(rentedBook20); context.RentedBooks.AddOrUpdate(rentedBook21); context.RentedBooks.AddOrUpdate(rentedBook22); context.SaveChanges(); }
/* Called just before removing this rental from the list */ public void EndRental() { RentedBook.ReturnBook(); AssociatedUser.RemoveBook(); }