2025-12-02 06:01:51.758 +00:00 [INF] Request starting HTTP/1.0 GET http:/// - null null 2025-12-02 06:01:51.758 +00:00 [INF] Request finished HTTP/1.0 GET http:/// - 404 0 null 0.9385ms 2025-12-02 06:01:51.759 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http:///, Response status code: 404 2025-12-02 07:34:35.439 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null 2025-12-02 07:34:35.439 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.2534ms 2025-12-02 07:34:35.439 +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-12-02 07:34:44.985 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null 2025-12-02 07:34:44.985 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.2867ms 2025-12-02 07:34:44.985 +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-12-02 07:34:50.265 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/.well-known/security.txt - null null 2025-12-02 07:34:50.265 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/.well-known/security.txt - 404 0 null 0.3261ms 2025-12-02 07:34:50.265 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/.well-known/security.txt, Response status code: 404 2025-12-02 13:33:05.101 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null 2025-12-02 13:33:05.101 +00:00 [INF] CORS policy execution successful. 2025-12-02 13:33:05.101 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.694ms 2025-12-02 13:33:05.161 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 65 2025-12-02 13:33:05.161 +00:00 [INF] CORS policy execution successful. 2025-12-02 13:33:05.161 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin' 2025-12-02 13:33:05.530 +00:00 [INF] Executed DbCommand (18ms) [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-12-02 13:33:05.645 +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-12-02 13:33:05.646 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 13:33:05.646 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json. 2025-12-02 13:33:05.646 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin' 2025-12-02 13:33:05.646 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 485.2471ms 2025-12-02 13:33:08.509 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-12-02 13:33:08.509 +00:00 [INF] CORS policy execution successful. 2025-12-02 13:33:08.509 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.5144ms 2025-12-02 13:33:08.564 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-12-02 13:33:08.564 +00:00 [INF] CORS policy execution successful. 2025-12-02 13:33:08.564 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.2396ms 2025-12-02 13:33:08.564 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-12-02 13:33:08.565 +00:00 [INF] CORS policy execution successful. 2025-12-02 13:33:08.565 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.8726ms 2025-12-02 13:33:08.569 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-12-02 13:33:08.570 +00:00 [INF] CORS policy execution successful. 2025-12-02 13:33:08.570 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null 2025-12-02 13:33:08.570 +00:00 [INF] CORS policy execution successful. 2025-12-02 13:33:08.570 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-12-02 13:33:08.571 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.9867ms 2025-12-02 13:33:08.589 +00:00 [INF] Executed DbCommand (7ms) [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-12-02 13:33:08.590 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 13:33:08.590 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 13:33:08.590 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-12-02 13:33:08.590 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 20.5001ms 2025-12-02 13:33:08.618 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-12-02 13:33:08.618 +00:00 [INF] CORS policy execution successful. 2025-12-02 13:33:08.618 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-12-02 13:33:08.620 +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-12-02 13:33:08.620 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 13:33:08.621 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 13:33:08.621 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-12-02 13:33:08.621 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 3.1836ms 2025-12-02 13:33:08.621 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-12-02 13:33:08.621 +00:00 [INF] CORS policy execution successful. 2025-12-02 13:33:08.621 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-12-02 13:33:08.623 +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-12-02 13:33:08.624 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 13:33:08.624 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-12-02 13:33:08.624 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-12-02 13:33:08.624 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 3.6097ms 2025-12-02 13:33:08.630 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null 2025-12-02 13:33:08.630 +00:00 [INF] CORS policy execution successful. 2025-12-02 13:33:08.630 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities' 2025-12-02 13:33:08.632 +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-12-02 13:33:08.633 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 13:33:08.633 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 13:33:08.633 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities' 2025-12-02 13:33:08.633 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 3.8228ms 2025-12-02 13:33:14.041 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/moringa - null null 2025-12-02 13:33:14.042 +00:00 [INF] CORS policy execution successful. 2025-12-02 13:33:14.042 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/moringa - 204 null null 1.0789ms 2025-12-02 13:33:14.099 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/moringa - null null 2025-12-02 13:33:14.099 +00:00 [INF] CORS policy execution successful. 2025-12-02 13:33:14.100 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 13:33:14.108 +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-12-02 13:33:14.111 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 13:33:14.111 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 13:33:14.112 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 13:33:14.113 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/moringa - 200 null application/json; charset=utf-8 13.5689ms 2025-12-02 13:33:18.541 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/92 - null null 2025-12-02 13:33:18.541 +00:00 [INF] CORS policy execution successful. 2025-12-02 13:33:18.541 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/92 - 204 null null 0.2846ms 2025-12-02 13:33:18.598 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/92 - null null 2025-12-02 13:33:18.598 +00:00 [INF] CORS policy execution successful. 2025-12-02 13:33:18.599 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}' 2025-12-02 13:33:18.606 +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-12-02 13:33:18.607 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 13:33:18.607 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json. 2025-12-02 13:33:18.607 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}' 2025-12-02 13:33:18.611 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/92 - 200 null application/json; charset=utf-8 13.4162ms 2025-12-02 13:34:52.347 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null 2025-12-02 13:34:52.347 +00:00 [INF] CORS policy execution successful. 2025-12-02 13:34:52.347 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3715ms 2025-12-02 13:34:52.400 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182 2025-12-02 13:34:52.401 +00:00 [INF] CORS policy execution successful. 2025-12-02 13:34:52.401 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd' 2025-12-02 13:34:52.410 +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-12-02 13:34:52.413 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7); 2025-12-02 13:34:52.414 +00:00 [INF] Setting HTTP status code 201. 2025-12-02 13:34:52.414 +00:00 [INF] Writing value of type 'Int64' as Json. 2025-12-02 13:34:52.414 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd' 2025-12-02 13:34:52.415 +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.0329ms 2025-12-02 13:34:52.477 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41045 - null null 2025-12-02 13:34:52.477 +00:00 [INF] CORS policy execution successful. 2025-12-02 13:34:52.478 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41045 - 204 null null 0.7752ms 2025-12-02 13:34:52.487 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-12-02 13:34:52.487 +00:00 [INF] CORS policy execution successful. 2025-12-02 13:34:52.488 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.8371ms 2025-12-02 13:34:52.537 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41045 - application/json 104 2025-12-02 13:34:52.537 +00:00 [INF] CORS policy execution successful. 2025-12-02 13:34:52.538 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-12-02 13:34:52.540 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-12-02 13:34:52.547 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-12-02 13:34:52.548 +00:00 [INF] CORS policy execution successful. 2025-12-02 13:34:52.548 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-12-02 13:34:52.567 +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-12-02 13:34:52.568 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 13:34:52.568 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 13:34:52.568 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-12-02 13:34:52.569 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 21.9632ms 2025-12-02 13:34:52.699 +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-12-02 13:34:52.707 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21 OUTPUT 1 WHERE [Id] = @p22; INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35); INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice]) OUTPUT INSERTED.[Id] VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47); 2025-12-02 13:34:52.712 +00:00 [INF] Setting HTTP status code 201. 2025-12-02 13:34:52.713 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-12-02 13:34:52.713 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41045 - 201 0 null 176.1754ms 2025-12-02 15:14:21.496 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/omega - null null 2025-12-02 15:14:21.496 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:14:21.496 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/omega - 204 null null 0.3181ms 2025-12-02 15:14:21.557 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/omega - null null 2025-12-02 15:14:21.557 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:14:21.557 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 15:14:21.793 +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-12-02 15:14:21.804 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 15:14:21.805 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 15:14:21.914 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 15:14:21.914 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/omega - 200 null application/json; charset=utf-8 357.6934ms 2025-12-02 15:14:58.939 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-12-02 15:14:58.940 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:14:58.940 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.4525ms 2025-12-02 15:14:58.998 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-12-02 15:14:58.998 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:14:58.999 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-12-02 15:14:59.001 +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-12-02 15:14:59.001 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 15:14:59.001 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 15:14:59.001 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-12-02 15:14:59.001 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 3.1826ms 2025-12-02 15:36:11.631 +00:00 [INF] Request starting HTTP/1.0 GET http:/// - null null 2025-12-02 15:36:11.631 +00:00 [INF] Request finished HTTP/1.0 GET http:/// - 404 0 null 0.6075ms 2025-12-02 15:36:11.631 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http:///, Response status code: 404 2025-12-02 15:58:14.155 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null 2025-12-02 15:58:14.155 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:58:14.155 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.2419ms 2025-12-02 15:58:14.207 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 58 2025-12-02 15:58:14.207 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:58:14.207 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin' 2025-12-02 15:58:14.448 +00:00 [INF] Executed DbCommand (7ms) [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-12-02 15:58:14.567 +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-12-02 15:58:14.568 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 15:58:14.569 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json. 2025-12-02 15:58:14.569 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin' 2025-12-02 15:58:14.569 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 362.4369ms 2025-12-02 15:58:23.150 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - null null 2025-12-02 15:58:23.150 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:58:23.151 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - 204 null null 0.32ms 2025-12-02 15:58:23.202 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - null null 2025-12-02 15:58:23.202 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:58:23.204 +00:00 [INF] Executing endpoint 'HTTP: GET InventoryReplenishment/' 2025-12-02 15:58:23.225 +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] IN (1, 3) 2025-12-02 15:58:23.371 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 15:58:23.371 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 15:58:23.373 +00:00 [INF] Executed endpoint 'HTTP: GET InventoryReplenishment/' 2025-12-02 15:58:23.373 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - 200 null application/json; charset=utf-8 170.7756ms 2025-12-02 15:59:02.834 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - null null 2025-12-02 15:59:02.834 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:02.834 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - 204 null null 0.3258ms 2025-12-02 15:59:02.885 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - application/json 45 2025-12-02 15:59:02.885 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:02.886 +00:00 [INF] Executing endpoint 'HTTP: POST InventoryReplenishment/createInvRepHD' 2025-12-02 15:59:02.891 +00:00 [INF] Executed DbCommand (4ms) [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-12-02 15:59:02.891 +00:00 [INF] Setting HTTP status code 201. 2025-12-02 15:59:02.891 +00:00 [INF] Writing value of type 'Guid' as Json. 2025-12-02 15:59:02.891 +00:00 [INF] Executed endpoint 'HTTP: POST InventoryReplenishment/createInvRepHD' 2025-12-02 15:59:02.891 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - 201 null application/json; charset=utf-8 6.3287ms 2025-12-02 15:59:02.944 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - null null 2025-12-02 15:59:02.944 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:02.944 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - 204 null null 0.4039ms 2025-12-02 15:59:02.995 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - application/json 421 2025-12-02 15:59:02.996 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:02.996 +00:00 [INF] Executing endpoint 'HTTP: POST InventoryReplenishment/createInvRepDet' 2025-12-02 15:59:03.001 +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-12-02 15:59:03.237 +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-12-02 15:59:03.240 +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-12-02 15:59:03.249 +00:00 [INF] Executed DbCommand (5ms) [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-12-02 15:59:03.255 +00:00 [INF] Setting HTTP status code 201. 2025-12-02 15:59:03.256 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 15:59:03.256 +00:00 [INF] Executed endpoint 'HTTP: POST InventoryReplenishment/createInvRepDet' 2025-12-02 15:59:03.256 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - 201 null application/json; charset=utf-8 260.7609ms 2025-12-02 15:59:03.309 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - null null 2025-12-02 15:59:03.309 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:03.309 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - 204 null null 0.3679ms 2025-12-02 15:59:03.362 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - null null 2025-12-02 15:59:03.362 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:03.363 +00:00 [INF] Executing endpoint 'HTTP: GET InventoryReplenishment/' 2025-12-02 15:59:03.368 +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) AND [p].[CategoryId] IN (1, 3) 2025-12-02 15:59:03.559 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 15:59:03.559 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 15:59:03.560 +00:00 [INF] Executed endpoint 'HTTP: GET InventoryReplenishment/' 2025-12-02 15:59:03.560 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - 200 null application/json; charset=utf-8 198.3157ms 2025-12-02 15:59:07.700 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-12-02 15:59:07.700 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:07.700 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.3131ms 2025-12-02 15:59:07.751 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-12-02 15:59:07.761 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - null null 2025-12-02 15:59:07.762 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:07.762 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - 204 null null 1.1262ms 2025-12-02 15:59:07.762 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:07.763 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 11.9634ms 2025-12-02 15:59:07.769 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-12-02 15:59:07.769 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:07.769 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-12-02 15:59:07.772 +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-12-02 15:59:07.773 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 15:59:07.773 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-12-02 15:59:07.774 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-12-02 15:59:07.774 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 5.5607ms 2025-12-02 15:59:07.816 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-12-02 15:59:07.816 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:07.817 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-12-02 15:59:07.820 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Products - null null 2025-12-02 15:59:07.820 +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-12-02 15:59:07.821 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 15:59:07.821 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 15:59:07.821 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-12-02 15:59:07.821 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 5.5658ms 2025-12-02 15:59:07.821 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:07.822 +00:00 [INF] Executing endpoint 'HTTP: GET /products' 2025-12-02 15:59:07.833 +00:00 [INF] Executed DbCommand (10ms) [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-12-02 15:59:08.196 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 15:59:08.197 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 15:59:09.538 +00:00 [INF] Executed endpoint 'HTTP: GET /products' 2025-12-02 15:59:09.538 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Products - 200 null application/json; charset=utf-8 1718.5636ms 2025-12-02 15:59:12.984 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductCategory - null null 2025-12-02 15:59:12.984 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:12.985 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductCategory - 204 null null 0.2832ms 2025-12-02 15:59:12.985 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/362 - null null 2025-12-02 15:59:12.985 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:12.985 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/362 - 204 null null 0.0767ms 2025-12-02 15:59:12.985 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-12-02 15:59:12.985 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:12.985 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.0493ms 2025-12-02 15:59:13.037 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductCategory - null null 2025-12-02 15:59:13.037 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:13.037 +00:00 [INF] Executing endpoint 'HTTP: GET ProductCategory/' 2025-12-02 15:59:13.040 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Description], [p].[UpdatedById], [p].[UpdatedDate] FROM [ProductCategories] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-12-02 15:59:13.041 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 15:59:13.041 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 15:59:13.041 +00:00 [INF] Executed endpoint 'HTTP: GET ProductCategory/' 2025-12-02 15:59:13.041 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductCategory - 200 null application/json; charset=utf-8 3.9087ms 2025-12-02 15:59:13.042 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-12-02 15:59:13.042 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:13.043 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-12-02 15:59:13.047 +00:00 [INF] Executed DbCommand (3ms) [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-12-02 15:59:13.048 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 15:59:13.048 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 15:59:13.049 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-12-02 15:59:13.049 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 6.748ms 2025-12-02 15:59:13.053 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/362 - null null 2025-12-02 15:59:13.054 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:13.054 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}' 2025-12-02 15:59:13.058 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0 2025-12-02 15:59:13.058 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 15:59:13.058 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json. 2025-12-02 15:59:13.059 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}' 2025-12-02 15:59:13.059 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/362 - 200 null application/json; charset=utf-8 5.3061ms 2025-12-02 15:59:16.639 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/362 - null null 2025-12-02 15:59:16.639 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:16.639 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/362 - 204 null null 0.2529ms 2025-12-02 15:59:16.708 +00:00 [INF] Request starting HTTP/1.1 PUT http://159.89.226.33:5227/products/362 - application/json 23614 2025-12-02 15:59:16.708 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:16.709 +00:00 [INF] Executing endpoint 'HTTP: PUT Products/{id}' 2025-12-02 15:59:16.779 +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-12-02 15:59:16.784 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p17='?' (DbType = Int32), @p0='?' (Size = 4000), @p1='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p2='?' (DbType = Int32), @p3='?' (DbType = Guid), @p4='?' (DbType = DateTime2), @p5='?' (DbType = Boolean), @p6='?' (DbType = DateTime2), @p7='?' (DbType = Int32), @p8='?' (Size = 150), @p9='?' (Size = 500), @p10='?' (Size = -1) (DbType = Binary), @p11='?' (DbType = Int32), @p12='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p13='?' (Size = 4000), @p14='?' (DbType = Int32), @p15='?' (DbType = Guid), @p16='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; UPDATE [Products] SET [BarCode] = @p0, [BuyPrice] = @p1, [CategoryId] = @p2, [CreatedById] = @p3, [CreatedDate] = @p4, [DeleteFlag] = @p5, [ExpirationDate] = @p6, [MinimunStock] = @p7, [Name] = @p8, [Note] = @p9, [ProductImage] = @p10, [ProductTaxId] = @p11, [SalePrice] = @p12, [Status] = @p13, [Stock] = @p14, [UpdatedById] = @p15, [UpdatedDate] = @p16 OUTPUT 1 WHERE [Id] = @p17; 2025-12-02 15:59:16.785 +00:00 [INF] Setting HTTP status code 204. 2025-12-02 15:59:16.785 +00:00 [INF] Executed endpoint 'HTTP: PUT Products/{id}' 2025-12-02 15:59:16.785 +00:00 [INF] Request finished HTTP/1.1 PUT http://159.89.226.33:5227/products/362 - 204 null null 76.7901ms 2025-12-02 15:59:18.862 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-12-02 15:59:18.862 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:18.862 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.5681ms 2025-12-02 15:59:18.862 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - null null 2025-12-02 15:59:18.863 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:18.863 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - 204 null null 1.1706ms 2025-12-02 15:59:18.863 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-12-02 15:59:18.863 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:18.864 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.1946ms 2025-12-02 15:59:18.914 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Products - null null 2025-12-02 15:59:18.914 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:18.914 +00:00 [INF] Executing endpoint 'HTTP: GET /products' 2025-12-02 15:59:18.919 +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-12-02 15:59:18.920 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-12-02 15:59:18.921 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:18.921 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-12-02 15:59:18.932 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-12-02 15:59:18.932 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:18.933 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-12-02 15:59:18.942 +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-12-02 15:59:18.942 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 15:59:18.942 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 15:59:18.942 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-12-02 15:59:18.942 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 21.7256ms 2025-12-02 15:59:18.961 +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-12-02 15:59:18.962 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 15:59:18.963 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-12-02 15:59:18.963 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-12-02 15:59:18.963 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 31.3361ms 2025-12-02 15:59:19.155 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 15:59:19.155 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 15:59:20.105 +00:00 [INF] Executed endpoint 'HTTP: GET /products' 2025-12-02 15:59:20.105 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Products - 200 null application/json; charset=utf-8 1191.4232ms 2025-12-02 15:59:24.368 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductCategory - null null 2025-12-02 15:59:24.368 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:24.368 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductCategory - 204 null null 0.3539ms 2025-12-02 15:59:24.368 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-12-02 15:59:24.368 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:24.368 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.0837ms 2025-12-02 15:59:24.370 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/364 - null null 2025-12-02 15:59:24.370 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:24.370 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/364 - 204 null null 0.2433ms 2025-12-02 15:59:24.420 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-12-02 15:59:24.420 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:24.420 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-12-02 15:59:24.422 +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-12-02 15:59:24.423 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 15:59:24.423 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 15:59:24.423 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-12-02 15:59:24.423 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 3.2078ms 2025-12-02 15:59:24.427 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/364 - null null 2025-12-02 15:59:24.427 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:24.427 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}' 2025-12-02 15:59:24.430 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0 2025-12-02 15:59:24.432 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 15:59:24.432 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json. 2025-12-02 15:59:24.432 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}' 2025-12-02 15:59:24.432 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/364 - 200 null application/json; charset=utf-8 5.5306ms 2025-12-02 15:59:24.436 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductCategory - null null 2025-12-02 15:59:24.437 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:24.437 +00:00 [INF] Executing endpoint 'HTTP: GET ProductCategory/' 2025-12-02 15:59:24.440 +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-12-02 15:59:24.440 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 15:59:24.440 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 15:59:24.441 +00:00 [INF] Executed endpoint 'HTTP: GET ProductCategory/' 2025-12-02 15:59:24.441 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductCategory - 200 null application/json; charset=utf-8 4.377ms 2025-12-02 15:59:28.834 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/364 - null null 2025-12-02 15:59:28.834 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:28.834 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/364 - 204 null null 0.2946ms 2025-12-02 15:59:28.891 +00:00 [INF] Request starting HTTP/1.1 PUT http://159.89.226.33:5227/products/364 - application/json 23614 2025-12-02 15:59:28.892 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:28.892 +00:00 [INF] Executing endpoint 'HTTP: PUT Products/{id}' 2025-12-02 15:59:28.951 +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-12-02 15:59:28.957 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p17='?' (DbType = Int32), @p0='?' (Size = 4000), @p1='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p2='?' (DbType = Int32), @p3='?' (DbType = Guid), @p4='?' (DbType = DateTime2), @p5='?' (DbType = Boolean), @p6='?' (DbType = DateTime2), @p7='?' (DbType = Int32), @p8='?' (Size = 150), @p9='?' (Size = 500), @p10='?' (Size = -1) (DbType = Binary), @p11='?' (DbType = Int32), @p12='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p13='?' (Size = 4000), @p14='?' (DbType = Int32), @p15='?' (DbType = Guid), @p16='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; UPDATE [Products] SET [BarCode] = @p0, [BuyPrice] = @p1, [CategoryId] = @p2, [CreatedById] = @p3, [CreatedDate] = @p4, [DeleteFlag] = @p5, [ExpirationDate] = @p6, [MinimunStock] = @p7, [Name] = @p8, [Note] = @p9, [ProductImage] = @p10, [ProductTaxId] = @p11, [SalePrice] = @p12, [Status] = @p13, [Stock] = @p14, [UpdatedById] = @p15, [UpdatedDate] = @p16 OUTPUT 1 WHERE [Id] = @p17; 2025-12-02 15:59:28.957 +00:00 [INF] Setting HTTP status code 204. 2025-12-02 15:59:28.957 +00:00 [INF] Executed endpoint 'HTTP: PUT Products/{id}' 2025-12-02 15:59:28.957 +00:00 [INF] Request finished HTTP/1.1 PUT http://159.89.226.33:5227/products/364 - 204 null null 65.8121ms 2025-12-02 15:59:31.033 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - null null 2025-12-02 15:59:31.033 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:31.033 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - 204 null null 0.2623ms 2025-12-02 15:59:31.033 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-12-02 15:59:31.034 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:31.034 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 1.3578ms 2025-12-02 15:59:31.035 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-12-02 15:59:31.035 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:31.035 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.1669ms 2025-12-02 15:59:31.085 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Products - null null 2025-12-02 15:59:31.085 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:31.085 +00:00 [INF] Executing endpoint 'HTTP: GET /products' 2025-12-02 15:59:31.090 +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) 2025-12-02 15:59:31.092 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-12-02 15:59:31.092 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:31.093 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-12-02 15:59:31.094 +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-12-02 15:59:31.095 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 15:59:31.095 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-12-02 15:59:31.095 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-12-02 15:59:31.095 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 2.9129ms 2025-12-02 15:59:31.102 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-12-02 15:59:31.102 +00:00 [INF] CORS policy execution successful. 2025-12-02 15:59:31.103 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-12-02 15:59:31.104 +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-12-02 15:59:31.104 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 15:59:31.104 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 15:59:31.105 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-12-02 15:59:31.105 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 2.4226ms 2025-12-02 15:59:31.279 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 15:59:31.279 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 15:59:32.057 +00:00 [INF] Executed endpoint 'HTTP: GET /products' 2025-12-02 15:59:32.057 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Products - 200 null application/json; charset=utf-8 972.0913ms 2025-12-02 16:00:03.687 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-12-02 16:00:03.687 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:00:03.687 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.3193ms 2025-12-02 16:00:03.687 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductCategory - null null 2025-12-02 16:00:03.688 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:00:03.688 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductCategory - 204 null null 1.0115ms 2025-12-02 16:00:03.740 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-12-02 16:00:03.749 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:00:03.750 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-12-02 16:00:03.758 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductCategory - null null 2025-12-02 16:00:03.758 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:00:03.758 +00:00 [INF] Executing endpoint 'HTTP: GET ProductCategory/' 2025-12-02 16:00:03.764 +00:00 [INF] Executed DbCommand (4ms) [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-12-02 16:00:03.764 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 16:00:03.764 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 16:00:03.764 +00:00 [INF] Executed endpoint 'HTTP: GET ProductCategory/' 2025-12-02 16:00:03.764 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductCategory - 200 null application/json; charset=utf-8 6.5049ms 2025-12-02 16:00:03.770 +00:00 [INF] Executed DbCommand (19ms) [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-12-02 16:00:03.771 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 16:00:03.771 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 16:00:03.771 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-12-02 16:00:03.771 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 31.3856ms 2025-12-02 16:00:28.035 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products - null null 2025-12-02 16:00:28.035 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:00:28.035 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products - 204 null null 0.3856ms 2025-12-02 16:00:28.106 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/products - application/json 23612 2025-12-02 16:00:28.106 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:00:28.107 +00:00 [INF] Executing endpoint 'HTTP: POST Products/' 2025-12-02 16:00:28.123 +00:00 [INF] Executed DbCommand (14ms) [Parameters=[@p0='?' (Size = 4000), @p1='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p2='?' (DbType = Int32), @p3='?' (DbType = Guid), @p4='?' (DbType = DateTime2), @p5='?' (DbType = Boolean), @p6='?' (DbType = DateTime2), @p7='?' (DbType = Int32), @p8='?' (Size = 150), @p9='?' (Size = 500), @p10='?' (Size = -1) (DbType = Binary), @p11='?' (DbType = Int32), @p12='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p13='?' (Size = 4000), @p14='?' (DbType = Int32), @p15='?' (DbType = Guid), @p16='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [Products] ([BarCode], [BuyPrice], [CategoryId], [CreatedById], [CreatedDate], [DeleteFlag], [ExpirationDate], [MinimunStock], [Name], [Note], [ProductImage], [ProductTaxId], [SalePrice], [Status], [Stock], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16); 2025-12-02 16:00:28.125 +00:00 [INF] Setting HTTP status code 201. 2025-12-02 16:00:28.126 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json. 2025-12-02 16:00:28.126 +00:00 [INF] Executed endpoint 'HTTP: POST Products/' 2025-12-02 16:00:28.126 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/products - 201 null application/json; charset=utf-8 20.438ms 2025-12-02 16:00:30.274 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-12-02 16:00:30.274 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:00:30.274 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.306ms 2025-12-02 16:00:30.274 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-12-02 16:00:30.274 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:00:30.274 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.0684ms 2025-12-02 16:00:30.276 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - null null 2025-12-02 16:00:30.276 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:00:30.276 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - 204 null null 0.3547ms 2025-12-02 16:00:30.326 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-12-02 16:00:30.326 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:00:30.326 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-12-02 16:00:30.329 +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-12-02 16:00:30.330 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 16:00:30.330 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 16:00:30.331 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-12-02 16:00:30.331 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 5.4454ms 2025-12-02 16:00:30.333 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Products - null null 2025-12-02 16:00:30.333 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:00:30.334 +00:00 [INF] Executing endpoint 'HTTP: GET /products' 2025-12-02 16:00:30.338 +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-12-02 16:00:30.342 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-12-02 16:00:30.343 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:00:30.343 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-12-02 16:00:30.350 +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-12-02 16:00:30.350 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 16:00:30.351 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-12-02 16:00:30.351 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-12-02 16:00:30.351 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 8.9944ms 2025-12-02 16:00:30.527 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 16:00:30.528 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 16:00:31.314 +00:00 [INF] Executed endpoint 'HTTP: GET /products' 2025-12-02 16:00:31.314 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Products - 200 null application/json; charset=utf-8 980.6168ms 2025-12-02 16:32:49.528 +00:00 [INF] Request starting HTTP/1.1 GET http://localhost:5227/.env - null null 2025-12-02 16:32:49.528 +00:00 [INF] Request finished HTTP/1.1 GET http://localhost:5227/.env - 404 0 null 0.3095ms 2025-12-02 16:32:49.528 +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-12-02 16:42:00.230 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/kefir - null null 2025-12-02 16:42:00.230 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:42:00.230 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/kefir - 204 null null 0.2945ms 2025-12-02 16:42:00.290 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/kefir - null null 2025-12-02 16:42:00.290 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:42:00.290 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 16:42:00.547 +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-12-02 16:42:00.547 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 16:42:00.547 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 16:42:00.547 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 16:42:00.547 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/kefir - 200 null application/json; charset=utf-8 257.723ms 2025-12-02 16:42:11.310 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null 2025-12-02 16:42:11.310 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:42:11.310 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.2957ms 2025-12-02 16:42:11.365 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 179 2025-12-02 16:42:11.365 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:42:11.366 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd' 2025-12-02 16:42:11.370 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9); 2025-12-02 16:42:11.376 +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-12-02 16:42:11.377 +00:00 [INF] Setting HTTP status code 201. 2025-12-02 16:42:11.377 +00:00 [INF] Writing value of type 'Int64' as Json. 2025-12-02 16:42:11.378 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd' 2025-12-02 16:42:11.378 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 12.8684ms 2025-12-02 16:42:11.437 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41046 - null null 2025-12-02 16:42:11.437 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:42:11.438 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41046 - 204 null null 0.2841ms 2025-12-02 16:42:11.496 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-12-02 16:42:11.496 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:42:11.496 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.7416ms 2025-12-02 16:42:11.507 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41046 - application/json 104 2025-12-02 16:42:11.508 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:42:11.508 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-12-02 16:42:11.510 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-12-02 16:42:11.557 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-12-02 16:42:11.557 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:42:11.557 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-12-02 16:42:11.588 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-12-02 16:42:11.589 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 16:42:11.589 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 16:42:11.589 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-12-02 16:42:11.589 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 32.4604ms 2025-12-02 16:42:11.676 +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-12-02 16:42:11.678 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21 OUTPUT 1 WHERE [Id] = @p22; INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35); INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice]) OUTPUT INSERTED.[Id] VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47); 2025-12-02 16:42:11.682 +00:00 [INF] Setting HTTP status code 201. 2025-12-02 16:42:11.682 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-12-02 16:42:11.682 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41046 - 201 0 null 174.765ms 2025-12-02 16:43:09.777 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma local - null null 2025-12-02 16:43:09.777 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:43:09.777 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma local - 204 null null 0.3858ms 2025-12-02 16:43:09.836 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma local - null null 2025-12-02 16:43:09.836 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:43:09.836 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 16:43:09.841 +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-12-02 16:43:09.842 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 16:43:09.842 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 16:43:09.842 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 16:43:09.842 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma local - 200 null application/json; charset=utf-8 6.2061ms 2025-12-02 16:47:25.551 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma local - null null 2025-12-02 16:47:25.551 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:47:25.551 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma local - 204 null null 0.3077ms 2025-12-02 16:47:25.611 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma local - null null 2025-12-02 16:47:25.611 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:47:25.611 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 16:47:25.616 +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-12-02 16:47:25.617 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 16:47:25.617 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 16:47:25.617 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 16:47:25.617 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma local - 200 null application/json; charset=utf-8 5.9975ms 2025-12-02 16:47:32.919 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - null null 2025-12-02 16:47:32.919 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:47:32.919 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - 204 null null 0.2563ms 2025-12-02 16:47:32.979 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma - null null 2025-12-02 16:47:32.979 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:47:32.979 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 16:47:32.982 +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-12-02 16:47:32.993 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 16:47:32.993 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 16:47:33.162 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 16:47:33.162 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma - 200 null application/json; charset=utf-8 183.0604ms 2025-12-02 16:47:37.828 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1415 - null null 2025-12-02 16:47:37.828 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:47:37.828 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1415 - 204 null null 0.4382ms 2025-12-02 16:47:37.888 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/1415 - null null 2025-12-02 16:47:37.888 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:47:37.888 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}' 2025-12-02 16:47:37.911 +00:00 [INF] Executed DbCommand (21ms) [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-12-02 16:47:37.912 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 16:47:37.912 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json. 2025-12-02 16:47:37.913 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}' 2025-12-02 16:47:37.913 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/1415 - 200 null application/json; charset=utf-8 24.8244ms 2025-12-02 16:47:42.667 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null 2025-12-02 16:47:42.667 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:47:42.667 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.394ms 2025-12-02 16:47:42.727 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182 2025-12-02 16:47:42.727 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:47:42.727 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd' 2025-12-02 16:47:42.732 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9); 2025-12-02 16:47:42.736 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7); 2025-12-02 16:47:42.737 +00:00 [INF] Setting HTTP status code 201. 2025-12-02 16:47:42.738 +00:00 [INF] Writing value of type 'Int64' as Json. 2025-12-02 16:47:42.738 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd' 2025-12-02 16:47:42.738 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 11.1329ms 2025-12-02 16:47:42.795 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41047 - null null 2025-12-02 16:47:42.795 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:47:42.796 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41047 - 204 null null 0.697ms 2025-12-02 16:47:42.850 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-12-02 16:47:42.850 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:47:42.850 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.5427ms 2025-12-02 16:47:42.860 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41047 - application/json 106 2025-12-02 16:47:42.861 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:47:42.861 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-12-02 16:47:42.865 +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-12-02 16:47:42.907 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-12-02 16:47:42.907 +00:00 [INF] CORS policy execution successful. 2025-12-02 16:47:42.908 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-12-02 16:47:42.909 +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-12-02 16:47:42.910 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 16:47:42.910 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 16:47:42.911 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-12-02 16:47:42.911 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 4.0375ms 2025-12-02 16:47:43.034 +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-12-02 16:47:43.037 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21 OUTPUT 1 WHERE [Id] = @p22; INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35); INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice]) OUTPUT INSERTED.[Id] VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47); 2025-12-02 16:47:43.041 +00:00 [INF] Setting HTTP status code 201. 2025-12-02 16:47:43.041 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-12-02 16:47:43.041 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41047 - 201 0 null 180.497ms 2025-12-02 18:03:27.055 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33/ - null null 2025-12-02 18:03:27.055 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33/ - 404 0 null 0.2929ms 2025-12-02 18:03:27.055 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33/, Response status code: 404 2025-12-02 18:03:29.739 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/favicon.ico - null null 2025-12-02 18:03:29.740 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/favicon.ico - 404 0 null 0.9884ms 2025-12-02 18:03:29.740 +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/favicon.ico, Response status code: 404 2025-12-02 18:17:50.819 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/inmune - null null 2025-12-02 18:17:50.819 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:17:50.819 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/inmune - 204 null null 0.2911ms 2025-12-02 18:17:50.887 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/inmune - null null 2025-12-02 18:17:50.888 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:17:50.888 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 18:17:51.144 +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-12-02 18:17:51.149 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 18:17:51.150 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 18:17:51.150 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 18:17:51.150 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/inmune - 200 null application/json; charset=utf-8 263.0495ms 2025-12-02 18:18:00.015 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - null null 2025-12-02 18:18:00.016 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:18:00.016 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - 204 null null 0.3057ms 2025-12-02 18:18:00.075 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - null null 2025-12-02 18:18:00.075 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:18:00.076 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}' 2025-12-02 18:18:00.076 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}' 2025-12-02 18:18:00.076 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - 400 0 null 0.7583ms 2025-12-02 18:18:04.761 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/4 - null null 2025-12-02 18:18:04.761 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:18:04.762 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/4 - 204 null null 0.2385ms 2025-12-02 18:18:04.824 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/4 - null null 2025-12-02 18:18:04.825 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:18:04.825 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 18:18:04.829 +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-12-02 18:18:04.852 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 18:18:04.852 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 18:18:05.143 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 18:18:05.143 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/4 - 200 null application/json; charset=utf-8 319.1642ms 2025-12-02 18:18:06.804 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/life - null null 2025-12-02 18:18:06.804 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:18:06.804 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/life - 204 null null 0.3768ms 2025-12-02 18:18:06.864 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/life - null null 2025-12-02 18:18:06.864 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:18:06.864 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 18:18:06.867 +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-12-02 18:18:06.871 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 18:18:06.872 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 18:18:06.872 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 18:18:06.873 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/life - 200 null application/json; charset=utf-8 8.7897ms 2025-12-02 18:35:47.197 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null 2025-12-02 18:35:47.197 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:35:47.198 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.2956ms 2025-12-02 18:35:47.249 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 58 2025-12-02 18:35:47.249 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:35:47.249 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin' 2025-12-02 18:35:47.493 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName] FROM [AspNetUsers] AS [a] WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0 2025-12-02 18:35:47.616 +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-12-02 18:35:47.617 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 18:35:47.617 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json. 2025-12-02 18:35:47.618 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin' 2025-12-02 18:35:47.618 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 368.5829ms 2025-12-02 18:35:54.287 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-12-02 18:35:54.288 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:35:54.288 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.3306ms 2025-12-02 18:35:54.338 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-12-02 18:35:54.338 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:35:54.338 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.2812ms 2025-12-02 18:35:54.338 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - null null 2025-12-02 18:35:54.338 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:35:54.338 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - 204 null null 0.1643ms 2025-12-02 18:35:54.355 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-12-02 18:35:54.355 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:35:54.356 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-12-02 18:35:54.371 +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-12-02 18:35:54.371 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 18:35:54.371 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-12-02 18:35:54.372 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-12-02 18:35:54.372 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 16.3335ms 2025-12-02 18:35:54.389 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-12-02 18:35:54.389 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:35:54.389 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-12-02 18:35:54.389 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Products - null null 2025-12-02 18:35:54.390 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:35:54.390 +00:00 [INF] Executing endpoint 'HTTP: GET /products' 2025-12-02 18:35:54.392 +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-12-02 18:35:54.392 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 18:35:54.392 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 18:35:54.392 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-12-02 18:35:54.392 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 2.7889ms 2025-12-02 18:35:54.400 +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) 2025-12-02 18:35:54.588 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 18:35:54.588 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 18:35:55.152 +00:00 [INF] Executed endpoint 'HTTP: GET /products' 2025-12-02 18:35:55.152 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Products - 200 null application/json; charset=utf-8 763.0093ms 2025-12-02 18:36:00.540 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-12-02 18:36:00.540 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:36:00.541 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.3693ms 2025-12-02 18:36:00.540 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductCategory - null null 2025-12-02 18:36:00.541 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:36:00.541 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductCategory - 204 null null 0.7448ms 2025-12-02 18:36:00.541 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1514 - null null 2025-12-02 18:36:00.541 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:36:00.541 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1514 - 204 null null 0.1227ms 2025-12-02 18:36:00.592 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-12-02 18:36:00.592 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:36:00.592 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-12-02 18:36:00.592 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductCategory - null null 2025-12-02 18:36:00.592 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:36:00.593 +00:00 [INF] Executing endpoint 'HTTP: GET ProductCategory/' 2025-12-02 18:36:00.595 +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-12-02 18:36:00.595 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 18:36:00.595 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 18:36:00.595 +00:00 [INF] Executed endpoint 'HTTP: GET ProductCategory/' 2025-12-02 18:36:00.595 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductCategory - 200 null application/json; charset=utf-8 2.9019ms 2025-12-02 18:36:00.597 +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-12-02 18:36:00.597 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 18:36:00.597 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 18:36:00.597 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-12-02 18:36:00.597 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 5.4664ms 2025-12-02 18:36:00.609 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/1514 - null null 2025-12-02 18:36:00.610 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:36:00.611 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}' 2025-12-02 18:36:00.614 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0 2025-12-02 18:36:00.614 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 18:36:00.614 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json. 2025-12-02 18:36:00.614 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}' 2025-12-02 18:36:00.614 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/1514 - 200 null application/json; charset=utf-8 4.8749ms 2025-12-02 18:36:11.549 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1514 - null null 2025-12-02 18:36:11.549 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:36:11.549 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1514 - 204 null null 0.3505ms 2025-12-02 18:36:11.621 +00:00 [INF] Request starting HTTP/1.1 PUT http://159.89.226.33:5227/products/1514 - application/json 23638 2025-12-02 18:36:11.622 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:36:11.622 +00:00 [INF] Executing endpoint 'HTTP: PUT Products/{id}' 2025-12-02 18:36:11.692 +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-12-02 18:36:11.698 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p17='?' (DbType = Int32), @p0='?' (Size = 4000), @p1='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p2='?' (DbType = Int32), @p3='?' (DbType = Guid), @p4='?' (DbType = DateTime2), @p5='?' (DbType = Boolean), @p6='?' (DbType = DateTime2), @p7='?' (DbType = Int32), @p8='?' (Size = 150), @p9='?' (Size = 500), @p10='?' (Size = -1) (DbType = Binary), @p11='?' (DbType = Int32), @p12='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p13='?' (Size = 4000), @p14='?' (DbType = Int32), @p15='?' (DbType = Guid), @p16='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; UPDATE [Products] SET [BarCode] = @p0, [BuyPrice] = @p1, [CategoryId] = @p2, [CreatedById] = @p3, [CreatedDate] = @p4, [DeleteFlag] = @p5, [ExpirationDate] = @p6, [MinimunStock] = @p7, [Name] = @p8, [Note] = @p9, [ProductImage] = @p10, [ProductTaxId] = @p11, [SalePrice] = @p12, [Status] = @p13, [Stock] = @p14, [UpdatedById] = @p15, [UpdatedDate] = @p16 OUTPUT 1 WHERE [Id] = @p17; 2025-12-02 18:36:11.698 +00:00 [INF] Setting HTTP status code 204. 2025-12-02 18:36:11.699 +00:00 [INF] Executed endpoint 'HTTP: PUT Products/{id}' 2025-12-02 18:36:11.699 +00:00 [INF] Request finished HTTP/1.1 PUT http://159.89.226.33:5227/products/1514 - 204 null null 77.4944ms 2025-12-02 18:36:13.787 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-12-02 18:36:13.788 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:36:13.788 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.2879ms 2025-12-02 18:36:13.788 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-12-02 18:36:13.788 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:36:13.788 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.0799ms 2025-12-02 18:36:13.788 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - null null 2025-12-02 18:36:13.788 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:36:13.788 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - 204 null null 0.132ms 2025-12-02 18:36:13.840 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-12-02 18:36:13.840 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:36:13.840 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-12-02 18:36:13.841 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Products - null null 2025-12-02 18:36:13.841 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:36:13.841 +00:00 [INF] Executing endpoint 'HTTP: GET /products' 2025-12-02 18:36:13.843 +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-12-02 18:36:13.843 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 18:36:13.843 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 18:36:13.843 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-12-02 18:36:13.843 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 3.8689ms 2025-12-02 18:36:13.847 +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) 2025-12-02 18:36:13.856 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-12-02 18:36:13.856 +00:00 [INF] CORS policy execution successful. 2025-12-02 18:36:13.856 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-12-02 18:36:13.881 +00:00 [INF] Executed DbCommand (5ms) [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-12-02 18:36:13.882 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 18:36:13.882 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-12-02 18:36:13.882 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-12-02 18:36:13.882 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 26.5468ms 2025-12-02 18:36:14.086 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 18:36:14.086 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 18:36:14.626 +00:00 [INF] Executed endpoint 'HTTP: GET /products' 2025-12-02 18:36:14.627 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Products - 200 null application/json; charset=utf-8 786.2948ms 2025-12-02 21:48:07.638 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null 2025-12-02 21:48:07.638 +00:00 [INF] CORS policy execution successful. 2025-12-02 21:48:07.638 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.2371ms 2025-12-02 21:48:07.708 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 61 2025-12-02 21:48:07.708 +00:00 [INF] CORS policy execution successful. 2025-12-02 21:48:07.709 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin' 2025-12-02 21:48:07.952 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName] FROM [AspNetUsers] AS [a] WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0 2025-12-02 21:48:08.062 +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-12-02 21:48:08.062 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 21:48:08.062 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json. 2025-12-02 21:48:08.062 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin' 2025-12-02 21:48:08.062 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 354.0577ms 2025-12-02 21:48:11.521 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-12-02 21:48:11.521 +00:00 [INF] CORS policy execution successful. 2025-12-02 21:48:11.521 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2725ms 2025-12-02 21:48:11.576 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-12-02 21:48:11.576 +00:00 [INF] CORS policy execution successful. 2025-12-02 21:48:11.576 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.2982ms 2025-12-02 21:48:11.577 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-12-02 21:48:11.578 +00:00 [INF] CORS policy execution successful. 2025-12-02 21:48:11.578 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-12-02 21:48:11.577 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-12-02 21:48:11.578 +00:00 [INF] CORS policy execution successful. 2025-12-02 21:48:11.578 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.8684ms 2025-12-02 21:48:11.579 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null 2025-12-02 21:48:11.579 +00:00 [INF] CORS policy execution successful. 2025-12-02 21:48:11.579 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.0975ms 2025-12-02 21:48:11.599 +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-12-02 21:48:11.599 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 21:48:11.599 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 21:48:11.599 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-12-02 21:48:11.599 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 22.0453ms 2025-12-02 21:48:11.631 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-12-02 21:48:11.631 +00:00 [INF] CORS policy execution successful. 2025-12-02 21:48:11.632 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-12-02 21:48:11.634 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [ProductTaxes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-12-02 21:48:11.635 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null 2025-12-02 21:48:11.635 +00:00 [INF] CORS policy execution successful. 2025-12-02 21:48:11.635 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 21:48:11.635 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities' 2025-12-02 21:48:11.635 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 21:48:11.636 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-12-02 21:48:11.636 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 4.7961ms 2025-12-02 21:48:11.638 +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-12-02 21:48:11.638 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-12-02 21:48:11.638 +00:00 [INF] CORS policy execution successful. 2025-12-02 21:48:11.639 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-12-02 21:48:11.639 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 21:48:11.640 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 21:48:11.640 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities' 2025-12-02 21:48:11.640 +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-12-02 21:48:11.641 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 5.8687ms 2025-12-02 21:48:11.641 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 21:48:11.641 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-12-02 21:48:11.641 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-12-02 21:48:11.641 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 3.6299ms 2025-12-02 21:48:16.497 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/amarilis - null null 2025-12-02 21:48:16.497 +00:00 [INF] CORS policy execution successful. 2025-12-02 21:48:16.497 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/amarilis - 204 null null 0.2438ms 2025-12-02 21:48:16.567 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/amarilis - null null 2025-12-02 21:48:16.567 +00:00 [INF] CORS policy execution successful. 2025-12-02 21:48:16.567 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 21:48:16.570 +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-12-02 21:48:16.574 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 21:48:16.574 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 21:48:16.693 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 21:48:16.694 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/amarilis - 200 null application/json; charset=utf-8 127.2519ms 2025-12-02 22:12:22.732 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-12-02 22:12:22.732 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:12:22.733 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3052ms 2025-12-02 22:12:22.793 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-12-02 22:12:22.794 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:12:22.794 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-12-02 22:12:23.044 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-12-02 22:12:23.044 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 22:12:23.044 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 22:12:23.044 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-12-02 22:12:23.045 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 251.1205ms 2025-12-02 22:12:27.302 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/vit - null null 2025-12-02 22:12:27.303 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:12:27.303 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/vit - 204 null null 0.219ms 2025-12-02 22:12:27.363 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/vit - null null 2025-12-02 22:12:27.363 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:12:27.363 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 22:12:27.366 +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-12-02 22:12:27.378 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 22:12:27.378 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 22:12:27.662 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 22:12:27.663 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/vit - 200 null application/json; charset=utf-8 300.0819ms 2025-12-02 22:12:35.461 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/gin - null null 2025-12-02 22:12:35.461 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:12:35.462 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/gin - 204 null null 0.4562ms 2025-12-02 22:12:35.521 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/gin - null null 2025-12-02 22:12:35.521 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:12:35.522 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 22:12:35.524 +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-12-02 22:12:35.532 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 22:12:35.532 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 22:12:35.532 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 22:12:35.533 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/gin - 200 null application/json; charset=utf-8 11.509ms 2025-12-02 22:13:15.683 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/aceite - null null 2025-12-02 22:13:15.683 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:13:15.684 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/aceite - 204 null null 0.294ms 2025-12-02 22:13:15.743 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/aceite - null null 2025-12-02 22:13:15.744 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:13:15.744 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 22:13:15.746 +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-12-02 22:13:15.763 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 22:13:15.764 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 22:13:15.773 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 22:13:15.774 +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 30.3099ms 2025-12-02 22:13:58.473 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/alcachofa - null null 2025-12-02 22:13:58.474 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:13:58.474 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/alcachofa - 204 null null 0.2577ms 2025-12-02 22:13:58.533 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/alcachofa - null null 2025-12-02 22:13:58.533 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:13:58.534 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 22:13:58.536 +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-12-02 22:13:58.540 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 22:13:58.540 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 22:13:58.540 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 22:13:58.540 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/alcachofa - 200 null application/json; charset=utf-8 7.1085ms 2025-12-02 22:14:15.592 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/omega - null null 2025-12-02 22:14:15.592 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:14:15.593 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/omega - 204 null null 0.2517ms 2025-12-02 22:14:15.653 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/omega - null null 2025-12-02 22:14:15.653 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:14:15.653 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 22:14:15.656 +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-12-02 22:14:15.661 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 22:14:15.662 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 22:14:15.662 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 22:14:15.662 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/omega - 200 null application/json; charset=utf-8 9.8272ms 2025-12-02 22:14:57.982 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/vitamina c - null null 2025-12-02 22:14:57.982 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:14:57.982 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/vitamina c - 204 null null 0.291ms 2025-12-02 22:14:58.040 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/vitamina c - null null 2025-12-02 22:14:58.040 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:14:58.041 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 22:14:58.044 +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-12-02 22:14:58.051 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 22:14:58.051 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 22:14:58.051 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 22:14:58.051 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/vitamina c - 200 null application/json; charset=utf-8 11.3183ms 2025-12-02 22:17:21.469 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null 2025-12-02 22:17:21.469 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:17:21.469 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3003ms 2025-12-02 22:17:21.529 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 191 2025-12-02 22:17:21.529 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:17:21.530 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd' 2025-12-02 22:17:21.534 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9); 2025-12-02 22:17:21.538 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7); 2025-12-02 22:17:21.538 +00:00 [INF] Setting HTTP status code 201. 2025-12-02 22:17:21.538 +00:00 [INF] Writing value of type 'Int64' as Json. 2025-12-02 22:17:21.538 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd' 2025-12-02 22:17:21.538 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 9.1728ms 2025-12-02 22:17:21.599 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41048 - null null 2025-12-02 22:17:21.599 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:17:21.599 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41048 - 204 null null 0.3063ms 2025-12-02 22:17:21.656 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-12-02 22:17:21.656 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:17:21.656 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3134ms 2025-12-02 22:17:21.657 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41048 - application/json 518 2025-12-02 22:17:21.657 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:17:21.658 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-12-02 22:17:21.660 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-12-02 22:17:21.712 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-12-02 22:17:21.713 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:17:21.713 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-12-02 22:17:21.753 +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-12-02 22:17:21.753 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 22:17:21.754 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 22:17:21.754 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-12-02 22:17:21.754 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 41.4889ms 2025-12-02 22:17:21.894 +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-12-02 22:17:21.905 +00:00 [INF] Executed DbCommand (10ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p40='?' (DbType = Int32), @p23='?' (Size = 4000), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Int32), @p26='?' (DbType = Guid), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Boolean), @p29='?' (DbType = DateTime2), @p30='?' (DbType = Int32), @p31='?' (Size = 150), @p32='?' (Size = 500), @p33='?' (Size = -1) (DbType = Binary), @p34='?' (DbType = Int32), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p36='?' (Size = 4000), @p37='?' (DbType = Int32), @p38='?' (DbType = Guid), @p39='?' (DbType = DateTime2), @p58='?' (DbType = Int32), @p41='?' (Size = 4000), @p42='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p43='?' (DbType = Int32), @p44='?' (DbType = Guid), @p45='?' (DbType = DateTime2), @p46='?' (DbType = Boolean), @p47='?' (DbType = DateTime2), @p48='?' (DbType = Int32), @p49='?' (Size = 150), @p50='?' (Size = 500), @p51='?' (Size = -1) (DbType = Binary), @p52='?' (DbType = Int32), @p53='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p54='?' (Size = 4000), @p55='?' (DbType = Int32), @p56='?' (DbType = Guid), @p57='?' (DbType = DateTime2), @p76='?' (DbType = Int32), @p59='?' (Size = 4000), @p60='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p61='?' (DbType = Int32), @p62='?' (DbType = Guid), @p63='?' (DbType = DateTime2), @p64='?' (DbType = Boolean), @p65='?' (DbType = DateTime2), @p66='?' (DbType = Int32), @p67='?' (Size = 150), @p68='?' (Size = 500), @p69='?' (Size = -1) (DbType = Binary), @p70='?' (DbType = Int32), @p71='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p72='?' (Size = 4000), @p73='?' (DbType = Int32), @p74='?' (DbType = Guid), @p75='?' (DbType = DateTime2), @p94='?' (DbType = Int32), @p77='?' (Size = 4000), @p78='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p79='?' (DbType = Int32), @p80='?' (DbType = Guid), @p81='?' (DbType = DateTime2), @p82='?' (DbType = Boolean), @p83='?' (DbType = DateTime2), @p84='?' (DbType = Int32), @p85='?' (Size = 150), @p86='?' (Size = 500), @p87='?' (Size = -1) (DbType = Binary), @p88='?' (DbType = Int32), @p89='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p90='?' (Size = 4000), @p91='?' (DbType = Int32), @p92='?' (DbType = Guid), @p93='?' (DbType = DateTime2), @p95='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p96='?' (DbType = Guid), @p97='?' (DbType = DateTime2), @p98='?' (DbType = Boolean), @p99='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p100='?' (DbType = Int32), @p101='?' (DbType = Int32), @p102='?' (DbType = Int64), @p103='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p104='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p105='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p106='?' (DbType = Guid), @p107='?' (DbType = DateTime2), @p108='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p109='?' (DbType = Guid), @p110='?' (DbType = DateTime2), @p111='?' (DbType = Boolean), @p112='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p113='?' (DbType = Int32), @p114='?' (DbType = Int32), @p115='?' (DbType = Int64), @p116='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p117='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p118='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p119='?' (DbType = Guid), @p120='?' (DbType = DateTime2), @p121='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p122='?' (DbType = Guid), @p123='?' (DbType = DateTime2), @p124='?' (DbType = Boolean), @p125='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p126='?' (DbType = Int32), @p127='?' (DbType = Int32), @p128='?' (DbType = Int64), @p129='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p130='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p131='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p132='?' (DbType = Guid), @p133='?' (DbType = DateTime2), @p134='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p135='?' (DbType = Guid), @p136='?' (DbType = DateTime2), @p137='?' (DbType = Boolean), @p138='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p139='?' (DbType = Int32), @p140='?' (DbType = Int32), @p141='?' (DbType = Int64), @p142='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p143='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p144='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p145='?' (DbType = Guid), @p146='?' (DbType = DateTime2), @p147='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p148='?' (DbType = Guid), @p149='?' (DbType = DateTime2), @p150='?' (DbType = Boolean), @p151='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p152='?' (DbType = Int32), @p153='?' (DbType = Int32), @p154='?' (DbType = Int64), @p155='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p156='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p157='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p158='?' (DbType = Guid), @p159='?' (DbType = DateTime2), @p160='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p161='?' (DbType = Guid), @p162='?' (DbType = DateTime2), @p163='?' (DbType = Int32), @p164='?' (Size = 34), @p165='?' (DbType = Guid), @p166='?' (DbType = Int32), @p167='?' (DbType = Int32), @p168='?' (DbType = Int32), @p169='?' (Size = 4000), @p170='?' (Size = 4000), @p171='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p172='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p173='?' (DbType = Guid), @p174='?' (DbType = DateTime2), @p175='?' (DbType = Int32), @p176='?' (Size = 34), @p177='?' (DbType = Guid), @p178='?' (DbType = Int32), @p179='?' (DbType = Int32), @p180='?' (DbType = Int32), @p181='?' (Size = 4000), @p182='?' (Size = 4000), @p183='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p184='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p185='?' (DbType = Guid), @p186='?' (DbType = DateTime2), @p187='?' (DbType = Int32), @p188='?' (Size = 34), @p189='?' (DbType = Guid), @p190='?' (DbType = Int32), @p191='?' (DbType = Int32), @p192='?' (DbType = Int32), @p193='?' (Size = 4000), @p194='?' (Size = 4000), @p195='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p196='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p197='?' (DbType = Guid), @p198='?' (DbType = DateTime2), @p199='?' (DbType = Int32), @p200='?' (Size = 34), @p201='?' (DbType = Guid), @p202='?' (DbType = Int32), @p203='?' (DbType = Int32), @p204='?' (DbType = Int32), @p205='?' (Size = 4000), @p206='?' (Size = 4000), @p207='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p208='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p209='?' (DbType = Guid), @p210='?' (DbType = DateTime2), @p211='?' (DbType = Int32), @p212='?' (Size = 34), @p213='?' (DbType = Guid), @p214='?' (DbType = Int32), @p215='?' (DbType = Int32), @p216='?' (DbType = Int32), @p217='?' (Size = 4000), @p218='?' (Size = 4000), @p219='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21 OUTPUT 1 WHERE [Id] = @p22; UPDATE [Products] SET [BarCode] = @p23, [BuyPrice] = @p24, [CategoryId] = @p25, [CreatedById] = @p26, [CreatedDate] = @p27, [DeleteFlag] = @p28, [ExpirationDate] = @p29, [MinimunStock] = @p30, [Name] = @p31, [Note] = @p32, [ProductImage] = @p33, [ProductTaxId] = @p34, [SalePrice] = @p35, [Status] = @p36, [Stock] = @p37, [UpdatedById] = @p38, [UpdatedDate] = @p39 OUTPUT 1 WHERE [Id] = @p40; UPDATE [Products] SET [BarCode] = @p41, [BuyPrice] = @p42, [CategoryId] = @p43, [CreatedById] = @p44, [CreatedDate] = @p45, [DeleteFlag] = @p46, [ExpirationDate] = @p47, [MinimunStock] = @p48, [Name] = @p49, [Note] = @p50, [ProductImage] = @p51, [ProductTaxId] = @p52, [SalePrice] = @p53, [Status] = @p54, [Stock] = @p55, [UpdatedById] = @p56, [UpdatedDate] = @p57 OUTPUT 1 WHERE [Id] = @p58; UPDATE [Products] SET [BarCode] = @p59, [BuyPrice] = @p60, [CategoryId] = @p61, [CreatedById] = @p62, [CreatedDate] = @p63, [DeleteFlag] = @p64, [ExpirationDate] = @p65, [MinimunStock] = @p66, [Name] = @p67, [Note] = @p68, [ProductImage] = @p69, [ProductTaxId] = @p70, [SalePrice] = @p71, [Status] = @p72, [Stock] = @p73, [UpdatedById] = @p74, [UpdatedDate] = @p75 OUTPUT 1 WHERE [Id] = @p76; UPDATE [Products] SET [BarCode] = @p77, [BuyPrice] = @p78, [CategoryId] = @p79, [CreatedById] = @p80, [CreatedDate] = @p81, [DeleteFlag] = @p82, [ExpirationDate] = @p83, [MinimunStock] = @p84, [Name] = @p85, [Note] = @p86, [ProductImage] = @p87, [ProductTaxId] = @p88, [SalePrice] = @p89, [Status] = @p90, [Stock] = @p91, [UpdatedById] = @p92, [UpdatedDate] = @p93 OUTPUT 1 WHERE [Id] = @p94; MERGE [SalesDetail] USING ( VALUES (@p95, @p96, @p97, @p98, @p99, @p100, @p101, @p102, @p103, @p104, @p105, @p106, @p107, 0), (@p108, @p109, @p110, @p111, @p112, @p113, @p114, @p115, @p116, @p117, @p118, @p119, @p120, 1), (@p121, @p122, @p123, @p124, @p125, @p126, @p127, @p128, @p129, @p130, @p131, @p132, @p133, 2), (@p134, @p135, @p136, @p137, @p138, @p139, @p140, @p141, @p142, @p143, @p144, @p145, @p146, 3), (@p147, @p148, @p149, @p150, @p151, @p152, @p153, @p154, @p155, @p156, @p157, @p158, @p159, 4)) 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 (@p160, @p161, @p162, @p163, @p164, @p165, @p166, @p167, @p168, @p169, @p170, @p171, 0), (@p172, @p173, @p174, @p175, @p176, @p177, @p178, @p179, @p180, @p181, @p182, @p183, 1), (@p184, @p185, @p186, @p187, @p188, @p189, @p190, @p191, @p192, @p193, @p194, @p195, 2), (@p196, @p197, @p198, @p199, @p200, @p201, @p202, @p203, @p204, @p205, @p206, @p207, 3), (@p208, @p209, @p210, @p211, @p212, @p213, @p214, @p215, @p216, @p217, @p218, @p219, 4)) 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-12-02 22:17:21.913 +00:00 [INF] Setting HTTP status code 201. 2025-12-02 22:17:21.913 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-12-02 22:17:21.913 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41048 - 201 0 null 255.9563ms 2025-12-02 22:28:01.275 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - null null 2025-12-02 22:28:01.275 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:28:01.275 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - 204 null null 0.4497ms 2025-12-02 22:28:01.341 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan - null null 2025-12-02 22:28:01.341 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:28:01.342 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 22:28:01.586 +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-12-02 22:28:01.594 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 22:28:01.595 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 22:28:01.706 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 22:28:01.706 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan - 200 null application/json; charset=utf-8 364.8818ms 2025-12-02 22:28:15.459 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/kel - null null 2025-12-02 22:28:15.459 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:28:15.459 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/kel - 204 null null 0.3508ms 2025-12-02 22:28:15.522 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/kel - null null 2025-12-02 22:28:15.522 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:28:15.523 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 22:28:15.525 +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-12-02 22:28:15.528 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 22:28:15.528 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 22:28:15.529 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 22:28:15.529 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/kel - 200 null application/json; charset=utf-8 6.8306ms 2025-12-02 22:28:16.500 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - null null 2025-12-02 22:28:16.501 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:28:16.502 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - 204 null null 1.3395ms 2025-12-02 22:28:16.568 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - null null 2025-12-02 22:28:16.568 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:28:16.568 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}' 2025-12-02 22:28:16.568 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}' 2025-12-02 22:28:16.568 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - 400 0 null 0.49ms 2025-12-02 22:28:20.347 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ke - null null 2025-12-02 22:28:20.348 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:28:20.348 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ke - 204 null null 1.0037ms 2025-12-02 22:28:20.407 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ke - null null 2025-12-02 22:28:20.407 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:28:20.407 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 22:28:20.410 +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-12-02 22:28:20.413 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 22:28:20.414 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 22:28:20.414 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 22:28:20.414 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ke - 200 null application/json; charset=utf-8 7.617ms 2025-12-02 22:30:31.913 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null 2025-12-02 22:30:31.913 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:30:31.913 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.389ms 2025-12-02 22:30:31.969 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 188 2025-12-02 22:30:31.969 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:30:31.970 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd' 2025-12-02 22:30:31.974 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9); 2025-12-02 22:30:31.977 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7); 2025-12-02 22:30:31.977 +00:00 [INF] Setting HTTP status code 201. 2025-12-02 22:30:31.978 +00:00 [INF] Writing value of type 'Int64' as Json. 2025-12-02 22:30:31.978 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd' 2025-12-02 22:30:31.978 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 8.5919ms 2025-12-02 22:30:32.039 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41049 - null null 2025-12-02 22:30:32.040 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:30:32.040 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41049 - 204 null null 0.6198ms 2025-12-02 22:30:32.093 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-12-02 22:30:32.093 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:30:32.093 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.6963ms 2025-12-02 22:30:32.104 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41049 - application/json 213 2025-12-02 22:30:32.104 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:30:32.104 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-12-02 22:30:32.106 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-12-02 22:30:32.146 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-12-02 22:30:32.147 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:30:32.147 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-12-02 22:30:32.165 +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-12-02 22:30:32.166 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 22:30:32.166 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 22:30:32.166 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-12-02 22:30:32.166 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 20.1795ms 2025-12-02 22:30:32.238 +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-12-02 22:30:32.243 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p40='?' (DbType = Int32), @p23='?' (Size = 4000), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Int32), @p26='?' (DbType = Guid), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Boolean), @p29='?' (DbType = DateTime2), @p30='?' (DbType = Int32), @p31='?' (Size = 150), @p32='?' (Size = 500), @p33='?' (Size = -1) (DbType = Binary), @p34='?' (DbType = Int32), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p36='?' (Size = 4000), @p37='?' (DbType = Int32), @p38='?' (DbType = Guid), @p39='?' (DbType = DateTime2), @p41='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p42='?' (DbType = Guid), @p43='?' (DbType = DateTime2), @p44='?' (DbType = Boolean), @p45='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p46='?' (DbType = Int32), @p47='?' (DbType = Int32), @p48='?' (DbType = Int64), @p49='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p50='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p51='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p52='?' (DbType = Guid), @p53='?' (DbType = DateTime2), @p54='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p55='?' (DbType = Guid), @p56='?' (DbType = DateTime2), @p57='?' (DbType = Boolean), @p58='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p59='?' (DbType = Int32), @p60='?' (DbType = Int32), @p61='?' (DbType = Int64), @p62='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p63='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p64='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p65='?' (DbType = Guid), @p66='?' (DbType = DateTime2), @p67='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p68='?' (DbType = Guid), @p69='?' (DbType = DateTime2), @p70='?' (DbType = Int32), @p71='?' (Size = 34), @p72='?' (DbType = Guid), @p73='?' (DbType = Int32), @p74='?' (DbType = Int32), @p75='?' (DbType = Int32), @p76='?' (Size = 4000), @p77='?' (Size = 4000), @p78='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p79='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p80='?' (DbType = Guid), @p81='?' (DbType = DateTime2), @p82='?' (DbType = Int32), @p83='?' (Size = 34), @p84='?' (DbType = Guid), @p85='?' (DbType = Int32), @p86='?' (DbType = Int32), @p87='?' (DbType = Int32), @p88='?' (Size = 4000), @p89='?' (Size = 4000), @p90='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21 OUTPUT 1 WHERE [Id] = @p22; UPDATE [Products] SET [BarCode] = @p23, [BuyPrice] = @p24, [CategoryId] = @p25, [CreatedById] = @p26, [CreatedDate] = @p27, [DeleteFlag] = @p28, [ExpirationDate] = @p29, [MinimunStock] = @p30, [Name] = @p31, [Note] = @p32, [ProductImage] = @p33, [ProductTaxId] = @p34, [SalePrice] = @p35, [Status] = @p36, [Stock] = @p37, [UpdatedById] = @p38, [UpdatedDate] = @p39 OUTPUT 1 WHERE [Id] = @p40; MERGE [SalesDetail] USING ( VALUES (@p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52, @p53, 0), (@p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62, @p63, @p64, @p65, @p66, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate], _Position) ON 1=0 WHEN NOT MATCHED THEN INSERT ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate]) VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[DeleteFlag], i.[DiscountAmount], i.[ProductId], i.[Quantity], i.[SalesId], i.[Tax], i.[Total], i.[UnitPrice], i.[UpdatedById], i.[UpdatedDate]) OUTPUT INSERTED.[Id], i._Position; MERGE [InventoryMovements] USING ( VALUES (@p67, @p68, @p69, @p70, @p71, @p72, @p73, @p74, @p75, @p76, @p77, @p78, 0), (@p79, @p80, @p81, @p82, @p83, @p84, @p85, @p86, @p87, @p88, @p89, @p90, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice], _Position) ON 1=0 WHEN NOT MATCHED THEN INSERT ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice]) VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[Difference], i.[Discriminator], i.[InventoryMovementHeaderId], i.[NewStock], i.[OriginaStock], i.[ProductId], i.[ProductName], i.[Reazon], i.[SalePrice]) OUTPUT INSERTED.[Id], i._Position; 2025-12-02 22:30:32.247 +00:00 [INF] Setting HTTP status code 201. 2025-12-02 22:30:32.248 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-12-02 22:30:32.248 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41049 - 201 0 null 144.1241ms 2025-12-02 22:32:26.054 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-12-02 22:32:26.055 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:32:26.055 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.5581ms 2025-12-02 22:32:26.115 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-12-02 22:32:26.115 +00:00 [INF] CORS policy execution successful. 2025-12-02 22:32:26.116 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-12-02 22:32:26.121 +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-12-02 22:32:26.121 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 22:32:26.121 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 22:32:26.122 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-12-02 22:32:26.122 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 6.3486ms 2025-12-02 23:39:48.379 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/daniel - null null 2025-12-02 23:39:48.379 +00:00 [INF] CORS policy execution successful. 2025-12-02 23:39:48.379 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/daniel - 204 null null 0.3984ms 2025-12-02 23:39:48.475 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/daniel - null null 2025-12-02 23:39:48.475 +00:00 [INF] CORS policy execution successful. 2025-12-02 23:39:48.475 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 23:39:48.715 +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-12-02 23:39:48.724 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 23:39:48.724 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 23:39:48.839 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 23:39:48.840 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/daniel - 200 null application/json; charset=utf-8 364.8027ms 2025-12-02 23:40:03.249 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null 2025-12-02 23:40:03.249 +00:00 [INF] CORS policy execution successful. 2025-12-02 23:40:03.249 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3826ms 2025-12-02 23:40:03.310 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182 2025-12-02 23:40:03.311 +00:00 [INF] CORS policy execution successful. 2025-12-02 23:40:03.311 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd' 2025-12-02 23:40:03.318 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9); 2025-12-02 23:40:03.324 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7); 2025-12-02 23:40:03.332 +00:00 [INF] Setting HTTP status code 201. 2025-12-02 23:40:03.332 +00:00 [INF] Writing value of type 'Int64' as Json. 2025-12-02 23:40:03.332 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd' 2025-12-02 23:40:03.332 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 22.6828ms 2025-12-02 23:40:03.396 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41050 - null null 2025-12-02 23:40:03.397 +00:00 [INF] CORS policy execution successful. 2025-12-02 23:40:03.397 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41050 - 204 null null 0.3811ms 2025-12-02 23:40:03.408 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-12-02 23:40:03.408 +00:00 [INF] CORS policy execution successful. 2025-12-02 23:40:03.408 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2692ms 2025-12-02 23:40:03.457 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41050 - application/json 106 2025-12-02 23:40:03.457 +00:00 [INF] CORS policy execution successful. 2025-12-02 23:40:03.457 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-12-02 23:40:03.460 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-12-02 23:40:03.466 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-12-02 23:40:03.467 +00:00 [INF] CORS policy execution successful. 2025-12-02 23:40:03.467 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-12-02 23:40:03.487 +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-12-02 23:40:03.488 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 23:40:03.488 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 23:40:03.488 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-12-02 23:40:03.488 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 21.5293ms 2025-12-02 23:40:03.685 +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-12-02 23:40:03.688 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21 OUTPUT 1 WHERE [Id] = @p22; INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35); INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice]) OUTPUT INSERTED.[Id] VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47); 2025-12-02 23:40:03.694 +00:00 [INF] Setting HTTP status code 201. 2025-12-02 23:40:03.694 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-12-02 23:40:03.694 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41050 - 201 0 null 237.7443ms 2025-12-02 23:41:27.103 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/amarilis - null null 2025-12-02 23:41:27.104 +00:00 [INF] CORS policy execution successful. 2025-12-02 23:41:27.104 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/amarilis - 204 null null 0.4506ms 2025-12-02 23:41:27.161 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/amarilis - null null 2025-12-02 23:41:27.161 +00:00 [INF] CORS policy execution successful. 2025-12-02 23:41:27.162 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 23:41:27.164 +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-12-02 23:41:27.169 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 23:41:27.169 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 23:41:27.169 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 23:41:27.169 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/amarilis - 200 null application/json; charset=utf-8 8.4909ms 2025-12-02 23:43:33.192 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null 2025-12-02 23:43:33.192 +00:00 [INF] CORS policy execution successful. 2025-12-02 23:43:33.192 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3041ms 2025-12-02 23:43:33.261 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182 2025-12-02 23:43:33.261 +00:00 [INF] CORS policy execution successful. 2025-12-02 23:43:33.262 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd' 2025-12-02 23:43:33.267 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9); 2025-12-02 23:43:33.272 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7); 2025-12-02 23:43:33.273 +00:00 [INF] Setting HTTP status code 201. 2025-12-02 23:43:33.273 +00:00 [INF] Writing value of type 'Int64' as Json. 2025-12-02 23:43:33.274 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd' 2025-12-02 23:43:33.274 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 12.8856ms 2025-12-02 23:43:33.341 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41051 - null null 2025-12-02 23:43:33.341 +00:00 [INF] CORS policy execution successful. 2025-12-02 23:43:33.341 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41051 - 204 null null 0.695ms 2025-12-02 23:43:33.401 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-12-02 23:43:33.402 +00:00 [INF] CORS policy execution successful. 2025-12-02 23:43:33.402 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 1.0587ms 2025-12-02 23:43:33.404 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41051 - application/json 105 2025-12-02 23:43:33.405 +00:00 [INF] CORS policy execution successful. 2025-12-02 23:43:33.405 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-12-02 23:43:33.408 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-12-02 23:43:33.461 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-12-02 23:43:33.462 +00:00 [INF] CORS policy execution successful. 2025-12-02 23:43:33.463 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-12-02 23:43:33.465 +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-12-02 23:43:33.466 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 23:43:33.466 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 23:43:33.466 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-12-02 23:43:33.467 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 5.203ms 2025-12-02 23:43:33.603 +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-12-02 23:43:33.606 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21 OUTPUT 1 WHERE [Id] = @p22; INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35); INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice]) OUTPUT INSERTED.[Id] VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47); 2025-12-02 23:43:33.611 +00:00 [INF] Setting HTTP status code 201. 2025-12-02 23:43:33.611 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-12-02 23:43:33.611 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41051 - 201 0 null 206.6567ms 2025-12-02 23:44:12.756 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/amar - null null 2025-12-02 23:44:12.756 +00:00 [INF] CORS policy execution successful. 2025-12-02 23:44:12.756 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/amar - 204 null null 0.3018ms 2025-12-02 23:44:12.812 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/amar - null null 2025-12-02 23:44:12.812 +00:00 [INF] CORS policy execution successful. 2025-12-02 23:44:12.813 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 23:44:12.816 +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-12-02 23:44:12.821 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 23:44:12.821 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 23:44:12.928 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-12-02 23:44:12.928 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/amar - 200 null application/json; charset=utf-8 115.7674ms 2025-12-02 23:44:50.095 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null 2025-12-02 23:44:50.095 +00:00 [INF] CORS policy execution successful. 2025-12-02 23:44:50.095 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.366ms 2025-12-02 23:44:50.154 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182 2025-12-02 23:44:50.154 +00:00 [INF] CORS policy execution successful. 2025-12-02 23:44:50.154 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd' 2025-12-02 23:44:50.159 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9); 2025-12-02 23:44:50.162 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7); 2025-12-02 23:44:50.163 +00:00 [INF] Setting HTTP status code 201. 2025-12-02 23:44:50.163 +00:00 [INF] Writing value of type 'Int64' as Json. 2025-12-02 23:44:50.163 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd' 2025-12-02 23:44:50.163 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 9.0375ms 2025-12-02 23:44:50.224 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41052 - null null 2025-12-02 23:44:50.224 +00:00 [INF] CORS policy execution successful. 2025-12-02 23:44:50.224 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41052 - 204 null null 0.3355ms 2025-12-02 23:44:50.228 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-12-02 23:44:50.228 +00:00 [INF] CORS policy execution successful. 2025-12-02 23:44:50.228 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2985ms 2025-12-02 23:44:50.278 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41052 - application/json 105 2025-12-02 23:44:50.278 +00:00 [INF] CORS policy execution successful. 2025-12-02 23:44:50.279 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-12-02 23:44:50.281 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-12-02 23:44:50.284 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-12-02 23:44:50.284 +00:00 [INF] CORS policy execution successful. 2025-12-02 23:44:50.284 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-12-02 23:44:50.286 +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-12-02 23:44:50.286 +00:00 [INF] Setting HTTP status code 200. 2025-12-02 23:44:50.286 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-12-02 23:44:50.287 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-12-02 23:44:50.287 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 2.5272ms 2025-12-02 23:44:50.434 +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-12-02 23:44:50.437 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21 OUTPUT 1 WHERE [Id] = @p22; INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35); INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice]) OUTPUT INSERTED.[Id] VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47); 2025-12-02 23:44:50.440 +00:00 [INF] Setting HTTP status code 201. 2025-12-02 23:44:50.440 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-12-02 23:44:50.440 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41052 - 201 0 null 162.0038ms