2026-01-08 00:45:58.534 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null 2026-01-08 00:45:58.536 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 2.569ms 2026-01-08 00:45:58.536 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404 2026-01-08 04:18:06.590 +00:00 [INF] Request starting HTTP/1.0 GET http:/// - null null 2026-01-08 04:18:06.591 +00:00 [INF] Request finished HTTP/1.0 GET http:/// - 404 0 null 1.2ms 2026-01-08 04:18:06.591 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http:///, Response status code: 404 2026-01-08 07:27:05.432 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null 2026-01-08 07:27:05.433 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 1.014ms 2026-01-08 07:27:05.433 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404 2026-01-08 07:51:28.796 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null 2026-01-08 07:51:28.796 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.3199ms 2026-01-08 07:51:28.796 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404 2026-01-08 07:51:37.940 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null 2026-01-08 07:51:37.941 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.3386ms 2026-01-08 07:51:37.941 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404 2026-01-08 07:51:42.761 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/security.txt - null null 2026-01-08 07:51:42.761 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/security.txt - 404 0 null 0.2961ms 2026-01-08 07:51:42.761 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/security.txt, Response status code: 404 2026-01-08 08:00:09.671 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null 2026-01-08 08:00:09.672 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.4093ms 2026-01-08 08:00:09.672 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404 2026-01-08 08:00:15.480 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/security.txt - null null 2026-01-08 08:00:15.481 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/security.txt - 404 0 null 0.3726ms 2026-01-08 08:00:15.481 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/security.txt, Response status code: 404 2026-01-08 12:49:24.979 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null 2026-01-08 12:49:24.980 +00:00 [INF] CORS policy execution successful. 2026-01-08 12:49:24.980 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 1.1359ms 2026-01-08 12:49:25.039 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 65 2026-01-08 12:49:25.039 +00:00 [INF] CORS policy execution successful. 2026-01-08 12:49:25.040 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin' 2026-01-08 12:49:25.393 +00:00 [INF] Executed DbCommand (12ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName] FROM [AspNetUsers] AS [a] WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0 2026-01-08 12:49:25.550 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (Size = 450)], CommandType='"Text"', CommandTimeout='30'] SELECT [a0].[Name] FROM [AspNetUserRoles] AS [a] INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id] WHERE [a].[UserId] = @__userId_0 2026-01-08 12:49:25.552 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 12:49:25.552 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json. 2026-01-08 12:49:25.552 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin' 2026-01-08 12:49:25.552 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 513.8186ms 2026-01-08 12:49:28.205 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2026-01-08 12:49:28.205 +00:00 [INF] CORS policy execution successful. 2026-01-08 12:49:28.206 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.4152ms 2026-01-08 12:49:28.262 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2026-01-08 12:49:28.262 +00:00 [INF] CORS policy execution successful. 2026-01-08 12:49:28.262 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.4674ms 2026-01-08 12:49:28.262 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2026-01-08 12:49:28.262 +00:00 [INF] CORS policy execution successful. 2026-01-08 12:49:28.262 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.6993ms 2026-01-08 12:49:28.264 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null 2026-01-08 12:49:28.264 +00:00 [INF] CORS policy execution successful. 2026-01-08 12:49:28.264 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.2693ms 2026-01-08 12:49:28.269 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2026-01-08 12:49:28.269 +00:00 [INF] CORS policy execution successful. 2026-01-08 12:49:28.270 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2026-01-08 12:49:28.287 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2026-01-08 12:49:28.287 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 12:49:28.287 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 12:49:28.287 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2026-01-08 12:49:28.287 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 18.5269ms 2026-01-08 12:49:28.328 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2026-01-08 12:49:28.328 +00:00 [INF] CORS policy execution successful. 2026-01-08 12:49:28.328 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2026-01-08 12:49:28.329 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null 2026-01-08 12:49:28.330 +00:00 [INF] CORS policy execution successful. 2026-01-08 12:49:28.330 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities' 2026-01-08 12:49:28.331 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2026-01-08 12:49:28.331 +00:00 [INF] CORS policy execution successful. 2026-01-08 12:49:28.331 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2026-01-08 12:49:28.335 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [ProductTaxes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2026-01-08 12:49:28.335 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 12:49:28.335 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 12:49:28.335 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2026-01-08 12:49:28.336 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 7.7229ms 2026-01-08 12:49:28.347 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [n].[Id], [n].[Descripcion], [n].[Estatus], [n].[Gentilicio], [n].[Siglas] FROM [Nationalities] AS [n] 2026-01-08 12:49:28.347 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate] FROM [Settings] AS [s] 2026-01-08 12:49:28.347 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 12:49:28.348 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 12:49:28.348 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2026-01-08 12:49:28.348 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 12:49:28.348 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2026-01-08 12:49:28.348 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 17.5882ms 2026-01-08 12:49:28.349 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities' 2026-01-08 12:49:28.349 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 19.5221ms 2026-01-08 12:49:35.171 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/kis - null null 2026-01-08 12:49:35.171 +00:00 [INF] CORS policy execution successful. 2026-01-08 12:49:35.172 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/kis - 204 null null 1.3223ms 2026-01-08 12:49:35.235 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/kis - null null 2026-01-08 12:49:35.235 +00:00 [INF] CORS policy execution successful. 2026-01-08 12:49:35.235 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 12:49:35.241 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2026-01-08 12:49:35.241 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 12:49:35.241 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 12:49:35.242 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 12:49:35.242 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/kis - 200 null application/json; charset=utf-8 6.797ms 2026-01-08 12:49:38.701 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/kids - null null 2026-01-08 12:49:38.701 +00:00 [INF] CORS policy execution successful. 2026-01-08 12:49:38.701 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/kids - 204 null null 0.3404ms 2026-01-08 12:49:38.767 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/kids - null null 2026-01-08 12:49:38.767 +00:00 [INF] CORS policy execution successful. 2026-01-08 12:49:38.767 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 12:49:38.771 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2026-01-08 12:49:38.779 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 12:49:38.780 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 12:49:38.892 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 12:49:38.893 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/kids - 200 null application/json; charset=utf-8 126.377ms 2026-01-08 13:55:16.072 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null 2026-01-08 13:55:16.072 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:55:16.073 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.2668ms 2026-01-08 13:55:16.132 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 58 2026-01-08 13:55:16.133 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:55:16.133 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin' 2026-01-08 13:55:16.383 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName] FROM [AspNetUsers] AS [a] WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0 2026-01-08 13:55:16.494 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (Size = 450)], CommandType='"Text"', CommandTimeout='30'] SELECT [a0].[Name] FROM [AspNetUserRoles] AS [a] INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id] WHERE [a].[UserId] = @__userId_0 2026-01-08 13:55:16.495 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 13:55:16.495 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json. 2026-01-08 13:55:16.495 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin' 2026-01-08 13:55:16.495 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 362.6345ms 2026-01-08 13:55:20.112 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - null null 2026-01-08 13:55:20.113 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:55:20.113 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - 204 null null 0.2961ms 2026-01-08 13:55:20.172 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - null null 2026-01-08 13:55:20.173 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:55:20.174 +00:00 [INF] Executing endpoint 'HTTP: GET InventoryReplenishment/' 2026-01-08 13:55:20.191 +00:00 [INF] Executed DbCommand (5ms) [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) AND [p].[CategoryId] IN (1, 3) 2026-01-08 13:55:20.329 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 13:55:20.329 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 13:55:20.330 +00:00 [INF] Executed endpoint 'HTTP: GET InventoryReplenishment/' 2026-01-08 13:55:20.330 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - 200 null application/json; charset=utf-8 157.5426ms 2026-01-08 13:55:53.206 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - null null 2026-01-08 13:55:53.206 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:55:53.206 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - 204 null null 0.3616ms 2026-01-08 13:55:53.267 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - null null 2026-01-08 13:55:53.268 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:55:53.268 +00:00 [INF] Executing endpoint 'HTTP: GET InventoryReplenishment/' 2026-01-08 13:55:53.272 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [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) AND [p].[CategoryId] IN (1, 3) 2026-01-08 13:55:53.441 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 13:55:53.441 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 13:55:53.441 +00:00 [INF] Executed endpoint 'HTTP: GET InventoryReplenishment/' 2026-01-08 13:55:53.442 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - 200 null application/json; charset=utf-8 174.2268ms 2026-01-08 13:56:21.541 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - null null 2026-01-08 13:56:21.541 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:56:21.541 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - 204 null null 0.2948ms 2026-01-08 13:56:21.601 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - application/json 47 2026-01-08 13:56:21.601 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:56:21.601 +00:00 [INF] Executing endpoint 'HTTP: POST InventoryReplenishment/createInvRepHD' 2026-01-08 13:56:21.606 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); 2026-01-08 13:56:21.606 +00:00 [INF] Setting HTTP status code 201. 2026-01-08 13:56:21.606 +00:00 [INF] Writing value of type 'Guid' as Json. 2026-01-08 13:56:21.606 +00:00 [INF] Executed endpoint 'HTTP: POST InventoryReplenishment/createInvRepHD' 2026-01-08 13:56:21.606 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - 201 null application/json; charset=utf-8 5.8868ms 2026-01-08 13:56:21.667 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - null null 2026-01-08 13:56:21.668 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:56:21.668 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - 204 null null 0.8185ms 2026-01-08 13:56:21.728 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - application/json 224 2026-01-08 13:56:21.729 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:56:21.729 +00:00 [INF] Executing endpoint 'HTTP: POST InventoryReplenishment/createInvRepDet' 2026-01-08 13:56:21.733 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [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) 2026-01-08 13:56:21.940 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0 2026-01-08 13:56:21.946 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Int32), @p4='?' (Size = 34), @p5='?' (DbType = Guid), @p6='?' (DbType = Int32), @p7='?' (DbType = Int32), @p8='?' (DbType = Int32), @p9='?' (Size = 4000), @p10='?' (Size = 4000), @p11='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p29='?' (DbType = Int32), @p12='?' (Size = 4000), @p13='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p14='?' (DbType = Int32), @p15='?' (DbType = Guid), @p16='?' (DbType = DateTime2), @p17='?' (DbType = Boolean), @p18='?' (DbType = DateTime2), @p19='?' (DbType = Int32), @p20='?' (Size = 150), @p21='?' (Size = 500), @p22='?' (Size = -1) (DbType = Binary), @p23='?' (DbType = Int32), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (Size = 4000), @p26='?' (DbType = Int32), @p27='?' (DbType = Guid), @p28='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11); UPDATE [Products] SET [BarCode] = @p12, [BuyPrice] = @p13, [CategoryId] = @p14, [CreatedById] = @p15, [CreatedDate] = @p16, [DeleteFlag] = @p17, [ExpirationDate] = @p18, [MinimunStock] = @p19, [Name] = @p20, [Note] = @p21, [ProductImage] = @p22, [ProductTaxId] = @p23, [SalePrice] = @p24, [Status] = @p25, [Stock] = @p26, [UpdatedById] = @p27, [UpdatedDate] = @p28 OUTPUT 1 WHERE [Id] = @p29; 2026-01-08 13:56:21.949 +00:00 [INF] Setting HTTP status code 201. 2026-01-08 13:56:21.949 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 13:56:21.949 +00:00 [INF] Executed endpoint 'HTTP: POST InventoryReplenishment/createInvRepDet' 2026-01-08 13:56:21.949 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - 201 null application/json; charset=utf-8 220.8179ms 2026-01-08 13:56:22.010 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - null null 2026-01-08 13:56:22.010 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:56:22.010 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - 204 null null 0.4488ms 2026-01-08 13:56:22.071 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - null null 2026-01-08 13:56:22.071 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:56:22.071 +00:00 [INF] Executing endpoint 'HTTP: GET InventoryReplenishment/' 2026-01-08 13:56:22.076 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [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) AND [p].[CategoryId] IN (1, 3) 2026-01-08 13:56:22.217 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 13:56:22.218 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 13:56:22.219 +00:00 [INF] Executed endpoint 'HTTP: GET InventoryReplenishment/' 2026-01-08 13:56:22.219 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - 200 null application/json; charset=utf-8 148.6332ms 2026-01-08 13:56:26.295 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2026-01-08 13:56:26.295 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:56:26.296 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.2723ms 2026-01-08 13:56:26.337 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2026-01-08 13:56:26.337 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - null null 2026-01-08 13:56:26.338 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:56:26.338 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:56:26.338 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.8298ms 2026-01-08 13:56:26.338 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - 204 null null 0.7962ms 2026-01-08 13:56:26.355 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2026-01-08 13:56:26.356 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:56:26.356 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2026-01-08 13:56:26.358 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate] FROM [Settings] AS [s] 2026-01-08 13:56:26.359 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 13:56:26.359 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2026-01-08 13:56:26.359 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2026-01-08 13:56:26.359 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 3.8745ms 2026-01-08 13:56:26.390 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2026-01-08 13:56:26.390 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:56:26.391 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Products - null null 2026-01-08 13:56:26.391 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:56:26.391 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2026-01-08 13:56:26.391 +00:00 [INF] Executing endpoint 'HTTP: GET /products' 2026-01-08 13:56:26.395 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [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) 2026-01-08 13:56:26.427 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [ProductTaxes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2026-01-08 13:56:26.427 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 13:56:26.428 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 13:56:26.428 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2026-01-08 13:56:26.429 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 38.8558ms 2026-01-08 13:56:26.554 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 13:56:26.555 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 13:56:27.109 +00:00 [INF] Executed endpoint 'HTTP: GET /products' 2026-01-08 13:56:27.110 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Products - 200 null application/json; charset=utf-8 719.4082ms 2026-01-08 13:56:32.085 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2026-01-08 13:56:32.085 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:56:32.085 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.3494ms 2026-01-08 13:56:32.085 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductCategory - null null 2026-01-08 13:56:32.085 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:56:32.086 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductCategory - 204 null null 0.8771ms 2026-01-08 13:56:32.094 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1527 - null null 2026-01-08 13:56:32.094 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:56:32.094 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1527 - 204 null null 0.2892ms 2026-01-08 13:56:32.137 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2026-01-08 13:56:32.137 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:56:32.137 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2026-01-08 13:56:32.138 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductCategory - null null 2026-01-08 13:56:32.138 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:56:32.138 +00:00 [INF] Executing endpoint 'HTTP: GET ProductCategory/' 2026-01-08 13:56:32.140 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [ProductTaxes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2026-01-08 13:56:32.140 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 13:56:32.140 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 13:56:32.140 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2026-01-08 13:56:32.140 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 3.4577ms 2026-01-08 13:56:32.141 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Description], [p].[UpdatedById], [p].[UpdatedDate] FROM [ProductCategories] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2026-01-08 13:56:32.141 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 13:56:32.142 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 13:56:32.142 +00:00 [INF] Executed endpoint 'HTTP: GET ProductCategory/' 2026-01-08 13:56:32.142 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductCategory - 200 null application/json; charset=utf-8 4.0189ms 2026-01-08 13:56:32.154 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/1527 - null null 2026-01-08 13:56:32.155 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:56:32.155 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}' 2026-01-08 13:56:32.158 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0 2026-01-08 13:56:32.159 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 13:56:32.159 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json. 2026-01-08 13:56:32.159 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}' 2026-01-08 13:56:32.159 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/1527 - 200 null application/json; charset=utf-8 5.1558ms 2026-01-08 13:56:38.527 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1527 - null null 2026-01-08 13:56:38.527 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:56:38.527 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1527 - 204 null null 0.2707ms 2026-01-08 13:56:38.587 +00:00 [INF] Request starting HTTP/1.1 PUT http://159.89.226.33:5227/products/1527 - application/json 23628 2026-01-08 13:56:38.588 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:56:38.588 +00:00 [INF] Executing endpoint 'HTTP: PUT Products/{id}' 2026-01-08 13:56:38.590 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0 2026-01-08 13:56:38.595 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p17='?' (DbType = Int32), @p0='?' (Size = 4000), @p1='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p2='?' (DbType = Int32), @p3='?' (DbType = Guid), @p4='?' (DbType = DateTime2), @p5='?' (DbType = Boolean), @p6='?' (DbType = DateTime2), @p7='?' (DbType = Int32), @p8='?' (Size = 150), @p9='?' (Size = 500), @p10='?' (Size = -1) (DbType = Binary), @p11='?' (DbType = Int32), @p12='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p13='?' (Size = 4000), @p14='?' (DbType = Int32), @p15='?' (DbType = Guid), @p16='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; UPDATE [Products] SET [BarCode] = @p0, [BuyPrice] = @p1, [CategoryId] = @p2, [CreatedById] = @p3, [CreatedDate] = @p4, [DeleteFlag] = @p5, [ExpirationDate] = @p6, [MinimunStock] = @p7, [Name] = @p8, [Note] = @p9, [ProductImage] = @p10, [ProductTaxId] = @p11, [SalePrice] = @p12, [Status] = @p13, [Stock] = @p14, [UpdatedById] = @p15, [UpdatedDate] = @p16 OUTPUT 1 WHERE [Id] = @p17; 2026-01-08 13:56:38.595 +00:00 [INF] Setting HTTP status code 204. 2026-01-08 13:56:38.596 +00:00 [INF] Executed endpoint 'HTTP: PUT Products/{id}' 2026-01-08 13:56:38.596 +00:00 [INF] Request finished HTTP/1.1 PUT http://159.89.226.33:5227/products/1527 - 204 null null 8.4248ms 2026-01-08 13:56:40.656 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2026-01-08 13:56:40.656 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:56:40.656 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.3838ms 2026-01-08 13:56:40.656 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - null null 2026-01-08 13:56:40.657 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:56:40.657 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - 204 null null 1.5141ms 2026-01-08 13:56:40.664 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2026-01-08 13:56:40.664 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:56:40.664 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.2309ms 2026-01-08 13:56:40.709 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Products - null null 2026-01-08 13:56:40.709 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2026-01-08 13:56:40.709 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:56:40.709 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:56:40.710 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2026-01-08 13:56:40.710 +00:00 [INF] Executing endpoint 'HTTP: GET /products' 2026-01-08 13:56:40.712 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [ProductTaxes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2026-01-08 13:56:40.712 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 13:56:40.712 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 13:56:40.712 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2026-01-08 13:56:40.712 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 3.3755ms 2026-01-08 13:56:40.714 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [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) 2026-01-08 13:56:40.725 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2026-01-08 13:56:40.725 +00:00 [INF] CORS policy execution successful. 2026-01-08 13:56:40.725 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2026-01-08 13:56:40.728 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate] FROM [Settings] AS [s] 2026-01-08 13:56:40.728 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 13:56:40.728 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2026-01-08 13:56:40.728 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2026-01-08 13:56:40.728 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 3.8623ms 2026-01-08 13:56:40.855 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 13:56:40.855 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 13:56:41.444 +00:00 [INF] Executed endpoint 'HTTP: GET /products' 2026-01-08 13:56:41.445 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Products - 200 null application/json; charset=utf-8 735.9614ms 2026-01-08 15:09:46.452 +00:00 [INF] Request starting HTTP/1.0 GET http:/// - null null 2026-01-08 15:09:46.452 +00:00 [INF] Request finished HTTP/1.0 GET http:/// - 404 0 null 0.2884ms 2026-01-08 15:09:46.452 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http:///, Response status code: 404 2026-01-08 15:39:01.174 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/mix - null null 2026-01-08 15:39:01.175 +00:00 [INF] CORS policy execution successful. 2026-01-08 15:39:01.176 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/mix - 204 null null 1.3122ms 2026-01-08 15:39:01.236 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/mix - null null 2026-01-08 15:39:01.236 +00:00 [INF] CORS policy execution successful. 2026-01-08 15:39:01.236 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 15:39:01.618 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2026-01-08 15:39:01.650 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 15:39:01.650 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 15:39:01.815 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 15:39:01.815 +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 579.5438ms 2026-01-08 15:39:12.277 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/L- - null null 2026-01-08 15:39:12.278 +00:00 [INF] CORS policy execution successful. 2026-01-08 15:39:12.278 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/L- - 204 null null 0.3977ms 2026-01-08 15:39:12.333 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/L- - null null 2026-01-08 15:39:12.334 +00:00 [INF] CORS policy execution successful. 2026-01-08 15:39:12.334 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 15:39:12.338 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2026-01-08 15:39:12.351 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 15:39:12.351 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 15:39:12.352 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 15:39:12.352 +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 18.8395ms 2026-01-08 15:40:48.023 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null 2026-01-08 15:40:48.023 +00:00 [INF] CORS policy execution successful. 2026-01-08 15:40:48.023 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3312ms 2026-01-08 15:40:48.083 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 228 2026-01-08 15:40:48.083 +00:00 [INF] CORS policy execution successful. 2026-01-08 15:40:48.083 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd' 2026-01-08 15:40:48.090 +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); 2026-01-08 15:40:48.109 +00:00 [INF] Executed DbCommand (18ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2), @p8='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p9='?' (DbType = Guid), @p10='?' (DbType = DateTime2), @p11='?' (DbType = Boolean), @p12='?' (DbType = Int32), @p13='?' (DbType = Int64), @p14='?' (DbType = Guid), @p15='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; MERGE [SalesPaymentTypesDetails] USING ( VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, 0), (@p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, 1)) AS i ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate], _Position) ON 1=0 WHEN NOT MATCHED THEN INSERT ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate]) VALUES (i.[Amount], i.[CreatedById], i.[CreatedDate], i.[DeleteFlag], i.[PaymentTypeId], i.[SalesId], i.[UpdatedById], i.[UpdatedDate]) OUTPUT INSERTED.[Id], i._Position; 2026-01-08 15:40:48.110 +00:00 [INF] Setting HTTP status code 201. 2026-01-08 15:40:48.110 +00:00 [INF] Writing value of type 'Int64' as Json. 2026-01-08 15:40:48.110 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd' 2026-01-08 15:40:48.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 27.0232ms 2026-01-08 15:40:48.173 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41231 - null null 2026-01-08 15:40:48.173 +00:00 [INF] CORS policy execution successful. 2026-01-08 15:40:48.173 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41231 - 204 null null 0.4681ms 2026-01-08 15:40:48.229 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2026-01-08 15:40:48.229 +00:00 [INF] CORS policy execution successful. 2026-01-08 15:40:48.229 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.4277ms 2026-01-08 15:40:48.232 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41231 - application/json 211 2026-01-08 15:40:48.232 +00:00 [INF] CORS policy execution successful. 2026-01-08 15:40:48.232 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}' 2026-01-08 15:40:48.235 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2026-01-08 15:40:48.284 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2026-01-08 15:40:48.285 +00:00 [INF] CORS policy execution successful. 2026-01-08 15:40:48.286 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2026-01-08 15:40:48.323 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2026-01-08 15:40:48.323 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 15:40:48.323 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 15:40:48.324 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2026-01-08 15:40:48.324 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 39.4884ms 2026-01-08 15:40:48.454 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'. 2026-01-08 15:40:48.460 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p40='?' (DbType = Int32), @p23='?' (Size = 4000), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Int32), @p26='?' (DbType = Guid), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Boolean), @p29='?' (DbType = DateTime2), @p30='?' (DbType = Int32), @p31='?' (Size = 150), @p32='?' (Size = 500), @p33='?' (Size = -1) (DbType = Binary), @p34='?' (DbType = Int32), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p36='?' (Size = 4000), @p37='?' (DbType = Int32), @p38='?' (DbType = Guid), @p39='?' (DbType = DateTime2), @p41='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p42='?' (DbType = Guid), @p43='?' (DbType = DateTime2), @p44='?' (DbType = Boolean), @p45='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p46='?' (DbType = Int32), @p47='?' (DbType = Int32), @p48='?' (DbType = Int64), @p49='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p50='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p51='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p52='?' (DbType = Guid), @p53='?' (DbType = DateTime2), @p54='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p55='?' (DbType = Guid), @p56='?' (DbType = DateTime2), @p57='?' (DbType = Boolean), @p58='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p59='?' (DbType = Int32), @p60='?' (DbType = Int32), @p61='?' (DbType = Int64), @p62='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p63='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p64='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p65='?' (DbType = Guid), @p66='?' (DbType = DateTime2), @p67='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p68='?' (DbType = Guid), @p69='?' (DbType = DateTime2), @p70='?' (DbType = Int32), @p71='?' (Size = 34), @p72='?' (DbType = Guid), @p73='?' (DbType = Int32), @p74='?' (DbType = Int32), @p75='?' (DbType = Int32), @p76='?' (Size = 4000), @p77='?' (Size = 4000), @p78='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p79='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p80='?' (DbType = Guid), @p81='?' (DbType = DateTime2), @p82='?' (DbType = Int32), @p83='?' (Size = 34), @p84='?' (DbType = Guid), @p85='?' (DbType = Int32), @p86='?' (DbType = Int32), @p87='?' (DbType = Int32), @p88='?' (Size = 4000), @p89='?' (Size = 4000), @p90='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21 OUTPUT 1 WHERE [Id] = @p22; UPDATE [Products] SET [BarCode] = @p23, [BuyPrice] = @p24, [CategoryId] = @p25, [CreatedById] = @p26, [CreatedDate] = @p27, [DeleteFlag] = @p28, [ExpirationDate] = @p29, [MinimunStock] = @p30, [Name] = @p31, [Note] = @p32, [ProductImage] = @p33, [ProductTaxId] = @p34, [SalePrice] = @p35, [Status] = @p36, [Stock] = @p37, [UpdatedById] = @p38, [UpdatedDate] = @p39 OUTPUT 1 WHERE [Id] = @p40; MERGE [SalesDetail] USING ( VALUES (@p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52, @p53, 0), (@p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62, @p63, @p64, @p65, @p66, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate], _Position) ON 1=0 WHEN NOT MATCHED THEN INSERT ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate]) VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[DeleteFlag], i.[DiscountAmount], i.[ProductId], i.[Quantity], i.[SalesId], i.[Tax], i.[Total], i.[UnitPrice], i.[UpdatedById], i.[UpdatedDate]) OUTPUT INSERTED.[Id], i._Position; MERGE [InventoryMovements] USING ( VALUES (@p67, @p68, @p69, @p70, @p71, @p72, @p73, @p74, @p75, @p76, @p77, @p78, 0), (@p79, @p80, @p81, @p82, @p83, @p84, @p85, @p86, @p87, @p88, @p89, @p90, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice], _Position) ON 1=0 WHEN NOT MATCHED THEN INSERT ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice]) VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[Difference], i.[Discriminator], i.[InventoryMovementHeaderId], i.[NewStock], i.[OriginaStock], i.[ProductId], i.[ProductName], i.[Reazon], i.[SalePrice]) OUTPUT INSERTED.[Id], i._Position; 2026-01-08 15:40:48.464 +00:00 [INF] Setting HTTP status code 201. 2026-01-08 15:40:48.464 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}' 2026-01-08 15:40:48.465 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41231 - 201 0 null 232.5564ms 2026-01-08 18:59:37.790 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ozono - null null 2026-01-08 18:59:37.790 +00:00 [INF] CORS policy execution successful. 2026-01-08 18:59:37.790 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ozono - 204 null null 0.3264ms 2026-01-08 18:59:37.851 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ozono - null null 2026-01-08 18:59:37.851 +00:00 [INF] CORS policy execution successful. 2026-01-08 18:59:37.852 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 18:59:38.136 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2026-01-08 18:59:38.148 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 18:59:38.149 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 18:59:38.150 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 18:59:38.150 +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 299.051ms 2026-01-08 18:59:45.750 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/vita - null null 2026-01-08 18:59:45.750 +00:00 [INF] CORS policy execution successful. 2026-01-08 18:59:45.750 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/vita - 204 null null 0.2936ms 2026-01-08 18:59:45.809 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/vita - null null 2026-01-08 18:59:45.810 +00:00 [INF] CORS policy execution successful. 2026-01-08 18:59:45.810 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 18:59:45.812 +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'\')) 2026-01-08 18:59:45.824 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 18:59:45.824 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 18:59:46.108 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 18:59:46.108 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/vita - 200 null application/json; charset=utf-8 298.5898ms 2026-01-08 18:59:48.389 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - null null 2026-01-08 18:59:48.389 +00:00 [INF] CORS policy execution successful. 2026-01-08 18:59:48.390 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - 204 null null 0.9948ms 2026-01-08 18:59:48.449 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - null null 2026-01-08 18:59:48.449 +00:00 [INF] CORS policy execution successful. 2026-01-08 18:59:48.449 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}' 2026-01-08 18:59:48.449 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}' 2026-01-08 18:59:48.449 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - 400 0 null 0.6487ms 2026-01-08 18:59:50.618 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/suero - null null 2026-01-08 18:59:50.618 +00:00 [INF] CORS policy execution successful. 2026-01-08 18:59:50.619 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/suero - 204 null null 0.2902ms 2026-01-08 18:59:50.678 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/suero - null null 2026-01-08 18:59:50.678 +00:00 [INF] CORS policy execution successful. 2026-01-08 18:59:50.679 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 18:59:50.682 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2026-01-08 18:59:50.693 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 18:59:50.694 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 18:59:50.695 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 18:59:50.695 +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 16.9653ms 2026-01-08 19:00:11.087 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null 2026-01-08 19:00:11.087 +00:00 [INF] CORS policy execution successful. 2026-01-08 19:00:11.088 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3622ms 2026-01-08 19:00:11.149 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182 2026-01-08 19:00:11.149 +00:00 [INF] CORS policy execution successful. 2026-01-08 19:00:11.149 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd' 2026-01-08 19:00:11.159 +00:00 [INF] Executed DbCommand (8ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9); 2026-01-08 19:00:11.165 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7); 2026-01-08 19:00:11.166 +00:00 [INF] Setting HTTP status code 201. 2026-01-08 19:00:11.166 +00:00 [INF] Writing value of type 'Int64' as Json. 2026-01-08 19:00:11.166 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd' 2026-01-08 19:00:11.167 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 18.049ms 2026-01-08 19:00:11.226 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41232 - null null 2026-01-08 19:00:11.226 +00:00 [INF] CORS policy execution successful. 2026-01-08 19:00:11.226 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41232 - 204 null null 0.391ms 2026-01-08 19:00:11.293 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41232 - application/json 211 2026-01-08 19:00:11.294 +00:00 [INF] CORS policy execution successful. 2026-01-08 19:00:11.294 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2026-01-08 19:00:11.294 +00:00 [INF] CORS policy execution successful. 2026-01-08 19:00:11.294 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.241ms 2026-01-08 19:00:11.294 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}' 2026-01-08 19:00:11.297 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2026-01-08 19:00:11.354 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2026-01-08 19:00:11.354 +00:00 [INF] CORS policy execution successful. 2026-01-08 19:00:11.355 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2026-01-08 19:00:11.385 +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) 2026-01-08 19:00:11.385 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 19:00:11.385 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 19:00:11.385 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2026-01-08 19:00:11.386 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 32.0218ms 2026-01-08 19:00:11.531 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'. 2026-01-08 19:00:11.537 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p40='?' (DbType = Int32), @p23='?' (Size = 4000), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Int32), @p26='?' (DbType = Guid), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Boolean), @p29='?' (DbType = DateTime2), @p30='?' (DbType = Int32), @p31='?' (Size = 150), @p32='?' (Size = 500), @p33='?' (Size = -1) (DbType = Binary), @p34='?' (DbType = Int32), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p36='?' (Size = 4000), @p37='?' (DbType = Int32), @p38='?' (DbType = Guid), @p39='?' (DbType = DateTime2), @p41='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p42='?' (DbType = Guid), @p43='?' (DbType = DateTime2), @p44='?' (DbType = Boolean), @p45='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p46='?' (DbType = Int32), @p47='?' (DbType = Int32), @p48='?' (DbType = Int64), @p49='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p50='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p51='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p52='?' (DbType = Guid), @p53='?' (DbType = DateTime2), @p54='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p55='?' (DbType = Guid), @p56='?' (DbType = DateTime2), @p57='?' (DbType = Boolean), @p58='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p59='?' (DbType = Int32), @p60='?' (DbType = Int32), @p61='?' (DbType = Int64), @p62='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p63='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p64='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p65='?' (DbType = Guid), @p66='?' (DbType = DateTime2), @p67='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p68='?' (DbType = Guid), @p69='?' (DbType = DateTime2), @p70='?' (DbType = Int32), @p71='?' (Size = 34), @p72='?' (DbType = Guid), @p73='?' (DbType = Int32), @p74='?' (DbType = Int32), @p75='?' (DbType = Int32), @p76='?' (Size = 4000), @p77='?' (Size = 4000), @p78='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p79='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p80='?' (DbType = Guid), @p81='?' (DbType = DateTime2), @p82='?' (DbType = Int32), @p83='?' (Size = 34), @p84='?' (DbType = Guid), @p85='?' (DbType = Int32), @p86='?' (DbType = Int32), @p87='?' (DbType = Int32), @p88='?' (Size = 4000), @p89='?' (Size = 4000), @p90='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21 OUTPUT 1 WHERE [Id] = @p22; UPDATE [Products] SET [BarCode] = @p23, [BuyPrice] = @p24, [CategoryId] = @p25, [CreatedById] = @p26, [CreatedDate] = @p27, [DeleteFlag] = @p28, [ExpirationDate] = @p29, [MinimunStock] = @p30, [Name] = @p31, [Note] = @p32, [ProductImage] = @p33, [ProductTaxId] = @p34, [SalePrice] = @p35, [Status] = @p36, [Stock] = @p37, [UpdatedById] = @p38, [UpdatedDate] = @p39 OUTPUT 1 WHERE [Id] = @p40; MERGE [SalesDetail] USING ( VALUES (@p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52, @p53, 0), (@p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62, @p63, @p64, @p65, @p66, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate], _Position) ON 1=0 WHEN NOT MATCHED THEN INSERT ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate]) VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[DeleteFlag], i.[DiscountAmount], i.[ProductId], i.[Quantity], i.[SalesId], i.[Tax], i.[Total], i.[UnitPrice], i.[UpdatedById], i.[UpdatedDate]) OUTPUT INSERTED.[Id], i._Position; MERGE [InventoryMovements] USING ( VALUES (@p67, @p68, @p69, @p70, @p71, @p72, @p73, @p74, @p75, @p76, @p77, @p78, 0), (@p79, @p80, @p81, @p82, @p83, @p84, @p85, @p86, @p87, @p88, @p89, @p90, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice], _Position) ON 1=0 WHEN NOT MATCHED THEN INSERT ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice]) VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[Difference], i.[Discriminator], i.[InventoryMovementHeaderId], i.[NewStock], i.[OriginaStock], i.[ProductId], i.[ProductName], i.[Reazon], i.[SalePrice]) OUTPUT INSERTED.[Id], i._Position; 2026-01-08 19:00:11.543 +00:00 [INF] Setting HTTP status code 201. 2026-01-08 19:00:11.543 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}' 2026-01-08 19:00:11.543 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41232 - 201 0 null 250.188ms 2026-01-08 19:53:57.902 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/oxidartiva - null null 2026-01-08 19:53:57.902 +00:00 [INF] CORS policy execution successful. 2026-01-08 19:53:57.902 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/oxidartiva - 204 null null 0.3358ms 2026-01-08 19:53:57.961 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/oxidartiva - null null 2026-01-08 19:53:57.962 +00:00 [INF] CORS policy execution successful. 2026-01-08 19:53:57.962 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 19:53:58.230 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2026-01-08 19:53:58.231 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 19:53:58.231 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 19:53:58.231 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 19:53:58.231 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/oxidartiva - 200 null application/json; charset=utf-8 269.8607ms 2026-01-08 19:54:03.111 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/oxidatu - null null 2026-01-08 19:54:03.111 +00:00 [INF] CORS policy execution successful. 2026-01-08 19:54:03.111 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/oxidatu - 204 null null 0.3779ms 2026-01-08 19:54:03.168 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/oxidatu - null null 2026-01-08 19:54:03.169 +00:00 [INF] CORS policy execution successful. 2026-01-08 19:54:03.169 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 19:54:03.175 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2026-01-08 19:54:03.175 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 19:54:03.175 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 19:54:03.175 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 19:54:03.175 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/oxidatu - 200 null application/json; charset=utf-8 7.0227ms 2026-01-08 19:54:09.039 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/oxidativa - null null 2026-01-08 19:54:09.039 +00:00 [INF] CORS policy execution successful. 2026-01-08 19:54:09.040 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/oxidativa - 204 null null 0.3723ms 2026-01-08 19:54:09.099 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/oxidativa - null null 2026-01-08 19:54:09.100 +00:00 [INF] CORS policy execution successful. 2026-01-08 19:54:09.100 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 19:54:09.106 +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'\')) 2026-01-08 19:54:09.109 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 19:54:09.109 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 19:54:09.109 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 19:54:09.109 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/oxidativa - 200 null application/json; charset=utf-8 9.4838ms 2026-01-08 19:54:15.861 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - null null 2026-01-08 19:54:15.861 +00:00 [INF] CORS policy execution successful. 2026-01-08 19:54:15.861 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - 204 null null 0.319ms 2026-01-08 19:54:15.927 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma - null null 2026-01-08 19:54:15.928 +00:00 [INF] CORS policy execution successful. 2026-01-08 19:54:15.928 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 19:54:15.930 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2026-01-08 19:54:15.943 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 19:54:15.943 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 19:54:16.111 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 19:54:16.112 +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 184.1443ms 2026-01-08 19:54:21.437 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1415 - null null 2026-01-08 19:54:21.437 +00:00 [INF] CORS policy execution successful. 2026-01-08 19:54:21.437 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1415 - 204 null null 0.3894ms 2026-01-08 19:54:21.497 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/1415 - null null 2026-01-08 19:54:21.497 +00:00 [INF] CORS policy execution successful. 2026-01-08 19:54:21.497 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}' 2026-01-08 19:54:21.500 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0 2026-01-08 19:54:21.501 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 19:54:21.501 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json. 2026-01-08 19:54:21.501 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}' 2026-01-08 19:54:21.501 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/1415 - 200 null application/json; charset=utf-8 4.8948ms 2026-01-08 20:03:38.078 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1415 - null null 2026-01-08 20:03:38.078 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:03:38.078 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1415 - 204 null null 0.4298ms 2026-01-08 20:03:38.135 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/1415 - null null 2026-01-08 20:03:38.136 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:03:38.136 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}' 2026-01-08 20:03:38.477 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0 2026-01-08 20:03:38.481 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 20:03:38.481 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json. 2026-01-08 20:03:38.482 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}' 2026-01-08 20:03:38.482 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/1415 - 200 null application/json; charset=utf-8 346.2006ms 2026-01-08 20:11:48.372 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1415 - null null 2026-01-08 20:11:48.372 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:11:48.372 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1415 - 204 null null 0.3998ms 2026-01-08 20:11:48.434 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/1415 - null null 2026-01-08 20:11:48.434 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:11:48.434 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}' 2026-01-08 20:11:48.666 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0 2026-01-08 20:11:48.667 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 20:11:48.667 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json. 2026-01-08 20:11:48.667 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}' 2026-01-08 20:11:48.667 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/1415 - 200 null application/json; charset=utf-8 233.2982ms 2026-01-08 20:12:06.512 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2026-01-08 20:12:06.512 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:12:06.513 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3269ms 2026-01-08 20:12:06.572 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null 2026-01-08 20:12:06.572 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:12:06.572 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.3524ms 2026-01-08 20:12:06.572 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2026-01-08 20:12:06.572 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:12:06.572 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.1649ms 2026-01-08 20:12:06.573 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2026-01-08 20:12:06.573 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:12:06.574 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.4823ms 2026-01-08 20:12:06.577 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2026-01-08 20:12:06.577 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:12:06.577 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2026-01-08 20:12:06.579 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2026-01-08 20:12:06.580 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 20:12:06.580 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 20:12:06.580 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2026-01-08 20:12:06.580 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 3.0177ms 2026-01-08 20:12:06.631 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2026-01-08 20:12:06.631 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:12:06.632 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2026-01-08 20:12:06.632 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null 2026-01-08 20:12:06.633 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:12:06.633 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities' 2026-01-08 20:12:06.634 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2026-01-08 20:12:06.634 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:12:06.634 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2026-01-08 20:12:06.634 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [ProductTaxes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2026-01-08 20:12:06.635 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 20:12:06.635 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 20:12:06.635 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2026-01-08 20:12:06.635 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 4.2381ms 2026-01-08 20:12:06.637 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [n].[Id], [n].[Descripcion], [n].[Estatus], [n].[Gentilicio], [n].[Siglas] FROM [Nationalities] AS [n] 2026-01-08 20:12:06.638 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 20:12:06.638 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 20:12:06.638 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities' 2026-01-08 20:12:06.639 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 6.3279ms 2026-01-08 20:12:06.649 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate] FROM [Settings] AS [s] 2026-01-08 20:12:06.649 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 20:12:06.649 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2026-01-08 20:12:06.650 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2026-01-08 20:12:06.650 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 16.2362ms 2026-01-08 20:12:10.266 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - null null 2026-01-08 20:12:10.267 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:12:10.267 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - 204 null null 0.2649ms 2026-01-08 20:12:10.326 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma - null null 2026-01-08 20:12:10.326 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:12:10.326 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 20:12:10.330 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2026-01-08 20:12:10.338 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 20:12:10.338 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 20:12:10.507 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 20:12:10.507 +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 181.4974ms 2026-01-08 20:12:14.336 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1415 - null null 2026-01-08 20:12:14.336 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:12:14.336 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1415 - 204 null null 0.3865ms 2026-01-08 20:12:14.394 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/1415 - null null 2026-01-08 20:12:14.394 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:12:14.394 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}' 2026-01-08 20:12:14.396 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0 2026-01-08 20:12:14.397 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 20:12:14.398 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json. 2026-01-08 20:12:14.398 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}' 2026-01-08 20:12:14.398 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/1415 - 200 null application/json; charset=utf-8 3.9241ms 2026-01-08 20:12:19.285 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/terapya - null null 2026-01-08 20:12:19.285 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:12:19.285 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/terapya - 204 null null 0.2624ms 2026-01-08 20:12:19.344 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/terapya - null null 2026-01-08 20:12:19.345 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:12:19.345 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 20:12:19.349 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2026-01-08 20:12:19.350 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 20:12:19.350 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 20:12:19.350 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 20:12:19.350 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/terapya - 200 null application/json; charset=utf-8 5.3742ms 2026-01-08 20:12:23.007 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/terapia - null null 2026-01-08 20:12:23.007 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:12:23.007 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/terapia - 204 null null 0.2968ms 2026-01-08 20:12:23.067 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/terapia - null null 2026-01-08 20:12:23.067 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:12:23.067 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 20:12:23.070 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2026-01-08 20:12:23.075 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 20:12:23.076 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 20:12:23.076 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 20:12:23.076 +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 9.4987ms 2026-01-08 20:12:39.301 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null 2026-01-08 20:12:39.302 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:12:39.302 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3307ms 2026-01-08 20:12:39.361 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182 2026-01-08 20:12:39.361 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:12:39.361 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd' 2026-01-08 20:12:39.366 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9); 2026-01-08 20:12:39.369 +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); 2026-01-08 20:12:39.369 +00:00 [INF] Setting HTTP status code 201. 2026-01-08 20:12:39.369 +00:00 [INF] Writing value of type 'Int64' as Json. 2026-01-08 20:12:39.369 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd' 2026-01-08 20:12:39.369 +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.5817ms 2026-01-08 20:12:39.431 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41233 - null null 2026-01-08 20:12:39.431 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:12:39.431 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41233 - 204 null null 0.3352ms 2026-01-08 20:12:39.435 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2026-01-08 20:12:39.435 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:12:39.435 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2559ms 2026-01-08 20:12:39.488 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41233 - application/json 211 2026-01-08 20:12:39.488 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:12:39.488 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}' 2026-01-08 20:12:39.490 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2026-01-08 20:12:39.491 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2026-01-08 20:12:39.491 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:12:39.492 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2026-01-08 20:12:39.493 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2026-01-08 20:12:39.493 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 20:12:39.493 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 20:12:39.493 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2026-01-08 20:12:39.493 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 2.051ms 2026-01-08 20:12:39.632 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'. 2026-01-08 20:12:39.636 +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; 2026-01-08 20:12:39.640 +00:00 [INF] Setting HTTP status code 201. 2026-01-08 20:12:39.640 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}' 2026-01-08 20:12:39.640 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41233 - 201 0 null 152.4039ms 2026-01-08 20:29:56.200 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/silver - null null 2026-01-08 20:29:56.201 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:29:56.201 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/silver - 204 null null 1.0251ms 2026-01-08 20:29:56.264 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/silver - null null 2026-01-08 20:29:56.264 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:29:56.265 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 20:29:56.572 +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'\')) 2026-01-08 20:29:56.579 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 20:29:56.580 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 20:29:56.580 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2026-01-08 20:29:56.580 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/silver - 200 null application/json; charset=utf-8 316.2128ms 2026-01-08 20:30:15.317 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null 2026-01-08 20:30:15.317 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:30:15.317 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.4273ms 2026-01-08 20:30:15.374 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182 2026-01-08 20:30:15.374 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:30:15.374 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd' 2026-01-08 20:30:15.380 +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); 2026-01-08 20:30:15.384 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7); 2026-01-08 20:30:15.385 +00:00 [INF] Setting HTTP status code 201. 2026-01-08 20:30:15.385 +00:00 [INF] Writing value of type 'Int64' as Json. 2026-01-08 20:30:15.385 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd' 2026-01-08 20:30:15.385 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 11.4241ms 2026-01-08 20:30:15.452 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41234 - null null 2026-01-08 20:30:15.452 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:30:15.453 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41234 - 204 null null 0.4298ms 2026-01-08 20:30:15.514 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2026-01-08 20:30:15.515 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:30:15.515 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.4299ms 2026-01-08 20:30:15.514 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41234 - application/json 104 2026-01-08 20:30:15.515 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:30:15.515 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}' 2026-01-08 20:30:15.518 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2026-01-08 20:30:15.575 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2026-01-08 20:30:15.575 +00:00 [INF] CORS policy execution successful. 2026-01-08 20:30:15.575 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2026-01-08 20:30:15.590 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2026-01-08 20:30:15.591 +00:00 [INF] Setting HTTP status code 200. 2026-01-08 20:30:15.592 +00:00 [INF] Writing value of type 'List`1' as Json. 2026-01-08 20:30:15.592 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2026-01-08 20:30:15.592 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 17.4988ms 2026-01-08 20:30:15.684 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'. 2026-01-08 20:30:15.686 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21 OUTPUT 1 WHERE [Id] = @p22; INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35); INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice]) OUTPUT INSERTED.[Id] VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47); 2026-01-08 20:30:15.690 +00:00 [INF] Setting HTTP status code 201. 2026-01-08 20:30:15.690 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}' 2026-01-08 20:30:15.690 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41234 - 201 0 null 175.8095ms