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].[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)