public void CreateGuestEventIsSuccessful()
{
// Arrange
using (new TestDataHelper(GetTestQuery(TestQuery.PopulateBookingAndPaymentsTestData), GetTestQuery(TestQuery.CleanupUnitTestData)))
{
var guestEvent = new GuestEvent
{
GuestId = 1,
GuestEventType = GuestEventType.Modified
};
// Act
guestEventDao.Create(guestEvent);
// Assert
Assert.IsTrue(guestEvent.Id > 0, "Id was not filled in after create");
}
}
/// <summary>
/// Create GuestEvent
/// </summary>
/// <param name="guestEvent">Guest event to add</param>
public void Create(GuestEvent guestEvent)
{
const string SQL_STATEMENT = @"
INSERT INTO Customer.GuestEvent
(
GuestId,
GuestEventTypeCode,
Reference,
Notes,
CreatedByUserId
)
VALUES
(
@GuestId,
@GuestEventTypeCode,
@Reference,
@Notes,
@CreatedByUserId
)
SELECT @Id = SCOPE_IDENTITY()";
var parameters = new List<SqlParameter>
{
DbHelper.CreateParameter(GuestEventMapper.Parameters.GuestId, guestEvent.GuestId),
DbHelper.CreateParameter(GuestEventMapper.Parameters.GuestEventTypeCode, guestEvent.GuestEventType.GetCode()),
DbHelper.CreateParameter(GuestEventMapper.Parameters.Reference, guestEvent.Reference),
DbHelper.CreateParameter(GuestEventMapper.Parameters.Notes, guestEvent.Notes),
DbHelper.CreateParameter<Guid>(GuestEventMapper.Parameters.CreatedByUserId, AuditFieldsHelper.GetUserId())
};
SqlParameter outputKey;
parameters.Add(outputKey = DbHelper.CreateParameterOut<int>(GuestEventMapper.Parameters.Id, SqlDbType.Int));
DbHelper.ExecuteNonQueryCommand(SQL_STATEMENT, parameters: parameters);
guestEvent.Id = DbHelper.ParameterValue<int>(outputKey);
}
