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