DELETE FROM [dbo].[Client] WHERE (([IdClient] = @Original_IdClient) AND ((@IsNull_Surname = 1 AND [Surname] IS NULL) OR ([Surname] = @Original_Surname)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Patronymic = 1 AND [Patronymic] IS NULL) OR ([Patronymic] = @Original_Patronymic))) INSERT INTO [dbo].[Client] ([Surname], [Name], [Patronymic]) VALUES (@Surname, @Name, @Patronymic); SELECT IdClient, Surname, Name, Patronymic FROM Client WHERE (IdClient = SCOPE_IDENTITY()) SELECT IdClient, Surname, Name, Patronymic FROM dbo.Client UPDATE [dbo].[Client] SET [Surname] = @Surname, [Name] = @Name, [Patronymic] = @Patronymic WHERE (([IdClient] = @Original_IdClient) AND ((@IsNull_Surname = 1 AND [Surname] IS NULL) OR ([Surname] = @Original_Surname)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Patronymic = 1 AND [Patronymic] IS NULL) OR ([Patronymic] = @Original_Patronymic))); SELECT IdClient, Surname, Name, Patronymic FROM Client WHERE (IdClient = @IdClient) DELETE FROM [dbo].[Employee] WHERE (([IdEmployee] = @Original_IdEmployee) AND ((@IsNull_IdRole = 1 AND [IdRole] IS NULL) OR ([IdRole] = @Original_IdRole)) AND ((@IsNull_Surname = 1 AND [Surname] IS NULL) OR ([Surname] = @Original_Surname)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Patronymic = 1 AND [Patronymic] IS NULL) OR ([Patronymic] = @Original_Patronymic)) AND ((@IsNull_Login = 1 AND [Login] IS NULL) OR ([Login] = @Original_Login)) AND ((@IsNull_Password = 1 AND [Password] IS NULL) OR ([Password] = @Original_Password)) AND ((@IsNull_Photo = 1 AND [Photo] IS NULL) OR ([Photo] = @Original_Photo))) INSERT INTO [dbo].[Employee] ([IdRole], [Surname], [Name], [Patronymic], [Login], [Password], [Photo]) VALUES (@IdRole, @Surname, @Name, @Patronymic, @Login, @Password, @Photo); SELECT IdEmployee, IdRole, Surname, Name, Patronymic, Login, Password, Photo FROM Employee WHERE (IdEmployee = SCOPE_IDENTITY()) SELECT IdEmployee, IdRole, Surname, Name, Patronymic, Login, Password, Photo FROM dbo.Employee UPDATE [dbo].[Employee] SET [IdRole] = @IdRole, [Surname] = @Surname, [Name] = @Name, [Patronymic] = @Patronymic, [Login] = @Login, [Password] = @Password, [Photo] = @Photo WHERE (([IdEmployee] = @Original_IdEmployee) AND ((@IsNull_IdRole = 1 AND [IdRole] IS NULL) OR ([IdRole] = @Original_IdRole)) AND ((@IsNull_Surname = 1 AND [Surname] IS NULL) OR ([Surname] = @Original_Surname)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Patronymic = 1 AND [Patronymic] IS NULL) OR ([Patronymic] = @Original_Patronymic)) AND ((@IsNull_Login = 1 AND [Login] IS NULL) OR ([Login] = @Original_Login)) AND ((@IsNull_Password = 1 AND [Password] IS NULL) OR ([Password] = @Original_Password)) AND ((@IsNull_Photo = 1 AND [Photo] IS NULL) OR ([Photo] = @Original_Photo))); SELECT IdEmployee, IdRole, Surname, Name, Patronymic, Login, Password, Photo FROM Employee WHERE (IdEmployee = @IdEmployee) DELETE FROM [dbo].[ExecutionRequest] WHERE (([IdExecution] = @Original_IdExecution) AND ((@IsNull_IdRequest = 1 AND [IdRequest] IS NULL) OR ([IdRequest] = @Original_IdRequest)) AND ((@IsNull_IdMaster = 1 AND [IdMaster] IS NULL) OR ([IdMaster] = @Original_IdMaster))) INSERT INTO [dbo].[ExecutionRequest] ([IdRequest], [IdMaster]) VALUES (@IdRequest, @IdMaster); SELECT IdExecution, IdRequest, IdMaster FROM ExecutionRequest WHERE (IdExecution = SCOPE_IDENTITY()) SELECT IdExecution, IdRequest, IdMaster FROM dbo.ExecutionRequest UPDATE [dbo].[ExecutionRequest] SET [IdRequest] = @IdRequest, [IdMaster] = @IdMaster WHERE (([IdExecution] = @Original_IdExecution) AND ((@IsNull_IdRequest = 1 AND [IdRequest] IS NULL) OR ([IdRequest] = @Original_IdRequest)) AND ((@IsNull_IdMaster = 1 AND [IdMaster] IS NULL) OR ([IdMaster] = @Original_IdMaster))); SELECT IdExecution, IdRequest, IdMaster FROM ExecutionRequest WHERE (IdExecution = @IdExecution) DELETE FROM [dbo].[Request] WHERE (([IdRequest] = @Original_IdRequest) AND ((@IsNull_IdStatus = 1 AND [IdStatus] IS NULL) OR ([IdStatus] = @Original_IdStatus)) AND ((@IsNull_IdTypeDefect = 1 AND [IdTypeDefect] IS NULL) OR ([IdTypeDefect] = @Original_IdTypeDefect)) AND ((@IsNull_IdClient = 1 AND [IdClient] IS NULL) OR ([IdClient] = @Original_IdClient)) AND ((@IsNull_IdManager = 1 AND [IdManager] IS NULL) OR ([IdManager] = @Original_IdManager)) AND ((@IsNull_DateAccepting = 1 AND [DateAccepting] IS NULL) OR ([DateAccepting] = @Original_DateAccepting)) AND ((@IsNull_DateCompletion = 1 AND [DateCompletion] IS NULL) OR ([DateCompletion] = @Original_DateCompletion)) AND ((@IsNull_EquipmentDefect = 1 AND [EquipmentDefect] IS NULL) OR ([EquipmentDefect] = @Original_EquipmentDefect))) INSERT INTO [dbo].[Request] ([IdStatus], [IdTypeDefect], [IdClient], [IdManager], [DateAccepting], [DateCompletion], [EquipmentDefect], [Description], [Comment]) VALUES (@IdStatus, @IdTypeDefect, @IdClient, @IdManager, @DateAccepting, @DateCompletion, @EquipmentDefect, @Description, @Comment); SELECT IdRequest, IdStatus, IdTypeDefect, IdClient, IdManager, DateAccepting, DateCompletion, EquipmentDefect, Description, Comment FROM Request WHERE (IdRequest = SCOPE_IDENTITY()) SELECT IdRequest, IdStatus, IdTypeDefect, IdClient, IdManager, DateAccepting, DateCompletion, EquipmentDefect, Description, Comment FROM dbo.Request UPDATE [dbo].[Request] SET [IdStatus] = @IdStatus, [IdTypeDefect] = @IdTypeDefect, [IdClient] = @IdClient, [IdManager] = @IdManager, [DateAccepting] = @DateAccepting, [DateCompletion] = @DateCompletion, [EquipmentDefect] = @EquipmentDefect, [Description] = @Description, [Comment] = @Comment WHERE (([IdRequest] = @Original_IdRequest) AND ((@IsNull_IdStatus = 1 AND [IdStatus] IS NULL) OR ([IdStatus] = @Original_IdStatus)) AND ((@IsNull_IdTypeDefect = 1 AND [IdTypeDefect] IS NULL) OR ([IdTypeDefect] = @Original_IdTypeDefect)) AND ((@IsNull_IdClient = 1 AND [IdClient] IS NULL) OR ([IdClient] = @Original_IdClient)) AND ((@IsNull_IdManager = 1 AND [IdManager] IS NULL) OR ([IdManager] = @Original_IdManager)) AND ((@IsNull_DateAccepting = 1 AND [DateAccepting] IS NULL) OR ([DateAccepting] = @Original_DateAccepting)) AND ((@IsNull_DateCompletion = 1 AND [DateCompletion] IS NULL) OR ([DateCompletion] = @Original_DateCompletion)) AND ((@IsNull_EquipmentDefect = 1 AND [EquipmentDefect] IS NULL) OR ([EquipmentDefect] = @Original_EquipmentDefect))); SELECT IdRequest, IdStatus, IdTypeDefect, IdClient, IdManager, DateAccepting, DateCompletion, EquipmentDefect, Description, Comment FROM Request WHERE (IdRequest = @IdRequest) DELETE FROM [dbo].[Role] WHERE (([IdRole] = @Original_IdRole) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title))) INSERT INTO [dbo].[Role] ([Title]) VALUES (@Title); SELECT IdRole, Title FROM Role WHERE (IdRole = SCOPE_IDENTITY()) SELECT IdRole, Title FROM dbo.Role UPDATE [dbo].[Role] SET [Title] = @Title WHERE (([IdRole] = @Original_IdRole) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title))); SELECT IdRole, Title FROM Role WHERE (IdRole = @IdRole) DELETE FROM [dbo].[Status] WHERE (([IdStatus] = @Original_IdStatus) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title))) INSERT INTO [dbo].[Status] ([Title]) VALUES (@Title); SELECT IdStatus, Title FROM Status WHERE (IdStatus = SCOPE_IDENTITY()) SELECT IdStatus, Title FROM dbo.Status UPDATE [dbo].[Status] SET [Title] = @Title WHERE (([IdStatus] = @Original_IdStatus) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title))); SELECT IdStatus, Title FROM Status WHERE (IdStatus = @IdStatus) DELETE FROM [dbo].[TypeDefect] WHERE (([IdTypeDefect] = @Original_IdTypeDefect) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title))) INSERT INTO [dbo].[TypeDefect] ([Title]) VALUES (@Title); SELECT IdTypeDefect, Title FROM TypeDefect WHERE (IdTypeDefect = SCOPE_IDENTITY()) SELECT IdTypeDefect, Title FROM dbo.TypeDefect UPDATE [dbo].[TypeDefect] SET [Title] = @Title WHERE (([IdTypeDefect] = @Original_IdTypeDefect) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title))); SELECT IdTypeDefect, Title FROM TypeDefect WHERE (IdTypeDefect = @IdTypeDefect) Select 'Все заявки' union all Select Title From TypeDefect DELETE FROM [Client] WHERE (([IdClient] = @Original_IdClient)) INSERT INTO [Client] DEFAULT VALUES; SELECT IdClient, Surname + ' ' + Name + ' ' + Patronymic AS FIO FROM Client WHERE (IdClient = SCOPE_IDENTITY()) SELECT IdClient, (Surname + ' ' + Name + ' ' + Patronymic) as FIO FROM Client