DELETE FROM [dbo].[Aircrafts] WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ((@IsNull_MakeModel = 1 AND [MakeModel] IS NULL) OR ([MakeModel] = @Original_MakeModel)) AND ([TotalSeats] = @Original_TotalSeats) AND ([EconomySeats] = @Original_EconomySeats) AND ([BusinessSeats] = @Original_BusinessSeats)) INSERT INTO [dbo].[Aircrafts] ([ID], [Name], [MakeModel], [TotalSeats], [EconomySeats], [BusinessSeats]) VALUES (@ID, @Name, @MakeModel, @TotalSeats, @EconomySeats, @BusinessSeats); SELECT ID, Name, MakeModel, TotalSeats, EconomySeats, BusinessSeats FROM Aircrafts WHERE (ID = @ID) SELECT ID, Name, MakeModel, TotalSeats, EconomySeats, BusinessSeats FROM dbo.Aircrafts UPDATE [dbo].[Aircrafts] SET [ID] = @ID, [Name] = @Name, [MakeModel] = @MakeModel, [TotalSeats] = @TotalSeats, [EconomySeats] = @EconomySeats, [BusinessSeats] = @BusinessSeats WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ((@IsNull_MakeModel = 1 AND [MakeModel] IS NULL) OR ([MakeModel] = @Original_MakeModel)) AND ([TotalSeats] = @Original_TotalSeats) AND ([EconomySeats] = @Original_EconomySeats) AND ([BusinessSeats] = @Original_BusinessSeats)); SELECT ID, Name, MakeModel, TotalSeats, EconomySeats, BusinessSeats FROM Aircrafts WHERE (ID = @ID) DELETE FROM [dbo].[Airports] WHERE (([ID] = @Original_ID) AND ([CountryID] = @Original_CountryID) AND ([IATACode] = @Original_IATACode) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name))) INSERT INTO [dbo].[Airports] ([CountryID], [IATACode], [Name]) VALUES (@CountryID, @IATACode, @Name); SELECT ID, CountryID, IATACode, Name FROM Airports WHERE (ID = SCOPE_IDENTITY()) SELECT ID, CountryID, IATACode, Name FROM dbo.Airports UPDATE [dbo].[Airports] SET [CountryID] = @CountryID, [IATACode] = @IATACode, [Name] = @Name WHERE (([ID] = @Original_ID) AND ([CountryID] = @Original_CountryID) AND ([IATACode] = @Original_IATACode) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name))); SELECT ID, CountryID, IATACode, Name FROM Airports WHERE (ID = @ID) DELETE FROM [dbo].[CabinTypes] WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name)) INSERT INTO [dbo].[CabinTypes] ([Name]) VALUES (@Name); SELECT ID, Name FROM CabinTypes WHERE (ID = SCOPE_IDENTITY()) SELECT ID, Name FROM dbo.CabinTypes UPDATE [dbo].[CabinTypes] SET [Name] = @Name WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name)); SELECT ID, Name FROM CabinTypes WHERE (ID = @ID) DELETE FROM [dbo].[Countries] WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name)) INSERT INTO [dbo].[Countries] ([Name]) VALUES (@Name); SELECT ID, Name FROM Countries WHERE (ID = SCOPE_IDENTITY()) SELECT ID, Name FROM dbo.Countries UPDATE [dbo].[Countries] SET [Name] = @Name WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name)); SELECT ID, Name FROM Countries WHERE (ID = @ID) DELETE FROM [dbo].[Offices] WHERE (([ID] = @Original_ID) AND ([CountryID] = @Original_CountryID) AND ([Title] = @Original_Title) AND ([Phone] = @Original_Phone) AND ([Contact] = @Original_Contact)) INSERT INTO [dbo].[Offices] ([CountryID], [Title], [Phone], [Contact]) VALUES (@CountryID, @Title, @Phone, @Contact); SELECT ID, CountryID, Title, Phone, Contact FROM Offices WHERE (ID = SCOPE_IDENTITY()) SELECT ID, CountryID, Title, Phone, Contact FROM dbo.Offices UPDATE [dbo].[Offices] SET [CountryID] = @CountryID, [Title] = @Title, [Phone] = @Phone, [Contact] = @Contact WHERE (([ID] = @Original_ID) AND ([CountryID] = @Original_CountryID) AND ([Title] = @Original_Title) AND ([Phone] = @Original_Phone) AND ([Contact] = @Original_Contact)); SELECT ID, CountryID, Title, Phone, Contact FROM Offices WHERE (ID = @ID) DELETE FROM [dbo].[Roles] WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title)) INSERT INTO [dbo].[Roles] ([ID], [Title]) VALUES (@ID, @Title); SELECT ID, Title FROM Roles WHERE (ID = @ID) SELECT ID, Title FROM dbo.Roles UPDATE [dbo].[Roles] SET [ID] = @ID, [Title] = @Title WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title)); SELECT ID, Title FROM Roles WHERE (ID = @ID) DELETE FROM [dbo].[Routes] WHERE (([ID] = @Original_ID) AND ([DepartureAirportID] = @Original_DepartureAirportID) AND ([ArrivalAirportID] = @Original_ArrivalAirportID) AND ([Distance] = @Original_Distance) AND ([FlightTime] = @Original_FlightTime)) INSERT INTO [dbo].[Routes] ([DepartureAirportID], [ArrivalAirportID], [Distance], [FlightTime]) VALUES (@DepartureAirportID, @ArrivalAirportID, @Distance, @FlightTime); SELECT ID, DepartureAirportID, ArrivalAirportID, Distance, FlightTime FROM Routes WHERE (ID = SCOPE_IDENTITY()) SELECT ID, DepartureAirportID, ArrivalAirportID, Distance, FlightTime FROM dbo.Routes UPDATE [dbo].[Routes] SET [DepartureAirportID] = @DepartureAirportID, [ArrivalAirportID] = @ArrivalAirportID, [Distance] = @Distance, [FlightTime] = @FlightTime WHERE (([ID] = @Original_ID) AND ([DepartureAirportID] = @Original_DepartureAirportID) AND ([ArrivalAirportID] = @Original_ArrivalAirportID) AND ([Distance] = @Original_Distance) AND ([FlightTime] = @Original_FlightTime)); SELECT ID, DepartureAirportID, ArrivalAirportID, Distance, FlightTime FROM Routes WHERE (ID = @ID) DELETE FROM [dbo].[Schedules] WHERE (([ID] = @Original_ID) AND ([Date] = @Original_Date) AND ([Time] = @Original_Time) AND ([AircraftID] = @Original_AircraftID) AND ([RouteID] = @Original_RouteID) AND ([EconomyPrice] = @Original_EconomyPrice) AND ([Confirmed] = @Original_Confirmed) AND ((@IsNull_FlightNumber = 1 AND [FlightNumber] IS NULL) OR ([FlightNumber] = @Original_FlightNumber))) INSERT INTO [dbo].[Schedules] ([Date], [Time], [AircraftID], [RouteID], [EconomyPrice], [Confirmed], [FlightNumber]) VALUES (@Date, @Time, @AircraftID, @RouteID, @EconomyPrice, @Confirmed, @FlightNumber); SELECT ID, Date, Time, AircraftID, RouteID, EconomyPrice, Confirmed, FlightNumber FROM Schedules WHERE (ID = SCOPE_IDENTITY()) SELECT ID, Date, Time, AircraftID, RouteID, EconomyPrice, Confirmed, FlightNumber FROM dbo.Schedules UPDATE [dbo].[Schedules] SET [Date] = @Date, [Time] = @Time, [AircraftID] = @AircraftID, [RouteID] = @RouteID, [EconomyPrice] = @EconomyPrice, [Confirmed] = @Confirmed, [FlightNumber] = @FlightNumber WHERE (([ID] = @Original_ID) AND ([Date] = @Original_Date) AND ([Time] = @Original_Time) AND ([AircraftID] = @Original_AircraftID) AND ([RouteID] = @Original_RouteID) AND ([EconomyPrice] = @Original_EconomyPrice) AND ([Confirmed] = @Original_Confirmed) AND ((@IsNull_FlightNumber = 1 AND [FlightNumber] IS NULL) OR ([FlightNumber] = @Original_FlightNumber))); SELECT ID, Date, Time, AircraftID, RouteID, EconomyPrice, Confirmed, FlightNumber FROM Schedules WHERE (ID = @ID) DELETE FROM [dbo].[Tickets] WHERE (([ID] = @Original_ID) AND ([UserID] = @Original_UserID) AND ([ScheduleID] = @Original_ScheduleID) AND ([CabinTypeID] = @Original_CabinTypeID) AND ([Firstname] = @Original_Firstname) AND ([Lastname] = @Original_Lastname) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ([Phone] = @Original_Phone) AND ([PassportNumber] = @Original_PassportNumber) AND ([PassportCountryID] = @Original_PassportCountryID) AND ([BookingReference] = @Original_BookingReference) AND ([Confirmed] = @Original_Confirmed)) INSERT INTO [dbo].[Tickets] ([UserID], [ScheduleID], [CabinTypeID], [Firstname], [Lastname], [Email], [Phone], [PassportNumber], [PassportCountryID], [BookingReference], [Confirmed]) VALUES (@UserID, @ScheduleID, @CabinTypeID, @Firstname, @Lastname, @Email, @Phone, @PassportNumber, @PassportCountryID, @BookingReference, @Confirmed); SELECT ID, UserID, ScheduleID, CabinTypeID, Firstname, Lastname, Email, Phone, PassportNumber, PassportCountryID, BookingReference, Confirmed FROM Tickets WHERE (ID = SCOPE_IDENTITY()) SELECT ID, UserID, ScheduleID, CabinTypeID, Firstname, Lastname, Email, Phone, PassportNumber, PassportCountryID, BookingReference, Confirmed FROM dbo.Tickets UPDATE [dbo].[Tickets] SET [UserID] = @UserID, [ScheduleID] = @ScheduleID, [CabinTypeID] = @CabinTypeID, [Firstname] = @Firstname, [Lastname] = @Lastname, [Email] = @Email, [Phone] = @Phone, [PassportNumber] = @PassportNumber, [PassportCountryID] = @PassportCountryID, [BookingReference] = @BookingReference, [Confirmed] = @Confirmed WHERE (([ID] = @Original_ID) AND ([UserID] = @Original_UserID) AND ([ScheduleID] = @Original_ScheduleID) AND ([CabinTypeID] = @Original_CabinTypeID) AND ([Firstname] = @Original_Firstname) AND ([Lastname] = @Original_Lastname) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ([Phone] = @Original_Phone) AND ([PassportNumber] = @Original_PassportNumber) AND ([PassportCountryID] = @Original_PassportCountryID) AND ([BookingReference] = @Original_BookingReference) AND ([Confirmed] = @Original_Confirmed)); SELECT ID, UserID, ScheduleID, CabinTypeID, Firstname, Lastname, Email, Phone, PassportNumber, PassportCountryID, BookingReference, Confirmed FROM Tickets WHERE (ID = @ID) DELETE FROM [dbo].[Users] WHERE (([ID] = @Original_ID) AND ([RoleID] = @Original_RoleID) AND ([Email] = @Original_Email) AND ([Password] = @Original_Password) AND ((@IsNull_FirstName = 1 AND [FirstName] IS NULL) OR ([FirstName] = @Original_FirstName)) AND ([LastName] = @Original_LastName) AND ((@IsNull_OfficeID = 1 AND [OfficeID] IS NULL) OR ([OfficeID] = @Original_OfficeID)) AND ((@IsNull_Birthdate = 1 AND [Birthdate] IS NULL) OR ([Birthdate] = @Original_Birthdate)) AND ((@IsNull_Active = 1 AND [Active] IS NULL) OR ([Active] = @Original_Active))) INSERT INTO [dbo].[Users] ([RoleID], [Email], [Password], [FirstName], [LastName], [OfficeID], [Birthdate], [Active]) VALUES (@RoleID, @Email, @Password, @FirstName, @LastName, @OfficeID, @Birthdate, @Active); SELECT ID, RoleID, Email, Password, FirstName, LastName, OfficeID, Birthdate, Active FROM Users WHERE (ID = SCOPE_IDENTITY()) SELECT ID, RoleID, Email, Password, FirstName, LastName, OfficeID, Birthdate, Active FROM dbo.Users UPDATE [dbo].[Users] SET [RoleID] = @RoleID, [Email] = @Email, [Password] = @Password, [FirstName] = @FirstName, [LastName] = @LastName, [OfficeID] = @OfficeID, [Birthdate] = @Birthdate, [Active] = @Active WHERE (([ID] = @Original_ID) AND ([RoleID] = @Original_RoleID) AND ([Email] = @Original_Email) AND ([Password] = @Original_Password) AND ((@IsNull_FirstName = 1 AND [FirstName] IS NULL) OR ([FirstName] = @Original_FirstName)) AND ([LastName] = @Original_LastName) AND ((@IsNull_OfficeID = 1 AND [OfficeID] IS NULL) OR ([OfficeID] = @Original_OfficeID)) AND ((@IsNull_Birthdate = 1 AND [Birthdate] IS NULL) OR ([Birthdate] = @Original_Birthdate)) AND ((@IsNull_Active = 1 AND [Active] IS NULL) OR ([Active] = @Original_Active))); SELECT ID, RoleID, Email, Password, FirstName, LastName, OfficeID, Birthdate, Active FROM Users WHERE (ID = @ID)