2026-01-15 05:12:06.451 +00:00 [INF] Request starting HTTP/1.0 GET http:/// - null null
2026-01-15 05:12:06.456 +00:00 [INF] Request finished HTTP/1.0 GET http:/// - 404 0 null 5.5578ms
2026-01-15 05:12:06.456 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http:///, Response status code: 404
2026-01-15 06:18:29.862 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2026-01-15 06:18:29.862 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.3482ms
2026-01-15 06:18:29.862 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404
2026-01-15 09:06:50.214 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2026-01-15 09:06:50.215 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 1.9148ms
2026-01-15 09:06:50.215 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404
2026-01-15 09:07:42.811 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/wiki - null null
2026-01-15 09:07:42.812 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/wiki - 404 0 null 0.9003ms
2026-01-15 09:07:42.812 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/wiki, Response status code: 404
2026-01-15 09:41:15.010 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2026-01-15 09:41:15.011 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.9356ms
2026-01-15 09:41:15.011 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404
2026-01-15 09:41:27.499 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2026-01-15 09:41:27.499 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.325ms
2026-01-15 09:41:27.499 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404
2026-01-15 09:41:32.928 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/wiki - null null
2026-01-15 09:41:32.929 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/wiki - 404 0 null 0.3231ms
2026-01-15 09:41:32.929 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/wiki, Response status code: 404
2026-01-15 10:44:30.078 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2026-01-15 10:44:30.078 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.3318ms
2026-01-15 10:44:30.078 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404
2026-01-15 13:01:06.786 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null
2026-01-15 13:01:06.786 +00:00 [INF] CORS policy execution successful.
2026-01-15 13:01:06.787 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.2982ms
2026-01-15 13:01:06.846 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 65
2026-01-15 13:01:06.847 +00:00 [INF] CORS policy execution successful.
2026-01-15 13:01:06.847 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin'
2026-01-15 13:01:07.187 +00:00 [INF] Executed DbCommand (8ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName]
FROM [AspNetUsers] AS [a]
WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0
2026-01-15 13:01:07.305 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__userId_0='?' (Size = 450)], CommandType='"Text"', CommandTimeout='30']
SELECT [a0].[Name]
FROM [AspNetUserRoles] AS [a]
INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id]
WHERE [a].[UserId] = @__userId_0
2026-01-15 13:01:07.306 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 13:01:07.306 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json.
2026-01-15 13:01:07.306 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin'
2026-01-15 13:01:07.306 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 460.1189ms
2026-01-15 14:50:39.966 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null
2026-01-15 14:50:39.967 +00:00 [INF] CORS policy execution successful.
2026-01-15 14:50:39.967 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.3695ms
2026-01-15 14:50:39.968 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 14:50:39.968 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2026-01-15 14:50:39.968 +00:00 [INF] CORS policy execution successful.
2026-01-15 14:50:39.968 +00:00 [INF] CORS policy execution successful.
2026-01-15 14:50:39.968 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2562ms
2026-01-15 14:50:39.968 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.1895ms
2026-01-15 14:50:39.970 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null
2026-01-15 14:50:39.971 +00:00 [INF] CORS policy execution successful.
2026-01-15 14:50:39.971 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.2671ms
2026-01-15 14:50:40.043 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2026-01-15 14:50:40.043 +00:00 [INF] CORS policy execution successful.
2026-01-15 14:50:40.044 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2026-01-15 14:50:40.045 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 14:50:40.045 +00:00 [INF] CORS policy execution successful.
2026-01-15 14:50:40.045 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null
2026-01-15 14:50:40.046 +00:00 [INF] CORS policy execution successful.
2026-01-15 14:50:40.046 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 14:50:40.046 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/'
2026-01-15 14:50:40.047 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null
2026-01-15 14:50:40.047 +00:00 [INF] CORS policy execution successful.
2026-01-15 14:50:40.048 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities'
2026-01-15 14:50:40.289 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [ProductTaxes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-15 14:50:40.289 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 14:50:40.289 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 14:50:40.289 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2026-01-15 14:50:40.289 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 246.6816ms
2026-01-15 14:50:40.301 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-15 14:50:40.301 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 14:50:40.301 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 14:50:40.301 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 14:50:40.301 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 256.1813ms
2026-01-15 14:50:40.302 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate]
FROM [Settings] AS [s]
2026-01-15 14:50:40.302 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 14:50:40.302 +00:00 [INF] Writing value of type 'SettingDto' as Json.
2026-01-15 14:50:40.302 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/'
2026-01-15 14:50:40.303 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 257.4505ms
2026-01-15 14:50:40.316 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [n].[Id], [n].[Descripcion], [n].[Estatus], [n].[Gentilicio], [n].[Siglas]
FROM [Nationalities] AS [n]
2026-01-15 14:50:40.317 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 14:50:40.317 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 14:50:40.317 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities'
2026-01-15 14:50:40.317 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 269.6056ms
2026-01-15 14:50:43.875 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/hierro - null null
2026-01-15 14:50:43.876 +00:00 [INF] CORS policy execution successful.
2026-01-15 14:50:43.876 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/hierro - 204 null null 0.2783ms
2026-01-15 14:50:43.956 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/hierro - null null
2026-01-15 14:50:43.956 +00:00 [INF] CORS policy execution successful.
2026-01-15 14:50:43.957 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 14:50:43.963 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 14:50:43.964 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 14:50:43.964 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 14:50:43.965 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 14:50:43.965 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/hierro - 200 null application/json; charset=utf-8 8.9953ms
2026-01-15 15:49:31.048 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - null null
2026-01-15 15:49:31.048 +00:00 [INF] CORS policy execution successful.
2026-01-15 15:49:31.048 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - 204 null null 0.2708ms
2026-01-15 15:49:31.128 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma - null null
2026-01-15 15:49:31.128 +00:00 [INF] CORS policy execution successful.
2026-01-15 15:49:31.128 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 15:49:31.368 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 15:49:31.383 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 15:49:31.383 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 15:49:31.593 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 15:49:31.594 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma - 200 null application/json; charset=utf-8 466.1171ms
2026-01-15 16:44:57.724 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/proteinna - null null
2026-01-15 16:44:57.725 +00:00 [INF] CORS policy execution successful.
2026-01-15 16:44:57.725 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/proteinna - 204 null null 0.2729ms
2026-01-15 16:44:57.798 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/proteinna - null null
2026-01-15 16:44:57.798 +00:00 [INF] CORS policy execution successful.
2026-01-15 16:44:57.798 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 16:44:58.044 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 16:44:58.045 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 16:44:58.045 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 16:44:58.045 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 16:44:58.046 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/proteinna - 200 null application/json; charset=utf-8 247.9623ms
2026-01-15 16:45:02.534 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/proteina - null null
2026-01-15 16:45:02.534 +00:00 [INF] CORS policy execution successful.
2026-01-15 16:45:02.534 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/proteina - 204 null null 0.3675ms
2026-01-15 16:45:02.613 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/proteina - null null
2026-01-15 16:45:02.614 +00:00 [INF] CORS policy execution successful.
2026-01-15 16:45:02.614 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 16:45:02.619 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 16:45:02.625 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 16:45:02.625 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 16:45:02.626 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 16:45:02.626 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/proteina - 200 null application/json; charset=utf-8 12.6064ms
2026-01-15 16:45:13.232 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/suprema - null null
2026-01-15 16:45:13.232 +00:00 [INF] CORS policy execution successful.
2026-01-15 16:45:13.232 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/suprema - 204 null null 0.326ms
2026-01-15 16:45:13.305 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/suprema - null null
2026-01-15 16:45:13.305 +00:00 [INF] CORS policy execution successful.
2026-01-15 16:45:13.306 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 16:45:13.308 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 16:45:13.312 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 16:45:13.312 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 16:45:13.312 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 16:45:13.312 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/suprema - 200 null application/json; charset=utf-8 7.1527ms
2026-01-15 17:02:33.372 +00:00 [INF] Request starting HTTP/1.0 GET http:/// - null null
2026-01-15 17:02:33.372 +00:00 [INF] Request finished HTTP/1.0 GET http:/// - 404 0 null 0.321ms
2026-01-15 17:02:33.372 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http:///, Response status code: 404
2026-01-15 17:28:42.601 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan de - null null
2026-01-15 17:28:42.602 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:28:42.602 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan de - 204 null null 1.054ms
2026-01-15 17:28:42.681 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan de - null null
2026-01-15 17:28:42.681 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:28:42.682 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:28:42.912 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 17:28:42.921 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 17:28:42.921 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 17:28:43.064 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:28:43.065 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan de - 200 null application/json; charset=utf-8 383.875ms
2026-01-15 17:28:50.712 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 17:28:50.712 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:28:50.712 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3695ms
2026-01-15 17:28:50.785 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 17:28:50.785 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:28:50.786 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 17:28:50.788 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-15 17:28:50.788 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 17:28:50.788 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 17:28:50.788 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 17:28:50.788 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 2.8973ms
2026-01-15 17:28:54.918 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan de - null null
2026-01-15 17:28:54.918 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:28:54.918 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan de - 204 null null 0.3518ms
2026-01-15 17:28:54.998 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan de - null null
2026-01-15 17:28:54.998 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:28:54.998 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:28:55.004 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 17:28:55.011 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 17:28:55.012 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 17:28:55.013 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:28:55.013 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan de - 200 null application/json; charset=utf-8 15.6221ms
2026-01-15 17:29:03.467 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 17:29:03.467 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:29:03.467 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3394ms
2026-01-15 17:29:03.539 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 17:29:03.540 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:29:03.540 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 17:29:03.542 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-15 17:29:03.543 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 17:29:03.543 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 17:29:03.543 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 17:29:03.543 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 3.5164ms
2026-01-15 17:29:07.905 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - null null
2026-01-15 17:29:07.905 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:29:07.906 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - 204 null null 0.3025ms
2026-01-15 17:29:08.005 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan - null null
2026-01-15 17:29:08.005 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:29:08.006 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:29:08.009 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 17:29:08.015 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 17:29:08.015 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 17:29:08.016 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:29:08.016 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan - 200 null application/json; charset=utf-8 11.0721ms
2026-01-15 17:29:12.839 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan - null null
2026-01-15 17:29:12.839 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:29:12.839 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:29:12.842 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 17:29:12.852 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 17:29:12.852 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 17:29:13.097 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:29:13.098 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan - 200 null application/json; charset=utf-8 259.1433ms
2026-01-15 17:29:24.802 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-15 17:29:24.802 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:29:24.802 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3245ms
2026-01-15 17:29:24.881 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 179
2026-01-15 17:29:24.882 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:29:24.882 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-15 17:29:24.887 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2026-01-15 17:29:24.890 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2026-01-15 17:29:24.891 +00:00 [INF] Setting HTTP status code 201.
2026-01-15 17:29:24.891 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-15 17:29:24.891 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-15 17:29:24.891 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 9.6398ms
2026-01-15 17:29:24.971 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41276 - null null
2026-01-15 17:29:24.972 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:29:24.972 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41276 - 204 null null 0.3112ms
2026-01-15 17:29:24.991 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 17:29:24.992 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:29:24.992 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.29ms
2026-01-15 17:29:25.051 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41276 - application/json 104
2026-01-15 17:29:25.052 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:29:25.052 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-15 17:29:25.054 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-15 17:29:25.064 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 17:29:25.064 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:29:25.065 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 17:29:25.081 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-15 17:29:25.082 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 17:29:25.082 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 17:29:25.082 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 17:29:25.082 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 18.2577ms
2026-01-15 17:29:25.248 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2026-01-15 17:29:25.251 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35);
INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
OUTPUT INSERTED.[Id]
VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47);
2026-01-15 17:29:25.256 +00:00 [INF] Setting HTTP status code 201.
2026-01-15 17:29:25.256 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-15 17:29:25.257 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41276 - 201 0 null 205.2517ms
2026-01-15 17:30:42.845 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - null null
2026-01-15 17:30:42.846 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:30:42.846 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - 204 null null 0.3325ms
2026-01-15 17:30:42.925 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma - null null
2026-01-15 17:30:42.925 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:30:42.925 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:30:42.928 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 17:30:42.937 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 17:30:42.938 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 17:30:43.625 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:30:43.625 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma - 200 null application/json; charset=utf-8 700.2042ms
2026-01-15 17:30:54.903 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/arbaje - null null
2026-01-15 17:30:54.903 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:30:54.903 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/arbaje - 204 null null 0.3334ms
2026-01-15 17:30:54.982 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/arbaje - null null
2026-01-15 17:30:54.982 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:30:54.983 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:30:54.987 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 17:30:54.997 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 17:30:54.998 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 17:30:54.998 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:30:54.998 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/arbaje - 200 null application/json; charset=utf-8 16.0143ms
2026-01-15 17:31:05.390 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-15 17:31:05.390 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:31:05.390 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.2854ms
2026-01-15 17:31:05.470 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2026-01-15 17:31:05.470 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:31:05.470 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-15 17:31:05.475 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2026-01-15 17:31:05.478 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2026-01-15 17:31:05.479 +00:00 [INF] Setting HTTP status code 201.
2026-01-15 17:31:05.479 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-15 17:31:05.479 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-15 17:31:05.480 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 9.7121ms
2026-01-15 17:31:05.560 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 17:31:05.560 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:31:05.560 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2353ms
2026-01-15 17:31:05.560 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41277 - null null
2026-01-15 17:31:05.560 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:31:05.560 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41277 - 204 null null 0.7874ms
2026-01-15 17:31:05.632 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 17:31:05.632 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:31:05.632 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 17:31:05.633 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41277 - application/json 210
2026-01-15 17:31:05.634 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:31:05.634 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-15 17:31:05.635 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-15 17:31:05.635 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 17:31:05.635 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 17:31:05.635 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 17:31:05.635 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 3.8738ms
2026-01-15 17:31:05.637 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-15 17:31:05.825 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2026-01-15 17:31:05.830 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p40='?' (DbType = Int32), @p23='?' (Size = 4000), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Int32), @p26='?' (DbType = Guid), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Boolean), @p29='?' (DbType = DateTime2), @p30='?' (DbType = Int32), @p31='?' (Size = 150), @p32='?' (Size = 500), @p33='?' (Size = -1) (DbType = Binary), @p34='?' (DbType = Int32), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p36='?' (Size = 4000), @p37='?' (DbType = Int32), @p38='?' (DbType = Guid), @p39='?' (DbType = DateTime2), @p41='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p42='?' (DbType = Guid), @p43='?' (DbType = DateTime2), @p44='?' (DbType = Boolean), @p45='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p46='?' (DbType = Int32), @p47='?' (DbType = Int32), @p48='?' (DbType = Int64), @p49='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p50='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p51='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p52='?' (DbType = Guid), @p53='?' (DbType = DateTime2), @p54='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p55='?' (DbType = Guid), @p56='?' (DbType = DateTime2), @p57='?' (DbType = Boolean), @p58='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p59='?' (DbType = Int32), @p60='?' (DbType = Int32), @p61='?' (DbType = Int64), @p62='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p63='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p64='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p65='?' (DbType = Guid), @p66='?' (DbType = DateTime2), @p67='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p68='?' (DbType = Guid), @p69='?' (DbType = DateTime2), @p70='?' (DbType = Int32), @p71='?' (Size = 34), @p72='?' (DbType = Guid), @p73='?' (DbType = Int32), @p74='?' (DbType = Int32), @p75='?' (DbType = Int32), @p76='?' (Size = 4000), @p77='?' (Size = 4000), @p78='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p79='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p80='?' (DbType = Guid), @p81='?' (DbType = DateTime2), @p82='?' (DbType = Int32), @p83='?' (Size = 34), @p84='?' (DbType = Guid), @p85='?' (DbType = Int32), @p86='?' (DbType = Int32), @p87='?' (DbType = Int32), @p88='?' (Size = 4000), @p89='?' (Size = 4000), @p90='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
UPDATE [Products] SET [BarCode] = @p23, [BuyPrice] = @p24, [CategoryId] = @p25, [CreatedById] = @p26, [CreatedDate] = @p27, [DeleteFlag] = @p28, [ExpirationDate] = @p29, [MinimunStock] = @p30, [Name] = @p31, [Note] = @p32, [ProductImage] = @p33, [ProductTaxId] = @p34, [SalePrice] = @p35, [Status] = @p36, [Stock] = @p37, [UpdatedById] = @p38, [UpdatedDate] = @p39
OUTPUT 1
WHERE [Id] = @p40;
MERGE [SalesDetail] USING (
VALUES (@p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52, @p53, 0),
(@p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62, @p63, @p64, @p65, @p66, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[DeleteFlag], i.[DiscountAmount], i.[ProductId], i.[Quantity], i.[SalesId], i.[Tax], i.[Total], i.[UnitPrice], i.[UpdatedById], i.[UpdatedDate])
OUTPUT INSERTED.[Id], i._Position;
MERGE [InventoryMovements] USING (
VALUES (@p67, @p68, @p69, @p70, @p71, @p72, @p73, @p74, @p75, @p76, @p77, @p78, 0),
(@p79, @p80, @p81, @p82, @p83, @p84, @p85, @p86, @p87, @p88, @p89, @p90, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[Difference], i.[Discriminator], i.[InventoryMovementHeaderId], i.[NewStock], i.[OriginaStock], i.[ProductId], i.[ProductName], i.[Reazon], i.[SalePrice])
OUTPUT INSERTED.[Id], i._Position;
2026-01-15 17:31:05.836 +00:00 [INF] Setting HTTP status code 201.
2026-01-15 17:31:05.836 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-15 17:31:05.836 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41277 - 201 0 null 202.9636ms
2026-01-15 17:31:24.560 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plas - null null
2026-01-15 17:31:24.560 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:31:24.560 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plas - 204 null null 0.4137ms
2026-01-15 17:31:24.636 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plas - null null
2026-01-15 17:31:24.636 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:31:24.636 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:31:24.639 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 17:31:24.653 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 17:31:24.654 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 17:31:25.199 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:31:25.199 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/plas - 200 null application/json; charset=utf-8 563.3105ms
2026-01-15 17:31:27.048 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pl - null null
2026-01-15 17:31:27.049 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:31:27.049 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pl - 204 null null 0.9384ms
2026-01-15 17:31:27.125 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/pl - null null
2026-01-15 17:31:27.125 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:31:27.126 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:31:27.128 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 17:31:27.139 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 17:31:27.139 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 17:31:28.537 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:31:28.537 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/pl - 200 null application/json; charset=utf-8 1412.1812ms
2026-01-15 17:31:32.164 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - null null
2026-01-15 17:31:32.164 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:31:32.164 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - 204 null null 0.3653ms
2026-01-15 17:31:32.244 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma - null null
2026-01-15 17:31:32.244 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:31:32.244 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:31:32.247 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 17:31:32.257 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 17:31:32.257 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 17:31:32.689 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:31:32.689 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma - 200 null application/json; charset=utf-8 445.1172ms
2026-01-15 17:31:39.402 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/terapuia - null null
2026-01-15 17:31:39.403 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:31:39.403 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/terapuia - 204 null null 0.2522ms
2026-01-15 17:31:39.482 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/terapuia - null null
2026-01-15 17:31:39.483 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:31:39.483 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:31:39.487 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 17:31:39.488 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 17:31:39.488 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 17:31:39.488 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:31:39.488 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/terapuia - 200 null application/json; charset=utf-8 5.5738ms
2026-01-15 17:31:43.331 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/terpaia - null null
2026-01-15 17:31:43.332 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:31:43.332 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/terpaia - 204 null null 0.3141ms
2026-01-15 17:31:43.405 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/terpaia - null null
2026-01-15 17:31:43.405 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:31:43.405 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:31:43.410 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 17:31:43.410 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 17:31:43.410 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 17:31:43.411 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:31:43.411 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/terpaia - 200 null application/json; charset=utf-8 5.7455ms
2026-01-15 17:31:46.671 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Terapia - null null
2026-01-15 17:31:46.671 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:31:46.671 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Terapia - 204 null null 0.2697ms
2026-01-15 17:31:46.751 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/Terapia - null null
2026-01-15 17:31:46.751 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:31:46.751 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:31:46.754 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 17:31:46.764 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 17:31:46.764 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 17:31:47.054 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:31:47.054 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/Terapia - 200 null application/json; charset=utf-8 303.2268ms
2026-01-15 17:31:56.715 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-15 17:31:56.716 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:31:56.716 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.2725ms
2026-01-15 17:31:56.789 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2026-01-15 17:31:56.789 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:31:56.789 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-15 17:31:56.793 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2026-01-15 17:31:56.796 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2026-01-15 17:31:56.797 +00:00 [INF] Setting HTTP status code 201.
2026-01-15 17:31:56.797 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-15 17:31:56.797 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-15 17:31:56.797 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 8.2729ms
2026-01-15 17:31:56.875 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41278 - null null
2026-01-15 17:31:56.875 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:31:56.875 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41278 - 204 null null 0.5662ms
2026-01-15 17:31:56.889 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 17:31:56.890 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:31:56.890 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.4006ms
2026-01-15 17:31:56.948 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41278 - application/json 211
2026-01-15 17:31:56.949 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:31:56.949 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-15 17:31:56.951 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-15 17:31:56.962 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 17:31:56.963 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:31:56.965 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 17:31:56.977 +00:00 [INF] Executed DbCommand (7ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-15 17:31:56.979 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 17:31:56.979 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 17:31:56.980 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 17:31:56.980 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 17.5596ms
2026-01-15 17:31:57.133 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2026-01-15 17:31:57.137 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p40='?' (DbType = Int32), @p23='?' (Size = 4000), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Int32), @p26='?' (DbType = Guid), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Boolean), @p29='?' (DbType = DateTime2), @p30='?' (DbType = Int32), @p31='?' (Size = 150), @p32='?' (Size = 500), @p33='?' (Size = -1) (DbType = Binary), @p34='?' (DbType = Int32), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p36='?' (Size = 4000), @p37='?' (DbType = Int32), @p38='?' (DbType = Guid), @p39='?' (DbType = DateTime2), @p41='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p42='?' (DbType = Guid), @p43='?' (DbType = DateTime2), @p44='?' (DbType = Boolean), @p45='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p46='?' (DbType = Int32), @p47='?' (DbType = Int32), @p48='?' (DbType = Int64), @p49='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p50='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p51='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p52='?' (DbType = Guid), @p53='?' (DbType = DateTime2), @p54='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p55='?' (DbType = Guid), @p56='?' (DbType = DateTime2), @p57='?' (DbType = Boolean), @p58='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p59='?' (DbType = Int32), @p60='?' (DbType = Int32), @p61='?' (DbType = Int64), @p62='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p63='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p64='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p65='?' (DbType = Guid), @p66='?' (DbType = DateTime2), @p67='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p68='?' (DbType = Guid), @p69='?' (DbType = DateTime2), @p70='?' (DbType = Int32), @p71='?' (Size = 34), @p72='?' (DbType = Guid), @p73='?' (DbType = Int32), @p74='?' (DbType = Int32), @p75='?' (DbType = Int32), @p76='?' (Size = 4000), @p77='?' (Size = 4000), @p78='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p79='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p80='?' (DbType = Guid), @p81='?' (DbType = DateTime2), @p82='?' (DbType = Int32), @p83='?' (Size = 34), @p84='?' (DbType = Guid), @p85='?' (DbType = Int32), @p86='?' (DbType = Int32), @p87='?' (DbType = Int32), @p88='?' (Size = 4000), @p89='?' (Size = 4000), @p90='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
UPDATE [Products] SET [BarCode] = @p23, [BuyPrice] = @p24, [CategoryId] = @p25, [CreatedById] = @p26, [CreatedDate] = @p27, [DeleteFlag] = @p28, [ExpirationDate] = @p29, [MinimunStock] = @p30, [Name] = @p31, [Note] = @p32, [ProductImage] = @p33, [ProductTaxId] = @p34, [SalePrice] = @p35, [Status] = @p36, [Stock] = @p37, [UpdatedById] = @p38, [UpdatedDate] = @p39
OUTPUT 1
WHERE [Id] = @p40;
MERGE [SalesDetail] USING (
VALUES (@p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52, @p53, 0),
(@p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62, @p63, @p64, @p65, @p66, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[DeleteFlag], i.[DiscountAmount], i.[ProductId], i.[Quantity], i.[SalesId], i.[Tax], i.[Total], i.[UnitPrice], i.[UpdatedById], i.[UpdatedDate])
OUTPUT INSERTED.[Id], i._Position;
MERGE [InventoryMovements] USING (
VALUES (@p67, @p68, @p69, @p70, @p71, @p72, @p73, @p74, @p75, @p76, @p77, @p78, 0),
(@p79, @p80, @p81, @p82, @p83, @p84, @p85, @p86, @p87, @p88, @p89, @p90, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[Difference], i.[Discriminator], i.[InventoryMovementHeaderId], i.[NewStock], i.[OriginaStock], i.[ProductId], i.[ProductName], i.[Reazon], i.[SalePrice])
OUTPUT INSERTED.[Id], i._Position;
2026-01-15 17:31:57.143 +00:00 [INF] Setting HTTP status code 201.
2026-01-15 17:31:57.143 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-15 17:31:57.143 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41278 - 201 0 null 194.905ms
2026-01-15 17:32:34.382 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/posy - null null
2026-01-15 17:32:34.383 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:32:34.383 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/posy - 204 null null 0.8759ms
2026-01-15 17:32:34.460 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/posy - null null
2026-01-15 17:32:34.460 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:32:34.460 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:32:34.466 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 17:32:34.466 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 17:32:34.466 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 17:32:34.466 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:32:34.466 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/posy - 200 null application/json; charset=utf-8 6.9626ms
2026-01-15 17:32:39.810 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/postura - null null
2026-01-15 17:32:39.810 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:32:39.810 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/postura - 204 null null 0.3456ms
2026-01-15 17:32:39.890 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/postura - null null
2026-01-15 17:32:39.890 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:32:39.890 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:32:39.894 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 17:32:39.895 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 17:32:39.895 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 17:32:39.896 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:32:39.896 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/postura - 200 null application/json; charset=utf-8 6.0232ms
2026-01-15 17:32:46.538 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/kit - null null
2026-01-15 17:32:46.538 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:32:46.538 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/kit - 204 null null 0.2618ms
2026-01-15 17:32:46.618 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/kit - null null
2026-01-15 17:32:46.618 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:32:46.618 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:32:46.623 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 17:32:46.624 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 17:32:46.624 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 17:32:46.624 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:32:46.624 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/kit - 200 null application/json; charset=utf-8 6.1998ms
2026-01-15 17:51:38.855 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ozozno - null null
2026-01-15 17:51:38.855 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:51:38.855 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ozozno - 204 null null 0.2867ms
2026-01-15 17:51:38.932 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ozozno - null null
2026-01-15 17:51:38.932 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:51:38.932 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:51:39.167 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 17:51:39.168 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 17:51:39.168 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 17:51:39.168 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:51:39.168 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ozozno - 200 null application/json; charset=utf-8 236.2046ms
2026-01-15 17:51:43.174 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ozono - null null
2026-01-15 17:51:43.174 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:51:43.174 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ozono - 204 null null 0.3106ms
2026-01-15 17:51:43.254 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ozono - null null
2026-01-15 17:51:43.254 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:51:43.255 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:51:43.259 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 17:51:43.263 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 17:51:43.263 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 17:51:43.264 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:51:43.264 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ozono - 200 null application/json; charset=utf-8 9.5724ms
2026-01-15 17:52:13.559 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/terapia - null null
2026-01-15 17:52:13.559 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:52:13.559 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/terapia - 204 null null 0.2972ms
2026-01-15 17:52:13.635 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/terapia - null null
2026-01-15 17:52:13.635 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:52:13.635 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:52:13.638 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 17:52:13.649 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 17:52:13.650 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 17:52:13.861 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:52:13.861 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/terapia - 200 null application/json; charset=utf-8 226.3866ms
2026-01-15 17:56:13.706 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colloidal - null null
2026-01-15 17:56:13.707 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:56:13.707 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colloidal - 204 null null 0.3893ms
2026-01-15 17:56:13.786 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/colloidal - null null
2026-01-15 17:56:13.787 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:56:13.787 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:56:13.789 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 17:56:13.793 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 17:56:13.793 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 17:56:13.793 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 17:56:13.793 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/colloidal - 200 null application/json; charset=utf-8 6.6502ms
2026-01-15 17:59:15.986 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-15 17:59:15.986 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:59:15.987 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3814ms
2026-01-15 17:59:16.059 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 228
2026-01-15 17:59:16.059 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:59:16.059 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-15 17:59:16.341 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2026-01-15 17:59:16.345 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2), @p8='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p9='?' (DbType = Guid), @p10='?' (DbType = DateTime2), @p11='?' (DbType = Boolean), @p12='?' (DbType = Int32), @p13='?' (DbType = Int64), @p14='?' (DbType = Guid), @p15='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
MERGE [SalesPaymentTypesDetails] USING (
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, 0),
(@p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, 1)) AS i ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
VALUES (i.[Amount], i.[CreatedById], i.[CreatedDate], i.[DeleteFlag], i.[PaymentTypeId], i.[SalesId], i.[UpdatedById], i.[UpdatedDate])
OUTPUT INSERTED.[Id], i._Position;
2026-01-15 17:59:16.345 +00:00 [INF] Setting HTTP status code 201.
2026-01-15 17:59:16.346 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-15 17:59:16.346 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-15 17:59:16.346 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 287.1923ms
2026-01-15 17:59:16.421 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41279 - null null
2026-01-15 17:59:16.421 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:59:16.421 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41279 - 204 null null 0.422ms
2026-01-15 17:59:16.497 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 17:59:16.498 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:59:16.498 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.68ms
2026-01-15 17:59:16.501 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41279 - application/json 312
2026-01-15 17:59:16.501 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:59:16.501 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-15 17:59:16.503 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-15 17:59:16.570 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 17:59:16.571 +00:00 [INF] CORS policy execution successful.
2026-01-15 17:59:16.572 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 17:59:16.591 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-15 17:59:16.591 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 17:59:16.591 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 17:59:16.591 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 17:59:16.591 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 20.6563ms
2026-01-15 17:59:16.651 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2026-01-15 17:59:16.655 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p40='?' (DbType = Int32), @p23='?' (Size = 4000), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Int32), @p26='?' (DbType = Guid), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Boolean), @p29='?' (DbType = DateTime2), @p30='?' (DbType = Int32), @p31='?' (Size = 150), @p32='?' (Size = 500), @p33='?' (Size = -1) (DbType = Binary), @p34='?' (DbType = Int32), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p36='?' (Size = 4000), @p37='?' (DbType = Int32), @p38='?' (DbType = Guid), @p39='?' (DbType = DateTime2), @p58='?' (DbType = Int32), @p41='?' (Size = 4000), @p42='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p43='?' (DbType = Int32), @p44='?' (DbType = Guid), @p45='?' (DbType = DateTime2), @p46='?' (DbType = Boolean), @p47='?' (DbType = DateTime2), @p48='?' (DbType = Int32), @p49='?' (Size = 150), @p50='?' (Size = 500), @p51='?' (Size = -1) (DbType = Binary), @p52='?' (DbType = Int32), @p53='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p54='?' (Size = 4000), @p55='?' (DbType = Int32), @p56='?' (DbType = Guid), @p57='?' (DbType = DateTime2), @p59='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p60='?' (DbType = Guid), @p61='?' (DbType = DateTime2), @p62='?' (DbType = Boolean), @p63='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p64='?' (DbType = Int32), @p65='?' (DbType = Int32), @p66='?' (DbType = Int64), @p67='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p68='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p69='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p70='?' (DbType = Guid), @p71='?' (DbType = DateTime2), @p72='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p73='?' (DbType = Guid), @p74='?' (DbType = DateTime2), @p75='?' (DbType = Boolean), @p76='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p77='?' (DbType = Int32), @p78='?' (DbType = Int32), @p79='?' (DbType = Int64), @p80='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p81='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p82='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p83='?' (DbType = Guid), @p84='?' (DbType = DateTime2), @p85='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p86='?' (DbType = Guid), @p87='?' (DbType = DateTime2), @p88='?' (DbType = Boolean), @p89='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p90='?' (DbType = Int32), @p91='?' (DbType = Int32), @p92='?' (DbType = Int64), @p93='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p94='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p95='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p96='?' (DbType = Guid), @p97='?' (DbType = DateTime2), @p98='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p99='?' (DbType = Guid), @p100='?' (DbType = DateTime2), @p101='?' (DbType = Int32), @p102='?' (Size = 34), @p103='?' (DbType = Guid), @p104='?' (DbType = Int32), @p105='?' (DbType = Int32), @p106='?' (DbType = Int32), @p107='?' (Size = 4000), @p108='?' (Size = 4000), @p109='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p110='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p111='?' (DbType = Guid), @p112='?' (DbType = DateTime2), @p113='?' (DbType = Int32), @p114='?' (Size = 34), @p115='?' (DbType = Guid), @p116='?' (DbType = Int32), @p117='?' (DbType = Int32), @p118='?' (DbType = Int32), @p119='?' (Size = 4000), @p120='?' (Size = 4000), @p121='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p122='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p123='?' (DbType = Guid), @p124='?' (DbType = DateTime2), @p125='?' (DbType = Int32), @p126='?' (Size = 34), @p127='?' (DbType = Guid), @p128='?' (DbType = Int32), @p129='?' (DbType = Int32), @p130='?' (DbType = Int32), @p131='?' (Size = 4000), @p132='?' (Size = 4000), @p133='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
UPDATE [Products] SET [BarCode] = @p23, [BuyPrice] = @p24, [CategoryId] = @p25, [CreatedById] = @p26, [CreatedDate] = @p27, [DeleteFlag] = @p28, [ExpirationDate] = @p29, [MinimunStock] = @p30, [Name] = @p31, [Note] = @p32, [ProductImage] = @p33, [ProductTaxId] = @p34, [SalePrice] = @p35, [Status] = @p36, [Stock] = @p37, [UpdatedById] = @p38, [UpdatedDate] = @p39
OUTPUT 1
WHERE [Id] = @p40;
UPDATE [Products] SET [BarCode] = @p41, [BuyPrice] = @p42, [CategoryId] = @p43, [CreatedById] = @p44, [CreatedDate] = @p45, [DeleteFlag] = @p46, [ExpirationDate] = @p47, [MinimunStock] = @p48, [Name] = @p49, [Note] = @p50, [ProductImage] = @p51, [ProductTaxId] = @p52, [SalePrice] = @p53, [Status] = @p54, [Stock] = @p55, [UpdatedById] = @p56, [UpdatedDate] = @p57
OUTPUT 1
WHERE [Id] = @p58;
MERGE [SalesDetail] USING (
VALUES (@p59, @p60, @p61, @p62, @p63, @p64, @p65, @p66, @p67, @p68, @p69, @p70, @p71, 0),
(@p72, @p73, @p74, @p75, @p76, @p77, @p78, @p79, @p80, @p81, @p82, @p83, @p84, 1),
(@p85, @p86, @p87, @p88, @p89, @p90, @p91, @p92, @p93, @p94, @p95, @p96, @p97, 2)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[DeleteFlag], i.[DiscountAmount], i.[ProductId], i.[Quantity], i.[SalesId], i.[Tax], i.[Total], i.[UnitPrice], i.[UpdatedById], i.[UpdatedDate])
OUTPUT INSERTED.[Id], i._Position;
MERGE [InventoryMovements] USING (
VALUES (@p98, @p99, @p100, @p101, @p102, @p103, @p104, @p105, @p106, @p107, @p108, @p109, 0),
(@p110, @p111, @p112, @p113, @p114, @p115, @p116, @p117, @p118, @p119, @p120, @p121, 1),
(@p122, @p123, @p124, @p125, @p126, @p127, @p128, @p129, @p130, @p131, @p132, @p133, 2)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[Difference], i.[Discriminator], i.[InventoryMovementHeaderId], i.[NewStock], i.[OriginaStock], i.[ProductId], i.[ProductName], i.[Reazon], i.[SalePrice])
OUTPUT INSERTED.[Id], i._Position;
2026-01-15 17:59:16.662 +00:00 [INF] Setting HTTP status code 201.
2026-01-15 17:59:16.663 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-15 17:59:16.663 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41279 - 201 0 null 162.3578ms
2026-01-15 18:01:48.075 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/vitanina c - null null
2026-01-15 18:01:48.075 +00:00 [INF] CORS policy execution successful.
2026-01-15 18:01:48.075 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/vitanina c - 204 null null 0.415ms
2026-01-15 18:01:48.149 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/vitanina c - null null
2026-01-15 18:01:48.149 +00:00 [INF] CORS policy execution successful.
2026-01-15 18:01:48.149 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 18:01:48.156 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 18:01:48.156 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 18:01:48.156 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 18:01:48.157 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 18:01:48.157 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/vitanina c - 200 null application/json; charset=utf-8 7.9997ms
2026-01-15 18:01:52.947 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/suero - null null
2026-01-15 18:01:52.947 +00:00 [INF] CORS policy execution successful.
2026-01-15 18:01:52.948 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/suero - 204 null null 0.9699ms
2026-01-15 18:01:53.022 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/suero - null null
2026-01-15 18:01:53.023 +00:00 [INF] CORS policy execution successful.
2026-01-15 18:01:53.023 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 18:01:53.027 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 18:01:53.041 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 18:01:53.041 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 18:01:53.263 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 18:01:53.264 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/suero - 200 null application/json; charset=utf-8 241.4597ms
2026-01-15 18:07:59.295 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - null null
2026-01-15 18:07:59.295 +00:00 [INF] CORS policy execution successful.
2026-01-15 18:07:59.295 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - 204 null null 0.3083ms
2026-01-15 18:07:59.373 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma - null null
2026-01-15 18:07:59.373 +00:00 [INF] CORS policy execution successful.
2026-01-15 18:07:59.373 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 18:07:59.636 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 18:07:59.650 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 18:07:59.650 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 18:07:59.870 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 18:07:59.870 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma - 200 null application/json; charset=utf-8 497.4455ms
2026-01-15 18:08:30.909 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/oxidactiva - null null
2026-01-15 18:08:30.909 +00:00 [INF] CORS policy execution successful.
2026-01-15 18:08:30.909 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/oxidactiva - 204 null null 0.3791ms
2026-01-15 18:08:30.989 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/oxidactiva - null null
2026-01-15 18:08:30.989 +00:00 [INF] CORS policy execution successful.
2026-01-15 18:08:30.990 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 18:08:30.995 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 18:08:30.996 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 18:08:30.996 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 18:08:30.996 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 18:08:30.996 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/oxidactiva - 200 null application/json; charset=utf-8 7.2896ms
2026-01-15 18:08:37.207 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/oxidativa - null null
2026-01-15 18:08:37.208 +00:00 [INF] CORS policy execution successful.
2026-01-15 18:08:37.208 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/oxidativa - 204 null null 0.9895ms
2026-01-15 18:08:37.287 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/oxidativa - null null
2026-01-15 18:08:37.287 +00:00 [INF] CORS policy execution successful.
2026-01-15 18:08:37.287 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 18:08:37.295 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 18:08:37.296 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 18:08:37.296 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 18:08:37.296 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 18:08:37.297 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/oxidativa - 200 null application/json; charset=utf-8 9.9841ms
2026-01-15 18:08:48.265 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-15 18:08:48.265 +00:00 [INF] CORS policy execution successful.
2026-01-15 18:08:48.266 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.4165ms
2026-01-15 18:08:48.344 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2026-01-15 18:08:48.345 +00:00 [INF] CORS policy execution successful.
2026-01-15 18:08:48.345 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-15 18:08:48.349 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2026-01-15 18:08:48.353 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2026-01-15 18:08:48.353 +00:00 [INF] Setting HTTP status code 201.
2026-01-15 18:08:48.353 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-15 18:08:48.353 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-15 18:08:48.353 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 8.8356ms
2026-01-15 18:08:48.430 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41280 - null null
2026-01-15 18:08:48.431 +00:00 [INF] CORS policy execution successful.
2026-01-15 18:08:48.431 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41280 - 204 null null 0.3364ms
2026-01-15 18:08:48.504 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 18:08:48.505 +00:00 [INF] CORS policy execution successful.
2026-01-15 18:08:48.505 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3984ms
2026-01-15 18:08:48.508 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41280 - application/json 211
2026-01-15 18:08:48.508 +00:00 [INF] CORS policy execution successful.
2026-01-15 18:08:48.509 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-15 18:08:48.511 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-15 18:08:48.576 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 18:08:48.576 +00:00 [INF] CORS policy execution successful.
2026-01-15 18:08:48.577 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 18:08:48.614 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-15 18:08:48.615 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 18:08:48.615 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 18:08:48.616 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 18:08:48.616 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 40.2969ms
2026-01-15 18:08:48.731 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2026-01-15 18:08:48.737 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p40='?' (DbType = Int32), @p23='?' (Size = 4000), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Int32), @p26='?' (DbType = Guid), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Boolean), @p29='?' (DbType = DateTime2), @p30='?' (DbType = Int32), @p31='?' (Size = 150), @p32='?' (Size = 500), @p33='?' (Size = -1) (DbType = Binary), @p34='?' (DbType = Int32), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p36='?' (Size = 4000), @p37='?' (DbType = Int32), @p38='?' (DbType = Guid), @p39='?' (DbType = DateTime2), @p41='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p42='?' (DbType = Guid), @p43='?' (DbType = DateTime2), @p44='?' (DbType = Boolean), @p45='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p46='?' (DbType = Int32), @p47='?' (DbType = Int32), @p48='?' (DbType = Int64), @p49='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p50='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p51='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p52='?' (DbType = Guid), @p53='?' (DbType = DateTime2), @p54='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p55='?' (DbType = Guid), @p56='?' (DbType = DateTime2), @p57='?' (DbType = Boolean), @p58='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p59='?' (DbType = Int32), @p60='?' (DbType = Int32), @p61='?' (DbType = Int64), @p62='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p63='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p64='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p65='?' (DbType = Guid), @p66='?' (DbType = DateTime2), @p67='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p68='?' (DbType = Guid), @p69='?' (DbType = DateTime2), @p70='?' (DbType = Int32), @p71='?' (Size = 34), @p72='?' (DbType = Guid), @p73='?' (DbType = Int32), @p74='?' (DbType = Int32), @p75='?' (DbType = Int32), @p76='?' (Size = 4000), @p77='?' (Size = 4000), @p78='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p79='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p80='?' (DbType = Guid), @p81='?' (DbType = DateTime2), @p82='?' (DbType = Int32), @p83='?' (Size = 34), @p84='?' (DbType = Guid), @p85='?' (DbType = Int32), @p86='?' (DbType = Int32), @p87='?' (DbType = Int32), @p88='?' (Size = 4000), @p89='?' (Size = 4000), @p90='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
UPDATE [Products] SET [BarCode] = @p23, [BuyPrice] = @p24, [CategoryId] = @p25, [CreatedById] = @p26, [CreatedDate] = @p27, [DeleteFlag] = @p28, [ExpirationDate] = @p29, [MinimunStock] = @p30, [Name] = @p31, [Note] = @p32, [ProductImage] = @p33, [ProductTaxId] = @p34, [SalePrice] = @p35, [Status] = @p36, [Stock] = @p37, [UpdatedById] = @p38, [UpdatedDate] = @p39
OUTPUT 1
WHERE [Id] = @p40;
MERGE [SalesDetail] USING (
VALUES (@p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52, @p53, 0),
(@p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62, @p63, @p64, @p65, @p66, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[DeleteFlag], i.[DiscountAmount], i.[ProductId], i.[Quantity], i.[SalesId], i.[Tax], i.[Total], i.[UnitPrice], i.[UpdatedById], i.[UpdatedDate])
OUTPUT INSERTED.[Id], i._Position;
MERGE [InventoryMovements] USING (
VALUES (@p67, @p68, @p69, @p70, @p71, @p72, @p73, @p74, @p75, @p76, @p77, @p78, 0),
(@p79, @p80, @p81, @p82, @p83, @p84, @p85, @p86, @p87, @p88, @p89, @p90, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[Difference], i.[Discriminator], i.[InventoryMovementHeaderId], i.[NewStock], i.[OriginaStock], i.[ProductId], i.[ProductName], i.[Reazon], i.[SalePrice])
OUTPUT INSERTED.[Id], i._Position;
2026-01-15 18:08:48.741 +00:00 [INF] Setting HTTP status code 201.
2026-01-15 18:08:48.741 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-15 18:08:48.741 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41280 - 201 0 null 233.1095ms
2026-01-15 18:09:09.801 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/gel - null null
2026-01-15 18:09:09.801 +00:00 [INF] CORS policy execution successful.
2026-01-15 18:09:09.801 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/gel - 204 null null 0.4552ms
2026-01-15 18:09:09.881 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/gel - null null
2026-01-15 18:09:09.881 +00:00 [INF] CORS policy execution successful.
2026-01-15 18:09:09.881 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 18:09:09.885 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 18:09:09.889 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 18:09:09.889 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 18:09:09.889 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 18:09:09.889 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/gel - 200 null application/json; charset=utf-8 8.4092ms
2026-01-15 18:09:19.799 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/oxidativa - null null
2026-01-15 18:09:19.799 +00:00 [INF] CORS policy execution successful.
2026-01-15 18:09:19.799 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/oxidativa - 204 null null 0.3567ms
2026-01-15 18:09:19.879 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/oxidativa - null null
2026-01-15 18:09:19.879 +00:00 [INF] CORS policy execution successful.
2026-01-15 18:09:19.879 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 18:09:19.884 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 18:09:19.885 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 18:09:19.886 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 18:09:19.886 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 18:09:19.886 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/oxidativa - 200 null application/json; charset=utf-8 7.1292ms
2026-01-15 18:18:41.339 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 18:18:41.339 +00:00 [INF] CORS policy execution successful.
2026-01-15 18:18:41.339 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3206ms
2026-01-15 18:18:41.418 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 18:18:41.418 +00:00 [INF] CORS policy execution successful.
2026-01-15 18:18:41.419 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 18:18:41.681 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-15 18:18:41.682 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 18:18:41.682 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 18:18:41.682 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 18:18:41.683 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 264.4454ms
2026-01-15 18:18:47.237 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/oxidativa - null null
2026-01-15 18:18:47.238 +00:00 [INF] CORS policy execution successful.
2026-01-15 18:18:47.238 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/oxidativa - 204 null null 1.4941ms
2026-01-15 18:18:47.313 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/oxidativa - null null
2026-01-15 18:18:47.313 +00:00 [INF] CORS policy execution successful.
2026-01-15 18:18:47.314 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 18:18:47.319 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 18:18:47.322 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 18:18:47.322 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 18:18:47.323 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 18:18:47.323 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/oxidativa - 200 null application/json; charset=utf-8 9.8131ms
2026-01-15 18:18:58.386 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma gel - null null
2026-01-15 18:18:58.386 +00:00 [INF] CORS policy execution successful.
2026-01-15 18:18:58.386 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma gel - 204 null null 0.5684ms
2026-01-15 18:18:58.464 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma gel - null null
2026-01-15 18:18:58.464 +00:00 [INF] CORS policy execution successful.
2026-01-15 18:18:58.465 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 18:18:58.471 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 18:18:58.473 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 18:18:58.473 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 18:18:58.474 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 18:18:58.474 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma gel - 200 null application/json; charset=utf-8 9.5783ms
2026-01-15 19:03:07.885 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 19:03:07.885 +00:00 [INF] CORS policy execution successful.
2026-01-15 19:03:07.885 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2567ms
2026-01-15 19:03:07.958 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 19:03:07.958 +00:00 [INF] CORS policy execution successful.
2026-01-15 19:03:07.958 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 19:03:08.185 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-15 19:03:08.186 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 19:03:08.186 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 19:03:08.186 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 19:03:08.187 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 229.025ms
2026-01-15 19:03:11.793 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colina - null null
2026-01-15 19:03:11.793 +00:00 [INF] CORS policy execution successful.
2026-01-15 19:03:11.794 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colina - 204 null null 0.3622ms
2026-01-15 19:03:11.867 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/colina - null null
2026-01-15 19:03:11.867 +00:00 [INF] CORS policy execution successful.
2026-01-15 19:03:11.868 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 19:03:11.872 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 19:03:11.874 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 19:03:11.874 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 19:03:11.874 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 19:03:11.874 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/colina - 200 null application/json; charset=utf-8 7.294ms
2026-01-15 19:03:19.465 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-15 19:03:19.465 +00:00 [INF] CORS policy execution successful.
2026-01-15 19:03:19.465 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3665ms
2026-01-15 19:03:19.541 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2026-01-15 19:03:19.541 +00:00 [INF] CORS policy execution successful.
2026-01-15 19:03:19.541 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-15 19:03:19.545 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2026-01-15 19:03:19.548 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2026-01-15 19:03:19.549 +00:00 [INF] Setting HTTP status code 201.
2026-01-15 19:03:19.549 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-15 19:03:19.549 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-15 19:03:19.549 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 8.5313ms
2026-01-15 19:03:19.625 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41281 - null null
2026-01-15 19:03:19.626 +00:00 [INF] CORS policy execution successful.
2026-01-15 19:03:19.626 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41281 - 204 null null 0.8803ms
2026-01-15 19:03:19.698 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 19:03:19.699 +00:00 [INF] CORS policy execution successful.
2026-01-15 19:03:19.699 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.81ms
2026-01-15 19:03:19.715 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41281 - application/json 106
2026-01-15 19:03:19.715 +00:00 [INF] CORS policy execution successful.
2026-01-15 19:03:19.715 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-15 19:03:19.718 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-15 19:03:19.770 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 19:03:19.771 +00:00 [INF] CORS policy execution successful.
2026-01-15 19:03:19.771 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 19:03:19.790 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-15 19:03:19.790 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 19:03:19.790 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 19:03:19.791 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 19:03:19.791 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 20.2525ms
2026-01-15 19:03:19.860 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2026-01-15 19:03:19.862 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35);
INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
OUTPUT INSERTED.[Id]
VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47);
2026-01-15 19:03:19.865 +00:00 [INF] Setting HTTP status code 201.
2026-01-15 19:03:19.866 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-15 19:03:19.866 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41281 - 201 0 null 151.1642ms
2026-01-15 19:10:38.288 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma gel - null null
2026-01-15 19:10:38.288 +00:00 [INF] CORS policy execution successful.
2026-01-15 19:10:38.288 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma gel - 204 null null 0.2724ms
2026-01-15 19:10:38.376 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma gel - null null
2026-01-15 19:10:38.376 +00:00 [INF] CORS policy execution successful.
2026-01-15 19:10:38.376 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 19:10:38.606 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 19:10:38.608 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 19:10:38.608 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 19:10:38.608 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 19:10:38.608 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma gel - 200 null application/json; charset=utf-8 232.2281ms
2026-01-15 19:10:50.245 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ooxri - null null
2026-01-15 19:10:50.246 +00:00 [INF] CORS policy execution successful.
2026-01-15 19:10:50.246 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ooxri - 204 null null 0.9684ms
2026-01-15 19:10:50.338 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ooxri - null null
2026-01-15 19:10:50.338 +00:00 [INF] CORS policy execution successful.
2026-01-15 19:10:50.338 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 19:10:50.344 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 19:10:50.344 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 19:10:50.344 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 19:10:50.344 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 19:10:50.345 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ooxri - 200 null application/json; charset=utf-8 7.0342ms
2026-01-15 19:10:55.154 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/oxidativa - null null
2026-01-15 19:10:55.154 +00:00 [INF] CORS policy execution successful.
2026-01-15 19:10:55.155 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/oxidativa - 204 null null 1.2286ms
2026-01-15 19:10:55.237 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/oxidativa - null null
2026-01-15 19:10:55.237 +00:00 [INF] CORS policy execution successful.
2026-01-15 19:10:55.237 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 19:10:55.243 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 19:10:55.245 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 19:10:55.245 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 19:10:55.245 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 19:10:55.246 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/oxidativa - 200 null application/json; charset=utf-8 9.0861ms
2026-01-15 19:11:28.687 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-15 19:11:28.687 +00:00 [INF] CORS policy execution successful.
2026-01-15 19:11:28.687 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.2841ms
2026-01-15 19:11:28.766 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2026-01-15 19:11:28.767 +00:00 [INF] CORS policy execution successful.
2026-01-15 19:11:28.767 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-15 19:11:28.773 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2026-01-15 19:11:28.776 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2026-01-15 19:11:28.776 +00:00 [INF] Setting HTTP status code 201.
2026-01-15 19:11:28.776 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-15 19:11:28.777 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-15 19:11:28.777 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 10.4688ms
2026-01-15 19:11:28.856 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41282 - null null
2026-01-15 19:11:28.856 +00:00 [INF] CORS policy execution successful.
2026-01-15 19:11:28.856 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41282 - 204 null null 0.2534ms
2026-01-15 19:11:28.936 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 19:11:28.936 +00:00 [INF] CORS policy execution successful.
2026-01-15 19:11:28.936 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.339ms
2026-01-15 19:11:28.942 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41282 - application/json 211
2026-01-15 19:11:28.942 +00:00 [INF] CORS policy execution successful.
2026-01-15 19:11:28.943 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-15 19:11:28.945 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-15 19:11:29.017 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 19:11:29.017 +00:00 [INF] CORS policy execution successful.
2026-01-15 19:11:29.018 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 19:11:29.047 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-15 19:11:29.047 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 19:11:29.047 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 19:11:29.047 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 19:11:29.047 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 30.702ms
2026-01-15 19:11:29.101 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2026-01-15 19:11:29.106 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p40='?' (DbType = Int32), @p23='?' (Size = 4000), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Int32), @p26='?' (DbType = Guid), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Boolean), @p29='?' (DbType = DateTime2), @p30='?' (DbType = Int32), @p31='?' (Size = 150), @p32='?' (Size = 500), @p33='?' (Size = -1) (DbType = Binary), @p34='?' (DbType = Int32), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p36='?' (Size = 4000), @p37='?' (DbType = Int32), @p38='?' (DbType = Guid), @p39='?' (DbType = DateTime2), @p41='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p42='?' (DbType = Guid), @p43='?' (DbType = DateTime2), @p44='?' (DbType = Boolean), @p45='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p46='?' (DbType = Int32), @p47='?' (DbType = Int32), @p48='?' (DbType = Int64), @p49='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p50='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p51='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p52='?' (DbType = Guid), @p53='?' (DbType = DateTime2), @p54='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p55='?' (DbType = Guid), @p56='?' (DbType = DateTime2), @p57='?' (DbType = Boolean), @p58='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p59='?' (DbType = Int32), @p60='?' (DbType = Int32), @p61='?' (DbType = Int64), @p62='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p63='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p64='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p65='?' (DbType = Guid), @p66='?' (DbType = DateTime2), @p67='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p68='?' (DbType = Guid), @p69='?' (DbType = DateTime2), @p70='?' (DbType = Int32), @p71='?' (Size = 34), @p72='?' (DbType = Guid), @p73='?' (DbType = Int32), @p74='?' (DbType = Int32), @p75='?' (DbType = Int32), @p76='?' (Size = 4000), @p77='?' (Size = 4000), @p78='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p79='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p80='?' (DbType = Guid), @p81='?' (DbType = DateTime2), @p82='?' (DbType = Int32), @p83='?' (Size = 34), @p84='?' (DbType = Guid), @p85='?' (DbType = Int32), @p86='?' (DbType = Int32), @p87='?' (DbType = Int32), @p88='?' (Size = 4000), @p89='?' (Size = 4000), @p90='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
UPDATE [Products] SET [BarCode] = @p23, [BuyPrice] = @p24, [CategoryId] = @p25, [CreatedById] = @p26, [CreatedDate] = @p27, [DeleteFlag] = @p28, [ExpirationDate] = @p29, [MinimunStock] = @p30, [Name] = @p31, [Note] = @p32, [ProductImage] = @p33, [ProductTaxId] = @p34, [SalePrice] = @p35, [Status] = @p36, [Stock] = @p37, [UpdatedById] = @p38, [UpdatedDate] = @p39
OUTPUT 1
WHERE [Id] = @p40;
MERGE [SalesDetail] USING (
VALUES (@p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52, @p53, 0),
(@p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62, @p63, @p64, @p65, @p66, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[DeleteFlag], i.[DiscountAmount], i.[ProductId], i.[Quantity], i.[SalesId], i.[Tax], i.[Total], i.[UnitPrice], i.[UpdatedById], i.[UpdatedDate])
OUTPUT INSERTED.[Id], i._Position;
MERGE [InventoryMovements] USING (
VALUES (@p67, @p68, @p69, @p70, @p71, @p72, @p73, @p74, @p75, @p76, @p77, @p78, 0),
(@p79, @p80, @p81, @p82, @p83, @p84, @p85, @p86, @p87, @p88, @p89, @p90, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[Difference], i.[Discriminator], i.[InventoryMovementHeaderId], i.[NewStock], i.[OriginaStock], i.[ProductId], i.[ProductName], i.[Reazon], i.[SalePrice])
OUTPUT INSERTED.[Id], i._Position;
2026-01-15 19:11:29.110 +00:00 [INF] Setting HTTP status code 201.
2026-01-15 19:11:29.110 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-15 19:11:29.110 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41282 - 201 0 null 167.7245ms
2026-01-15 20:50:33.937 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plata - null null
2026-01-15 20:50:33.937 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:50:33.937 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plata - 204 null null 0.2686ms
2026-01-15 20:50:34.021 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plata - null null
2026-01-15 20:50:34.021 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:50:34.021 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 20:50:34.336 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 20:50:34.338 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 20:50:34.338 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 20:50:34.338 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 20:50:34.338 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/plata - 200 null application/json; charset=utf-8 317.7617ms
2026-01-15 20:50:40.619 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plata - null null
2026-01-15 20:50:40.620 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:50:40.620 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plata - 204 null null 0.3315ms
2026-01-15 20:50:40.699 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plata - null null
2026-01-15 20:50:40.700 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:50:40.700 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 20:50:40.705 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 20:50:40.705 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 20:50:40.705 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 20:50:40.705 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 20:50:40.705 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/plata - 200 null application/json; charset=utf-8 6.0599ms
2026-01-15 20:50:41.899 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/o - null null
2026-01-15 20:50:41.900 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:50:41.900 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/o - 204 null null 0.3251ms
2026-01-15 20:50:41.979 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/o - null null
2026-01-15 20:50:41.979 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:50:41.980 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 20:50:41.982 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 20:50:42.089 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 20:50:42.089 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 20:50:43.640 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 20:50:43.641 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/o - 200 null application/json; charset=utf-8 1661.8577ms
2026-01-15 20:50:54.887 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colloidal - null null
2026-01-15 20:50:54.887 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:50:54.887 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colloidal - 204 null null 0.3091ms
2026-01-15 20:50:54.961 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/colloidal - null null
2026-01-15 20:50:54.962 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:50:54.962 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 20:50:54.964 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 20:50:54.968 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 20:50:54.968 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 20:50:54.969 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 20:50:54.969 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/colloidal - 200 null application/json; charset=utf-8 7.2715ms
2026-01-15 20:51:13.523 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/friscilico - null null
2026-01-15 20:51:13.523 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:51:13.523 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/friscilico - 204 null null 0.2574ms
2026-01-15 20:51:13.602 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/friscilico - null null
2026-01-15 20:51:13.602 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:51:13.603 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 20:51:13.608 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 20:51:13.608 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 20:51:13.608 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 20:51:13.608 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 20:51:13.608 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/friscilico - 200 null application/json; charset=utf-8 5.9352ms
2026-01-15 20:51:37.336 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/mentol - null null
2026-01-15 20:51:37.336 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:51:37.336 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/mentol - 204 null null 0.2743ms
2026-01-15 20:51:37.417 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/mentol - null null
2026-01-15 20:51:37.418 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:51:37.418 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 20:51:37.421 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 20:51:37.423 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 20:51:37.423 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 20:51:37.423 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 20:51:37.423 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/mentol - 200 null application/json; charset=utf-8 6.0139ms
2026-01-15 20:52:12.418 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/fricci - null null
2026-01-15 20:52:12.418 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:52:12.418 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/fricci - 204 null null 0.2942ms
2026-01-15 20:52:12.493 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/fricci - null null
2026-01-15 20:52:12.493 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:52:12.493 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 20:52:12.498 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 20:52:12.499 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 20:52:12.499 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 20:52:12.499 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 20:52:12.499 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/fricci - 200 null application/json; charset=utf-8 6.3394ms
2026-01-15 20:52:14.363 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ico - null null
2026-01-15 20:52:14.363 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:52:14.363 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ico - 204 null null 0.408ms
2026-01-15 20:52:14.439 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ico - null null
2026-01-15 20:52:14.439 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:52:14.440 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 20:52:14.442 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 20:52:14.460 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 20:52:14.460 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 20:52:14.461 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 20:52:14.461 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ico - 200 null application/json; charset=utf-8 21.401ms
2026-01-15 20:54:47.866 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/harina - null null
2026-01-15 20:54:47.866 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:54:47.866 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/harina - 204 null null 0.3185ms
2026-01-15 20:54:47.939 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/harina - null null
2026-01-15 20:54:47.939 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:54:47.939 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 20:54:47.942 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 20:54:47.947 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 20:54:47.947 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 20:54:48.097 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 20:54:48.097 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/harina - 200 null application/json; charset=utf-8 158.6271ms
2026-01-15 20:55:13.101 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Jarabe - null null
2026-01-15 20:55:13.101 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:55:13.101 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Jarabe - 204 null null 0.4044ms
2026-01-15 20:55:13.174 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/Jarabe - null null
2026-01-15 20:55:13.175 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:55:13.175 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 20:55:13.179 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 20:55:13.180 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 20:55:13.180 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 20:55:13.181 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 20:55:13.181 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/Jarabe - 200 null application/json; charset=utf-8 6.4707ms
2026-01-15 20:55:21.519 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1527 - null null
2026-01-15 20:55:21.519 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:55:21.519 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1527 - 204 null null 0.3223ms
2026-01-15 20:55:21.591 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/1527 - null null
2026-01-15 20:55:21.592 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:55:21.592 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2026-01-15 20:55:21.602 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2026-01-15 20:55:21.603 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 20:55:21.603 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json.
2026-01-15 20:55:21.603 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2026-01-15 20:55:21.603 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/1527 - 200 null application/json; charset=utf-8 11.7002ms
2026-01-15 20:55:42.495 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/aceite de coco - null null
2026-01-15 20:55:42.495 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:55:42.495 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/aceite de coco - 204 null null 0.3282ms
2026-01-15 20:55:42.574 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/aceite de coco - null null
2026-01-15 20:55:42.575 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:55:42.575 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 20:55:42.577 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 20:55:42.581 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 20:55:42.581 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 20:55:42.581 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 20:55:42.581 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/aceite de coco - 200 null application/json; charset=utf-8 7.0662ms
2026-01-15 20:55:52.826 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/miel - null null
2026-01-15 20:55:52.826 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:55:52.826 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/miel - 204 null null 0.3394ms
2026-01-15 20:55:52.905 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/miel - null null
2026-01-15 20:55:52.906 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:55:52.906 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 20:55:52.909 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 20:55:52.918 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 20:55:52.918 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 20:55:53.062 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 20:55:53.062 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/miel - 200 null application/json; charset=utf-8 157.0838ms
2026-01-15 20:56:37.633 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-15 20:56:37.633 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:56:37.633 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3746ms
2026-01-15 20:56:37.712 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 191
2026-01-15 20:56:37.713 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:56:37.713 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-15 20:56:37.718 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2026-01-15 20:56:37.721 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2026-01-15 20:56:37.722 +00:00 [INF] Setting HTTP status code 201.
2026-01-15 20:56:37.722 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-15 20:56:37.722 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-15 20:56:37.722 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 9.6787ms
2026-01-15 20:56:37.802 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41283 - null null
2026-01-15 20:56:37.803 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:56:37.803 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41283 - 204 null null 0.2945ms
2026-01-15 20:56:37.882 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 20:56:37.883 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:56:37.883 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2814ms
2026-01-15 20:56:37.903 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41283 - application/json 625
2026-01-15 20:56:37.903 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:56:37.904 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-15 20:56:37.906 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-15 20:56:37.956 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 20:56:37.956 +00:00 [INF] CORS policy execution successful.
2026-01-15 20:56:37.956 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 20:56:38.076 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2026-01-15 20:56:38.085 +00:00 [INF] Executed DbCommand (7ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p40='?' (DbType = Int32), @p23='?' (Size = 4000), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Int32), @p26='?' (DbType = Guid), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Boolean), @p29='?' (DbType = DateTime2), @p30='?' (DbType = Int32), @p31='?' (Size = 150), @p32='?' (Size = 500), @p33='?' (Size = -1) (DbType = Binary), @p34='?' (DbType = Int32), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p36='?' (Size = 4000), @p37='?' (DbType = Int32), @p38='?' (DbType = Guid), @p39='?' (DbType = DateTime2), @p58='?' (DbType = Int32), @p41='?' (Size = 4000), @p42='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p43='?' (DbType = Int32), @p44='?' (DbType = Guid), @p45='?' (DbType = DateTime2), @p46='?' (DbType = Boolean), @p47='?' (DbType = DateTime2), @p48='?' (DbType = Int32), @p49='?' (Size = 150), @p50='?' (Size = 500), @p51='?' (Size = -1) (DbType = Binary), @p52='?' (DbType = Int32), @p53='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p54='?' (Size = 4000), @p55='?' (DbType = Int32), @p56='?' (DbType = Guid), @p57='?' (DbType = DateTime2), @p76='?' (DbType = Int32), @p59='?' (Size = 4000), @p60='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p61='?' (DbType = Int32), @p62='?' (DbType = Guid), @p63='?' (DbType = DateTime2), @p64='?' (DbType = Boolean), @p65='?' (DbType = DateTime2), @p66='?' (DbType = Int32), @p67='?' (Size = 150), @p68='?' (Size = 500), @p69='?' (Size = -1) (DbType = Binary), @p70='?' (DbType = Int32), @p71='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p72='?' (Size = 4000), @p73='?' (DbType = Int32), @p74='?' (DbType = Guid), @p75='?' (DbType = DateTime2), @p94='?' (DbType = Int32), @p77='?' (Size = 4000), @p78='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p79='?' (DbType = Int32), @p80='?' (DbType = Guid), @p81='?' (DbType = DateTime2), @p82='?' (DbType = Boolean), @p83='?' (DbType = DateTime2), @p84='?' (DbType = Int32), @p85='?' (Size = 150), @p86='?' (Size = 500), @p87='?' (Size = -1) (DbType = Binary), @p88='?' (DbType = Int32), @p89='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p90='?' (Size = 4000), @p91='?' (DbType = Int32), @p92='?' (DbType = Guid), @p93='?' (DbType = DateTime2), @p112='?' (DbType = Int32), @p95='?' (Size = 4000), @p96='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p97='?' (DbType = Int32), @p98='?' (DbType = Guid), @p99='?' (DbType = DateTime2), @p100='?' (DbType = Boolean), @p101='?' (DbType = DateTime2), @p102='?' (DbType = Int32), @p103='?' (Size = 150), @p104='?' (Size = 500), @p105='?' (Size = -1) (DbType = Binary), @p106='?' (DbType = Int32), @p107='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p108='?' (Size = 4000), @p109='?' (DbType = Int32), @p110='?' (DbType = Guid), @p111='?' (DbType = DateTime2), @p113='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p114='?' (DbType = Guid), @p115='?' (DbType = DateTime2), @p116='?' (DbType = Boolean), @p117='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p118='?' (DbType = Int32), @p119='?' (DbType = Int32), @p120='?' (DbType = Int64), @p121='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p122='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p123='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p124='?' (DbType = Guid), @p125='?' (DbType = DateTime2), @p126='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p127='?' (DbType = Guid), @p128='?' (DbType = DateTime2), @p129='?' (DbType = Boolean), @p130='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p131='?' (DbType = Int32), @p132='?' (DbType = Int32), @p133='?' (DbType = Int64), @p134='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p135='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p136='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p137='?' (DbType = Guid), @p138='?' (DbType = DateTime2), @p139='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p140='?' (DbType = Guid), @p141='?' (DbType = DateTime2), @p142='?' (DbType = Boolean), @p143='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p144='?' (DbType = Int32), @p145='?' (DbType = Int32), @p146='?' (DbType = Int64), @p147='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p148='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p149='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p150='?' (DbType = Guid), @p151='?' (DbType = DateTime2), @p152='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p153='?' (DbType = Guid), @p154='?' (DbType = DateTime2), @p155='?' (DbType = Boolean), @p156='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p157='?' (DbType = Int32), @p158='?' (DbType = Int32), @p159='?' (DbType = Int64), @p160='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p161='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p162='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p163='?' (DbType = Guid), @p164='?' (DbType = DateTime2), @p165='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p166='?' (DbType = Guid), @p167='?' (DbType = DateTime2), @p168='?' (DbType = Boolean), @p169='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p170='?' (DbType = Int32), @p171='?' (DbType = Int32), @p172='?' (DbType = Int64), @p173='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p174='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p175='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p176='?' (DbType = Guid), @p177='?' (DbType = DateTime2), @p178='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p179='?' (DbType = Guid), @p180='?' (DbType = DateTime2), @p181='?' (DbType = Boolean), @p182='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p183='?' (DbType = Int32), @p184='?' (DbType = Int32), @p185='?' (DbType = Int64), @p186='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p187='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p188='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p189='?' (DbType = Guid), @p190='?' (DbType = DateTime2), @p191='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p192='?' (DbType = Guid), @p193='?' (DbType = DateTime2), @p194='?' (DbType = Int32), @p195='?' (Size = 34), @p196='?' (DbType = Guid), @p197='?' (DbType = Int32), @p198='?' (DbType = Int32), @p199='?' (DbType = Int32), @p200='?' (Size = 4000), @p201='?' (Size = 4000), @p202='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p203='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p204='?' (DbType = Guid), @p205='?' (DbType = DateTime2), @p206='?' (DbType = Int32), @p207='?' (Size = 34), @p208='?' (DbType = Guid), @p209='?' (DbType = Int32), @p210='?' (DbType = Int32), @p211='?' (DbType = Int32), @p212='?' (Size = 4000), @p213='?' (Size = 4000), @p214='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p215='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p216='?' (DbType = Guid), @p217='?' (DbType = DateTime2), @p218='?' (DbType = Int32), @p219='?' (Size = 34), @p220='?' (DbType = Guid), @p221='?' (DbType = Int32), @p222='?' (DbType = Int32), @p223='?' (DbType = Int32), @p224='?' (Size = 4000), @p225='?' (Size = 4000), @p226='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p227='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p228='?' (DbType = Guid), @p229='?' (DbType = DateTime2), @p230='?' (DbType = Int32), @p231='?' (Size = 34), @p232='?' (DbType = Guid), @p233='?' (DbType = Int32), @p234='?' (DbType = Int32), @p235='?' (DbType = Int32), @p236='?' (Size = 4000), @p237='?' (Size = 4000), @p238='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p239='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p240='?' (DbType = Guid), @p241='?' (DbType = DateTime2), @p242='?' (DbType = Int32), @p243='?' (Size = 34), @p244='?' (DbType = Guid), @p245='?' (DbType = Int32), @p246='?' (DbType = Int32), @p247='?' (DbType = Int32), @p248='?' (Size = 4000), @p249='?' (Size = 4000), @p250='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p251='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p252='?' (DbType = Guid), @p253='?' (DbType = DateTime2), @p254='?' (DbType = Int32), @p255='?' (Size = 34), @p256='?' (DbType = Guid), @p257='?' (DbType = Int32), @p258='?' (DbType = Int32), @p259='?' (DbType = Int32), @p260='?' (Size = 4000), @p261='?' (Size = 4000), @p262='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
UPDATE [Products] SET [BarCode] = @p23, [BuyPrice] = @p24, [CategoryId] = @p25, [CreatedById] = @p26, [CreatedDate] = @p27, [DeleteFlag] = @p28, [ExpirationDate] = @p29, [MinimunStock] = @p30, [Name] = @p31, [Note] = @p32, [ProductImage] = @p33, [ProductTaxId] = @p34, [SalePrice] = @p35, [Status] = @p36, [Stock] = @p37, [UpdatedById] = @p38, [UpdatedDate] = @p39
OUTPUT 1
WHERE [Id] = @p40;
UPDATE [Products] SET [BarCode] = @p41, [BuyPrice] = @p42, [CategoryId] = @p43, [CreatedById] = @p44, [CreatedDate] = @p45, [DeleteFlag] = @p46, [ExpirationDate] = @p47, [MinimunStock] = @p48, [Name] = @p49, [Note] = @p50, [ProductImage] = @p51, [ProductTaxId] = @p52, [SalePrice] = @p53, [Status] = @p54, [Stock] = @p55, [UpdatedById] = @p56, [UpdatedDate] = @p57
OUTPUT 1
WHERE [Id] = @p58;
UPDATE [Products] SET [BarCode] = @p59, [BuyPrice] = @p60, [CategoryId] = @p61, [CreatedById] = @p62, [CreatedDate] = @p63, [DeleteFlag] = @p64, [ExpirationDate] = @p65, [MinimunStock] = @p66, [Name] = @p67, [Note] = @p68, [ProductImage] = @p69, [ProductTaxId] = @p70, [SalePrice] = @p71, [Status] = @p72, [Stock] = @p73, [UpdatedById] = @p74, [UpdatedDate] = @p75
OUTPUT 1
WHERE [Id] = @p76;
UPDATE [Products] SET [BarCode] = @p77, [BuyPrice] = @p78, [CategoryId] = @p79, [CreatedById] = @p80, [CreatedDate] = @p81, [DeleteFlag] = @p82, [ExpirationDate] = @p83, [MinimunStock] = @p84, [Name] = @p85, [Note] = @p86, [ProductImage] = @p87, [ProductTaxId] = @p88, [SalePrice] = @p89, [Status] = @p90, [Stock] = @p91, [UpdatedById] = @p92, [UpdatedDate] = @p93
OUTPUT 1
WHERE [Id] = @p94;
UPDATE [Products] SET [BarCode] = @p95, [BuyPrice] = @p96, [CategoryId] = @p97, [CreatedById] = @p98, [CreatedDate] = @p99, [DeleteFlag] = @p100, [ExpirationDate] = @p101, [MinimunStock] = @p102, [Name] = @p103, [Note] = @p104, [ProductImage] = @p105, [ProductTaxId] = @p106, [SalePrice] = @p107, [Status] = @p108, [Stock] = @p109, [UpdatedById] = @p110, [UpdatedDate] = @p111
OUTPUT 1
WHERE [Id] = @p112;
MERGE [SalesDetail] USING (
VALUES (@p113, @p114, @p115, @p116, @p117, @p118, @p119, @p120, @p121, @p122, @p123, @p124, @p125, 0),
(@p126, @p127, @p128, @p129, @p130, @p131, @p132, @p133, @p134, @p135, @p136, @p137, @p138, 1),
(@p139, @p140, @p141, @p142, @p143, @p144, @p145, @p146, @p147, @p148, @p149, @p150, @p151, 2),
(@p152, @p153, @p154, @p155, @p156, @p157, @p158, @p159, @p160, @p161, @p162, @p163, @p164, 3),
(@p165, @p166, @p167, @p168, @p169, @p170, @p171, @p172, @p173, @p174, @p175, @p176, @p177, 4),
(@p178, @p179, @p180, @p181, @p182, @p183, @p184, @p185, @p186, @p187, @p188, @p189, @p190, 5)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[DeleteFlag], i.[DiscountAmount], i.[ProductId], i.[Quantity], i.[SalesId], i.[Tax], i.[Total], i.[UnitPrice], i.[UpdatedById], i.[UpdatedDate])
OUTPUT INSERTED.[Id], i._Position;
MERGE [InventoryMovements] USING (
VALUES (@p191, @p192, @p193, @p194, @p195, @p196, @p197, @p198, @p199, @p200, @p201, @p202, 0),
(@p203, @p204, @p205, @p206, @p207, @p208, @p209, @p210, @p211, @p212, @p213, @p214, 1),
(@p215, @p216, @p217, @p218, @p219, @p220, @p221, @p222, @p223, @p224, @p225, @p226, 2),
(@p227, @p228, @p229, @p230, @p231, @p232, @p233, @p234, @p235, @p236, @p237, @p238, 3),
(@p239, @p240, @p241, @p242, @p243, @p244, @p245, @p246, @p247, @p248, @p249, @p250, 4),
(@p251, @p252, @p253, @p254, @p255, @p256, @p257, @p258, @p259, @p260, @p261, @p262, 5)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[Difference], i.[Discriminator], i.[InventoryMovementHeaderId], i.[NewStock], i.[OriginaStock], i.[ProductId], i.[ProductName], i.[Reazon], i.[SalePrice])
OUTPUT INSERTED.[Id], i._Position;
2026-01-15 20:56:38.093 +00:00 [INF] Setting HTTP status code 201.
2026-01-15 20:56:38.093 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-15 20:56:38.093 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41283 - 201 0 null 190.7818ms
2026-01-15 20:56:38.254 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-15 20:56:38.255 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 20:56:38.255 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 20:56:38.256 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 20:56:38.256 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 300.0119ms
2026-01-15 21:05:41.936 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null
2026-01-15 21:05:41.936 +00:00 [INF] CORS policy execution successful.
2026-01-15 21:05:41.936 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.3921ms
2026-01-15 21:05:42.016 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 61
2026-01-15 21:05:42.016 +00:00 [INF] CORS policy execution successful.
2026-01-15 21:05:42.016 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin'
2026-01-15 21:05:42.245 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName]
FROM [AspNetUsers] AS [a]
WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0
2026-01-15 21:05:42.246 +00:00 [INF] Setting HTTP status code 400.
2026-01-15 21:05:42.246 +00:00 [INF] Writing value of type '<>f__AnonymousType9`1' as Json.
2026-01-15 21:05:42.246 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin'
2026-01-15 21:05:42.247 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 400 null application/json; charset=utf-8 230.5911ms
2026-01-15 21:05:43.356 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 61
2026-01-15 21:05:43.356 +00:00 [INF] CORS policy execution successful.
2026-01-15 21:05:43.357 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin'
2026-01-15 21:05:43.359 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName]
FROM [AspNetUsers] AS [a]
WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0
2026-01-15 21:05:43.360 +00:00 [INF] Setting HTTP status code 400.
2026-01-15 21:05:43.360 +00:00 [INF] Writing value of type '<>f__AnonymousType9`1' as Json.
2026-01-15 21:05:43.360 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin'
2026-01-15 21:05:43.360 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 400 null application/json; charset=utf-8 4.3544ms
2026-01-15 21:05:52.814 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null
2026-01-15 21:05:52.814 +00:00 [INF] CORS policy execution successful.
2026-01-15 21:05:52.814 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.3195ms
2026-01-15 21:05:52.894 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 61
2026-01-15 21:05:52.894 +00:00 [INF] CORS policy execution successful.
2026-01-15 21:05:52.894 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin'
2026-01-15 21:05:52.896 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName]
FROM [AspNetUsers] AS [a]
WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0
2026-01-15 21:05:52.896 +00:00 [INF] Setting HTTP status code 400.
2026-01-15 21:05:52.896 +00:00 [INF] Writing value of type '<>f__AnonymousType9`1' as Json.
2026-01-15 21:05:52.896 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin'
2026-01-15 21:05:52.896 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 400 null application/json; charset=utf-8 2.6144ms
2026-01-15 21:06:07.342 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null
2026-01-15 21:06:07.342 +00:00 [INF] CORS policy execution successful.
2026-01-15 21:06:07.342 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.3514ms
2026-01-15 21:06:07.421 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 61
2026-01-15 21:06:07.421 +00:00 [INF] CORS policy execution successful.
2026-01-15 21:06:07.421 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin'
2026-01-15 21:06:07.424 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName]
FROM [AspNetUsers] AS [a]
WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0
2026-01-15 21:06:07.534 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (Size = 450)], CommandType='"Text"', CommandTimeout='30']
SELECT [a0].[Name]
FROM [AspNetUserRoles] AS [a]
INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id]
WHERE [a].[UserId] = @__userId_0
2026-01-15 21:06:07.534 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 21:06:07.535 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json.
2026-01-15 21:06:07.535 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin'
2026-01-15 21:06:07.535 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 114.0259ms
2026-01-15 21:06:10.453 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 21:06:10.454 +00:00 [INF] CORS policy execution successful.
2026-01-15 21:06:10.454 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3441ms
2026-01-15 21:06:10.529 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null
2026-01-15 21:06:10.529 +00:00 [INF] CORS policy execution successful.
2026-01-15 21:06:10.529 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.8481ms
2026-01-15 21:06:10.530 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null
2026-01-15 21:06:10.530 +00:00 [INF] CORS policy execution successful.
2026-01-15 21:06:10.530 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.3534ms
2026-01-15 21:06:10.530 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2026-01-15 21:06:10.531 +00:00 [INF] CORS policy execution successful.
2026-01-15 21:06:10.531 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.1558ms
2026-01-15 21:06:10.534 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-15 21:06:10.534 +00:00 [INF] CORS policy execution successful.
2026-01-15 21:06:10.535 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 21:06:10.549 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-15 21:06:10.550 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 21:06:10.550 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 21:06:10.550 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-15 21:06:10.550 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 16.033ms
2026-01-15 21:06:10.609 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null
2026-01-15 21:06:10.610 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null
2026-01-15 21:06:10.610 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2026-01-15 21:06:10.610 +00:00 [INF] CORS policy execution successful.
2026-01-15 21:06:10.610 +00:00 [INF] CORS policy execution successful.
2026-01-15 21:06:10.610 +00:00 [INF] CORS policy execution successful.
2026-01-15 21:06:10.611 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities'
2026-01-15 21:06:10.611 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2026-01-15 21:06:10.612 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/'
2026-01-15 21:06:10.613 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [ProductTaxes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-15 21:06:10.614 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 21:06:10.614 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 21:06:10.614 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2026-01-15 21:06:10.614 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 4.5331ms
2026-01-15 21:06:10.619 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate]
FROM [Settings] AS [s]
2026-01-15 21:06:10.619 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 21:06:10.619 +00:00 [INF] Writing value of type 'SettingDto' as Json.
2026-01-15 21:06:10.620 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/'
2026-01-15 21:06:10.620 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 10.4555ms
2026-01-15 21:06:10.630 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [n].[Id], [n].[Descripcion], [n].[Estatus], [n].[Gentilicio], [n].[Siglas]
FROM [Nationalities] AS [n]
2026-01-15 21:06:10.631 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 21:06:10.631 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 21:06:10.631 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities'
2026-01-15 21:06:10.631 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 21.3602ms
2026-01-15 21:06:16.409 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/mega dosis - null null
2026-01-15 21:06:16.409 +00:00 [INF] CORS policy execution successful.
2026-01-15 21:06:16.409 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/mega dosis - 204 null null 0.3488ms
2026-01-15 21:06:16.499 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/mega dosis - null null
2026-01-15 21:06:16.499 +00:00 [INF] CORS policy execution successful.
2026-01-15 21:06:16.499 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 21:06:16.504 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 21:06:16.504 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 21:06:16.504 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 21:06:16.504 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 21:06:16.504 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/mega dosis - 200 null application/json; charset=utf-8 5.6327ms
2026-01-15 21:06:21.528 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/dosi - null null
2026-01-15 21:06:21.528 +00:00 [INF] CORS policy execution successful.
2026-01-15 21:06:21.528 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/dosi - 204 null null 0.2706ms
2026-01-15 21:06:21.607 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/dosi - null null
2026-01-15 21:06:21.608 +00:00 [INF] CORS policy execution successful.
2026-01-15 21:06:21.608 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 21:06:21.612 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-15 21:06:21.614 +00:00 [INF] Setting HTTP status code 200.
2026-01-15 21:06:21.614 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-15 21:06:21.615 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-15 21:06:21.615 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/dosi - 200 null application/json; charset=utf-8 7.4055ms