select * from Workshop

exec addWorkshopToDay
    @workshopID = 1,
    @conferenceDayID = 5,
    @participantsLimit = 30,
    @price = 100,
    @room = 19,
    @from = '10:00:00',
    @to = '12:00:00'


exec addDiscountToDay
    @percentage = 10,
    @daysBefore = 15,
    @conferenceDayID = 1

select * from Workshop_In_Day
select * from Discount

exec addPerson
    @firstName = 'Sebastian',
    @lastName = 'Gaweł',
    @address = 'bbb',
    @city = 'Warszawa',
    @country = 'Poland',
    @phone = 1092433,
    @mail = 'mlladaf.com'

exec addCompany
    @name = 'lepszaFirma',
    @address = 'bbb',
    @city = 'Lublin',
    @Country = 'Poland',
    @Phone = 984324945,
    @Mail = 'klfjaf.pl',
    @Contact_Person = 'Adam Mickiewicz'

select * from Company

declare @resid int
exec addReservation
    @normalTicketCount = 2,
    @studentTicketCount = 3,
    @clientID = 3,
    @conferenceDayID = 1,
    @reservationID = @resid


select * from Reservation

select * from Person

exec addPersonToReservation
    @reservationID = 2,
    @personID = 1

exec cancelConference
    @conferenceID = 1

select * from Workshop

select * from Conference

update Conference
set Is_Cancelled = 0
where Is_Cancelled = 1

disable trigger ConferenceDayCancellation on Conference_Day
enable trigger ConferenceDayCancellation on Conference_Day
disable trigger DayConferenceParticipantsLimitChange on Conference_Day
enable trigger DayConferenceParticipantsLimitChange on Conference_Day

update Conference_Day
set Is_Cancelled = 0
where Is_Cancelled = 1

select * from Conference_Day

update Reservation
set Is_Cancelled = 0
where Is_Cancelled = 1

select * from Reservation

select * from Workshop_Reservation

select * from Workshop_Participant
select * from Conference_Day_Participant

select * from Person
exec addPersonToReservation
    @reservationID = 2,
    @personID = 1,
    @isStudent = 0

exec addPersonToWorkshopReservation
    @personID = 1,
    @workshopReservationID = 1

update dbo.Workshop_Reservation
set Is_Cancelled = 0
where Is_Cancelled = 1


select * from Workshop_In_Day
select dbo.FreePlacesForWorkshopInDay(3,1)
declare @wshid int
exec addWorkshopReservation
    @reservationID = 2,
    @workshopID = 3,
    @conferenceDayID = 1,
    @ticketsCount = 2,
    @workshopReservationID = @wshid

select * from Workshop_Reservation
select * from Workshop_In_Day

update Workshop_In_Day
set Participants_Limit = 1
where Workshop_ID = 3 and Conference_Day_ID = 1


update Conference_Day
set Participants_Limit = 2
where Conference_Day_ID = 1

exec addWorkshopToDay
 @workshopID = 1,
    @conferenceDayID = 1,
    @participantsLimit = 30,
    @price = 60,
    @room = 14,
    @from = '09:50:00',
    @to = '19:50:00'

declare @wshid int
exec addWorkshopReservation
    @reservationID = 2,
    @workshopID = 1,
    @conferenceDayID = 1,
    @ticketsCount = 2,
    @workshopReservationID = @wshid

select * from Workshop_Reservation

select * from Workshop_Participant
select * from Conference_Day_Participant
select * from Conference
exec addPersonToWorkshopReservation
    @personID = 1,
    @workshopReservationID = 2

exec cancelConference
    @conferenceID = 1

select * from Reservation
select * from Conference
select * from availableConferences
select * from Workshop_In_Day
select * from upcomingWorkshops
select * from availableWorkshops
select * from Personal_Identifier_Badge
select * from DayReservations
select * from CancelledDayReservations
select * from DayReservationsNotFilledWithParticipants
select * from WorkshopReservations
select * from CancelledWorkshopReservations
select * from WorkshopReservationsNotFilledWithParticipants
select * from ReservationsMonetary
select * from ReservationsNotFullyPaidYet
select * from ReservationsOverpaid
select * from ConferencesParticipants
select * from HighestNumberOfReservations
select * from HighestAmountPaidForReservations