DELETE FROM [dbo].[FaceImages] WHERE (([ID] = @Original_ID) AND ([UserID] = @Original_UserID)) INSERT INTO [dbo].[FaceImages] ([ID], [UserID], [Picture]) VALUES (@ID, @UserID, @Picture); SELECT ID, UserID, Picture FROM FaceImages WHERE (ID = @ID) SELECT ID, UserID, Picture FROM dbo.FaceImages UPDATE [dbo].[FaceImages] SET [ID] = @ID, [UserID] = @UserID, [Picture] = @Picture WHERE (([ID] = @Original_ID) AND ([UserID] = @Original_UserID)); SELECT ID, UserID, Picture FROM FaceImages WHERE (ID = @ID) DELETE FROM [dbo].[HistoryLogin] WHERE (([ID] = @Original_ID) AND ([StaffsID] = @Original_StaffsID) AND ([TimeLogin] = @Original_TimeLogin)) INSERT INTO [dbo].[HistoryLogin] ([StaffsID], [TimeLogin]) VALUES (@StaffsID, @TimeLogin); SELECT ID, StaffsID, TimeLogin FROM HistoryLogin WHERE (ID = SCOPE_IDENTITY()) SELECT ID, StaffsID, TimeLogin FROM dbo.HistoryLogin UPDATE [dbo].[HistoryLogin] SET [StaffsID] = @StaffsID, [TimeLogin] = @TimeLogin WHERE (([ID] = @Original_ID) AND ([StaffsID] = @Original_StaffsID) AND ([TimeLogin] = @Original_TimeLogin)); SELECT ID, StaffsID, TimeLogin FROM HistoryLogin WHERE (ID = @ID) DELETE FROM [dbo].[Staffs] WHERE (([ID] = @Original_ID) AND ([Lastname] = @Original_Lastname) AND ([Firstname] = @Original_Firstname) AND ((@IsNull_Patronymic = 1 AND [Patronymic] IS NULL) OR ([Patronymic] = @Original_Patronymic)) AND ([PassportSeria] = @Original_PassportSeria) AND ([PassportNum] = @Original_PassportNum) AND ([Login] = @Original_Login) AND ([Password] = @Original_Password) AND ([IDStaffsType] = @Original_IDStaffsType)) INSERT INTO [dbo].[Staffs] ([Lastname], [Firstname], [Patronymic], [PassportSeria], [PassportNum], [Login], [Password], [IDStaffsType]) VALUES (@Lastname, @Firstname, @Patronymic, @PassportSeria, @PassportNum, @Login, @Password, @IDStaffsType); SELECT ID, Lastname, Firstname, Patronymic, PassportSeria, PassportNum, Login, Password, IDStaffsType FROM Staffs WHERE (ID = SCOPE_IDENTITY()) SELECT ID, Lastname, Firstname, Patronymic, PassportSeria, PassportNum, Login, Password, IDStaffsType FROM dbo.Staffs UPDATE [dbo].[Staffs] SET [Lastname] = @Lastname, [Firstname] = @Firstname, [Patronymic] = @Patronymic, [PassportSeria] = @PassportSeria, [PassportNum] = @PassportNum, [Login] = @Login, [Password] = @Password, [IDStaffsType] = @IDStaffsType WHERE (([ID] = @Original_ID) AND ([Lastname] = @Original_Lastname) AND ([Firstname] = @Original_Firstname) AND ((@IsNull_Patronymic = 1 AND [Patronymic] IS NULL) OR ([Patronymic] = @Original_Patronymic)) AND ([PassportSeria] = @Original_PassportSeria) AND ([PassportNum] = @Original_PassportNum) AND ([Login] = @Original_Login) AND ([Password] = @Original_Password) AND ([IDStaffsType] = @Original_IDStaffsType)); SELECT ID, Lastname, Firstname, Patronymic, PassportSeria, PassportNum, Login, Password, IDStaffsType FROM Staffs WHERE (ID = @ID) DELETE FROM [dbo].[Users] WHERE (([ID] = @Original_ID) AND ([Lastname] = @Original_Lastname) AND ([Firstname] = @Original_Firstname) AND ((@IsNull_Patronymic = 1 AND [Patronymic] IS NULL) OR ([Patronymic] = @Original_Patronymic)) AND ([PassportSeria] = @Original_PassportSeria) AND ([PassportNum] = @Original_PassportNum) AND ([IDUserType] = @Original_IDUserType)) INSERT INTO [dbo].[Users] ([Lastname], [Firstname], [Patronymic], [PassportSeria], [PassportNum], [IDUserType]) VALUES (@Lastname, @Firstname, @Patronymic, @PassportSeria, @PassportNum, @IDUserType); SELECT ID, Lastname, Firstname, Patronymic, PassportSeria, PassportNum, IDUserType FROM Users WHERE (ID = SCOPE_IDENTITY()) SELECT ID, Lastname, Firstname, Patronymic, PassportSeria, PassportNum, IDUserType FROM dbo.Users UPDATE [dbo].[Users] SET [Lastname] = @Lastname, [Firstname] = @Firstname, [Patronymic] = @Patronymic, [PassportSeria] = @PassportSeria, [PassportNum] = @PassportNum, [IDUserType] = @IDUserType WHERE (([ID] = @Original_ID) AND ([Lastname] = @Original_Lastname) AND ([Firstname] = @Original_Firstname) AND ((@IsNull_Patronymic = 1 AND [Patronymic] IS NULL) OR ([Patronymic] = @Original_Patronymic)) AND ([PassportSeria] = @Original_PassportSeria) AND ([PassportNum] = @Original_PassportNum) AND ([IDUserType] = @Original_IDUserType)); SELECT ID, Lastname, Firstname, Patronymic, PassportSeria, PassportNum, IDUserType FROM Users WHERE (ID = @ID) DELETE FROM [dbo].[UserTraffic] WHERE (([ID] = @Original_ID) AND ([UserID] = @Original_UserID) AND ((@IsNull_TimeEntrance = 1 AND [TimeEntrance] IS NULL) OR ([TimeEntrance] = @Original_TimeEntrance)) AND ((@IsNull_TimeExit = 1 AND [TimeExit] IS NULL) OR ([TimeExit] = @Original_TimeExit)) AND ([Identification] = @Original_Identification)) INSERT INTO [dbo].[UserTraffic] ([UserID], [TimeEntrance], [TimeExit], [Identification]) VALUES (@UserID, @TimeEntrance, @TimeExit, @Identification); SELECT ID, UserID, TimeEntrance, TimeExit, Identification FROM UserTraffic WHERE (ID = SCOPE_IDENTITY()) SELECT ID, UserID, TimeEntrance, TimeExit, Identification FROM dbo.UserTraffic UPDATE [dbo].[UserTraffic] SET [UserID] = @UserID, [TimeEntrance] = @TimeEntrance, [TimeExit] = @TimeExit, [Identification] = @Identification WHERE (([ID] = @Original_ID) AND ([UserID] = @Original_UserID) AND ((@IsNull_TimeEntrance = 1 AND [TimeEntrance] IS NULL) OR ([TimeEntrance] = @Original_TimeEntrance)) AND ((@IsNull_TimeExit = 1 AND [TimeExit] IS NULL) OR ([TimeExit] = @Original_TimeExit)) AND ([Identification] = @Original_Identification)); SELECT ID, UserID, TimeEntrance, TimeExit, Identification FROM UserTraffic WHERE (ID = @ID) DELETE FROM [dbo].[UserType] WHERE (([ID] = @Original_ID) AND ([UserType] = @Original_UserType)) INSERT INTO [dbo].[UserType] ([UserType]) VALUES (@UserType); SELECT ID, UserType FROM UserType WHERE (ID = SCOPE_IDENTITY()) SELECT ID, UserType FROM dbo.UserType UPDATE [dbo].[UserType] SET [UserType] = @UserType WHERE (([ID] = @Original_ID) AND ([UserType] = @Original_UserType)); SELECT ID, UserType FROM UserType WHERE (ID = @ID)