public ActionResult FinalizeReservation(int reservationId)
{
BookReserve bookReserve = db.BookReserves.Where(a => a.BookReserveId == reservationId).Single();
User user = db.Users.Where(a => a.UserId == bookReserve.UserId).Single();
BookCode bookCode = new BookCode();
bookCode = db.BookCodes.Where(a => a.BookCodeId == bookReserve.BookCodeId && a.IsInLibrary == true).First();
bookCode.IsInLibrary = false;
Booking booking = new Booking();
booking.BookId = bookCode.BookId;
booking.User = user;
booking.DateCreated = DateTime.Now;
booking.DateReturned = null;
booking.BookCodeId = bookCode.BookCodeId;
booking.Book = db.Books.Where(a => a.BookCode.FirstOrDefault().BookCodeId == bookCode.BookCodeId).Single();
user.Bookings.Add(booking);
if (ModelState.IsValid)
{
db.BookReserves.Remove(bookReserve);
db.Bookings.AddOrUpdate(booking);
db.BookCodes.AddOrUpdate(bookCode);
db.SaveChanges();
return(RedirectToAction("ListOfReservations"));
}
return(View("Error"));
}
private void DgvReserves_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
reserveId = Convert.ToInt32(DgvReserves.Rows[e.RowIndex].Cells[0].Value);
reserve = db.BookReserves.Find(reserveId);
User = db.Users.Find(reserve.UserId);
admin = db.Admins.Find(reserve.AdminId);
book = db.Books.Find(reserve.BookId);
TxtUniqueId.Visible = true;
CmbUniqueId.Visible = false;
LblBookName.Location = new Point(6, 196);
CmdBookName.Location = new Point(121, 190);
PnlButtons.Location = new Point(6, 214);
PnlUser.Visible = false;
PnlDateTime.Visible = true;
PnlDateTime.Location = new Point(5, 59);
BtnBookReservation.Visible = false;
BtnEnd.Visible = true;
GrbBookCrud.Size = new Size(285, 290);
BtnEnd.Enabled = false;
TxtUniqueId.Text = User.UserUniqueId;
CmdBookName.Text = book.Name;
TxtStartTime.Text = Convert.ToDateTime(reserve.StartTime).ToString("dd.MM.yy");
TxtPenalty.Text = reserve.Penalty.ToString();
if (reserve.EndTime == null)
{
BtnEnd.Enabled = true;
}
}
private void DgvReserves_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
reserveId = Convert.ToInt32(DgvReserves.Rows[e.RowIndex].Cells[0].Value);
reserve = db.BookReserves.Find(reserveId);
User = db.Users.Find(reserve.UserId);
admin = db.Admins.Find(reserve.AdminId);
book = db.Books.Find(reserve.BookId);
BtnSearch.Enabled = false;
BtnEnd.Enabled = true;
CmdBookName.Text = book.Name;
CmbUniqueId.Text = User.UserUniqueId;
}
public ActionResult ReservedBook(int bookCodeId, int userId)
{
BookReserve bookReserve = new BookReserve();
bookReserve.BookCodeId = bookCodeId;
bookReserve.ReservationRequestTime = DateTime.Today;
bookReserve.UserId = userId;
db.BookReserves.Add(bookReserve);
db.SaveChanges();
return(View(bookReserve));
}
private void BtnEnd_Click(object sender, EventArgs e)
{
reserve = db.BookReserves.Find(reserveId);
reserve.EndTime = DateTime.Now;
if (reserve.EndTime > reserve.StartTime.Value.AddDays(30))
{
reserve.Penalty = Convert.ToDecimal(reserve.EndTime.Value.Subtract(reserve.StartTime.Value.AddDays(30)).TotalDays);
}
else
{
reserve.Penalty = 0;
}
FillDgvReserves();
Reset();
}
private void BtnEnd_Click(object sender, EventArgs e)
{
reserve = db.BookReserves.Find(reserveId);
reserve.EndTime = DateTime.Now;
book = db.Books.Find(reserve.BookId);
book.Count++;
if (reserve.EndTime > reserve.StartTime.Value.AddDays(30))
{
reserve.Penalty = Convert.ToDecimal(reserve.EndTime.Value.Subtract(reserve.StartTime.Value.AddDays(30)).TotalDays);
}
else
{
reserve.Penalty = 0;
}
MessageBox.Show("Reservaciya sonlandi. \n Odenilecek cerime: {0}", reserve.Penalty.ToString());
FillDgvReserves();
Reset();
}
private void BtnBookReservation_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(CmbUniqueId.Text) || string.IsNullOrEmpty(CmdBookName.Text))
{
MessageBox.Show("Xanalari doldurun");
}
DateTime STime = DateTime.Now;
reserve = new BookReserve()
{
UserId = User.Id,
BookId = book.Id,
AdminId = admin.Id,
StartTime = STime,
};
book = db.Books.Find(reserve.BookId);
book.Count--;
db.BookReserves.Add(reserve);
db.SaveChanges();
FillDgvReserves();
Reset();
}
{ //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
}