2025-11-28 03:44:02.921 +00:00 [INF] Request starting HTTP/1.0 GET http:/// - null null
2025-11-28 03:44:02.924 +00:00 [INF] Request finished HTTP/1.0 GET http:/// - 404 0 null 3.004ms
2025-11-28 03:44:02.925 +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-11-28 04:05:33.850 +00:00 [INF] Request starting HTTP/1.1 GET http://localhost:5227/.git/config - null null
2025-11-28 04:05:33.850 +00:00 [INF] Request starting HTTP/1.1 GET http://localhost:5227/.env - null null
2025-11-28 04:05:33.851 +00:00 [INF] Request finished HTTP/1.1 GET http://localhost:5227/.git/config - 404 0 null 0.9981ms
2025-11-28 04:05:33.851 +00:00 [INF] Request finished HTTP/1.1 GET http://localhost:5227/.env - 404 0 null 1.0427ms
2025-11-28 04:05:33.851 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://localhost:5227/.git/config, Response status code: 404
2025-11-28 04:05:33.851 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://localhost:5227/.env, Response status code: 404
2025-11-28 07:26:00.405 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2025-11-28 07:26:00.406 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.31ms
2025-11-28 07:26:00.406 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404
2025-11-28 07:26:10.300 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2025-11-28 07:26:10.300 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.3367ms
2025-11-28 07:26:10.300 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404
2025-11-28 07:26:16.744 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/security.txt - null null
2025-11-28 07:26:16.744 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/security.txt - 404 0 null 0.3088ms
2025-11-28 07:26:16.744 +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/security.txt, Response status code: 404
2025-11-28 08:02:27.321 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2025-11-28 08:02:27.321 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.2367ms
2025-11-28 08:02:27.322 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404
2025-11-28 08:04:25.252 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/.well-known/security.txt - null null
2025-11-28 08:04:25.252 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/.well-known/security.txt - 404 0 null 0.2835ms
2025-11-28 08:04:25.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/.well-known/security.txt, Response status code: 404
2025-11-28 11:42:27.199 +00:00 [INF] Request starting HTTP/1.1 GET http://localhost:5227/.env - null null
2025-11-28 11:42:27.199 +00:00 [INF] Request starting HTTP/1.1 GET http://localhost:5227/.git/config - null null
2025-11-28 11:42:27.199 +00:00 [INF] Request finished HTTP/1.1 GET http://localhost:5227/.env - 404 0 null 0.9717ms
2025-11-28 11:42:27.200 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://localhost:5227/.env, Response status code: 404
2025-11-28 11:42:27.200 +00:00 [INF] Request finished HTTP/1.1 GET http://localhost:5227/.git/config - 404 0 null 1.0839ms
2025-11-28 11:42:27.200 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://localhost:5227/.git/config, Response status code: 404
2025-11-28 12:31:28.342 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null
2025-11-28 12:31:28.342 +00:00 [INF] CORS policy execution successful.
2025-11-28 12:31:28.342 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.3588ms
2025-11-28 12:31:28.402 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 65
2025-11-28 12:31:28.403 +00:00 [INF] CORS policy execution successful.
2025-11-28 12:31:28.403 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin'
2025-11-28 12:31:28.766 +00:00 [INF] Executed DbCommand (19ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName]
FROM [AspNetUsers] AS [a]
WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0
2025-11-28 12:31:28.896 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (Size = 450)], CommandType='"Text"', CommandTimeout='30']
SELECT [a0].[Name]
FROM [AspNetUserRoles] AS [a]
INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id]
WHERE [a].[UserId] = @__userId_0
2025-11-28 12:31:28.898 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 12:31:28.898 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json.
2025-11-28 12:31:28.898 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin'
2025-11-28 12:31:28.899 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 496.101ms
2025-11-28 13:31:57.216 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-28 13:31:57.216 +00:00 [INF] CORS policy execution successful.
2025-11-28 13:31:57.216 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.338ms
2025-11-28 13:31:57.220 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null
2025-11-28 13:31:57.220 +00:00 [INF] CORS policy execution successful.
2025-11-28 13:31:57.220 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.2414ms
2025-11-28 13:31:57.220 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2025-11-28 13:31:57.220 +00:00 [INF] CORS policy execution successful.
2025-11-28 13:31:57.220 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.1442ms
2025-11-28 13:31:57.231 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null
2025-11-28 13:31:57.231 +00:00 [INF] CORS policy execution successful.
2025-11-28 13:31:57.231 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.3601ms
2025-11-28 13:31:57.271 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-28 13:31:57.271 +00:00 [INF] CORS policy execution successful.
2025-11-28 13:31:57.272 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-28 13:31:57.277 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null
2025-11-28 13:31:57.277 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2025-11-28 13:31:57.278 +00:00 [INF] CORS policy execution successful.
2025-11-28 13:31:57.278 +00:00 [INF] CORS policy execution successful.
2025-11-28 13:31:57.278 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/'
2025-11-28 13:31:57.278 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2025-11-28 13:31:57.291 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null
2025-11-28 13:31:57.291 +00:00 [INF] CORS policy execution successful.
2025-11-28 13:31:57.291 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities'
2025-11-28 13:31:57.566 +00:00 [INF] Executed DbCommand (10ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-28 13:31:57.567 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 13:31:57.567 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 13:31:57.567 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-28 13:31:57.567 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 296.3889ms
2025-11-28 13:31:57.575 +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]
2025-11-28 13:31:57.575 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 13:31:57.575 +00:00 [INF] Writing value of type 'SettingDto' as Json.
2025-11-28 13:31:57.575 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/'
2025-11-28 13:31:57.575 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 297.8597ms
2025-11-28 13:31:57.576 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [ProductTaxes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-28 13:31:57.577 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 13:31:57.577 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 13:31:57.578 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2025-11-28 13:31:57.578 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 300.6022ms
2025-11-28 13:31:57.579 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [n].[Id], [n].[Descripcion], [n].[Estatus], [n].[Gentilicio], [n].[Siglas]
FROM [Nationalities] AS [n]
2025-11-28 13:31:57.580 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 13:31:57.580 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 13:31:57.581 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities'
2025-11-28 13:31:57.581 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 290.2811ms
2025-11-28 13:32:04.146 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - null null
2025-11-28 13:32:04.147 +00:00 [INF] CORS policy execution successful.
2025-11-28 13:32:04.147 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - 204 null null 0.3542ms
2025-11-28 13:32:04.209 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan - null null
2025-11-28 13:32:04.210 +00:00 [INF] CORS policy execution successful.
2025-11-28 13:32:04.210 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 13:32:04.215 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-28 13:32:04.222 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 13:32:04.222 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 13:32:04.340 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 13:32:04.340 +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 130.4863ms
2025-11-28 13:32:10.909 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/customers/ByName/lui - null null
2025-11-28 13:32:10.909 +00:00 [INF] CORS policy execution successful.
2025-11-28 13:32:10.910 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/customers/ByName/lui - 204 null null 0.2253ms
2025-11-28 13:32:10.963 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/customers/ByName/lui - null null
2025-11-28 13:32:10.964 +00:00 [INF] CORS policy execution successful.
2025-11-28 13:32:10.964 +00:00 [INF] Executing endpoint 'HTTP: GET Customers/ByName/{name}'
2025-11-28 13:32:10.966 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__name_0_contains='?' (Size = 150)], CommandType='"Text"', CommandTimeout='30']
SELECT [c].[Id], [c].[Address], [c].[BirthDate], [c].[Cedula], [c].[CellPhone], [c].[CreatedById], [c].[CreatedDate], [c].[DeleteFlag], [c].[Email], [c].[Gender], [c].[HomePhone], [c].[Name], [c].[NationalityId], [c].[NationalityId1], [c].[Phone], [c].[UpdatedById], [c].[UpdatedDate]
FROM [Customers] AS [c]
WHERE [c].[DeleteFlag] = CAST(0 AS bit) AND [c].[Name] LIKE @__name_0_contains ESCAPE N'\'
2025-11-28 13:32:10.967 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 13:32:10.967 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 13:32:10.967 +00:00 [INF] Executed endpoint 'HTTP: GET Customers/ByName/{name}'
2025-11-28 13:32:10.967 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/customers/ByName/lui - 200 null application/json; charset=utf-8 3.4581ms
2025-11-28 13:32:11.448 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/customers/ByName/luisa - null null
2025-11-28 13:32:11.448 +00:00 [INF] CORS policy execution successful.
2025-11-28 13:32:11.448 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/customers/ByName/luisa - 204 null null 0.2837ms
2025-11-28 13:32:11.507 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/customers/ByName/luisa - null null
2025-11-28 13:32:11.508 +00:00 [INF] CORS policy execution successful.
2025-11-28 13:32:11.508 +00:00 [INF] Executing endpoint 'HTTP: GET Customers/ByName/{name}'
2025-11-28 13:32:11.511 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__name_0_contains='?' (Size = 150)], CommandType='"Text"', CommandTimeout='30']
SELECT [c].[Id], [c].[Address], [c].[BirthDate], [c].[Cedula], [c].[CellPhone], [c].[CreatedById], [c].[CreatedDate], [c].[DeleteFlag], [c].[Email], [c].[Gender], [c].[HomePhone], [c].[Name], [c].[NationalityId], [c].[NationalityId1], [c].[Phone], [c].[UpdatedById], [c].[UpdatedDate]
FROM [Customers] AS [c]
WHERE [c].[DeleteFlag] = CAST(0 AS bit) AND [c].[Name] LIKE @__name_0_contains ESCAPE N'\'
2025-11-28 13:32:11.511 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 13:32:11.511 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 13:32:11.511 +00:00 [INF] Executed endpoint 'HTTP: GET Customers/ByName/{name}'
2025-11-28 13:32:11.511 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/customers/ByName/luisa - 200 null application/json; charset=utf-8 3.8345ms
2025-11-28 13:33:53.536 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-28 13:33:53.536 +00:00 [INF] CORS policy execution successful.
2025-11-28 13:33:53.536 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3322ms
2025-11-28 13:33:53.589 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-28 13:33:53.589 +00:00 [INF] CORS policy execution successful.
2025-11-28 13:33:53.590 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-28 13:33:53.591 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-28 13:33:53.592 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 13:33:53.592 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 13:33:53.592 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-28 13:33:53.592 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 2.8107ms
2025-11-28 13:52:38.511 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/282 - null null
2025-11-28 13:52:38.511 +00:00 [INF] CORS policy execution successful.
2025-11-28 13:52:38.511 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/282 - 204 null null 0.3476ms
2025-11-28 13:52:38.571 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/282 - null null
2025-11-28 13:52:38.571 +00:00 [INF] CORS policy execution successful.
2025-11-28 13:52:38.572 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 13:52:38.807 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-28 13:52:38.808 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 13:52:38.808 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 13:52:38.808 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 13:52:38.809 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/282 - 200 null application/json; charset=utf-8 237.7905ms
2025-11-28 14:30:43.186 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ch - null null
2025-11-28 14:30:43.187 +00:00 [INF] CORS policy execution successful.
2025-11-28 14:30:43.187 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ch - 204 null null 0.9421ms
2025-11-28 14:30:43.246 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ch - null null
2025-11-28 14:30:43.247 +00:00 [INF] CORS policy execution successful.
2025-11-28 14:30:43.247 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 14:30:43.484 +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-11-28 14:30:43.505 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 14:30:43.506 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 14:30:43.774 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 14:30:43.775 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ch - 200 null application/json; charset=utf-8 528.4642ms
2025-11-28 14:30:47.429 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/clorofila - null null
2025-11-28 14:30:47.429 +00:00 [INF] CORS policy execution successful.
2025-11-28 14:30:47.429 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/clorofila - 204 null null 0.3001ms
2025-11-28 14:30:47.485 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/clorofila - null null
2025-11-28 14:30:47.485 +00:00 [INF] CORS policy execution successful.
2025-11-28 14:30:47.486 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 14:30:47.488 +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-11-28 14:30:47.493 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 14:30:47.493 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 14:30:47.493 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 14:30:47.494 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/clorofila - 200 null application/json; charset=utf-8 8.3322ms
2025-11-28 14:31:07.202 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-11-28 14:31:07.202 +00:00 [INF] CORS policy execution successful.
2025-11-28 14:31:07.202 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3937ms
2025-11-28 14:31:07.261 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 179
2025-11-28 14:31:07.261 +00:00 [INF] CORS policy execution successful.
2025-11-28 14:31:07.261 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-11-28 14:31:07.268 +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-11-28 14:31:07.272 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2025-11-28 14:31:07.272 +00:00 [INF] Setting HTTP status code 201.
2025-11-28 14:31:07.272 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-11-28 14:31:07.273 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-11-28 14:31:07.273 +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.6106ms
2025-11-28 14:31:07.331 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41024 - null null
2025-11-28 14:31:07.331 +00:00 [INF] CORS policy execution successful.
2025-11-28 14:31:07.331 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41024 - 204 null null 0.3606ms
2025-11-28 14:31:07.391 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-28 14:31:07.391 +00:00 [INF] CORS policy execution successful.
2025-11-28 14:31:07.391 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3941ms
2025-11-28 14:31:07.422 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41024 - application/json 102
2025-11-28 14:31:07.422 +00:00 [INF] CORS policy execution successful.
2025-11-28 14:31:07.422 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-28 14:31:07.425 +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)
2025-11-28 14:31:07.451 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-28 14:31:07.452 +00:00 [INF] CORS policy execution successful.
2025-11-28 14:31:07.453 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-28 14:31:07.481 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-28 14:31:07.482 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 14:31:07.482 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 14:31:07.482 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-28 14:31:07.482 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 30.9432ms
2025-11-28 14:31:07.607 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2025-11-28 14:31:07.615 +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), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35);
INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
OUTPUT INSERTED.[Id]
VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47);
2025-11-28 14:31:07.620 +00:00 [INF] Setting HTTP status code 201.
2025-11-28 14:31:07.620 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-28 14:31:07.620 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41024 - 201 0 null 198.7992ms
2025-11-28 15:13:12.173 +00:00 [INF] Request starting HTTP/1.0 GET http:/// - null null
2025-11-28 15:13:12.175 +00:00 [INF] Request finished HTTP/1.0 GET http:/// - 404 0 null 1.6039ms
2025-11-28 15:13:12.175 +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-11-28 17:01:45.966 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/alle - null null
2025-11-28 17:01:45.966 +00:00 [INF] CORS policy execution successful.
2025-11-28 17:01:45.966 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/alle - 204 null null 0.311ms
2025-11-28 17:01:46.024 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/alle - null null
2025-11-28 17:01:46.024 +00:00 [INF] CORS policy execution successful.
2025-11-28 17:01:46.024 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 17:01:46.331 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-28 17:01:46.347 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 17:01:46.348 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 17:01:46.513 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 17:01:46.514 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/alle - 200 null application/json; charset=utf-8 489.679ms
2025-11-28 17:02:49.064 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-11-28 17:02:49.064 +00:00 [INF] CORS policy execution successful.
2025-11-28 17:02:49.064 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3413ms
2025-11-28 17:02:49.121 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 188
2025-11-28 17:02:49.121 +00:00 [INF] CORS policy execution successful.
2025-11-28 17:02:49.121 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-11-28 17:02:49.126 +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);
2025-11-28 17:02:49.130 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2025-11-28 17:02:49.130 +00:00 [INF] Setting HTTP status code 201.
2025-11-28 17:02:49.131 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-11-28 17:02:49.131 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-11-28 17:02:49.131 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 10.2301ms
2025-11-28 17:02:49.193 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41025 - null null
2025-11-28 17:02:49.193 +00:00 [INF] CORS policy execution successful.
2025-11-28 17:02:49.194 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41025 - 204 null null 0.8964ms
2025-11-28 17:02:49.253 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-28 17:02:49.253 +00:00 [INF] CORS policy execution successful.
2025-11-28 17:02:49.253 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.7362ms
2025-11-28 17:02:49.262 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41025 - application/json 110
2025-11-28 17:02:49.262 +00:00 [INF] CORS policy execution successful.
2025-11-28 17:02:49.263 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-28 17:02:49.265 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-28 17:02:49.312 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-28 17:02:49.313 +00:00 [INF] CORS policy execution successful.
2025-11-28 17:02:49.313 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-28 17:02:49.348 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-28 17:02:49.349 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 17:02:49.349 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 17:02:49.349 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-28 17:02:49.350 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 37.1917ms
2025-11-28 17:02:49.481 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2025-11-28 17:02:49.488 +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), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35);
INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
OUTPUT INSERTED.[Id]
VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47);
2025-11-28 17:02:49.493 +00:00 [INF] Setting HTTP status code 201.
2025-11-28 17:02:49.493 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-28 17:02:49.493 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41025 - 201 0 null 230.6955ms
2025-11-28 17:03:56.849 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/mezcla - null null
2025-11-28 17:03:56.849 +00:00 [INF] CORS policy execution successful.
2025-11-28 17:03:56.850 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/mezcla - 204 null null 0.3567ms
2025-11-28 17:03:56.908 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/mezcla - null null
2025-11-28 17:03:56.908 +00:00 [INF] CORS policy execution successful.
2025-11-28 17:03:56.909 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 17:03:56.912 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-28 17:03:56.915 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 17:03:56.915 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 17:03:56.915 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 17:03:56.915 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/mezcla - 200 null application/json; charset=utf-8 7.3021ms
2025-11-28 17:04:21.133 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-11-28 17:04:21.133 +00:00 [INF] CORS policy execution successful.
2025-11-28 17:04:21.133 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.342ms
2025-11-28 17:04:21.193 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 179
2025-11-28 17:04:21.193 +00:00 [INF] CORS policy execution successful.
2025-11-28 17:04:21.193 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-11-28 17:04:21.198 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2025-11-28 17:04:21.202 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2025-11-28 17:04:21.203 +00:00 [INF] Setting HTTP status code 201.
2025-11-28 17:04:21.203 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-11-28 17:04:21.203 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-11-28 17:04:21.203 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 9.9179ms
2025-11-28 17:04:21.266 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41026 - null null
2025-11-28 17:04:21.266 +00:00 [INF] CORS policy execution successful.
2025-11-28 17:04:21.266 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41026 - 204 null null 0.3246ms
2025-11-28 17:04:21.273 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-28 17:04:21.273 +00:00 [INF] CORS policy execution successful.
2025-11-28 17:04:21.273 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2602ms
2025-11-28 17:04:21.323 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41026 - application/json 103
2025-11-28 17:04:21.324 +00:00 [INF] CORS policy execution successful.
2025-11-28 17:04:21.324 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-28 17:04:21.326 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-28 17:04:21.326 +00:00 [INF] CORS policy execution successful.
2025-11-28 17:04:21.327 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-28 17:04:21.326 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-28 17:04:21.329 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-28 17:04:21.329 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 17:04:21.329 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 17:04:21.329 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-28 17:04:21.329 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 2.9468ms
2025-11-28 17:04:21.556 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2025-11-28 17:04:21.559 +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-11-28 17:04:21.564 +00:00 [INF] Setting HTTP status code 201.
2025-11-28 17:04:21.564 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-28 17:04:21.565 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41026 - 201 0 null 241.389ms
2025-11-28 17:04:51.527 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Co - null null
2025-11-28 17:04:51.527 +00:00 [INF] CORS policy execution successful.
2025-11-28 17:04:51.528 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Co - 204 null null 0.3512ms
2025-11-28 17:04:51.591 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/Co - null null
2025-11-28 17:04:51.591 +00:00 [INF] CORS policy execution successful.
2025-11-28 17:04:51.591 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 17:04:51.594 +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-11-28 17:04:51.640 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 17:04:51.640 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 17:04:51.992 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 17:04:51.993 +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 401.8091ms
2025-11-28 17:04:54.646 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Q - null null
2025-11-28 17:04:54.646 +00:00 [INF] CORS policy execution successful.
2025-11-28 17:04:54.646 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Q - 204 null null 0.2952ms
2025-11-28 17:04:54.706 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/Q - null null
2025-11-28 17:04:54.706 +00:00 [INF] CORS policy execution successful.
2025-11-28 17:04:54.707 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 17:04:54.713 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-28 17:04:54.737 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 17:04:54.738 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 17:04:54.740 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 17:04:54.740 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/Q - 200 null application/json; charset=utf-8 34.0643ms
2025-11-28 17:05:22.581 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-11-28 17:05:22.581 +00:00 [INF] CORS policy execution successful.
2025-11-28 17:05:22.581 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.2737ms
2025-11-28 17:05:22.639 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 188
2025-11-28 17:05:22.639 +00:00 [INF] CORS policy execution successful.
2025-11-28 17:05:22.640 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-11-28 17:05:22.644 +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);
2025-11-28 17:05:22.648 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2025-11-28 17:05:22.648 +00:00 [INF] Setting HTTP status code 201.
2025-11-28 17:05:22.648 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-11-28 17:05:22.648 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-11-28 17:05:22.648 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 9.1823ms
2025-11-28 17:05:22.710 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41027 - null null
2025-11-28 17:05:22.710 +00:00 [INF] CORS policy execution successful.
2025-11-28 17:05:22.710 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41027 - 204 null null 0.3799ms
2025-11-28 17:05:22.720 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-28 17:05:22.721 +00:00 [INF] CORS policy execution successful.
2025-11-28 17:05:22.721 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3517ms
2025-11-28 17:05:22.770 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41027 - application/json 108
2025-11-28 17:05:22.770 +00:00 [INF] CORS policy execution successful.
2025-11-28 17:05:22.770 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-28 17:05:22.772 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-28 17:05:22.773 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-28 17:05:22.773 +00:00 [INF] CORS policy execution successful.
2025-11-28 17:05:22.773 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-28 17:05:22.775 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-28 17:05:22.775 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 17:05:22.775 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 17:05:22.775 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-28 17:05:22.775 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 2.1622ms
2025-11-28 17:05:22.947 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2025-11-28 17:05:22.950 +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-11-28 17:05:22.954 +00:00 [INF] Setting HTTP status code 201.
2025-11-28 17:05:22.955 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-28 17:05:22.955 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41027 - 201 0 null 185.3892ms
2025-11-28 17:29:38.055 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2025-11-28 17:29:38.055 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.4077ms
2025-11-28 17:29:38.055 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404
2025-11-28 19:30:06.083 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/juego - null null
2025-11-28 19:30:06.083 +00:00 [INF] CORS policy execution successful.
2025-11-28 19:30:06.083 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/juego - 204 null null 0.2212ms
2025-11-28 19:30:06.141 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/juego - null null
2025-11-28 19:30:06.141 +00:00 [INF] CORS policy execution successful.
2025-11-28 19:30:06.142 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 19:30:06.402 +00:00 [INF] Executed DbCommand (8ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-28 19:30:06.403 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 19:30:06.403 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 19:30:06.403 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 19:30:06.403 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/juego - 200 null application/json; charset=utf-8 262.208ms
2025-11-28 19:30:08.512 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Ju - null null
2025-11-28 19:30:08.513 +00:00 [INF] CORS policy execution successful.
2025-11-28 19:30:08.513 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Ju - 204 null null 1.1969ms
2025-11-28 19:30:08.572 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/Ju - null null
2025-11-28 19:30:08.572 +00:00 [INF] CORS policy execution successful.
2025-11-28 19:30:08.573 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 19:30:08.577 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-28 19:30:08.582 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 19:30:08.582 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 19:30:08.697 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 19:30:08.698 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/Ju - 200 null application/json; charset=utf-8 125.9599ms
2025-11-28 19:30:16.660 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - null null
2025-11-28 19:30:16.661 +00:00 [INF] CORS policy execution successful.
2025-11-28 19:30:16.661 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - 204 null null 0.3044ms
2025-11-28 19:30:16.720 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan - null null
2025-11-28 19:30:16.720 +00:00 [INF] CORS policy execution successful.
2025-11-28 19:30:16.721 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 19:30:16.724 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-28 19:30:16.736 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 19:30:16.737 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 19:30:16.859 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 19:30:16.860 +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 139.3718ms
2025-11-28 19:31:37.450 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/consulta - null null
2025-11-28 19:31:37.451 +00:00 [INF] CORS policy execution successful.
2025-11-28 19:31:37.451 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/consulta - 204 null null 0.3361ms
2025-11-28 19:31:37.513 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/consulta - null null
2025-11-28 19:31:37.513 +00:00 [INF] CORS policy execution successful.
2025-11-28 19:31:37.513 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 19:31:37.516 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-28 19:31:37.524 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 19:31:37.524 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 19:31:37.698 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 19:31:37.699 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/consulta - 200 null application/json; charset=utf-8 186.1079ms
2025-11-28 19:32:25.092 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-11-28 19:32:25.092 +00:00 [INF] CORS policy execution successful.
2025-11-28 19:32:25.093 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3102ms
2025-11-28 19:32:25.153 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 224
2025-11-28 19:32:25.153 +00:00 [INF] CORS policy execution successful.
2025-11-28 19:32:25.153 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-11-28 19:32:25.158 +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);
2025-11-28 19:32:25.162 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2025-11-28 19:32:25.162 +00:00 [INF] Setting HTTP status code 201.
2025-11-28 19:32:25.162 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-11-28 19:32:25.162 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-11-28 19:32:25.162 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 9.6447ms
2025-11-28 19:32:25.232 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41028 - null null
2025-11-28 19:32:25.232 +00:00 [INF] CORS policy execution successful.
2025-11-28 19:32:25.232 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41028 - 204 null null 0.2733ms
2025-11-28 19:32:25.292 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-28 19:32:25.292 +00:00 [INF] CORS policy execution successful.
2025-11-28 19:32:25.292 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3354ms
2025-11-28 19:32:25.310 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41028 - application/json 423
2025-11-28 19:32:25.310 +00:00 [INF] CORS policy execution successful.
2025-11-28 19:32:25.311 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-28 19:32:25.313 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-28 19:32:25.350 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-28 19:32:25.350 +00:00 [INF] CORS policy execution successful.
2025-11-28 19:32:25.351 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-28 19:32:25.381 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-28 19:32:25.381 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 19:32:25.381 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 19:32:25.381 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-28 19:32:25.381 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 31.6232ms
2025-11-28 19:32:25.479 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2025-11-28 19:32:25.495 +00:00 [INF] Executed DbCommand (8ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p40='?' (DbType = Int32), @p23='?' (Size = 4000), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Int32), @p26='?' (DbType = Guid), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Boolean), @p29='?' (DbType = DateTime2), @p30='?' (DbType = Int32), @p31='?' (Size = 150), @p32='?' (Size = 500), @p33='?' (Size = -1) (DbType = Binary), @p34='?' (DbType = Int32), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p36='?' (Size = 4000), @p37='?' (DbType = Int32), @p38='?' (DbType = Guid), @p39='?' (DbType = DateTime2), @p58='?' (DbType = Int32), @p41='?' (Size = 4000), @p42='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p43='?' (DbType = Int32), @p44='?' (DbType = Guid), @p45='?' (DbType = DateTime2), @p46='?' (DbType = Boolean), @p47='?' (DbType = DateTime2), @p48='?' (DbType = Int32), @p49='?' (Size = 150), @p50='?' (Size = 500), @p51='?' (Size = -1) (DbType = Binary), @p52='?' (DbType = Int32), @p53='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p54='?' (Size = 4000), @p55='?' (DbType = Int32), @p56='?' (DbType = Guid), @p57='?' (DbType = DateTime2), @p76='?' (DbType = Int32), @p59='?' (Size = 4000), @p60='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p61='?' (DbType = Int32), @p62='?' (DbType = Guid), @p63='?' (DbType = DateTime2), @p64='?' (DbType = Boolean), @p65='?' (DbType = DateTime2), @p66='?' (DbType = Int32), @p67='?' (Size = 150), @p68='?' (Size = 500), @p69='?' (Size = -1) (DbType = Binary), @p70='?' (DbType = Int32), @p71='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p72='?' (Size = 4000), @p73='?' (DbType = Int32), @p74='?' (DbType = Guid), @p75='?' (DbType = DateTime2), @p77='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p78='?' (DbType = Guid), @p79='?' (DbType = DateTime2), @p80='?' (DbType = Boolean), @p81='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p82='?' (DbType = Int32), @p83='?' (DbType = Int32), @p84='?' (DbType = Int64), @p85='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p86='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p87='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p88='?' (DbType = Guid), @p89='?' (DbType = DateTime2), @p90='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p91='?' (DbType = Guid), @p92='?' (DbType = DateTime2), @p93='?' (DbType = Boolean), @p94='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p95='?' (DbType = Int32), @p96='?' (DbType = Int32), @p97='?' (DbType = Int64), @p98='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p99='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p100='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p101='?' (DbType = Guid), @p102='?' (DbType = DateTime2), @p103='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p104='?' (DbType = Guid), @p105='?' (DbType = DateTime2), @p106='?' (DbType = Boolean), @p107='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p108='?' (DbType = Int32), @p109='?' (DbType = Int32), @p110='?' (DbType = Int64), @p111='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p112='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p113='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p114='?' (DbType = Guid), @p115='?' (DbType = DateTime2), @p116='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p117='?' (DbType = Guid), @p118='?' (DbType = DateTime2), @p119='?' (DbType = Boolean), @p120='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p121='?' (DbType = Int32), @p122='?' (DbType = Int32), @p123='?' (DbType = Int64), @p124='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p125='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p126='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p127='?' (DbType = Guid), @p128='?' (DbType = DateTime2), @p129='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p130='?' (DbType = Guid), @p131='?' (DbType = DateTime2), @p132='?' (DbType = Int32), @p133='?' (Size = 34), @p134='?' (DbType = Guid), @p135='?' (DbType = Int32), @p136='?' (DbType = Int32), @p137='?' (DbType = Int32), @p138='?' (Size = 4000), @p139='?' (Size = 4000), @p140='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p141='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p142='?' (DbType = Guid), @p143='?' (DbType = DateTime2), @p144='?' (DbType = Int32), @p145='?' (Size = 34), @p146='?' (DbType = Guid), @p147='?' (DbType = Int32), @p148='?' (DbType = Int32), @p149='?' (DbType = Int32), @p150='?' (Size = 4000), @p151='?' (Size = 4000), @p152='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p153='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p154='?' (DbType = Guid), @p155='?' (DbType = DateTime2), @p156='?' (DbType = Int32), @p157='?' (Size = 34), @p158='?' (DbType = Guid), @p159='?' (DbType = Int32), @p160='?' (DbType = Int32), @p161='?' (DbType = Int32), @p162='?' (Size = 4000), @p163='?' (Size = 4000), @p164='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p165='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p166='?' (DbType = Guid), @p167='?' (DbType = DateTime2), @p168='?' (DbType = Int32), @p169='?' (Size = 34), @p170='?' (DbType = Guid), @p171='?' (DbType = Int32), @p172='?' (DbType = Int32), @p173='?' (DbType = Int32), @p174='?' (Size = 4000), @p175='?' (Size = 4000), @p176='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
UPDATE [Products] SET [BarCode] = @p23, [BuyPrice] = @p24, [CategoryId] = @p25, [CreatedById] = @p26, [CreatedDate] = @p27, [DeleteFlag] = @p28, [ExpirationDate] = @p29, [MinimunStock] = @p30, [Name] = @p31, [Note] = @p32, [ProductImage] = @p33, [ProductTaxId] = @p34, [SalePrice] = @p35, [Status] = @p36, [Stock] = @p37, [UpdatedById] = @p38, [UpdatedDate] = @p39
OUTPUT 1
WHERE [Id] = @p40;
UPDATE [Products] SET [BarCode] = @p41, [BuyPrice] = @p42, [CategoryId] = @p43, [CreatedById] = @p44, [CreatedDate] = @p45, [DeleteFlag] = @p46, [ExpirationDate] = @p47, [MinimunStock] = @p48, [Name] = @p49, [Note] = @p50, [ProductImage] = @p51, [ProductTaxId] = @p52, [SalePrice] = @p53, [Status] = @p54, [Stock] = @p55, [UpdatedById] = @p56, [UpdatedDate] = @p57
OUTPUT 1
WHERE [Id] = @p58;
UPDATE [Products] SET [BarCode] = @p59, [BuyPrice] = @p60, [CategoryId] = @p61, [CreatedById] = @p62, [CreatedDate] = @p63, [DeleteFlag] = @p64, [ExpirationDate] = @p65, [MinimunStock] = @p66, [Name] = @p67, [Note] = @p68, [ProductImage] = @p69, [ProductTaxId] = @p70, [SalePrice] = @p71, [Status] = @p72, [Stock] = @p73, [UpdatedById] = @p74, [UpdatedDate] = @p75
OUTPUT 1
WHERE [Id] = @p76;
MERGE [SalesDetail] USING (
VALUES (@p77, @p78, @p79, @p80, @p81, @p82, @p83, @p84, @p85, @p86, @p87, @p88, @p89, 0),
(@p90, @p91, @p92, @p93, @p94, @p95, @p96, @p97, @p98, @p99, @p100, @p101, @p102, 1),
(@p103, @p104, @p105, @p106, @p107, @p108, @p109, @p110, @p111, @p112, @p113, @p114, @p115, 2),
(@p116, @p117, @p118, @p119, @p120, @p121, @p122, @p123, @p124, @p125, @p126, @p127, @p128, 3)) 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 (@p129, @p130, @p131, @p132, @p133, @p134, @p135, @p136, @p137, @p138, @p139, @p140, 0),
(@p141, @p142, @p143, @p144, @p145, @p146, @p147, @p148, @p149, @p150, @p151, @p152, 1),
(@p153, @p154, @p155, @p156, @p157, @p158, @p159, @p160, @p161, @p162, @p163, @p164, 2),
(@p165, @p166, @p167, @p168, @p169, @p170, @p171, @p172, @p173, @p174, @p175, @p176, 3)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[Difference], i.[Discriminator], i.[InventoryMovementHeaderId], i.[NewStock], i.[OriginaStock], i.[ProductId], i.[ProductName], i.[Reazon], i.[SalePrice])
OUTPUT INSERTED.[Id], i._Position;
2025-11-28 19:32:25.500 +00:00 [INF] Setting HTTP status code 201.
2025-11-28 19:32:25.500 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-28 19:32:25.500 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41028 - 201 0 null 190.5007ms
2025-11-28 20:08:20.625 +00:00 [INF] Request starting HTTP/1.1 GET http://localhost:5227/.env - null null
2025-11-28 20:08:20.625 +00:00 [INF] Request finished HTTP/1.1 GET http://localhost:5227/.env - 404 0 null 0.3706ms
2025-11-28 20:08:20.625 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://localhost:5227/.env, Response status code: 404
2025-11-28 20:59:23.842 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/harina - null null
2025-11-28 20:59:23.843 +00:00 [INF] CORS policy execution successful.
2025-11-28 20:59:23.843 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/harina - 204 null null 0.2252ms
2025-11-28 20:59:23.899 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/harina - null null
2025-11-28 20:59:23.899 +00:00 [INF] CORS policy execution successful.
2025-11-28 20:59:23.900 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 20:59:24.143 +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-11-28 20:59:24.152 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 20:59:24.152 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 20:59:24.259 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 20:59:24.259 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/harina - 200 null application/json; charset=utf-8 360.2825ms
2025-11-28 20:59:42.570 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/kefir - null null
2025-11-28 20:59:42.570 +00:00 [INF] CORS policy execution successful.
2025-11-28 20:59:42.571 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/kefir - 204 null null 0.9665ms
2025-11-28 20:59:42.630 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/kefir - null null
2025-11-28 20:59:42.631 +00:00 [INF] CORS policy execution successful.
2025-11-28 20:59:42.631 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 20:59:42.636 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-28 20:59:42.638 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 20:59:42.638 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 20:59:42.638 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 20:59:42.638 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/kefir - 200 null application/json; charset=utf-8 8.0764ms
2025-11-28 20:59:48.413 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - null null
2025-11-28 20:59:48.413 +00:00 [INF] CORS policy execution successful.
2025-11-28 20:59:48.413 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - 204 null null 0.2518ms
2025-11-28 20:59:48.467 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan - null null
2025-11-28 20:59:48.468 +00:00 [INF] CORS policy execution successful.
2025-11-28 20:59:48.468 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 20:59:48.470 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-28 20:59:48.478 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 20:59:48.479 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 20:59:48.479 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 20:59:48.479 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan - 200 null application/json; charset=utf-8 11.8206ms
2025-11-28 20:59:57.075 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/harina - null null
2025-11-28 20:59:57.076 +00:00 [INF] CORS policy execution successful.
2025-11-28 20:59:57.076 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/harina - 204 null null 0.465ms
2025-11-28 20:59:57.135 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/harina - null null
2025-11-28 20:59:57.136 +00:00 [INF] CORS policy execution successful.
2025-11-28 20:59:57.136 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 20:59:57.139 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-28 20:59:57.143 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 20:59:57.143 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 20:59:57.144 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 20:59:57.144 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/harina - 200 null application/json; charset=utf-8 8.2923ms
2025-11-28 21:00:24.841 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-11-28 21:00:24.841 +00:00 [INF] CORS policy execution successful.
2025-11-28 21:00:24.841 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3221ms
2025-11-28 21:00:24.900 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 179
2025-11-28 21:00:24.900 +00:00 [INF] CORS policy execution successful.
2025-11-28 21:00:24.900 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-11-28 21:00:24.907 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2025-11-28 21:00:24.910 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2025-11-28 21:00:24.911 +00:00 [INF] Setting HTTP status code 201.
2025-11-28 21:00:24.911 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-11-28 21:00:24.911 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-11-28 21:00:24.911 +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.228ms
2025-11-28 21:00:24.970 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41029 - null null
2025-11-28 21:00:24.970 +00:00 [INF] CORS policy execution successful.
2025-11-28 21:00:24.970 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41029 - 204 null null 0.3227ms
2025-11-28 21:00:25.024 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-28 21:00:25.024 +00:00 [INF] CORS policy execution successful.
2025-11-28 21:00:25.024 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3497ms
2025-11-28 21:00:25.036 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41029 - application/json 307
2025-11-28 21:00:25.036 +00:00 [INF] CORS policy execution successful.
2025-11-28 21:00:25.037 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-28 21:00:25.039 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-28 21:00:25.081 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-28 21:00:25.081 +00:00 [INF] CORS policy execution successful.
2025-11-28 21:00:25.081 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-28 21:00:25.103 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-28 21:00:25.105 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 21:00:25.105 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 21:00:25.105 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-28 21:00:25.106 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 24.6ms
2025-11-28 21:00:25.204 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2025-11-28 21:00:25.211 +00:00 [INF] Executed DbCommand (6ms) [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-11-28 21:00:25.219 +00:00 [INF] Setting HTTP status code 201.
2025-11-28 21:00:25.219 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-28 21:00:25.220 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41029 - 201 0 null 184.1228ms
2025-11-28 21:05:48.040 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jarabe - null null
2025-11-28 21:05:48.040 +00:00 [INF] CORS policy execution successful.
2025-11-28 21:05:48.040 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jarabe - 204 null null 0.2301ms
2025-11-28 21:05:48.100 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/jarabe - null null
2025-11-28 21:05:48.100 +00:00 [INF] CORS policy execution successful.
2025-11-28 21:05:48.101 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 21:05:48.368 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-28 21:05:48.371 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 21:05:48.372 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 21:05:48.372 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-28 21:05:48.372 +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 271.9262ms
2025-11-28 21:05:51.919 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1527 - null null
2025-11-28 21:05:51.920 +00:00 [INF] CORS policy execution successful.
2025-11-28 21:05:51.920 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1527 - 204 null null 0.317ms
2025-11-28 21:05:51.979 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/1527 - null null
2025-11-28 21:05:51.979 +00:00 [INF] CORS policy execution successful.
2025-11-28 21:05:51.980 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2025-11-28 21:05:51.988 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2025-11-28 21:05:51.989 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 21:05:51.989 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json.
2025-11-28 21:05:51.989 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2025-11-28 21:05:51.989 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/1527 - 200 null application/json; charset=utf-8 9.6678ms
2025-11-28 21:05:52.909 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/1527 - null null
2025-11-28 21:05:52.909 +00:00 [INF] CORS policy execution successful.
2025-11-28 21:05:52.909 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2025-11-28 21:05:52.912 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2025-11-28 21:05:52.913 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 21:05:52.914 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json.
2025-11-28 21:05:52.914 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2025-11-28 21:05:52.914 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/1527 - 200 null application/json; charset=utf-8 5.2678ms
2025-11-28 21:05:58.098 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-11-28 21:05:58.098 +00:00 [INF] CORS policy execution successful.
2025-11-28 21:05:58.098 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3185ms
2025-11-28 21:05:58.159 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2025-11-28 21:05:58.159 +00:00 [INF] CORS policy execution successful.
2025-11-28 21:05:58.159 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-11-28 21:05:58.164 +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);
2025-11-28 21:05:58.168 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2025-11-28 21:05:58.169 +00:00 [INF] Setting HTTP status code 201.
2025-11-28 21:05:58.169 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-11-28 21:05:58.169 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-11-28 21:05:58.169 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 10.319ms
2025-11-28 21:05:58.228 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41030 - null null
2025-11-28 21:05:58.228 +00:00 [INF] CORS policy execution successful.
2025-11-28 21:05:58.229 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41030 - 204 null null 0.6909ms
2025-11-28 21:05:58.288 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-28 21:05:58.288 +00:00 [INF] CORS policy execution successful.
2025-11-28 21:05:58.288 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3668ms
2025-11-28 21:05:58.298 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41030 - application/json 106
2025-11-28 21:05:58.298 +00:00 [INF] CORS policy execution successful.
2025-11-28 21:05:58.298 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-28 21:05:58.301 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-28 21:05:58.348 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-28 21:05:58.348 +00:00 [INF] CORS policy execution successful.
2025-11-28 21:05:58.349 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-28 21:05:58.380 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-28 21:05:58.381 +00:00 [INF] Setting HTTP status code 200.
2025-11-28 21:05:58.382 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-28 21:05:58.382 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-28 21:05:58.382 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 34.44ms
2025-11-28 21:05:58.486 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2025-11-28 21:05:58.489 +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-11-28 21:05:58.493 +00:00 [INF] Setting HTTP status code 201.
2025-11-28 21:05:58.493 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-28 21:05:58.493 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41030 - 201 0 null 195.7261ms