2025-12-29 00:51:14.984 +00:00 [INF] Request starting HTTP/1.1 GET http://localhost:5227/.env - null null
2025-12-29 00:51:14.990 +00:00 [INF] Request finished HTTP/1.1 GET http://localhost:5227/.env - 404 0 null 5.6756ms
2025-12-29 00:51:14.990 +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-12-29 02:28:26.437 +00:00 [INF] Request starting HTTP/1.0 GET http:/// - null null
2025-12-29 02:28:26.438 +00:00 [INF] Request finished HTTP/1.0 GET http:/// - 404 0 null 1.9272ms
2025-12-29 02:28:26.438 +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
2025-12-29 05:09:57.300 +00:00 [INF] Request starting HTTP/1.1 GET http://localhost:5227/.env - null null
2025-12-29 05:09:57.300 +00:00 [INF] Request finished HTTP/1.1 GET http://localhost:5227/.env - 404 0 null 0.3364ms
2025-12-29 05:09:57.300 +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-12-29 07:30:36.228 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2025-12-29 07:30:36.229 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 1.1165ms
2025-12-29 07:30:36.229 +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-12-29 07:30:48.222 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2025-12-29 07:30:48.222 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.2965ms
2025-12-29 07:30:48.222 +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-12-29 07:30:51.727 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/robots.txt - null null
2025-12-29 07:30:51.727 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/robots.txt - 404 0 null 0.3779ms
2025-12-29 07:30:51.727 +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/robots.txt, Response status code: 404
2025-12-29 08:00:18.831 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2025-12-29 08:00:18.832 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 1.5618ms
2025-12-29 08:00:18.832 +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-12-29 08:00:27.252 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/robots.txt - null null
2025-12-29 08:00:27.253 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/robots.txt - 404 0 null 0.9465ms
2025-12-29 08:00:27.253 +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/robots.txt, Response status code: 404
2025-12-29 17:11:46.744 +00:00 [INF] Request starting HTTP/1.0 GET http:/// - null null
2025-12-29 17:11:46.745 +00:00 [INF] Request finished HTTP/1.0 GET http:/// - 404 0 null 1.1423ms
2025-12-29 17:11:46.746 +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
2025-12-29 17:58:40.841 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null
2025-12-29 17:58:40.842 +00:00 [INF] CORS policy execution successful.
2025-12-29 17:58:40.842 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.7859ms
2025-12-29 17:58:40.898 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 61
2025-12-29 17:58:40.898 +00:00 [INF] CORS policy execution successful.
2025-12-29 17:58:40.898 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin'
2025-12-29 17:58:41.209 +00:00 [INF] Executed DbCommand (9ms) [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-12-29 17:58:41.211 +00:00 [INF] Setting HTTP status code 400.
2025-12-29 17:58:41.211 +00:00 [INF] Writing value of type '<>f__AnonymousType9`1' as Json.
2025-12-29 17:58:41.211 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin'
2025-12-29 17:58:41.212 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 400 null application/json; charset=utf-8 313.6643ms
2025-12-29 18:00:08.742 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null
2025-12-29 18:00:08.743 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:00:08.743 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.9686ms
2025-12-29 18:00:08.809 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 61
2025-12-29 18:00:08.809 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:00:08.810 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin'
2025-12-29 18:00:08.816 +00:00 [INF] Executed DbCommand (5ms) [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-12-29 18:00:08.949 +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
2025-12-29 18:00:08.951 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:00:08.951 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json.
2025-12-29 18:00:08.951 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin'
2025-12-29 18:00:08.952 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 142.8282ms
2025-12-29 18:02:28.104 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-12-29 18:02:28.105 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:02:28.105 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 1.151ms
2025-12-29 18:02:28.106 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2025-12-29 18:02:28.106 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:02:28.106 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.2169ms
2025-12-29 18:02:28.108 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null
2025-12-29 18:02:28.108 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:02:28.109 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.4143ms
2025-12-29 18:02:28.118 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null
2025-12-29 18:02:28.118 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:02:28.118 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.2862ms
2025-12-29 18:02:28.167 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-12-29 18:02:28.168 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:02:28.167 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2025-12-29 18:02:28.168 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:02:28.169 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null
2025-12-29 18:02:28.169 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:02:28.169 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/'
2025-12-29 18:02:28.170 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2025-12-29 18:02:28.169 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-12-29 18:02:28.179 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null
2025-12-29 18:02:28.179 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:02:28.179 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities'
2025-12-29 18:02:28.192 +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-12-29 18:02:28.192 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:02:28.193 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:02:28.193 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-12-29 18:02:28.193 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 25.5549ms
2025-12-29 18:02:28.199 +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-12-29 18:02:28.199 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:02:28.199 +00:00 [INF] Writing value of type 'SettingDto' as Json.
2025-12-29 18:02:28.199 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/'
2025-12-29 18:02:28.199 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 30.4461ms
2025-12-29 18:02:28.204 +00:00 [INF] Executed DbCommand (7ms) [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-12-29 18:02:28.205 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:02:28.205 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:02:28.205 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2025-12-29 18:02:28.205 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 37.6523ms
2025-12-29 18:02:28.211 +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-12-29 18:02:28.212 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:02:28.212 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:02:28.212 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities'
2025-12-29 18:02:28.212 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 33.0191ms
2025-12-29 18:02:31.694 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/coc - null null
2025-12-29 18:02:31.695 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:02:31.696 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/coc - 204 null null 1.0448ms
2025-12-29 18:02:31.767 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/coc - null null
2025-12-29 18:02:31.767 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:02:31.768 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:02:31.772 +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-12-29 18:02:31.780 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:02:31.780 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:02:31.943 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:02:31.943 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/coc - 200 null application/json; charset=utf-8 176.1373ms
2025-12-29 18:02:33.040 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/po - null null
2025-12-29 18:02:33.041 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:02:33.041 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/po - 204 null null 0.3228ms
2025-12-29 18:02:33.100 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/po - null null
2025-12-29 18:02:33.100 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:02:33.101 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:02:33.103 +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'\'))
2025-12-29 18:02:33.120 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:02:33.120 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:02:33.388 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:02:33.388 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/po - 200 null application/json; charset=utf-8 288.214ms
2025-12-29 18:02:36.736 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/coco - null null
2025-12-29 18:02:36.737 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:02:36.737 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/coco - 204 null null 1.2928ms
2025-12-29 18:02:36.796 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/coco - null null
2025-12-29 18:02:36.796 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:02:36.797 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:02:36.800 +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-12-29 18:02:36.809 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:02:36.809 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:02:36.809 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:02:36.809 +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 13.4208ms
2025-12-29 18:02:58.261 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/magnesio - null null
2025-12-29 18:02:58.261 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:02:58.262 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/magnesio - 204 null null 0.284ms
2025-12-29 18:02:58.331 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/magnesio - null null
2025-12-29 18:02:58.331 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:02:58.331 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:02:58.334 +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'\'))
2025-12-29 18:02:58.341 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:02:58.342 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:02:58.342 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:02:58.342 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/magnesio - 200 null application/json; charset=utf-8 11.5094ms
2025-12-29 18:03:20.842 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colego - null null
2025-12-29 18:03:20.842 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:03:20.842 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colego - 204 null null 0.3844ms
2025-12-29 18:03:20.906 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/colego - null null
2025-12-29 18:03:20.906 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:03:20.907 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:03:20.911 +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-12-29 18:03:20.912 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:03:20.912 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:03:20.912 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:03:20.913 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/colego - 200 null application/json; charset=utf-8 6.3713ms
2025-12-29 18:03:23.646 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/co - null null
2025-12-29 18:03:23.646 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:03:23.646 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/co - 204 null null 0.289ms
2025-12-29 18:03:23.709 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/co - null null
2025-12-29 18:03:23.709 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:03:23.709 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:03:23.711 +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'\'))
2025-12-29 18:03:23.756 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:03:23.756 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:03:24.119 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:03:24.119 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/co - 200 null application/json; charset=utf-8 410.3976ms
2025-12-29 18:03:28.125 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colagemn - null null
2025-12-29 18:03:28.125 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:03:28.125 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colagemn - 204 null null 0.3912ms
2025-12-29 18:03:28.184 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/colagemn - null null
2025-12-29 18:03:28.184 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:03:28.185 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:03:28.190 +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-12-29 18:03:28.190 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:03:28.190 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:03:28.190 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:03:28.190 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/colagemn - 200 null application/json; charset=utf-8 6.2679ms
2025-12-29 18:03:32.601 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colageno - null null
2025-12-29 18:03:32.601 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:03:32.601 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colageno - 204 null null 0.3461ms
2025-12-29 18:03:32.658 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/colageno - null null
2025-12-29 18:03:32.658 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:03:32.658 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:03:32.662 +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-12-29 18:03:32.666 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:03:32.666 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:03:32.666 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:03:32.666 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/colageno - 200 null application/json; charset=utf-8 8.7452ms
2025-12-29 18:14:04.075 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/as - null null
2025-12-29 18:14:04.076 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:14:04.076 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/as - 204 null null 0.494ms
2025-12-29 18:14:04.143 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/as - null null
2025-12-29 18:14:04.143 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:14:04.144 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:14:04.385 +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'\'))
2025-12-29 18:14:04.436 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:14:04.437 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:14:04.773 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:14:04.773 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/as - 200 null application/json; charset=utf-8 630.2766ms
2025-12-29 18:14:19.344 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/as - null null
2025-12-29 18:14:19.344 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:14:19.344 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/as - 204 null null 0.6819ms
2025-12-29 18:14:19.400 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/as - null null
2025-12-29 18:14:19.400 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:14:19.401 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:14:19.404 +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-12-29 18:14:19.440 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:14:19.441 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:14:19.444 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:14:19.444 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/as - 200 null application/json; charset=utf-8 44.1296ms
2025-12-29 18:14:23.049 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/as - null null
2025-12-29 18:14:23.049 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:14:23.050 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:14:23.053 +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-12-29 18:14:23.085 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:14:23.086 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:14:23.090 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:14:23.090 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/as - 200 null application/json; charset=utf-8 41.2645ms
2025-12-29 18:14:39.316 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ashw - null null
2025-12-29 18:14:39.316 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:14:39.317 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ashw - 204 null null 1.0735ms
2025-12-29 18:14:39.375 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ashw - null null
2025-12-29 18:14:39.375 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:14:39.376 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:14:39.380 +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-12-29 18:14:39.381 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:14:39.381 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:14:39.382 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:14:39.382 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ashw - 200 null application/json; charset=utf-8 6.602ms
2025-12-29 18:21:23.014 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/cooloidal - null null
2025-12-29 18:21:23.015 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:21:23.015 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/cooloidal - 204 null null 0.3512ms
2025-12-29 18:21:23.075 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/cooloidal - null null
2025-12-29 18:21:23.075 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:21:23.075 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:21:23.383 +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-12-29 18:21:23.384 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:21:23.384 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:21:23.384 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:21:23.384 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/cooloidal - 200 null application/json; charset=utf-8 309.2823ms
2025-12-29 18:21:27.553 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plata - null null
2025-12-29 18:21:27.553 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:21:27.553 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plata - 204 null null 0.3271ms
2025-12-29 18:21:27.613 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plata - null null
2025-12-29 18:21:27.613 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:21:27.613 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:21:27.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'\'))
2025-12-29 18:21:27.619 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:21:27.619 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:21:27.619 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:21:27.619 +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.212ms
2025-12-29 18:21:30.486 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/col - null null
2025-12-29 18:21:30.486 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:21:30.486 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/col - 204 null null 0.3175ms
2025-12-29 18:21:30.546 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/col - null null
2025-12-29 18:21:30.546 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:21:30.547 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:21:30.549 +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'\'))
2025-12-29 18:21:30.568 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:21:30.568 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:21:30.785 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:21:30.785 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/col - 200 null application/json; charset=utf-8 238.9249ms
2025-12-29 18:24:46.569 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-12-29 18:24:46.569 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:24:46.570 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2988ms
2025-12-29 18:24:46.629 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-12-29 18:24:46.630 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:24:46.630 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-12-29 18:24:46.632 +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-12-29 18:24:46.632 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:24:46.632 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:24:46.633 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-12-29 18:24:46.633 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 3.1792ms
2025-12-29 18:25:28.654 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/coco - null null
2025-12-29 18:25:28.655 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:25:28.655 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/coco - 204 null null 0.4055ms
2025-12-29 18:25:28.717 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/coco - null null
2025-12-29 18:25:28.717 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:25:28.717 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:25:28.721 +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-12-29 18:25:28.730 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:25:28.730 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:25:28.899 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:25:28.900 +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 182.7735ms
2025-12-29 18:25:41.361 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colageno - null null
2025-12-29 18:25:41.361 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:25:41.361 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colageno - 204 null null 0.3981ms
2025-12-29 18:25:41.420 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/colageno - null null
2025-12-29 18:25:41.421 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:25:41.421 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:25:41.424 +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-12-29 18:25:41.427 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:25:41.428 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:25:41.428 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:25:41.428 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/colageno - 200 null application/json; charset=utf-8 7.4053ms
2025-12-29 18:25:48.786 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/magnesio - null null
2025-12-29 18:25:48.787 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:25:48.787 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/magnesio - 204 null null 1.3322ms
2025-12-29 18:25:48.845 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/magnesio - null null
2025-12-29 18:25:48.846 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:25:48.847 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:25:48.850 +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-12-29 18:25:48.859 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:25:48.860 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:25:48.860 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:25:48.861 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/magnesio - 200 null application/json; charset=utf-8 15.7038ms
2025-12-29 18:26:43.217 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-12-29 18:26:43.217 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:26:43.217 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.5385ms
2025-12-29 18:26:43.276 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 191
2025-12-29 18:26:43.277 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:26:43.277 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-12-29 18:26:43.286 +00:00 [INF] Executed DbCommand (7ms) [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-12-29 18:26:43.290 +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-12-29 18:26:43.290 +00:00 [INF] Setting HTTP status code 201.
2025-12-29 18:26:43.290 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-12-29 18:26:43.290 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-12-29 18:26:43.290 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 13.9314ms
2025-12-29 18:26:43.349 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41209 - null null
2025-12-29 18:26:43.350 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:26:43.350 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41209 - 204 null null 0.3379ms
2025-12-29 18:26:43.407 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-12-29 18:26:43.407 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:26:43.407 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2961ms
2025-12-29 18:26:43.413 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41209 - application/json 320
2025-12-29 18:26:43.413 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:26:43.413 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-12-29 18:26:43.415 +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-12-29 18:26:43.463 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-12-29 18:26:43.463 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:26:43.463 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-12-29 18:26:43.600 +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-12-29 18:26:43.608 +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), @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;
2025-12-29 18:26:43.613 +00:00 [INF] Setting HTTP status code 201.
2025-12-29 18:26:43.613 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-12-29 18:26:43.613 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41209 - 201 0 null 200.6221ms
2025-12-29 18:26:43.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)
2025-12-29 18:26:43.788 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:26:43.788 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:26:43.789 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-12-29 18:26:43.789 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 325.9601ms
2025-12-29 18:32:07.424 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/balance - null null
2025-12-29 18:32:07.425 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:32:07.425 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/balance - 204 null null 0.2864ms
2025-12-29 18:32:07.485 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/balance - null null
2025-12-29 18:32:07.485 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:32:07.486 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:32:07.724 +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-12-29 18:32:07.725 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:32:07.725 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:32:07.726 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:32:07.726 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/balance - 200 null application/json; charset=utf-8 240.6712ms
2025-12-29 18:53:13.958 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colloidad - null null
2025-12-29 18:53:13.959 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:53:13.959 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colloidad - 204 null null 0.409ms
2025-12-29 18:53:14.018 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/colloidad - null null
2025-12-29 18:53:14.018 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:53:14.018 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:53:14.258 +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-12-29 18:53:14.258 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:53:14.258 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:53:14.258 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:53:14.258 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/colloidad - 200 null application/json; charset=utf-8 240.4526ms
2025-12-29 18:53:19.407 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colloidal - null null
2025-12-29 18:53:19.408 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:53:19.408 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colloidal - 204 null null 1.2798ms
2025-12-29 18:53:19.477 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/colloidal - null null
2025-12-29 18:53:19.477 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:53:19.477 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:53:19.481 +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-12-29 18:53:19.483 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:53:19.483 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:53:19.483 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:53:19.484 +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.7868ms
2025-12-29 18:53:29.394 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-12-29 18:53:29.395 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:53:29.395 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.4984ms
2025-12-29 18:53:29.454 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-12-29 18:53:29.455 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:53:29.455 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-12-29 18:53:29.457 +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-12-29 18:53:29.457 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:53:29.457 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:53:29.457 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-12-29 18:53:29.458 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 3.1931ms
2025-12-29 18:53:35.939 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/coloidal - null null
2025-12-29 18:53:35.939 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:53:35.940 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/coloidal - 204 null null 0.4865ms
2025-12-29 18:53:36.003 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/coloidal - null null
2025-12-29 18:53:36.003 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:53:36.003 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:53:36.008 +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-12-29 18:53:36.009 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:53:36.009 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:53:36.010 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:53:36.010 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/coloidal - 200 null application/json; charset=utf-8 7.1654ms
2025-12-29 18:53:59.079 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/coloidakl - null null
2025-12-29 18:53:59.079 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:53:59.079 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/coloidakl - 204 null null 0.3292ms
2025-12-29 18:53:59.141 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/coloidakl - null null
2025-12-29 18:53:59.141 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:53:59.142 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:53:59.147 +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-12-29 18:53:59.147 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:53:59.147 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:53:59.147 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:53:59.147 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/coloidakl - 200 null application/json; charset=utf-8 6.2325ms
2025-12-29 18:54:10.459 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/coloidal - null null
2025-12-29 18:54:10.460 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:54:10.460 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/coloidal - 204 null null 0.3833ms
2025-12-29 18:54:10.520 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/coloidal - null null
2025-12-29 18:54:10.520 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:54:10.520 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:54:10.527 +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-12-29 18:54:10.527 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:54:10.527 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:54:10.527 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:54:10.527 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/coloidal - 200 null application/json; charset=utf-8 7.255ms
2025-12-29 18:54:15.274 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colloidal - null null
2025-12-29 18:54:15.274 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:54:15.274 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colloidal - 204 null null 0.3639ms
2025-12-29 18:54:15.334 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/colloidal - null null
2025-12-29 18:54:15.334 +00:00 [INF] CORS policy execution successful.
2025-12-29 18:54:15.334 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:54:15.337 +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'\'))
2025-12-29 18:54:15.340 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 18:54:15.341 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 18:54:15.341 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-29 18:54:15.341 +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.1886ms
2025-12-29 19:07:02.654 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-12-29 19:07:02.654 +00:00 [INF] CORS policy execution successful.
2025-12-29 19:07:02.654 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3357ms
2025-12-29 19:07:02.714 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 179
2025-12-29 19:07:02.714 +00:00 [INF] CORS policy execution successful.
2025-12-29 19:07:02.714 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-12-29 19:07:02.944 +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);
2025-12-29 19:07:02.948 +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);
2025-12-29 19:07:02.948 +00:00 [INF] Setting HTTP status code 201.
2025-12-29 19:07:02.948 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-12-29 19:07:02.948 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-12-29 19:07:02.948 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 234.5574ms
2025-12-29 19:07:03.010 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41210 - null null
2025-12-29 19:07:03.010 +00:00 [INF] CORS policy execution successful.
2025-12-29 19:07:03.010 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41210 - 204 null null 0.3022ms
2025-12-29 19:07:03.067 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-12-29 19:07:03.067 +00:00 [INF] CORS policy execution successful.
2025-12-29 19:07:03.067 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.6682ms
2025-12-29 19:07:03.072 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41210 - application/json 102
2025-12-29 19:07:03.073 +00:00 [INF] CORS policy execution successful.
2025-12-29 19:07:03.073 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-12-29 19:07:03.075 +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-12-29 19:07:03.123 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-12-29 19:07:03.124 +00:00 [INF] CORS policy execution successful.
2025-12-29 19:07:03.124 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-12-29 19:07:03.151 +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)
2025-12-29 19:07:03.152 +00:00 [INF] Setting HTTP status code 200.
2025-12-29 19:07:03.152 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-29 19:07:03.153 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-12-29 19:07:03.153 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 29.5923ms
2025-12-29 19:07:03.271 +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-12-29 19:07:03.274 +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);
2025-12-29 19:07:03.278 +00:00 [INF] Setting HTTP status code 201.
2025-12-29 19:07:03.278 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-12-29 19:07:03.278 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41210 - 201 0 null 206.0323ms
2025-12-29 19:46:08.132 +00:00 [INF] Request starting HTTP/1.1 GET http://localhost:5227/.env - null null
2025-12-29 19:46:08.133 +00:00 [INF] Request finished HTTP/1.1 GET http://localhost:5227/.env - 404 0 null 0.8334ms
2025-12-29 19:46:08.134 +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-12-29 23:18:07.155 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2025-12-29 23:18:07.155 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.3422ms
2025-12-29 23:18:07.155 +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