Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 10:46:46.716: Opened connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.716: SELECT TOP (1)
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name],
- [Extent1].[Value] AS [Value],
- [Extent1].[LongValue] AS [LongValue]
- FROM [dbo].[Setting] AS [Extent1]
- WHERE N'NotificationEmail' = [Extent1].[Name]10:46:46.716:
- 10:46:46.717: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.717: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.717:
- 10:46:46.718: Closed connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.718: Opened connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.718: SELECT TOP (1)
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name],
- [Extent1].[Value] AS [Value],
- [Extent1].[LongValue] AS [LongValue]
- FROM [dbo].[Setting] AS [Extent1]
- WHERE N'SmtpServer' = [Extent1].[Name]10:46:46.719:
- 10:46:46.719: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.719: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.719:
- 10:46:46.72: Closed connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.72: Opened connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.72: SELECT TOP (1)
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name],
- [Extent1].[Value] AS [Value],
- [Extent1].[LongValue] AS [LongValue]
- FROM [dbo].[Setting] AS [Extent1]
- WHERE N'SmtpPort' = [Extent1].[Name]10:46:46.721:
- 10:46:46.721: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.721: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.721:
- 10:46:46.722: Closed connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.722: Opened connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.722: SELECT TOP (1)
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name],
- [Extent1].[Value] AS [Value],
- [Extent1].[LongValue] AS [LongValue]
- FROM [dbo].[Setting] AS [Extent1]
- WHERE N'NotificationPassword' = [Extent1].[Name]10:46:46.722:
- 10:46:46.723: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.723: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.723:
- 10:46:46.723: Closed connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.724: Opened connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.724: SELECT TOP (1)
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name],
- [Extent1].[Value] AS [Value],
- [Extent1].[LongValue] AS [LongValue]
- FROM [dbo].[Setting] AS [Extent1]
- WHERE N'RequiredAuthentication' = [Extent1].[Name]10:46:46.724:
- 10:46:46.725: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.725: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.725:
- 10:46:46.725: Closed connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.726: Opened connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.726: SELECT TOP (1)
- [Extent1].[ID] AS [ID],
- [Extent1].[ID_aspnet_Users] AS [ID_aspnet_Users],
- [Extent1].[FirstName] AS [FirstName],
- [Extent1].[LastName] AS [LastName],
- [Extent1].[Active] AS [Active]
- FROM [dbo].[User] AS [Extent1]
- LEFT OUTER JOIN [dbo].[aspnet_Users] AS [Extent2] ON [Extent1].[ID_aspnet_Users] = [Extent2].[UserId]
- WHERE ([Extent2].[UserName] = @p__linq__0) OR (([Extent2].[UserName] IS NULL) AND (@p__linq__0 IS NULL))10:46:46.727:
- 10:46:46.727: -- p__linq__0: 'admin' (Type = String, Size = 4000)
- 10:46:46.727: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.727: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.728:
- 10:46:46.728: Closed connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.728: Opened connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.729: SELECT
- [Extent1].[UserId] AS [UserId],
- [Extent1].[ApplicationId] AS [ApplicationId],
- [Extent1].[UserName] AS [UserName],
- [Extent1].[LoweredUserName] AS [LoweredUserName],
- [Extent1].[MobileAlias] AS [MobileAlias],
- [Extent1].[IsAnonymous] AS [IsAnonymous],
- [Extent1].[LastActivityDate] AS [LastActivityDate]
- FROM [dbo].[aspnet_Users] AS [Extent1]
- WHERE [Extent1].[UserId] = @EntityKeyValue110:46:46.729:
- 10:46:46.729: -- EntityKeyValue1: 'd2350d7b-bfa5-4b2a-9f08-5cae6a094a9e' (Type = Guid)
- 10:46:46.729: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.73: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.73:
- 10:46:46.73: Closed connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.731: Opened connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.731: SELECT
- [Extent2].[RoleId] AS [RoleId],
- [Extent2].[ApplicationId] AS [ApplicationId],
- [Extent2].[RoleName] AS [RoleName],
- [Extent2].[LoweredRoleName] AS [LoweredRoleName],
- [Extent2].[Description] AS [Description]
- FROM [dbo].[aspnet_UsersInRoles] AS [Extent1]
- INNER JOIN [dbo].[aspnet_Roles] AS [Extent2] ON [Extent1].[RoleId] = [Extent2].[RoleId]
- WHERE [Extent1].[UserId] = @EntityKeyValue110:46:46.731:
- 10:46:46.731: -- EntityKeyValue1: 'd2350d7b-bfa5-4b2a-9f08-5cae6a094a9e' (Type = Guid, IsNullable = false)
- 10:46:46.732: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.732: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.732:
- 10:46:46.732: Closed connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.733: Opened connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.733: SELECT
- [Extent1].[ID] AS [ID],
- [Extent1].[Name] AS [Name],
- [Extent1].[SourceSystemId] AS [SourceSystemId],
- [Extent1].[ID_ActionType] AS [ID_ActionType],
- [Extent1].[ID_Group] AS [ID_Group]
- FROM [dbo].[AccessRight] AS [Extent1]
- WHERE [Extent1].[ID_Group] = @EntityKeyValue110:46:46.733:
- 10:46:46.733: -- EntityKeyValue1: '59d39023-fc53-e611-80c3-00155d63106c' (Type = Guid, IsNullable = false)
- 10:46:46.734: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.734: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.734:
- 10:46:46.735: Closed connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.735: Opened connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.735: SELECT
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name]
- FROM [dbo].[ActionType] AS [Extent1]
- WHERE [Extent1].[Id] = @EntityKeyValue110:46:46.735:
- 10:46:46.736: -- EntityKeyValue1: '6' (Type = Int32)
- 10:46:46.736: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.736: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.736:
- 10:46:46.737: Closed connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.737: Opened connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.737: SELECT
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name]
- FROM [dbo].[ActionType] AS [Extent1]
- WHERE [Extent1].[Id] = @EntityKeyValue110:46:46.738:
- 10:46:46.738: -- EntityKeyValue1: '7' (Type = Int32)
- 10:46:46.738: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.738: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.738:
- 10:46:46.739: Closed connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.739: Opened connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.739: SELECT
- [Extent1].[ID] AS [ID],
- [Extent1].[Name] AS [Name],
- [Extent1].[SourceSystemId] AS [SourceSystemId],
- [Extent1].[ID_ActionType] AS [ID_ActionType],
- [Extent1].[ID_Group] AS [ID_Group]
- FROM [dbo].[AccessRight] AS [Extent1]
- WHERE [Extent1].[ID_Group] = @EntityKeyValue110:46:46.74:
- 10:46:46.74: -- EntityKeyValue1: 'f82b1d7a-0054-e611-80c3-00155d63106c' (Type = Guid, IsNullable = false)
- 10:46:46.74: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.74: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.74:
- 10:46:46.741: Closed connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.741: Opened connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.741: SELECT
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name]
- FROM [dbo].[ActionType] AS [Extent1]
- WHERE [Extent1].[Id] = @EntityKeyValue110:46:46.742:
- 10:46:46.742: -- EntityKeyValue1: '3' (Type = Int32)
- 10:46:46.742: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.742: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.743:
- 10:46:46.743: Closed connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.743: Opened connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.743: SELECT
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name],
- [Extent1].[ActionTypeId] AS [ActionTypeId],
- [Extent1].[BusinessProcessId] AS [BusinessProcessId],
- [Extent1].[DocumentStatusId] AS [DocumentStatusId]
- FROM [dbo].[Stage] AS [Extent1]10:46:46.744:
- 10:46:46.744: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.744: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.744:
- 10:46:46.745: Closed connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.749: Opened connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.824: SELECT
- [Project2].[Id] AS [Id],
- [Project2].[Name] AS [Name],
- [Project2].[PeriodTypeId] AS [PeriodTypeId],
- [Project2].[ParentSourceSystemId] AS [ParentSourceSystemId],
- [Project2].[Icon] AS [Icon],
- [Project2].[IconType] AS [IconType],
- [Project2].[C1] AS [C1],
- [Project2].[Id1] AS [Id1],
- [Project2].[Name1] AS [Name1],
- [Project2].[AuthorId] AS [AuthorId],
- [Project2].[PeriodTypeId1] AS [PeriodTypeId1],
- [Project2].[SourceSystemId] AS [SourceSystemId]
- FROM ( SELECT
- [Limit1].[Id] AS [Id],
- [Limit1].[Name] AS [Name],
- [Limit1].[PeriodTypeId] AS [PeriodTypeId],
- [Limit1].[ParentSourceSystemId] AS [ParentSourceSystemId],
- [Limit1].[Icon] AS [Icon],
- [Limit1].[IconType] AS [IconType],
- [Extent3].[Id] AS [Id1],
- [Extent3].[Name] AS [Name1],
- [Extent3].[AuthorId] AS [AuthorId],
- [Extent3].[PeriodTypeId] AS [PeriodTypeId1],
- [Extent3].[SourceSystemId] AS [SourceSystemId],
- CASE WHEN ([Extent3].[Id] IS NULL) THEN CAST(NULL AS int) ELSE 1 END AS [C1]
- FROM (SELECT TOP (1) [Project1].[Id] AS [Id], [Project1].[Name] AS [Name], [Project1].[PeriodTypeId] AS [PeriodTypeId], [Project1].[ParentSourceSystemId] AS [ParentSourceSystemId], [Project1].[Icon] AS [Icon], [Project1].[IconType] AS [IconType]
- FROM ( SELECT
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name],
- [Extent1].[PeriodTypeId] AS [PeriodTypeId],
- [Extent1].[ParentSourceSystemId] AS [ParentSourceSystemId],
- [Extent1].[Icon] AS [Icon],
- [Extent1].[IconType] AS [IconType],
- (SELECT
- COUNT(1) AS [A1]
- FROM [dbo].[DocumentTemplate] AS [Extent2]
- WHERE [Extent1].[Id] = [Extent2].[SourceSystemId]) AS [C1]
- FROM [dbo].[SourceSystem] AS [Extent1]
- ) AS [Project1]
- WHERE [Project1].[C1] > 0 ) AS [Limit1]
- LEFT OUTER JOIN [dbo].[DocumentTemplate] AS [Extent3] ON [Limit1].[Id] = [Extent3].[SourceSystemId]
- ) AS [Project2]
- ORDER BY [Project2].[Id] ASC, [Project2].[C1] ASC10:46:46.824:
- 10:46:46.825: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.83: -- Completed in 5 ms with result: SqlDataReader
- 10:46:46.831:
- 10:46:46.847: Closed connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.852: Opened connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.861: SELECT TOP (2)
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name],
- [Extent1].[AuthorId] AS [AuthorId],
- [Extent1].[PeriodTypeId] AS [PeriodTypeId],
- [Extent1].[SourceSystemId] AS [SourceSystemId]
- FROM [dbo].[DocumentTemplate] AS [Extent1]
- WHERE [Extent1].[Id] = @p__linq__010:46:46.861:
- 10:46:46.862: -- p__linq__0: '2' (Type = Int32, IsNullable = false)
- 10:46:46.862: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.863: -- Completed in 1 ms with result: SqlDataReader
- 10:46:46.863:
- 10:46:46.864: Closed connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.865: Opened connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.87: SELECT
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name]
- FROM [dbo].[ActionType] AS [Extent1]
- WHERE [Extent1].[Name] IN (N'Edit', N'Approve', N'Final Approve')10:46:46.87:
- 10:46:46.871: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.872: -- Completed in 1 ms with result: SqlDataReader
- 10:46:46.872:
- 10:46:46.878: SELECT
- [Extent1].[ID] AS [ID],
- [Extent1].[Name] AS [Name],
- [Extent1].[SourceSystemId] AS [SourceSystemId],
- [Extent1].[ID_ActionType] AS [ID_ActionType],
- [Extent1].[ID_Group] AS [ID_Group]
- FROM [dbo].[AccessRight] AS [Extent1]10:46:46.878:
- 10:46:46.878: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.879: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.88:
- 10:46:46.884: SELECT
- [Extent1].[RoleId] AS [RoleId],
- [Extent1].[ApplicationId] AS [ApplicationId],
- [Extent1].[RoleName] AS [RoleName],
- [Extent1].[LoweredRoleName] AS [LoweredRoleName],
- [Extent1].[Description] AS [Description]
- FROM [dbo].[aspnet_Roles] AS [Extent1]
- WHERE [Extent1].[RoleId] = @EntityKeyValue110:46:46.884:
- 10:46:46.884: -- EntityKeyValue1: 'e124b068-ff53-e611-80c3-00155d63106c' (Type = Guid)
- 10:46:46.884: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.885: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.886:
- 10:46:46.886: SELECT
- [Extent1].[RoleId] AS [RoleId],
- [Extent1].[ApplicationId] AS [ApplicationId],
- [Extent1].[RoleName] AS [RoleName],
- [Extent1].[LoweredRoleName] AS [LoweredRoleName],
- [Extent1].[Description] AS [Description]
- FROM [dbo].[aspnet_Roles] AS [Extent1]
- WHERE [Extent1].[RoleId] = @EntityKeyValue110:46:46.887:
- 10:46:46.887: -- EntityKeyValue1: 'f1744779-ff53-e611-80c3-00155d63106c' (Type = Guid)
- 10:46:46.887: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.887: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.888:
- 10:46:46.89: SELECT
- [Extent1].[Id] AS [Id],
- [Extent1].[DocumentId] AS [DocumentId],
- [Extent1].[TemplateId] AS [TemplateId],
- [Extent1].[ActionTypeId] AS [ActionTypeId]
- FROM [dbo].[ProcessQueue] AS [Extent1]
- WHERE [Extent1].[TemplateId] = @EntityKeyValue110:46:46.89:
- 10:46:46.89: -- EntityKeyValue1: '2' (Type = Int32, IsNullable = false)
- 10:46:46.89: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.892: -- Completed in 1 ms with result: SqlDataReader
- 10:46:46.892:
- 10:46:46.907: SELECT
- [Extent1].[Id] AS [Id],
- [Extent1].[StatusId] AS [StatusId],
- [Extent1].[RoleId] AS [RoleId],
- [Extent1].[QueueId] AS [QueueId],
- [Extent1].[TaskId] AS [TaskId],
- [Extent1].[Sent] AS [Sent],
- [Extent1].[Finished] AS [Finished],
- [Extent1].[Order] AS [Order]
- FROM [dbo].[ProcessQueueItem] AS [Extent1]
- WHERE [Extent1].[QueueId] = @EntityKeyValue110:46:46.907:
- 10:46:46.908: -- EntityKeyValue1: '1' (Type = Int32, IsNullable = false)
- 10:46:46.908: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.91: -- Completed in 1 ms with result: SqlDataReader
- 10:46:46.91:
- 10:46:46.916: SELECT
- [Extent1].[ID] AS [ID],
- [Extent1].[Name] AS [Name],
- [Extent1].[SourceSystemId] AS [SourceSystemId],
- [Extent1].[ID_ActionType] AS [ID_ActionType],
- [Extent1].[ID_Group] AS [ID_Group]
- FROM [dbo].[AccessRight] AS [Extent1]10:46:46.916:
- 10:46:46.916: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.917: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.917:
- 10:46:46.918: SELECT
- [Extent1].[RoleId] AS [RoleId],
- [Extent1].[ApplicationId] AS [ApplicationId],
- [Extent1].[RoleName] AS [RoleName],
- [Extent1].[LoweredRoleName] AS [LoweredRoleName],
- [Extent1].[Description] AS [Description]
- FROM [dbo].[aspnet_Roles] AS [Extent1]
- WHERE [Extent1].[RoleId] = @EntityKeyValue110:46:46.918:
- 10:46:46.919: -- EntityKeyValue1: 'aa793e06-fd53-e611-80c3-00155d63106c' (Type = Guid)
- 10:46:46.919: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.919: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.919:
- 10:46:46.92: SELECT
- [Extent1].[RoleId] AS [RoleId],
- [Extent1].[ApplicationId] AS [ApplicationId],
- [Extent1].[RoleName] AS [RoleName],
- [Extent1].[LoweredRoleName] AS [LoweredRoleName],
- [Extent1].[Description] AS [Description]
- FROM [dbo].[aspnet_Roles] AS [Extent1]
- WHERE [Extent1].[RoleId] = @EntityKeyValue110:46:46.92:
- 10:46:46.92: -- EntityKeyValue1: 'f167be34-fd53-e611-80c3-00155d63106c' (Type = Guid)
- 10:46:46.92: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.921: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.921:
- 10:46:46.921: SELECT
- [Extent1].[RoleId] AS [RoleId],
- [Extent1].[ApplicationId] AS [ApplicationId],
- [Extent1].[RoleName] AS [RoleName],
- [Extent1].[LoweredRoleName] AS [LoweredRoleName],
- [Extent1].[Description] AS [Description]
- FROM [dbo].[aspnet_Roles] AS [Extent1]
- WHERE [Extent1].[RoleId] = @EntityKeyValue110:46:46.921:
- 10:46:46.922: -- EntityKeyValue1: '105d4ff5-fe53-e611-80c3-00155d63106c' (Type = Guid)
- 10:46:46.922: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.922: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.922:
- 10:46:46.923: SELECT
- [Extent1].[RoleId] AS [RoleId],
- [Extent1].[ApplicationId] AS [ApplicationId],
- [Extent1].[RoleName] AS [RoleName],
- [Extent1].[LoweredRoleName] AS [LoweredRoleName],
- [Extent1].[Description] AS [Description]
- FROM [dbo].[aspnet_Roles] AS [Extent1]
- WHERE [Extent1].[RoleId] = @EntityKeyValue110:46:46.923:
- 10:46:46.923: -- EntityKeyValue1: 'd3bf4a4f-ff53-e611-80c3-00155d63106c' (Type = Guid)
- 10:46:46.923: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.924: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.924:
- 10:46:46.924: SELECT
- [Extent1].[ID] AS [ID],
- [Extent1].[Name] AS [Name],
- [Extent1].[SourceSystemId] AS [SourceSystemId],
- [Extent1].[ID_ActionType] AS [ID_ActionType],
- [Extent1].[ID_Group] AS [ID_Group]
- FROM [dbo].[AccessRight] AS [Extent1]10:46:46.924:
- 10:46:46.925: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.925: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.925:
- 10:46:46.926: SELECT
- [Extent1].[Id] AS [Id],
- [Extent1].[StatusId] AS [StatusId],
- [Extent1].[RoleId] AS [RoleId],
- [Extent1].[QueueId] AS [QueueId],
- [Extent1].[TaskId] AS [TaskId],
- [Extent1].[Sent] AS [Sent],
- [Extent1].[Finished] AS [Finished],
- [Extent1].[Order] AS [Order]
- FROM [dbo].[ProcessQueueItem] AS [Extent1]
- WHERE [Extent1].[QueueId] = @EntityKeyValue110:46:46.926:
- 10:46:46.926: -- EntityKeyValue1: '2' (Type = Int32, IsNullable = false)
- 10:46:46.926: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.926: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.927:
- 10:46:46.927: SELECT
- [Extent1].[ID] AS [ID],
- [Extent1].[Name] AS [Name],
- [Extent1].[SourceSystemId] AS [SourceSystemId],
- [Extent1].[ID_ActionType] AS [ID_ActionType],
- [Extent1].[ID_Group] AS [ID_Group]
- FROM [dbo].[AccessRight] AS [Extent1]10:46:46.927:
- 10:46:46.928: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.928: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.928:
- 10:46:46.928: SELECT
- [Extent1].[RoleId] AS [RoleId],
- [Extent1].[ApplicationId] AS [ApplicationId],
- [Extent1].[RoleName] AS [RoleName],
- [Extent1].[LoweredRoleName] AS [LoweredRoleName],
- [Extent1].[Description] AS [Description]
- FROM [dbo].[aspnet_Roles] AS [Extent1]
- WHERE [Extent1].[RoleId] = @EntityKeyValue110:46:46.929:
- 10:46:46.929: -- EntityKeyValue1: '9741a8cb-ff53-e611-80c3-00155d63106c' (Type = Guid)
- 10:46:46.929: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.929: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.93:
- 10:46:46.93: SELECT
- [Extent1].[RoleId] AS [RoleId],
- [Extent1].[ApplicationId] AS [ApplicationId],
- [Extent1].[RoleName] AS [RoleName],
- [Extent1].[LoweredRoleName] AS [LoweredRoleName],
- [Extent1].[Description] AS [Description]
- FROM [dbo].[aspnet_Roles] AS [Extent1]
- WHERE [Extent1].[RoleId] = @EntityKeyValue110:46:46.93:
- 10:46:46.93: -- EntityKeyValue1: 'ce0374de-ff53-e611-80c3-00155d63106c' (Type = Guid)
- 10:46:46.931: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.931: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.931:
- 10:46:46.932: Closed connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.933: Opened connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.943: SELECT TOP (1)
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name]
- FROM [dbo].[DocumentStatus] AS [Extent1]
- WHERE N'New' = [Extent1].[Name]10:46:46.943:
- 10:46:46.943: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.945: -- Completed in 1 ms with result: SqlDataReader
- 10:46:46.945:
- 10:46:46.947: Closed connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.947: Opened connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.947: SELECT TOP (1)
- [Extent1].[ID] AS [ID],
- [Extent1].[ID_aspnet_Users] AS [ID_aspnet_Users],
- [Extent1].[FirstName] AS [FirstName],
- [Extent1].[LastName] AS [LastName],
- [Extent1].[Active] AS [Active]
- FROM [dbo].[User] AS [Extent1]
- LEFT OUTER JOIN [dbo].[aspnet_Users] AS [Extent2] ON [Extent1].[ID_aspnet_Users] = [Extent2].[UserId]
- WHERE ([Extent2].[UserName] = @p__linq__0) OR (([Extent2].[UserName] IS NULL) AND (@p__linq__0 IS NULL))10:46:46.948:
- 10:46:46.948: -- p__linq__0: 'admin' (Type = String, Size = 4000)
- 10:46:46.948: -- Executing at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.949: -- Completed in 0 ms with result: SqlDataReader
- 10:46:46.949:
- 10:46:46.949: Closed connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.99: Opened connection at 7/29/2016 10:46:46 AM +05:00
- 10:46:46.991: Started transaction at 7/29/2016 10:46:46 AM +05:00
- 10:46:47.004: INSERT [dbo].[Document]([Name], [VersionNumber], [FileName], [Data], [PeriodTypeId], [Created], [IsCurrentVersion], [ChronicalDocumentId], [DocumentStatusId], [SourceSystemId], [DocumentTemplateId], [AuthorId], [SubmissionDate], [LastUserId], [LastUserComment], [PositionDate], [SubmissionDeadline])
- VALUES (@0, @1, @2, NULL, NULL, @3, @4, NULL, @5, @6, @7, @8, NULL, NULL, NULL, @9, NULL)
- SELECT [Id]
- FROM [dbo].[Document]
- WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.004:
- 10:46:47.004: -- @0: '10:46 AM_0' (Type = String, Size = 256)
- 10:46:47.005: -- @1: '1.0' (Type = String, Size = 64)
- 10:46:47.006: -- @2: 'test.bin' (Type = String, Size = 256)
- 10:46:47.006: -- @3: '7/29/2016 10:46:46 AM' (Type = DateTime2)
- 10:46:47.006: -- @4: 'True' (Type = Boolean)
- 10:46:47.006: -- @5: '6' (Type = Int32)
- 10:46:47.007: -- @6: '1' (Type = Int32)
- 10:46:47.007: -- @7: '2' (Type = Int32)
- 10:46:47.007: -- @8: 'd2350d7b-bfa5-4b2a-9f08-5cae6a094a9e' (Type = Guid)
- 10:46:47.007: -- @9: '1/1/0001 12:00:00 AM' (Type = DateTime2)
- 10:46:47.008: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.011: -- Completed in 3 ms with result: SqlDataReader
- 10:46:47.012:
- 10:46:47.016: Committed transaction at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.016: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.027: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.028: Started transaction at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.03: UPDATE [dbo].[Document]
- SET [ChronicalDocumentId] = @0
- WHERE ([Id] = @1)
- 10:46:47.03: -- @0: '2016' (Type = Int32)
- 10:46:47.031: -- @1: '2016' (Type = Int32)
- 10:46:47.031: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.032: -- Completed in 1 ms with result: 1
- 10:46:47.033:
- 10:46:47.033: Committed transaction at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.033: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.035: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.045: SELECT TOP (2)
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name]
- FROM [dbo].[ProcessQueueStatus] AS [Extent1]
- WHERE 'New' = [Extent1].[Name]10:46:47.046:
- 10:46:47.046: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.047: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.047:
- 10:46:47.05: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.056: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.056: Started transaction at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.061: INSERT [dbo].[ProcessQueue]([DocumentId], [TemplateId], [ActionTypeId])
- VALUES (@0, NULL, @1)
- SELECT [Id]
- FROM [dbo].[ProcessQueue]
- WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.061:
- 10:46:47.062: -- @0: '2016' (Type = Int32)
- 10:46:47.062: -- @1: '2' (Type = Int32)
- 10:46:47.062: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.064: -- Completed in 2 ms with result: SqlDataReader
- 10:46:47.065:
- 10:46:47.065: INSERT [dbo].[ProcessQueueItem]([StatusId], [RoleId], [QueueId], [TaskId], [Sent], [Finished], [Order])
- VALUES (@0, @1, @2, NULL, NULL, NULL, @3)
- SELECT [Id]
- FROM [dbo].[ProcessQueueItem]
- WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.066:
- 10:46:47.066: -- @0: '1' (Type = Int32)
- 10:46:47.066: -- @1: 'e124b068-ff53-e611-80c3-00155d63106c' (Type = Guid)
- 10:46:47.066: -- @2: '6052' (Type = Int32)
- 10:46:47.066: -- @3: '1' (Type = Int32)
- 10:46:47.067: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.069: -- Completed in 2 ms with result: SqlDataReader
- 10:46:47.069:
- 10:46:47.071: Committed transaction at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.071: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.074: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.075: Started transaction at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.076: INSERT [dbo].[ProcessQueue]([DocumentId], [TemplateId], [ActionTypeId])
- VALUES (@0, NULL, @1)
- SELECT [Id]
- FROM [dbo].[ProcessQueue]
- WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.076:
- 10:46:47.076: -- @0: '2016' (Type = Int32)
- 10:46:47.076: -- @1: '3' (Type = Int32)
- 10:46:47.076: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.077: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.077:
- 10:46:47.077: INSERT [dbo].[ProcessQueueItem]([StatusId], [RoleId], [QueueId], [TaskId], [Sent], [Finished], [Order])
- VALUES (@0, @1, @2, NULL, NULL, NULL, @3)
- SELECT [Id]
- FROM [dbo].[ProcessQueueItem]
- WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.078:
- 10:46:47.078: -- @0: '1' (Type = Int32)
- 10:46:47.078: -- @1: 'f82b1d7a-0054-e611-80c3-00155d63106c' (Type = Guid)
- 10:46:47.078: -- @2: '6053' (Type = Int32)
- 10:46:47.078: -- @3: '1' (Type = Int32)
- 10:46:47.079: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.079: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.079:
- 10:46:47.08: Committed transaction at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.08: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.081: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.081: SELECT
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name]
- FROM [dbo].[ActionType] AS [Extent1]
- WHERE [Extent1].[Id] = @EntityKeyValue110:46:47.081:
- 10:46:47.081: -- EntityKeyValue1: '1' (Type = Int32)
- 10:46:47.081: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.082: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.082:
- 10:46:47.082: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.083: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.083: SELECT
- [Extent1].[Id] AS [Id],
- [Extent1].[StatusId] AS [StatusId],
- [Extent1].[RoleId] AS [RoleId],
- [Extent1].[QueueId] AS [QueueId],
- [Extent1].[TaskId] AS [TaskId],
- [Extent1].[Sent] AS [Sent],
- [Extent1].[Finished] AS [Finished],
- [Extent1].[Order] AS [Order]
- FROM [dbo].[ProcessQueueItem] AS [Extent1]
- WHERE [Extent1].[QueueId] = @EntityKeyValue110:46:47.083:
- 10:46:47.083: -- EntityKeyValue1: '3' (Type = Int32, IsNullable = false)
- 10:46:47.084: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.084: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.084:
- 10:46:47.085: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.087: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.088: Started transaction at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.089: INSERT [dbo].[ProcessQueue]([DocumentId], [TemplateId], [ActionTypeId])
- VALUES (@0, NULL, @1)
- SELECT [Id]
- FROM [dbo].[ProcessQueue]
- WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.089:
- 10:46:47.089: -- @0: '2016' (Type = Int32)
- 10:46:47.089: -- @1: '1' (Type = Int32)
- 10:46:47.089: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.09: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.09:
- 10:46:47.09: INSERT [dbo].[ProcessQueueItem]([StatusId], [RoleId], [QueueId], [TaskId], [Sent], [Finished], [Order])
- VALUES (@0, @1, @2, NULL, NULL, NULL, @3)
- SELECT [Id]
- FROM [dbo].[ProcessQueueItem]
- WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.091:
- 10:46:47.091: -- @0: '1' (Type = Int32)
- 10:46:47.091: -- @1: 'aa793e06-fd53-e611-80c3-00155d63106c' (Type = Guid)
- 10:46:47.091: -- @2: '6054' (Type = Int32)
- 10:46:47.091: -- @3: '1' (Type = Int32)
- 10:46:47.092: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.092: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.092:
- 10:46:47.093: Committed transaction at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.093: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.096: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.107: SELECT TOP (1)
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name],
- [Extent1].[FirstStage] AS [FirstStage]
- FROM [dbo].[BusinessProcess] AS [Extent1]
- WHERE [Extent1].[Name] = @p__linq__010:46:47.107:
- 10:46:47.107: -- p__linq__0: 'Main' (Type = String, Size = 4000)
- 10:46:47.108: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.109: -- Completed in 1 ms with result: SqlDataReader
- 10:46:47.109:
- 10:46:47.112: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.116: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.117: Started transaction at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.117: INSERT [dbo].[Workflow]([Created], [Finished], [BusinessProcessId])
- VALUES (@0, NULL, @1)
- SELECT [Id]
- FROM [dbo].[Workflow]
- WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.117:
- 10:46:47.118: -- @0: '7/29/2016 10:46:47 AM' (Type = DateTime2)
- 10:46:47.118: -- @1: '1' (Type = Int32)
- 10:46:47.118: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.12: -- Completed in 1 ms with result: SqlDataReader
- 10:46:47.12:
- 10:46:47.121: Committed transaction at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.122: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.123: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.124: SELECT TOP (1)
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name],
- [Extent1].[ActionTypeId] AS [ActionTypeId],
- [Extent1].[BusinessProcessId] AS [BusinessProcessId],
- [Extent1].[DocumentStatusId] AS [DocumentStatusId]
- FROM [dbo].[Stage] AS [Extent1]
- WHERE [Extent1].[Id] = @p__linq__010:46:47.124:
- 10:46:47.124: -- p__linq__0: '1' (Type = Int32)
- 10:46:47.125: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.126: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.126:
- 10:46:47.126: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.127: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.127: SELECT TOP (1)
- [Extent1].[ID] AS [ID],
- [Extent1].[ID_aspnet_Users] AS [ID_aspnet_Users],
- [Extent1].[FirstName] AS [FirstName],
- [Extent1].[LastName] AS [LastName],
- [Extent1].[Active] AS [Active]
- FROM [dbo].[User] AS [Extent1]
- LEFT OUTER JOIN [dbo].[aspnet_Users] AS [Extent2] ON [Extent1].[ID_aspnet_Users] = [Extent2].[UserId]
- WHERE ([Extent2].[UserName] = @p__linq__0) OR (([Extent2].[UserName] IS NULL) AND (@p__linq__0 IS NULL))10:46:47.127:
- 10:46:47.127: -- p__linq__0: 'admin' (Type = String, Size = 4000)
- 10:46:47.128: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.128: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.128:
- 10:46:47.129: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.13: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.13: SELECT TOP (2)
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name]
- FROM [dbo].[ProcessQueueStatus] AS [Extent1]
- WHERE 'New' = [Extent1].[Name]10:46:47.131:
- 10:46:47.131: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.131: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.131:
- 10:46:47.132: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.136: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.137: Started transaction at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.139: UPDATE [dbo].[Document]
- SET [IsCurrentVersion] = @0
- WHERE ([Id] = @1)
- 10:46:47.139: -- @0: 'False' (Type = Boolean)
- 10:46:47.14: -- @1: '2016' (Type = Int32)
- 10:46:47.14: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.141: -- Completed in 1 ms with result: 1
- 10:46:47.142:
- 10:46:47.142: INSERT [dbo].[Document]([Name], [VersionNumber], [FileName], [Data], [PeriodTypeId], [Created], [IsCurrentVersion], [ChronicalDocumentId], [DocumentStatusId], [SourceSystemId], [DocumentTemplateId], [AuthorId], [SubmissionDate], [LastUserId], [LastUserComment], [PositionDate], [SubmissionDeadline])
- VALUES (@0, @1, @2, NULL, NULL, @3, @4, @5, @6, @7, @8, @9, NULL, NULL, NULL, @10, NULL)
- SELECT [Id]
- FROM [dbo].[Document]
- WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.142:
- 10:46:47.142: -- @0: '10:46 AM_0' (Type = String, Size = 256)
- 10:46:47.143: -- @1: '2.0' (Type = String, Size = 64)
- 10:46:47.143: -- @2: 'test.bin' (Type = String, Size = 256)
- 10:46:47.143: -- @3: '7/29/2016 10:46:47 AM' (Type = DateTime2)
- 10:46:47.143: -- @4: 'True' (Type = Boolean)
- 10:46:47.143: -- @5: '2016' (Type = Int32)
- 10:46:47.144: -- @6: '6' (Type = Int32)
- 10:46:47.144: -- @7: '1' (Type = Int32)
- 10:46:47.145: -- @8: '2' (Type = Int32)
- 10:46:47.145: -- @9: 'd2350d7b-bfa5-4b2a-9f08-5cae6a094a9e' (Type = Guid)
- 10:46:47.145: -- @10: '1/1/0001 12:00:00 AM' (Type = DateTime2)
- 10:46:47.145: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.148: -- Completed in 2 ms with result: SqlDataReader
- 10:46:47.148:
- 10:46:47.149: INSERT [dbo].[ProcessQueue]([DocumentId], [TemplateId], [ActionTypeId])
- VALUES (@0, NULL, @1)
- SELECT [Id]
- FROM [dbo].[ProcessQueue]
- WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.149:
- 10:46:47.149: -- @0: '2017' (Type = Int32)
- 10:46:47.149: -- @1: '2' (Type = Int32)
- 10:46:47.15: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.15: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.15:
- 10:46:47.151: INSERT [dbo].[ProcessQueue]([DocumentId], [TemplateId], [ActionTypeId])
- VALUES (@0, NULL, @1)
- SELECT [Id]
- FROM [dbo].[ProcessQueue]
- WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.151:
- 10:46:47.151: -- @0: '2017' (Type = Int32)
- 10:46:47.151: -- @1: '3' (Type = Int32)
- 10:46:47.151: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.152: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.152:
- 10:46:47.152: INSERT [dbo].[ProcessQueue]([DocumentId], [TemplateId], [ActionTypeId])
- VALUES (@0, NULL, @1)
- SELECT [Id]
- FROM [dbo].[ProcessQueue]
- WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.152:
- 10:46:47.153: -- @0: '2017' (Type = Int32)
- 10:46:47.153: -- @1: '1' (Type = Int32)
- 10:46:47.153: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.154: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.154:
- 10:46:47.154: INSERT [dbo].[ProcessQueueItem]([StatusId], [RoleId], [QueueId], [TaskId], [Sent], [Finished], [Order])
- VALUES (@0, @1, @2, NULL, NULL, NULL, @3)
- SELECT [Id]
- FROM [dbo].[ProcessQueueItem]
- WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.154:
- 10:46:47.155: -- @0: '1' (Type = Int32)
- 10:46:47.155: -- @1: 'e124b068-ff53-e611-80c3-00155d63106c' (Type = Guid)
- 10:46:47.155: -- @2: '6055' (Type = Int32)
- 10:46:47.155: -- @3: '1' (Type = Int32)
- 10:46:47.155: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.156: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.156:
- 10:46:47.156: INSERT [dbo].[ProcessQueueItem]([StatusId], [RoleId], [QueueId], [TaskId], [Sent], [Finished], [Order])
- VALUES (@0, @1, @2, NULL, NULL, NULL, @3)
- SELECT [Id]
- FROM [dbo].[ProcessQueueItem]
- WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.157:
- 10:46:47.157: -- @0: '1' (Type = Int32)
- 10:46:47.157: -- @1: 'f82b1d7a-0054-e611-80c3-00155d63106c' (Type = Guid)
- 10:46:47.157: -- @2: '6056' (Type = Int32)
- 10:46:47.157: -- @3: '1' (Type = Int32)
- 10:46:47.158: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.158: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.158:
- 10:46:47.159: INSERT [dbo].[ProcessQueueItem]([StatusId], [RoleId], [QueueId], [TaskId], [Sent], [Finished], [Order])
- VALUES (@0, @1, @2, NULL, NULL, NULL, @3)
- SELECT [Id]
- FROM [dbo].[ProcessQueueItem]
- WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.159:
- 10:46:47.159: -- @0: '1' (Type = Int32)
- 10:46:47.159: -- @1: 'aa793e06-fd53-e611-80c3-00155d63106c' (Type = Guid)
- 10:46:47.159: -- @2: '6057' (Type = Int32)
- 10:46:47.16: -- @3: '1' (Type = Int32)
- 10:46:47.16: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.16: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.16:
- 10:46:47.16: Committed transaction at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.161: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.163: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.164: SELECT
- [Extent1].[ID] AS [ID],
- [Extent1].[Name] AS [Name],
- [Extent1].[SourceSystemId] AS [SourceSystemId],
- [Extent1].[ID_ActionType] AS [ID_ActionType],
- [Extent1].[ID_Group] AS [ID_Group]
- FROM [dbo].[AccessRight] AS [Extent1]10:46:47.164:
- 10:46:47.164: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.164: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.165:
- 10:46:47.165: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.165: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.166: SELECT TOP (2)
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name]
- FROM [dbo].[ProcessQueueStatus] AS [Extent1]
- WHERE 'New' = [Extent1].[Name]10:46:47.166:
- 10:46:47.166: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.166: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.167:
- 10:46:47.167: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.167: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.168: SELECT
- [Extent1].[ID] AS [ID],
- [Extent1].[Name] AS [Name],
- [Extent1].[SourceSystemId] AS [SourceSystemId],
- [Extent1].[ID_ActionType] AS [ID_ActionType],
- [Extent1].[ID_Group] AS [ID_Group]
- FROM [dbo].[AccessRight] AS [Extent1]10:46:47.168:
- 10:46:47.168: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.168: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.169:
- 10:46:47.169: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.173: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.174: SELECT TOP (2)
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name]
- FROM [dbo].[ProcessQueueStatus] AS [Extent1]
- WHERE 'New' = [Extent1].[Name]10:46:47.174:
- 10:46:47.174: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.174: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.175:
- 10:46:47.175: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.175: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.176: SELECT TOP (2)
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name]
- FROM [dbo].[ProcessQueueStatus] AS [Extent1]
- WHERE 'Sent' = [Extent1].[Name]10:46:47.177:
- 10:46:47.177: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.178: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.178:
- 10:46:47.179: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.18: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.181: SELECT TOP (2)
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name]
- FROM [dbo].[ProcessQueueStatus] AS [Extent1]
- WHERE 'New' = [Extent1].[Name]10:46:47.181:
- 10:46:47.181: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.182: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.182:
- 10:46:47.182: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.189: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.19: Started transaction at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.191: UPDATE [dbo].[ProcessQueueItem]
- SET [StatusId] = @0, [Sent] = @1
- WHERE ([Id] = @2)
- 10:46:47.191: -- @0: '2' (Type = Int32)
- 10:46:47.191: -- @1: '7/29/2016 10:46:47 AM' (Type = DateTime2)
- 10:46:47.191: -- @2: '6005' (Type = Int32)
- 10:46:47.192: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.194: -- Completed in 1 ms with result: 1
- 10:46:47.194:
- 10:46:47.194: Committed transaction at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.195: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.196: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.198: SELECT
- [Extent2].[UserId] AS [UserId],
- [Extent2].[ApplicationId] AS [ApplicationId],
- [Extent2].[UserName] AS [UserName],
- [Extent2].[LoweredUserName] AS [LoweredUserName],
- [Extent2].[MobileAlias] AS [MobileAlias],
- [Extent2].[IsAnonymous] AS [IsAnonymous],
- [Extent2].[LastActivityDate] AS [LastActivityDate]
- FROM [dbo].[aspnet_UsersInRoles] AS [Extent1]
- INNER JOIN [dbo].[aspnet_Users] AS [Extent2] ON [Extent1].[UserId] = [Extent2].[UserId]
- WHERE [Extent1].[RoleId] = @EntityKeyValue110:46:47.198:
- 10:46:47.199: -- EntityKeyValue1: 'aa793e06-fd53-e611-80c3-00155d63106c' (Type = Guid, IsNullable = false)
- 10:46:47.199: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.203: -- Completed in 3 ms with result: SqlDataReader
- 10:46:47.203:
- 10:46:47.205: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.206: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.216: SELECT TOP (2)
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name]
- FROM [dbo].[TaskStatus] AS [Extent1]
- WHERE N'New' = [Extent1].[Name]10:46:47.217:
- 10:46:47.217: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.218: -- Completed in 1 ms with result: SqlDataReader
- 10:46:47.219:
- 10:46:47.22: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.225: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.225: Started transaction at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.226: INSERT [dbo].[TaskPerformer]([RoleId], [UserId])
- VALUES (NULL, @0)
- SELECT [Id]
- FROM [dbo].[TaskPerformer]
- WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.226:
- 10:46:47.226: -- @0: 'bbd89cbf-7995-4448-92b8-adaf29b268fd' (Type = Guid)
- 10:46:47.227: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.229: -- Completed in 1 ms with result: SqlDataReader
- 10:46:47.229:
- 10:46:47.23: Committed transaction at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.23: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.238: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.239: Started transaction at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.24: INSERT [dbo].[Task]([DocumentId], [StatusId], [Created], [Started], [Finished], [WorkflowId], [StageId], [TaskPerformerId], [Comment])
- VALUES (@0, @1, @2, NULL, NULL, @3, @4, @5, NULL)
- SELECT [Id]
- FROM [dbo].[Task]
- WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.24:
- 10:46:47.24: -- @0: '2016' (Type = Int32)
- 10:46:47.24: -- @1: '1' (Type = Int32)
- 10:46:47.241: -- @2: '7/29/2016 10:46:47 AM' (Type = DateTime2)
- 10:46:47.241: -- @3: '973' (Type = Int32)
- 10:46:47.241: -- @4: '1' (Type = Int32)
- 10:46:47.241: -- @5: '968' (Type = Int32)
- 10:46:47.242: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.245: -- Completed in 2 ms with result: SqlDataReader
- 10:46:47.245:
- 10:46:47.246: Committed transaction at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.247: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.249: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.25: SELECT TOP (1)
- [Extent1].[RoleId] AS [RoleId],
- [Extent1].[ApplicationId] AS [ApplicationId],
- [Extent1].[RoleName] AS [RoleName],
- [Extent1].[LoweredRoleName] AS [LoweredRoleName],
- [Extent1].[Description] AS [Description]
- FROM [dbo].[aspnet_Roles] AS [Extent1]
- WHERE [Extent1].[RoleId] = @p__linq__010:46:47.25:
- 10:46:47.25: -- p__linq__0: 'aa793e06-fd53-e611-80c3-00155d63106c' (Type = Guid, IsNullable = false)
- 10:46:47.251: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.252: -- Completed in 1 ms with result: SqlDataReader
- 10:46:47.252:
- 10:46:47.253: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.255: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.265: SELECT TOP (2)
- [Extent1].[ID] AS [ID],
- [Extent1].[Name] AS [Name]
- FROM [dbo].[AuditAction] AS [Extent1]
- WHERE [Extent1].[ID] = @p__linq__010:46:47.265:
- 10:46:47.265: -- p__linq__0: '2' (Type = Int32, IsNullable = false)
- 10:46:47.266: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.267: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.267:
- 10:46:47.269: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.275: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.276: Started transaction at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.277: UPDATE [dbo].[Task]
- SET [DocumentId] = @0
- WHERE ([Id] = @1)
- 10:46:47.277: -- @0: '2016' (Type = Int32)
- 10:46:47.277: -- @1: '968' (Type = Int32)
- 10:46:47.278: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.28: -- Completed in 1 ms with result: 1
- 10:46:47.28:
- 10:46:47.28: INSERT [dbo].[AuditTrail]([When], [UserId], [AuditActionId], [DocumentId], [TaskId])
- VALUES (@0, @1, @2, @3, @4)
- SELECT [ID]
- FROM [dbo].[AuditTrail]
- WHERE @@ROWCOUNT > 0 AND [ID] = scope_identity()10:46:47.28:
- 10:46:47.281: -- @0: '7/29/2016 10:46:47 AM' (Type = DateTime2)
- 10:46:47.281: -- @1: 'bbd89cbf-7995-4448-92b8-adaf29b268fd' (Type = Guid)
- 10:46:47.281: -- @2: '2' (Type = Int32)
- 10:46:47.281: -- @3: '2016' (Type = Int32)
- 10:46:47.281: -- @4: '968' (Type = Int32)
- 10:46:47.282: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.285: -- Completed in 2 ms with result: SqlDataReader
- 10:46:47.285:
- 10:46:47.286: Committed transaction at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.286: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.287: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.287: SELECT TOP (2)
- [Extent1].[ID] AS [ID],
- [Extent1].[Name] AS [Name]
- FROM [dbo].[AuditAction] AS [Extent1]
- WHERE [Extent1].[ID] = @p__linq__010:46:47.287:
- 10:46:47.288: -- p__linq__0: '2' (Type = Int32, IsNullable = false)
- 10:46:47.288: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.288: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.289:
- 10:46:47.289: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.293: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.293: Started transaction at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.294: UPDATE [dbo].[Task]
- SET [DocumentId] = @0
- WHERE ([Id] = @1)
- 10:46:47.294: -- @0: '2016' (Type = Int32)
- 10:46:47.295: -- @1: '968' (Type = Int32)
- 10:46:47.295: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.295: -- Completed in 0 ms with result: 1
- 10:46:47.295:
- 10:46:47.296: INSERT [dbo].[AuditTrail]([When], [UserId], [AuditActionId], [DocumentId], [TaskId])
- VALUES (@0, @1, @2, @3, @4)
- SELECT [ID]
- FROM [dbo].[AuditTrail]
- WHERE @@ROWCOUNT > 0 AND [ID] = scope_identity()10:46:47.296:
- 10:46:47.296: -- @0: '7/29/2016 10:46:47 AM' (Type = DateTime2)
- 10:46:47.296: -- @1: '85fec6aa-3ce7-420c-b990-c7639c06ca33' (Type = Guid)
- 10:46:47.296: -- @2: '2' (Type = Int32)
- 10:46:47.297: -- @3: '2016' (Type = Int32)
- 10:46:47.297: -- @4: '968' (Type = Int32)
- 10:46:47.297: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.298: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.298:
- 10:46:47.298: Committed transaction at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.298: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.299: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.3: SELECT
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name]
- FROM [dbo].[DocumentStatus] AS [Extent1]
- WHERE [Extent1].[Id] = @EntityKeyValue110:46:47.301:
- 10:46:47.301: -- EntityKeyValue1: '1' (Type = Int32)
- 10:46:47.301: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.302: -- Completed in 1 ms with result: SqlDataReader
- 10:46:47.302:
- 10:46:47.303: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.305: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.305: SELECT TOP (1)
- [Extent1].[RoleId] AS [RoleId],
- [Extent1].[ApplicationId] AS [ApplicationId],
- [Extent1].[RoleName] AS [RoleName],
- [Extent1].[LoweredRoleName] AS [LoweredRoleName],
- [Extent1].[Description] AS [Description]
- FROM [dbo].[aspnet_Roles] AS [Extent1]
- WHERE [Extent1].[RoleId] = @p__linq__010:46:47.306:
- 10:46:47.306: -- p__linq__0: 'aa793e06-fd53-e611-80c3-00155d63106c' (Type = Guid, IsNullable = false)
- 10:46:47.306: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.306: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.307:
- 10:46:47.307: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.308: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.31: SELECT TOP (2)
- [Extent1].[ID] AS [ID],
- [Extent1].[ID_aspnet_Users] AS [ID_aspnet_Users],
- [Extent1].[FirstName] AS [FirstName],
- [Extent1].[LastName] AS [LastName],
- [Extent1].[Active] AS [Active]
- FROM [dbo].[User] AS [Extent1]
- WHERE [Extent1].[ID_aspnet_Users] = @p__linq__010:46:47.31:
- 10:46:47.31: -- p__linq__0: 'bbd89cbf-7995-4448-92b8-adaf29b268fd' (Type = Guid, IsNullable = false)
- 10:46:47.311: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.312: -- Completed in 1 ms with result: SqlDataReader
- 10:46:47.312:
- 10:46:47.313: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.314: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.332: SELECT
- [Extent1].[UserId] AS [UserId],
- [Extent1].[ApplicationId] AS [ApplicationId],
- [Extent1].[Password] AS [Password],
- [Extent1].[PasswordFormat] AS [PasswordFormat],
- [Extent1].[PasswordSalt] AS [PasswordSalt],
- [Extent1].[MobilePIN] AS [MobilePIN],
- [Extent1].[Email] AS [Email],
- [Extent1].[LoweredEmail] AS [LoweredEmail],
- [Extent1].[PasswordQuestion] AS [PasswordQuestion],
- [Extent1].[PasswordAnswer] AS [PasswordAnswer],
- [Extent1].[IsApproved] AS [IsApproved],
- [Extent1].[IsLockedOut] AS [IsLockedOut],
- [Extent1].[CreateDate] AS [CreateDate],
- [Extent1].[LastLoginDate] AS [LastLoginDate],
- [Extent1].[LastPasswordChangedDate] AS [LastPasswordChangedDate],
- [Extent1].[LastLockoutDate] AS [LastLockoutDate],
- [Extent1].[FailedPasswordAttemptCount] AS [FailedPasswordAttemptCount],
- [Extent1].[FailedPasswordAttemptWindowStart] AS [FailedPasswordAttemptWindowStart],
- [Extent1].[FailedPasswordAnswerAttemptCount] AS [FailedPasswordAnswerAttemptCount],
- [Extent1].[FailedPasswordAnswerAttemptWindowStart] AS [FailedPasswordAnswerAttemptWindowStart],
- [Extent1].[Comment] AS [Comment]
- FROM [dbo].[aspnet_Membership] AS [Extent1]
- WHERE [Extent1].[UserId] = @EntityKeyValue110:46:47.332:
- 10:46:47.332: -- EntityKeyValue1: 'bbd89cbf-7995-4448-92b8-adaf29b268fd' (Type = Guid, IsNullable = false)
- 10:46:47.332: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.334: -- Completed in 1 ms with result: SqlDataReader
- 10:46:47.335:
- 10:46:47.343: Closed connection at 7/29/2016 10:46:47 AM +05:00
- Exception thrown: 'System.NullReferenceException' in Core.dll
- 10:46:47.377: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.377: SELECT TOP (2)
- [Extent1].[ID] AS [ID],
- [Extent1].[ID_aspnet_Users] AS [ID_aspnet_Users],
- [Extent1].[FirstName] AS [FirstName],
- [Extent1].[LastName] AS [LastName],
- [Extent1].[Active] AS [Active]
- FROM [dbo].[User] AS [Extent1]
- WHERE [Extent1].[ID_aspnet_Users] = @p__linq__010:46:47.378:
- 10:46:47.378: -- p__linq__0: '85fec6aa-3ce7-420c-b990-c7639c06ca33' (Type = Guid, IsNullable = false)
- 10:46:47.378: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.379: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.379:
- 10:46:47.379: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.38: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.38: SELECT
- [Extent1].[UserId] AS [UserId],
- [Extent1].[ApplicationId] AS [ApplicationId],
- [Extent1].[Password] AS [Password],
- [Extent1].[PasswordFormat] AS [PasswordFormat],
- [Extent1].[PasswordSalt] AS [PasswordSalt],
- [Extent1].[MobilePIN] AS [MobilePIN],
- [Extent1].[Email] AS [Email],
- [Extent1].[LoweredEmail] AS [LoweredEmail],
- [Extent1].[PasswordQuestion] AS [PasswordQuestion],
- [Extent1].[PasswordAnswer] AS [PasswordAnswer],
- [Extent1].[IsApproved] AS [IsApproved],
- [Extent1].[IsLockedOut] AS [IsLockedOut],
- [Extent1].[CreateDate] AS [CreateDate],
- [Extent1].[LastLoginDate] AS [LastLoginDate],
- [Extent1].[LastPasswordChangedDate] AS [LastPasswordChangedDate],
- [Extent1].[LastLockoutDate] AS [LastLockoutDate],
- [Extent1].[FailedPasswordAttemptCount] AS [FailedPasswordAttemptCount],
- [Extent1].[FailedPasswordAttemptWindowStart] AS [FailedPasswordAttemptWindowStart],
- [Extent1].[FailedPasswordAnswerAttemptCount] AS [FailedPasswordAnswerAttemptCount],
- [Extent1].[FailedPasswordAnswerAttemptWindowStart] AS [FailedPasswordAnswerAttemptWindowStart],
- [Extent1].[Comment] AS [Comment]
- FROM [dbo].[aspnet_Membership] AS [Extent1]
- WHERE [Extent1].[UserId] = @EntityKeyValue110:46:47.38:
- 10:46:47.38: -- EntityKeyValue1: '85fec6aa-3ce7-420c-b990-c7639c06ca33' (Type = Guid, IsNullable = false)
- 10:46:47.38: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.381: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.381:
- 10:46:47.381: Closed connection at 7/29/2016 10:46:47 AM +05:00
- Exception thrown: 'System.NullReferenceException' in Core.dll
- 10:46:47.399: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.399: SELECT TOP (1)
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name],
- [Extent1].[Value] AS [Value],
- [Extent1].[LongValue] AS [LongValue]
- FROM [dbo].[Setting] AS [Extent1]
- WHERE N'NotificationEmail' = [Extent1].[Name]10:46:47.4:
- 10:46:47.4: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.401: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.401:
- 10:46:47.402: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.403: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.404: SELECT TOP (1)
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name],
- [Extent1].[Value] AS [Value],
- [Extent1].[LongValue] AS [LongValue]
- FROM [dbo].[Setting] AS [Extent1]
- WHERE N'SmtpServer' = [Extent1].[Name]10:46:47.406:
- 10:46:47.407: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.407: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.408:
- 10:46:47.408: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.408: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.409: SELECT TOP (1)
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name],
- [Extent1].[Value] AS [Value],
- [Extent1].[LongValue] AS [LongValue]
- FROM [dbo].[Setting] AS [Extent1]
- WHERE N'SmtpPort' = [Extent1].[Name]10:46:47.409:
- 10:46:47.41: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.41: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.41:
- 10:46:47.411: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.411: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.412: SELECT TOP (1)
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name],
- [Extent1].[Value] AS [Value],
- [Extent1].[LongValue] AS [LongValue]
- FROM [dbo].[Setting] AS [Extent1]
- WHERE N'NotificationPassword' = [Extent1].[Name]10:46:47.412:
- 10:46:47.412: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.413: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.413:
- 10:46:47.413: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.413: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.414: SELECT TOP (1)
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name],
- [Extent1].[Value] AS [Value],
- [Extent1].[LongValue] AS [LongValue]
- FROM [dbo].[Setting] AS [Extent1]
- WHERE N'RequiredAuthentication' = [Extent1].[Name]10:46:47.414:
- 10:46:47.414: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.415: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.415:
- 10:46:47.415: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.416: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.416: SELECT TOP (1)
- [Extent1].[ID] AS [ID],
- [Extent1].[ID_aspnet_Users] AS [ID_aspnet_Users],
- [Extent1].[FirstName] AS [FirstName],
- [Extent1].[LastName] AS [LastName],
- [Extent1].[Active] AS [Active]
- FROM [dbo].[User] AS [Extent1]
- LEFT OUTER JOIN [dbo].[aspnet_Users] AS [Extent2] ON [Extent1].[ID_aspnet_Users] = [Extent2].[UserId]
- WHERE ([Extent2].[UserName] = @p__linq__0) OR (([Extent2].[UserName] IS NULL) AND (@p__linq__0 IS NULL))10:46:47.417:
- 10:46:47.417: -- p__linq__0: 'admin' (Type = String, Size = 4000)
- 10:46:47.417: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.417: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.418:
- 10:46:47.418: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.418: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.419: SELECT
- [Extent1].[UserId] AS [UserId],
- [Extent1].[ApplicationId] AS [ApplicationId],
- [Extent1].[UserName] AS [UserName],
- [Extent1].[LoweredUserName] AS [LoweredUserName],
- [Extent1].[MobileAlias] AS [MobileAlias],
- [Extent1].[IsAnonymous] AS [IsAnonymous],
- [Extent1].[LastActivityDate] AS [LastActivityDate]
- FROM [dbo].[aspnet_Users] AS [Extent1]
- WHERE [Extent1].[UserId] = @EntityKeyValue110:46:47.419:
- 10:46:47.419: -- EntityKeyValue1: 'd2350d7b-bfa5-4b2a-9f08-5cae6a094a9e' (Type = Guid)
- 10:46:47.419: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.42: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.42:
- 10:46:47.42: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.421: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.421: SELECT
- [Extent2].[RoleId] AS [RoleId],
- [Extent2].[ApplicationId] AS [ApplicationId],
- [Extent2].[RoleName] AS [RoleName],
- [Extent2].[LoweredRoleName] AS [LoweredRoleName],
- [Extent2].[Description] AS [Description]
- FROM [dbo].[aspnet_UsersInRoles] AS [Extent1]
- INNER JOIN [dbo].[aspnet_Roles] AS [Extent2] ON [Extent1].[RoleId] = [Extent2].[RoleId]
- WHERE [Extent1].[UserId] = @EntityKeyValue110:46:47.421:
- 10:46:47.421: -- EntityKeyValue1: 'd2350d7b-bfa5-4b2a-9f08-5cae6a094a9e' (Type = Guid, IsNullable = false)
- 10:46:47.422: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.422: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.422:
- 10:46:47.423: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.423: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.423: SELECT
- [Extent1].[ID] AS [ID],
- [Extent1].[Name] AS [Name],
- [Extent1].[SourceSystemId] AS [SourceSystemId],
- [Extent1].[ID_ActionType] AS [ID_ActionType],
- [Extent1].[ID_Group] AS [ID_Group]
- FROM [dbo].[AccessRight] AS [Extent1]
- WHERE [Extent1].[ID_Group] = @EntityKeyValue110:46:47.424:
- 10:46:47.424: -- EntityKeyValue1: '59d39023-fc53-e611-80c3-00155d63106c' (Type = Guid, IsNullable = false)
- 10:46:47.424: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.425: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.425:
- 10:46:47.425: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.426: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.426: SELECT
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name]
- FROM [dbo].[ActionType] AS [Extent1]
- WHERE [Extent1].[Id] = @EntityKeyValue110:46:47.426:
- 10:46:47.426: -- EntityKeyValue1: '6' (Type = Int32)
- 10:46:47.427: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.427: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.427:
- 10:46:47.428: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.428: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.428: SELECT
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name]
- FROM [dbo].[ActionType] AS [Extent1]
- WHERE [Extent1].[Id] = @EntityKeyValue110:46:47.429:
- 10:46:47.429: -- EntityKeyValue1: '7' (Type = Int32)
- 10:46:47.429: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.429: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.43:
- 10:46:47.43: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.43: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.431: SELECT
- [Extent1].[ID] AS [ID],
- [Extent1].[Name] AS [Name],
- [Extent1].[SourceSystemId] AS [SourceSystemId],
- [Extent1].[ID_ActionType] AS [ID_ActionType],
- [Extent1].[ID_Group] AS [ID_Group]
- FROM [dbo].[AccessRight] AS [Extent1]
- WHERE [Extent1].[ID_Group] = @EntityKeyValue110:46:47.431:
- 10:46:47.431: -- EntityKeyValue1: 'f82b1d7a-0054-e611-80c3-00155d63106c' (Type = Guid, IsNullable = false)
- 10:46:47.431: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.432: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.432:
- 10:46:47.432: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.433: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.433: SELECT
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name]
- FROM [dbo].[ActionType] AS [Extent1]
- WHERE [Extent1].[Id] = @EntityKeyValue110:46:47.433:
- 10:46:47.433: -- EntityKeyValue1: '3' (Type = Int32)
- 10:46:47.434: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.434: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.434:
- 10:46:47.434: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.435: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.435: SELECT
- [Extent1].[Id] AS [Id],
- [Extent1].[Name] AS [Name],
- [Extent1].[ActionTypeId] AS [ActionTypeId],
- [Extent1].[BusinessProcessId] AS [BusinessProcessId],
- [Extent1].[DocumentStatusId] AS [DocumentStatusId]
- FROM [dbo].[Stage] AS [Extent1]10:46:47.435:
- 10:46:47.435: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.436: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.436:
- 10:46:47.437: Closed connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.437: Opened connection at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.438: SELECT
- [GroupBy1].[A1] AS [C1]
- FROM ( SELECT
- COUNT(1) AS [A1]
- FROM [dbo].[Task] AS [Extent1]
- INNER JOIN [dbo].[TaskPerformer] AS [Extent2] ON [Extent1].[TaskPerformerId] = [Extent2].[Id]
- WHERE ([Extent2].[UserId] = @p__linq__0) AND ([Extent1].[StageId] = @p__linq__1) AND ([Extent1].[StatusId] < 3)
- ) AS [GroupBy1]10:46:47.438:
- 10:46:47.438: -- p__linq__0: 'd2350d7b-bfa5-4b2a-9f08-5cae6a094a9e' (Type = Guid, IsNullable = false)
- 10:46:47.439: -- p__linq__1: '3' (Type = Int32, IsNullable = false)
- 10:46:47.439: -- Executing at 7/29/2016 10:46:47 AM +05:00
- 10:46:47.439: -- Completed in 0 ms with result: SqlDataReader
- 10:46:47.44:
- 10:46:47.44: Closed connection at 7/29/2016 10:46:47 AM +05:00
- The thread 0x854 has exited with code 0 (0x0).
- The thread 0x4bc has exited with code 0 (0x0).
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement