protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity <Books>(entity => { entity.Property(e => e.CoverPrice) .IsRequired() .HasColumnType("money"); }); modelBuilder.Entity <Users>(entity => { entity.Property(e => e.DateOfCheckout) .HasColumnType("date") .HasDefaultValueSql("(getdate())"); }); modelBuilder.Entity <Books>().HasData(new Books { BookId = Guid.NewGuid(), Title = "Being a great Staff of Health Station", Isbn = "1234-PPL-HS", PublishYear = "2020", CoverPrice = 1800.00, AvailabilityStatus = "check-in" }, new Books { BookId = Guid.NewGuid(), Title = "INterview 101", Isbn = "13454-PPL-HS", PublishYear = "2020", CoverPrice = 1800.00, AvailabilityStatus = "check-Out" }); modelBuilder.Entity <Users>().HasData(new Users { UserId = Guid.NewGuid(), FullName = "Lawrence Olaoluwa", Email = "*****@*****.**", PhoneNumber = "08161813410", NationalIdentificationNumber = "12345678", DateOfCheckout = DateTime.Now, ExpectedDateOfReturn = DateTimeExtensions.AddWorkdays(DateTime.Now, 10), BookId = Guid.Parse("54E6C636-55F6-4176-97CA-60CB32E8ED8E") }, new Users { UserId = Guid.NewGuid(), FullName = "Joseph Olaoluwa", Email = "*****@*****.**", PhoneNumber = "12345678980", NationalIdentificationNumber = "123", DateOfCheckout = DateTime.Now, ExpectedDateOfReturn = DateTimeExtensions.AddWorkdays(DateTime.Now, 10), BookId = Guid.Parse("54E6C636-55F6-4176-97CA-60CB32E8ED8E") }); }
public IActionResult CheckOutBooks([FromBody] List <CheckOut> book) { if (!ModelState.IsValid) { return(BadRequest()); } else { string Token = String.Empty; Token = Request.Headers["Username"]; if (Token == "User") { try { foreach (var item in book) { var newUser = new Users() { UserId = Guid.NewGuid(), FullName = item.FullName, Email = item.Email, PhoneNumber = item.PhoneNumber, NationalIdentificationNumber = item.NationalIdentificationNumber, DateOfCheckout = DateTime.Now, ExpectedDateOfReturn = DateTimeExtensions.AddWorkdays(DateTime.Now, 10), HasReturnedBook = false }; _user.Add(newUser); } return(Ok(book)); } catch (Exception) { return(BadRequest()); } } else { return(Unauthorized()); } } }