2026-01-06 02:47:21.400 +00:00 [INF] Request starting HTTP/1.0 GET http:/// - null null
2026-01-06 02:47:21.405 +00:00 [INF] Request finished HTTP/1.0 GET http:/// - 404 0 null 4.2205ms
2026-01-06 02:47:21.405 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http:///, Response status code: 404
2026-01-06 05:02:21.785 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2026-01-06 05:02:21.785 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.3187ms
2026-01-06 05:02:21.786 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404
2026-01-06 05:02:31.706 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/wiki - null null
2026-01-06 05:02:31.706 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/wiki - 404 0 null 0.3482ms
2026-01-06 05:02:31.706 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/wiki, Response status code: 404
2026-01-06 05:15:48.135 +00:00 [INF] Request starting HTTP/1.1 GET http://localhost:5227/.env - null null
2026-01-06 05:15:48.136 +00:00 [INF] Request finished HTTP/1.1 GET http://localhost:5227/.env - 404 0 null 0.8777ms
2026-01-06 05:15:48.136 +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
2026-01-06 08:11:43.548 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2026-01-06 08:11:43.549 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 1.3206ms
2026-01-06 08:11:43.550 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404
2026-01-06 08:11:52.839 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2026-01-06 08:11:52.840 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.3447ms
2026-01-06 08:11:52.840 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404
2026-01-06 08:11:56.379 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/.well-known/security.txt - null null
2026-01-06 08:11:56.380 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/.well-known/security.txt - 404 0 null 0.3682ms
2026-01-06 08:11:56.380 +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
2026-01-06 12:15:28.848 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null
2026-01-06 12:15:28.849 +00:00 [INF] CORS policy execution successful.
2026-01-06 12:15:28.849 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 1.2994ms
2026-01-06 12:15:28.912 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 65
2026-01-06 12:15:28.912 +00:00 [INF] CORS policy execution successful.
2026-01-06 12:15:28.913 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin'
2026-01-06 12:15:29.253 +00:00 [INF] Executed DbCommand (20ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName]
FROM [AspNetUsers] AS [a]
WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0
2026-01-06 12:15:29.375 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__userId_0='?' (Size = 450)], CommandType='"Text"', CommandTimeout='30']
SELECT [a0].[Name]
FROM [AspNetUserRoles] AS [a]
INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id]
WHERE [a].[UserId] = @__userId_0
2026-01-06 12:15:29.377 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 12:15:29.378 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json.
2026-01-06 12:15:29.378 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin'
2026-01-06 12:15:29.378 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 466.9134ms
2026-01-06 12:26:31.324 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2026-01-06 12:26:31.324 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.3234ms
2026-01-06 12:26:31.324 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404
2026-01-06 14:01:47.329 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null
2026-01-06 14:01:47.329 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:01:47.330 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.3051ms
2026-01-06 14:01:47.385 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 58
2026-01-06 14:01:47.386 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:01:47.386 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin'
2026-01-06 14:01:47.624 +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
2026-01-06 14:01:47.798 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (Size = 450)], CommandType='"Text"', CommandTimeout='30']
SELECT [a0].[Name]
FROM [AspNetUserRoles] AS [a]
INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id]
WHERE [a].[UserId] = @__userId_0
2026-01-06 14:01:47.799 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 14:01:47.799 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json.
2026-01-06 14:01:47.799 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin'
2026-01-06 14:01:47.799 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 413.7906ms
2026-01-06 14:01:50.571 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-06 14:01:50.571 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:01:50.571 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3226ms
2026-01-06 14:01:50.639 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null
2026-01-06 14:01:50.639 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:01:50.640 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.3409ms
2026-01-06 14:01:50.641 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2026-01-06 14:01:50.641 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:01:50.641 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.157ms
2026-01-06 14:01:50.641 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null
2026-01-06 14:01:50.641 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:01:50.641 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.175ms
2026-01-06 14:01:50.654 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-06 14:01:50.654 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:01:50.657 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-06 14:01:50.673 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-06 14:01:50.674 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 14:01:50.674 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-06 14:01:50.674 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-06 14:01:50.674 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 19.6932ms
2026-01-06 14:01:50.704 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null
2026-01-06 14:01:50.704 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:01:50.705 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities'
2026-01-06 14:01:50.705 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null
2026-01-06 14:01:50.705 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:01:50.705 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/'
2026-01-06 14:01:50.706 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2026-01-06 14:01:50.706 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:01:50.706 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2026-01-06 14:01:50.709 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate]
FROM [Settings] AS [s]
2026-01-06 14:01:50.710 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 14:01:50.710 +00:00 [INF] Writing value of type 'SettingDto' as Json.
2026-01-06 14:01:50.710 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/'
2026-01-06 14:01:50.710 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 4.834ms
2026-01-06 14:01:50.721 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [ProductTaxes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-06 14:01:50.721 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [n].[Id], [n].[Descripcion], [n].[Estatus], [n].[Gentilicio], [n].[Siglas]
FROM [Nationalities] AS [n]
2026-01-06 14:01:50.722 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 14:01:50.722 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-06 14:01:50.722 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 14:01:50.722 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-06 14:01:50.722 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2026-01-06 14:01:50.722 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities'
2026-01-06 14:01:50.723 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 18.7018ms
2026-01-06 14:01:50.723 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 16.4279ms
2026-01-06 14:04:42.599 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null
2026-01-06 14:04:42.599 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2026-01-06 14:04:42.600 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:04:42.600 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.9903ms
2026-01-06 14:04:42.600 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:04:42.600 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-06 14:04:42.601 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 1.4115ms
2026-01-06 14:04:42.601 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:04:42.601 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.4481ms
2026-01-06 14:04:42.605 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null
2026-01-06 14:04:42.606 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:04:42.606 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.4831ms
2026-01-06 14:04:42.655 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-06 14:04:42.656 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2026-01-06 14:04:42.656 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:04:42.656 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:04:42.656 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-06 14:04:42.656 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2026-01-06 14:04:42.658 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-06 14:04:42.659 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 14:04:42.659 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-06 14:04:42.659 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-06 14:04:42.659 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 4.0577ms
2026-01-06 14:04:42.659 +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)
2026-01-06 14:04:42.660 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null
2026-01-06 14:04:42.660 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 14:04:42.660 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:04:42.660 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-06 14:04:42.660 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2026-01-06 14:04:42.661 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/'
2026-01-06 14:04:42.661 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 5.2047ms
2026-01-06 14:04:42.662 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate]
FROM [Settings] AS [s]
2026-01-06 14:04:42.663 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 14:04:42.663 +00:00 [INF] Writing value of type 'SettingDto' as Json.
2026-01-06 14:04:42.663 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/'
2026-01-06 14:04:42.663 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 3.4465ms
2026-01-06 14:04:42.669 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null
2026-01-06 14:04:42.670 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:04:42.670 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities'
2026-01-06 14:04:42.672 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [n].[Id], [n].[Descripcion], [n].[Estatus], [n].[Gentilicio], [n].[Siglas]
FROM [Nationalities] AS [n]
2026-01-06 14:04:42.675 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 14:04:42.675 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-06 14:04:42.675 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities'
2026-01-06 14:04:42.675 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 5.9236ms
2026-01-06 14:04:46.199 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/leci - null null
2026-01-06 14:04:46.200 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:04:46.200 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/leci - 204 null null 0.3443ms
2026-01-06 14:04:46.259 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/leci - null null
2026-01-06 14:04:46.259 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:04:46.259 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-06 14:04:46.264 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-06 14:04:46.269 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 14:04:46.269 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-06 14:04:46.384 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-06 14:04:46.384 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/leci - 200 null application/json; charset=utf-8 124.9322ms
2026-01-06 14:04:48.199 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/tina - null null
2026-01-06 14:04:48.199 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:04:48.199 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/tina - 204 null null 0.3302ms
2026-01-06 14:04:48.259 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/tina - null null
2026-01-06 14:04:48.259 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:04:48.259 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-06 14:04:48.262 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-06 14:04:48.264 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 14:04:48.264 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-06 14:04:48.265 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-06 14:04:48.265 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/tina - 200 null application/json; charset=utf-8 6.1889ms
2026-01-06 14:05:05.896 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - null null
2026-01-06 14:05:05.896 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:05:05.896 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - 204 null null 0.452ms
2026-01-06 14:05:05.958 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan - null null
2026-01-06 14:05:05.959 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:05:05.959 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-06 14:05:05.962 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-06 14:05:05.969 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 14:05:05.969 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-06 14:05:06.085 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-06 14:05:06.085 +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 126.8464ms
2026-01-06 14:05:23.038 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/soy - null null
2026-01-06 14:05:23.039 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:05:23.039 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/soy - 204 null null 0.3393ms
2026-01-06 14:05:23.101 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/soy - null null
2026-01-06 14:05:23.101 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:05:23.102 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-06 14:05:23.107 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-06 14:05:23.115 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 14:05:23.116 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-06 14:05:23.285 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-06 14:05:23.285 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/soy - 200 null application/json; charset=utf-8 184.3559ms
2026-01-06 14:31:49.261 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-06 14:31:49.262 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:31:49.262 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 1.1508ms
2026-01-06 14:31:49.321 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-06 14:31:49.321 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:31:49.321 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-06 14:31:49.553 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-06 14:31:49.553 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 14:31:49.554 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-06 14:31:49.554 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-06 14:31:49.554 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 233.3097ms
2026-01-06 14:31:52.453 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - null null
2026-01-06 14:31:52.454 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:31:52.454 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - 204 null null 0.2876ms
2026-01-06 14:31:52.513 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan - null null
2026-01-06 14:31:52.514 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:31:52.514 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-06 14:31:52.517 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-06 14:31:52.522 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 14:31:52.522 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-06 14:31:52.632 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-06 14:31:52.632 +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 118.8704ms
2026-01-06 14:32:02.918 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-06 14:32:02.918 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:32:02.918 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3486ms
2026-01-06 14:32:02.978 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 179
2026-01-06 14:32:02.978 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:32:02.978 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-06 14:32:02.985 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2026-01-06 14:32:02.988 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2026-01-06 14:32:02.989 +00:00 [INF] Setting HTTP status code 201.
2026-01-06 14:32:02.989 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-06 14:32:02.989 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-06 14:32:02.989 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 11.2289ms
2026-01-06 14:32:03.051 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41211 - null null
2026-01-06 14:32:03.052 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:32:03.052 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41211 - 204 null null 0.473ms
2026-01-06 14:32:03.108 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-06 14:32:03.108 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:32:03.108 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.4158ms
2026-01-06 14:32:03.135 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41211 - application/json 104
2026-01-06 14:32:03.135 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:32:03.135 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-06 14:32:03.138 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-06 14:32:03.168 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-06 14:32:03.168 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:32:03.169 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-06 14:32:03.190 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-06 14:32:03.191 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 14:32:03.191 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-06 14:32:03.191 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-06 14:32:03.191 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 23.2934ms
2026-01-06 14:32:03.322 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2026-01-06 14:32:03.327 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35);
INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
OUTPUT INSERTED.[Id]
VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47);
2026-01-06 14:32:03.331 +00:00 [INF] Setting HTTP status code 201.
2026-01-06 14:32:03.332 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-06 14:32:03.332 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41211 - 201 0 null 196.8512ms
2026-01-06 14:32:37.719 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jarabe - null null
2026-01-06 14:32:37.719 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:32:37.720 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jarabe - 204 null null 0.3848ms
2026-01-06 14:32:37.776 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/jarabe - null null
2026-01-06 14:32:37.776 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:32:37.776 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-06 14:32:37.781 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-06 14:32:37.783 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 14:32:37.784 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-06 14:32:37.784 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-06 14:32:37.784 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/jarabe - 200 null application/json; charset=utf-8 7.9922ms
2026-01-06 14:32:57.016 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plata - null null
2026-01-06 14:32:57.016 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:32:57.016 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plata - 204 null null 0.3385ms
2026-01-06 14:32:57.076 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plata - null null
2026-01-06 14:32:57.076 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:32:57.077 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-06 14:32:57.082 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-06 14:32:57.082 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 14:32:57.082 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-06 14:32:57.082 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-06 14:32:57.082 +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.1628ms
2026-01-06 14:33:03.236 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/silver - null null
2026-01-06 14:33:03.236 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:33:03.236 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/silver - 204 null null 0.4902ms
2026-01-06 14:33:03.305 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/silver - null null
2026-01-06 14:33:03.305 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:33:03.305 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-06 14:33:03.308 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-06 14:33:03.311 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 14:33:03.311 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-06 14:33:03.311 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-06 14:33:03.311 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/silver - 200 null application/json; charset=utf-8 6.7555ms
2026-01-06 14:34:42.472 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/reimy - null null
2026-01-06 14:34:42.473 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:34:42.473 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/reimy - 204 null null 0.3707ms
2026-01-06 14:34:42.536 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/reimy - null null
2026-01-06 14:34:42.536 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:34:42.536 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-06 14:34:42.540 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-06 14:34:42.544 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 14:34:42.544 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-06 14:34:42.657 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-06 14:34:42.657 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/reimy - 200 null application/json; charset=utf-8 121.6355ms
2026-01-06 14:34:49.222 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/montero - null null
2026-01-06 14:34:49.223 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:34:49.223 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/montero - 204 null null 0.2702ms
2026-01-06 14:34:49.282 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/montero - null null
2026-01-06 14:34:49.283 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:34:49.283 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-06 14:34:49.288 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-06 14:34:49.291 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 14:34:49.291 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-06 14:34:49.291 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-06 14:34:49.291 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/montero - 200 null application/json; charset=utf-8 8.8612ms
2026-01-06 14:35:02.361 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-06 14:35:02.361 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:35:02.361 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3787ms
2026-01-06 14:35:02.420 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2026-01-06 14:35:02.420 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:35:02.420 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-06 14:35:02.447 +00:00 [INF] Executed DbCommand (25ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2026-01-06 14:35:02.470 +00:00 [INF] Executed DbCommand (22ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2026-01-06 14:35:02.471 +00:00 [INF] Setting HTTP status code 201.
2026-01-06 14:35:02.472 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-06 14:35:02.472 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-06 14:35:02.473 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 53.6915ms
2026-01-06 14:35:02.529 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41212 - null null
2026-01-06 14:35:02.529 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:35:02.529 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41212 - 204 null null 0.7232ms
2026-01-06 14:35:02.590 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-06 14:35:02.590 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:35:02.591 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.4654ms
2026-01-06 14:35:02.600 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41212 - application/json 106
2026-01-06 14:35:02.601 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:35:02.601 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-06 14:35:02.605 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-06 14:35:02.648 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-06 14:35:02.648 +00:00 [INF] CORS policy execution successful.
2026-01-06 14:35:02.649 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-06 14:35:02.652 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-06 14:35:02.652 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 14:35:02.653 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-06 14:35:02.653 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-06 14:35:02.653 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 4.6482ms
2026-01-06 14:35:02.896 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2026-01-06 14:35:02.899 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35);
INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
OUTPUT INSERTED.[Id]
VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47);
2026-01-06 14:35:02.907 +00:00 [INF] Setting HTTP status code 201.
2026-01-06 14:35:02.908 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-06 14:35:02.909 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41212 - 201 0 null 308.1493ms
2026-01-06 17:23:53.049 +00:00 [INF] Request starting HTTP/1.0 GET http:/// - null null
2026-01-06 17:23:53.049 +00:00 [INF] Request finished HTTP/1.0 GET http:/// - 404 0 null 0.2697ms
2026-01-06 17:23:53.050 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http:///, Response status code: 404
2026-01-06 19:43:11.401 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2026-01-06 19:43:11.402 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.9164ms
2026-01-06 19:43:11.402 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404
2026-01-06 20:28:58.999 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/D3 - null null
2026-01-06 20:28:58.999 +00:00 [INF] CORS policy execution successful.
2026-01-06 20:28:58.999 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/D3 - 204 null null 0.3376ms
2026-01-06 20:28:59.055 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/D3 - null null
2026-01-06 20:28:59.056 +00:00 [INF] CORS policy execution successful.
2026-01-06 20:28:59.056 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-06 20:28:59.370 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-06 20:28:59.382 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 20:28:59.382 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-06 20:28:59.493 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-06 20:28:59.494 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/D3 - 200 null application/json; charset=utf-8 438.4897ms
2026-01-06 20:30:16.981 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-06 20:30:16.982 +00:00 [INF] CORS policy execution successful.
2026-01-06 20:30:16.982 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.4248ms
2026-01-06 20:30:17.038 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-06 20:30:17.038 +00:00 [INF] CORS policy execution successful.
2026-01-06 20:30:17.039 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-06 20:30:17.041 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-06 20:30:17.041 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 20:30:17.041 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-06 20:30:17.041 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-06 20:30:17.041 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 3.3185ms
2026-01-06 20:41:10.962 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/polasma - null null
2026-01-06 20:41:10.962 +00:00 [INF] CORS policy execution successful.
2026-01-06 20:41:10.962 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/polasma - 204 null null 0.4445ms
2026-01-06 20:41:11.022 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/polasma - null null
2026-01-06 20:41:11.022 +00:00 [INF] CORS policy execution successful.
2026-01-06 20:41:11.022 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-06 20:41:11.293 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-06 20:41:11.294 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 20:41:11.295 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-06 20:41:11.295 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-06 20:41:11.295 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/polasma - 200 null application/json; charset=utf-8 273.197ms
2026-01-06 20:41:12.402 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - null null
2026-01-06 20:41:12.402 +00:00 [INF] CORS policy execution successful.
2026-01-06 20:41:12.402 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - 204 null null 0.3698ms
2026-01-06 20:41:12.462 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - null null
2026-01-06 20:41:12.462 +00:00 [INF] CORS policy execution successful.
2026-01-06 20:41:12.462 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2026-01-06 20:41:12.462 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2026-01-06 20:41:12.462 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - 400 0 null 0.7059ms
2026-01-06 20:41:57.802 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - null null
2026-01-06 20:41:57.802 +00:00 [INF] CORS policy execution successful.
2026-01-06 20:41:57.802 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - 204 null null 0.4057ms
2026-01-06 20:41:57.862 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma - null null
2026-01-06 20:41:57.862 +00:00 [INF] CORS policy execution successful.
2026-01-06 20:41:57.862 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-06 20:41:57.866 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-06 20:41:57.871 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 20:41:57.872 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-06 20:41:58.052 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-06 20:41:58.053 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma - 200 null application/json; charset=utf-8 190.6359ms
2026-01-06 20:42:05.843 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1415 - null null
2026-01-06 20:42:05.844 +00:00 [INF] CORS policy execution successful.
2026-01-06 20:42:05.844 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1415 - 204 null null 0.2601ms
2026-01-06 20:42:05.910 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/1415 - null null
2026-01-06 20:42:05.910 +00:00 [INF] CORS policy execution successful.
2026-01-06 20:42:05.910 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2026-01-06 20:42:05.919 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2026-01-06 20:42:05.920 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 20:42:05.921 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json.
2026-01-06 20:42:05.921 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2026-01-06 20:42:05.921 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/1415 - 200 null application/json; charset=utf-8 11.3011ms
2026-01-06 20:44:51.418 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-06 20:44:51.418 +00:00 [INF] CORS policy execution successful.
2026-01-06 20:44:51.418 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3984ms
2026-01-06 20:44:51.476 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 228
2026-01-06 20:44:51.476 +00:00 [INF] CORS policy execution successful.
2026-01-06 20:44:51.476 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-06 20:44:51.483 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2026-01-06 20:44:51.489 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2), @p8='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p9='?' (DbType = Guid), @p10='?' (DbType = DateTime2), @p11='?' (DbType = Boolean), @p12='?' (DbType = Int32), @p13='?' (DbType = Int64), @p14='?' (DbType = Guid), @p15='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
MERGE [SalesPaymentTypesDetails] USING (
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, 0),
(@p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, 1)) AS i ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
VALUES (i.[Amount], i.[CreatedById], i.[CreatedDate], i.[DeleteFlag], i.[PaymentTypeId], i.[SalesId], i.[UpdatedById], i.[UpdatedDate])
OUTPUT INSERTED.[Id], i._Position;
2026-01-06 20:44:51.490 +00:00 [INF] Setting HTTP status code 201.
2026-01-06 20:44:51.491 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-06 20:44:51.491 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-06 20:44:51.491 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 15.2861ms
2026-01-06 20:44:51.552 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41213 - null null
2026-01-06 20:44:51.552 +00:00 [INF] CORS policy execution successful.
2026-01-06 20:44:51.552 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41213 - 204 null null 0.7686ms
2026-01-06 20:44:51.613 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-06 20:44:51.613 +00:00 [INF] CORS policy execution successful.
2026-01-06 20:44:51.614 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.4142ms
2026-01-06 20:44:51.614 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41213 - application/json 106
2026-01-06 20:44:51.614 +00:00 [INF] CORS policy execution successful.
2026-01-06 20:44:51.614 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-06 20:44:51.617 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-06 20:44:51.669 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-06 20:44:51.669 +00:00 [INF] CORS policy execution successful.
2026-01-06 20:44:51.670 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-06 20:44:51.689 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-06 20:44:51.690 +00:00 [INF] Setting HTTP status code 200.
2026-01-06 20:44:51.690 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-06 20:44:51.690 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-06 20:44:51.690 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 21.1695ms
2026-01-06 20:44:51.772 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2026-01-06 20:44:51.774 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35);
INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
OUTPUT INSERTED.[Id]
VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47);
2026-01-06 20:44:51.778 +00:00 [INF] Setting HTTP status code 201.
2026-01-06 20:44:51.779 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-06 20:44:51.779 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41213 - 201 0 null 164.9202ms