public async Task <Review> Add(Review entity)
{
_bookstoreDbContext.Add(entity);
await _bookstoreDbContext.SaveChangesAsync();
return(entity);
}
public void CreateOrder(Order order, StoreUser storeUser)
{
// var transaction = _bookstoreDbContext.Database.BeginTransaction();
// try
{
order.OrderDate = DateTime.Now;
order.OrderNumber = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString()
+ DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString()
+ DateTime.Now.Second.ToString() + DateTime.Now.Millisecond.ToString();
order.User = storeUser;
order.OrderTotal = _shoppingCart.GetShoppingCartTotal();
order.Condidtion = "Created";
_bookstoreDbContext.Add(order);
_bookstoreDbContext.SaveChanges();
var shoppingCartItems = _shoppingCart.ShoppingCartItems;
foreach (var item in shoppingCartItems)
{
var orderItem = new OrderItem()
{
BookId = item.Book.Id,
OrderId = order.Id,
Price = item.Book.Price * item.Amount,
Amount = item.Amount
};
//var itemStorage = _bookstoreDbContext.Storages.FirstOrDefault(s => s.BookId == item.Book.Id);
//itemStorage.Amount = itemStorage.Amount - orderItem.Amount;
// _bookstoreDbContext.Storages.Update(itemStorage);
_bookstoreDbContext.OrderItems.Add(orderItem);
}
_bookstoreDbContext.SaveChanges();
// transaction.Commit();
}
//catch (Exception e)
//{
// transaction.Rollback();
//}
}