Advertisement
Guest User

Untitled

a guest
Jul 29th, 2016
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 63.17 KB | None | 0 0
  1. 10:46:46.716: Opened connection at 7/29/2016 10:46:46 AM +05:00
  2. 10:46:46.716: SELECT TOP (1)
  3. [Extent1].[Id] AS [Id],
  4. [Extent1].[Name] AS [Name],
  5. [Extent1].[Value] AS [Value],
  6. [Extent1].[LongValue] AS [LongValue]
  7. FROM [dbo].[Setting] AS [Extent1]
  8. WHERE N'NotificationEmail' = [Extent1].[Name]10:46:46.716:
  9. 10:46:46.717: -- Executing at 7/29/2016 10:46:46 AM +05:00
  10. 10:46:46.717: -- Completed in 0 ms with result: SqlDataReader
  11. 10:46:46.717:
  12. 10:46:46.718: Closed connection at 7/29/2016 10:46:46 AM +05:00
  13. 10:46:46.718: Opened connection at 7/29/2016 10:46:46 AM +05:00
  14. 10:46:46.718: SELECT TOP (1)
  15. [Extent1].[Id] AS [Id],
  16. [Extent1].[Name] AS [Name],
  17. [Extent1].[Value] AS [Value],
  18. [Extent1].[LongValue] AS [LongValue]
  19. FROM [dbo].[Setting] AS [Extent1]
  20. WHERE N'SmtpServer' = [Extent1].[Name]10:46:46.719:
  21. 10:46:46.719: -- Executing at 7/29/2016 10:46:46 AM +05:00
  22. 10:46:46.719: -- Completed in 0 ms with result: SqlDataReader
  23. 10:46:46.719:
  24. 10:46:46.72: Closed connection at 7/29/2016 10:46:46 AM +05:00
  25. 10:46:46.72: Opened connection at 7/29/2016 10:46:46 AM +05:00
  26. 10:46:46.72: SELECT TOP (1)
  27. [Extent1].[Id] AS [Id],
  28. [Extent1].[Name] AS [Name],
  29. [Extent1].[Value] AS [Value],
  30. [Extent1].[LongValue] AS [LongValue]
  31. FROM [dbo].[Setting] AS [Extent1]
  32. WHERE N'SmtpPort' = [Extent1].[Name]10:46:46.721:
  33. 10:46:46.721: -- Executing at 7/29/2016 10:46:46 AM +05:00
  34. 10:46:46.721: -- Completed in 0 ms with result: SqlDataReader
  35. 10:46:46.721:
  36. 10:46:46.722: Closed connection at 7/29/2016 10:46:46 AM +05:00
  37. 10:46:46.722: Opened connection at 7/29/2016 10:46:46 AM +05:00
  38. 10:46:46.722: SELECT TOP (1)
  39. [Extent1].[Id] AS [Id],
  40. [Extent1].[Name] AS [Name],
  41. [Extent1].[Value] AS [Value],
  42. [Extent1].[LongValue] AS [LongValue]
  43. FROM [dbo].[Setting] AS [Extent1]
  44. WHERE N'NotificationPassword' = [Extent1].[Name]10:46:46.722:
  45. 10:46:46.723: -- Executing at 7/29/2016 10:46:46 AM +05:00
  46. 10:46:46.723: -- Completed in 0 ms with result: SqlDataReader
  47. 10:46:46.723:
  48. 10:46:46.723: Closed connection at 7/29/2016 10:46:46 AM +05:00
  49. 10:46:46.724: Opened connection at 7/29/2016 10:46:46 AM +05:00
  50. 10:46:46.724: SELECT TOP (1)
  51. [Extent1].[Id] AS [Id],
  52. [Extent1].[Name] AS [Name],
  53. [Extent1].[Value] AS [Value],
  54. [Extent1].[LongValue] AS [LongValue]
  55. FROM [dbo].[Setting] AS [Extent1]
  56. WHERE N'RequiredAuthentication' = [Extent1].[Name]10:46:46.724:
  57. 10:46:46.725: -- Executing at 7/29/2016 10:46:46 AM +05:00
  58. 10:46:46.725: -- Completed in 0 ms with result: SqlDataReader
  59. 10:46:46.725:
  60. 10:46:46.725: Closed connection at 7/29/2016 10:46:46 AM +05:00
  61. 10:46:46.726: Opened connection at 7/29/2016 10:46:46 AM +05:00
  62. 10:46:46.726: SELECT TOP (1)
  63. [Extent1].[ID] AS [ID],
  64. [Extent1].[ID_aspnet_Users] AS [ID_aspnet_Users],
  65. [Extent1].[FirstName] AS [FirstName],
  66. [Extent1].[LastName] AS [LastName],
  67. [Extent1].[Active] AS [Active]
  68. FROM [dbo].[User] AS [Extent1]
  69. LEFT OUTER JOIN [dbo].[aspnet_Users] AS [Extent2] ON [Extent1].[ID_aspnet_Users] = [Extent2].[UserId]
  70. WHERE ([Extent2].[UserName] = @p__linq__0) OR (([Extent2].[UserName] IS NULL) AND (@p__linq__0 IS NULL))10:46:46.727:
  71. 10:46:46.727: -- p__linq__0: 'admin' (Type = String, Size = 4000)
  72. 10:46:46.727: -- Executing at 7/29/2016 10:46:46 AM +05:00
  73. 10:46:46.727: -- Completed in 0 ms with result: SqlDataReader
  74. 10:46:46.728:
  75. 10:46:46.728: Closed connection at 7/29/2016 10:46:46 AM +05:00
  76. 10:46:46.728: Opened connection at 7/29/2016 10:46:46 AM +05:00
  77. 10:46:46.729: SELECT
  78. [Extent1].[UserId] AS [UserId],
  79. [Extent1].[ApplicationId] AS [ApplicationId],
  80. [Extent1].[UserName] AS [UserName],
  81. [Extent1].[LoweredUserName] AS [LoweredUserName],
  82. [Extent1].[MobileAlias] AS [MobileAlias],
  83. [Extent1].[IsAnonymous] AS [IsAnonymous],
  84. [Extent1].[LastActivityDate] AS [LastActivityDate]
  85. FROM [dbo].[aspnet_Users] AS [Extent1]
  86. WHERE [Extent1].[UserId] = @EntityKeyValue110:46:46.729:
  87. 10:46:46.729: -- EntityKeyValue1: 'd2350d7b-bfa5-4b2a-9f08-5cae6a094a9e' (Type = Guid)
  88. 10:46:46.729: -- Executing at 7/29/2016 10:46:46 AM +05:00
  89. 10:46:46.73: -- Completed in 0 ms with result: SqlDataReader
  90. 10:46:46.73:
  91. 10:46:46.73: Closed connection at 7/29/2016 10:46:46 AM +05:00
  92. 10:46:46.731: Opened connection at 7/29/2016 10:46:46 AM +05:00
  93. 10:46:46.731: SELECT
  94. [Extent2].[RoleId] AS [RoleId],
  95. [Extent2].[ApplicationId] AS [ApplicationId],
  96. [Extent2].[RoleName] AS [RoleName],
  97. [Extent2].[LoweredRoleName] AS [LoweredRoleName],
  98. [Extent2].[Description] AS [Description]
  99. FROM [dbo].[aspnet_UsersInRoles] AS [Extent1]
  100. INNER JOIN [dbo].[aspnet_Roles] AS [Extent2] ON [Extent1].[RoleId] = [Extent2].[RoleId]
  101. WHERE [Extent1].[UserId] = @EntityKeyValue110:46:46.731:
  102. 10:46:46.731: -- EntityKeyValue1: 'd2350d7b-bfa5-4b2a-9f08-5cae6a094a9e' (Type = Guid, IsNullable = false)
  103. 10:46:46.732: -- Executing at 7/29/2016 10:46:46 AM +05:00
  104. 10:46:46.732: -- Completed in 0 ms with result: SqlDataReader
  105. 10:46:46.732:
  106. 10:46:46.732: Closed connection at 7/29/2016 10:46:46 AM +05:00
  107. 10:46:46.733: Opened connection at 7/29/2016 10:46:46 AM +05:00
  108. 10:46:46.733: SELECT
  109. [Extent1].[ID] AS [ID],
  110. [Extent1].[Name] AS [Name],
  111. [Extent1].[SourceSystemId] AS [SourceSystemId],
  112. [Extent1].[ID_ActionType] AS [ID_ActionType],
  113. [Extent1].[ID_Group] AS [ID_Group]
  114. FROM [dbo].[AccessRight] AS [Extent1]
  115. WHERE [Extent1].[ID_Group] = @EntityKeyValue110:46:46.733:
  116. 10:46:46.733: -- EntityKeyValue1: '59d39023-fc53-e611-80c3-00155d63106c' (Type = Guid, IsNullable = false)
  117. 10:46:46.734: -- Executing at 7/29/2016 10:46:46 AM +05:00
  118. 10:46:46.734: -- Completed in 0 ms with result: SqlDataReader
  119. 10:46:46.734:
  120. 10:46:46.735: Closed connection at 7/29/2016 10:46:46 AM +05:00
  121. 10:46:46.735: Opened connection at 7/29/2016 10:46:46 AM +05:00
  122. 10:46:46.735: SELECT
  123. [Extent1].[Id] AS [Id],
  124. [Extent1].[Name] AS [Name]
  125. FROM [dbo].[ActionType] AS [Extent1]
  126. WHERE [Extent1].[Id] = @EntityKeyValue110:46:46.735:
  127. 10:46:46.736: -- EntityKeyValue1: '6' (Type = Int32)
  128. 10:46:46.736: -- Executing at 7/29/2016 10:46:46 AM +05:00
  129. 10:46:46.736: -- Completed in 0 ms with result: SqlDataReader
  130. 10:46:46.736:
  131. 10:46:46.737: Closed connection at 7/29/2016 10:46:46 AM +05:00
  132. 10:46:46.737: Opened connection at 7/29/2016 10:46:46 AM +05:00
  133. 10:46:46.737: SELECT
  134. [Extent1].[Id] AS [Id],
  135. [Extent1].[Name] AS [Name]
  136. FROM [dbo].[ActionType] AS [Extent1]
  137. WHERE [Extent1].[Id] = @EntityKeyValue110:46:46.738:
  138. 10:46:46.738: -- EntityKeyValue1: '7' (Type = Int32)
  139. 10:46:46.738: -- Executing at 7/29/2016 10:46:46 AM +05:00
  140. 10:46:46.738: -- Completed in 0 ms with result: SqlDataReader
  141. 10:46:46.738:
  142. 10:46:46.739: Closed connection at 7/29/2016 10:46:46 AM +05:00
  143. 10:46:46.739: Opened connection at 7/29/2016 10:46:46 AM +05:00
  144. 10:46:46.739: SELECT
  145. [Extent1].[ID] AS [ID],
  146. [Extent1].[Name] AS [Name],
  147. [Extent1].[SourceSystemId] AS [SourceSystemId],
  148. [Extent1].[ID_ActionType] AS [ID_ActionType],
  149. [Extent1].[ID_Group] AS [ID_Group]
  150. FROM [dbo].[AccessRight] AS [Extent1]
  151. WHERE [Extent1].[ID_Group] = @EntityKeyValue110:46:46.74:
  152. 10:46:46.74: -- EntityKeyValue1: 'f82b1d7a-0054-e611-80c3-00155d63106c' (Type = Guid, IsNullable = false)
  153. 10:46:46.74: -- Executing at 7/29/2016 10:46:46 AM +05:00
  154. 10:46:46.74: -- Completed in 0 ms with result: SqlDataReader
  155. 10:46:46.74:
  156. 10:46:46.741: Closed connection at 7/29/2016 10:46:46 AM +05:00
  157. 10:46:46.741: Opened connection at 7/29/2016 10:46:46 AM +05:00
  158. 10:46:46.741: SELECT
  159. [Extent1].[Id] AS [Id],
  160. [Extent1].[Name] AS [Name]
  161. FROM [dbo].[ActionType] AS [Extent1]
  162. WHERE [Extent1].[Id] = @EntityKeyValue110:46:46.742:
  163. 10:46:46.742: -- EntityKeyValue1: '3' (Type = Int32)
  164. 10:46:46.742: -- Executing at 7/29/2016 10:46:46 AM +05:00
  165. 10:46:46.742: -- Completed in 0 ms with result: SqlDataReader
  166. 10:46:46.743:
  167. 10:46:46.743: Closed connection at 7/29/2016 10:46:46 AM +05:00
  168. 10:46:46.743: Opened connection at 7/29/2016 10:46:46 AM +05:00
  169. 10:46:46.743: SELECT
  170. [Extent1].[Id] AS [Id],
  171. [Extent1].[Name] AS [Name],
  172. [Extent1].[ActionTypeId] AS [ActionTypeId],
  173. [Extent1].[BusinessProcessId] AS [BusinessProcessId],
  174. [Extent1].[DocumentStatusId] AS [DocumentStatusId]
  175. FROM [dbo].[Stage] AS [Extent1]10:46:46.744:
  176. 10:46:46.744: -- Executing at 7/29/2016 10:46:46 AM +05:00
  177. 10:46:46.744: -- Completed in 0 ms with result: SqlDataReader
  178. 10:46:46.744:
  179. 10:46:46.745: Closed connection at 7/29/2016 10:46:46 AM +05:00
  180. 10:46:46.749: Opened connection at 7/29/2016 10:46:46 AM +05:00
  181. 10:46:46.824: SELECT
  182. [Project2].[Id] AS [Id],
  183. [Project2].[Name] AS [Name],
  184. [Project2].[PeriodTypeId] AS [PeriodTypeId],
  185. [Project2].[ParentSourceSystemId] AS [ParentSourceSystemId],
  186. [Project2].[Icon] AS [Icon],
  187. [Project2].[IconType] AS [IconType],
  188. [Project2].[C1] AS [C1],
  189. [Project2].[Id1] AS [Id1],
  190. [Project2].[Name1] AS [Name1],
  191. [Project2].[AuthorId] AS [AuthorId],
  192. [Project2].[PeriodTypeId1] AS [PeriodTypeId1],
  193. [Project2].[SourceSystemId] AS [SourceSystemId]
  194. FROM ( SELECT
  195. [Limit1].[Id] AS [Id],
  196. [Limit1].[Name] AS [Name],
  197. [Limit1].[PeriodTypeId] AS [PeriodTypeId],
  198. [Limit1].[ParentSourceSystemId] AS [ParentSourceSystemId],
  199. [Limit1].[Icon] AS [Icon],
  200. [Limit1].[IconType] AS [IconType],
  201. [Extent3].[Id] AS [Id1],
  202. [Extent3].[Name] AS [Name1],
  203. [Extent3].[AuthorId] AS [AuthorId],
  204. [Extent3].[PeriodTypeId] AS [PeriodTypeId1],
  205. [Extent3].[SourceSystemId] AS [SourceSystemId],
  206. CASE WHEN ([Extent3].[Id] IS NULL) THEN CAST(NULL AS int) ELSE 1 END AS [C1]
  207. 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]
  208. FROM ( SELECT
  209. [Extent1].[Id] AS [Id],
  210. [Extent1].[Name] AS [Name],
  211. [Extent1].[PeriodTypeId] AS [PeriodTypeId],
  212. [Extent1].[ParentSourceSystemId] AS [ParentSourceSystemId],
  213. [Extent1].[Icon] AS [Icon],
  214. [Extent1].[IconType] AS [IconType],
  215. (SELECT
  216. COUNT(1) AS [A1]
  217. FROM [dbo].[DocumentTemplate] AS [Extent2]
  218. WHERE [Extent1].[Id] = [Extent2].[SourceSystemId]) AS [C1]
  219. FROM [dbo].[SourceSystem] AS [Extent1]
  220. ) AS [Project1]
  221. WHERE [Project1].[C1] > 0 ) AS [Limit1]
  222. LEFT OUTER JOIN [dbo].[DocumentTemplate] AS [Extent3] ON [Limit1].[Id] = [Extent3].[SourceSystemId]
  223. ) AS [Project2]
  224. ORDER BY [Project2].[Id] ASC, [Project2].[C1] ASC10:46:46.824:
  225. 10:46:46.825: -- Executing at 7/29/2016 10:46:46 AM +05:00
  226. 10:46:46.83: -- Completed in 5 ms with result: SqlDataReader
  227. 10:46:46.831:
  228. 10:46:46.847: Closed connection at 7/29/2016 10:46:46 AM +05:00
  229. 10:46:46.852: Opened connection at 7/29/2016 10:46:46 AM +05:00
  230. 10:46:46.861: SELECT TOP (2)
  231. [Extent1].[Id] AS [Id],
  232. [Extent1].[Name] AS [Name],
  233. [Extent1].[AuthorId] AS [AuthorId],
  234. [Extent1].[PeriodTypeId] AS [PeriodTypeId],
  235. [Extent1].[SourceSystemId] AS [SourceSystemId]
  236. FROM [dbo].[DocumentTemplate] AS [Extent1]
  237. WHERE [Extent1].[Id] = @p__linq__010:46:46.861:
  238. 10:46:46.862: -- p__linq__0: '2' (Type = Int32, IsNullable = false)
  239. 10:46:46.862: -- Executing at 7/29/2016 10:46:46 AM +05:00
  240. 10:46:46.863: -- Completed in 1 ms with result: SqlDataReader
  241. 10:46:46.863:
  242. 10:46:46.864: Closed connection at 7/29/2016 10:46:46 AM +05:00
  243. 10:46:46.865: Opened connection at 7/29/2016 10:46:46 AM +05:00
  244. 10:46:46.87: SELECT
  245. [Extent1].[Id] AS [Id],
  246. [Extent1].[Name] AS [Name]
  247. FROM [dbo].[ActionType] AS [Extent1]
  248. WHERE [Extent1].[Name] IN (N'Edit', N'Approve', N'Final Approve')10:46:46.87:
  249. 10:46:46.871: -- Executing at 7/29/2016 10:46:46 AM +05:00
  250. 10:46:46.872: -- Completed in 1 ms with result: SqlDataReader
  251. 10:46:46.872:
  252. 10:46:46.878: SELECT
  253. [Extent1].[ID] AS [ID],
  254. [Extent1].[Name] AS [Name],
  255. [Extent1].[SourceSystemId] AS [SourceSystemId],
  256. [Extent1].[ID_ActionType] AS [ID_ActionType],
  257. [Extent1].[ID_Group] AS [ID_Group]
  258. FROM [dbo].[AccessRight] AS [Extent1]10:46:46.878:
  259. 10:46:46.878: -- Executing at 7/29/2016 10:46:46 AM +05:00
  260. 10:46:46.879: -- Completed in 0 ms with result: SqlDataReader
  261. 10:46:46.88:
  262. 10:46:46.884: SELECT
  263. [Extent1].[RoleId] AS [RoleId],
  264. [Extent1].[ApplicationId] AS [ApplicationId],
  265. [Extent1].[RoleName] AS [RoleName],
  266. [Extent1].[LoweredRoleName] AS [LoweredRoleName],
  267. [Extent1].[Description] AS [Description]
  268. FROM [dbo].[aspnet_Roles] AS [Extent1]
  269. WHERE [Extent1].[RoleId] = @EntityKeyValue110:46:46.884:
  270. 10:46:46.884: -- EntityKeyValue1: 'e124b068-ff53-e611-80c3-00155d63106c' (Type = Guid)
  271. 10:46:46.884: -- Executing at 7/29/2016 10:46:46 AM +05:00
  272. 10:46:46.885: -- Completed in 0 ms with result: SqlDataReader
  273. 10:46:46.886:
  274. 10:46:46.886: SELECT
  275. [Extent1].[RoleId] AS [RoleId],
  276. [Extent1].[ApplicationId] AS [ApplicationId],
  277. [Extent1].[RoleName] AS [RoleName],
  278. [Extent1].[LoweredRoleName] AS [LoweredRoleName],
  279. [Extent1].[Description] AS [Description]
  280. FROM [dbo].[aspnet_Roles] AS [Extent1]
  281. WHERE [Extent1].[RoleId] = @EntityKeyValue110:46:46.887:
  282. 10:46:46.887: -- EntityKeyValue1: 'f1744779-ff53-e611-80c3-00155d63106c' (Type = Guid)
  283. 10:46:46.887: -- Executing at 7/29/2016 10:46:46 AM +05:00
  284. 10:46:46.887: -- Completed in 0 ms with result: SqlDataReader
  285. 10:46:46.888:
  286. 10:46:46.89: SELECT
  287. [Extent1].[Id] AS [Id],
  288. [Extent1].[DocumentId] AS [DocumentId],
  289. [Extent1].[TemplateId] AS [TemplateId],
  290. [Extent1].[ActionTypeId] AS [ActionTypeId]
  291. FROM [dbo].[ProcessQueue] AS [Extent1]
  292. WHERE [Extent1].[TemplateId] = @EntityKeyValue110:46:46.89:
  293. 10:46:46.89: -- EntityKeyValue1: '2' (Type = Int32, IsNullable = false)
  294. 10:46:46.89: -- Executing at 7/29/2016 10:46:46 AM +05:00
  295. 10:46:46.892: -- Completed in 1 ms with result: SqlDataReader
  296. 10:46:46.892:
  297. 10:46:46.907: SELECT
  298. [Extent1].[Id] AS [Id],
  299. [Extent1].[StatusId] AS [StatusId],
  300. [Extent1].[RoleId] AS [RoleId],
  301. [Extent1].[QueueId] AS [QueueId],
  302. [Extent1].[TaskId] AS [TaskId],
  303. [Extent1].[Sent] AS [Sent],
  304. [Extent1].[Finished] AS [Finished],
  305. [Extent1].[Order] AS [Order]
  306. FROM [dbo].[ProcessQueueItem] AS [Extent1]
  307. WHERE [Extent1].[QueueId] = @EntityKeyValue110:46:46.907:
  308. 10:46:46.908: -- EntityKeyValue1: '1' (Type = Int32, IsNullable = false)
  309. 10:46:46.908: -- Executing at 7/29/2016 10:46:46 AM +05:00
  310. 10:46:46.91: -- Completed in 1 ms with result: SqlDataReader
  311. 10:46:46.91:
  312. 10:46:46.916: SELECT
  313. [Extent1].[ID] AS [ID],
  314. [Extent1].[Name] AS [Name],
  315. [Extent1].[SourceSystemId] AS [SourceSystemId],
  316. [Extent1].[ID_ActionType] AS [ID_ActionType],
  317. [Extent1].[ID_Group] AS [ID_Group]
  318. FROM [dbo].[AccessRight] AS [Extent1]10:46:46.916:
  319. 10:46:46.916: -- Executing at 7/29/2016 10:46:46 AM +05:00
  320. 10:46:46.917: -- Completed in 0 ms with result: SqlDataReader
  321. 10:46:46.917:
  322. 10:46:46.918: SELECT
  323. [Extent1].[RoleId] AS [RoleId],
  324. [Extent1].[ApplicationId] AS [ApplicationId],
  325. [Extent1].[RoleName] AS [RoleName],
  326. [Extent1].[LoweredRoleName] AS [LoweredRoleName],
  327. [Extent1].[Description] AS [Description]
  328. FROM [dbo].[aspnet_Roles] AS [Extent1]
  329. WHERE [Extent1].[RoleId] = @EntityKeyValue110:46:46.918:
  330. 10:46:46.919: -- EntityKeyValue1: 'aa793e06-fd53-e611-80c3-00155d63106c' (Type = Guid)
  331. 10:46:46.919: -- Executing at 7/29/2016 10:46:46 AM +05:00
  332. 10:46:46.919: -- Completed in 0 ms with result: SqlDataReader
  333. 10:46:46.919:
  334. 10:46:46.92: SELECT
  335. [Extent1].[RoleId] AS [RoleId],
  336. [Extent1].[ApplicationId] AS [ApplicationId],
  337. [Extent1].[RoleName] AS [RoleName],
  338. [Extent1].[LoweredRoleName] AS [LoweredRoleName],
  339. [Extent1].[Description] AS [Description]
  340. FROM [dbo].[aspnet_Roles] AS [Extent1]
  341. WHERE [Extent1].[RoleId] = @EntityKeyValue110:46:46.92:
  342. 10:46:46.92: -- EntityKeyValue1: 'f167be34-fd53-e611-80c3-00155d63106c' (Type = Guid)
  343. 10:46:46.92: -- Executing at 7/29/2016 10:46:46 AM +05:00
  344. 10:46:46.921: -- Completed in 0 ms with result: SqlDataReader
  345. 10:46:46.921:
  346. 10:46:46.921: SELECT
  347. [Extent1].[RoleId] AS [RoleId],
  348. [Extent1].[ApplicationId] AS [ApplicationId],
  349. [Extent1].[RoleName] AS [RoleName],
  350. [Extent1].[LoweredRoleName] AS [LoweredRoleName],
  351. [Extent1].[Description] AS [Description]
  352. FROM [dbo].[aspnet_Roles] AS [Extent1]
  353. WHERE [Extent1].[RoleId] = @EntityKeyValue110:46:46.921:
  354. 10:46:46.922: -- EntityKeyValue1: '105d4ff5-fe53-e611-80c3-00155d63106c' (Type = Guid)
  355. 10:46:46.922: -- Executing at 7/29/2016 10:46:46 AM +05:00
  356. 10:46:46.922: -- Completed in 0 ms with result: SqlDataReader
  357. 10:46:46.922:
  358. 10:46:46.923: SELECT
  359. [Extent1].[RoleId] AS [RoleId],
  360. [Extent1].[ApplicationId] AS [ApplicationId],
  361. [Extent1].[RoleName] AS [RoleName],
  362. [Extent1].[LoweredRoleName] AS [LoweredRoleName],
  363. [Extent1].[Description] AS [Description]
  364. FROM [dbo].[aspnet_Roles] AS [Extent1]
  365. WHERE [Extent1].[RoleId] = @EntityKeyValue110:46:46.923:
  366. 10:46:46.923: -- EntityKeyValue1: 'd3bf4a4f-ff53-e611-80c3-00155d63106c' (Type = Guid)
  367. 10:46:46.923: -- Executing at 7/29/2016 10:46:46 AM +05:00
  368. 10:46:46.924: -- Completed in 0 ms with result: SqlDataReader
  369. 10:46:46.924:
  370. 10:46:46.924: SELECT
  371. [Extent1].[ID] AS [ID],
  372. [Extent1].[Name] AS [Name],
  373. [Extent1].[SourceSystemId] AS [SourceSystemId],
  374. [Extent1].[ID_ActionType] AS [ID_ActionType],
  375. [Extent1].[ID_Group] AS [ID_Group]
  376. FROM [dbo].[AccessRight] AS [Extent1]10:46:46.924:
  377. 10:46:46.925: -- Executing at 7/29/2016 10:46:46 AM +05:00
  378. 10:46:46.925: -- Completed in 0 ms with result: SqlDataReader
  379. 10:46:46.925:
  380. 10:46:46.926: SELECT
  381. [Extent1].[Id] AS [Id],
  382. [Extent1].[StatusId] AS [StatusId],
  383. [Extent1].[RoleId] AS [RoleId],
  384. [Extent1].[QueueId] AS [QueueId],
  385. [Extent1].[TaskId] AS [TaskId],
  386. [Extent1].[Sent] AS [Sent],
  387. [Extent1].[Finished] AS [Finished],
  388. [Extent1].[Order] AS [Order]
  389. FROM [dbo].[ProcessQueueItem] AS [Extent1]
  390. WHERE [Extent1].[QueueId] = @EntityKeyValue110:46:46.926:
  391. 10:46:46.926: -- EntityKeyValue1: '2' (Type = Int32, IsNullable = false)
  392. 10:46:46.926: -- Executing at 7/29/2016 10:46:46 AM +05:00
  393. 10:46:46.926: -- Completed in 0 ms with result: SqlDataReader
  394. 10:46:46.927:
  395. 10:46:46.927: SELECT
  396. [Extent1].[ID] AS [ID],
  397. [Extent1].[Name] AS [Name],
  398. [Extent1].[SourceSystemId] AS [SourceSystemId],
  399. [Extent1].[ID_ActionType] AS [ID_ActionType],
  400. [Extent1].[ID_Group] AS [ID_Group]
  401. FROM [dbo].[AccessRight] AS [Extent1]10:46:46.927:
  402. 10:46:46.928: -- Executing at 7/29/2016 10:46:46 AM +05:00
  403. 10:46:46.928: -- Completed in 0 ms with result: SqlDataReader
  404. 10:46:46.928:
  405. 10:46:46.928: SELECT
  406. [Extent1].[RoleId] AS [RoleId],
  407. [Extent1].[ApplicationId] AS [ApplicationId],
  408. [Extent1].[RoleName] AS [RoleName],
  409. [Extent1].[LoweredRoleName] AS [LoweredRoleName],
  410. [Extent1].[Description] AS [Description]
  411. FROM [dbo].[aspnet_Roles] AS [Extent1]
  412. WHERE [Extent1].[RoleId] = @EntityKeyValue110:46:46.929:
  413. 10:46:46.929: -- EntityKeyValue1: '9741a8cb-ff53-e611-80c3-00155d63106c' (Type = Guid)
  414. 10:46:46.929: -- Executing at 7/29/2016 10:46:46 AM +05:00
  415. 10:46:46.929: -- Completed in 0 ms with result: SqlDataReader
  416. 10:46:46.93:
  417. 10:46:46.93: SELECT
  418. [Extent1].[RoleId] AS [RoleId],
  419. [Extent1].[ApplicationId] AS [ApplicationId],
  420. [Extent1].[RoleName] AS [RoleName],
  421. [Extent1].[LoweredRoleName] AS [LoweredRoleName],
  422. [Extent1].[Description] AS [Description]
  423. FROM [dbo].[aspnet_Roles] AS [Extent1]
  424. WHERE [Extent1].[RoleId] = @EntityKeyValue110:46:46.93:
  425. 10:46:46.93: -- EntityKeyValue1: 'ce0374de-ff53-e611-80c3-00155d63106c' (Type = Guid)
  426. 10:46:46.931: -- Executing at 7/29/2016 10:46:46 AM +05:00
  427. 10:46:46.931: -- Completed in 0 ms with result: SqlDataReader
  428. 10:46:46.931:
  429. 10:46:46.932: Closed connection at 7/29/2016 10:46:46 AM +05:00
  430. 10:46:46.933: Opened connection at 7/29/2016 10:46:46 AM +05:00
  431. 10:46:46.943: SELECT TOP (1)
  432. [Extent1].[Id] AS [Id],
  433. [Extent1].[Name] AS [Name]
  434. FROM [dbo].[DocumentStatus] AS [Extent1]
  435. WHERE N'New' = [Extent1].[Name]10:46:46.943:
  436. 10:46:46.943: -- Executing at 7/29/2016 10:46:46 AM +05:00
  437. 10:46:46.945: -- Completed in 1 ms with result: SqlDataReader
  438. 10:46:46.945:
  439. 10:46:46.947: Closed connection at 7/29/2016 10:46:46 AM +05:00
  440. 10:46:46.947: Opened connection at 7/29/2016 10:46:46 AM +05:00
  441. 10:46:46.947: SELECT TOP (1)
  442. [Extent1].[ID] AS [ID],
  443. [Extent1].[ID_aspnet_Users] AS [ID_aspnet_Users],
  444. [Extent1].[FirstName] AS [FirstName],
  445. [Extent1].[LastName] AS [LastName],
  446. [Extent1].[Active] AS [Active]
  447. FROM [dbo].[User] AS [Extent1]
  448. LEFT OUTER JOIN [dbo].[aspnet_Users] AS [Extent2] ON [Extent1].[ID_aspnet_Users] = [Extent2].[UserId]
  449. WHERE ([Extent2].[UserName] = @p__linq__0) OR (([Extent2].[UserName] IS NULL) AND (@p__linq__0 IS NULL))10:46:46.948:
  450. 10:46:46.948: -- p__linq__0: 'admin' (Type = String, Size = 4000)
  451. 10:46:46.948: -- Executing at 7/29/2016 10:46:46 AM +05:00
  452. 10:46:46.949: -- Completed in 0 ms with result: SqlDataReader
  453. 10:46:46.949:
  454. 10:46:46.949: Closed connection at 7/29/2016 10:46:46 AM +05:00
  455. 10:46:46.99: Opened connection at 7/29/2016 10:46:46 AM +05:00
  456. 10:46:46.991: Started transaction at 7/29/2016 10:46:46 AM +05:00
  457. 10:46:47.004: INSERT [dbo].[Document]([Name], [VersionNumber], [FileName], [Data], [PeriodTypeId], [Created], [IsCurrentVersion], [ChronicalDocumentId], [DocumentStatusId], [SourceSystemId], [DocumentTemplateId], [AuthorId], [SubmissionDate], [LastUserId], [LastUserComment], [PositionDate], [SubmissionDeadline])
  458. VALUES (@0, @1, @2, NULL, NULL, @3, @4, NULL, @5, @6, @7, @8, NULL, NULL, NULL, @9, NULL)
  459. SELECT [Id]
  460. FROM [dbo].[Document]
  461. WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.004:
  462. 10:46:47.004: -- @0: '10:46 AM_0' (Type = String, Size = 256)
  463. 10:46:47.005: -- @1: '1.0' (Type = String, Size = 64)
  464. 10:46:47.006: -- @2: 'test.bin' (Type = String, Size = 256)
  465. 10:46:47.006: -- @3: '7/29/2016 10:46:46 AM' (Type = DateTime2)
  466. 10:46:47.006: -- @4: 'True' (Type = Boolean)
  467. 10:46:47.006: -- @5: '6' (Type = Int32)
  468. 10:46:47.007: -- @6: '1' (Type = Int32)
  469. 10:46:47.007: -- @7: '2' (Type = Int32)
  470. 10:46:47.007: -- @8: 'd2350d7b-bfa5-4b2a-9f08-5cae6a094a9e' (Type = Guid)
  471. 10:46:47.007: -- @9: '1/1/0001 12:00:00 AM' (Type = DateTime2)
  472. 10:46:47.008: -- Executing at 7/29/2016 10:46:47 AM +05:00
  473. 10:46:47.011: -- Completed in 3 ms with result: SqlDataReader
  474. 10:46:47.012:
  475. 10:46:47.016: Committed transaction at 7/29/2016 10:46:47 AM +05:00
  476. 10:46:47.016: Closed connection at 7/29/2016 10:46:47 AM +05:00
  477. 10:46:47.027: Opened connection at 7/29/2016 10:46:47 AM +05:00
  478. 10:46:47.028: Started transaction at 7/29/2016 10:46:47 AM +05:00
  479. 10:46:47.03: UPDATE [dbo].[Document]
  480. SET [ChronicalDocumentId] = @0
  481. WHERE ([Id] = @1)
  482. 10:46:47.03: -- @0: '2016' (Type = Int32)
  483. 10:46:47.031: -- @1: '2016' (Type = Int32)
  484. 10:46:47.031: -- Executing at 7/29/2016 10:46:47 AM +05:00
  485. 10:46:47.032: -- Completed in 1 ms with result: 1
  486. 10:46:47.033:
  487. 10:46:47.033: Committed transaction at 7/29/2016 10:46:47 AM +05:00
  488. 10:46:47.033: Closed connection at 7/29/2016 10:46:47 AM +05:00
  489. 10:46:47.035: Opened connection at 7/29/2016 10:46:47 AM +05:00
  490. 10:46:47.045: SELECT TOP (2)
  491. [Extent1].[Id] AS [Id],
  492. [Extent1].[Name] AS [Name]
  493. FROM [dbo].[ProcessQueueStatus] AS [Extent1]
  494. WHERE 'New' = [Extent1].[Name]10:46:47.046:
  495. 10:46:47.046: -- Executing at 7/29/2016 10:46:47 AM +05:00
  496. 10:46:47.047: -- Completed in 0 ms with result: SqlDataReader
  497. 10:46:47.047:
  498. 10:46:47.05: Closed connection at 7/29/2016 10:46:47 AM +05:00
  499. 10:46:47.056: Opened connection at 7/29/2016 10:46:47 AM +05:00
  500. 10:46:47.056: Started transaction at 7/29/2016 10:46:47 AM +05:00
  501. 10:46:47.061: INSERT [dbo].[ProcessQueue]([DocumentId], [TemplateId], [ActionTypeId])
  502. VALUES (@0, NULL, @1)
  503. SELECT [Id]
  504. FROM [dbo].[ProcessQueue]
  505. WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.061:
  506. 10:46:47.062: -- @0: '2016' (Type = Int32)
  507. 10:46:47.062: -- @1: '2' (Type = Int32)
  508. 10:46:47.062: -- Executing at 7/29/2016 10:46:47 AM +05:00
  509. 10:46:47.064: -- Completed in 2 ms with result: SqlDataReader
  510. 10:46:47.065:
  511. 10:46:47.065: INSERT [dbo].[ProcessQueueItem]([StatusId], [RoleId], [QueueId], [TaskId], [Sent], [Finished], [Order])
  512. VALUES (@0, @1, @2, NULL, NULL, NULL, @3)
  513. SELECT [Id]
  514. FROM [dbo].[ProcessQueueItem]
  515. WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.066:
  516. 10:46:47.066: -- @0: '1' (Type = Int32)
  517. 10:46:47.066: -- @1: 'e124b068-ff53-e611-80c3-00155d63106c' (Type = Guid)
  518. 10:46:47.066: -- @2: '6052' (Type = Int32)
  519. 10:46:47.066: -- @3: '1' (Type = Int32)
  520. 10:46:47.067: -- Executing at 7/29/2016 10:46:47 AM +05:00
  521. 10:46:47.069: -- Completed in 2 ms with result: SqlDataReader
  522. 10:46:47.069:
  523. 10:46:47.071: Committed transaction at 7/29/2016 10:46:47 AM +05:00
  524. 10:46:47.071: Closed connection at 7/29/2016 10:46:47 AM +05:00
  525. 10:46:47.074: Opened connection at 7/29/2016 10:46:47 AM +05:00
  526. 10:46:47.075: Started transaction at 7/29/2016 10:46:47 AM +05:00
  527. 10:46:47.076: INSERT [dbo].[ProcessQueue]([DocumentId], [TemplateId], [ActionTypeId])
  528. VALUES (@0, NULL, @1)
  529. SELECT [Id]
  530. FROM [dbo].[ProcessQueue]
  531. WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.076:
  532. 10:46:47.076: -- @0: '2016' (Type = Int32)
  533. 10:46:47.076: -- @1: '3' (Type = Int32)
  534. 10:46:47.076: -- Executing at 7/29/2016 10:46:47 AM +05:00
  535. 10:46:47.077: -- Completed in 0 ms with result: SqlDataReader
  536. 10:46:47.077:
  537. 10:46:47.077: INSERT [dbo].[ProcessQueueItem]([StatusId], [RoleId], [QueueId], [TaskId], [Sent], [Finished], [Order])
  538. VALUES (@0, @1, @2, NULL, NULL, NULL, @3)
  539. SELECT [Id]
  540. FROM [dbo].[ProcessQueueItem]
  541. WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.078:
  542. 10:46:47.078: -- @0: '1' (Type = Int32)
  543. 10:46:47.078: -- @1: 'f82b1d7a-0054-e611-80c3-00155d63106c' (Type = Guid)
  544. 10:46:47.078: -- @2: '6053' (Type = Int32)
  545. 10:46:47.078: -- @3: '1' (Type = Int32)
  546. 10:46:47.079: -- Executing at 7/29/2016 10:46:47 AM +05:00
  547. 10:46:47.079: -- Completed in 0 ms with result: SqlDataReader
  548. 10:46:47.079:
  549. 10:46:47.08: Committed transaction at 7/29/2016 10:46:47 AM +05:00
  550. 10:46:47.08: Closed connection at 7/29/2016 10:46:47 AM +05:00
  551. 10:46:47.081: Opened connection at 7/29/2016 10:46:47 AM +05:00
  552. 10:46:47.081: SELECT
  553. [Extent1].[Id] AS [Id],
  554. [Extent1].[Name] AS [Name]
  555. FROM [dbo].[ActionType] AS [Extent1]
  556. WHERE [Extent1].[Id] = @EntityKeyValue110:46:47.081:
  557. 10:46:47.081: -- EntityKeyValue1: '1' (Type = Int32)
  558. 10:46:47.081: -- Executing at 7/29/2016 10:46:47 AM +05:00
  559. 10:46:47.082: -- Completed in 0 ms with result: SqlDataReader
  560. 10:46:47.082:
  561. 10:46:47.082: Closed connection at 7/29/2016 10:46:47 AM +05:00
  562. 10:46:47.083: Opened connection at 7/29/2016 10:46:47 AM +05:00
  563. 10:46:47.083: SELECT
  564. [Extent1].[Id] AS [Id],
  565. [Extent1].[StatusId] AS [StatusId],
  566. [Extent1].[RoleId] AS [RoleId],
  567. [Extent1].[QueueId] AS [QueueId],
  568. [Extent1].[TaskId] AS [TaskId],
  569. [Extent1].[Sent] AS [Sent],
  570. [Extent1].[Finished] AS [Finished],
  571. [Extent1].[Order] AS [Order]
  572. FROM [dbo].[ProcessQueueItem] AS [Extent1]
  573. WHERE [Extent1].[QueueId] = @EntityKeyValue110:46:47.083:
  574. 10:46:47.083: -- EntityKeyValue1: '3' (Type = Int32, IsNullable = false)
  575. 10:46:47.084: -- Executing at 7/29/2016 10:46:47 AM +05:00
  576. 10:46:47.084: -- Completed in 0 ms with result: SqlDataReader
  577. 10:46:47.084:
  578. 10:46:47.085: Closed connection at 7/29/2016 10:46:47 AM +05:00
  579. 10:46:47.087: Opened connection at 7/29/2016 10:46:47 AM +05:00
  580. 10:46:47.088: Started transaction at 7/29/2016 10:46:47 AM +05:00
  581. 10:46:47.089: INSERT [dbo].[ProcessQueue]([DocumentId], [TemplateId], [ActionTypeId])
  582. VALUES (@0, NULL, @1)
  583. SELECT [Id]
  584. FROM [dbo].[ProcessQueue]
  585. WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.089:
  586. 10:46:47.089: -- @0: '2016' (Type = Int32)
  587. 10:46:47.089: -- @1: '1' (Type = Int32)
  588. 10:46:47.089: -- Executing at 7/29/2016 10:46:47 AM +05:00
  589. 10:46:47.09: -- Completed in 0 ms with result: SqlDataReader
  590. 10:46:47.09:
  591. 10:46:47.09: INSERT [dbo].[ProcessQueueItem]([StatusId], [RoleId], [QueueId], [TaskId], [Sent], [Finished], [Order])
  592. VALUES (@0, @1, @2, NULL, NULL, NULL, @3)
  593. SELECT [Id]
  594. FROM [dbo].[ProcessQueueItem]
  595. WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.091:
  596. 10:46:47.091: -- @0: '1' (Type = Int32)
  597. 10:46:47.091: -- @1: 'aa793e06-fd53-e611-80c3-00155d63106c' (Type = Guid)
  598. 10:46:47.091: -- @2: '6054' (Type = Int32)
  599. 10:46:47.091: -- @3: '1' (Type = Int32)
  600. 10:46:47.092: -- Executing at 7/29/2016 10:46:47 AM +05:00
  601. 10:46:47.092: -- Completed in 0 ms with result: SqlDataReader
  602. 10:46:47.092:
  603. 10:46:47.093: Committed transaction at 7/29/2016 10:46:47 AM +05:00
  604. 10:46:47.093: Closed connection at 7/29/2016 10:46:47 AM +05:00
  605. 10:46:47.096: Opened connection at 7/29/2016 10:46:47 AM +05:00
  606. 10:46:47.107: SELECT TOP (1)
  607. [Extent1].[Id] AS [Id],
  608. [Extent1].[Name] AS [Name],
  609. [Extent1].[FirstStage] AS [FirstStage]
  610. FROM [dbo].[BusinessProcess] AS [Extent1]
  611. WHERE [Extent1].[Name] = @p__linq__010:46:47.107:
  612. 10:46:47.107: -- p__linq__0: 'Main' (Type = String, Size = 4000)
  613. 10:46:47.108: -- Executing at 7/29/2016 10:46:47 AM +05:00
  614. 10:46:47.109: -- Completed in 1 ms with result: SqlDataReader
  615. 10:46:47.109:
  616. 10:46:47.112: Closed connection at 7/29/2016 10:46:47 AM +05:00
  617. 10:46:47.116: Opened connection at 7/29/2016 10:46:47 AM +05:00
  618. 10:46:47.117: Started transaction at 7/29/2016 10:46:47 AM +05:00
  619. 10:46:47.117: INSERT [dbo].[Workflow]([Created], [Finished], [BusinessProcessId])
  620. VALUES (@0, NULL, @1)
  621. SELECT [Id]
  622. FROM [dbo].[Workflow]
  623. WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.117:
  624. 10:46:47.118: -- @0: '7/29/2016 10:46:47 AM' (Type = DateTime2)
  625. 10:46:47.118: -- @1: '1' (Type = Int32)
  626. 10:46:47.118: -- Executing at 7/29/2016 10:46:47 AM +05:00
  627. 10:46:47.12: -- Completed in 1 ms with result: SqlDataReader
  628. 10:46:47.12:
  629. 10:46:47.121: Committed transaction at 7/29/2016 10:46:47 AM +05:00
  630. 10:46:47.122: Closed connection at 7/29/2016 10:46:47 AM +05:00
  631. 10:46:47.123: Opened connection at 7/29/2016 10:46:47 AM +05:00
  632. 10:46:47.124: SELECT TOP (1)
  633. [Extent1].[Id] AS [Id],
  634. [Extent1].[Name] AS [Name],
  635. [Extent1].[ActionTypeId] AS [ActionTypeId],
  636. [Extent1].[BusinessProcessId] AS [BusinessProcessId],
  637. [Extent1].[DocumentStatusId] AS [DocumentStatusId]
  638. FROM [dbo].[Stage] AS [Extent1]
  639. WHERE [Extent1].[Id] = @p__linq__010:46:47.124:
  640. 10:46:47.124: -- p__linq__0: '1' (Type = Int32)
  641. 10:46:47.125: -- Executing at 7/29/2016 10:46:47 AM +05:00
  642. 10:46:47.126: -- Completed in 0 ms with result: SqlDataReader
  643. 10:46:47.126:
  644. 10:46:47.126: Closed connection at 7/29/2016 10:46:47 AM +05:00
  645. 10:46:47.127: Opened connection at 7/29/2016 10:46:47 AM +05:00
  646. 10:46:47.127: SELECT TOP (1)
  647. [Extent1].[ID] AS [ID],
  648. [Extent1].[ID_aspnet_Users] AS [ID_aspnet_Users],
  649. [Extent1].[FirstName] AS [FirstName],
  650. [Extent1].[LastName] AS [LastName],
  651. [Extent1].[Active] AS [Active]
  652. FROM [dbo].[User] AS [Extent1]
  653. LEFT OUTER JOIN [dbo].[aspnet_Users] AS [Extent2] ON [Extent1].[ID_aspnet_Users] = [Extent2].[UserId]
  654. WHERE ([Extent2].[UserName] = @p__linq__0) OR (([Extent2].[UserName] IS NULL) AND (@p__linq__0 IS NULL))10:46:47.127:
  655. 10:46:47.127: -- p__linq__0: 'admin' (Type = String, Size = 4000)
  656. 10:46:47.128: -- Executing at 7/29/2016 10:46:47 AM +05:00
  657. 10:46:47.128: -- Completed in 0 ms with result: SqlDataReader
  658. 10:46:47.128:
  659. 10:46:47.129: Closed connection at 7/29/2016 10:46:47 AM +05:00
  660. 10:46:47.13: Opened connection at 7/29/2016 10:46:47 AM +05:00
  661. 10:46:47.13: SELECT TOP (2)
  662. [Extent1].[Id] AS [Id],
  663. [Extent1].[Name] AS [Name]
  664. FROM [dbo].[ProcessQueueStatus] AS [Extent1]
  665. WHERE 'New' = [Extent1].[Name]10:46:47.131:
  666. 10:46:47.131: -- Executing at 7/29/2016 10:46:47 AM +05:00
  667. 10:46:47.131: -- Completed in 0 ms with result: SqlDataReader
  668. 10:46:47.131:
  669. 10:46:47.132: Closed connection at 7/29/2016 10:46:47 AM +05:00
  670. 10:46:47.136: Opened connection at 7/29/2016 10:46:47 AM +05:00
  671. 10:46:47.137: Started transaction at 7/29/2016 10:46:47 AM +05:00
  672. 10:46:47.139: UPDATE [dbo].[Document]
  673. SET [IsCurrentVersion] = @0
  674. WHERE ([Id] = @1)
  675. 10:46:47.139: -- @0: 'False' (Type = Boolean)
  676. 10:46:47.14: -- @1: '2016' (Type = Int32)
  677. 10:46:47.14: -- Executing at 7/29/2016 10:46:47 AM +05:00
  678. 10:46:47.141: -- Completed in 1 ms with result: 1
  679. 10:46:47.142:
  680. 10:46:47.142: INSERT [dbo].[Document]([Name], [VersionNumber], [FileName], [Data], [PeriodTypeId], [Created], [IsCurrentVersion], [ChronicalDocumentId], [DocumentStatusId], [SourceSystemId], [DocumentTemplateId], [AuthorId], [SubmissionDate], [LastUserId], [LastUserComment], [PositionDate], [SubmissionDeadline])
  681. VALUES (@0, @1, @2, NULL, NULL, @3, @4, @5, @6, @7, @8, @9, NULL, NULL, NULL, @10, NULL)
  682. SELECT [Id]
  683. FROM [dbo].[Document]
  684. WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.142:
  685. 10:46:47.142: -- @0: '10:46 AM_0' (Type = String, Size = 256)
  686. 10:46:47.143: -- @1: '2.0' (Type = String, Size = 64)
  687. 10:46:47.143: -- @2: 'test.bin' (Type = String, Size = 256)
  688. 10:46:47.143: -- @3: '7/29/2016 10:46:47 AM' (Type = DateTime2)
  689. 10:46:47.143: -- @4: 'True' (Type = Boolean)
  690. 10:46:47.143: -- @5: '2016' (Type = Int32)
  691. 10:46:47.144: -- @6: '6' (Type = Int32)
  692. 10:46:47.144: -- @7: '1' (Type = Int32)
  693. 10:46:47.145: -- @8: '2' (Type = Int32)
  694. 10:46:47.145: -- @9: 'd2350d7b-bfa5-4b2a-9f08-5cae6a094a9e' (Type = Guid)
  695. 10:46:47.145: -- @10: '1/1/0001 12:00:00 AM' (Type = DateTime2)
  696. 10:46:47.145: -- Executing at 7/29/2016 10:46:47 AM +05:00
  697. 10:46:47.148: -- Completed in 2 ms with result: SqlDataReader
  698. 10:46:47.148:
  699. 10:46:47.149: INSERT [dbo].[ProcessQueue]([DocumentId], [TemplateId], [ActionTypeId])
  700. VALUES (@0, NULL, @1)
  701. SELECT [Id]
  702. FROM [dbo].[ProcessQueue]
  703. WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.149:
  704. 10:46:47.149: -- @0: '2017' (Type = Int32)
  705. 10:46:47.149: -- @1: '2' (Type = Int32)
  706. 10:46:47.15: -- Executing at 7/29/2016 10:46:47 AM +05:00
  707. 10:46:47.15: -- Completed in 0 ms with result: SqlDataReader
  708. 10:46:47.15:
  709. 10:46:47.151: INSERT [dbo].[ProcessQueue]([DocumentId], [TemplateId], [ActionTypeId])
  710. VALUES (@0, NULL, @1)
  711. SELECT [Id]
  712. FROM [dbo].[ProcessQueue]
  713. WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.151:
  714. 10:46:47.151: -- @0: '2017' (Type = Int32)
  715. 10:46:47.151: -- @1: '3' (Type = Int32)
  716. 10:46:47.151: -- Executing at 7/29/2016 10:46:47 AM +05:00
  717. 10:46:47.152: -- Completed in 0 ms with result: SqlDataReader
  718. 10:46:47.152:
  719. 10:46:47.152: INSERT [dbo].[ProcessQueue]([DocumentId], [TemplateId], [ActionTypeId])
  720. VALUES (@0, NULL, @1)
  721. SELECT [Id]
  722. FROM [dbo].[ProcessQueue]
  723. WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.152:
  724. 10:46:47.153: -- @0: '2017' (Type = Int32)
  725. 10:46:47.153: -- @1: '1' (Type = Int32)
  726. 10:46:47.153: -- Executing at 7/29/2016 10:46:47 AM +05:00
  727. 10:46:47.154: -- Completed in 0 ms with result: SqlDataReader
  728. 10:46:47.154:
  729. 10:46:47.154: INSERT [dbo].[ProcessQueueItem]([StatusId], [RoleId], [QueueId], [TaskId], [Sent], [Finished], [Order])
  730. VALUES (@0, @1, @2, NULL, NULL, NULL, @3)
  731. SELECT [Id]
  732. FROM [dbo].[ProcessQueueItem]
  733. WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.154:
  734. 10:46:47.155: -- @0: '1' (Type = Int32)
  735. 10:46:47.155: -- @1: 'e124b068-ff53-e611-80c3-00155d63106c' (Type = Guid)
  736. 10:46:47.155: -- @2: '6055' (Type = Int32)
  737. 10:46:47.155: -- @3: '1' (Type = Int32)
  738. 10:46:47.155: -- Executing at 7/29/2016 10:46:47 AM +05:00
  739. 10:46:47.156: -- Completed in 0 ms with result: SqlDataReader
  740. 10:46:47.156:
  741. 10:46:47.156: INSERT [dbo].[ProcessQueueItem]([StatusId], [RoleId], [QueueId], [TaskId], [Sent], [Finished], [Order])
  742. VALUES (@0, @1, @2, NULL, NULL, NULL, @3)
  743. SELECT [Id]
  744. FROM [dbo].[ProcessQueueItem]
  745. WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.157:
  746. 10:46:47.157: -- @0: '1' (Type = Int32)
  747. 10:46:47.157: -- @1: 'f82b1d7a-0054-e611-80c3-00155d63106c' (Type = Guid)
  748. 10:46:47.157: -- @2: '6056' (Type = Int32)
  749. 10:46:47.157: -- @3: '1' (Type = Int32)
  750. 10:46:47.158: -- Executing at 7/29/2016 10:46:47 AM +05:00
  751. 10:46:47.158: -- Completed in 0 ms with result: SqlDataReader
  752. 10:46:47.158:
  753. 10:46:47.159: INSERT [dbo].[ProcessQueueItem]([StatusId], [RoleId], [QueueId], [TaskId], [Sent], [Finished], [Order])
  754. VALUES (@0, @1, @2, NULL, NULL, NULL, @3)
  755. SELECT [Id]
  756. FROM [dbo].[ProcessQueueItem]
  757. WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.159:
  758. 10:46:47.159: -- @0: '1' (Type = Int32)
  759. 10:46:47.159: -- @1: 'aa793e06-fd53-e611-80c3-00155d63106c' (Type = Guid)
  760. 10:46:47.159: -- @2: '6057' (Type = Int32)
  761. 10:46:47.16: -- @3: '1' (Type = Int32)
  762. 10:46:47.16: -- Executing at 7/29/2016 10:46:47 AM +05:00
  763. 10:46:47.16: -- Completed in 0 ms with result: SqlDataReader
  764. 10:46:47.16:
  765. 10:46:47.16: Committed transaction at 7/29/2016 10:46:47 AM +05:00
  766. 10:46:47.161: Closed connection at 7/29/2016 10:46:47 AM +05:00
  767. 10:46:47.163: Opened connection at 7/29/2016 10:46:47 AM +05:00
  768. 10:46:47.164: SELECT
  769. [Extent1].[ID] AS [ID],
  770. [Extent1].[Name] AS [Name],
  771. [Extent1].[SourceSystemId] AS [SourceSystemId],
  772. [Extent1].[ID_ActionType] AS [ID_ActionType],
  773. [Extent1].[ID_Group] AS [ID_Group]
  774. FROM [dbo].[AccessRight] AS [Extent1]10:46:47.164:
  775. 10:46:47.164: -- Executing at 7/29/2016 10:46:47 AM +05:00
  776. 10:46:47.164: -- Completed in 0 ms with result: SqlDataReader
  777. 10:46:47.165:
  778. 10:46:47.165: Closed connection at 7/29/2016 10:46:47 AM +05:00
  779. 10:46:47.165: Opened connection at 7/29/2016 10:46:47 AM +05:00
  780. 10:46:47.166: SELECT TOP (2)
  781. [Extent1].[Id] AS [Id],
  782. [Extent1].[Name] AS [Name]
  783. FROM [dbo].[ProcessQueueStatus] AS [Extent1]
  784. WHERE 'New' = [Extent1].[Name]10:46:47.166:
  785. 10:46:47.166: -- Executing at 7/29/2016 10:46:47 AM +05:00
  786. 10:46:47.166: -- Completed in 0 ms with result: SqlDataReader
  787. 10:46:47.167:
  788. 10:46:47.167: Closed connection at 7/29/2016 10:46:47 AM +05:00
  789. 10:46:47.167: Opened connection at 7/29/2016 10:46:47 AM +05:00
  790. 10:46:47.168: SELECT
  791. [Extent1].[ID] AS [ID],
  792. [Extent1].[Name] AS [Name],
  793. [Extent1].[SourceSystemId] AS [SourceSystemId],
  794. [Extent1].[ID_ActionType] AS [ID_ActionType],
  795. [Extent1].[ID_Group] AS [ID_Group]
  796. FROM [dbo].[AccessRight] AS [Extent1]10:46:47.168:
  797. 10:46:47.168: -- Executing at 7/29/2016 10:46:47 AM +05:00
  798. 10:46:47.168: -- Completed in 0 ms with result: SqlDataReader
  799. 10:46:47.169:
  800. 10:46:47.169: Closed connection at 7/29/2016 10:46:47 AM +05:00
  801. 10:46:47.173: Opened connection at 7/29/2016 10:46:47 AM +05:00
  802. 10:46:47.174: SELECT TOP (2)
  803. [Extent1].[Id] AS [Id],
  804. [Extent1].[Name] AS [Name]
  805. FROM [dbo].[ProcessQueueStatus] AS [Extent1]
  806. WHERE 'New' = [Extent1].[Name]10:46:47.174:
  807. 10:46:47.174: -- Executing at 7/29/2016 10:46:47 AM +05:00
  808. 10:46:47.174: -- Completed in 0 ms with result: SqlDataReader
  809. 10:46:47.175:
  810. 10:46:47.175: Closed connection at 7/29/2016 10:46:47 AM +05:00
  811. 10:46:47.175: Opened connection at 7/29/2016 10:46:47 AM +05:00
  812. 10:46:47.176: SELECT TOP (2)
  813. [Extent1].[Id] AS [Id],
  814. [Extent1].[Name] AS [Name]
  815. FROM [dbo].[ProcessQueueStatus] AS [Extent1]
  816. WHERE 'Sent' = [Extent1].[Name]10:46:47.177:
  817. 10:46:47.177: -- Executing at 7/29/2016 10:46:47 AM +05:00
  818. 10:46:47.178: -- Completed in 0 ms with result: SqlDataReader
  819. 10:46:47.178:
  820. 10:46:47.179: Closed connection at 7/29/2016 10:46:47 AM +05:00
  821. 10:46:47.18: Opened connection at 7/29/2016 10:46:47 AM +05:00
  822. 10:46:47.181: SELECT TOP (2)
  823. [Extent1].[Id] AS [Id],
  824. [Extent1].[Name] AS [Name]
  825. FROM [dbo].[ProcessQueueStatus] AS [Extent1]
  826. WHERE 'New' = [Extent1].[Name]10:46:47.181:
  827. 10:46:47.181: -- Executing at 7/29/2016 10:46:47 AM +05:00
  828. 10:46:47.182: -- Completed in 0 ms with result: SqlDataReader
  829. 10:46:47.182:
  830. 10:46:47.182: Closed connection at 7/29/2016 10:46:47 AM +05:00
  831. 10:46:47.189: Opened connection at 7/29/2016 10:46:47 AM +05:00
  832. 10:46:47.19: Started transaction at 7/29/2016 10:46:47 AM +05:00
  833. 10:46:47.191: UPDATE [dbo].[ProcessQueueItem]
  834. SET [StatusId] = @0, [Sent] = @1
  835. WHERE ([Id] = @2)
  836. 10:46:47.191: -- @0: '2' (Type = Int32)
  837. 10:46:47.191: -- @1: '7/29/2016 10:46:47 AM' (Type = DateTime2)
  838. 10:46:47.191: -- @2: '6005' (Type = Int32)
  839. 10:46:47.192: -- Executing at 7/29/2016 10:46:47 AM +05:00
  840. 10:46:47.194: -- Completed in 1 ms with result: 1
  841. 10:46:47.194:
  842. 10:46:47.194: Committed transaction at 7/29/2016 10:46:47 AM +05:00
  843. 10:46:47.195: Closed connection at 7/29/2016 10:46:47 AM +05:00
  844. 10:46:47.196: Opened connection at 7/29/2016 10:46:47 AM +05:00
  845. 10:46:47.198: SELECT
  846. [Extent2].[UserId] AS [UserId],
  847. [Extent2].[ApplicationId] AS [ApplicationId],
  848. [Extent2].[UserName] AS [UserName],
  849. [Extent2].[LoweredUserName] AS [LoweredUserName],
  850. [Extent2].[MobileAlias] AS [MobileAlias],
  851. [Extent2].[IsAnonymous] AS [IsAnonymous],
  852. [Extent2].[LastActivityDate] AS [LastActivityDate]
  853. FROM [dbo].[aspnet_UsersInRoles] AS [Extent1]
  854. INNER JOIN [dbo].[aspnet_Users] AS [Extent2] ON [Extent1].[UserId] = [Extent2].[UserId]
  855. WHERE [Extent1].[RoleId] = @EntityKeyValue110:46:47.198:
  856. 10:46:47.199: -- EntityKeyValue1: 'aa793e06-fd53-e611-80c3-00155d63106c' (Type = Guid, IsNullable = false)
  857. 10:46:47.199: -- Executing at 7/29/2016 10:46:47 AM +05:00
  858. 10:46:47.203: -- Completed in 3 ms with result: SqlDataReader
  859. 10:46:47.203:
  860. 10:46:47.205: Closed connection at 7/29/2016 10:46:47 AM +05:00
  861. 10:46:47.206: Opened connection at 7/29/2016 10:46:47 AM +05:00
  862. 10:46:47.216: SELECT TOP (2)
  863. [Extent1].[Id] AS [Id],
  864. [Extent1].[Name] AS [Name]
  865. FROM [dbo].[TaskStatus] AS [Extent1]
  866. WHERE N'New' = [Extent1].[Name]10:46:47.217:
  867. 10:46:47.217: -- Executing at 7/29/2016 10:46:47 AM +05:00
  868. 10:46:47.218: -- Completed in 1 ms with result: SqlDataReader
  869. 10:46:47.219:
  870. 10:46:47.22: Closed connection at 7/29/2016 10:46:47 AM +05:00
  871. 10:46:47.225: Opened connection at 7/29/2016 10:46:47 AM +05:00
  872. 10:46:47.225: Started transaction at 7/29/2016 10:46:47 AM +05:00
  873. 10:46:47.226: INSERT [dbo].[TaskPerformer]([RoleId], [UserId])
  874. VALUES (NULL, @0)
  875. SELECT [Id]
  876. FROM [dbo].[TaskPerformer]
  877. WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.226:
  878. 10:46:47.226: -- @0: 'bbd89cbf-7995-4448-92b8-adaf29b268fd' (Type = Guid)
  879. 10:46:47.227: -- Executing at 7/29/2016 10:46:47 AM +05:00
  880. 10:46:47.229: -- Completed in 1 ms with result: SqlDataReader
  881. 10:46:47.229:
  882. 10:46:47.23: Committed transaction at 7/29/2016 10:46:47 AM +05:00
  883. 10:46:47.23: Closed connection at 7/29/2016 10:46:47 AM +05:00
  884. 10:46:47.238: Opened connection at 7/29/2016 10:46:47 AM +05:00
  885. 10:46:47.239: Started transaction at 7/29/2016 10:46:47 AM +05:00
  886. 10:46:47.24: INSERT [dbo].[Task]([DocumentId], [StatusId], [Created], [Started], [Finished], [WorkflowId], [StageId], [TaskPerformerId], [Comment])
  887. VALUES (@0, @1, @2, NULL, NULL, @3, @4, @5, NULL)
  888. SELECT [Id]
  889. FROM [dbo].[Task]
  890. WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()10:46:47.24:
  891. 10:46:47.24: -- @0: '2016' (Type = Int32)
  892. 10:46:47.24: -- @1: '1' (Type = Int32)
  893. 10:46:47.241: -- @2: '7/29/2016 10:46:47 AM' (Type = DateTime2)
  894. 10:46:47.241: -- @3: '973' (Type = Int32)
  895. 10:46:47.241: -- @4: '1' (Type = Int32)
  896. 10:46:47.241: -- @5: '968' (Type = Int32)
  897. 10:46:47.242: -- Executing at 7/29/2016 10:46:47 AM +05:00
  898. 10:46:47.245: -- Completed in 2 ms with result: SqlDataReader
  899. 10:46:47.245:
  900. 10:46:47.246: Committed transaction at 7/29/2016 10:46:47 AM +05:00
  901. 10:46:47.247: Closed connection at 7/29/2016 10:46:47 AM +05:00
  902. 10:46:47.249: Opened connection at 7/29/2016 10:46:47 AM +05:00
  903. 10:46:47.25: SELECT TOP (1)
  904. [Extent1].[RoleId] AS [RoleId],
  905. [Extent1].[ApplicationId] AS [ApplicationId],
  906. [Extent1].[RoleName] AS [RoleName],
  907. [Extent1].[LoweredRoleName] AS [LoweredRoleName],
  908. [Extent1].[Description] AS [Description]
  909. FROM [dbo].[aspnet_Roles] AS [Extent1]
  910. WHERE [Extent1].[RoleId] = @p__linq__010:46:47.25:
  911. 10:46:47.25: -- p__linq__0: 'aa793e06-fd53-e611-80c3-00155d63106c' (Type = Guid, IsNullable = false)
  912. 10:46:47.251: -- Executing at 7/29/2016 10:46:47 AM +05:00
  913. 10:46:47.252: -- Completed in 1 ms with result: SqlDataReader
  914. 10:46:47.252:
  915. 10:46:47.253: Closed connection at 7/29/2016 10:46:47 AM +05:00
  916. 10:46:47.255: Opened connection at 7/29/2016 10:46:47 AM +05:00
  917. 10:46:47.265: SELECT TOP (2)
  918. [Extent1].[ID] AS [ID],
  919. [Extent1].[Name] AS [Name]
  920. FROM [dbo].[AuditAction] AS [Extent1]
  921. WHERE [Extent1].[ID] = @p__linq__010:46:47.265:
  922. 10:46:47.265: -- p__linq__0: '2' (Type = Int32, IsNullable = false)
  923. 10:46:47.266: -- Executing at 7/29/2016 10:46:47 AM +05:00
  924. 10:46:47.267: -- Completed in 0 ms with result: SqlDataReader
  925. 10:46:47.267:
  926. 10:46:47.269: Closed connection at 7/29/2016 10:46:47 AM +05:00
  927. 10:46:47.275: Opened connection at 7/29/2016 10:46:47 AM +05:00
  928. 10:46:47.276: Started transaction at 7/29/2016 10:46:47 AM +05:00
  929. 10:46:47.277: UPDATE [dbo].[Task]
  930. SET [DocumentId] = @0
  931. WHERE ([Id] = @1)
  932. 10:46:47.277: -- @0: '2016' (Type = Int32)
  933. 10:46:47.277: -- @1: '968' (Type = Int32)
  934. 10:46:47.278: -- Executing at 7/29/2016 10:46:47 AM +05:00
  935. 10:46:47.28: -- Completed in 1 ms with result: 1
  936. 10:46:47.28:
  937. 10:46:47.28: INSERT [dbo].[AuditTrail]([When], [UserId], [AuditActionId], [DocumentId], [TaskId])
  938. VALUES (@0, @1, @2, @3, @4)
  939. SELECT [ID]
  940. FROM [dbo].[AuditTrail]
  941. WHERE @@ROWCOUNT > 0 AND [ID] = scope_identity()10:46:47.28:
  942. 10:46:47.281: -- @0: '7/29/2016 10:46:47 AM' (Type = DateTime2)
  943. 10:46:47.281: -- @1: 'bbd89cbf-7995-4448-92b8-adaf29b268fd' (Type = Guid)
  944. 10:46:47.281: -- @2: '2' (Type = Int32)
  945. 10:46:47.281: -- @3: '2016' (Type = Int32)
  946. 10:46:47.281: -- @4: '968' (Type = Int32)
  947. 10:46:47.282: -- Executing at 7/29/2016 10:46:47 AM +05:00
  948. 10:46:47.285: -- Completed in 2 ms with result: SqlDataReader
  949. 10:46:47.285:
  950. 10:46:47.286: Committed transaction at 7/29/2016 10:46:47 AM +05:00
  951. 10:46:47.286: Closed connection at 7/29/2016 10:46:47 AM +05:00
  952. 10:46:47.287: Opened connection at 7/29/2016 10:46:47 AM +05:00
  953. 10:46:47.287: SELECT TOP (2)
  954. [Extent1].[ID] AS [ID],
  955. [Extent1].[Name] AS [Name]
  956. FROM [dbo].[AuditAction] AS [Extent1]
  957. WHERE [Extent1].[ID] = @p__linq__010:46:47.287:
  958. 10:46:47.288: -- p__linq__0: '2' (Type = Int32, IsNullable = false)
  959. 10:46:47.288: -- Executing at 7/29/2016 10:46:47 AM +05:00
  960. 10:46:47.288: -- Completed in 0 ms with result: SqlDataReader
  961. 10:46:47.289:
  962. 10:46:47.289: Closed connection at 7/29/2016 10:46:47 AM +05:00
  963. 10:46:47.293: Opened connection at 7/29/2016 10:46:47 AM +05:00
  964. 10:46:47.293: Started transaction at 7/29/2016 10:46:47 AM +05:00
  965. 10:46:47.294: UPDATE [dbo].[Task]
  966. SET [DocumentId] = @0
  967. WHERE ([Id] = @1)
  968. 10:46:47.294: -- @0: '2016' (Type = Int32)
  969. 10:46:47.295: -- @1: '968' (Type = Int32)
  970. 10:46:47.295: -- Executing at 7/29/2016 10:46:47 AM +05:00
  971. 10:46:47.295: -- Completed in 0 ms with result: 1
  972. 10:46:47.295:
  973. 10:46:47.296: INSERT [dbo].[AuditTrail]([When], [UserId], [AuditActionId], [DocumentId], [TaskId])
  974. VALUES (@0, @1, @2, @3, @4)
  975. SELECT [ID]
  976. FROM [dbo].[AuditTrail]
  977. WHERE @@ROWCOUNT > 0 AND [ID] = scope_identity()10:46:47.296:
  978. 10:46:47.296: -- @0: '7/29/2016 10:46:47 AM' (Type = DateTime2)
  979. 10:46:47.296: -- @1: '85fec6aa-3ce7-420c-b990-c7639c06ca33' (Type = Guid)
  980. 10:46:47.296: -- @2: '2' (Type = Int32)
  981. 10:46:47.297: -- @3: '2016' (Type = Int32)
  982. 10:46:47.297: -- @4: '968' (Type = Int32)
  983. 10:46:47.297: -- Executing at 7/29/2016 10:46:47 AM +05:00
  984. 10:46:47.298: -- Completed in 0 ms with result: SqlDataReader
  985. 10:46:47.298:
  986. 10:46:47.298: Committed transaction at 7/29/2016 10:46:47 AM +05:00
  987. 10:46:47.298: Closed connection at 7/29/2016 10:46:47 AM +05:00
  988. 10:46:47.299: Opened connection at 7/29/2016 10:46:47 AM +05:00
  989. 10:46:47.3: SELECT
  990. [Extent1].[Id] AS [Id],
  991. [Extent1].[Name] AS [Name]
  992. FROM [dbo].[DocumentStatus] AS [Extent1]
  993. WHERE [Extent1].[Id] = @EntityKeyValue110:46:47.301:
  994. 10:46:47.301: -- EntityKeyValue1: '1' (Type = Int32)
  995. 10:46:47.301: -- Executing at 7/29/2016 10:46:47 AM +05:00
  996. 10:46:47.302: -- Completed in 1 ms with result: SqlDataReader
  997. 10:46:47.302:
  998. 10:46:47.303: Closed connection at 7/29/2016 10:46:47 AM +05:00
  999. 10:46:47.305: Opened connection at 7/29/2016 10:46:47 AM +05:00
  1000. 10:46:47.305: SELECT TOP (1)
  1001. [Extent1].[RoleId] AS [RoleId],
  1002. [Extent1].[ApplicationId] AS [ApplicationId],
  1003. [Extent1].[RoleName] AS [RoleName],
  1004. [Extent1].[LoweredRoleName] AS [LoweredRoleName],
  1005. [Extent1].[Description] AS [Description]
  1006. FROM [dbo].[aspnet_Roles] AS [Extent1]
  1007. WHERE [Extent1].[RoleId] = @p__linq__010:46:47.306:
  1008. 10:46:47.306: -- p__linq__0: 'aa793e06-fd53-e611-80c3-00155d63106c' (Type = Guid, IsNullable = false)
  1009. 10:46:47.306: -- Executing at 7/29/2016 10:46:47 AM +05:00
  1010. 10:46:47.306: -- Completed in 0 ms with result: SqlDataReader
  1011. 10:46:47.307:
  1012. 10:46:47.307: Closed connection at 7/29/2016 10:46:47 AM +05:00
  1013. 10:46:47.308: Opened connection at 7/29/2016 10:46:47 AM +05:00
  1014. 10:46:47.31: SELECT TOP (2)
  1015. [Extent1].[ID] AS [ID],
  1016. [Extent1].[ID_aspnet_Users] AS [ID_aspnet_Users],
  1017. [Extent1].[FirstName] AS [FirstName],
  1018. [Extent1].[LastName] AS [LastName],
  1019. [Extent1].[Active] AS [Active]
  1020. FROM [dbo].[User] AS [Extent1]
  1021. WHERE [Extent1].[ID_aspnet_Users] = @p__linq__010:46:47.31:
  1022. 10:46:47.31: -- p__linq__0: 'bbd89cbf-7995-4448-92b8-adaf29b268fd' (Type = Guid, IsNullable = false)
  1023. 10:46:47.311: -- Executing at 7/29/2016 10:46:47 AM +05:00
  1024. 10:46:47.312: -- Completed in 1 ms with result: SqlDataReader
  1025. 10:46:47.312:
  1026. 10:46:47.313: Closed connection at 7/29/2016 10:46:47 AM +05:00
  1027. 10:46:47.314: Opened connection at 7/29/2016 10:46:47 AM +05:00
  1028. 10:46:47.332: SELECT
  1029. [Extent1].[UserId] AS [UserId],
  1030. [Extent1].[ApplicationId] AS [ApplicationId],
  1031. [Extent1].[Password] AS [Password],
  1032. [Extent1].[PasswordFormat] AS [PasswordFormat],
  1033. [Extent1].[PasswordSalt] AS [PasswordSalt],
  1034. [Extent1].[MobilePIN] AS [MobilePIN],
  1035. [Extent1].[Email] AS [Email],
  1036. [Extent1].[LoweredEmail] AS [LoweredEmail],
  1037. [Extent1].[PasswordQuestion] AS [PasswordQuestion],
  1038. [Extent1].[PasswordAnswer] AS [PasswordAnswer],
  1039. [Extent1].[IsApproved] AS [IsApproved],
  1040. [Extent1].[IsLockedOut] AS [IsLockedOut],
  1041. [Extent1].[CreateDate] AS [CreateDate],
  1042. [Extent1].[LastLoginDate] AS [LastLoginDate],
  1043. [Extent1].[LastPasswordChangedDate] AS [LastPasswordChangedDate],
  1044. [Extent1].[LastLockoutDate] AS [LastLockoutDate],
  1045. [Extent1].[FailedPasswordAttemptCount] AS [FailedPasswordAttemptCount],
  1046. [Extent1].[FailedPasswordAttemptWindowStart] AS [FailedPasswordAttemptWindowStart],
  1047. [Extent1].[FailedPasswordAnswerAttemptCount] AS [FailedPasswordAnswerAttemptCount],
  1048. [Extent1].[FailedPasswordAnswerAttemptWindowStart] AS [FailedPasswordAnswerAttemptWindowStart],
  1049. [Extent1].[Comment] AS [Comment]
  1050. FROM [dbo].[aspnet_Membership] AS [Extent1]
  1051. WHERE [Extent1].[UserId] = @EntityKeyValue110:46:47.332:
  1052. 10:46:47.332: -- EntityKeyValue1: 'bbd89cbf-7995-4448-92b8-adaf29b268fd' (Type = Guid, IsNullable = false)
  1053. 10:46:47.332: -- Executing at 7/29/2016 10:46:47 AM +05:00
  1054. 10:46:47.334: -- Completed in 1 ms with result: SqlDataReader
  1055. 10:46:47.335:
  1056. 10:46:47.343: Closed connection at 7/29/2016 10:46:47 AM +05:00
  1057. Exception thrown: 'System.NullReferenceException' in Core.dll
  1058. 10:46:47.377: Opened connection at 7/29/2016 10:46:47 AM +05:00
  1059. 10:46:47.377: SELECT TOP (2)
  1060. [Extent1].[ID] AS [ID],
  1061. [Extent1].[ID_aspnet_Users] AS [ID_aspnet_Users],
  1062. [Extent1].[FirstName] AS [FirstName],
  1063. [Extent1].[LastName] AS [LastName],
  1064. [Extent1].[Active] AS [Active]
  1065. FROM [dbo].[User] AS [Extent1]
  1066. WHERE [Extent1].[ID_aspnet_Users] = @p__linq__010:46:47.378:
  1067. 10:46:47.378: -- p__linq__0: '85fec6aa-3ce7-420c-b990-c7639c06ca33' (Type = Guid, IsNullable = false)
  1068. 10:46:47.378: -- Executing at 7/29/2016 10:46:47 AM +05:00
  1069. 10:46:47.379: -- Completed in 0 ms with result: SqlDataReader
  1070. 10:46:47.379:
  1071. 10:46:47.379: Closed connection at 7/29/2016 10:46:47 AM +05:00
  1072. 10:46:47.38: Opened connection at 7/29/2016 10:46:47 AM +05:00
  1073. 10:46:47.38: SELECT
  1074. [Extent1].[UserId] AS [UserId],
  1075. [Extent1].[ApplicationId] AS [ApplicationId],
  1076. [Extent1].[Password] AS [Password],
  1077. [Extent1].[PasswordFormat] AS [PasswordFormat],
  1078. [Extent1].[PasswordSalt] AS [PasswordSalt],
  1079. [Extent1].[MobilePIN] AS [MobilePIN],
  1080. [Extent1].[Email] AS [Email],
  1081. [Extent1].[LoweredEmail] AS [LoweredEmail],
  1082. [Extent1].[PasswordQuestion] AS [PasswordQuestion],
  1083. [Extent1].[PasswordAnswer] AS [PasswordAnswer],
  1084. [Extent1].[IsApproved] AS [IsApproved],
  1085. [Extent1].[IsLockedOut] AS [IsLockedOut],
  1086. [Extent1].[CreateDate] AS [CreateDate],
  1087. [Extent1].[LastLoginDate] AS [LastLoginDate],
  1088. [Extent1].[LastPasswordChangedDate] AS [LastPasswordChangedDate],
  1089. [Extent1].[LastLockoutDate] AS [LastLockoutDate],
  1090. [Extent1].[FailedPasswordAttemptCount] AS [FailedPasswordAttemptCount],
  1091. [Extent1].[FailedPasswordAttemptWindowStart] AS [FailedPasswordAttemptWindowStart],
  1092. [Extent1].[FailedPasswordAnswerAttemptCount] AS [FailedPasswordAnswerAttemptCount],
  1093. [Extent1].[FailedPasswordAnswerAttemptWindowStart] AS [FailedPasswordAnswerAttemptWindowStart],
  1094. [Extent1].[Comment] AS [Comment]
  1095. FROM [dbo].[aspnet_Membership] AS [Extent1]
  1096. WHERE [Extent1].[UserId] = @EntityKeyValue110:46:47.38:
  1097. 10:46:47.38: -- EntityKeyValue1: '85fec6aa-3ce7-420c-b990-c7639c06ca33' (Type = Guid, IsNullable = false)
  1098. 10:46:47.38: -- Executing at 7/29/2016 10:46:47 AM +05:00
  1099. 10:46:47.381: -- Completed in 0 ms with result: SqlDataReader
  1100. 10:46:47.381:
  1101. 10:46:47.381: Closed connection at 7/29/2016 10:46:47 AM +05:00
  1102. Exception thrown: 'System.NullReferenceException' in Core.dll
  1103. 10:46:47.399: Opened connection at 7/29/2016 10:46:47 AM +05:00
  1104. 10:46:47.399: SELECT TOP (1)
  1105. [Extent1].[Id] AS [Id],
  1106. [Extent1].[Name] AS [Name],
  1107. [Extent1].[Value] AS [Value],
  1108. [Extent1].[LongValue] AS [LongValue]
  1109. FROM [dbo].[Setting] AS [Extent1]
  1110. WHERE N'NotificationEmail' = [Extent1].[Name]10:46:47.4:
  1111. 10:46:47.4: -- Executing at 7/29/2016 10:46:47 AM +05:00
  1112. 10:46:47.401: -- Completed in 0 ms with result: SqlDataReader
  1113. 10:46:47.401:
  1114. 10:46:47.402: Closed connection at 7/29/2016 10:46:47 AM +05:00
  1115. 10:46:47.403: Opened connection at 7/29/2016 10:46:47 AM +05:00
  1116. 10:46:47.404: SELECT TOP (1)
  1117. [Extent1].[Id] AS [Id],
  1118. [Extent1].[Name] AS [Name],
  1119. [Extent1].[Value] AS [Value],
  1120. [Extent1].[LongValue] AS [LongValue]
  1121. FROM [dbo].[Setting] AS [Extent1]
  1122. WHERE N'SmtpServer' = [Extent1].[Name]10:46:47.406:
  1123. 10:46:47.407: -- Executing at 7/29/2016 10:46:47 AM +05:00
  1124. 10:46:47.407: -- Completed in 0 ms with result: SqlDataReader
  1125. 10:46:47.408:
  1126. 10:46:47.408: Closed connection at 7/29/2016 10:46:47 AM +05:00
  1127. 10:46:47.408: Opened connection at 7/29/2016 10:46:47 AM +05:00
  1128. 10:46:47.409: SELECT TOP (1)
  1129. [Extent1].[Id] AS [Id],
  1130. [Extent1].[Name] AS [Name],
  1131. [Extent1].[Value] AS [Value],
  1132. [Extent1].[LongValue] AS [LongValue]
  1133. FROM [dbo].[Setting] AS [Extent1]
  1134. WHERE N'SmtpPort' = [Extent1].[Name]10:46:47.409:
  1135. 10:46:47.41: -- Executing at 7/29/2016 10:46:47 AM +05:00
  1136. 10:46:47.41: -- Completed in 0 ms with result: SqlDataReader
  1137. 10:46:47.41:
  1138. 10:46:47.411: Closed connection at 7/29/2016 10:46:47 AM +05:00
  1139. 10:46:47.411: Opened connection at 7/29/2016 10:46:47 AM +05:00
  1140. 10:46:47.412: SELECT TOP (1)
  1141. [Extent1].[Id] AS [Id],
  1142. [Extent1].[Name] AS [Name],
  1143. [Extent1].[Value] AS [Value],
  1144. [Extent1].[LongValue] AS [LongValue]
  1145. FROM [dbo].[Setting] AS [Extent1]
  1146. WHERE N'NotificationPassword' = [Extent1].[Name]10:46:47.412:
  1147. 10:46:47.412: -- Executing at 7/29/2016 10:46:47 AM +05:00
  1148. 10:46:47.413: -- Completed in 0 ms with result: SqlDataReader
  1149. 10:46:47.413:
  1150. 10:46:47.413: Closed connection at 7/29/2016 10:46:47 AM +05:00
  1151. 10:46:47.413: Opened connection at 7/29/2016 10:46:47 AM +05:00
  1152. 10:46:47.414: SELECT TOP (1)
  1153. [Extent1].[Id] AS [Id],
  1154. [Extent1].[Name] AS [Name],
  1155. [Extent1].[Value] AS [Value],
  1156. [Extent1].[LongValue] AS [LongValue]
  1157. FROM [dbo].[Setting] AS [Extent1]
  1158. WHERE N'RequiredAuthentication' = [Extent1].[Name]10:46:47.414:
  1159. 10:46:47.414: -- Executing at 7/29/2016 10:46:47 AM +05:00
  1160. 10:46:47.415: -- Completed in 0 ms with result: SqlDataReader
  1161. 10:46:47.415:
  1162. 10:46:47.415: Closed connection at 7/29/2016 10:46:47 AM +05:00
  1163. 10:46:47.416: Opened connection at 7/29/2016 10:46:47 AM +05:00
  1164. 10:46:47.416: SELECT TOP (1)
  1165. [Extent1].[ID] AS [ID],
  1166. [Extent1].[ID_aspnet_Users] AS [ID_aspnet_Users],
  1167. [Extent1].[FirstName] AS [FirstName],
  1168. [Extent1].[LastName] AS [LastName],
  1169. [Extent1].[Active] AS [Active]
  1170. FROM [dbo].[User] AS [Extent1]
  1171. LEFT OUTER JOIN [dbo].[aspnet_Users] AS [Extent2] ON [Extent1].[ID_aspnet_Users] = [Extent2].[UserId]
  1172. WHERE ([Extent2].[UserName] = @p__linq__0) OR (([Extent2].[UserName] IS NULL) AND (@p__linq__0 IS NULL))10:46:47.417:
  1173. 10:46:47.417: -- p__linq__0: 'admin' (Type = String, Size = 4000)
  1174. 10:46:47.417: -- Executing at 7/29/2016 10:46:47 AM +05:00
  1175. 10:46:47.417: -- Completed in 0 ms with result: SqlDataReader
  1176. 10:46:47.418:
  1177. 10:46:47.418: Closed connection at 7/29/2016 10:46:47 AM +05:00
  1178. 10:46:47.418: Opened connection at 7/29/2016 10:46:47 AM +05:00
  1179. 10:46:47.419: SELECT
  1180. [Extent1].[UserId] AS [UserId],
  1181. [Extent1].[ApplicationId] AS [ApplicationId],
  1182. [Extent1].[UserName] AS [UserName],
  1183. [Extent1].[LoweredUserName] AS [LoweredUserName],
  1184. [Extent1].[MobileAlias] AS [MobileAlias],
  1185. [Extent1].[IsAnonymous] AS [IsAnonymous],
  1186. [Extent1].[LastActivityDate] AS [LastActivityDate]
  1187. FROM [dbo].[aspnet_Users] AS [Extent1]
  1188. WHERE [Extent1].[UserId] = @EntityKeyValue110:46:47.419:
  1189. 10:46:47.419: -- EntityKeyValue1: 'd2350d7b-bfa5-4b2a-9f08-5cae6a094a9e' (Type = Guid)
  1190. 10:46:47.419: -- Executing at 7/29/2016 10:46:47 AM +05:00
  1191. 10:46:47.42: -- Completed in 0 ms with result: SqlDataReader
  1192. 10:46:47.42:
  1193. 10:46:47.42: Closed connection at 7/29/2016 10:46:47 AM +05:00
  1194. 10:46:47.421: Opened connection at 7/29/2016 10:46:47 AM +05:00
  1195. 10:46:47.421: SELECT
  1196. [Extent2].[RoleId] AS [RoleId],
  1197. [Extent2].[ApplicationId] AS [ApplicationId],
  1198. [Extent2].[RoleName] AS [RoleName],
  1199. [Extent2].[LoweredRoleName] AS [LoweredRoleName],
  1200. [Extent2].[Description] AS [Description]
  1201. FROM [dbo].[aspnet_UsersInRoles] AS [Extent1]
  1202. INNER JOIN [dbo].[aspnet_Roles] AS [Extent2] ON [Extent1].[RoleId] = [Extent2].[RoleId]
  1203. WHERE [Extent1].[UserId] = @EntityKeyValue110:46:47.421:
  1204. 10:46:47.421: -- EntityKeyValue1: 'd2350d7b-bfa5-4b2a-9f08-5cae6a094a9e' (Type = Guid, IsNullable = false)
  1205. 10:46:47.422: -- Executing at 7/29/2016 10:46:47 AM +05:00
  1206. 10:46:47.422: -- Completed in 0 ms with result: SqlDataReader
  1207. 10:46:47.422:
  1208. 10:46:47.423: Closed connection at 7/29/2016 10:46:47 AM +05:00
  1209. 10:46:47.423: Opened connection at 7/29/2016 10:46:47 AM +05:00
  1210. 10:46:47.423: SELECT
  1211. [Extent1].[ID] AS [ID],
  1212. [Extent1].[Name] AS [Name],
  1213. [Extent1].[SourceSystemId] AS [SourceSystemId],
  1214. [Extent1].[ID_ActionType] AS [ID_ActionType],
  1215. [Extent1].[ID_Group] AS [ID_Group]
  1216. FROM [dbo].[AccessRight] AS [Extent1]
  1217. WHERE [Extent1].[ID_Group] = @EntityKeyValue110:46:47.424:
  1218. 10:46:47.424: -- EntityKeyValue1: '59d39023-fc53-e611-80c3-00155d63106c' (Type = Guid, IsNullable = false)
  1219. 10:46:47.424: -- Executing at 7/29/2016 10:46:47 AM +05:00
  1220. 10:46:47.425: -- Completed in 0 ms with result: SqlDataReader
  1221. 10:46:47.425:
  1222. 10:46:47.425: Closed connection at 7/29/2016 10:46:47 AM +05:00
  1223. 10:46:47.426: Opened connection at 7/29/2016 10:46:47 AM +05:00
  1224. 10:46:47.426: SELECT
  1225. [Extent1].[Id] AS [Id],
  1226. [Extent1].[Name] AS [Name]
  1227. FROM [dbo].[ActionType] AS [Extent1]
  1228. WHERE [Extent1].[Id] = @EntityKeyValue110:46:47.426:
  1229. 10:46:47.426: -- EntityKeyValue1: '6' (Type = Int32)
  1230. 10:46:47.427: -- Executing at 7/29/2016 10:46:47 AM +05:00
  1231. 10:46:47.427: -- Completed in 0 ms with result: SqlDataReader
  1232. 10:46:47.427:
  1233. 10:46:47.428: Closed connection at 7/29/2016 10:46:47 AM +05:00
  1234. 10:46:47.428: Opened connection at 7/29/2016 10:46:47 AM +05:00
  1235. 10:46:47.428: SELECT
  1236. [Extent1].[Id] AS [Id],
  1237. [Extent1].[Name] AS [Name]
  1238. FROM [dbo].[ActionType] AS [Extent1]
  1239. WHERE [Extent1].[Id] = @EntityKeyValue110:46:47.429:
  1240. 10:46:47.429: -- EntityKeyValue1: '7' (Type = Int32)
  1241. 10:46:47.429: -- Executing at 7/29/2016 10:46:47 AM +05:00
  1242. 10:46:47.429: -- Completed in 0 ms with result: SqlDataReader
  1243. 10:46:47.43:
  1244. 10:46:47.43: Closed connection at 7/29/2016 10:46:47 AM +05:00
  1245. 10:46:47.43: Opened connection at 7/29/2016 10:46:47 AM +05:00
  1246. 10:46:47.431: SELECT
  1247. [Extent1].[ID] AS [ID],
  1248. [Extent1].[Name] AS [Name],
  1249. [Extent1].[SourceSystemId] AS [SourceSystemId],
  1250. [Extent1].[ID_ActionType] AS [ID_ActionType],
  1251. [Extent1].[ID_Group] AS [ID_Group]
  1252. FROM [dbo].[AccessRight] AS [Extent1]
  1253. WHERE [Extent1].[ID_Group] = @EntityKeyValue110:46:47.431:
  1254. 10:46:47.431: -- EntityKeyValue1: 'f82b1d7a-0054-e611-80c3-00155d63106c' (Type = Guid, IsNullable = false)
  1255. 10:46:47.431: -- Executing at 7/29/2016 10:46:47 AM +05:00
  1256. 10:46:47.432: -- Completed in 0 ms with result: SqlDataReader
  1257. 10:46:47.432:
  1258. 10:46:47.432: Closed connection at 7/29/2016 10:46:47 AM +05:00
  1259. 10:46:47.433: Opened connection at 7/29/2016 10:46:47 AM +05:00
  1260. 10:46:47.433: SELECT
  1261. [Extent1].[Id] AS [Id],
  1262. [Extent1].[Name] AS [Name]
  1263. FROM [dbo].[ActionType] AS [Extent1]
  1264. WHERE [Extent1].[Id] = @EntityKeyValue110:46:47.433:
  1265. 10:46:47.433: -- EntityKeyValue1: '3' (Type = Int32)
  1266. 10:46:47.434: -- Executing at 7/29/2016 10:46:47 AM +05:00
  1267. 10:46:47.434: -- Completed in 0 ms with result: SqlDataReader
  1268. 10:46:47.434:
  1269. 10:46:47.434: Closed connection at 7/29/2016 10:46:47 AM +05:00
  1270. 10:46:47.435: Opened connection at 7/29/2016 10:46:47 AM +05:00
  1271. 10:46:47.435: SELECT
  1272. [Extent1].[Id] AS [Id],
  1273. [Extent1].[Name] AS [Name],
  1274. [Extent1].[ActionTypeId] AS [ActionTypeId],
  1275. [Extent1].[BusinessProcessId] AS [BusinessProcessId],
  1276. [Extent1].[DocumentStatusId] AS [DocumentStatusId]
  1277. FROM [dbo].[Stage] AS [Extent1]10:46:47.435:
  1278. 10:46:47.435: -- Executing at 7/29/2016 10:46:47 AM +05:00
  1279. 10:46:47.436: -- Completed in 0 ms with result: SqlDataReader
  1280. 10:46:47.436:
  1281. 10:46:47.437: Closed connection at 7/29/2016 10:46:47 AM +05:00
  1282. 10:46:47.437: Opened connection at 7/29/2016 10:46:47 AM +05:00
  1283. 10:46:47.438: SELECT
  1284. [GroupBy1].[A1] AS [C1]
  1285. FROM ( SELECT
  1286. COUNT(1) AS [A1]
  1287. FROM [dbo].[Task] AS [Extent1]
  1288. INNER JOIN [dbo].[TaskPerformer] AS [Extent2] ON [Extent1].[TaskPerformerId] = [Extent2].[Id]
  1289. WHERE ([Extent2].[UserId] = @p__linq__0) AND ([Extent1].[StageId] = @p__linq__1) AND ([Extent1].[StatusId] < 3)
  1290. ) AS [GroupBy1]10:46:47.438:
  1291. 10:46:47.438: -- p__linq__0: 'd2350d7b-bfa5-4b2a-9f08-5cae6a094a9e' (Type = Guid, IsNullable = false)
  1292. 10:46:47.439: -- p__linq__1: '3' (Type = Int32, IsNullable = false)
  1293. 10:46:47.439: -- Executing at 7/29/2016 10:46:47 AM +05:00
  1294. 10:46:47.439: -- Completed in 0 ms with result: SqlDataReader
  1295. 10:46:47.44:
  1296. 10:46:47.44: Closed connection at 7/29/2016 10:46:47 AM +05:00
  1297. The thread 0x854 has exited with code 0 (0x0).
  1298. The thread 0x4bc has exited with code 0 (0x0).
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement