2025-11-21 01:20:32.382 +00:00 [INF] Request starting HTTP/1.1 GET http://localhost:5227/.env - null null
2025-11-21 01:20:32.386 +00:00 [INF] Request finished HTTP/1.1 GET http://localhost:5227/.env - 404 0 null 4.1456ms
2025-11-21 01:20:32.387 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://localhost:5227/.env, Response status code: 404
2025-11-21 04:03:50.908 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33/ - null null
2025-11-21 04:03:50.908 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33/ - 404 0 null 0.3753ms
2025-11-21 04:03:50.908 +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/, Response status code: 404
2025-11-21 04:03:52.606 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/favicon.ico - null null
2025-11-21 04:03:52.607 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/favicon.ico - 404 0 null 0.3678ms
2025-11-21 04:03:52.607 +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/favicon.ico, Response status code: 404
2025-11-21 06:56:36.460 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2025-11-21 06:56:36.461 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.8118ms
2025-11-21 06:56:36.461 +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
2025-11-21 06:57:11.957 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/sitemap.xml - null null
2025-11-21 06:57:11.957 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/sitemap.xml - 404 0 null 0.2628ms
2025-11-21 06:57:11.957 +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/sitemap.xml, Response status code: 404
2025-11-21 07:20:41.956 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2025-11-21 07:20:41.957 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.2794ms
2025-11-21 07:20:41.957 +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
2025-11-21 07:20:52.085 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2025-11-21 07:20:52.085 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.2889ms
2025-11-21 07:20:52.085 +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
2025-11-21 07:20:57.325 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/.well-known/security.txt - null null
2025-11-21 07:20:57.325 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/.well-known/security.txt - 404 0 null 0.2712ms
2025-11-21 07:20:57.325 +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/.well-known/security.txt, Response status code: 404
2025-11-21 13:03:48.640 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null
2025-11-21 13:03:48.640 +00:00 [INF] CORS policy execution successful.
2025-11-21 13:03:48.640 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.2882ms
2025-11-21 13:03:48.700 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 65
2025-11-21 13:03:48.700 +00:00 [INF] CORS policy execution successful.
2025-11-21 13:03:48.700 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin'
2025-11-21 13:03:48.997 +00:00 [INF] Executed DbCommand (6ms) [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
2025-11-21 13:03:49.128 +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
2025-11-21 13:03:49.129 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 13:03:49.129 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json.
2025-11-21 13:03:49.129 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin'
2025-11-21 13:03:49.129 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 429.3381ms
2025-11-21 13:35:59.557 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2025-11-21 13:35:59.557 +00:00 [INF] CORS policy execution successful.
2025-11-21 13:35:59.558 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.3343ms
2025-11-21 13:35:59.558 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null
2025-11-21 13:35:59.558 +00:00 [INF] CORS policy execution successful.
2025-11-21 13:35:59.558 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.0694ms
2025-11-21 13:35:59.558 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-21 13:35:59.558 +00:00 [INF] CORS policy execution successful.
2025-11-21 13:35:59.558 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.0554ms
2025-11-21 13:35:59.557 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null
2025-11-21 13:35:59.558 +00:00 [INF] CORS policy execution successful.
2025-11-21 13:35:59.558 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.8179ms
2025-11-21 13:35:59.621 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-21 13:35:59.621 +00:00 [INF] CORS policy execution successful.
2025-11-21 13:35:59.622 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null
2025-11-21 13:35:59.622 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2025-11-21 13:35:59.622 +00:00 [INF] CORS policy execution successful.
2025-11-21 13:35:59.622 +00:00 [INF] CORS policy execution successful.
2025-11-21 13:35:59.622 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2025-11-21 13:35:59.622 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities'
2025-11-21 13:35:59.623 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-21 13:35:59.624 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null
2025-11-21 13:35:59.624 +00:00 [INF] CORS policy execution successful.
2025-11-21 13:35:59.625 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/'
2025-11-21 13:35:59.943 +00:00 [INF] Executed DbCommand (4ms) [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)
2025-11-21 13:35:59.943 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 13:35:59.943 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 13:35:59.944 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-21 13:35:59.944 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 322.6357ms
2025-11-21 13:35:59.955 +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]
2025-11-21 13:35:59.956 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 13:35:59.957 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 13:35:59.957 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities'
2025-11-21 13:35:59.957 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 334.9288ms
2025-11-21 13:35:59.957 +00:00 [INF] Executed DbCommand (2ms) [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)
2025-11-21 13:35:59.957 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 13:35:59.957 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 13:35:59.957 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2025-11-21 13:35:59.957 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 335.2955ms
2025-11-21 13:35:59.959 +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]
2025-11-21 13:35:59.960 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 13:35:59.960 +00:00 [INF] Writing value of type 'SettingDto' as Json.
2025-11-21 13:35:59.960 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/'
2025-11-21 13:35:59.960 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 335.5439ms
2025-11-21 13:36:02.896 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/c - null null
2025-11-21 13:36:02.896 +00:00 [INF] CORS policy execution successful.
2025-11-21 13:36:02.896 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/c - 204 null null 0.3835ms
2025-11-21 13:36:02.954 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/c - null null
2025-11-21 13:36:02.954 +00:00 [INF] CORS policy execution successful.
2025-11-21 13:36:02.955 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 13:36:02.960 +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'\'))
2025-11-21 13:36:03.107 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 13:36:03.108 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 13:36:03.621 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 13:36:03.622 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/c - 200 null application/json; charset=utf-8 667.6592ms
2025-11-21 13:36:10.179 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/picolinate - null null
2025-11-21 13:36:10.179 +00:00 [INF] CORS policy execution successful.
2025-11-21 13:36:10.179 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/picolinate - 204 null null 0.3055ms
2025-11-21 13:36:10.239 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/picolinate - null null
2025-11-21 13:36:10.239 +00:00 [INF] CORS policy execution successful.
2025-11-21 13:36:10.239 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 13:36:10.247 +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'\'))
2025-11-21 13:36:10.247 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 13:36:10.247 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 13:36:10.247 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 13:36:10.247 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/picolinate - 200 null application/json; charset=utf-8 8.6041ms
2025-11-21 13:36:18.560 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/chro - null null
2025-11-21 13:36:18.560 +00:00 [INF] CORS policy execution successful.
2025-11-21 13:36:18.561 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/chro - 204 null null 0.5027ms
2025-11-21 13:36:18.627 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/chro - null null
2025-11-21 13:36:18.627 +00:00 [INF] CORS policy execution successful.
2025-11-21 13:36:18.627 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 13:36:18.632 +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'\'))
2025-11-21 13:36:18.635 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 13:36:18.635 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 13:36:18.635 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 13:36:18.635 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/chro - 200 null application/json; charset=utf-8 8.69ms
2025-11-21 13:36:20.456 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - null null
2025-11-21 13:36:20.457 +00:00 [INF] CORS policy execution successful.
2025-11-21 13:36:20.457 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - 204 null null 0.2762ms
2025-11-21 13:36:20.516 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - null null
2025-11-21 13:36:20.517 +00:00 [INF] CORS policy execution successful.
2025-11-21 13:36:20.517 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2025-11-21 13:36:20.517 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2025-11-21 13:36:20.517 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - 400 0 null 0.7635ms
2025-11-21 13:36:31.738 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/presion/ - null null
2025-11-21 13:36:31.739 +00:00 [INF] CORS policy execution successful.
2025-11-21 13:36:31.739 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/presion/ - 204 null null 0.3374ms
2025-11-21 13:36:31.804 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/presion/ - null null
2025-11-21 13:36:31.804 +00:00 [INF] CORS policy execution successful.
2025-11-21 13:36:31.805 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 13:36:31.808 +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'\'))
2025-11-21 13:36:31.811 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 13:36:31.811 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 13:36:31.811 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 13:36:31.812 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/presion/ - 200 null application/json; charset=utf-8 7.6653ms
2025-11-21 14:00:52.459 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-21 14:00:52.461 +00:00 [INF] CORS policy execution successful.
2025-11-21 14:00:52.461 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 1.8247ms
2025-11-21 14:00:52.519 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-21 14:00:52.519 +00:00 [INF] CORS policy execution successful.
2025-11-21 14:00:52.520 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-21 14:00:52.859 +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)
2025-11-21 14:00:52.860 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 14:00:52.860 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 14:00:52.860 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-21 14:00:52.861 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 341.5699ms
2025-11-21 14:00:59.068 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/control - null null
2025-11-21 14:00:59.068 +00:00 [INF] CORS policy execution successful.
2025-11-21 14:00:59.068 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/control - 204 null null 0.2956ms
2025-11-21 14:00:59.125 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/control - null null
2025-11-21 14:00:59.125 +00:00 [INF] CORS policy execution successful.
2025-11-21 14:00:59.126 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 14:00:59.131 +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'\'))
2025-11-21 14:00:59.134 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 14:00:59.135 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 14:00:59.135 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 14:00:59.135 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/control - 200 null application/json; charset=utf-8 9.8539ms
2025-11-21 14:01:08.536 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/picolinate - null null
2025-11-21 14:01:08.536 +00:00 [INF] CORS policy execution successful.
2025-11-21 14:01:08.536 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/picolinate - 204 null null 0.3911ms
2025-11-21 14:01:08.596 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/picolinate - null null
2025-11-21 14:01:08.596 +00:00 [INF] CORS policy execution successful.
2025-11-21 14:01:08.596 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 14:01:08.601 +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'\'))
2025-11-21 14:01:08.602 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 14:01:08.602 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 14:01:08.602 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 14:01:08.602 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/picolinate - 200 null application/json; charset=utf-8 6.1595ms
2025-11-21 14:01:14.295 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/chro - null null
2025-11-21 14:01:14.295 +00:00 [INF] CORS policy execution successful.
2025-11-21 14:01:14.295 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/chro - 204 null null 0.2976ms
2025-11-21 14:01:14.354 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/chro - null null
2025-11-21 14:01:14.355 +00:00 [INF] CORS policy execution successful.
2025-11-21 14:01:14.355 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 14:01:14.361 +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'\'))
2025-11-21 14:01:14.363 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 14:01:14.363 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 14:01:14.363 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 14:01:14.364 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/chro - 200 null application/json; charset=utf-8 8.9235ms
2025-11-21 14:01:49.798 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-11-21 14:01:49.798 +00:00 [INF] CORS policy execution successful.
2025-11-21 14:01:49.798 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3738ms
2025-11-21 14:01:49.857 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2025-11-21 14:01:49.857 +00:00 [INF] CORS policy execution successful.
2025-11-21 14:01:49.857 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-11-21 14:01:49.863 +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);
2025-11-21 14:01:49.867 +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);
2025-11-21 14:01:49.867 +00:00 [INF] Setting HTTP status code 201.
2025-11-21 14:01:49.867 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-11-21 14:01:49.867 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-11-21 14:01:49.867 +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.7271ms
2025-11-21 14:01:49.933 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40976 - null null
2025-11-21 14:01:49.933 +00:00 [INF] CORS policy execution successful.
2025-11-21 14:01:49.933 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40976 - 204 null null 0.3407ms
2025-11-21 14:01:49.990 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-21 14:01:49.990 +00:00 [INF] CORS policy execution successful.
2025-11-21 14:01:49.990 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3325ms
2025-11-21 14:01:49.997 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40976 - application/json 205
2025-11-21 14:01:49.997 +00:00 [INF] CORS policy execution successful.
2025-11-21 14:01:49.997 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-21 14:01:49.999 +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)
2025-11-21 14:01:50.046 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-21 14:01:50.047 +00:00 [INF] CORS policy execution successful.
2025-11-21 14:01:50.047 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-21 14:01:50.068 +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)
2025-11-21 14:01:50.069 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 14:01:50.069 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 14:01:50.069 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-21 14:01:50.069 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 22.5303ms
2025-11-21 14:01:50.163 +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))'.
2025-11-21 14:01:50.169 +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;
2025-11-21 14:01:50.174 +00:00 [INF] Setting HTTP status code 201.
2025-11-21 14:01:50.175 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-21 14:01:50.175 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40976 - 201 0 null 178.4186ms
2025-11-21 16:47:57.401 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/G-4 - null null
2025-11-21 16:47:57.402 +00:00 [INF] CORS policy execution successful.
2025-11-21 16:47:57.402 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/G-4 - 204 null null 0.2736ms
2025-11-21 16:47:57.461 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/G-4 - null null
2025-11-21 16:47:57.462 +00:00 [INF] CORS policy execution successful.
2025-11-21 16:47:57.462 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 16:47:57.772 +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'\'))
2025-11-21 16:47:57.778 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 16:47:57.778 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 16:47:57.779 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 16:47:57.779 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/G-4 - 200 null application/json; charset=utf-8 317.5197ms
2025-11-21 16:48:40.813 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1504 - null null
2025-11-21 16:48:40.813 +00:00 [INF] CORS policy execution successful.
2025-11-21 16:48:40.813 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1504 - 204 null null 0.4276ms
2025-11-21 16:48:40.882 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/1504 - null null
2025-11-21 16:48:40.883 +00:00 [INF] CORS policy execution successful.
2025-11-21 16:48:40.883 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2025-11-21 16:48:40.892 +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
2025-11-21 16:48:40.893 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 16:48:40.893 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json.
2025-11-21 16:48:40.894 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2025-11-21 16:48:40.894 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/1504 - 200 null application/json; charset=utf-8 11.2024ms
2025-11-21 16:48:57.439 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-11-21 16:48:57.440 +00:00 [INF] CORS policy execution successful.
2025-11-21 16:48:57.440 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3406ms
2025-11-21 16:48:57.499 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2025-11-21 16:48:57.499 +00:00 [INF] CORS policy execution successful.
2025-11-21 16:48:57.499 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-11-21 16:48:57.509 +00:00 [INF] Executed DbCommand (8ms) [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);
2025-11-21 16:48:57.515 +00:00 [INF] Executed DbCommand (4ms) [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);
2025-11-21 16:48:57.516 +00:00 [INF] Setting HTTP status code 201.
2025-11-21 16:48:57.517 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-11-21 16:48:57.517 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-11-21 16:48:57.517 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 18.6997ms
2025-11-21 16:48:57.589 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40977 - null null
2025-11-21 16:48:57.589 +00:00 [INF] CORS policy execution successful.
2025-11-21 16:48:57.589 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40977 - 204 null null 0.7472ms
2025-11-21 16:48:57.649 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-21 16:48:57.649 +00:00 [INF] CORS policy execution successful.
2025-11-21 16:48:57.649 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3933ms
2025-11-21 16:48:57.668 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40977 - application/json 106
2025-11-21 16:48:57.669 +00:00 [INF] CORS policy execution successful.
2025-11-21 16:48:57.669 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-21 16:48:57.671 +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)
2025-11-21 16:48:57.708 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-21 16:48:57.709 +00:00 [INF] CORS policy execution successful.
2025-11-21 16:48:57.709 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-21 16:48:57.733 +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)
2025-11-21 16:48:57.734 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 16:48:57.734 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 16:48:57.734 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-21 16:48:57.734 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 26.0705ms
2025-11-21 16:48:57.849 +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))'.
2025-11-21 16:48:57.852 +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);
2025-11-21 16:48:57.857 +00:00 [INF] Setting HTTP status code 201.
2025-11-21 16:48:57.857 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-21 16:48:57.857 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40977 - 201 0 null 188.6071ms
2025-11-21 17:47:14.352 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/allery - null null
2025-11-21 17:47:14.353 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:47:14.353 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/allery - 204 null null 0.3311ms
2025-11-21 17:47:14.410 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/allery - null null
2025-11-21 17:47:14.411 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:47:14.411 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:47:14.648 +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'\'))
2025-11-21 17:47:14.648 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 17:47:14.648 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 17:47:14.648 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:47:14.648 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/allery - 200 null application/json; charset=utf-8 237.8784ms
2025-11-21 17:47:18.791 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/allrer - null null
2025-11-21 17:47:18.791 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:47:18.791 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/allrer - 204 null null 0.2657ms
2025-11-21 17:47:18.851 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/allrer - null null
2025-11-21 17:47:18.851 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:47:18.851 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:47:18.856 +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'\'))
2025-11-21 17:47:18.856 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 17:47:18.856 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 17:47:18.856 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:47:18.856 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/allrer - 200 null application/json; charset=utf-8 5.0378ms
2025-11-21 17:47:22.510 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/clean - null null
2025-11-21 17:47:22.510 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:47:22.510 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/clean - 204 null null 0.2928ms
2025-11-21 17:47:22.570 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/clean - null null
2025-11-21 17:47:22.570 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:47:22.571 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:47:22.575 +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'\'))
2025-11-21 17:47:22.578 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 17:47:22.578 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 17:47:22.578 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:47:22.579 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/clean - 200 null application/json; charset=utf-8 8.5213ms
2025-11-21 17:47:31.082 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan de - null null
2025-11-21 17:47:31.083 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:47:31.083 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan de - 204 null null 0.2742ms
2025-11-21 17:47:31.148 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan de - null null
2025-11-21 17:47:31.148 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:47:31.149 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:47:31.153 +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'\'))
2025-11-21 17:47:31.157 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 17:47:31.158 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 17:47:31.277 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:47:31.277 +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 129.3243ms
2025-11-21 17:47:41.616 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1561 - null null
2025-11-21 17:47:41.617 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:47:41.617 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1561 - 204 null null 0.3067ms
2025-11-21 17:47:41.679 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/1561 - null null
2025-11-21 17:47:41.679 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:47:41.680 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2025-11-21 17:47:41.682 +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
2025-11-21 17:47:41.683 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 17:47:41.684 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json.
2025-11-21 17:47:41.684 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2025-11-21 17:47:41.684 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/1561 - 200 null application/json; charset=utf-8 5.2733ms
2025-11-21 17:47:49.604 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/kefir - null null
2025-11-21 17:47:49.604 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:47:49.605 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/kefir - 204 null null 0.2898ms
2025-11-21 17:47:49.674 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/kefir - null null
2025-11-21 17:47:49.674 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:47:49.675 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:47:49.679 +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'\'))
2025-11-21 17:47:49.679 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 17:47:49.679 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 17:47:49.680 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:47:49.680 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/kefir - 200 null application/json; charset=utf-8 5.5905ms
2025-11-21 17:48:00.833 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/crask - null null
2025-11-21 17:48:00.833 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:48:00.833 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/crask - 204 null null 0.3213ms
2025-11-21 17:48:00.895 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/crask - null null
2025-11-21 17:48:00.895 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:48:00.895 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:48:00.901 +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'\'))
2025-11-21 17:48:00.901 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 17:48:00.901 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 17:48:00.901 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:48:00.901 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/crask - 200 null application/json; charset=utf-8 6.525ms
2025-11-21 17:48:04.639 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/cra - null null
2025-11-21 17:48:04.639 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:48:04.639 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/cra - 204 null null 0.3397ms
2025-11-21 17:48:04.702 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/cra - null null
2025-11-21 17:48:04.703 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:48:04.703 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:48:04.706 +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'\'))
2025-11-21 17:48:04.712 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 17:48:04.712 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 17:48:04.713 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:48:04.713 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/cra - 200 null application/json; charset=utf-8 10.9867ms
2025-11-21 17:48:18.565 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/galleta - null null
2025-11-21 17:48:18.565 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:48:18.565 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/galleta - 204 null null 0.2736ms
2025-11-21 17:48:18.631 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/galleta - null null
2025-11-21 17:48:18.631 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:48:18.631 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:48:18.634 +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'\'))
2025-11-21 17:48:18.640 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 17:48:18.640 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 17:48:18.751 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:48:18.751 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/galleta - 200 null application/json; charset=utf-8 120.5118ms
2025-11-21 17:48:57.817 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/coco - null null
2025-11-21 17:48:57.817 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:48:57.817 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/coco - 204 null null 0.5751ms
2025-11-21 17:48:57.880 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/coco - null null
2025-11-21 17:48:57.880 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:48:57.880 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:48:57.883 +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'\'))
2025-11-21 17:48:57.891 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 17:48:57.891 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 17:48:58.057 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:48:58.058 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/coco - 200 null application/json; charset=utf-8 178.169ms
2025-11-21 17:49:14.160 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/orregab - null null
2025-11-21 17:49:14.160 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:49:14.160 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/orregab - 204 null null 0.2345ms
2025-11-21 17:49:14.226 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/orregab - null null
2025-11-21 17:49:14.227 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:49:14.227 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:49:14.232 +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'\'))
2025-11-21 17:49:14.232 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 17:49:14.232 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 17:49:14.232 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:49:14.232 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/orregab - 200 null application/json; charset=utf-8 6.5212ms
2025-11-21 17:49:18.963 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/oregano - null null
2025-11-21 17:49:18.963 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:49:18.963 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/oregano - 204 null null 0.2852ms
2025-11-21 17:49:19.025 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/oregano - null null
2025-11-21 17:49:19.025 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:49:19.025 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:49:19.028 +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'\'))
2025-11-21 17:49:19.034 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 17:49:19.034 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 17:49:19.034 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:49:19.035 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/oregano - 200 null application/json; charset=utf-8 9.6331ms
2025-11-21 17:49:35.013 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/vitamina C - null null
2025-11-21 17:49:35.013 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:49:35.013 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/vitamina C - 204 null null 0.2671ms
2025-11-21 17:49:35.072 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/vitamina C - null null
2025-11-21 17:49:35.072 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:49:35.072 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:49:35.076 +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'\'))
2025-11-21 17:49:35.084 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 17:49:35.084 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 17:49:35.084 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:49:35.085 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/vitamina C - 200 null application/json; charset=utf-8 12.8466ms
2025-11-21 17:50:51.466 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-21 17:50:51.466 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:50:51.466 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2433ms
2025-11-21 17:50:51.525 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-21 17:50:51.525 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:50:51.526 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-21 17:50:51.527 +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)
2025-11-21 17:50:51.528 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 17:50:51.528 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 17:50:51.528 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-21 17:50:51.528 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 3.2811ms
2025-11-21 17:51:02.913 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jara - null null
2025-11-21 17:51:02.914 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:51:02.914 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jara - 204 null null 0.8882ms
2025-11-21 17:51:02.983 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/jara - null null
2025-11-21 17:51:02.983 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:51:02.983 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:51:02.989 +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'\'))
2025-11-21 17:51:02.991 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 17:51:02.992 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 17:51:02.992 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:51:02.992 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/jara - 200 null application/json; charset=utf-8 9.3652ms
2025-11-21 17:51:04.372 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - null null
2025-11-21 17:51:04.373 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:51:04.373 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - 204 null null 0.8779ms
2025-11-21 17:51:04.432 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - null null
2025-11-21 17:51:04.433 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:51:04.433 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2025-11-21 17:51:04.434 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2025-11-21 17:51:04.434 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - 400 0 null 1.6599ms
2025-11-21 17:51:26.042 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/kefir - null null
2025-11-21 17:51:26.042 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:51:26.042 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/kefir - 204 null null 0.3105ms
2025-11-21 17:51:26.107 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/kefir - null null
2025-11-21 17:51:26.108 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:51:26.108 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:51:26.113 +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'\'))
2025-11-21 17:51:26.114 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 17:51:26.115 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 17:51:26.115 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:51:26.115 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/kefir - 200 null application/json; charset=utf-8 7.7254ms
2025-11-21 17:51:32.415 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/galleta - null null
2025-11-21 17:51:32.415 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:51:32.416 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/galleta - 204 null null 0.3309ms
2025-11-21 17:51:32.481 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/galleta - null null
2025-11-21 17:51:32.481 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:51:32.481 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:51:32.484 +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'\'))
2025-11-21 17:51:32.490 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 17:51:32.491 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 17:51:32.491 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:51:32.492 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/galleta - 200 null application/json; charset=utf-8 11.0086ms
2025-11-21 17:51:39.048 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - null null
2025-11-21 17:51:39.048 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:51:39.048 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - 204 null null 0.2266ms
2025-11-21 17:51:39.115 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan - null null
2025-11-21 17:51:39.115 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:51:39.115 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:51:39.118 +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'\'))
2025-11-21 17:51:39.124 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 17:51:39.124 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 17:51:39.125 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:51:39.125 +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 10.3651ms
2025-11-21 17:51:43.744 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1561 - null null
2025-11-21 17:51:43.744 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:51:43.744 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1561 - 204 null null 0.4773ms
2025-11-21 17:51:43.804 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/1561 - null null
2025-11-21 17:51:43.804 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:51:43.804 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2025-11-21 17:51:43.807 +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
2025-11-21 17:51:43.808 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 17:51:43.808 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json.
2025-11-21 17:51:43.808 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2025-11-21 17:51:43.808 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/1561 - 200 null application/json; charset=utf-8 4.0181ms
2025-11-21 17:51:50.446 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/aller - null null
2025-11-21 17:51:50.446 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:51:50.446 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/aller - 204 null null 0.2705ms
2025-11-21 17:51:50.512 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/aller - null null
2025-11-21 17:51:50.512 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:51:50.513 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:51:50.515 +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'\'))
2025-11-21 17:51:50.518 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 17:51:50.518 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 17:51:50.518 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 17:51:50.518 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/aller - 200 null application/json; charset=utf-8 6.0494ms
2025-11-21 17:57:07.344 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-21 17:57:07.344 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:57:07.345 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3749ms
2025-11-21 17:57:07.404 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-21 17:57:07.405 +00:00 [INF] CORS policy execution successful.
2025-11-21 17:57:07.405 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-21 17:57:07.723 +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)
2025-11-21 17:57:07.724 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 17:57:07.724 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 17:57:07.724 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-21 17:57:07.724 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 319.4598ms
2025-11-21 19:25:40.165 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/probiti - null null
2025-11-21 19:25:40.166 +00:00 [INF] CORS policy execution successful.
2025-11-21 19:25:40.166 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/probiti - 204 null null 0.335ms
2025-11-21 19:25:40.226 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/probiti - null null
2025-11-21 19:25:40.226 +00:00 [INF] CORS policy execution successful.
2025-11-21 19:25:40.226 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 19:25:40.501 +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'\'))
2025-11-21 19:25:40.502 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 19:25:40.502 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 19:25:40.502 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 19:25:40.502 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/probiti - 200 null application/json; charset=utf-8 276.6051ms
2025-11-21 19:25:41.219 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - null null
2025-11-21 19:25:41.219 +00:00 [INF] CORS policy execution successful.
2025-11-21 19:25:41.219 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - 204 null null 0.2266ms
2025-11-21 19:25:41.279 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - null null
2025-11-21 19:25:41.279 +00:00 [INF] CORS policy execution successful.
2025-11-21 19:25:41.279 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2025-11-21 19:25:41.279 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2025-11-21 19:25:41.279 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - 400 0 null 0.6377ms
2025-11-21 19:25:47.414 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/probiotic - null null
2025-11-21 19:25:47.415 +00:00 [INF] CORS policy execution successful.
2025-11-21 19:25:47.415 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/probiotic - 204 null null 0.8996ms
2025-11-21 19:25:47.477 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/probiotic - null null
2025-11-21 19:25:47.477 +00:00 [INF] CORS policy execution successful.
2025-11-21 19:25:47.478 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 19:25:47.482 +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'\'))
2025-11-21 19:25:47.485 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 19:25:47.485 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 19:25:47.485 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-21 19:25:47.485 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/probiotic - 200 null application/json; charset=utf-8 8.0782ms
2025-11-21 19:26:56.820 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-21 19:26:56.821 +00:00 [INF] CORS policy execution successful.
2025-11-21 19:26:56.821 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3449ms
2025-11-21 19:26:56.879 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-21 19:26:56.880 +00:00 [INF] CORS policy execution successful.
2025-11-21 19:26:56.880 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-21 19:26:56.882 +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)
2025-11-21 19:26:56.882 +00:00 [INF] Setting HTTP status code 200.
2025-11-21 19:26:56.882 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-21 19:26:56.882 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-21 19:26:56.883 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 3.1036ms
2025-11-21 22:40:37.764 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2025-11-21 22:40:37.765 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.2984ms
2025-11-21 22:40:37.765 +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