2025-11-13 02:49:33.040 +00:00 [INF] Request starting HTTP/1.1 GET http://localhost:5227/.env - null null
2025-11-13 02:49:33.042 +00:00 [INF] Request finished HTTP/1.1 GET http://localhost:5227/.env - 404 0 null 2.1101ms
2025-11-13 02:49:33.042 +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-13 09:44:22.286 +00:00 [INF] Request starting HTTP/1.1 GET http://localhost:5227/.env - null null
2025-11-13 09:44:22.287 +00:00 [INF] Request finished HTTP/1.1 GET http://localhost:5227/.env - 404 0 null 1.8933ms
2025-11-13 09:44:22.288 +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-13 12:23:08.953 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null
2025-11-13 12:23:08.953 +00:00 [INF] CORS policy execution successful.
2025-11-13 12:23:08.953 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.2867ms
2025-11-13 12:23:09.012 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 65
2025-11-13 12:23:09.013 +00:00 [INF] CORS policy execution successful.
2025-11-13 12:23:09.013 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin'
2025-11-13 12:23:09.358 +00:00 [INF] Executed DbCommand (8ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName]
FROM [AspNetUsers] AS [a]
WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0
2025-11-13 12:23:09.473 +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-13 12:23:09.474 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 12:23:09.475 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json.
2025-11-13 12:23:09.475 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin'
2025-11-13 12:23:09.475 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 462.6804ms
2025-11-13 12:34:33.807 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2025-11-13 12:34:33.807 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.3282ms
2025-11-13 12:34:33.807 +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-13 12:34:49.405 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2025-11-13 12:34:49.405 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.2673ms
2025-11-13 12:34:49.405 +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-13 12:35:02.725 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/login - null null
2025-11-13 12:35:02.725 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/login - 404 0 null 0.4088ms
2025-11-13 12:35:02.725 +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/login, Response status code: 404
2025-11-13 14:53:19.318 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2025-11-13 14:53:19.318 +00:00 [INF] CORS policy execution successful.
2025-11-13 14:53:19.318 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.3778ms
2025-11-13 14:53:19.319 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null
2025-11-13 14:53:19.319 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-13 14:53:19.319 +00:00 [INF] CORS policy execution successful.
2025-11-13 14:53:19.320 +00:00 [INF] CORS policy execution successful.
2025-11-13 14:53:19.320 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.5638ms
2025-11-13 14:53:19.320 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.5575ms
2025-11-13 14:53:19.328 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null
2025-11-13 14:53:19.329 +00:00 [INF] CORS policy execution successful.
2025-11-13 14:53:19.329 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.3455ms
2025-11-13 14:53:19.375 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null
2025-11-13 14:53:19.375 +00:00 [INF] CORS policy execution successful.
2025-11-13 14:53:19.375 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/'
2025-11-13 14:53:19.376 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2025-11-13 14:53:19.377 +00:00 [INF] CORS policy execution successful.
2025-11-13 14:53:19.377 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2025-11-13 14:53:19.379 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-13 14:53:19.379 +00:00 [INF] CORS policy execution successful.
2025-11-13 14:53:19.379 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-13 14:53:19.389 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null
2025-11-13 14:53:19.389 +00:00 [INF] CORS policy execution successful.
2025-11-13 14:53:19.390 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities'
2025-11-13 14:53:19.622 +00:00 [INF] Executed DbCommand (8ms) [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-13 14:53:19.622 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 14:53:19.622 +00:00 [INF] Writing value of type 'SettingDto' as Json.
2025-11-13 14:53:19.622 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/'
2025-11-13 14:53:19.622 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 247.6931ms
2025-11-13 14:53:19.628 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [ProductTaxes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-13 14:53:19.628 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 14:53:19.628 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 14:53:19.628 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2025-11-13 14:53:19.628 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 252.2689ms
2025-11-13 14:53:19.630 +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-13 14:53:19.630 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 14:53:19.630 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 14:53:19.630 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-13 14:53:19.630 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 251.3756ms
2025-11-13 14:53:19.631 +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-13 14:53:19.631 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 14:53:19.631 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 14:53:19.632 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities'
2025-11-13 14:53:19.632 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 242.982ms
2025-11-13 14:53:23.548 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/D3 - null null
2025-11-13 14:53:23.548 +00:00 [INF] CORS policy execution successful.
2025-11-13 14:53:23.548 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/D3 - 204 null null 0.407ms
2025-11-13 14:53:23.611 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/D3 - null null
2025-11-13 14:53:23.611 +00:00 [INF] CORS policy execution successful.
2025-11-13 14:53:23.611 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 14:53:23.615 +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-13 14:53:23.623 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 14:53:23.624 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 14:53:23.737 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 14:53:23.737 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/D3 - 200 null application/json; charset=utf-8 126.4402ms
2025-11-13 15:01:17.883 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/l - null null
2025-11-13 15:01:17.883 +00:00 [INF] CORS policy execution successful.
2025-11-13 15:01:17.883 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/l - 204 null null 0.2815ms
2025-11-13 15:01:17.953 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/l - null null
2025-11-13 15:01:17.953 +00:00 [INF] CORS policy execution successful.
2025-11-13 15:01:17.953 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 15:01:18.282 +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-13 15:01:18.459 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 15:01:18.460 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 15:01:18.999 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 15:01:19.000 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/l - 200 null application/json; charset=utf-8 1046.9202ms
2025-11-13 15:01:20.121 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/kit - null null
2025-11-13 15:01:20.121 +00:00 [INF] CORS policy execution successful.
2025-11-13 15:01:20.121 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/kit - 204 null null 0.3741ms
2025-11-13 15:01:20.305 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/kit - null null
2025-11-13 15:01:20.306 +00:00 [INF] CORS policy execution successful.
2025-11-13 15:01:20.306 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 15:01:20.311 +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-13 15:01:20.313 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 15:01:20.313 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 15:01:20.314 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 15:01:20.314 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/kit - 200 null application/json; charset=utf-8 8.5675ms
2025-11-13 15:01:40.369 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-13 15:01:40.369 +00:00 [INF] CORS policy execution successful.
2025-11-13 15:01:40.369 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.325ms
2025-11-13 15:01:40.438 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-13 15:01:40.439 +00:00 [INF] CORS policy execution successful.
2025-11-13 15:01:40.439 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-13 15:01:40.441 +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-13 15:01:40.442 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 15:01:40.442 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 15:01:40.443 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-13 15:01:40.443 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 5.0399ms
2025-11-13 16:17:56.152 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - null null
2025-11-13 16:17:56.152 +00:00 [INF] CORS policy execution successful.
2025-11-13 16:17:56.153 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - 204 null null 1.371ms
2025-11-13 16:17:56.221 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma - null null
2025-11-13 16:17:56.221 +00:00 [INF] CORS policy execution successful.
2025-11-13 16:17:56.221 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 16:17:56.556 +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-13 16:17:56.572 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 16:17:56.573 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 16:17:56.740 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 16:17:56.740 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma - 200 null application/json; charset=utf-8 519.9274ms
2025-11-13 16:18:01.740 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1415 - null null
2025-11-13 16:18:01.740 +00:00 [INF] CORS policy execution successful.
2025-11-13 16:18:01.740 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1415 - 204 null null 0.5312ms
2025-11-13 16:18:01.807 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/1415 - null null
2025-11-13 16:18:01.808 +00:00 [INF] CORS policy execution successful.
2025-11-13 16:18:01.808 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2025-11-13 16:18:01.822 +00:00 [INF] Executed DbCommand (6ms) [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-13 16:18:01.823 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 16:18:01.823 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json.
2025-11-13 16:18:01.823 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2025-11-13 16:18:01.823 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/1415 - 200 null application/json; charset=utf-8 15.9642ms
2025-11-13 16:18:06.857 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-11-13 16:18:06.857 +00:00 [INF] CORS policy execution successful.
2025-11-13 16:18:06.858 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.9288ms
2025-11-13 16:18:06.914 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2025-11-13 16:18:06.914 +00:00 [INF] CORS policy execution successful.
2025-11-13 16:18:06.914 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-11-13 16:18:06.923 +00:00 [INF] Executed DbCommand (7ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2025-11-13 16:18:06.927 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2025-11-13 16:18:06.928 +00:00 [INF] Setting HTTP status code 201.
2025-11-13 16:18:06.928 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-11-13 16:18:06.928 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-11-13 16:18:06.928 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 14.4233ms
2025-11-13 16:18:06.986 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40921 - null null
2025-11-13 16:18:06.986 +00:00 [INF] CORS policy execution successful.
2025-11-13 16:18:06.986 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40921 - 204 null null 0.3872ms
2025-11-13 16:18:07.048 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-13 16:18:07.048 +00:00 [INF] CORS policy execution successful.
2025-11-13 16:18:07.048 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3213ms
2025-11-13 16:18:07.058 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40921 - application/json 106
2025-11-13 16:18:07.058 +00:00 [INF] CORS policy execution successful.
2025-11-13 16:18:07.058 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-13 16:18:07.061 +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-13 16:18:07.108 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-13 16:18:07.108 +00:00 [INF] CORS policy execution successful.
2025-11-13 16:18:07.109 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-13 16:18:07.129 +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-13 16:18:07.129 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 16:18:07.129 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 16:18:07.130 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-13 16:18:07.130 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 21.8543ms
2025-11-13 16:18:07.254 +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-13 16:18:07.265 +00:00 [INF] Executed DbCommand (11ms) [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-13 16:18:07.271 +00:00 [INF] Setting HTTP status code 201.
2025-11-13 16:18:07.271 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-13 16:18:07.271 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40921 - 201 0 null 213.8533ms
2025-11-13 16:19:29.180 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - null null
2025-11-13 16:19:29.180 +00:00 [INF] CORS policy execution successful.
2025-11-13 16:19:29.180 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - 204 null null 0.3629ms
2025-11-13 16:19:29.245 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan - null null
2025-11-13 16:19:29.245 +00:00 [INF] CORS policy execution successful.
2025-11-13 16:19:29.245 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 16:19:29.248 +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-13 16:19:29.256 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 16:19:29.257 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 16:19:29.383 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 16:19:29.384 +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 138.7941ms
2025-11-13 16:19:42.617 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-11-13 16:19:42.617 +00:00 [INF] CORS policy execution successful.
2025-11-13 16:19:42.617 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.2917ms
2025-11-13 16:19:42.675 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 209
2025-11-13 16:19:42.676 +00:00 [INF] CORS policy execution successful.
2025-11-13 16:19:42.676 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-11-13 16:19:42.681 +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-13 16:19:42.686 +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-13 16:19:42.686 +00:00 [INF] Setting HTTP status code 201.
2025-11-13 16:19:42.686 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-11-13 16:19:42.686 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-11-13 16:19:42.686 +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.9802ms
2025-11-13 16:19:42.747 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40922 - null null
2025-11-13 16:19:42.747 +00:00 [INF] CORS policy execution successful.
2025-11-13 16:19:42.747 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40922 - 204 null null 0.2595ms
2025-11-13 16:19:42.753 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-13 16:19:42.753 +00:00 [INF] CORS policy execution successful.
2025-11-13 16:19:42.753 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3468ms
2025-11-13 16:19:42.804 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40922 - application/json 129
2025-11-13 16:19:42.805 +00:00 [INF] CORS policy execution successful.
2025-11-13 16:19:42.805 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-13 16:19:42.807 +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-13 16:19:42.810 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-13 16:19:42.810 +00:00 [INF] CORS policy execution successful.
2025-11-13 16:19:42.811 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-13 16:19:42.814 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-13 16:19:42.814 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 16:19:42.814 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 16:19:42.814 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-13 16:19:42.814 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 3.9625ms
2025-11-13 16:19:42.986 +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-13 16:19:42.989 +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-13 16:19:42.994 +00:00 [INF] Setting HTTP status code 201.
2025-11-13 16:19:42.994 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-13 16:19:42.994 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40922 - 201 0 null 190.0587ms
2025-11-13 17:09:44.913 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null
2025-11-13 17:09:44.913 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:09:44.913 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.3147ms
2025-11-13 17:09:45.054 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 58
2025-11-13 17:09:45.054 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:09:45.055 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin'
2025-11-13 17:09:45.297 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName]
FROM [AspNetUsers] AS [a]
WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0
2025-11-13 17:09:45.409 +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-13 17:09:45.409 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 17:09:45.409 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json.
2025-11-13 17:09:45.410 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin'
2025-11-13 17:09:45.410 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 355.4685ms
2025-11-13 17:09:48.804 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null
2025-11-13 17:09:48.804 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:09:48.804 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.252ms
2025-11-13 17:09:48.861 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2025-11-13 17:09:48.861 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:09:48.861 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.3623ms
2025-11-13 17:09:48.861 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - null null
2025-11-13 17:09:48.862 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:09:48.862 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - 204 null null 0.155ms
2025-11-13 17:09:48.862 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null
2025-11-13 17:09:48.862 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:09:48.863 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/'
2025-11-13 17:09:48.876 +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-13 17:09:48.876 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 17:09:48.876 +00:00 [INF] Writing value of type 'SettingDto' as Json.
2025-11-13 17:09:48.876 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/'
2025-11-13 17:09:48.876 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 13.7715ms
2025-11-13 17:09:48.918 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2025-11-13 17:09:48.918 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:09:48.918 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2025-11-13 17:09:48.919 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Products - null null
2025-11-13 17:09:48.919 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:09:48.919 +00:00 [INF] Executing endpoint 'HTTP: GET /products'
2025-11-13 17:09:48.921 +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-13 17:09:48.921 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 17:09:48.921 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 17:09:48.921 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2025-11-13 17:09:48.921 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 3.3687ms
2025-11-13 17:09:48.934 +00:00 [INF] Executed DbCommand (12ms) [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], [t].[Id], [t].[CreatedById], [t].[CreatedDate], [t].[DeleteFlag], [t].[Description], [t].[UpdatedById], [t].[UpdatedDate], [t0].[Id], [t0].[CreatedById], [t0].[CreatedDate], [t0].[DeleteFlag], [t0].[Percentage], [t0].[TaxDescription], [t0].[UpdatedById], [t0].[UpdatedDate]
FROM [Products] AS [p]
INNER JOIN (
    SELECT [p0].[Id], [p0].[CreatedById], [p0].[CreatedDate], [p0].[DeleteFlag], [p0].[Description], [p0].[UpdatedById], [p0].[UpdatedDate]
    FROM [ProductCategories] AS [p0]
    WHERE [p0].[DeleteFlag] = CAST(0 AS bit)
) AS [t] ON [p].[CategoryId] = [t].[Id]
INNER JOIN (
    SELECT [p1].[Id], [p1].[CreatedById], [p1].[CreatedDate], [p1].[DeleteFlag], [p1].[Percentage], [p1].[TaxDescription], [p1].[UpdatedById], [p1].[UpdatedDate]
    FROM [ProductTaxes] AS [p1]
    WHERE [p1].[DeleteFlag] = CAST(0 AS bit)
) AS [t0] ON [p].[ProductTaxId] = [t0].[Id]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-13 17:09:49.183 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 17:09:49.183 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 17:09:50.890 +00:00 [INF] Executed endpoint 'HTTP: GET /products'
2025-11-13 17:09:50.890 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Products - 200 null application/json; charset=utf-8 1971.6284ms
2025-11-13 17:10:58.258 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/arro - null null
2025-11-13 17:10:58.258 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:10:58.259 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/arro - 204 null null 0.8861ms
2025-11-13 17:10:58.320 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/arro - null null
2025-11-13 17:10:58.320 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:10:58.320 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 17:10:58.324 +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-13 17:10:58.329 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 17:10:58.330 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 17:10:58.495 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 17:10:58.495 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/arro - 200 null application/json; charset=utf-8 175.5605ms
2025-11-13 17:11:00.537 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/z - null null
2025-11-13 17:11:00.537 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:11:00.538 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/z - 204 null null 0.3599ms
2025-11-13 17:11:00.596 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/z - null null
2025-11-13 17:11:00.597 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:11:00.597 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 17:11:00.599 +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-13 17:11:00.618 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 17:11:00.619 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 17:11:00.905 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 17:11:00.905 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/z - 200 null application/json; charset=utf-8 308.3097ms
2025-11-13 17:12:22.725 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-13 17:12:22.725 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:12:22.725 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3076ms
2025-11-13 17:12:22.784 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-13 17:12:22.784 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:12:22.785 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-13 17:12:22.787 +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-13 17:12:22.788 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 17:12:22.788 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 17:12:22.788 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-13 17:12:22.788 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 4.1997ms
2025-11-13 17:35:17.668 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/agua - null null
2025-11-13 17:35:17.668 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:35:17.668 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/agua - 204 null null 0.3669ms
2025-11-13 17:35:17.727 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/agua - null null
2025-11-13 17:35:17.727 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:35:17.728 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 17:35:17.955 +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-13 17:35:17.956 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 17:35:17.956 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 17:35:17.956 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 17:35:17.956 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/agua - 200 null application/json; charset=utf-8 228.8236ms
2025-11-13 17:35:29.467 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/kits - null null
2025-11-13 17:35:29.467 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:35:29.467 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/kits - 204 null null 0.4475ms
2025-11-13 17:35:29.526 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/kits - null null
2025-11-13 17:35:29.526 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:35:29.526 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 17:35:29.532 +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-13 17:35:29.532 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 17:35:29.532 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 17:35:29.532 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 17:35:29.532 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/kits - 200 null application/json; charset=utf-8 6.3836ms
2025-11-13 17:35:36.288 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/potura - null null
2025-11-13 17:35:36.288 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:35:36.288 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/potura - 204 null null 0.2966ms
2025-11-13 17:35:36.344 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/potura - null null
2025-11-13 17:35:36.344 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:35:36.344 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 17:35:36.349 +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-13 17:35:36.350 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 17:35:36.350 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 17:35:36.350 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 17:35:36.350 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/potura - 200 null application/json; charset=utf-8 5.8801ms
2025-11-13 17:35:41.143 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/postura - null null
2025-11-13 17:35:41.144 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:35:41.144 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/postura - 204 null null 1.2533ms
2025-11-13 17:35:41.203 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/postura - null null
2025-11-13 17:35:41.203 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:35:41.203 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 17:35:41.208 +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-13 17:35:41.210 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 17:35:41.210 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 17:35:41.210 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 17:35:41.210 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/postura - 200 null application/json; charset=utf-8 7.4118ms
2025-11-13 17:35:46.792 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/kit - null null
2025-11-13 17:35:46.792 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:35:46.792 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/kit - 204 null null 0.2495ms
2025-11-13 17:35:46.851 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/kit - null null
2025-11-13 17:35:46.852 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:35:46.852 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 17:35:46.858 +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-13 17:35:46.858 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 17:35:46.858 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 17:35:46.859 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 17:35:46.859 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/kit - 200 null application/json; charset=utf-8 7.2083ms
2025-11-13 17:36:43.990 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-11-13 17:36:43.990 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:36:43.990 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.2789ms
2025-11-13 17:36:44.049 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2025-11-13 17:36:44.049 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:36:44.049 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-11-13 17:36:44.053 +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-13 17:36:44.058 +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-13 17:36:44.059 +00:00 [INF] Setting HTTP status code 201.
2025-11-13 17:36:44.059 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-11-13 17:36:44.059 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-11-13 17:36:44.059 +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.7949ms
2025-11-13 17:36:44.119 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40923 - null null
2025-11-13 17:36:44.119 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:36:44.119 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40923 - 204 null null 0.6777ms
2025-11-13 17:36:44.175 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-13 17:36:44.175 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:36:44.175 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.5367ms
2025-11-13 17:36:44.197 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40923 - application/json 310
2025-11-13 17:36:44.198 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:36:44.198 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-13 17:36:44.200 +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-13 17:36:44.231 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-13 17:36:44.231 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:36:44.231 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-13 17:36:44.246 +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-13 17:36:44.247 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 17:36:44.247 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 17:36:44.247 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-13 17:36:44.247 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 15.805ms
2025-11-13 17:36:44.369 +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-13 17:36:44.375 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p40='?' (DbType = Int32), @p23='?' (Size = 4000), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Int32), @p26='?' (DbType = Guid), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Boolean), @p29='?' (DbType = DateTime2), @p30='?' (DbType = Int32), @p31='?' (Size = 150), @p32='?' (Size = 500), @p33='?' (Size = -1) (DbType = Binary), @p34='?' (DbType = Int32), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p36='?' (Size = 4000), @p37='?' (DbType = Int32), @p38='?' (DbType = Guid), @p39='?' (DbType = DateTime2), @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-13 17:36:44.382 +00:00 [INF] Setting HTTP status code 201.
2025-11-13 17:36:44.383 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-13 17:36:44.383 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40923 - 201 0 null 185.4558ms
2025-11-13 17:54:41.001 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/local - null null
2025-11-13 17:54:41.001 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:54:41.001 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/local - 204 null null 0.4257ms
2025-11-13 17:54:41.061 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/local - null null
2025-11-13 17:54:41.061 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:54:41.062 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 17:54:41.301 +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-13 17:54:41.305 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 17:54:41.305 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 17:54:41.305 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 17:54:41.306 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/local - 200 null application/json; charset=utf-8 244.5083ms
2025-11-13 17:55:00.586 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-11-13 17:55:00.586 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:55:00.586 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3252ms
2025-11-13 17:55:00.647 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2025-11-13 17:55:00.647 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:55:00.647 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-11-13 17:55:00.653 +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-13 17:55:00.660 +00:00 [INF] Executed DbCommand (6ms) [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-13 17:55:00.660 +00:00 [INF] Setting HTTP status code 201.
2025-11-13 17:55:00.660 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-11-13 17:55:00.660 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-11-13 17:55:00.660 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 13.3626ms
2025-11-13 17:55:00.725 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40924 - null null
2025-11-13 17:55:00.725 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:55:00.725 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40924 - 204 null null 0.286ms
2025-11-13 17:55:00.782 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-13 17:55:00.782 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:55:00.782 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3415ms
2025-11-13 17:55:00.787 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40924 - application/json 106
2025-11-13 17:55:00.787 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:55:00.788 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-13 17:55:00.790 +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-13 17:55:00.847 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-13 17:55:00.847 +00:00 [INF] CORS policy execution successful.
2025-11-13 17:55:00.848 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-13 17:55:00.881 +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-13 17:55:00.882 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 17:55:00.882 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 17:55:00.882 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-13 17:55:00.882 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 35.2433ms
2025-11-13 17:55:00.946 +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-13 17:55:00.948 +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-13 17:55:00.953 +00:00 [INF] Setting HTTP status code 201.
2025-11-13 17:55:00.954 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-13 17:55:00.954 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40924 - 201 0 null 166.6417ms
2025-11-13 19:03:38.765 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/mix - null null
2025-11-13 19:03:38.765 +00:00 [INF] CORS policy execution successful.
2025-11-13 19:03:38.765 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/mix - 204 null null 0.297ms
2025-11-13 19:03:38.822 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/mix - null null
2025-11-13 19:03:38.822 +00:00 [INF] CORS policy execution successful.
2025-11-13 19:03:38.822 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 19:03:39.066 +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-13 19:03:39.082 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 19:03:39.082 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 19:03:39.255 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 19:03:39.255 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/mix - 200 null application/json; charset=utf-8 433.8466ms
2025-11-13 19:03:45.950 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-13 19:03:45.950 +00:00 [INF] CORS policy execution successful.
2025-11-13 19:03:45.951 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2424ms
2025-11-13 19:03:46.008 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-13 19:03:46.009 +00:00 [INF] CORS policy execution successful.
2025-11-13 19:03:46.009 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-13 19:03:46.012 +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-13 19:03:46.012 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 19:03:46.012 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 19:03:46.012 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-13 19:03:46.012 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 4.1519ms
2025-11-13 20:10:37.654 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - null null
2025-11-13 20:10:37.654 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:10:37.654 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - 204 null null 0.2947ms
2025-11-13 20:10:37.714 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - null null
2025-11-13 20:10:37.714 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:10:37.715 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2025-11-13 20:10:37.715 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2025-11-13 20:10:37.715 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - 400 0 null 0.6289ms
2025-11-13 20:10:40.583 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/suero - null null
2025-11-13 20:10:40.583 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:10:40.583 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/suero - 204 null null 0.309ms
2025-11-13 20:10:40.643 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/suero - null null
2025-11-13 20:10:40.643 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:10:40.643 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 20:10:40.952 +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-13 20:10:40.968 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 20:10:40.969 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 20:10:41.188 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 20:10:41.188 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/suero - 200 null application/json; charset=utf-8 545.7198ms
2025-11-13 20:10:45.715 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1402 - null null
2025-11-13 20:10:45.716 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:10:45.716 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1402 - 204 null null 0.2992ms
2025-11-13 20:10:45.775 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/1402 - null null
2025-11-13 20:10:45.776 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:10:45.776 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2025-11-13 20:10:45.778 +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-13 20:10:45.779 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 20:10:45.779 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json.
2025-11-13 20:10:45.779 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2025-11-13 20:10:45.779 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/1402 - 200 null application/json; charset=utf-8 4.1131ms
2025-11-13 20:10:54.120 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ozono - null null
2025-11-13 20:10:54.120 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:10:54.120 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ozono - 204 null null 0.3762ms
2025-11-13 20:10:54.190 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ozono - null null
2025-11-13 20:10:54.190 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:10:54.191 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 20:10:54.193 +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-13 20:10:54.197 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 20:10:54.197 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 20:10:54.198 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 20:10:54.198 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ozono - 200 null application/json; charset=utf-8 7.7144ms
2025-11-13 20:10:55.276 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - null null
2025-11-13 20:10:55.276 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:10:55.276 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - 204 null null 0.3196ms
2025-11-13 20:10:55.340 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - null null
2025-11-13 20:10:55.340 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:10:55.341 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2025-11-13 20:10:55.341 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2025-11-13 20:10:55.341 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - 400 0 null 0.6983ms
2025-11-13 20:12:00.347 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-11-13 20:12:00.347 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:12:00.347 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.2854ms
2025-11-13 20:12:00.406 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2025-11-13 20:12:00.406 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:12:00.406 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-11-13 20:12:00.410 +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-13 20:12:00.413 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2025-11-13 20:12:00.413 +00:00 [INF] Setting HTTP status code 201.
2025-11-13 20:12:00.413 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-11-13 20:12:00.414 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-11-13 20:12:00.414 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 7.9522ms
2025-11-13 20:12:00.476 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40925 - null null
2025-11-13 20:12:00.476 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:12:00.476 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40925 - 204 null null 0.2759ms
2025-11-13 20:12:00.536 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-13 20:12:00.536 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:12:00.536 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2175ms
2025-11-13 20:12:00.545 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40925 - application/json 211
2025-11-13 20:12:00.546 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:12:00.546 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-13 20:12:00.548 +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-13 20:12:00.596 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-13 20:12:00.596 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:12:00.596 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-13 20:12:00.611 +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-13 20:12:00.611 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 20:12:00.611 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 20:12:00.611 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-13 20:12:00.611 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 15.8882ms
2025-11-13 20:12:00.679 +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-13 20:12:00.683 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p40='?' (DbType = Int32), @p23='?' (Size = 4000), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Int32), @p26='?' (DbType = Guid), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Boolean), @p29='?' (DbType = DateTime2), @p30='?' (DbType = Int32), @p31='?' (Size = 150), @p32='?' (Size = 500), @p33='?' (Size = -1) (DbType = Binary), @p34='?' (DbType = Int32), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p36='?' (Size = 4000), @p37='?' (DbType = Int32), @p38='?' (DbType = Guid), @p39='?' (DbType = DateTime2), @p41='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p42='?' (DbType = Guid), @p43='?' (DbType = DateTime2), @p44='?' (DbType = Boolean), @p45='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p46='?' (DbType = Int32), @p47='?' (DbType = Int32), @p48='?' (DbType = Int64), @p49='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p50='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p51='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p52='?' (DbType = Guid), @p53='?' (DbType = DateTime2), @p54='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p55='?' (DbType = Guid), @p56='?' (DbType = DateTime2), @p57='?' (DbType = Boolean), @p58='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p59='?' (DbType = Int32), @p60='?' (DbType = Int32), @p61='?' (DbType = Int64), @p62='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p63='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p64='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p65='?' (DbType = Guid), @p66='?' (DbType = DateTime2), @p67='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p68='?' (DbType = Guid), @p69='?' (DbType = DateTime2), @p70='?' (DbType = Int32), @p71='?' (Size = 34), @p72='?' (DbType = Guid), @p73='?' (DbType = Int32), @p74='?' (DbType = Int32), @p75='?' (DbType = Int32), @p76='?' (Size = 4000), @p77='?' (Size = 4000), @p78='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p79='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p80='?' (DbType = Guid), @p81='?' (DbType = DateTime2), @p82='?' (DbType = Int32), @p83='?' (Size = 34), @p84='?' (DbType = Guid), @p85='?' (DbType = Int32), @p86='?' (DbType = Int32), @p87='?' (DbType = Int32), @p88='?' (Size = 4000), @p89='?' (Size = 4000), @p90='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
UPDATE [Products] SET [BarCode] = @p23, [BuyPrice] = @p24, [CategoryId] = @p25, [CreatedById] = @p26, [CreatedDate] = @p27, [DeleteFlag] = @p28, [ExpirationDate] = @p29, [MinimunStock] = @p30, [Name] = @p31, [Note] = @p32, [ProductImage] = @p33, [ProductTaxId] = @p34, [SalePrice] = @p35, [Status] = @p36, [Stock] = @p37, [UpdatedById] = @p38, [UpdatedDate] = @p39
OUTPUT 1
WHERE [Id] = @p40;
MERGE [SalesDetail] USING (
VALUES (@p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52, @p53, 0),
(@p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62, @p63, @p64, @p65, @p66, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[DeleteFlag], i.[DiscountAmount], i.[ProductId], i.[Quantity], i.[SalesId], i.[Tax], i.[Total], i.[UnitPrice], i.[UpdatedById], i.[UpdatedDate])
OUTPUT INSERTED.[Id], i._Position;
MERGE [InventoryMovements] USING (
VALUES (@p67, @p68, @p69, @p70, @p71, @p72, @p73, @p74, @p75, @p76, @p77, @p78, 0),
(@p79, @p80, @p81, @p82, @p83, @p84, @p85, @p86, @p87, @p88, @p89, @p90, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[Difference], i.[Discriminator], i.[InventoryMovementHeaderId], i.[NewStock], i.[OriginaStock], i.[ProductId], i.[ProductName], i.[Reazon], i.[SalePrice])
OUTPUT INSERTED.[Id], i._Position;
2025-11-13 20:12:00.686 +00:00 [INF] Setting HTTP status code 201.
2025-11-13 20:12:00.686 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-13 20:12:00.686 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40925 - 201 0 null 140.553ms
2025-11-13 20:21:15.323 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2025-11-13 20:21:15.323 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.3254ms
2025-11-13 20:21:15.323 +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-13 20:23:25.806 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - null null
2025-11-13 20:23:25.807 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:23:25.807 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - 204 null null 1.2605ms
2025-11-13 20:23:25.863 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma - null null
2025-11-13 20:23:25.864 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:23:25.864 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 20:23:26.187 +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-13 20:23:26.201 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 20:23:26.202 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 20:23:26.366 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 20:23:26.367 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma - 200 null application/json; charset=utf-8 504.0776ms
2025-11-13 20:23:37.343 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/terapia - null null
2025-11-13 20:23:37.344 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:23:37.344 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/terapia - 204 null null 0.2493ms
2025-11-13 20:23:37.403 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/terapia - null null
2025-11-13 20:23:37.403 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:23:37.403 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 20:23:37.406 +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-13 20:23:37.414 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 20:23:37.414 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 20:23:37.580 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 20:23:37.580 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/terapia - 200 null application/json; charset=utf-8 177.2997ms
2025-11-13 20:23:38.747 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - null null
2025-11-13 20:23:38.747 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:23:38.747 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - 204 null null 0.64ms
2025-11-13 20:23:38.808 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - null null
2025-11-13 20:23:38.808 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:23:38.808 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2025-11-13 20:23:38.808 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2025-11-13 20:23:38.808 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - 400 0 null 0.5357ms
2025-11-13 20:23:58.042 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-11-13 20:23:58.042 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:23:58.043 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3801ms
2025-11-13 20:23:58.101 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2025-11-13 20:23:58.102 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:23:58.102 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-11-13 20:23:58.106 +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-13 20:23:58.109 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2025-11-13 20:23:58.110 +00:00 [INF] Setting HTTP status code 201.
2025-11-13 20:23:58.110 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-11-13 20:23:58.110 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-11-13 20:23:58.110 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 8.2748ms
2025-11-13 20:23:58.171 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40926 - null null
2025-11-13 20:23:58.171 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:23:58.171 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40926 - 204 null null 0.3652ms
2025-11-13 20:23:58.228 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-13 20:23:58.228 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:23:58.228 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3129ms
2025-11-13 20:23:58.239 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40926 - application/json 211
2025-11-13 20:23:58.239 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:23:58.239 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-13 20:23:58.242 +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-13 20:23:58.288 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-13 20:23:58.288 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:23:58.288 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-13 20:23:58.305 +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-13 20:23:58.305 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 20:23:58.305 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 20:23:58.306 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-13 20:23:58.306 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 18.0615ms
2025-11-13 20:23:58.393 +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-13 20:23:58.397 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p40='?' (DbType = Int32), @p23='?' (Size = 4000), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Int32), @p26='?' (DbType = Guid), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Boolean), @p29='?' (DbType = DateTime2), @p30='?' (DbType = Int32), @p31='?' (Size = 150), @p32='?' (Size = 500), @p33='?' (Size = -1) (DbType = Binary), @p34='?' (DbType = Int32), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p36='?' (Size = 4000), @p37='?' (DbType = Int32), @p38='?' (DbType = Guid), @p39='?' (DbType = DateTime2), @p41='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p42='?' (DbType = Guid), @p43='?' (DbType = DateTime2), @p44='?' (DbType = Boolean), @p45='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p46='?' (DbType = Int32), @p47='?' (DbType = Int32), @p48='?' (DbType = Int64), @p49='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p50='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p51='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p52='?' (DbType = Guid), @p53='?' (DbType = DateTime2), @p54='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p55='?' (DbType = Guid), @p56='?' (DbType = DateTime2), @p57='?' (DbType = Boolean), @p58='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p59='?' (DbType = Int32), @p60='?' (DbType = Int32), @p61='?' (DbType = Int64), @p62='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p63='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p64='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p65='?' (DbType = Guid), @p66='?' (DbType = DateTime2), @p67='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p68='?' (DbType = Guid), @p69='?' (DbType = DateTime2), @p70='?' (DbType = Int32), @p71='?' (Size = 34), @p72='?' (DbType = Guid), @p73='?' (DbType = Int32), @p74='?' (DbType = Int32), @p75='?' (DbType = Int32), @p76='?' (Size = 4000), @p77='?' (Size = 4000), @p78='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p79='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p80='?' (DbType = Guid), @p81='?' (DbType = DateTime2), @p82='?' (DbType = Int32), @p83='?' (Size = 34), @p84='?' (DbType = Guid), @p85='?' (DbType = Int32), @p86='?' (DbType = Int32), @p87='?' (DbType = Int32), @p88='?' (Size = 4000), @p89='?' (Size = 4000), @p90='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
UPDATE [Products] SET [BarCode] = @p23, [BuyPrice] = @p24, [CategoryId] = @p25, [CreatedById] = @p26, [CreatedDate] = @p27, [DeleteFlag] = @p28, [ExpirationDate] = @p29, [MinimunStock] = @p30, [Name] = @p31, [Note] = @p32, [ProductImage] = @p33, [ProductTaxId] = @p34, [SalePrice] = @p35, [Status] = @p36, [Stock] = @p37, [UpdatedById] = @p38, [UpdatedDate] = @p39
OUTPUT 1
WHERE [Id] = @p40;
MERGE [SalesDetail] USING (
VALUES (@p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52, @p53, 0),
(@p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62, @p63, @p64, @p65, @p66, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[DeleteFlag], i.[DiscountAmount], i.[ProductId], i.[Quantity], i.[SalesId], i.[Tax], i.[Total], i.[UnitPrice], i.[UpdatedById], i.[UpdatedDate])
OUTPUT INSERTED.[Id], i._Position;
MERGE [InventoryMovements] USING (
VALUES (@p67, @p68, @p69, @p70, @p71, @p72, @p73, @p74, @p75, @p76, @p77, @p78, 0),
(@p79, @p80, @p81, @p82, @p83, @p84, @p85, @p86, @p87, @p88, @p89, @p90, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[Difference], i.[Discriminator], i.[InventoryMovementHeaderId], i.[NewStock], i.[OriginaStock], i.[ProductId], i.[ProductName], i.[Reazon], i.[SalePrice])
OUTPUT INSERTED.[Id], i._Position;
2025-11-13 20:23:58.402 +00:00 [INF] Setting HTTP status code 201.
2025-11-13 20:23:58.402 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-13 20:23:58.402 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40926 - 201 0 null 163.5377ms
2025-11-13 20:36:39.403 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/allergy - null null
2025-11-13 20:36:39.403 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:36:39.403 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/allergy - 204 null null 0.297ms
2025-11-13 20:36:39.462 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/allergy - null null
2025-11-13 20:36:39.462 +00:00 [INF] CORS policy execution successful.
2025-11-13 20:36:39.462 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 20:36:39.692 +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-13 20:36:39.697 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 20:36:39.697 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 20:36:39.697 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 20:36:39.697 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/allergy - 200 null application/json; charset=utf-8 235.4099ms
2025-11-13 21:07:16.538 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null
2025-11-13 21:07:16.538 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:07:16.539 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.3539ms
2025-11-13 21:07:16.598 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 61
2025-11-13 21:07:16.598 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:07:16.599 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin'
2025-11-13 21:07:16.880 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName]
FROM [AspNetUsers] AS [a]
WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0
2025-11-13 21:07:16.996 +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-13 21:07:16.997 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 21:07:16.997 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json.
2025-11-13 21:07:16.998 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin'
2025-11-13 21:07:16.998 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 399.5457ms
2025-11-13 21:07:37.258 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-13 21:07:37.259 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:07:37.259 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2465ms
2025-11-13 21:07:37.314 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null
2025-11-13 21:07:37.315 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:07:37.315 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.7619ms
2025-11-13 21:07:37.316 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2025-11-13 21:07:37.316 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:07:37.316 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.1806ms
2025-11-13 21:07:37.317 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null
2025-11-13 21:07:37.317 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:07:37.317 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.1628ms
2025-11-13 21:07:37.323 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-13 21:07:37.323 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:07:37.324 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-13 21:07:37.341 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-13 21:07:37.342 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 21:07:37.342 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 21:07:37.342 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-13 21:07:37.342 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 19.4495ms
2025-11-13 21:07:37.371 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2025-11-13 21:07:37.371 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:07:37.372 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2025-11-13 21:07:37.372 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null
2025-11-13 21:07:37.373 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:07:37.373 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/'
2025-11-13 21:07:37.374 +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-13 21:07:37.375 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 21:07:37.375 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 21:07:37.375 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2025-11-13 21:07:37.375 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 3.5507ms
2025-11-13 21:07:37.376 +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-13 21:07:37.377 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 21:07:37.377 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null
2025-11-13 21:07:37.377 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:07:37.377 +00:00 [INF] Writing value of type 'SettingDto' as Json.
2025-11-13 21:07:37.377 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities'
2025-11-13 21:07:37.378 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/'
2025-11-13 21:07:37.378 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 5.4132ms
2025-11-13 21:07:37.380 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [n].[Id], [n].[Descripcion], [n].[Estatus], [n].[Gentilicio], [n].[Siglas]
FROM [Nationalities] AS [n]
2025-11-13 21:07:37.381 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 21:07:37.381 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 21:07:37.381 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities'
2025-11-13 21:07:37.382 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 4.7863ms
2025-11-13 21:07:52.231 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/cancer - null null
2025-11-13 21:07:52.231 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:07:52.231 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/cancer - 204 null null 0.233ms
2025-11-13 21:07:52.290 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/cancer - null null
2025-11-13 21:07:52.291 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:07:52.291 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 21:07:52.295 +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-13 21:07:52.298 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 21:07:52.298 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 21:07:52.298 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 21:07:52.298 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/cancer - 200 null application/json; charset=utf-8 7.5539ms
2025-11-13 21:11:01.285 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colageno - null null
2025-11-13 21:11:01.286 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:11:01.286 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colageno - 204 null null 0.3538ms
2025-11-13 21:11:01.348 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/colageno - null null
2025-11-13 21:11:01.348 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:11:01.348 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 21:11:01.353 +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-13 21:11:01.356 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 21:11:01.356 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 21:11:01.357 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 21:11:01.357 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/colageno - 200 null application/json; charset=utf-8 9.6386ms
2025-11-13 21:11:09.796 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/glucosamina - null null
2025-11-13 21:11:09.796 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:11:09.796 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/glucosamina - 204 null null 0.3068ms
2025-11-13 21:11:09.856 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/glucosamina - null null
2025-11-13 21:11:09.856 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:11:09.856 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 21:11:09.860 +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-13 21:11:09.863 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 21:11:09.863 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 21:11:09.863 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 21:11:09.863 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/glucosamina - 200 null application/json; charset=utf-8 7.2361ms
2025-11-13 21:12:00.942 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/msm - null null
2025-11-13 21:12:00.942 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:12:00.942 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/msm - 204 null null 0.2981ms
2025-11-13 21:12:01.001 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/msm - null null
2025-11-13 21:12:01.001 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:12:01.002 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 21:12:01.004 +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-13 21:12:01.007 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 21:12:01.007 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 21:12:01.007 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 21:12:01.007 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/msm - 200 null application/json; charset=utf-8 6.3154ms
2025-11-13 21:12:08.823 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/triple - null null
2025-11-13 21:12:08.823 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:12:08.823 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/triple - 204 null null 0.3418ms
2025-11-13 21:12:08.883 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/triple - null null
2025-11-13 21:12:08.883 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:12:08.883 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 21:12:08.887 +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-13 21:12:08.889 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 21:12:08.889 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 21:12:08.889 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 21:12:08.890 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/triple - 200 null application/json; charset=utf-8 6.8179ms
2025-11-13 21:12:24.780 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/co - null null
2025-11-13 21:12:24.780 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:12:24.781 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/co - 204 null null 0.3746ms
2025-11-13 21:12:24.840 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/co - null null
2025-11-13 21:12:24.840 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:12:24.840 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 21:12:24.842 +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-13 21:12:24.887 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 21:12:24.888 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 21:12:25.235 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 21:12:25.236 +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 396.1052ms
2025-11-13 21:13:28.645 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/anti - null null
2025-11-13 21:13:28.645 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:13:28.645 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/anti - 204 null null 0.2533ms
2025-11-13 21:13:28.705 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/anti - null null
2025-11-13 21:13:28.706 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:13:28.706 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 21:13:28.709 +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-13 21:13:28.714 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 21:13:28.714 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 21:13:28.715 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 21:13:28.715 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/anti - 200 null application/json; charset=utf-8 9.378ms
2025-11-13 21:13:37.163 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/alpha - null null
2025-11-13 21:13:37.165 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:13:37.165 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/alpha - 204 null null 1.7346ms
2025-11-13 21:13:37.223 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/alpha - null null
2025-11-13 21:13:37.223 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:13:37.224 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 21:13:37.226 +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-13 21:13:37.229 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 21:13:37.229 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 21:13:37.230 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 21:13:37.230 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/alpha - 200 null application/json; charset=utf-8 6.7932ms
2025-11-13 21:13:49.742 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ksm - null null
2025-11-13 21:13:49.742 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:13:49.742 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ksm - 204 null null 0.2511ms
2025-11-13 21:13:49.801 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ksm - null null
2025-11-13 21:13:49.801 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:13:49.802 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 21:13:49.806 +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-13 21:13:49.807 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 21:13:49.808 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 21:13:49.808 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 21:13:49.808 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ksm - 200 null application/json; charset=utf-8 7.1133ms
2025-11-13 21:14:25.835 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jugo - null null
2025-11-13 21:14:25.835 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:14:25.835 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jugo - 204 null null 0.2984ms
2025-11-13 21:14:25.903 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/jugo - null null
2025-11-13 21:14:25.903 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:14:25.903 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 21:14:25.906 +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-13 21:14:25.909 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 21:14:25.909 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 21:14:25.909 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 21:14:25.909 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/jugo - 200 null application/json; charset=utf-8 6.3714ms
2025-11-13 21:15:14.442 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - null null
2025-11-13 21:15:14.443 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:15:14.443 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - 204 null null 0.2537ms
2025-11-13 21:15:14.502 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan - null null
2025-11-13 21:15:14.503 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:15:14.503 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 21:15:14.506 +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-13 21:15:14.513 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 21:15:14.514 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 21:15:14.515 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 21:15:14.515 +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 12.3592ms
2025-11-13 21:15:29.316 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/sara - null null
2025-11-13 21:15:29.316 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:15:29.316 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/sara - 204 null null 0.2577ms
2025-11-13 21:15:29.379 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/sara - null null
2025-11-13 21:15:29.379 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:15:29.379 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 21:15:29.382 +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-13 21:15:29.385 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 21:15:29.385 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 21:15:29.390 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 21:15:29.391 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/sara - 200 null application/json; charset=utf-8 11.9522ms
2025-11-13 21:17:54.697 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-11-13 21:17:54.698 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:17:54.698 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.4078ms
2025-11-13 21:17:54.757 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 221
2025-11-13 21:17:54.758 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:17:54.758 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-11-13 21:17:55.072 +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-13 21:17:55.077 +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-13 21:17:55.077 +00:00 [INF] Setting HTTP status code 201.
2025-11-13 21:17:55.077 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-11-13 21:17:55.078 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-11-13 21:17:55.078 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 320.2211ms
2025-11-13 21:17:55.140 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40927 - null null
2025-11-13 21:17:55.140 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:17:55.141 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40927 - 204 null null 0.3661ms
2025-11-13 21:17:55.198 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-13 21:17:55.198 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:17:55.198 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3401ms
2025-11-13 21:17:55.216 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40927 - application/json 1158
2025-11-13 21:17:55.217 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:17:55.217 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-13 21:17:55.220 +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-13 21:17:55.254 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-13 21:17:55.254 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:17:55.255 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-13 21:17:55.280 +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-13 21:17:55.280 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 21:17:55.280 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 21:17:55.280 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-13 21:17:55.280 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 26.0972ms
2025-11-13 21:17:55.409 +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-13 21:17:55.537 +00:00 [INF] Executed DbCommand (126ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p40='?' (DbType = Int32), @p23='?' (Size = 4000), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Int32), @p26='?' (DbType = Guid), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Boolean), @p29='?' (DbType = DateTime2), @p30='?' (DbType = Int32), @p31='?' (Size = 150), @p32='?' (Size = 500), @p33='?' (Size = -1) (DbType = Binary), @p34='?' (DbType = Int32), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p36='?' (Size = 4000), @p37='?' (DbType = Int32), @p38='?' (DbType = Guid), @p39='?' (DbType = DateTime2), @p58='?' (DbType = Int32), @p41='?' (Size = 4000), @p42='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p43='?' (DbType = Int32), @p44='?' (DbType = Guid), @p45='?' (DbType = DateTime2), @p46='?' (DbType = Boolean), @p47='?' (DbType = DateTime2), @p48='?' (DbType = Int32), @p49='?' (Size = 150), @p50='?' (Size = 500), @p51='?' (Size = -1) (DbType = Binary), @p52='?' (DbType = Int32), @p53='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p54='?' (Size = 4000), @p55='?' (DbType = Int32), @p56='?' (DbType = Guid), @p57='?' (DbType = DateTime2), @p76='?' (DbType = Int32), @p59='?' (Size = 4000), @p60='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p61='?' (DbType = Int32), @p62='?' (DbType = Guid), @p63='?' (DbType = DateTime2), @p64='?' (DbType = Boolean), @p65='?' (DbType = DateTime2), @p66='?' (DbType = Int32), @p67='?' (Size = 150), @p68='?' (Size = 500), @p69='?' (Size = -1) (DbType = Binary), @p70='?' (DbType = Int32), @p71='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p72='?' (Size = 4000), @p73='?' (DbType = Int32), @p74='?' (DbType = Guid), @p75='?' (DbType = DateTime2), @p94='?' (DbType = Int32), @p77='?' (Size = 4000), @p78='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p79='?' (DbType = Int32), @p80='?' (DbType = Guid), @p81='?' (DbType = DateTime2), @p82='?' (DbType = Boolean), @p83='?' (DbType = DateTime2), @p84='?' (DbType = Int32), @p85='?' (Size = 150), @p86='?' (Size = 500), @p87='?' (Size = -1) (DbType = Binary), @p88='?' (DbType = Int32), @p89='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p90='?' (Size = 4000), @p91='?' (DbType = Int32), @p92='?' (DbType = Guid), @p93='?' (DbType = DateTime2), @p112='?' (DbType = Int32), @p95='?' (Size = 4000), @p96='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p97='?' (DbType = Int32), @p98='?' (DbType = Guid), @p99='?' (DbType = DateTime2), @p100='?' (DbType = Boolean), @p101='?' (DbType = DateTime2), @p102='?' (DbType = Int32), @p103='?' (Size = 150), @p104='?' (Size = 500), @p105='?' (Size = -1) (DbType = Binary), @p106='?' (DbType = Int32), @p107='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p108='?' (Size = 4000), @p109='?' (DbType = Int32), @p110='?' (DbType = Guid), @p111='?' (DbType = DateTime2), @p130='?' (DbType = Int32), @p113='?' (Size = 4000), @p114='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p115='?' (DbType = Int32), @p116='?' (DbType = Guid), @p117='?' (DbType = DateTime2), @p118='?' (DbType = Boolean), @p119='?' (DbType = DateTime2), @p120='?' (DbType = Int32), @p121='?' (Size = 150), @p122='?' (Size = 500), @p123='?' (Size = -1) (DbType = Binary), @p124='?' (DbType = Int32), @p125='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p126='?' (Size = 4000), @p127='?' (DbType = Int32), @p128='?' (DbType = Guid), @p129='?' (DbType = DateTime2), @p148='?' (DbType = Int32), @p131='?' (Size = 4000), @p132='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p133='?' (DbType = Int32), @p134='?' (DbType = Guid), @p135='?' (DbType = DateTime2), @p136='?' (DbType = Boolean), @p137='?' (DbType = DateTime2), @p138='?' (DbType = Int32), @p139='?' (Size = 150), @p140='?' (Size = 500), @p141='?' (Size = -1) (DbType = Binary), @p142='?' (DbType = Int32), @p143='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p144='?' (Size = 4000), @p145='?' (DbType = Int32), @p146='?' (DbType = Guid), @p147='?' (DbType = DateTime2), @p166='?' (DbType = Int32), @p149='?' (Size = 4000), @p150='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p151='?' (DbType = Int32), @p152='?' (DbType = Guid), @p153='?' (DbType = DateTime2), @p154='?' (DbType = Boolean), @p155='?' (DbType = DateTime2), @p156='?' (DbType = Int32), @p157='?' (Size = 150), @p158='?' (Size = 500), @p159='?' (Size = -1) (DbType = Binary), @p160='?' (DbType = Int32), @p161='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p162='?' (Size = 4000), @p163='?' (DbType = Int32), @p164='?' (DbType = Guid), @p165='?' (DbType = DateTime2), @p184='?' (DbType = Int32), @p167='?' (Size = 4000), @p168='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p169='?' (DbType = Int32), @p170='?' (DbType = Guid), @p171='?' (DbType = DateTime2), @p172='?' (DbType = Boolean), @p173='?' (DbType = DateTime2), @p174='?' (DbType = Int32), @p175='?' (Size = 150), @p176='?' (Size = 500), @p177='?' (Size = -1) (DbType = Binary), @p178='?' (DbType = Int32), @p179='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p180='?' (Size = 4000), @p181='?' (DbType = Int32), @p182='?' (DbType = Guid), @p183='?' (DbType = DateTime2), @p202='?' (DbType = Int32), @p185='?' (Size = 4000), @p186='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p187='?' (DbType = Int32), @p188='?' (DbType = Guid), @p189='?' (DbType = DateTime2), @p190='?' (DbType = Boolean), @p191='?' (DbType = DateTime2), @p192='?' (DbType = Int32), @p193='?' (Size = 150), @p194='?' (Size = 500), @p195='?' (Size = -1) (DbType = Binary), @p196='?' (DbType = Int32), @p197='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p198='?' (Size = 4000), @p199='?' (DbType = Int32), @p200='?' (DbType = Guid), @p201='?' (DbType = DateTime2), @p203='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p204='?' (DbType = Guid), @p205='?' (DbType = DateTime2), @p206='?' (DbType = Boolean), @p207='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p208='?' (DbType = Int32), @p209='?' (DbType = Int32), @p210='?' (DbType = Int64), @p211='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p212='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p213='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p214='?' (DbType = Guid), @p215='?' (DbType = DateTime2), @p216='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p217='?' (DbType = Guid), @p218='?' (DbType = DateTime2), @p219='?' (DbType = Boolean), @p220='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p221='?' (DbType = Int32), @p222='?' (DbType = Int32), @p223='?' (DbType = Int64), @p224='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p225='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p226='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p227='?' (DbType = Guid), @p228='?' (DbType = DateTime2), @p229='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p230='?' (DbType = Guid), @p231='?' (DbType = DateTime2), @p232='?' (DbType = Boolean), @p233='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p234='?' (DbType = Int32), @p235='?' (DbType = Int32), @p236='?' (DbType = Int64), @p237='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p238='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p239='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p240='?' (DbType = Guid), @p241='?' (DbType = DateTime2), @p242='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p243='?' (DbType = Guid), @p244='?' (DbType = DateTime2), @p245='?' (DbType = Boolean), @p246='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p247='?' (DbType = Int32), @p248='?' (DbType = Int32), @p249='?' (DbType = Int64), @p250='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p251='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p252='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p253='?' (DbType = Guid), @p254='?' (DbType = DateTime2), @p255='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p256='?' (DbType = Guid), @p257='?' (DbType = DateTime2), @p258='?' (DbType = Boolean), @p259='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p260='?' (DbType = Int32), @p261='?' (DbType = Int32), @p262='?' (DbType = Int64), @p263='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p264='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p265='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p266='?' (DbType = Guid), @p267='?' (DbType = DateTime2), @p268='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p269='?' (DbType = Guid), @p270='?' (DbType = DateTime2), @p271='?' (DbType = Boolean), @p272='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p273='?' (DbType = Int32), @p274='?' (DbType = Int32), @p275='?' (DbType = Int64), @p276='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p277='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p278='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p279='?' (DbType = Guid), @p280='?' (DbType = DateTime2), @p281='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p282='?' (DbType = Guid), @p283='?' (DbType = DateTime2), @p284='?' (DbType = Boolean), @p285='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p286='?' (DbType = Int32), @p287='?' (DbType = Int32), @p288='?' (DbType = Int64), @p289='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p290='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p291='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p292='?' (DbType = Guid), @p293='?' (DbType = DateTime2), @p294='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p295='?' (DbType = Guid), @p296='?' (DbType = DateTime2), @p297='?' (DbType = Boolean), @p298='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p299='?' (DbType = Int32), @p300='?' (DbType = Int32), @p301='?' (DbType = Int64), @p302='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p303='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p304='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p305='?' (DbType = Guid), @p306='?' (DbType = DateTime2), @p307='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p308='?' (DbType = Guid), @p309='?' (DbType = DateTime2), @p310='?' (DbType = Boolean), @p311='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p312='?' (DbType = Int32), @p313='?' (DbType = Int32), @p314='?' (DbType = Int64), @p315='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p316='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p317='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p318='?' (DbType = Guid), @p319='?' (DbType = DateTime2), @p320='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p321='?' (DbType = Guid), @p322='?' (DbType = DateTime2), @p323='?' (DbType = Boolean), @p324='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p325='?' (DbType = Int32), @p326='?' (DbType = Int32), @p327='?' (DbType = Int64), @p328='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p329='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p330='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p331='?' (DbType = Guid), @p332='?' (DbType = DateTime2), @p333='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p334='?' (DbType = Guid), @p335='?' (DbType = DateTime2), @p336='?' (DbType = Boolean), @p337='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p338='?' (DbType = Int32), @p339='?' (DbType = Int32), @p340='?' (DbType = Int64), @p341='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p342='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p343='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p344='?' (DbType = Guid), @p345='?' (DbType = DateTime2), @p346='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p347='?' (DbType = Guid), @p348='?' (DbType = DateTime2), @p349='?' (DbType = Int32), @p350='?' (Size = 34), @p351='?' (DbType = Guid), @p352='?' (DbType = Int32), @p353='?' (DbType = Int32), @p354='?' (DbType = Int32), @p355='?' (Size = 4000), @p356='?' (Size = 4000), @p357='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p358='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p359='?' (DbType = Guid), @p360='?' (DbType = DateTime2), @p361='?' (DbType = Int32), @p362='?' (Size = 34), @p363='?' (DbType = Guid), @p364='?' (DbType = Int32), @p365='?' (DbType = Int32), @p366='?' (DbType = Int32), @p367='?' (Size = 4000), @p368='?' (Size = 4000), @p369='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p370='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p371='?' (DbType = Guid), @p372='?' (DbType = DateTime2), @p373='?' (DbType = Int32), @p374='?' (Size = 34), @p375='?' (DbType = Guid), @p376='?' (DbType = Int32), @p377='?' (DbType = Int32), @p378='?' (DbType = Int32), @p379='?' (Size = 4000), @p380='?' (Size = 4000), @p381='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p382='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p383='?' (DbType = Guid), @p384='?' (DbType = DateTime2), @p385='?' (DbType = Int32), @p386='?' (Size = 34), @p387='?' (DbType = Guid), @p388='?' (DbType = Int32), @p389='?' (DbType = Int32), @p390='?' (DbType = Int32), @p391='?' (Size = 4000), @p392='?' (Size = 4000), @p393='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p394='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p395='?' (DbType = Guid), @p396='?' (DbType = DateTime2), @p397='?' (DbType = Int32), @p398='?' (Size = 34), @p399='?' (DbType = Guid), @p400='?' (DbType = Int32), @p401='?' (DbType = Int32), @p402='?' (DbType = Int32), @p403='?' (Size = 4000), @p404='?' (Size = 4000), @p405='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p406='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p407='?' (DbType = Guid), @p408='?' (DbType = DateTime2), @p409='?' (DbType = Int32), @p410='?' (Size = 34), @p411='?' (DbType = Guid), @p412='?' (DbType = Int32), @p413='?' (DbType = Int32), @p414='?' (DbType = Int32), @p415='?' (Size = 4000), @p416='?' (Size = 4000), @p417='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p418='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p419='?' (DbType = Guid), @p420='?' (DbType = DateTime2), @p421='?' (DbType = Int32), @p422='?' (Size = 34), @p423='?' (DbType = Guid), @p424='?' (DbType = Int32), @p425='?' (DbType = Int32), @p426='?' (DbType = Int32), @p427='?' (Size = 4000), @p428='?' (Size = 4000), @p429='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p430='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p431='?' (DbType = Guid), @p432='?' (DbType = DateTime2), @p433='?' (DbType = Int32), @p434='?' (Size = 34), @p435='?' (DbType = Guid), @p436='?' (DbType = Int32), @p437='?' (DbType = Int32), @p438='?' (DbType = Int32), @p439='?' (Size = 4000), @p440='?' (Size = 4000), @p441='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p442='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p443='?' (DbType = Guid), @p444='?' (DbType = DateTime2), @p445='?' (DbType = Int32), @p446='?' (Size = 34), @p447='?' (DbType = Guid), @p448='?' (DbType = Int32), @p449='?' (DbType = Int32), @p450='?' (DbType = Int32), @p451='?' (Size = 4000), @p452='?' (Size = 4000), @p453='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p454='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p455='?' (DbType = Guid), @p456='?' (DbType = DateTime2), @p457='?' (DbType = Int32), @p458='?' (Size = 34), @p459='?' (DbType = Guid), @p460='?' (DbType = Int32), @p461='?' (DbType = Int32), @p462='?' (DbType = Int32), @p463='?' (Size = 4000), @p464='?' (Size = 4000), @p465='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p466='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p467='?' (DbType = Guid), @p468='?' (DbType = DateTime2), @p469='?' (DbType = Int32), @p470='?' (Size = 34), @p471='?' (DbType = Guid), @p472='?' (DbType = Int32), @p473='?' (DbType = Int32), @p474='?' (DbType = Int32), @p475='?' (Size = 4000), @p476='?' (Size = 4000), @p477='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
UPDATE [Products] SET [BarCode] = @p23, [BuyPrice] = @p24, [CategoryId] = @p25, [CreatedById] = @p26, [CreatedDate] = @p27, [DeleteFlag] = @p28, [ExpirationDate] = @p29, [MinimunStock] = @p30, [Name] = @p31, [Note] = @p32, [ProductImage] = @p33, [ProductTaxId] = @p34, [SalePrice] = @p35, [Status] = @p36, [Stock] = @p37, [UpdatedById] = @p38, [UpdatedDate] = @p39
OUTPUT 1
WHERE [Id] = @p40;
UPDATE [Products] SET [BarCode] = @p41, [BuyPrice] = @p42, [CategoryId] = @p43, [CreatedById] = @p44, [CreatedDate] = @p45, [DeleteFlag] = @p46, [ExpirationDate] = @p47, [MinimunStock] = @p48, [Name] = @p49, [Note] = @p50, [ProductImage] = @p51, [ProductTaxId] = @p52, [SalePrice] = @p53, [Status] = @p54, [Stock] = @p55, [UpdatedById] = @p56, [UpdatedDate] = @p57
OUTPUT 1
WHERE [Id] = @p58;
UPDATE [Products] SET [BarCode] = @p59, [BuyPrice] = @p60, [CategoryId] = @p61, [CreatedById] = @p62, [CreatedDate] = @p63, [DeleteFlag] = @p64, [ExpirationDate] = @p65, [MinimunStock] = @p66, [Name] = @p67, [Note] = @p68, [ProductImage] = @p69, [ProductTaxId] = @p70, [SalePrice] = @p71, [Status] = @p72, [Stock] = @p73, [UpdatedById] = @p74, [UpdatedDate] = @p75
OUTPUT 1
WHERE [Id] = @p76;
UPDATE [Products] SET [BarCode] = @p77, [BuyPrice] = @p78, [CategoryId] = @p79, [CreatedById] = @p80, [CreatedDate] = @p81, [DeleteFlag] = @p82, [ExpirationDate] = @p83, [MinimunStock] = @p84, [Name] = @p85, [Note] = @p86, [ProductImage] = @p87, [ProductTaxId] = @p88, [SalePrice] = @p89, [Status] = @p90, [Stock] = @p91, [UpdatedById] = @p92, [UpdatedDate] = @p93
OUTPUT 1
WHERE [Id] = @p94;
UPDATE [Products] SET [BarCode] = @p95, [BuyPrice] = @p96, [CategoryId] = @p97, [CreatedById] = @p98, [CreatedDate] = @p99, [DeleteFlag] = @p100, [ExpirationDate] = @p101, [MinimunStock] = @p102, [Name] = @p103, [Note] = @p104, [ProductImage] = @p105, [ProductTaxId] = @p106, [SalePrice] = @p107, [Status] = @p108, [Stock] = @p109, [UpdatedById] = @p110, [UpdatedDate] = @p111
OUTPUT 1
WHERE [Id] = @p112;
UPDATE [Products] SET [BarCode] = @p113, [BuyPrice] = @p114, [CategoryId] = @p115, [CreatedById] = @p116, [CreatedDate] = @p117, [DeleteFlag] = @p118, [ExpirationDate] = @p119, [MinimunStock] = @p120, [Name] = @p121, [Note] = @p122, [ProductImage] = @p123, [ProductTaxId] = @p124, [SalePrice] = @p125, [Status] = @p126, [Stock] = @p127, [UpdatedById] = @p128, [UpdatedDate] = @p129
OUTPUT 1
WHERE [Id] = @p130;
UPDATE [Products] SET [BarCode] = @p131, [BuyPrice] = @p132, [CategoryId] = @p133, [CreatedById] = @p134, [CreatedDate] = @p135, [DeleteFlag] = @p136, [ExpirationDate] = @p137, [MinimunStock] = @p138, [Name] = @p139, [Note] = @p140, [ProductImage] = @p141, [ProductTaxId] = @p142, [SalePrice] = @p143, [Status] = @p144, [Stock] = @p145, [UpdatedById] = @p146, [UpdatedDate] = @p147
OUTPUT 1
WHERE [Id] = @p148;
UPDATE [Products] SET [BarCode] = @p149, [BuyPrice] = @p150, [CategoryId] = @p151, [CreatedById] = @p152, [CreatedDate] = @p153, [DeleteFlag] = @p154, [ExpirationDate] = @p155, [MinimunStock] = @p156, [Name] = @p157, [Note] = @p158, [ProductImage] = @p159, [ProductTaxId] = @p160, [SalePrice] = @p161, [Status] = @p162, [Stock] = @p163, [UpdatedById] = @p164, [UpdatedDate] = @p165
OUTPUT 1
WHERE [Id] = @p166;
UPDATE [Products] SET [BarCode] = @p167, [BuyPrice] = @p168, [CategoryId] = @p169, [CreatedById] = @p170, [CreatedDate] = @p171, [DeleteFlag] = @p172, [ExpirationDate] = @p173, [MinimunStock] = @p174, [Name] = @p175, [Note] = @p176, [ProductImage] = @p177, [ProductTaxId] = @p178, [SalePrice] = @p179, [Status] = @p180, [Stock] = @p181, [UpdatedById] = @p182, [UpdatedDate] = @p183
OUTPUT 1
WHERE [Id] = @p184;
UPDATE [Products] SET [BarCode] = @p185, [BuyPrice] = @p186, [CategoryId] = @p187, [CreatedById] = @p188, [CreatedDate] = @p189, [DeleteFlag] = @p190, [ExpirationDate] = @p191, [MinimunStock] = @p192, [Name] = @p193, [Note] = @p194, [ProductImage] = @p195, [ProductTaxId] = @p196, [SalePrice] = @p197, [Status] = @p198, [Stock] = @p199, [UpdatedById] = @p200, [UpdatedDate] = @p201
OUTPUT 1
WHERE [Id] = @p202;
MERGE [SalesDetail] USING (
VALUES (@p203, @p204, @p205, @p206, @p207, @p208, @p209, @p210, @p211, @p212, @p213, @p214, @p215, 0),
(@p216, @p217, @p218, @p219, @p220, @p221, @p222, @p223, @p224, @p225, @p226, @p227, @p228, 1),
(@p229, @p230, @p231, @p232, @p233, @p234, @p235, @p236, @p237, @p238, @p239, @p240, @p241, 2),
(@p242, @p243, @p244, @p245, @p246, @p247, @p248, @p249, @p250, @p251, @p252, @p253, @p254, 3),
(@p255, @p256, @p257, @p258, @p259, @p260, @p261, @p262, @p263, @p264, @p265, @p266, @p267, 4),
(@p268, @p269, @p270, @p271, @p272, @p273, @p274, @p275, @p276, @p277, @p278, @p279, @p280, 5),
(@p281, @p282, @p283, @p284, @p285, @p286, @p287, @p288, @p289, @p290, @p291, @p292, @p293, 6),
(@p294, @p295, @p296, @p297, @p298, @p299, @p300, @p301, @p302, @p303, @p304, @p305, @p306, 7),
(@p307, @p308, @p309, @p310, @p311, @p312, @p313, @p314, @p315, @p316, @p317, @p318, @p319, 8),
(@p320, @p321, @p322, @p323, @p324, @p325, @p326, @p327, @p328, @p329, @p330, @p331, @p332, 9),
(@p333, @p334, @p335, @p336, @p337, @p338, @p339, @p340, @p341, @p342, @p343, @p344, @p345, 10)) 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 (@p346, @p347, @p348, @p349, @p350, @p351, @p352, @p353, @p354, @p355, @p356, @p357, 0),
(@p358, @p359, @p360, @p361, @p362, @p363, @p364, @p365, @p366, @p367, @p368, @p369, 1),
(@p370, @p371, @p372, @p373, @p374, @p375, @p376, @p377, @p378, @p379, @p380, @p381, 2),
(@p382, @p383, @p384, @p385, @p386, @p387, @p388, @p389, @p390, @p391, @p392, @p393, 3),
(@p394, @p395, @p396, @p397, @p398, @p399, @p400, @p401, @p402, @p403, @p404, @p405, 4),
(@p406, @p407, @p408, @p409, @p410, @p411, @p412, @p413, @p414, @p415, @p416, @p417, 5),
(@p418, @p419, @p420, @p421, @p422, @p423, @p424, @p425, @p426, @p427, @p428, @p429, 6),
(@p430, @p431, @p432, @p433, @p434, @p435, @p436, @p437, @p438, @p439, @p440, @p441, 7),
(@p442, @p443, @p444, @p445, @p446, @p447, @p448, @p449, @p450, @p451, @p452, @p453, 8),
(@p454, @p455, @p456, @p457, @p458, @p459, @p460, @p461, @p462, @p463, @p464, @p465, 9),
(@p466, @p467, @p468, @p469, @p470, @p471, @p472, @p473, @p474, @p475, @p476, @p477, 10)) 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-13 21:17:55.547 +00:00 [INF] Setting HTTP status code 201.
2025-11-13 21:17:55.547 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-13 21:17:55.547 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40927 - 201 0 null 330.9649ms
2025-11-13 21:57:51.340 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/sara - null null
2025-11-13 21:57:51.340 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:57:51.340 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/sara - 204 null null 0.319ms
2025-11-13 21:57:51.400 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/sara - null null
2025-11-13 21:57:51.400 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:57:51.400 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 21:57:51.625 +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-13 21:57:51.628 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 21:57:51.628 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 21:57:51.628 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-13 21:57:51.628 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/sara - 200 null application/json; charset=utf-8 227.994ms
2025-11-13 21:58:05.837 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-11-13 21:58:05.837 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:58:05.837 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.2955ms
2025-11-13 21:58:05.900 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2025-11-13 21:58:05.900 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:58:05.900 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-11-13 21:58:05.905 +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-13 21:58:05.908 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2025-11-13 21:58:05.908 +00:00 [INF] Setting HTTP status code 201.
2025-11-13 21:58:05.908 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-11-13 21:58:05.908 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-11-13 21:58:05.908 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 8.5148ms
2025-11-13 21:58:05.968 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40928 - null null
2025-11-13 21:58:05.969 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:58:05.969 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40928 - 204 null null 0.8653ms
2025-11-13 21:58:06.026 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-13 21:58:06.026 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:58:06.026 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2408ms
2025-11-13 21:58:06.029 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40928 - application/json 105
2025-11-13 21:58:06.030 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:58:06.030 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-13 21:58:06.032 +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-13 21:58:06.086 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-13 21:58:06.087 +00:00 [INF] CORS policy execution successful.
2025-11-13 21:58:06.087 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-13 21:58:06.100 +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-13 21:58:06.101 +00:00 [INF] Setting HTTP status code 200.
2025-11-13 21:58:06.101 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-13 21:58:06.101 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-13 21:58:06.101 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 14.7513ms
2025-11-13 21:58:06.159 +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-13 21:58:06.161 +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-13 21:58:06.164 +00:00 [INF] Setting HTTP status code 201.
2025-11-13 21:58:06.164 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-13 21:58:06.164 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40928 - 201 0 null 135.1566ms