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());
}
}
}