public bool Handle(UserBorrowBookEvent message) { string insertHistorySql = @"INSERT INTO [BookTransferHistory] ([UserID], [BookID], [Returned], [ReturnedDate], [BorrowedDate]) VALUES (@userId, @bookId, @returned, @returnedDate, @borrowedDate)"; Guid? userGUID = this.GetIDByAggregateRootId("UserAccounts", message.UserAccountId); if (userGUID == null) { throw new InvalidOperationException(string.Format("Cannot find the UserAccount with the AggregateRootId={0}", message.UserAccountId)); } Guid?bookGUID = this.GetIDByAggregateRootId("Books", message.BookId); if (bookGUID == null) { throw new InvalidOperationException(string.Format("Cannot find the Book with the AggregateRootId={0}", message.BookId)); } var rowsAffected = SqlHelper.ExecuteNonQuery(this.QueryDBConnectionString, CommandType.Text, insertHistorySql, new SqlParameter("@userId", userGUID.Value), new SqlParameter("@bookId", bookGUID.Value), new SqlParameter("@returned", false), new SqlParameter("@returnedDate", SqlDateTime.MinValue), new SqlParameter("@borrowedDate", new SqlDateTime(message.TransferDateTime))); return(rowsAffected > 0); }
private void HandleEvent(UserBorrowBookEvent domainEvent) { using (QueryDBEntities _dbContext = new QueryDBEntities()) { BorrowRecord record = new BorrowRecord { UserAggregateRootId = domainEvent.UserAggregateRootId, BookAggregateRootId = domainEvent.BookAggregateRootId, BorrowedDate = domainEvent.BorrowedDate }; _dbContext.BorrowRecord.Add(record); _dbContext.SaveChanges(); } }
private void HandleBorrowBookEvent(UserBorrowBookEvent e) { this.bookIds.Add(e.BookId); }
public void HandleEvent(UserBorrowBookEvent e) { this._bookIds.Add(e.BookAggregateRootId); }