2025-11-11 00:01:47.981 +00:00 [INF] Request starting HTTP/1.1 GET http://localhost:5227/.env - null null 2025-11-11 00:01:47.984 +00:00 [INF] Request finished HTTP/1.1 GET http://localhost:5227/.env - 404 0 null 3.0323ms 2025-11-11 00:01:47.984 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://localhost:5227/.env, Response status code: 404 2025-11-11 12:27:28.095 +00:00 [INF] Request starting HTTP/1.1 GET http://localhost:5227/.env - null null 2025-11-11 12:27:28.098 +00:00 [INF] Request finished HTTP/1.1 GET http://localhost:5227/.env - 404 0 null 2.986ms 2025-11-11 12:27:28.099 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://localhost:5227/.env, Response status code: 404 2025-11-11 15:05:07.846 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null 2025-11-11 15:05:07.847 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 1.273ms 2025-11-11 15:05:07.847 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404 2025-11-11 15:05:22.729 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null 2025-11-11 15:05:22.730 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.3134ms 2025-11-11 15:05:22.730 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404 2025-11-11 15:05:37.480 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/wiki - null null 2025-11-11 15:05:37.480 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/wiki - 404 0 null 0.2996ms 2025-11-11 15:05:37.480 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/wiki, Response status code: 404 2025-11-11 15:22:01.741 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null 2025-11-11 15:22:01.743 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:22:01.743 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 1.7878ms 2025-11-11 15:22:01.800 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 58 2025-11-11 15:22:01.800 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:22:01.800 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin' 2025-11-11 15:22:02.377 +00:00 [INF] Executed DbCommand (20ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName] FROM [AspNetUsers] AS [a] WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0 2025-11-11 15:22:02.598 +00:00 [INF] Executed DbCommand (9ms) [Parameters=[@__userId_0='?' (Size = 450)], CommandType='"Text"', CommandTimeout='30'] SELECT [a0].[Name] FROM [AspNetUserRoles] AS [a] INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id] WHERE [a].[UserId] = @__userId_0 2025-11-11 15:22:02.606 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:22:02.607 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json. 2025-11-11 15:22:02.607 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin' 2025-11-11 15:22:02.607 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 807.2229ms 2025-11-11 15:22:08.340 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-11-11 15:22:08.340 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:22:08.340 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.3246ms 2025-11-11 15:22:08.395 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-11-11 15:22:08.395 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:22:08.397 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-11-11 15:22:08.421 +00:00 [INF] Executed DbCommand (8ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate] FROM [Settings] AS [s] 2025-11-11 15:22:08.421 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:22:08.421 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-11-11 15:22:08.422 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-11-11 15:22:08.422 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 26.9939ms 2025-11-11 15:22:50.033 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-11 15:22:50.034 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:22:50.034 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 1.2034ms 2025-11-11 15:22:50.088 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-11-11 15:22:50.088 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-11-11 15:22:50.089 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:22:50.089 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:22:50.089 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 1.3297ms 2025-11-11 15:22:50.089 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 1.3563ms 2025-11-11 15:22:50.090 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null 2025-11-11 15:22:50.090 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:22:50.090 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.3699ms 2025-11-11 15:22:50.109 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-11 15:22:50.110 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:22:50.110 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-11 15:22:50.115 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 15:22:50.115 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:22:50.115 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 15:22:50.115 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-11 15:22:50.115 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 5.9573ms 2025-11-11 15:22:50.145 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null 2025-11-11 15:22:50.145 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:22:50.146 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities' 2025-11-11 15:22:50.146 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-11-11 15:22:50.146 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:22:50.146 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-11-11 15:22:50.147 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:22:50.147 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-11-11 15:22:50.147 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-11-11 15:22:50.151 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [n].[Id], [n].[Descripcion], [n].[Estatus], [n].[Gentilicio], [n].[Siglas] FROM [Nationalities] AS [n] 2025-11-11 15:22:50.152 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:22:50.152 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 15:22:50.152 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities' 2025-11-11 15:22:50.152 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 7.1598ms 2025-11-11 15:22:50.167 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate] FROM [Settings] AS [s] 2025-11-11 15:22:50.168 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:22:50.168 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-11-11 15:22:50.168 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-11-11 15:22:50.168 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 21.7816ms 2025-11-11 15:22:50.169 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [ProductTaxes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 15:22:50.169 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:22:50.169 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 15:22:50.169 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-11-11 15:22:50.169 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 24.4235ms 2025-11-11 15:23:15.670 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/5 - null null 2025-11-11 15:23:15.670 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:23:15.670 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/5 - 204 null null 0.331ms 2025-11-11 15:23:15.726 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/5 - null null 2025-11-11 15:23:15.727 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:23:15.727 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 15:23:15.756 +00:00 [INF] Executed DbCommand (27ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-11 15:23:15.806 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:23:15.806 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 15:23:16.030 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 15:23:16.030 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/5 - 200 null application/json; charset=utf-8 303.8919ms 2025-11-11 15:23:50.480 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-11-11 15:23:50.480 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:23:50.480 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.3211ms 2025-11-11 15:23:50.480 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-11-11 15:23:50.480 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:23:50.481 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.1248ms 2025-11-11 15:23:50.480 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - null null 2025-11-11 15:23:50.481 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:23:50.481 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - 204 null null 0.934ms 2025-11-11 15:23:50.537 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-11-11 15:23:50.537 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:23:50.537 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-11-11 15:23:50.538 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-11-11 15:23:50.538 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:23:50.539 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Products - null null 2025-11-11 15:23:50.539 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:23:50.539 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-11-11 15:23:50.540 +00:00 [INF] Executing endpoint 'HTTP: GET /products' 2025-11-11 15:23:50.542 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [ProductTaxes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 15:23:50.542 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:23:50.542 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 15:23:50.542 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-11-11 15:23:50.543 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 4.5971ms 2025-11-11 15:23:50.543 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate] FROM [Settings] AS [s] 2025-11-11 15:23:50.544 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:23:50.544 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-11-11 15:23:50.544 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-11-11 15:23:50.544 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 7.7076ms 2025-11-11 15:23:50.558 +00:00 [INF] Executed DbCommand (15ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [t].[Id], [t].[CreatedById], [t].[CreatedDate], [t].[DeleteFlag], [t].[Description], [t].[UpdatedById], [t].[UpdatedDate], [t0].[Id], [t0].[CreatedById], [t0].[CreatedDate], [t0].[DeleteFlag], [t0].[Percentage], [t0].[TaxDescription], [t0].[UpdatedById], [t0].[UpdatedDate] FROM [Products] AS [p] INNER JOIN ( SELECT [p0].[Id], [p0].[CreatedById], [p0].[CreatedDate], [p0].[DeleteFlag], [p0].[Description], [p0].[UpdatedById], [p0].[UpdatedDate] FROM [ProductCategories] AS [p0] WHERE [p0].[DeleteFlag] = CAST(0 AS bit) ) AS [t] ON [p].[CategoryId] = [t].[Id] INNER JOIN ( SELECT [p1].[Id], [p1].[CreatedById], [p1].[CreatedDate], [p1].[DeleteFlag], [p1].[Percentage], [p1].[TaxDescription], [p1].[UpdatedById], [p1].[UpdatedDate] FROM [ProductTaxes] AS [p1] WHERE [p1].[DeleteFlag] = CAST(0 AS bit) ) AS [t0] ON [p].[ProductTaxId] = [t0].[Id] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 15:23:50.833 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:23:50.833 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 15:23:52.143 +00:00 [INF] Executed endpoint 'HTTP: GET /products' 2025-11-11 15:23:52.143 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Products - 200 null application/json; charset=utf-8 1604.5226ms 2025-11-11 15:23:53.110 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-11-11 15:23:53.110 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductCategory - null null 2025-11-11 15:23:53.110 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:23:53.110 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:23:53.111 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductCategory - 204 null null 1.0901ms 2025-11-11 15:23:53.111 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-11-11 15:23:53.114 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [ProductTaxes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 15:23:53.115 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:23:53.115 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 15:23:53.115 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-11-11 15:23:53.116 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 6.0119ms 2025-11-11 15:23:53.166 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductCategory - null null 2025-11-11 15:23:53.167 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:23:53.167 +00:00 [INF] Executing endpoint 'HTTP: GET ProductCategory/' 2025-11-11 15:23:53.171 +00:00 [INF] Executed DbCommand (3ms) [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) 2025-11-11 15:23:53.171 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:23:53.171 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 15:23:53.171 +00:00 [INF] Executed endpoint 'HTTP: GET ProductCategory/' 2025-11-11 15:23:53.172 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductCategory - 200 null application/json; charset=utf-8 5.1558ms 2025-11-11 15:25:04.391 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-11-11 15:25:04.391 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:25:04.391 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.4098ms 2025-11-11 15:25:04.446 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-11-11 15:25:04.446 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:25:04.447 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-11-11 15:25:04.449 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate] FROM [Settings] AS [s] 2025-11-11 15:25:04.450 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:25:04.450 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-11-11 15:25:04.450 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-11-11 15:25:04.450 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 3.8829ms 2025-11-11 15:25:10.812 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-11 15:25:10.812 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:25:10.812 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2655ms 2025-11-11 15:25:10.813 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-11-11 15:25:10.813 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-11-11 15:25:10.814 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:25:10.814 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:25:10.814 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.2296ms 2025-11-11 15:25:10.814 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.2303ms 2025-11-11 15:25:10.870 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null 2025-11-11 15:25:10.870 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-11-11 15:25:10.870 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:25:10.870 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:25:10.870 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.3254ms 2025-11-11 15:25:10.870 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-11 15:25:10.870 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:25:10.870 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-11-11 15:25:10.870 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-11 15:25:10.873 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate] FROM [Settings] AS [s] 2025-11-11 15:25:10.874 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:25:10.874 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-11-11 15:25:10.874 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-11-11 15:25:10.874 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 4.3049ms 2025-11-11 15:25:10.874 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 15:25:10.875 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:25:10.875 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 15:25:10.875 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-11 15:25:10.875 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 4.8223ms 2025-11-11 15:25:10.876 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-11-11 15:25:10.876 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:25:10.876 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-11-11 15:25:10.879 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [ProductTaxes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 15:25:10.879 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:25:10.880 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 15:25:10.880 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-11-11 15:25:10.880 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 4.2357ms 2025-11-11 15:25:10.926 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null 2025-11-11 15:25:10.927 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:25:10.927 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities' 2025-11-11 15:25:10.930 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [n].[Id], [n].[Descripcion], [n].[Estatus], [n].[Gentilicio], [n].[Siglas] FROM [Nationalities] AS [n] 2025-11-11 15:25:10.931 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:25:10.931 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 15:25:10.931 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities' 2025-11-11 15:25:10.931 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 5.0973ms 2025-11-11 15:25:26.075 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/5 - null null 2025-11-11 15:25:26.075 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:25:26.076 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/5 - 204 null null 0.3071ms 2025-11-11 15:25:26.135 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/5 - null null 2025-11-11 15:25:26.135 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:25:26.135 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 15:25:26.138 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-11 15:25:26.164 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:25:26.165 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 15:25:26.167 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 15:25:26.167 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/5 - 200 null application/json; charset=utf-8 32.4983ms 2025-11-11 15:25:58.588 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-11-11 15:25:58.588 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:25:58.588 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.3463ms 2025-11-11 15:25:58.643 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-11-11 15:25:58.644 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:25:58.644 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-11-11 15:25:58.646 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate] FROM [Settings] AS [s] 2025-11-11 15:25:58.647 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:25:58.647 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-11-11 15:25:58.647 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-11-11 15:25:58.647 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 3.3269ms 2025-11-11 15:26:27.924 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-11-11 15:26:27.924 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:26:27.924 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.581ms 2025-11-11 15:26:27.924 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - null null 2025-11-11 15:26:27.924 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:26:27.925 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - 204 null null 0.1204ms 2025-11-11 15:26:27.925 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-11-11 15:26:27.925 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:26:27.925 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.1095ms 2025-11-11 15:26:27.984 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-11-11 15:26:27.984 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-11-11 15:26:27.984 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:26:27.984 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Products - null null 2025-11-11 15:26:27.984 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:26:27.984 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-11-11 15:26:27.984 +00:00 [INF] Executing endpoint 'HTTP: GET /products' 2025-11-11 15:26:27.984 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:26:27.986 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-11-11 15:26:27.994 +00:00 [INF] Executed DbCommand (8ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [ProductTaxes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 15:26:27.994 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:26:27.994 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 15:26:27.994 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-11-11 15:26:27.994 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 10.7752ms 2025-11-11 15:26:27.996 +00:00 [INF] Executed DbCommand (11ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [t].[Id], [t].[CreatedById], [t].[CreatedDate], [t].[DeleteFlag], [t].[Description], [t].[UpdatedById], [t].[UpdatedDate], [t0].[Id], [t0].[CreatedById], [t0].[CreatedDate], [t0].[DeleteFlag], [t0].[Percentage], [t0].[TaxDescription], [t0].[UpdatedById], [t0].[UpdatedDate] FROM [Products] AS [p] INNER JOIN ( SELECT [p0].[Id], [p0].[CreatedById], [p0].[CreatedDate], [p0].[DeleteFlag], [p0].[Description], [p0].[UpdatedById], [p0].[UpdatedDate] FROM [ProductCategories] AS [p0] WHERE [p0].[DeleteFlag] = CAST(0 AS bit) ) AS [t] ON [p].[CategoryId] = [t].[Id] INNER JOIN ( SELECT [p1].[Id], [p1].[CreatedById], [p1].[CreatedDate], [p1].[DeleteFlag], [p1].[Percentage], [p1].[TaxDescription], [p1].[UpdatedById], [p1].[UpdatedDate] FROM [ProductTaxes] AS [p1] WHERE [p1].[DeleteFlag] = CAST(0 AS bit) ) AS [t0] ON [p].[ProductTaxId] = [t0].[Id] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 15:26:28.007 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate] FROM [Settings] AS [s] 2025-11-11 15:26:28.008 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:26:28.008 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-11-11 15:26:28.008 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-11-11 15:26:28.008 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 24.3826ms 2025-11-11 15:26:28.176 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:26:28.177 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 15:26:28.776 +00:00 [INF] Executed endpoint 'HTTP: GET /products' 2025-11-11 15:26:28.776 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Products - 200 null application/json; charset=utf-8 792.8957ms 2025-11-11 15:26:38.698 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-11-11 15:26:38.698 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:26:38.698 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.2824ms 2025-11-11 15:26:38.698 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-11-11 15:26:38.698 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:26:38.698 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.0485ms 2025-11-11 15:26:38.699 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null 2025-11-11 15:26:38.700 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:26:38.700 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.1533ms 2025-11-11 15:26:38.700 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-11 15:26:38.700 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:26:38.700 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.1187ms 2025-11-11 15:26:38.753 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-11-11 15:26:38.753 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:26:38.753 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-11-11 15:26:38.753 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-11-11 15:26:38.754 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:26:38.754 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-11-11 15:26:38.755 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null 2025-11-11 15:26:38.755 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:26:38.755 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities' 2025-11-11 15:26:38.757 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-11 15:26:38.757 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:26:38.757 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-11 15:26:38.758 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate] FROM [Settings] AS [s] 2025-11-11 15:26:38.758 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:26:38.758 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-11-11 15:26:38.758 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-11-11 15:26:38.758 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 5.4486ms 2025-11-11 15:26:38.758 +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) 2025-11-11 15:26:38.759 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:26:38.759 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 15:26:38.759 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-11-11 15:26:38.759 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 5.8288ms 2025-11-11 15:26:38.760 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [n].[Id], [n].[Descripcion], [n].[Estatus], [n].[Gentilicio], [n].[Siglas] FROM [Nationalities] AS [n] 2025-11-11 15:26:38.760 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:26:38.761 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 15:26:38.761 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities' 2025-11-11 15:26:38.761 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 6.7013ms 2025-11-11 15:26:38.763 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 15:26:38.763 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:26:38.763 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 15:26:38.763 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-11 15:26:38.763 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 6.6978ms 2025-11-11 15:27:03.199 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-11-11 15:27:03.199 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:27:03.199 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.422ms 2025-11-11 15:27:03.199 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - null null 2025-11-11 15:27:03.199 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:27:03.199 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - 204 null null 0.1028ms 2025-11-11 15:27:03.199 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-11-11 15:27:03.199 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:27:03.200 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 1.002ms 2025-11-11 15:27:03.260 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Products - null null 2025-11-11 15:27:03.261 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:27:03.261 +00:00 [INF] Executing endpoint 'HTTP: GET /products' 2025-11-11 15:27:03.260 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-11-11 15:27:03.262 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:27:03.262 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-11-11 15:27:03.263 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-11-11 15:27:03.263 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:27:03.264 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-11-11 15:27:03.267 +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) 2025-11-11 15:27:03.269 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate] FROM [Settings] AS [s] 2025-11-11 15:27:03.269 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:27:03.270 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-11-11 15:27:03.270 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-11-11 15:27:03.270 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 9.2655ms 2025-11-11 15:27:03.271 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [ProductTaxes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 15:27:03.271 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:27:03.271 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 15:27:03.271 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-11-11 15:27:03.271 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 7.8444ms 2025-11-11 15:27:03.492 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:27:03.493 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 15:27:04.133 +00:00 [INF] Executed endpoint 'HTTP: GET /products' 2025-11-11 15:27:04.133 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Products - 200 null application/json; charset=utf-8 873.2476ms 2025-11-11 15:27:29.877 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-11-11 15:27:29.878 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:27:29.877 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductCategory - null null 2025-11-11 15:27:29.878 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:27:29.878 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductCategory - 204 null null 0.4088ms 2025-11-11 15:27:29.878 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.3124ms 2025-11-11 15:27:29.936 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductCategory - null null 2025-11-11 15:27:29.936 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:27:29.936 +00:00 [INF] Executing endpoint 'HTTP: GET ProductCategory/' 2025-11-11 15:27:29.937 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-11-11 15:27:29.937 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:27:29.937 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-11-11 15:27:29.939 +00:00 [INF] Executed DbCommand (1ms) [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) 2025-11-11 15:27:29.939 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:27:29.939 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 15:27:29.939 +00:00 [INF] Executed endpoint 'HTTP: GET ProductCategory/' 2025-11-11 15:27:29.939 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductCategory - 200 null application/json; charset=utf-8 3.2887ms 2025-11-11 15:27:29.939 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [ProductTaxes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 15:27:29.940 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:27:29.940 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 15:27:29.940 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-11-11 15:27:29.940 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 3.2093ms 2025-11-11 15:42:26.404 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ca - null null 2025-11-11 15:42:26.405 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:42:26.406 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ca - 204 null null 1.4075ms 2025-11-11 15:42:26.464 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ca - null null 2025-11-11 15:42:26.464 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:42:26.465 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 15:42:26.747 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-11 15:42:26.816 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:42:26.817 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 15:42:27.211 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 15:42:27.212 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ca - 200 null application/json; charset=utf-8 747.755ms 2025-11-11 15:42:37.632 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/carbon - null null 2025-11-11 15:42:37.632 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:42:37.632 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/carbon - 204 null null 0.2292ms 2025-11-11 15:42:37.692 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/carbon - null null 2025-11-11 15:42:37.692 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:42:37.692 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 15:42:37.695 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-11 15:42:37.700 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:42:37.700 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 15:42:37.701 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 15:42:37.701 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/carbon - 200 null application/json; charset=utf-8 9.3082ms 2025-11-11 15:42:53.539 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/L- - null null 2025-11-11 15:42:53.539 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:42:53.539 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/L- - 204 null null 0.3038ms 2025-11-11 15:42:53.598 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/L- - null null 2025-11-11 15:42:53.598 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:42:53.599 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 15:42:53.601 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-11 15:42:53.607 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:42:53.607 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 15:42:53.608 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 15:42:53.608 +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 9.9448ms 2025-11-11 15:43:49.170 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/levadura - null null 2025-11-11 15:43:49.170 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:43:49.170 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/levadura - 204 null null 0.363ms 2025-11-11 15:43:49.226 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/levadura - null null 2025-11-11 15:43:49.226 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:43:49.227 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 15:43:49.230 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-11 15:43:49.233 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:43:49.233 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 15:43:49.233 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 15:43:49.233 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/levadura - 200 null application/json; charset=utf-8 6.8314ms 2025-11-11 15:45:23.465 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null 2025-11-11 15:45:23.465 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:45:23.465 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.2462ms 2025-11-11 15:45:23.525 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 190 2025-11-11 15:45:23.525 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:45:23.525 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd' 2025-11-11 15:45:23.534 +00:00 [INF] Executed DbCommand (7ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9); 2025-11-11 15:45:23.539 +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); 2025-11-11 15:45:23.540 +00:00 [INF] Setting HTTP status code 201. 2025-11-11 15:45:23.540 +00:00 [INF] Writing value of type 'Int64' as Json. 2025-11-11 15:45:23.540 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd' 2025-11-11 15:45:23.540 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 14.6829ms 2025-11-11 15:45:23.605 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40899 - null null 2025-11-11 15:45:23.605 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:45:23.605 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40899 - 204 null null 0.3547ms 2025-11-11 15:45:23.661 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-11 15:45:23.662 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:45:23.662 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2694ms 2025-11-11 15:45:23.668 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40899 - application/json 329 2025-11-11 15:45:23.669 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:45:23.669 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-11 15:45:23.673 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 15:45:23.718 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-11 15:45:23.718 +00:00 [INF] CORS policy execution successful. 2025-11-11 15:45:23.719 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-11 15:45:23.745 +00:00 [INF] Executed DbCommand (13ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 15:45:23.745 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 15:45:23.745 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 15:45:23.745 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-11 15:45:23.745 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 27.331ms 2025-11-11 15:45:23.817 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'. 2025-11-11 15:45:23.861 +00:00 [INF] Executed DbCommand (44ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p40='?' (DbType = Int32), @p23='?' (Size = 4000), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Int32), @p26='?' (DbType = Guid), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Boolean), @p29='?' (DbType = DateTime2), @p30='?' (DbType = Int32), @p31='?' (Size = 150), @p32='?' (Size = 500), @p33='?' (Size = -1) (DbType = Binary), @p34='?' (DbType = Int32), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p36='?' (Size = 4000), @p37='?' (DbType = Int32), @p38='?' (DbType = Guid), @p39='?' (DbType = DateTime2), @p58='?' (DbType = Int32), @p41='?' (Size = 4000), @p42='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p43='?' (DbType = Int32), @p44='?' (DbType = Guid), @p45='?' (DbType = DateTime2), @p46='?' (DbType = Boolean), @p47='?' (DbType = DateTime2), @p48='?' (DbType = Int32), @p49='?' (Size = 150), @p50='?' (Size = 500), @p51='?' (Size = -1) (DbType = Binary), @p52='?' (DbType = Int32), @p53='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p54='?' (Size = 4000), @p55='?' (DbType = Int32), @p56='?' (DbType = Guid), @p57='?' (DbType = DateTime2), @p59='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p60='?' (DbType = Guid), @p61='?' (DbType = DateTime2), @p62='?' (DbType = Boolean), @p63='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p64='?' (DbType = Int32), @p65='?' (DbType = Int32), @p66='?' (DbType = Int64), @p67='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p68='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p69='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p70='?' (DbType = Guid), @p71='?' (DbType = DateTime2), @p72='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p73='?' (DbType = Guid), @p74='?' (DbType = DateTime2), @p75='?' (DbType = Boolean), @p76='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p77='?' (DbType = Int32), @p78='?' (DbType = Int32), @p79='?' (DbType = Int64), @p80='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p81='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p82='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p83='?' (DbType = Guid), @p84='?' (DbType = DateTime2), @p85='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p86='?' (DbType = Guid), @p87='?' (DbType = DateTime2), @p88='?' (DbType = Boolean), @p89='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p90='?' (DbType = Int32), @p91='?' (DbType = Int32), @p92='?' (DbType = Int64), @p93='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p94='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p95='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p96='?' (DbType = Guid), @p97='?' (DbType = DateTime2), @p98='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p99='?' (DbType = Guid), @p100='?' (DbType = DateTime2), @p101='?' (DbType = Int32), @p102='?' (Size = 34), @p103='?' (DbType = Guid), @p104='?' (DbType = Int32), @p105='?' (DbType = Int32), @p106='?' (DbType = Int32), @p107='?' (Size = 4000), @p108='?' (Size = 4000), @p109='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p110='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p111='?' (DbType = Guid), @p112='?' (DbType = DateTime2), @p113='?' (DbType = Int32), @p114='?' (Size = 34), @p115='?' (DbType = Guid), @p116='?' (DbType = Int32), @p117='?' (DbType = Int32), @p118='?' (DbType = Int32), @p119='?' (Size = 4000), @p120='?' (Size = 4000), @p121='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p122='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p123='?' (DbType = Guid), @p124='?' (DbType = DateTime2), @p125='?' (DbType = Int32), @p126='?' (Size = 34), @p127='?' (DbType = Guid), @p128='?' (DbType = Int32), @p129='?' (DbType = Int32), @p130='?' (DbType = Int32), @p131='?' (Size = 4000), @p132='?' (Size = 4000), @p133='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21 OUTPUT 1 WHERE [Id] = @p22; UPDATE [Products] SET [BarCode] = @p23, [BuyPrice] = @p24, [CategoryId] = @p25, [CreatedById] = @p26, [CreatedDate] = @p27, [DeleteFlag] = @p28, [ExpirationDate] = @p29, [MinimunStock] = @p30, [Name] = @p31, [Note] = @p32, [ProductImage] = @p33, [ProductTaxId] = @p34, [SalePrice] = @p35, [Status] = @p36, [Stock] = @p37, [UpdatedById] = @p38, [UpdatedDate] = @p39 OUTPUT 1 WHERE [Id] = @p40; UPDATE [Products] SET [BarCode] = @p41, [BuyPrice] = @p42, [CategoryId] = @p43, [CreatedById] = @p44, [CreatedDate] = @p45, [DeleteFlag] = @p46, [ExpirationDate] = @p47, [MinimunStock] = @p48, [Name] = @p49, [Note] = @p50, [ProductImage] = @p51, [ProductTaxId] = @p52, [SalePrice] = @p53, [Status] = @p54, [Stock] = @p55, [UpdatedById] = @p56, [UpdatedDate] = @p57 OUTPUT 1 WHERE [Id] = @p58; MERGE [SalesDetail] USING ( VALUES (@p59, @p60, @p61, @p62, @p63, @p64, @p65, @p66, @p67, @p68, @p69, @p70, @p71, 0), (@p72, @p73, @p74, @p75, @p76, @p77, @p78, @p79, @p80, @p81, @p82, @p83, @p84, 1), (@p85, @p86, @p87, @p88, @p89, @p90, @p91, @p92, @p93, @p94, @p95, @p96, @p97, 2)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate], _Position) ON 1=0 WHEN NOT MATCHED THEN INSERT ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate]) VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[DeleteFlag], i.[DiscountAmount], i.[ProductId], i.[Quantity], i.[SalesId], i.[Tax], i.[Total], i.[UnitPrice], i.[UpdatedById], i.[UpdatedDate]) OUTPUT INSERTED.[Id], i._Position; MERGE [InventoryMovements] USING ( VALUES (@p98, @p99, @p100, @p101, @p102, @p103, @p104, @p105, @p106, @p107, @p108, @p109, 0), (@p110, @p111, @p112, @p113, @p114, @p115, @p116, @p117, @p118, @p119, @p120, @p121, 1), (@p122, @p123, @p124, @p125, @p126, @p127, @p128, @p129, @p130, @p131, @p132, @p133, 2)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice], _Position) ON 1=0 WHEN NOT MATCHED THEN INSERT ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice]) VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[Difference], i.[Discriminator], i.[InventoryMovementHeaderId], i.[NewStock], i.[OriginaStock], i.[ProductId], i.[ProductName], i.[Reazon], i.[SalePrice]) OUTPUT INSERTED.[Id], i._Position; 2025-11-11 15:45:23.867 +00:00 [INF] Setting HTTP status code 201. 2025-11-11 15:45:23.867 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-11 15:45:23.867 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40899 - 201 0 null 198.737ms 2025-11-11 17:12:19.100 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null 2025-11-11 17:12:19.101 +00:00 [INF] CORS policy execution successful. 2025-11-11 17:12:19.101 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.303ms 2025-11-11 17:12:19.155 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 58 2025-11-11 17:12:19.156 +00:00 [INF] CORS policy execution successful. 2025-11-11 17:12:19.156 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin' 2025-11-11 17:12:19.409 +00:00 [INF] Executed DbCommand (9ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName] FROM [AspNetUsers] AS [a] WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0 2025-11-11 17:12:19.578 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[@__userId_0='?' (Size = 450)], CommandType='"Text"', CommandTimeout='30'] SELECT [a0].[Name] FROM [AspNetUserRoles] AS [a] INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id] WHERE [a].[UserId] = @__userId_0 2025-11-11 17:12:19.579 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 17:12:19.580 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json. 2025-11-11 17:12:19.580 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin' 2025-11-11 17:12:19.580 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 424.6509ms 2025-11-11 17:12:21.831 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-11-11 17:12:21.832 +00:00 [INF] CORS policy execution successful. 2025-11-11 17:12:21.832 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.2709ms 2025-11-11 17:12:21.886 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - null null 2025-11-11 17:12:21.887 +00:00 [INF] CORS policy execution successful. 2025-11-11 17:12:21.887 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - 204 null null 0.2641ms 2025-11-11 17:12:21.887 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-11-11 17:12:21.887 +00:00 [INF] CORS policy execution successful. 2025-11-11 17:12:21.887 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.1087ms 2025-11-11 17:12:21.890 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-11-11 17:12:21.890 +00:00 [INF] CORS policy execution successful. 2025-11-11 17:12:21.890 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-11-11 17:12:21.904 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate] FROM [Settings] AS [s] 2025-11-11 17:12:21.904 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 17:12:21.904 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-11-11 17:12:21.904 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-11-11 17:12:21.905 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 14.4436ms 2025-11-11 17:12:21.942 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-11-11 17:12:21.942 +00:00 [INF] CORS policy execution successful. 2025-11-11 17:12:21.942 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-11-11 17:12:21.942 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Products - null null 2025-11-11 17:12:21.943 +00:00 [INF] CORS policy execution successful. 2025-11-11 17:12:21.943 +00:00 [INF] Executing endpoint 'HTTP: GET /products' 2025-11-11 17:12:21.947 +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) 2025-11-11 17:12:21.947 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 17:12:21.948 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 17:12:21.948 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-11-11 17:12:21.948 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 6.2118ms 2025-11-11 17:12:21.964 +00:00 [INF] Executed DbCommand (8ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [t].[Id], [t].[CreatedById], [t].[CreatedDate], [t].[DeleteFlag], [t].[Description], [t].[UpdatedById], [t].[UpdatedDate], [t0].[Id], [t0].[CreatedById], [t0].[CreatedDate], [t0].[DeleteFlag], [t0].[Percentage], [t0].[TaxDescription], [t0].[UpdatedById], [t0].[UpdatedDate] FROM [Products] AS [p] INNER JOIN ( SELECT [p0].[Id], [p0].[CreatedById], [p0].[CreatedDate], [p0].[DeleteFlag], [p0].[Description], [p0].[UpdatedById], [p0].[UpdatedDate] FROM [ProductCategories] AS [p0] WHERE [p0].[DeleteFlag] = CAST(0 AS bit) ) AS [t] ON [p].[CategoryId] = [t].[Id] INNER JOIN ( SELECT [p1].[Id], [p1].[CreatedById], [p1].[CreatedDate], [p1].[DeleteFlag], [p1].[Percentage], [p1].[TaxDescription], [p1].[UpdatedById], [p1].[UpdatedDate] FROM [ProductTaxes] AS [p1] WHERE [p1].[DeleteFlag] = CAST(0 AS bit) ) AS [t0] ON [p].[ProductTaxId] = [t0].[Id] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 17:12:22.128 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 17:12:22.129 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 17:12:22.876 +00:00 [INF] Executed endpoint 'HTTP: GET /products' 2025-11-11 17:12:22.876 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Products - 200 null application/json; charset=utf-8 933.3843ms 2025-11-11 18:09:31.373 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/antican - null null 2025-11-11 18:09:31.373 +00:00 [INF] CORS policy execution successful. 2025-11-11 18:09:31.373 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/antican - 204 null null 0.3216ms 2025-11-11 18:09:31.431 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/antican - null null 2025-11-11 18:09:31.431 +00:00 [INF] CORS policy execution successful. 2025-11-11 18:09:31.432 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 18:09:31.689 +00:00 [INF] Executed DbCommand (9ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-11 18:09:31.700 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 18:09:31.700 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 18:09:31.700 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 18:09:31.700 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/antican - 200 null application/json; charset=utf-8 268.7606ms 2025-11-11 18:11:36.577 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-11 18:11:36.577 +00:00 [INF] CORS policy execution successful. 2025-11-11 18:11:36.577 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3462ms 2025-11-11 18:11:36.634 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-11 18:11:36.634 +00:00 [INF] CORS policy execution successful. 2025-11-11 18:11:36.634 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-11 18:11:36.636 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 18:11:36.637 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 18:11:36.637 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 18:11:36.637 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-11 18:11:36.637 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 3.8921ms 2025-11-11 19:20:39.447 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/glisamine - null null 2025-11-11 19:20:39.448 +00:00 [INF] CORS policy execution successful. 2025-11-11 19:20:39.448 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/glisamine - 204 null null 0.3756ms 2025-11-11 19:20:39.508 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/glisamine - null null 2025-11-11 19:20:39.508 +00:00 [INF] CORS policy execution successful. 2025-11-11 19:20:39.508 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 19:20:39.764 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-11 19:20:39.765 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 19:20:39.765 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 19:20:39.765 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 19:20:39.765 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/glisamine - 200 null application/json; charset=utf-8 257.3284ms 2025-11-11 19:20:45.767 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Glucosamine - null null 2025-11-11 19:20:45.767 +00:00 [INF] CORS policy execution successful. 2025-11-11 19:20:45.767 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Glucosamine - 204 null null 0.3352ms 2025-11-11 19:20:45.823 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/Glucosamine - null null 2025-11-11 19:20:45.823 +00:00 [INF] CORS policy execution successful. 2025-11-11 19:20:45.824 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 19:20:45.827 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-11 19:20:45.830 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 19:20:45.830 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 19:20:45.830 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 19:20:45.830 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/Glucosamine - 200 null application/json; charset=utf-8 7.161ms 2025-11-11 19:23:16.233 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-11 19:23:16.234 +00:00 [INF] CORS policy execution successful. 2025-11-11 19:23:16.234 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3025ms 2025-11-11 19:23:16.307 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-11 19:23:16.307 +00:00 [INF] CORS policy execution successful. 2025-11-11 19:23:16.308 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-11 19:23:16.310 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 19:23:16.310 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 19:23:16.311 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 19:23:16.311 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-11 19:23:16.311 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 3.906ms 2025-11-11 20:49:50.639 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/aceite - null null 2025-11-11 20:49:50.640 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:49:50.640 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/aceite - 204 null null 0.3866ms 2025-11-11 20:49:50.701 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/aceite - null null 2025-11-11 20:49:50.701 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:49:50.701 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 20:49:50.975 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-11 20:49:50.994 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 20:49:50.994 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 20:49:51.794 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - null null 2025-11-11 20:49:51.794 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:49:51.794 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - 204 null null 0.2677ms 2025-11-11 20:49:51.969 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - null null 2025-11-11 20:49:51.969 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:49:51.970 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}' 2025-11-11 20:49:51.970 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}' 2025-11-11 20:49:51.970 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - 400 0 null 0.7008ms 2025-11-11 20:49:52.021 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 20:49:52.021 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/aceite - 200 null application/json; charset=utf-8 1320.4653ms 2025-11-11 20:51:38.981 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Fo - null null 2025-11-11 20:51:38.981 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:51:38.981 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Fo - 204 null null 0.4068ms 2025-11-11 20:51:39.042 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/Fo - null null 2025-11-11 20:51:39.043 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:51:39.043 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 20:51:39.047 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-11 20:51:39.059 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 20:51:39.059 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 20:51:39.059 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 20:51:39.059 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/Fo - 200 null application/json; charset=utf-8 17.1507ms 2025-11-11 20:53:59.663 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null 2025-11-11 20:53:59.663 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:53:59.663 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.3231ms 2025-11-11 20:53:59.754 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 58 2025-11-11 20:53:59.755 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:53:59.755 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin' 2025-11-11 20:53:59.771 +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 2025-11-11 20:53:59.880 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (Size = 450)], CommandType='"Text"', CommandTimeout='30'] SELECT [a0].[Name] FROM [AspNetUserRoles] AS [a] INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id] WHERE [a].[UserId] = @__userId_0 2025-11-11 20:53:59.880 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 20:53:59.880 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json. 2025-11-11 20:53:59.880 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin' 2025-11-11 20:53:59.880 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 126.0573ms 2025-11-11 20:54:03.623 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - null null 2025-11-11 20:54:03.623 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:54:03.623 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - 204 null null 0.3145ms 2025-11-11 20:54:03.722 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - null null 2025-11-11 20:54:03.723 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:54:03.724 +00:00 [INF] Executing endpoint 'HTTP: GET InventoryReplenishment/' 2025-11-11 20:54:03.737 +00:00 [INF] Executed DbCommand (12ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [t].[Id], [t].[CreatedById], [t].[CreatedDate], [t].[DeleteFlag], [t].[Description], [t].[UpdatedById], [t].[UpdatedDate], [t0].[Id], [t0].[CreatedById], [t0].[CreatedDate], [t0].[DeleteFlag], [t0].[Percentage], [t0].[TaxDescription], [t0].[UpdatedById], [t0].[UpdatedDate] FROM [Products] AS [p] INNER JOIN ( SELECT [p0].[Id], [p0].[CreatedById], [p0].[CreatedDate], [p0].[DeleteFlag], [p0].[Description], [p0].[UpdatedById], [p0].[UpdatedDate] FROM [ProductCategories] AS [p0] WHERE [p0].[DeleteFlag] = CAST(0 AS bit) ) AS [t] ON [p].[CategoryId] = [t].[Id] INNER JOIN ( SELECT [p1].[Id], [p1].[CreatedById], [p1].[CreatedDate], [p1].[DeleteFlag], [p1].[Percentage], [p1].[TaxDescription], [p1].[UpdatedById], [p1].[UpdatedDate] FROM [ProductTaxes] AS [p1] WHERE [p1].[DeleteFlag] = CAST(0 AS bit) ) AS [t0] ON [p].[ProductTaxId] = [t0].[Id] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 3) 2025-11-11 20:54:03.898 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 20:54:03.899 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 20:54:04.113 +00:00 [INF] Executed endpoint 'HTTP: GET InventoryReplenishment/' 2025-11-11 20:54:04.114 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - 200 null application/json; charset=utf-8 391.3654ms 2025-11-11 20:54:33.379 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-11 20:54:33.380 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:54:33.380 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.377ms 2025-11-11 20:54:33.383 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-11-11 20:54:33.383 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:54:33.383 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.3324ms 2025-11-11 20:54:33.386 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-11-11 20:54:33.387 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:54:33.387 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.4063ms 2025-11-11 20:54:33.390 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null 2025-11-11 20:54:33.390 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:54:33.390 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.263ms 2025-11-11 20:54:33.436 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-11 20:54:33.437 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:54:33.437 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-11 20:54:33.439 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 20:54:33.440 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 20:54:33.440 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 20:54:33.440 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-11 20:54:33.440 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 3.7627ms 2025-11-11 20:54:33.443 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-11-11 20:54:33.444 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:54:33.444 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-11-11 20:54:33.444 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:54:33.444 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-11-11 20:54:33.444 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-11-11 20:54:33.447 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate] FROM [Settings] AS [s] 2025-11-11 20:54:33.447 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 20:54:33.448 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-11-11 20:54:33.448 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-11-11 20:54:33.448 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 4.96ms 2025-11-11 20:54:33.448 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null 2025-11-11 20:54:33.449 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:54:33.449 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities' 2025-11-11 20:54:33.452 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [n].[Id], [n].[Descripcion], [n].[Estatus], [n].[Gentilicio], [n].[Siglas] FROM [Nationalities] AS [n] 2025-11-11 20:54:33.453 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 20:54:33.458 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 20:54:33.458 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities' 2025-11-11 20:54:33.459 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 10.0231ms 2025-11-11 20:54:33.464 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [ProductTaxes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 20:54:33.465 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 20:54:33.465 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 20:54:33.465 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-11-11 20:54:33.466 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 21.8267ms 2025-11-11 20:54:38.885 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/nature - null null 2025-11-11 20:54:38.885 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:54:38.886 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/nature - 204 null null 0.2574ms 2025-11-11 20:54:38.945 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/nature - null null 2025-11-11 20:54:38.946 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:54:38.946 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 20:54:38.950 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-11 20:54:38.958 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 20:54:38.958 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 20:54:39.160 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 20:54:39.161 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/nature - 200 null application/json; charset=utf-8 215.809ms 2025-11-11 20:54:39.655 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - null null 2025-11-11 20:54:39.655 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:54:39.656 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - 204 null null 0.2502ms 2025-11-11 20:54:39.750 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - application/json 46 2025-11-11 20:54:39.751 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:54:39.752 +00:00 [INF] Executing endpoint 'HTTP: POST InventoryReplenishment/createInvRepHD' 2025-11-11 20:54:39.758 +00:00 [INF] Executed DbCommand (5ms) [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); 2025-11-11 20:54:39.759 +00:00 [INF] Setting HTTP status code 201. 2025-11-11 20:54:39.759 +00:00 [INF] Writing value of type 'Guid' as Json. 2025-11-11 20:54:39.760 +00:00 [INF] Executed endpoint 'HTTP: POST InventoryReplenishment/createInvRepHD' 2025-11-11 20:54:39.760 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - 201 null application/json; charset=utf-8 9.6441ms 2025-11-11 20:54:39.834 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - null null 2025-11-11 20:54:39.835 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:54:39.835 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - 204 null null 0.9188ms 2025-11-11 20:54:39.922 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - application/json 205 2025-11-11 20:54:39.923 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:54:39.923 +00:00 [INF] Executing endpoint 'HTTP: POST InventoryReplenishment/createInvRepDet' 2025-11-11 20:54:39.936 +00:00 [INF] Executed DbCommand (11ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [t].[Id], [t].[CreatedById], [t].[CreatedDate], [t].[DeleteFlag], [t].[Description], [t].[UpdatedById], [t].[UpdatedDate], [t0].[Id], [t0].[CreatedById], [t0].[CreatedDate], [t0].[DeleteFlag], [t0].[Percentage], [t0].[TaxDescription], [t0].[UpdatedById], [t0].[UpdatedDate] FROM [Products] AS [p] INNER JOIN ( SELECT [p0].[Id], [p0].[CreatedById], [p0].[CreatedDate], [p0].[DeleteFlag], [p0].[Description], [p0].[UpdatedById], [p0].[UpdatedDate] FROM [ProductCategories] AS [p0] WHERE [p0].[DeleteFlag] = CAST(0 AS bit) ) AS [t] ON [p].[CategoryId] = [t].[Id] INNER JOIN ( SELECT [p1].[Id], [p1].[CreatedById], [p1].[CreatedDate], [p1].[DeleteFlag], [p1].[Percentage], [p1].[TaxDescription], [p1].[UpdatedById], [p1].[UpdatedDate] FROM [ProductTaxes] AS [p1] WHERE [p1].[DeleteFlag] = CAST(0 AS bit) ) AS [t0] ON [p].[ProductTaxId] = [t0].[Id] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 20:54:40.136 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0 2025-11-11 20:54:40.146 +00:00 [INF] Executed DbCommand (7ms) [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; 2025-11-11 20:54:40.150 +00:00 [INF] Setting HTTP status code 201. 2025-11-11 20:54:40.151 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 20:54:40.151 +00:00 [INF] Executed endpoint 'HTTP: POST InventoryReplenishment/createInvRepDet' 2025-11-11 20:54:40.151 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - 201 null application/json; charset=utf-8 228.9561ms 2025-11-11 20:54:40.242 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - null null 2025-11-11 20:54:40.243 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:54:40.243 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - 204 null null 0.4098ms 2025-11-11 20:54:40.330 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - null null 2025-11-11 20:54:40.330 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:54:40.330 +00:00 [INF] Executing endpoint 'HTTP: GET InventoryReplenishment/' 2025-11-11 20:54:40.335 +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) 2025-11-11 20:54:40.490 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 20:54:40.490 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 20:54:40.492 +00:00 [INF] Executed endpoint 'HTTP: GET InventoryReplenishment/' 2025-11-11 20:54:40.492 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - 200 null application/json; charset=utf-8 162.0026ms 2025-11-11 20:55:13.639 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-11 20:55:13.639 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:55:13.639 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2429ms 2025-11-11 20:55:13.698 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-11 20:55:13.698 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:55:13.699 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-11 20:55:13.701 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 20:55:13.701 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 20:55:13.701 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 20:55:13.701 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-11 20:55:13.701 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 2.8589ms 2025-11-11 20:55:18.317 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Fo - null null 2025-11-11 20:55:18.317 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:55:18.317 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Fo - 204 null null 0.4502ms 2025-11-11 20:55:18.377 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/Fo - null null 2025-11-11 20:55:18.377 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:55:18.377 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 20:55:18.380 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-11 20:55:18.392 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 20:55:18.392 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 20:55:18.393 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 20:55:18.393 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/Fo - 200 null application/json; charset=utf-8 16.484ms 2025-11-11 20:55:47.711 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-11 20:55:47.711 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:55:47.711 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2964ms 2025-11-11 20:55:47.790 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-11 20:55:47.790 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:55:47.791 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-11 20:55:47.793 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 20:55:47.793 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 20:55:47.793 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 20:55:47.793 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-11 20:55:47.793 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 3.2151ms 2025-11-11 20:59:33.183 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null 2025-11-11 20:59:33.184 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:59:33.184 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 1.3725ms 2025-11-11 20:59:33.254 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 58 2025-11-11 20:59:33.255 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:59:33.255 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin' 2025-11-11 20:59:33.517 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName] FROM [AspNetUsers] AS [a] WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0 2025-11-11 20:59:33.702 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (Size = 450)], CommandType='"Text"', CommandTimeout='30'] SELECT [a0].[Name] FROM [AspNetUserRoles] AS [a] INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id] WHERE [a].[UserId] = @__userId_0 2025-11-11 20:59:33.703 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 20:59:33.703 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json. 2025-11-11 20:59:33.703 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin' 2025-11-11 20:59:33.703 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 448.8425ms 2025-11-11 20:59:38.710 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryMovement - null null 2025-11-11 20:59:38.711 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:59:38.711 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryMovement - 204 null null 0.2697ms 2025-11-11 20:59:38.790 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/InventoryMovement - null null 2025-11-11 20:59:38.790 +00:00 [INF] CORS policy execution successful. 2025-11-11 20:59:38.791 +00:00 [INF] Executing endpoint 'HTTP: GET InventoryMovement/' 2025-11-11 20:59:38.809 +00:00 [INF] Executed DbCommand (6ms) [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] = 1 2025-11-11 20:59:38.876 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 20:59:38.877 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 20:59:38.878 +00:00 [INF] Executed endpoint 'HTTP: GET InventoryMovement/' 2025-11-11 20:59:38.878 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/InventoryMovement - 200 null application/json; charset=utf-8 87.726ms 2025-11-11 21:00:05.503 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryMovement/createInvMovHD - null null 2025-11-11 21:00:05.503 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:00:05.503 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryMovement/createInvMovHD - 204 null null 0.3649ms 2025-11-11 21:00:05.591 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/InventoryMovement/createInvMovHD - application/json 47 2025-11-11 21:00:05.591 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:00:05.591 +00:00 [INF] Executing endpoint 'HTTP: POST InventoryMovement/createInvMovHD' 2025-11-11 21:00:05.616 +00:00 [INF] Executed DbCommand (18ms) [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); 2025-11-11 21:00:05.618 +00:00 [INF] Setting HTTP status code 201. 2025-11-11 21:00:05.618 +00:00 [INF] Writing value of type 'Guid' as Json. 2025-11-11 21:00:05.618 +00:00 [INF] Executed endpoint 'HTTP: POST InventoryMovement/createInvMovHD' 2025-11-11 21:00:05.618 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/InventoryMovement/createInvMovHD - 201 null application/json; charset=utf-8 27.4618ms 2025-11-11 21:00:05.695 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryMovement/createInvMovDet - null null 2025-11-11 21:00:05.695 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:00:05.696 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryMovement/createInvMovDet - 204 null null 0.6784ms 2025-11-11 21:00:05.784 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/InventoryMovement/createInvMovDet - application/json 412 2025-11-11 21:00:05.785 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:00:05.785 +00:00 [INF] Executing endpoint 'HTTP: POST InventoryMovement/createInvMovDet' 2025-11-11 21:00:05.790 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [t].[Id], [t].[CreatedById], [t].[CreatedDate], [t].[DeleteFlag], [t].[Description], [t].[UpdatedById], [t].[UpdatedDate], [t0].[Id], [t0].[CreatedById], [t0].[CreatedDate], [t0].[DeleteFlag], [t0].[Percentage], [t0].[TaxDescription], [t0].[UpdatedById], [t0].[UpdatedDate] FROM [Products] AS [p] INNER JOIN ( SELECT [p0].[Id], [p0].[CreatedById], [p0].[CreatedDate], [p0].[DeleteFlag], [p0].[Description], [p0].[UpdatedById], [p0].[UpdatedDate] FROM [ProductCategories] AS [p0] WHERE [p0].[DeleteFlag] = CAST(0 AS bit) ) AS [t] ON [p].[CategoryId] = [t].[Id] INNER JOIN ( SELECT [p1].[Id], [p1].[CreatedById], [p1].[CreatedDate], [p1].[DeleteFlag], [p1].[Percentage], [p1].[TaxDescription], [p1].[UpdatedById], [p1].[UpdatedDate] FROM [ProductTaxes] AS [p1] WHERE [p1].[DeleteFlag] = CAST(0 AS bit) ) AS [t0] ON [p].[ProductTaxId] = [t0].[Id] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 21:00:06.006 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0 2025-11-11 21:00:06.008 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0 2025-11-11 21:00:06.036 +00:00 [INF] Executed DbCommand (24ms) [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), @p12='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p13='?' (DbType = Guid), @p14='?' (DbType = DateTime2), @p15='?' (DbType = Int32), @p16='?' (Size = 34), @p17='?' (DbType = Guid), @p18='?' (DbType = Int32), @p19='?' (DbType = Int32), @p20='?' (DbType = Int32), @p21='?' (Size = 4000), @p22='?' (Size = 4000), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p41='?' (DbType = Int32), @p24='?' (Size = 4000), @p25='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p26='?' (DbType = Int32), @p27='?' (DbType = Guid), @p28='?' (DbType = DateTime2), @p29='?' (DbType = Boolean), @p30='?' (DbType = DateTime2), @p31='?' (DbType = Int32), @p32='?' (Size = 150), @p33='?' (Size = 500), @p34='?' (Size = -1) (DbType = Binary), @p35='?' (DbType = Int32), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (Size = 4000), @p38='?' (DbType = Int32), @p39='?' (DbType = Guid), @p40='?' (DbType = DateTime2), @p59='?' (DbType = Int32), @p42='?' (Size = 4000), @p43='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p44='?' (DbType = Int32), @p45='?' (DbType = Guid), @p46='?' (DbType = DateTime2), @p47='?' (DbType = Boolean), @p48='?' (DbType = DateTime2), @p49='?' (DbType = Int32), @p50='?' (Size = 150), @p51='?' (Size = 500), @p52='?' (Size = -1) (DbType = Binary), @p53='?' (DbType = Int32), @p54='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p55='?' (Size = 4000), @p56='?' (DbType = Int32), @p57='?' (DbType = Guid), @p58='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; MERGE [InventoryMovements] USING ( VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, 0), (@p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, 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; UPDATE [Products] SET [BarCode] = @p24, [BuyPrice] = @p25, [CategoryId] = @p26, [CreatedById] = @p27, [CreatedDate] = @p28, [DeleteFlag] = @p29, [ExpirationDate] = @p30, [MinimunStock] = @p31, [Name] = @p32, [Note] = @p33, [ProductImage] = @p34, [ProductTaxId] = @p35, [SalePrice] = @p36, [Status] = @p37, [Stock] = @p38, [UpdatedById] = @p39, [UpdatedDate] = @p40 OUTPUT 1 WHERE [Id] = @p41; UPDATE [Products] SET [BarCode] = @p42, [BuyPrice] = @p43, [CategoryId] = @p44, [CreatedById] = @p45, [CreatedDate] = @p46, [DeleteFlag] = @p47, [ExpirationDate] = @p48, [MinimunStock] = @p49, [Name] = @p50, [Note] = @p51, [ProductImage] = @p52, [ProductTaxId] = @p53, [SalePrice] = @p54, [Status] = @p55, [Stock] = @p56, [UpdatedById] = @p57, [UpdatedDate] = @p58 OUTPUT 1 WHERE [Id] = @p59; 2025-11-11 21:00:06.039 +00:00 [INF] Setting HTTP status code 201. 2025-11-11 21:00:06.040 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 21:00:06.043 +00:00 [INF] Executed endpoint 'HTTP: POST InventoryMovement/createInvMovDet' 2025-11-11 21:00:06.044 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/InventoryMovement/createInvMovDet - 201 null application/json; charset=utf-8 259.1562ms 2025-11-11 21:00:06.194 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryMovement - null null 2025-11-11 21:00:06.195 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:00:06.195 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryMovement - 204 null null 0.3895ms 2025-11-11 21:00:06.270 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/InventoryMovement - null null 2025-11-11 21:00:06.271 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:00:06.271 +00:00 [INF] Executing endpoint 'HTTP: GET InventoryMovement/' 2025-11-11 21:00:06.275 +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] = 1 2025-11-11 21:00:06.411 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 21:00:06.412 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 21:00:06.413 +00:00 [INF] Executed endpoint 'HTTP: GET InventoryMovement/' 2025-11-11 21:00:06.414 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/InventoryMovement - 200 null application/json; charset=utf-8 143.6104ms 2025-11-11 21:00:19.771 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-11 21:00:19.771 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:00:19.771 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.4728ms 2025-11-11 21:00:19.867 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-11-11 21:00:19.867 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:00:19.867 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.7498ms 2025-11-11 21:00:19.874 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-11 21:00:19.874 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-11-11 21:00:19.875 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:00:19.875 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:00:19.875 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 1.0366ms 2025-11-11 21:00:19.876 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-11 21:00:19.876 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null 2025-11-11 21:00:19.876 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:00:19.876 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.1986ms 2025-11-11 21:00:19.878 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 21:00:19.879 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 21:00:19.879 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 21:00:19.879 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-11 21:00:19.880 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 5.4991ms 2025-11-11 21:00:19.942 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-11-11 21:00:19.943 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:00:19.943 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-11-11 21:00:19.946 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [ProductTaxes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 21:00:19.947 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 21:00:19.947 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 21:00:19.947 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-11-11 21:00:19.948 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 5.4526ms 2025-11-11 21:00:19.966 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null 2025-11-11 21:00:19.966 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:00:19.967 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities' 2025-11-11 21:00:19.969 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [n].[Id], [n].[Descripcion], [n].[Estatus], [n].[Gentilicio], [n].[Siglas] FROM [Nationalities] AS [n] 2025-11-11 21:00:19.970 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 21:00:19.970 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 21:00:19.970 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities' 2025-11-11 21:00:19.970 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 3.9935ms 2025-11-11 21:00:19.974 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-11-11 21:00:19.974 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:00:19.975 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-11-11 21:00:19.977 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate] FROM [Settings] AS [s] 2025-11-11 21:00:19.978 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 21:00:19.978 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-11-11 21:00:19.978 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-11-11 21:00:19.978 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 4.4929ms 2025-11-11 21:00:23.303 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/fomentol - null null 2025-11-11 21:00:23.303 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:00:23.303 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/fomentol - 204 null null 0.329ms 2025-11-11 21:00:23.399 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/fomentol - null null 2025-11-11 21:00:23.400 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:00:23.400 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 21:00:23.408 +00:00 [INF] Executed DbCommand (7ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-11 21:00:23.409 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 21:00:23.410 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 21:00:23.410 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 21:00:23.410 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/fomentol - 200 null application/json; charset=utf-8 10.7397ms 2025-11-11 21:47:03.047 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null 2025-11-11 21:47:03.047 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:47:03.047 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.324ms 2025-11-11 21:47:03.107 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 61 2025-11-11 21:47:03.107 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:47:03.107 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin' 2025-11-11 21:47:03.357 +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 2025-11-11 21:47:03.466 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (Size = 450)], CommandType='"Text"', CommandTimeout='30'] SELECT [a0].[Name] FROM [AspNetUserRoles] AS [a] INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id] WHERE [a].[UserId] = @__userId_0 2025-11-11 21:47:03.467 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 21:47:03.467 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json. 2025-11-11 21:47:03.467 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin' 2025-11-11 21:47:03.467 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 360.2961ms 2025-11-11 21:47:06.719 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-11 21:47:06.720 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:47:06.720 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2551ms 2025-11-11 21:47:06.791 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-11-11 21:47:06.792 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:47:06.792 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.24ms 2025-11-11 21:47:06.792 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-11-11 21:47:06.792 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:47:06.792 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.1317ms 2025-11-11 21:47:06.792 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null 2025-11-11 21:47:06.793 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:47:06.793 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.1268ms 2025-11-11 21:47:06.793 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-11 21:47:06.793 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:47:06.793 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-11 21:47:06.808 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 21:47:06.808 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 21:47:06.808 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 21:47:06.809 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-11 21:47:06.809 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 15.487ms 2025-11-11 21:47:06.869 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-11-11 21:47:06.869 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:47:06.869 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-11-11 21:47:06.870 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-11-11 21:47:06.870 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:47:06.870 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-11-11 21:47:06.871 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null 2025-11-11 21:47:06.871 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:47:06.871 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities' 2025-11-11 21:47:06.877 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate] FROM [Settings] AS [s] 2025-11-11 21:47:06.877 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 21:47:06.877 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-11-11 21:47:06.878 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-11-11 21:47:06.878 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 8.8985ms 2025-11-11 21:47:06.888 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [ProductTaxes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 21:47:06.889 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 21:47:06.889 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 21:47:06.889 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-11-11 21:47:06.889 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 19.5543ms 2025-11-11 21:47:06.890 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [n].[Id], [n].[Descripcion], [n].[Estatus], [n].[Gentilicio], [n].[Siglas] FROM [Nationalities] AS [n] 2025-11-11 21:47:06.890 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 21:47:06.890 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 21:47:06.891 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities' 2025-11-11 21:47:06.891 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 19.9501ms 2025-11-11 21:47:10.732 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/bija - null null 2025-11-11 21:47:10.733 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:47:10.733 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/bija - 204 null null 0.3954ms 2025-11-11 21:47:10.792 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/bija - null null 2025-11-11 21:47:10.793 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:47:10.793 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 21:47:10.796 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-11 21:47:10.798 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 21:47:10.798 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 21:47:10.798 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 21:47:10.799 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/bija - 200 null application/json; charset=utf-8 6.3705ms 2025-11-11 21:47:43.716 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-11 21:47:43.716 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:47:43.716 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.5748ms 2025-11-11 21:47:43.775 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-11 21:47:43.775 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:47:43.776 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-11 21:47:43.778 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 21:47:43.778 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 21:47:43.778 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 21:47:43.779 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-11 21:47:43.779 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 3.5303ms 2025-11-11 21:47:47.824 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/sal - null null 2025-11-11 21:47:47.824 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:47:47.824 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/sal - 204 null null 0.2902ms 2025-11-11 21:47:47.884 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/sal - null null 2025-11-11 21:47:47.884 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:47:47.885 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 21:47:47.887 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-11 21:47:47.899 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 21:47:47.899 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 21:47:48.365 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 21:47:48.365 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/sal - 200 null application/json; charset=utf-8 481.0129ms 2025-11-11 21:51:23.347 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/bija - null null 2025-11-11 21:51:23.347 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:51:23.347 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/bija - 204 null null 0.4079ms 2025-11-11 21:51:23.417 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/bija - null null 2025-11-11 21:51:23.417 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:51:23.417 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 21:51:23.421 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-11 21:51:23.424 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 21:51:23.424 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 21:51:23.424 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 21:51:23.425 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/bija - 200 null application/json; charset=utf-8 7.9088ms 2025-11-11 21:51:37.084 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/salsa - null null 2025-11-11 21:51:37.084 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:51:37.084 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/salsa - 204 null null 0.3351ms 2025-11-11 21:51:37.153 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/salsa - null null 2025-11-11 21:51:37.153 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:51:37.153 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 21:51:37.156 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-11 21:51:37.159 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 21:51:37.159 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 21:51:37.159 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 21:51:37.159 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/salsa - 200 null application/json; charset=utf-8 6.0765ms 2025-11-11 21:51:58.662 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/salzon - null null 2025-11-11 21:51:58.662 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:51:58.663 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/salzon - 204 null null 0.3267ms 2025-11-11 21:51:58.728 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/salzon - null null 2025-11-11 21:51:58.729 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:51:58.730 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 21:51:58.735 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-11 21:51:58.735 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 21:51:58.735 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 21:51:58.735 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 21:51:58.735 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/salzon - 200 null application/json; charset=utf-8 6.6078ms 2025-11-11 21:52:03.818 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/sazon - null null 2025-11-11 21:52:03.818 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:52:03.818 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/sazon - 204 null null 0.4018ms 2025-11-11 21:52:03.878 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/sazon - null null 2025-11-11 21:52:03.878 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:52:03.878 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 21:52:03.882 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-11 21:52:03.887 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 21:52:03.887 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 21:52:03.887 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 21:52:03.887 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/sazon - 200 null application/json; charset=utf-8 9.6528ms 2025-11-11 21:52:56.571 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ajonjoli - null null 2025-11-11 21:52:56.571 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:52:56.572 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ajonjoli - 204 null null 0.2989ms 2025-11-11 21:52:56.652 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ajonjoli - null null 2025-11-11 21:52:56.652 +00:00 [INF] CORS policy execution successful. 2025-11-11 21:52:56.652 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 21:52:56.655 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-11 21:52:56.664 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 21:52:56.664 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 21:52:56.897 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 21:52:56.897 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ajonjoli - 200 null application/json; charset=utf-8 245.1486ms 2025-11-11 22:01:39.700 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/stevia - null null 2025-11-11 22:01:39.700 +00:00 [INF] CORS policy execution successful. 2025-11-11 22:01:39.700 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/stevia - 204 null null 0.2883ms 2025-11-11 22:01:39.760 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/stevia - null null 2025-11-11 22:01:39.760 +00:00 [INF] CORS policy execution successful. 2025-11-11 22:01:39.760 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 22:01:39.998 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-11 22:01:40.013 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 22:01:40.013 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 22:01:40.013 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 22:01:40.013 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/stevia - 200 null application/json; charset=utf-8 253.243ms 2025-11-11 22:02:00.636 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - null null 2025-11-11 22:02:00.636 +00:00 [INF] CORS policy execution successful. 2025-11-11 22:02:00.636 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - 204 null null 0.3137ms 2025-11-11 22:02:00.698 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - null null 2025-11-11 22:02:00.698 +00:00 [INF] CORS policy execution successful. 2025-11-11 22:02:00.699 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}' 2025-11-11 22:02:00.699 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}' 2025-11-11 22:02:00.699 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - 400 0 null 0.5975ms 2025-11-11 22:02:02.510 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/12 - null null 2025-11-11 22:02:02.510 +00:00 [INF] CORS policy execution successful. 2025-11-11 22:02:02.511 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/12 - 204 null null 1.2035ms 2025-11-11 22:02:02.577 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/12 - null null 2025-11-11 22:02:02.577 +00:00 [INF] CORS policy execution successful. 2025-11-11 22:02:02.577 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 22:02:02.579 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-11 22:02:02.588 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 22:02:02.588 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 22:02:03.113 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 22:02:03.113 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/12 - 200 null application/json; charset=utf-8 536.8418ms 2025-11-11 22:05:00.707 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-11 22:05:00.707 +00:00 [INF] CORS policy execution successful. 2025-11-11 22:05:00.707 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2305ms 2025-11-11 22:05:00.772 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-11 22:05:00.772 +00:00 [INF] CORS policy execution successful. 2025-11-11 22:05:00.772 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-11 22:05:00.775 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-11 22:05:00.775 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 22:05:00.775 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 22:05:00.775 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-11 22:05:00.775 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 3.4663ms 2025-11-11 22:05:07.547 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/alhumada - null null 2025-11-11 22:05:07.548 +00:00 [INF] CORS policy execution successful. 2025-11-11 22:05:07.548 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/alhumada - 204 null null 0.3644ms 2025-11-11 22:05:07.609 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/alhumada - null null 2025-11-11 22:05:07.610 +00:00 [INF] CORS policy execution successful. 2025-11-11 22:05:07.610 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 22:05:07.615 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-11 22:05:07.616 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 22:05:07.616 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 22:05:07.616 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 22:05:07.617 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/alhumada - 200 null application/json; charset=utf-8 7.1861ms 2025-11-11 22:05:50.328 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/alhumada - null null 2025-11-11 22:05:50.328 +00:00 [INF] CORS policy execution successful. 2025-11-11 22:05:50.329 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/alhumada - 204 null null 0.3268ms 2025-11-11 22:05:50.395 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/alhumada - null null 2025-11-11 22:05:50.396 +00:00 [INF] CORS policy execution successful. 2025-11-11 22:05:50.396 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 22:05:50.401 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-11 22:05:50.401 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 22:05:50.401 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 22:05:50.401 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 22:05:50.401 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/alhumada - 200 null application/json; charset=utf-8 5.9642ms 2025-11-11 22:05:56.185 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ahumada - null null 2025-11-11 22:05:56.186 +00:00 [INF] CORS policy execution successful. 2025-11-11 22:05:56.186 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ahumada - 204 null null 0.4761ms 2025-11-11 22:05:56.263 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ahumada - null null 2025-11-11 22:05:56.263 +00:00 [INF] CORS policy execution successful. 2025-11-11 22:05:56.263 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 22:05:56.268 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-11 22:05:56.270 +00:00 [INF] Setting HTTP status code 200. 2025-11-11 22:05:56.270 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-11 22:05:56.270 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-11 22:05:56.271 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ahumada - 200 null application/json; charset=utf-8 7.7781ms