public ActionResult Regulations(int fine, int borrowTime)
{
List <User> listOfUser = new List <User>();
listOfUser = db.Users.ToList();
User user = listOfUser.Where(a => a.UserId == Convert.ToInt32(Session["UserId"])).Single();
string authorName = user.Name + " " + user.Surname;
News news = new News();
LibraryRegulations libraryRegulations = new LibraryRegulations();
news.NewsTitle = "Changes in ";
if (libraryRegulations.BorrowTime != borrowTime)
{
news.NewsContent = "You can borrow your book up to: " + borrowTime.ToString() + " days now." + Environment.NewLine;
news.NewsTitle += " Loan Length ";
}
if (libraryRegulations.Fine != fine)
{
news.NewsContent += "Fine for not returning a book on time is now : £" + fine.ToString();
news.NewsTitle += " Late Fees ";
}
news.IsPinned = true;
news.DisplayOnNews = true;
news.NewsAuthor = authorName;
news.NewsPublicationDate = DateTime.Today;;
libraryRegulations.BorrowTime = borrowTime;
libraryRegulations.Fine = fine;
db.News.Add(news);
db.LibraryRegulations.AddOrUpdate(libraryRegulations);
db.SaveChanges();
return(View());
}
public ActionResult ReturnBook(string bookSerialNumber)
{
// bookSerialNumber = RouteData.Values["SerialNumber"] + Request.Url.Query;
LibraryRegulations libraryRegulations = new LibraryRegulations();
List <BookCode> bookCode = db.BookCodes.ToList();
List <Booking> bookings = db.Bookings.ToList();
BookCode bookCode1 = bookCode.Where(a => a.BookSerialNumber == bookSerialNumber).Single();
if (db.Bookings.Where(a => a.BookCodeId == bookCode1.BookCodeId && a.DateReturned == null).Count() > 0)
{
int bookingId = Int32.Parse(db.Bookings.Where(a => a.BookCodeId == bookCode1.BookCodeId && a.DateReturned == null).Single().BookingId.ToString());
Booking booking = db.Bookings.Where(a => a.BookingId == bookingId).Single();
User user = db.Users.Where(a => a.UserId == booking.UserId).Single();
foreach (var book in bookCode)
{
if (book.BookSerialNumber == bookSerialNumber)
{
booking.DateReturned = DateTime.Today;
book.IsInLibrary = true;
if ((DateTime.Today - booking.DateCreated).TotalDays > libraryRegulations.BorrowTime)
{
//create a fee for user for being late
PaymentLibrary payment = new PaymentLibrary()
{
UserId = user.UserId,
Amount = libraryRegulations.Fine,
BookingId = booking.BookingId,
Status = "Unpaid",
DatePaid = null
};
db.Payments.Add(payment);
}
}
db.BookCodes.AddOrUpdate(book);
}
db.SaveChanges();
return(Redirect("/Admin/BookDatabase"));
}
else
{
return(View("Error"));
}
}
{ //DropCreateDatabaseAlways<LibraryContext>
protected override void Seed(LibraryContext context)
{
LibraryRegulations libraryRegulations = new LibraryRegulations()
{
Fine = 3,
BorrowTime = 7
};
//------------------------------------- PEOPLE
Author author = new Author()
{
Id = 1,
Name = "Joanne",
Surname = "Rowling",
};
context.Authors.Add(author);
Author author1 = new Author()
{
Id = 2,
Name = "Kremi",
Surname = "Super",
};
context.Authors.Add(author1);
Author author2 = new Author()
{
Id = 3,
Name = "Guten",
Surname = "Yers",
};
context.Authors.Add(author2);
Author author3 = new Author()
{
Id = 4,
Name = "Awel",
Surname = "Rona",
};
context.Authors.Add(author3);
Book book = new Book()
{
DateOfPublication = DateTime.Now,
Genre = Genre.Action,
Name = "Harry Potter",
Overview = "good book",
Publisher = "JKR",
BookId = 1,
Rating = 5,
//BookImage = "~/Images/BookImageTest.png",
};
context.Books.Add(book);
Book book2 = new Book()
{
DateOfPublication = DateTime.Now,
Genre = Genre.Horror,
Name = "Lord of The Rings",
Overview = "Fantasy book",
Publisher = "Tolkien",
BookId = 2,
Rating = 5,
//BookImage = "~/Images/BookImageTest.png",
Link = "http://www.china.doingbusinessguide.co.uk/media/880543/Doing_Business_in_China_Guide_PDF.pdf",
};
context.Books.Add(book2);
Book book3 = new Book()
{
DateOfPublication = DateTime.Now,
Genre = Genre.Horror,
Name = "James Bond",
Overview = "Spy book",
Publisher = "007",
BookId = 3,
Rating = 5,
//BookImage = "~/Images/BookImageTest.png",
};
context.Books.Add(book3);
Book book4 = new Book()
{
DateOfPublication = DateTime.Now,
Genre = Genre.Horror,
Name = "Doom",
Overview = "Slayer book",
Publisher = "Bethesda",
// BookImage = "~/Images/BookImageTest.png",
BookId = 6,
Rating = 5,
};
context.Books.Add(book4);
BookCode bookCode = new BookCode()
{
BookCodeId = 1,
BookId = 1,
BookSerialNumber = "33233",
IsInLibrary = true
};
context.BookCodes.Add(bookCode);
BookCode bookCode1 = new BookCode()
{
BookCodeId = 2,
BookId = 1,
BookSerialNumber = "33234",
IsInLibrary = true
};
context.BookCodes.Add(bookCode1);
BookCode bookCode2 = new BookCode()
{
BookCodeId = 3,
BookId = 1,
BookSerialNumber = "33235",
IsInLibrary = false
};
context.BookCodes.Add(bookCode2);
BookCode bookCode3 = new BookCode()
{
BookCodeId = 4,
BookId = 2,
BookSerialNumber = "33236",
IsInLibrary = true
};
context.BookCodes.Add(bookCode3);
BookCode bookCode4 = new BookCode()
{
BookCodeId = 5,
BookId = 2,
BookSerialNumber = "33237",
IsInLibrary = false
};
context.BookCodes.Add(bookCode4);
BookCode bookCode5 = new BookCode()
{
BookCodeId = 4,
BookId = 3,
BookSerialNumber = "33238",
IsInLibrary = false
};
context.BookCodes.Add(bookCode5);
BookCode bookCode6 = new BookCode()
{
BookCodeId = 5,
BookId = 3,
BookSerialNumber = "33239",
IsInLibrary = false
};
context.BookCodes.Add(bookCode6);
//=------------------ User
var hash = SecurePasswordHasher.Hash("abcdef!");
User user = new User();
{
user.Name = "Matt";
user.Surname = "Sean";
user.DateOfBirth = new DateTime(2020, 10, 10);
user.Email = "*****@*****.**";
user.HouseNo = "35";
user.Password = hash;
user.UserRole = "User";
user.ZipCode = "Le27dp";
user.UserId = 1;
// user.ConfirmPassword = hash;
}
context.Users.Add((user));
User user2 = new User();
{
user2.Name = "Ethan";
user2.Surname = "Jason";
user2.DateOfBirth = new DateTime(2000, 10, 10);
user2.Email = "*****@*****.**";
user2.HouseNo = "35";
user2.Password = hash;
user2.UserRole = "Admin";
user2.ZipCode = "Le2 7dp";
user2.UserId = 2;
}
context.Users.Add((user2));
User user3 = new User();
{
user3.Name = "John";
user3.Surname = "Smith";
user3.DateOfBirth = new DateTime(2020, 10, 10);
user3.Email = "*****@*****.**";
user3.HouseNo = "22";
user3.Password = hash;
user3.UserRole = "User";
user3.ZipCode = "Le2 7dp";
user3.UserId = 3;
}
context.Users.Add((user3));
////============ Payment
BookReserve bookReserve = new BookReserve()
{
BookReserveId = 1,
BookCodeId = 1,
UserId = 1,
ReservationRequestTime = DateTime.Now,
};
context.BookReserves.Add(bookReserve);
//=============Reviews
BookReview bookReview = new BookReview();
{
bookReview.BookId = 1;
bookReview.BookReviewId = 1;
bookReview.Content = "Harry Potter is the most miserable, lonely boy you can imagine. He’s shunned by his relatives, the Dursley’s, that have raised him since he was an infant. He’s forced to live in the cupboard under the stairs, forced to wear his cousin Dudley’s hand-me-down clothes, and forced to go to his neighbour’s house when the rest of the family is doing something fun. Yes, he’s just about as miserable as you can get.";
bookReview.UserId = 1;
bookReview.DatePosted = DateTime.Now;
}
context.BookReviews.Add(bookReview);
BookReview bookReview1 = new BookReview();
{
bookReview1.BookId = 2;
bookReview1.BookReviewId = 2;
bookReview1.Content = "content testing";
bookReview1.UserId = 1;
bookReview1.DatePosted = DateTime.Now;
}
context.BookReviews.Add(bookReview1);
//------------------------------------------------
Booking booking = new Booking();
{
booking.BookCodeId = 1;
booking.UserId = 1;
booking.BookId = 1;
booking.DateCreated = new DateTime(2019, 12, 05);
booking.DateReturned = new DateTime(2019, 12, 12);
}
context.Bookings.Add(booking);
Booking booking1 = new Booking();
{
booking1.BookCodeId = 1;
booking1.UserId = 1;
booking1.BookId = 2;
booking1.DateCreated = new DateTime(2021, 12, 05);
booking1.DateReturned = new DateTime(2020, 01, 02);
}
context.Bookings.Add(booking1);
Booking booking2 = new Booking();
{
booking2.BookCodeId = 1;
booking2.UserId = 2;
booking2.BookId = 2;
booking2.DateCreated = new DateTime(2021, 12, 05);
booking2.DateReturned = null;
}
context.Bookings.Add(booking2);
Booking booking3 = new Booking();
{
booking3.BookCodeId = 3;
booking3.UserId = 2;
booking3.BookId = 1;
booking3.DateCreated = new DateTime(2019, 12, 05);
booking3.DateReturned = new DateTime(2020, 04, 01);
}
context.Bookings.Add(booking3);
//--------------------------Payment
// LibraryRegulations libraryRegulations = new LibraryRegulations();
PaymentLibrary payment = new PaymentLibrary();
{
// Booking bookingPayment1 = context.Bookings.Where(a => a.BookingId == 1).Single();
payment.UserId = 1;
payment.Amount = libraryRegulations.Fine;
payment.DatePaid = null;
payment.PaymentLibraryId = 1;
payment.Status = "Unpaid";
payment.BookingId = 2;
// payment.Booking = bookingPayment1;
}
context.Payments.Add(payment);
PaymentLibrary payment1 = new PaymentLibrary();
{
//Booking bookingPayment2 = context.Bookings.Where(a => a.BookingId == 2).Single();
payment1.UserId = 1;
payment1.Amount = libraryRegulations.Fine;
payment1.DatePaid = DateTime.Now;
payment1.PaymentLibraryId = 2;
payment1.Status = "Paid";
payment.BookingId = 1;
// payment.Booking = bookingPayment2;
}
context.Payments.Add(payment1);
//Payment payment2 = new Payment();
//{
// payment2.UserId = 1;
// payment2.Amount = 5;
// payment2.DatePaid = null;
// payment2.PaymentLibraryId = 3;
// payment2.Status = "Unpaid";
// payment.BookingId = 3;
//}
//context.Payments.Add(payment2);
//------------------------------------------------------ COMMENTS
Comment com2 = new Comment();
com2.CommentId = 4;
com2.AuthorId = "1";
com2.Content = " Great book! ";
com2.PersonId = 3;
com2.BookId = 1;
com2.PostId = 1;
com2.IsBlocked = false;
com2.UserRating = 6f;
context.Comment.Add(com2);
Comment com3 = new Comment();
com3.CommentId = 1;
com3.AuthorId = "1";
com3.Content = " Great book! ";
com3.PersonId = 1;
com3.BookId = 2;
com3.PostId = 1;
com3.IsBlocked = false;
com3.UserRating = 6f;
context.Comment.Add(com3);
Comment com4 = new Comment();
com4.CommentId = 4;
com4.AuthorId = "1";
com4.Content = " Great book! ";
com4.PersonId = 1;
com4.BookId = 3;
com4.PostId = 1;
com4.IsBlocked = false;
com4.UserRating = 6f;
context.Comment.Add(com4);
Comment com5 = new Comment();
com5.CommentId = 5;
com5.AuthorId = "3";
com5.Content = " Great book! ";
com5.PersonId = 3;
com5.BookId = 4;
com5.PostId = 1;
com5.IsBlocked = false;
com5.UserRating = 5f;
context.Comment.Add(com5);
//------------------------------------------------------
//-------------------------------------------------------------CommentReply
//CommentReply comReply3 = new CommentReply() { CommentId = 2, CommentReplyID = 4, AuthorId = "1", PersonId = 1, BookId = 1, PostId = 1, Content = "this is a reply" };
//context.CommentReply.Add(comReply3);
//CommentReply comReply4 = new CommentReply() { CommentId = 4, CommentReplyID = 5, AuthorId = "1", PersonId = 1, BookId = 1, PostId = 1, Content = "reply1-2" };
//context.CommentReply.Add(comReply4);
//CommentReply comReply5 = new CommentReply() { CommentId = 2, CommentReplyID = 6, AuthorId = "1", PersonId = 1, BookId = 1, PostId = 1, Content = "this is a reply1-3" };
//context.CommentReply.Add(comReply5);
//base.Seed(context);
//--------------------------------------------------------------Loan info
}
public ActionResult Regulations()
{
LibraryRegulations libraryRegulations = new LibraryRegulations();
return(View(libraryRegulations));
}
private Payment CreatePayment(APIContext apiContext, string redirectUrl)
{
LibraryRegulations libraryRegulations = new LibraryRegulations();
//create itemlist and add item objects to it
var itemList = new ItemList()
{
items = new List <Item>()
};
//Adding Item Details like name, currency, price etc
itemList.items.Add(new Item()
{
name = "Library fee",
currency = "GBP",
price = libraryRegulations.Fine.ToString(),
quantity = "1",
sku = "sku"
});
var payer = new Payer()
{
payment_method = "paypal"
};
// Configure Redirect Urls here with RedirectUrls object
var redirUrls = new RedirectUrls()
{
cancel_url = redirectUrl + "&Cancel=true",
return_url = redirectUrl
};
// Adding Tax, shipping and Subtotal details
var details = new Details()
{
tax = "1",
shipping = "1",
subtotal = "1"
};
//Final amount with details
var amount = new Amount()
{
currency = "GBP",
total = "3", // Total must be equal to sum of tax, shipping and subtotal.
details = details
};
var transactionList = new List <Transaction>();
// Adding description about the transaction
transactionList.Add(new Transaction()
{
description = "Transaction description",
invoice_number = rnd.Next(1, 1000).ToString()
, //Generate an Invoice No
amount = amount,
item_list = itemList
});
this.payment = new Payment()
{
intent = "sale",
payer = payer,
transactions = transactionList,
redirect_urls = redirUrls
};
// Create a payment using a APIContext
return(this.payment.Create(apiContext));
}
