2026-01-09 04:08:11.201 +00:00 [INF] Request starting HTTP/1.0 GET http:/// - null null
2026-01-09 04:08:11.204 +00:00 [INF] Request finished HTTP/1.0 GET http:/// - 404 0 null 3.013ms
2026-01-09 04:08:11.204 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http:///, Response status code: 404
2026-01-09 09:00:45.198 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2026-01-09 09:00:45.199 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 1.8434ms
2026-01-09 09:00:45.199 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404
2026-01-09 09:01:30.162 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/robots.txt - null null
2026-01-09 09:01:30.162 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/robots.txt - 404 0 null 0.4179ms
2026-01-09 09:01:30.162 +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/robots.txt, Response status code: 404
2026-01-09 09:04:01.770 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2026-01-09 09:04:01.771 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 1.2539ms
2026-01-09 09:04:01.771 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404
2026-01-09 09:04:13.561 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2026-01-09 09:04:13.561 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.2741ms
2026-01-09 09:04:13.561 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404
2026-01-09 09:04:20.769 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/login - null null
2026-01-09 09:04:20.769 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/login - 404 0 null 0.3304ms
2026-01-09 09:04:20.769 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/login, Response status code: 404
2026-01-09 13:04:40.904 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null
2026-01-09 13:04:40.904 +00:00 [INF] CORS policy execution successful.
2026-01-09 13:04:40.904 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.4728ms
2026-01-09 13:04:40.974 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 65
2026-01-09 13:04:40.974 +00:00 [INF] CORS policy execution successful.
2026-01-09 13:04:40.974 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin'
2026-01-09 13:04:41.325 +00:00 [INF] Executed DbCommand (8ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName]
FROM [AspNetUsers] AS [a]
WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0
2026-01-09 13:04:41.500 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__userId_0='?' (Size = 450)], CommandType='"Text"', CommandTimeout='30']
SELECT [a0].[Name]
FROM [AspNetUserRoles] AS [a]
INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id]
WHERE [a].[UserId] = @__userId_0
2026-01-09 13:04:41.502 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 13:04:41.502 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json.
2026-01-09 13:04:41.502 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin'
2026-01-09 13:04:41.503 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 529.0494ms
2026-01-09 13:27:40.454 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2026-01-09 13:27:40.454 +00:00 [INF] CORS policy execution successful.
2026-01-09 13:27:40.454 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.3793ms
2026-01-09 13:27:40.454 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null
2026-01-09 13:27:40.454 +00:00 [INF] CORS policy execution successful.
2026-01-09 13:27:40.454 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.0712ms
2026-01-09 13:27:40.454 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-09 13:27:40.454 +00:00 [INF] CORS policy execution successful.
2026-01-09 13:27:40.454 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.8576ms
2026-01-09 13:27:40.458 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null
2026-01-09 13:27:40.459 +00:00 [INF] CORS policy execution successful.
2026-01-09 13:27:40.459 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.2814ms
2026-01-09 13:27:40.509 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null
2026-01-09 13:27:40.509 +00:00 [INF] CORS policy execution successful.
2026-01-09 13:27:40.510 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-09 13:27:40.510 +00:00 [INF] CORS policy execution successful.
2026-01-09 13:27:40.510 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/'
2026-01-09 13:27:40.510 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-09 13:27:40.512 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2026-01-09 13:27:40.512 +00:00 [INF] CORS policy execution successful.
2026-01-09 13:27:40.512 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2026-01-09 13:27:40.518 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null
2026-01-09 13:27:40.519 +00:00 [INF] CORS policy execution successful.
2026-01-09 13:27:40.519 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities'
2026-01-09 13:27:40.752 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 13:27:40.752 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 13:27:40.752 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 13:27:40.752 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-09 13:27:40.752 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 242.8106ms
2026-01-09 13:27:40.762 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate]
FROM [Settings] AS [s]
2026-01-09 13:27:40.762 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 13:27:40.762 +00:00 [INF] Writing value of type 'SettingDto' as Json.
2026-01-09 13:27:40.762 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/'
2026-01-09 13:27:40.762 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 253.3542ms
2026-01-09 13:27:40.764 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [ProductTaxes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 13:27:40.765 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 13:27:40.765 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 13:27:40.765 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2026-01-09 13:27:40.765 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 252.9358ms
2026-01-09 13:27:40.774 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [n].[Id], [n].[Descripcion], [n].[Estatus], [n].[Gentilicio], [n].[Siglas]
FROM [Nationalities] AS [n]
2026-01-09 13:27:40.775 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 13:27:40.775 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 13:27:40.775 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities'
2026-01-09 13:27:40.775 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 256.9551ms
2026-01-09 13:27:44.311 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - null null
2026-01-09 13:27:44.311 +00:00 [INF] CORS policy execution successful.
2026-01-09 13:27:44.311 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - 204 null null 0.3191ms
2026-01-09 13:27:44.368 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma - null null
2026-01-09 13:27:44.368 +00:00 [INF] CORS policy execution successful.
2026-01-09 13:27:44.368 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 13:27:44.373 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 13:27:44.383 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 13:27:44.384 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 13:27:44.565 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 13:27:44.565 +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 197.7167ms
2026-01-09 13:27:48.487 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1415 - null null
2026-01-09 13:27:48.487 +00:00 [INF] CORS policy execution successful.
2026-01-09 13:27:48.488 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1415 - 204 null null 0.4095ms
2026-01-09 13:27:48.547 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/1415 - null null
2026-01-09 13:27:48.547 +00:00 [INF] CORS policy execution successful.
2026-01-09 13:27:48.547 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2026-01-09 13:27:48.555 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2026-01-09 13:27:48.556 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 13:27:48.556 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json.
2026-01-09 13:27:48.556 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2026-01-09 13:27:48.557 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/1415 - 200 null application/json; charset=utf-8 9.9692ms
2026-01-09 13:28:05.844 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-09 13:28:05.844 +00:00 [INF] CORS policy execution successful.
2026-01-09 13:28:05.844 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.2824ms
2026-01-09 13:28:05.903 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2026-01-09 13:28:05.904 +00:00 [INF] CORS policy execution successful.
2026-01-09 13:28:05.904 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-09 13:28:05.910 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2026-01-09 13:28:05.913 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2026-01-09 13:28:05.914 +00:00 [INF] Setting HTTP status code 201.
2026-01-09 13:28:05.914 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-09 13:28:05.914 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-09 13:28:05.914 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 10.7044ms
2026-01-09 13:28:05.972 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41235 - null null
2026-01-09 13:28:05.972 +00:00 [INF] CORS policy execution successful.
2026-01-09 13:28:05.973 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41235 - 204 null null 0.3938ms
2026-01-09 13:28:05.973 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-09 13:28:05.973 +00:00 [INF] CORS policy execution successful.
2026-01-09 13:28:05.973 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.1269ms
2026-01-09 13:28:06.033 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41235 - application/json 106
2026-01-09 13:28:06.033 +00:00 [INF] CORS policy execution successful.
2026-01-09 13:28:06.033 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-09 13:28:06.034 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-09 13:28:06.034 +00:00 [INF] CORS policy execution successful.
2026-01-09 13:28:06.034 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-09 13:28:06.036 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 13:28:06.037 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 13:28:06.037 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 13:28:06.037 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 13:28:06.037 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-09 13:28:06.037 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 3.7905ms
2026-01-09 13:28:06.205 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2026-01-09 13:28:06.208 +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);
2026-01-09 13:28:06.213 +00:00 [INF] Setting HTTP status code 201.
2026-01-09 13:28:06.213 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-09 13:28:06.213 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41235 - 201 0 null 180.5874ms
2026-01-09 14:23:30.650 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - null null
2026-01-09 14:23:30.651 +00:00 [INF] CORS policy execution successful.
2026-01-09 14:23:30.651 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - 204 null null 1.0169ms
2026-01-09 14:23:30.709 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma - null null
2026-01-09 14:23:30.709 +00:00 [INF] CORS policy execution successful.
2026-01-09 14:23:30.716 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 14:23:31.025 +00:00 [INF] Executed DbCommand (12ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 14:23:31.046 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 14:23:31.046 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 14:23:31.212 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 14:23:31.212 +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 503.2375ms
2026-01-09 14:23:39.628 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-09 14:23:39.628 +00:00 [INF] CORS policy execution successful.
2026-01-09 14:23:39.628 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.2827ms
2026-01-09 14:23:39.688 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2026-01-09 14:23:39.688 +00:00 [INF] CORS policy execution successful.
2026-01-09 14:23:39.688 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-09 14:23:39.695 +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);
2026-01-09 14:23:39.699 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2026-01-09 14:23:39.700 +00:00 [INF] Setting HTTP status code 201.
2026-01-09 14:23:39.700 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-09 14:23:39.701 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-09 14:23:39.701 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 13.3093ms
2026-01-09 14:23:39.761 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41236 - null null
2026-01-09 14:23:39.761 +00:00 [INF] CORS policy execution successful.
2026-01-09 14:23:39.761 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41236 - 204 null null 0.3107ms
2026-01-09 14:23:39.818 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-09 14:23:39.818 +00:00 [INF] CORS policy execution successful.
2026-01-09 14:23:39.818 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3431ms
2026-01-09 14:23:39.828 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41236 - application/json 106
2026-01-09 14:23:39.828 +00:00 [INF] CORS policy execution successful.
2026-01-09 14:23:39.829 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-09 14:23:39.832 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 14:23:39.877 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-09 14:23:39.878 +00:00 [INF] CORS policy execution successful.
2026-01-09 14:23:39.878 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-09 14:23:39.902 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 14:23:39.902 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 14:23:39.902 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 14:23:39.902 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-09 14:23:39.902 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 24.6257ms
2026-01-09 14:23:40.018 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2026-01-09 14:23:40.023 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35);
INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
OUTPUT INSERTED.[Id]
VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47);
2026-01-09 14:23:40.028 +00:00 [INF] Setting HTTP status code 201.
2026-01-09 14:23:40.028 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-09 14:23:40.028 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41236 - 201 0 null 200.6469ms
2026-01-09 14:46:01.079 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - null null
2026-01-09 14:46:01.079 +00:00 [INF] CORS policy execution successful.
2026-01-09 14:46:01.079 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - 204 null null 0.2682ms
2026-01-09 14:46:01.134 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - null null
2026-01-09 14:46:01.134 +00:00 [INF] CORS policy execution successful.
2026-01-09 14:46:01.136 +00:00 [INF] Executing endpoint 'HTTP: GET InventoryReplenishment/'
2026-01-09 14:46:01.412 +00:00 [INF] Executed DbCommand (7ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [t].[Id], [t].[CreatedById], [t].[CreatedDate], [t].[DeleteFlag], [t].[Description], [t].[UpdatedById], [t].[UpdatedDate], [t0].[Id], [t0].[CreatedById], [t0].[CreatedDate], [t0].[DeleteFlag], [t0].[Percentage], [t0].[TaxDescription], [t0].[UpdatedById], [t0].[UpdatedDate]
FROM [Products] AS [p]
INNER JOIN (
    SELECT [p0].[Id], [p0].[CreatedById], [p0].[CreatedDate], [p0].[DeleteFlag], [p0].[Description], [p0].[UpdatedById], [p0].[UpdatedDate]
    FROM [ProductCategories] AS [p0]
    WHERE [p0].[DeleteFlag] = CAST(0 AS bit)
) AS [t] ON [p].[CategoryId] = [t].[Id]
INNER JOIN (
    SELECT [p1].[Id], [p1].[CreatedById], [p1].[CreatedDate], [p1].[DeleteFlag], [p1].[Percentage], [p1].[TaxDescription], [p1].[UpdatedById], [p1].[UpdatedDate]
    FROM [ProductTaxes] AS [p1]
    WHERE [p1].[DeleteFlag] = CAST(0 AS bit)
) AS [t0] ON [p].[ProductTaxId] = [t0].[Id]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 3)
2026-01-09 14:46:01.565 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 14:46:01.566 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 14:46:01.567 +00:00 [INF] Executed endpoint 'HTTP: GET InventoryReplenishment/'
2026-01-09 14:46:01.568 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - 200 null application/json; charset=utf-8 433.7002ms
2026-01-09 14:46:54.841 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - null null
2026-01-09 14:46:54.841 +00:00 [INF] CORS policy execution successful.
2026-01-09 14:46:54.841 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - 204 null null 0.3496ms
2026-01-09 14:46:54.896 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - application/json 61
2026-01-09 14:46:54.897 +00:00 [INF] CORS policy execution successful.
2026-01-09 14:46:54.897 +00:00 [INF] Executing endpoint 'HTTP: POST InventoryReplenishment/createInvRepHD'
2026-01-09 14:46:54.902 +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);
2026-01-09 14:46:54.902 +00:00 [INF] Setting HTTP status code 201.
2026-01-09 14:46:54.902 +00:00 [INF] Writing value of type 'Guid' as Json.
2026-01-09 14:46:54.902 +00:00 [INF] Executed endpoint 'HTTP: POST InventoryReplenishment/createInvRepHD'
2026-01-09 14:46:54.902 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - 201 null application/json; charset=utf-8 5.9225ms
2026-01-09 14:46:54.959 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - null null
2026-01-09 14:46:54.959 +00:00 [INF] CORS policy execution successful.
2026-01-09 14:46:54.959 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - 204 null null 0.3175ms
2026-01-09 14:46:55.014 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - application/json 224
2026-01-09 14:46:55.014 +00:00 [INF] CORS policy execution successful.
2026-01-09 14:46:55.014 +00:00 [INF] Executing endpoint 'HTTP: POST InventoryReplenishment/createInvRepDet'
2026-01-09 14:46:55.020 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [t].[Id], [t].[CreatedById], [t].[CreatedDate], [t].[DeleteFlag], [t].[Description], [t].[UpdatedById], [t].[UpdatedDate], [t0].[Id], [t0].[CreatedById], [t0].[CreatedDate], [t0].[DeleteFlag], [t0].[Percentage], [t0].[TaxDescription], [t0].[UpdatedById], [t0].[UpdatedDate]
FROM [Products] AS [p]
INNER JOIN (
    SELECT [p0].[Id], [p0].[CreatedById], [p0].[CreatedDate], [p0].[DeleteFlag], [p0].[Description], [p0].[UpdatedById], [p0].[UpdatedDate]
    FROM [ProductCategories] AS [p0]
    WHERE [p0].[DeleteFlag] = CAST(0 AS bit)
) AS [t] ON [p].[CategoryId] = [t].[Id]
INNER JOIN (
    SELECT [p1].[Id], [p1].[CreatedById], [p1].[CreatedDate], [p1].[DeleteFlag], [p1].[Percentage], [p1].[TaxDescription], [p1].[UpdatedById], [p1].[UpdatedDate]
    FROM [ProductTaxes] AS [p1]
    WHERE [p1].[DeleteFlag] = CAST(0 AS bit)
) AS [t0] ON [p].[ProductTaxId] = [t0].[Id]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 14:46:55.204 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2026-01-09 14:46:55.211 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Int32), @p4='?' (Size = 34), @p5='?' (DbType = Guid), @p6='?' (DbType = Int32), @p7='?' (DbType = Int32), @p8='?' (DbType = Int32), @p9='?' (Size = 4000), @p10='?' (Size = 4000), @p11='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p29='?' (DbType = Int32), @p12='?' (Size = 4000), @p13='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p14='?' (DbType = Int32), @p15='?' (DbType = Guid), @p16='?' (DbType = DateTime2), @p17='?' (DbType = Boolean), @p18='?' (DbType = DateTime2), @p19='?' (DbType = Int32), @p20='?' (Size = 150), @p21='?' (Size = 500), @p22='?' (Size = -1) (DbType = Binary), @p23='?' (DbType = Int32), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (Size = 4000), @p26='?' (DbType = Int32), @p27='?' (DbType = Guid), @p28='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11);
UPDATE [Products] SET [BarCode] = @p12, [BuyPrice] = @p13, [CategoryId] = @p14, [CreatedById] = @p15, [CreatedDate] = @p16, [DeleteFlag] = @p17, [ExpirationDate] = @p18, [MinimunStock] = @p19, [Name] = @p20, [Note] = @p21, [ProductImage] = @p22, [ProductTaxId] = @p23, [SalePrice] = @p24, [Status] = @p25, [Stock] = @p26, [UpdatedById] = @p27, [UpdatedDate] = @p28
OUTPUT 1
WHERE [Id] = @p29;
2026-01-09 14:46:55.217 +00:00 [INF] Setting HTTP status code 201.
2026-01-09 14:46:55.217 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 14:46:55.218 +00:00 [INF] Executed endpoint 'HTTP: POST InventoryReplenishment/createInvRepDet'
2026-01-09 14:46:55.218 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - 201 null application/json; charset=utf-8 203.9147ms
2026-01-09 14:46:55.275 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - null null
2026-01-09 14:46:55.275 +00:00 [INF] CORS policy execution successful.
2026-01-09 14:46:55.275 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - 204 null null 0.2483ms
2026-01-09 14:46:55.330 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - null null
2026-01-09 14:46:55.330 +00:00 [INF] CORS policy execution successful.
2026-01-09 14:46:55.330 +00:00 [INF] Executing endpoint 'HTTP: GET InventoryReplenishment/'
2026-01-09 14:46:55.335 +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)
2026-01-09 14:46:55.518 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 14:46:55.518 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 14:46:55.525 +00:00 [INF] Executed endpoint 'HTTP: GET InventoryReplenishment/'
2026-01-09 14:46:55.526 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - 200 null application/json; charset=utf-8 195.6491ms
2026-01-09 15:19:30.777 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan de guineo - null null
2026-01-09 15:19:30.777 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:19:30.777 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan de guineo - 204 null null 0.2645ms
2026-01-09 15:19:30.838 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan de guineo - null null
2026-01-09 15:19:30.838 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:19:30.838 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 15:19:31.072 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 15:19:31.077 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:19:31.078 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:19:31.190 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 15:19:31.191 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan de guineo - 200 null application/json; charset=utf-8 353.521ms
2026-01-09 15:46:33.192 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/soya - null null
2026-01-09 15:46:33.193 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:46:33.193 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/soya - 204 null null 0.3915ms
2026-01-09 15:46:33.250 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/soya - null null
2026-01-09 15:46:33.250 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:46:33.250 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 15:46:33.482 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 15:46:33.492 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:46:33.492 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:46:33.604 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 15:46:33.605 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/soya - 200 null application/json; charset=utf-8 355.0256ms
2026-01-09 15:46:43.438 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - null null
2026-01-09 15:46:43.438 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:46:43.438 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - 204 null null 0.2684ms
2026-01-09 15:46:43.508 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma - null null
2026-01-09 15:46:43.508 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:46:43.508 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 15:46:43.511 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 15:46:43.521 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:46:43.521 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:46:43.693 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 15:46:43.693 +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 185.281ms
2026-01-09 15:49:23.373 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/protein - null null
2026-01-09 15:49:23.373 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:49:23.374 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/protein - 204 null null 0.2847ms
2026-01-09 15:49:23.430 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/protein - null null
2026-01-09 15:49:23.430 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:49:23.430 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 15:49:23.434 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 15:49:23.438 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:49:23.438 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:49:23.552 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 15:49:23.552 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/protein - 200 null application/json; charset=utf-8 122.8319ms
2026-01-09 15:50:47.196 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-09 15:50:47.196 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:50:47.196 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3642ms
2026-01-09 15:50:47.255 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-09 15:50:47.255 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:50:47.256 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-09 15:50:47.258 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 15:50:47.258 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:50:47.258 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:50:47.258 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-09 15:50:47.258 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 2.9171ms
2026-01-09 15:51:15.744 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null
2026-01-09 15:51:15.744 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:15.745 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.2684ms
2026-01-09 15:51:15.801 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 58
2026-01-09 15:51:15.801 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:15.801 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin'
2026-01-09 15:51:15.816 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName]
FROM [AspNetUsers] AS [a]
WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0
2026-01-09 15:51:15.928 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (Size = 450)], CommandType='"Text"', CommandTimeout='30']
SELECT [a0].[Name]
FROM [AspNetUserRoles] AS [a]
INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id]
WHERE [a].[UserId] = @__userId_0
2026-01-09 15:51:15.929 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:51:15.929 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json.
2026-01-09 15:51:15.929 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin'
2026-01-09 15:51:15.929 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 128.5856ms
2026-01-09 15:51:20.724 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null
2026-01-09 15:51:20.724 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:20.724 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.3047ms
2026-01-09 15:51:20.775 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2026-01-09 15:51:20.775 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:20.775 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.2254ms
2026-01-09 15:51:20.779 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - null null
2026-01-09 15:51:20.779 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:20.780 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - 204 null null 0.4159ms
2026-01-09 15:51:20.792 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null
2026-01-09 15:51:20.793 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:20.793 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/'
2026-01-09 15:51:20.795 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate]
FROM [Settings] AS [s]
2026-01-09 15:51:20.795 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:51:20.795 +00:00 [INF] Writing value of type 'SettingDto' as Json.
2026-01-09 15:51:20.795 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/'
2026-01-09 15:51:20.795 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 2.8752ms
2026-01-09 15:51:20.828 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2026-01-09 15:51:20.828 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:20.828 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2026-01-09 15:51:20.831 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [ProductTaxes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 15:51:20.831 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:51:20.831 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:51:20.831 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2026-01-09 15:51:20.831 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 3.0877ms
2026-01-09 15:51:20.836 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Products - null null
2026-01-09 15:51:20.836 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:20.837 +00:00 [INF] Executing endpoint 'HTTP: GET /products'
2026-01-09 15:51:20.841 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [t].[Id], [t].[CreatedById], [t].[CreatedDate], [t].[DeleteFlag], [t].[Description], [t].[UpdatedById], [t].[UpdatedDate], [t0].[Id], [t0].[CreatedById], [t0].[CreatedDate], [t0].[DeleteFlag], [t0].[Percentage], [t0].[TaxDescription], [t0].[UpdatedById], [t0].[UpdatedDate]
FROM [Products] AS [p]
INNER JOIN (
    SELECT [p0].[Id], [p0].[CreatedById], [p0].[CreatedDate], [p0].[DeleteFlag], [p0].[Description], [p0].[UpdatedById], [p0].[UpdatedDate]
    FROM [ProductCategories] AS [p0]
    WHERE [p0].[DeleteFlag] = CAST(0 AS bit)
) AS [t] ON [p].[CategoryId] = [t].[Id]
INNER JOIN (
    SELECT [p1].[Id], [p1].[CreatedById], [p1].[CreatedDate], [p1].[DeleteFlag], [p1].[Percentage], [p1].[TaxDescription], [p1].[UpdatedById], [p1].[UpdatedDate]
    FROM [ProductTaxes] AS [p1]
    WHERE [p1].[DeleteFlag] = CAST(0 AS bit)
) AS [t0] ON [p].[ProductTaxId] = [t0].[Id]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 15:51:21.017 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:51:21.018 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:51:21.620 +00:00 [INF] Executed endpoint 'HTTP: GET /products'
2026-01-09 15:51:21.621 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Products - 200 null application/json; charset=utf-8 784.7664ms
2026-01-09 15:51:29.637 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2026-01-09 15:51:29.638 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:29.638 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.3558ms
2026-01-09 15:51:29.638 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductCategory - null null
2026-01-09 15:51:29.638 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:29.638 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductCategory - 204 null null 0.1584ms
2026-01-09 15:51:29.647 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1562 - null null
2026-01-09 15:51:29.647 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:29.647 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1562 - 204 null null 0.3426ms
2026-01-09 15:51:29.691 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductCategory - null null
2026-01-09 15:51:29.691 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:29.692 +00:00 [INF] Executing endpoint 'HTTP: GET ProductCategory/'
2026-01-09 15:51:29.693 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2026-01-09 15:51:29.693 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:29.693 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2026-01-09 15:51:29.694 +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)
2026-01-09 15:51:29.694 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:51:29.694 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:51:29.694 +00:00 [INF] Executed endpoint 'HTTP: GET ProductCategory/'
2026-01-09 15:51:29.694 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductCategory - 200 null application/json; charset=utf-8 3.1255ms
2026-01-09 15:51:29.695 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [ProductTaxes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 15:51:29.695 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:51:29.695 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:51:29.695 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2026-01-09 15:51:29.695 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 2.5651ms
2026-01-09 15:51:29.707 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/1562 - null null
2026-01-09 15:51:29.707 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:29.707 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2026-01-09 15:51:29.710 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2026-01-09 15:51:29.713 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:51:29.713 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json.
2026-01-09 15:51:29.713 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2026-01-09 15:51:29.713 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/1562 - 200 null application/json; charset=utf-8 6.5052ms
2026-01-09 15:51:31.926 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - null null
2026-01-09 15:51:31.926 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:31.927 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - 204 null null 0.2799ms
2026-01-09 15:51:31.986 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma - null null
2026-01-09 15:51:31.986 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:31.986 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 15:51:31.989 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 15:51:31.998 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:51:31.998 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:51:32.166 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 15:51:32.166 +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 180.7864ms
2026-01-09 15:51:35.311 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1562 - null null
2026-01-09 15:51:35.311 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:35.311 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1562 - 204 null null 0.434ms
2026-01-09 15:51:35.371 +00:00 [INF] Request starting HTTP/1.1 PUT http://159.89.226.33:5227/products/1562 - application/json 23626
2026-01-09 15:51:35.372 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:35.373 +00:00 [INF] Executing endpoint 'HTTP: PUT Products/{id}'
2026-01-09 15:51:35.434 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2026-01-09 15:51:35.439 +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;
2026-01-09 15:51:35.440 +00:00 [INF] Setting HTTP status code 204.
2026-01-09 15:51:35.440 +00:00 [INF] Executed endpoint 'HTTP: PUT Products/{id}'
2026-01-09 15:51:35.441 +00:00 [INF] Request finished HTTP/1.1 PUT http://159.89.226.33:5227/products/1562 - 204 null null 69.3989ms
2026-01-09 15:51:37.506 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2026-01-09 15:51:37.506 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:37.506 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.2772ms
2026-01-09 15:51:37.507 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - null null
2026-01-09 15:51:37.507 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:37.507 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - 204 null null 0.0984ms
2026-01-09 15:51:37.514 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null
2026-01-09 15:51:37.514 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:37.515 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.2519ms
2026-01-09 15:51:37.559 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Products - null null
2026-01-09 15:51:37.559 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:37.560 +00:00 [INF] Executing endpoint 'HTTP: GET /products'
2026-01-09 15:51:37.561 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2026-01-09 15:51:37.561 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:37.562 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2026-01-09 15:51:37.564 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [t].[Id], [t].[CreatedById], [t].[CreatedDate], [t].[DeleteFlag], [t].[Description], [t].[UpdatedById], [t].[UpdatedDate], [t0].[Id], [t0].[CreatedById], [t0].[CreatedDate], [t0].[DeleteFlag], [t0].[Percentage], [t0].[TaxDescription], [t0].[UpdatedById], [t0].[UpdatedDate]
FROM [Products] AS [p]
INNER JOIN (
    SELECT [p0].[Id], [p0].[CreatedById], [p0].[CreatedDate], [p0].[DeleteFlag], [p0].[Description], [p0].[UpdatedById], [p0].[UpdatedDate]
    FROM [ProductCategories] AS [p0]
    WHERE [p0].[DeleteFlag] = CAST(0 AS bit)
) AS [t] ON [p].[CategoryId] = [t].[Id]
INNER JOIN (
    SELECT [p1].[Id], [p1].[CreatedById], [p1].[CreatedDate], [p1].[DeleteFlag], [p1].[Percentage], [p1].[TaxDescription], [p1].[UpdatedById], [p1].[UpdatedDate]
    FROM [ProductTaxes] AS [p1]
    WHERE [p1].[DeleteFlag] = CAST(0 AS bit)
) AS [t0] ON [p].[ProductTaxId] = [t0].[Id]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 15:51:37.574 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null
2026-01-09 15:51:37.574 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:37.574 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/'
2026-01-09 15:51:37.841 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:51:37.842 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:51:37.867 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate]
FROM [Settings] AS [s]
2026-01-09 15:51:37.868 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [ProductTaxes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 15:51:37.867 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:51:37.869 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:51:37.869 +00:00 [INF] Writing value of type 'SettingDto' as Json.
2026-01-09 15:51:37.869 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:51:37.870 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2026-01-09 15:51:37.869 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/'
2026-01-09 15:51:37.870 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 308.6489ms
2026-01-09 15:51:37.870 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 296.0344ms
2026-01-09 15:51:38.529 +00:00 [INF] Executed endpoint 'HTTP: GET /products'
2026-01-09 15:51:38.530 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Products - 200 null application/json; charset=utf-8 970.6764ms
2026-01-09 15:51:39.342 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-09 15:51:39.342 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:39.342 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3507ms
2026-01-09 15:51:39.404 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2026-01-09 15:51:39.404 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:39.404 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-09 15:51:39.408 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2026-01-09 15:51:39.412 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2026-01-09 15:51:39.412 +00:00 [INF] Setting HTTP status code 201.
2026-01-09 15:51:39.412 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-09 15:51:39.412 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-09 15:51:39.412 +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.7378ms
2026-01-09 15:51:39.471 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41237 - null null
2026-01-09 15:51:39.472 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:39.472 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41237 - 204 null null 0.4767ms
2026-01-09 15:51:39.527 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-09 15:51:39.527 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:39.528 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.4271ms
2026-01-09 15:51:39.534 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41237 - application/json 106
2026-01-09 15:51:39.534 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:39.535 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-09 15:51:39.537 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 15:51:39.583 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-09 15:51:39.583 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:51:39.583 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-09 15:51:39.585 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 15:51:39.586 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:51:39.586 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:51:39.586 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-09 15:51:39.586 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 2.7722ms
2026-01-09 15:51:39.711 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2026-01-09 15:51:39.714 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35);
INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
OUTPUT INSERTED.[Id]
VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47);
2026-01-09 15:51:39.718 +00:00 [INF] Setting HTTP status code 201.
2026-01-09 15:51:39.719 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-09 15:51:39.719 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41237 - 201 0 null 184.8668ms
2026-01-09 15:52:13.228 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/leche - null null
2026-01-09 15:52:13.228 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:52:13.228 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/leche - 204 null null 0.3773ms
2026-01-09 15:52:13.287 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/leche - null null
2026-01-09 15:52:13.288 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:52:13.288 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 15:52:13.291 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 15:52:13.295 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:52:13.295 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:52:13.295 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 15:52:13.295 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/leche - 200 null application/json; charset=utf-8 7.5627ms
2026-01-09 15:52:23.288 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/puer - null null
2026-01-09 15:52:23.289 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:52:23.289 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/puer - 204 null null 0.3237ms
2026-01-09 15:52:23.348 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/puer - null null
2026-01-09 15:52:23.349 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:52:23.349 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 15:52:23.353 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 15:52:23.354 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:52:23.354 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:52:23.354 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 15:52:23.354 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/puer - 200 null application/json; charset=utf-8 5.3456ms
2026-01-09 15:52:27.594 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/vegan - null null
2026-01-09 15:52:27.594 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:52:27.594 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/vegan - 204 null null 0.4338ms
2026-01-09 15:52:27.654 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/vegan - null null
2026-01-09 15:52:27.655 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:52:27.655 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 15:52:27.660 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 15:52:27.662 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:52:27.663 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:52:27.663 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 15:52:27.663 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/vegan - 200 null application/json; charset=utf-8 8.3692ms
2026-01-09 15:53:01.357 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-09 15:53:01.357 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:53:01.358 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3067ms
2026-01-09 15:53:01.414 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-09 15:53:01.415 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:53:01.415 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-09 15:53:01.418 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 15:53:01.418 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:53:01.418 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:53:01.418 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-09 15:53:01.418 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 3.7741ms
2026-01-09 15:53:05.996 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/vegan - null null
2026-01-09 15:53:05.996 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:53:05.997 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/vegan - 204 null null 0.5919ms
2026-01-09 15:53:06.056 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/vegan - null null
2026-01-09 15:53:06.056 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:53:06.057 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 15:53:06.062 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 15:53:06.063 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:53:06.063 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:53:06.064 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 15:53:06.064 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/vegan - 200 null application/json; charset=utf-8 7.6545ms
2026-01-09 15:53:18.907 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Proteina - null null
2026-01-09 15:53:18.907 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:53:18.907 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Proteina - 204 null null 0.3368ms
2026-01-09 15:53:18.973 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/Proteina - null null
2026-01-09 15:53:18.973 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:53:18.974 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 15:53:18.977 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 15:53:18.981 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:53:18.981 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:53:18.981 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 15:53:18.981 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/Proteina - 200 null application/json; charset=utf-8 8.0666ms
2026-01-09 15:54:28.629 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2026-01-09 15:54:28.630 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:28.630 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.3446ms
2026-01-09 15:54:28.629 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductCategory - null null
2026-01-09 15:54:28.630 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:28.630 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductCategory - 204 null null 0.6978ms
2026-01-09 15:54:28.632 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1587 - null null
2026-01-09 15:54:28.632 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:28.632 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1587 - 204 null null 0.1867ms
2026-01-09 15:54:28.681 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductCategory - null null
2026-01-09 15:54:28.681 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:28.681 +00:00 [INF] Executing endpoint 'HTTP: GET ProductCategory/'
2026-01-09 15:54:28.682 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2026-01-09 15:54:28.682 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:28.682 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2026-01-09 15:54:28.684 +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)
2026-01-09 15:54:28.684 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:54:28.684 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:54:28.684 +00:00 [INF] Executed endpoint 'HTTP: GET ProductCategory/'
2026-01-09 15:54:28.684 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductCategory - 200 null application/json; charset=utf-8 3.8856ms
2026-01-09 15:54:28.685 +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)
2026-01-09 15:54:28.685 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:54:28.685 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:54:28.685 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2026-01-09 15:54:28.685 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 3.7811ms
2026-01-09 15:54:28.687 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/1587 - null null
2026-01-09 15:54:28.687 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:28.688 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2026-01-09 15:54:28.690 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2026-01-09 15:54:28.691 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:54:28.691 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json.
2026-01-09 15:54:28.691 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2026-01-09 15:54:28.691 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/1587 - 200 null application/json; charset=utf-8 3.959ms
2026-01-09 15:54:32.946 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1587 - null null
2026-01-09 15:54:32.946 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:32.947 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1587 - 204 null null 0.419ms
2026-01-09 15:54:33.014 +00:00 [INF] Request starting HTTP/1.1 PUT http://159.89.226.33:5227/products/1587 - application/json 23642
2026-01-09 15:54:33.014 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:33.014 +00:00 [INF] Executing endpoint 'HTTP: PUT Products/{id}'
2026-01-09 15:54:33.085 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2026-01-09 15:54:33.090 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p17='?' (DbType = Int32), @p0='?' (Size = 4000), @p1='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p2='?' (DbType = Int32), @p3='?' (DbType = Guid), @p4='?' (DbType = DateTime2), @p5='?' (DbType = Boolean), @p6='?' (DbType = DateTime2), @p7='?' (DbType = Int32), @p8='?' (Size = 150), @p9='?' (Size = 500), @p10='?' (Size = -1) (DbType = Binary), @p11='?' (DbType = Int32), @p12='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p13='?' (Size = 4000), @p14='?' (DbType = Int32), @p15='?' (DbType = Guid), @p16='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
UPDATE [Products] SET [BarCode] = @p0, [BuyPrice] = @p1, [CategoryId] = @p2, [CreatedById] = @p3, [CreatedDate] = @p4, [DeleteFlag] = @p5, [ExpirationDate] = @p6, [MinimunStock] = @p7, [Name] = @p8, [Note] = @p9, [ProductImage] = @p10, [ProductTaxId] = @p11, [SalePrice] = @p12, [Status] = @p13, [Stock] = @p14, [UpdatedById] = @p15, [UpdatedDate] = @p16
OUTPUT 1
WHERE [Id] = @p17;
2026-01-09 15:54:33.090 +00:00 [INF] Setting HTTP status code 204.
2026-01-09 15:54:33.090 +00:00 [INF] Executed endpoint 'HTTP: PUT Products/{id}'
2026-01-09 15:54:33.090 +00:00 [INF] Request finished HTTP/1.1 PUT http://159.89.226.33:5227/products/1587 - 204 null null 76.4297ms
2026-01-09 15:54:35.153 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null
2026-01-09 15:54:35.153 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:35.153 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.3749ms
2026-01-09 15:54:35.153 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2026-01-09 15:54:35.153 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:35.153 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.1153ms
2026-01-09 15:54:35.153 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - null null
2026-01-09 15:54:35.153 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:35.153 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - 204 null null 0.0546ms
2026-01-09 15:54:35.205 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Products - null null
2026-01-09 15:54:35.205 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:35.205 +00:00 [INF] Executing endpoint 'HTTP: GET /products'
2026-01-09 15:54:35.205 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2026-01-09 15:54:35.206 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:35.206 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2026-01-09 15:54:35.209 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [t].[Id], [t].[CreatedById], [t].[CreatedDate], [t].[DeleteFlag], [t].[Description], [t].[UpdatedById], [t].[UpdatedDate], [t0].[Id], [t0].[CreatedById], [t0].[CreatedDate], [t0].[DeleteFlag], [t0].[Percentage], [t0].[TaxDescription], [t0].[UpdatedById], [t0].[UpdatedDate]
FROM [Products] AS [p]
INNER JOIN (
    SELECT [p0].[Id], [p0].[CreatedById], [p0].[CreatedDate], [p0].[DeleteFlag], [p0].[Description], [p0].[UpdatedById], [p0].[UpdatedDate]
    FROM [ProductCategories] AS [p0]
    WHERE [p0].[DeleteFlag] = CAST(0 AS bit)
) AS [t] ON [p].[CategoryId] = [t].[Id]
INNER JOIN (
    SELECT [p1].[Id], [p1].[CreatedById], [p1].[CreatedDate], [p1].[DeleteFlag], [p1].[Percentage], [p1].[TaxDescription], [p1].[UpdatedById], [p1].[UpdatedDate]
    FROM [ProductTaxes] AS [p1]
    WHERE [p1].[DeleteFlag] = CAST(0 AS bit)
) AS [t0] ON [p].[ProductTaxId] = [t0].[Id]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 15:54:35.210 +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)
2026-01-09 15:54:35.212 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:54:35.212 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:54:35.212 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2026-01-09 15:54:35.212 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 7.4225ms
2026-01-09 15:54:35.212 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null
2026-01-09 15:54:35.213 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:35.213 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/'
2026-01-09 15:54:35.215 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate]
FROM [Settings] AS [s]
2026-01-09 15:54:35.215 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:54:35.215 +00:00 [INF] Writing value of type 'SettingDto' as Json.
2026-01-09 15:54:35.215 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/'
2026-01-09 15:54:35.215 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 2.6821ms
2026-01-09 15:54:35.374 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:54:35.374 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:54:35.940 +00:00 [INF] Executed endpoint 'HTTP: GET /products'
2026-01-09 15:54:35.941 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Products - 200 null application/json; charset=utf-8 735.9615ms
2026-01-09 15:54:42.028 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductCategory - null null
2026-01-09 15:54:42.028 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:42.028 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductCategory - 204 null null 0.2767ms
2026-01-09 15:54:42.028 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1588 - null null
2026-01-09 15:54:42.029 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:42.029 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1588 - 204 null null 0.104ms
2026-01-09 15:54:42.028 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2026-01-09 15:54:42.029 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:42.029 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 1.256ms
2026-01-09 15:54:42.080 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/1588 - null null
2026-01-09 15:54:42.080 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:42.081 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2026-01-09 15:54:42.081 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2026-01-09 15:54:42.081 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:42.081 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2026-01-09 15:54:42.083 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [ProductTaxes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 15:54:42.083 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:54:42.083 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:54:42.083 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2026-01-09 15:54:42.083 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 2.763ms
2026-01-09 15:54:42.084 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductCategory - null null
2026-01-09 15:54:42.084 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:42.084 +00:00 [INF] Executing endpoint 'HTTP: GET ProductCategory/'
2026-01-09 15:54:42.085 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2026-01-09 15:54:42.086 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:54:42.086 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json.
2026-01-09 15:54:42.086 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2026-01-09 15:54:42.086 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/1588 - 200 null application/json; charset=utf-8 6.3323ms
2026-01-09 15:54:42.087 +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)
2026-01-09 15:54:42.088 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:54:42.088 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:54:42.088 +00:00 [INF] Executed endpoint 'HTTP: GET ProductCategory/'
2026-01-09 15:54:42.088 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductCategory - 200 null application/json; charset=utf-8 3.6898ms
2026-01-09 15:54:45.735 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1588 - null null
2026-01-09 15:54:45.735 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:45.735 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1588 - 204 null null 0.449ms
2026-01-09 15:54:45.789 +00:00 [INF] Request starting HTTP/1.1 PUT http://159.89.226.33:5227/products/1588 - application/json 23641
2026-01-09 15:54:45.790 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:45.790 +00:00 [INF] Executing endpoint 'HTTP: PUT Products/{id}'
2026-01-09 15:54:45.842 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2026-01-09 15:54:45.847 +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;
2026-01-09 15:54:45.847 +00:00 [INF] Setting HTTP status code 204.
2026-01-09 15:54:45.847 +00:00 [INF] Executed endpoint 'HTTP: PUT Products/{id}'
2026-01-09 15:54:45.847 +00:00 [INF] Request finished HTTP/1.1 PUT http://159.89.226.33:5227/products/1588 - 204 null null 58.1917ms
2026-01-09 15:54:47.907 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null
2026-01-09 15:54:47.908 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2026-01-09 15:54:47.908 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:47.908 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:47.908 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.3923ms
2026-01-09 15:54:47.908 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - null null
2026-01-09 15:54:47.908 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:47.908 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - 204 null null 0.0683ms
2026-01-09 15:54:47.908 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.2355ms
2026-01-09 15:54:47.960 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Products - null null
2026-01-09 15:54:47.960 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:47.960 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null
2026-01-09 15:54:47.961 +00:00 [INF] Executing endpoint 'HTTP: GET /products'
2026-01-09 15:54:47.961 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:47.961 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/'
2026-01-09 15:54:47.963 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2026-01-09 15:54:47.963 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate]
FROM [Settings] AS [s]
2026-01-09 15:54:47.963 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:54:47.963 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:54:47.963 +00:00 [INF] Writing value of type 'SettingDto' as Json.
2026-01-09 15:54:47.963 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/'
2026-01-09 15:54:47.963 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2026-01-09 15:54:47.963 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 3.0677ms
2026-01-09 15:54:47.966 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [t].[Id], [t].[CreatedById], [t].[CreatedDate], [t].[DeleteFlag], [t].[Description], [t].[UpdatedById], [t].[UpdatedDate], [t0].[Id], [t0].[CreatedById], [t0].[CreatedDate], [t0].[DeleteFlag], [t0].[Percentage], [t0].[TaxDescription], [t0].[UpdatedById], [t0].[UpdatedDate]
FROM [Products] AS [p]
INNER JOIN (
    SELECT [p0].[Id], [p0].[CreatedById], [p0].[CreatedDate], [p0].[DeleteFlag], [p0].[Description], [p0].[UpdatedById], [p0].[UpdatedDate]
    FROM [ProductCategories] AS [p0]
    WHERE [p0].[DeleteFlag] = CAST(0 AS bit)
) AS [t] ON [p].[CategoryId] = [t].[Id]
INNER JOIN (
    SELECT [p1].[Id], [p1].[CreatedById], [p1].[CreatedDate], [p1].[DeleteFlag], [p1].[Percentage], [p1].[TaxDescription], [p1].[UpdatedById], [p1].[UpdatedDate]
    FROM [ProductTaxes] AS [p1]
    WHERE [p1].[DeleteFlag] = CAST(0 AS bit)
) AS [t0] ON [p].[ProductTaxId] = [t0].[Id]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 15:54:47.967 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [ProductTaxes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 15:54:47.967 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:54:47.967 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:54:47.968 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2026-01-09 15:54:47.968 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 4.9482ms
2026-01-09 15:54:48.090 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:54:48.091 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:54:48.651 +00:00 [INF] Executed endpoint 'HTTP: GET /products'
2026-01-09 15:54:48.651 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Products - 200 null application/json; charset=utf-8 691.3489ms
2026-01-09 15:57:54.684 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/leche - null null
2026-01-09 15:57:54.684 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:57:54.685 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/leche - 204 null null 0.4143ms
2026-01-09 15:57:54.754 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/leche - null null
2026-01-09 15:57:54.754 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:57:54.755 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 15:57:55.049 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 15:57:55.057 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:57:55.058 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:57:55.058 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 15:57:55.059 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/leche - 200 null application/json; charset=utf-8 304.4359ms
2026-01-09 15:58:00.973 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/vegan - null null
2026-01-09 15:58:00.973 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:58:00.973 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/vegan - 204 null null 0.439ms
2026-01-09 15:58:01.033 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/vegan - null null
2026-01-09 15:58:01.033 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:58:01.033 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 15:58:01.038 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 15:58:01.042 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:58:01.042 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:58:01.046 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 15:58:01.046 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/vegan - 200 null application/json; charset=utf-8 13.7543ms
2026-01-09 15:58:08.811 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-09 15:58:08.811 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:58:08.811 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.351ms
2026-01-09 15:58:08.871 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2026-01-09 15:58:08.871 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:58:08.871 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-09 15:58:08.876 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2026-01-09 15:58:08.880 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2026-01-09 15:58:08.880 +00:00 [INF] Setting HTTP status code 201.
2026-01-09 15:58:08.880 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-09 15:58:08.880 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-09 15:58:08.880 +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.2748ms
2026-01-09 15:58:08.941 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41238 - null null
2026-01-09 15:58:08.941 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:58:08.941 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41238 - 204 null null 0.3464ms
2026-01-09 15:58:09.001 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-09 15:58:09.001 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:58:09.001 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3269ms
2026-01-09 15:58:09.010 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41238 - application/json 208
2026-01-09 15:58:09.011 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:58:09.011 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-09 15:58:09.013 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 15:58:09.061 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-09 15:58:09.061 +00:00 [INF] CORS policy execution successful.
2026-01-09 15:58:09.061 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-09 15:58:09.088 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 15:58:09.088 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 15:58:09.088 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 15:58:09.089 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-09 15:58:09.089 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 28.6815ms
2026-01-09 15:58:09.198 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2026-01-09 15:58:09.203 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p40='?' (DbType = Int32), @p23='?' (Size = 4000), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Int32), @p26='?' (DbType = Guid), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Boolean), @p29='?' (DbType = DateTime2), @p30='?' (DbType = Int32), @p31='?' (Size = 150), @p32='?' (Size = 500), @p33='?' (Size = -1) (DbType = Binary), @p34='?' (DbType = Int32), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p36='?' (Size = 4000), @p37='?' (DbType = Int32), @p38='?' (DbType = Guid), @p39='?' (DbType = DateTime2), @p41='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p42='?' (DbType = Guid), @p43='?' (DbType = DateTime2), @p44='?' (DbType = Boolean), @p45='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p46='?' (DbType = Int32), @p47='?' (DbType = Int32), @p48='?' (DbType = Int64), @p49='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p50='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p51='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p52='?' (DbType = Guid), @p53='?' (DbType = DateTime2), @p54='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p55='?' (DbType = Guid), @p56='?' (DbType = DateTime2), @p57='?' (DbType = Boolean), @p58='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p59='?' (DbType = Int32), @p60='?' (DbType = Int32), @p61='?' (DbType = Int64), @p62='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p63='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p64='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p65='?' (DbType = Guid), @p66='?' (DbType = DateTime2), @p67='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p68='?' (DbType = Guid), @p69='?' (DbType = DateTime2), @p70='?' (DbType = Int32), @p71='?' (Size = 34), @p72='?' (DbType = Guid), @p73='?' (DbType = Int32), @p74='?' (DbType = Int32), @p75='?' (DbType = Int32), @p76='?' (Size = 4000), @p77='?' (Size = 4000), @p78='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p79='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p80='?' (DbType = Guid), @p81='?' (DbType = DateTime2), @p82='?' (DbType = Int32), @p83='?' (Size = 34), @p84='?' (DbType = Guid), @p85='?' (DbType = Int32), @p86='?' (DbType = Int32), @p87='?' (DbType = Int32), @p88='?' (Size = 4000), @p89='?' (Size = 4000), @p90='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
UPDATE [Products] SET [BarCode] = @p23, [BuyPrice] = @p24, [CategoryId] = @p25, [CreatedById] = @p26, [CreatedDate] = @p27, [DeleteFlag] = @p28, [ExpirationDate] = @p29, [MinimunStock] = @p30, [Name] = @p31, [Note] = @p32, [ProductImage] = @p33, [ProductTaxId] = @p34, [SalePrice] = @p35, [Status] = @p36, [Stock] = @p37, [UpdatedById] = @p38, [UpdatedDate] = @p39
OUTPUT 1
WHERE [Id] = @p40;
MERGE [SalesDetail] USING (
VALUES (@p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52, @p53, 0),
(@p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62, @p63, @p64, @p65, @p66, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[DeleteFlag], i.[DiscountAmount], i.[ProductId], i.[Quantity], i.[SalesId], i.[Tax], i.[Total], i.[UnitPrice], i.[UpdatedById], i.[UpdatedDate])
OUTPUT INSERTED.[Id], i._Position;
MERGE [InventoryMovements] USING (
VALUES (@p67, @p68, @p69, @p70, @p71, @p72, @p73, @p74, @p75, @p76, @p77, @p78, 0),
(@p79, @p80, @p81, @p82, @p83, @p84, @p85, @p86, @p87, @p88, @p89, @p90, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[Difference], i.[Discriminator], i.[InventoryMovementHeaderId], i.[NewStock], i.[OriginaStock], i.[ProductId], i.[ProductName], i.[Reazon], i.[SalePrice])
OUTPUT INSERTED.[Id], i._Position;
2026-01-09 15:58:09.209 +00:00 [INF] Setting HTTP status code 201.
2026-01-09 15:58:09.209 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-09 15:58:09.210 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41238 - 201 0 null 199.4224ms
2026-01-09 16:32:36.743 +00:00 [INF] Request starting HTTP/1.0 GET http:/// - null null
2026-01-09 16:32:36.743 +00:00 [INF] Request finished HTTP/1.0 GET http:/// - 404 0 null 0.298ms
2026-01-09 16:32:36.743 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http:///, Response status code: 404
2026-01-09 17:04:11.547 +00:00 [INF] Request starting HTTP/1.1 GET http://localhost:5227/.env - null null
2026-01-09 17:04:11.547 +00:00 [INF] Request finished HTTP/1.1 GET http://localhost:5227/.env - 404 0 null 0.3289ms
2026-01-09 17:04:11.547 +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
2026-01-09 17:04:11.786 +00:00 [INF] Request starting HTTP/1.1 POST http://localhost:5227/.env - application/x-www-form-urlencoded 20
2026-01-09 17:04:11.786 +00:00 [INF] Request finished HTTP/1.1 POST http://localhost:5227/.env - 404 0 null 0.3162ms
2026-01-09 17:04:11.786 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: POST http://localhost:5227/.env, Response status code: 404
2026-01-09 18:58:23.128 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jacobo - null null
2026-01-09 18:58:23.128 +00:00 [INF] CORS policy execution successful.
2026-01-09 18:58:23.128 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jacobo - 204 null null 0.2792ms
2026-01-09 18:58:23.190 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/jacobo - null null
2026-01-09 18:58:23.190 +00:00 [INF] CORS policy execution successful.
2026-01-09 18:58:23.190 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 18:58:23.444 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 18:58:23.451 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 18:58:23.451 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 18:58:23.451 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 18:58:23.452 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/jacobo - 200 null application/json; charset=utf-8 261.7187ms
2026-01-09 18:58:29.677 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-09 18:58:29.677 +00:00 [INF] CORS policy execution successful.
2026-01-09 18:58:29.677 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3076ms
2026-01-09 18:58:29.734 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2026-01-09 18:58:29.735 +00:00 [INF] CORS policy execution successful.
2026-01-09 18:58:29.735 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-09 18:58:29.739 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2026-01-09 18:58:29.742 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2026-01-09 18:58:29.743 +00:00 [INF] Setting HTTP status code 201.
2026-01-09 18:58:29.743 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-09 18:58:29.743 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-09 18:58:29.744 +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.4432ms
2026-01-09 18:58:29.808 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41239 - null null
2026-01-09 18:58:29.808 +00:00 [INF] CORS policy execution successful.
2026-01-09 18:58:29.809 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41239 - 204 null null 0.2683ms
2026-01-09 18:58:29.868 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-09 18:58:29.868 +00:00 [INF] CORS policy execution successful.
2026-01-09 18:58:29.868 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3034ms
2026-01-09 18:58:29.877 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41239 - application/json 105
2026-01-09 18:58:29.877 +00:00 [INF] CORS policy execution successful.
2026-01-09 18:58:29.877 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-09 18:58:29.879 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 18:58:29.928 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-09 18:58:29.929 +00:00 [INF] CORS policy execution successful.
2026-01-09 18:58:29.929 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-09 18:58:29.955 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 18:58:29.955 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 18:58:29.955 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 18:58:29.955 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-09 18:58:29.955 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 26.8599ms
2026-01-09 18:58:30.057 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2026-01-09 18:58:30.059 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35);
INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
OUTPUT INSERTED.[Id]
VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47);
2026-01-09 18:58:30.061 +00:00 [INF] Setting HTTP status code 201.
2026-01-09 18:58:30.062 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-09 18:58:30.062 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41239 - 201 0 null 184.7344ms
2026-01-09 20:29:25.235 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/sara - null null
2026-01-09 20:29:25.235 +00:00 [INF] CORS policy execution successful.
2026-01-09 20:29:25.235 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/sara - 204 null null 0.3488ms
2026-01-09 20:29:25.296 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/sara - null null
2026-01-09 20:29:25.296 +00:00 [INF] CORS policy execution successful.
2026-01-09 20:29:25.296 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 20:29:25.576 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 20:29:25.583 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 20:29:25.583 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 20:29:25.583 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 20:29:25.584 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/sara - 200 null application/json; charset=utf-8 288.0715ms
2026-01-09 20:29:32.114 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-09 20:29:32.115 +00:00 [INF] CORS policy execution successful.
2026-01-09 20:29:32.115 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.2546ms
2026-01-09 20:29:32.174 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2026-01-09 20:29:32.174 +00:00 [INF] CORS policy execution successful.
2026-01-09 20:29:32.175 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-09 20:29:32.179 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2026-01-09 20:29:32.183 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2026-01-09 20:29:32.184 +00:00 [INF] Setting HTTP status code 201.
2026-01-09 20:29:32.184 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-09 20:29:32.184 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-09 20:29:32.184 +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.5107ms
2026-01-09 20:29:32.242 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41240 - null null
2026-01-09 20:29:32.242 +00:00 [INF] CORS policy execution successful.
2026-01-09 20:29:32.242 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41240 - 204 null null 0.2631ms
2026-01-09 20:29:32.299 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-09 20:29:32.300 +00:00 [INF] CORS policy execution successful.
2026-01-09 20:29:32.300 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.7452ms
2026-01-09 20:29:32.304 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41240 - application/json 105
2026-01-09 20:29:32.304 +00:00 [INF] CORS policy execution successful.
2026-01-09 20:29:32.305 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-09 20:29:32.306 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 20:29:32.355 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-09 20:29:32.355 +00:00 [INF] CORS policy execution successful.
2026-01-09 20:29:32.356 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-09 20:29:32.369 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 20:29:32.370 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 20:29:32.370 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 20:29:32.370 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-09 20:29:32.370 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 15.6285ms
2026-01-09 20:29:32.467 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2026-01-09 20:29:32.470 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35);
INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
OUTPUT INSERTED.[Id]
VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47);
2026-01-09 20:29:32.474 +00:00 [INF] Setting HTTP status code 201.
2026-01-09 20:29:32.475 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-09 20:29:32.475 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41240 - 201 0 null 170.643ms
2026-01-09 21:08:43.720 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/SA - null null
2026-01-09 21:08:43.720 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:08:43.720 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/SA - 204 null null 0.2634ms
2026-01-09 21:08:43.780 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/SA - null null
2026-01-09 21:08:43.780 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:08:43.780 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 21:08:44.030 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 21:08:44.062 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 21:08:44.063 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 21:08:44.344 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 21:08:44.345 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/SA - 200 null application/json; charset=utf-8 564.6898ms
2026-01-09 21:08:44.949 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/L - null null
2026-01-09 21:08:44.950 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:08:44.950 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/L - 204 null null 0.3053ms
2026-01-09 21:08:45.006 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/L - null null
2026-01-09 21:08:45.007 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:08:45.007 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 21:08:45.010 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 21:08:45.153 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 21:08:45.153 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 21:08:45.442 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 21:08:45.442 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/L - 200 null application/json; charset=utf-8 435.9489ms
2026-01-09 21:08:47.569 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/SAL - null null
2026-01-09 21:08:47.570 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:08:47.571 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/SAL - 204 null null 1.3452ms
2026-01-09 21:08:47.629 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/SAL - null null
2026-01-09 21:08:47.629 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:08:47.630 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 21:08:47.632 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 21:08:47.645 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 21:08:47.646 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 21:08:47.646 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 21:08:47.646 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/SAL - 200 null application/json; charset=utf-8 17.3895ms
2026-01-09 21:08:54.408 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/177 - null null
2026-01-09 21:08:54.408 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:08:54.408 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/177 - 204 null null 0.2633ms
2026-01-09 21:08:54.468 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/177 - null null
2026-01-09 21:08:54.468 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:08:54.468 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2026-01-09 21:08:54.470 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2026-01-09 21:08:54.471 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 21:08:54.471 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json.
2026-01-09 21:08:54.471 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2026-01-09 21:08:54.471 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/177 - 200 null application/json; charset=utf-8 3.8818ms
2026-01-09 21:09:02.766 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/177 - null null
2026-01-09 21:09:02.766 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:09:02.766 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/177 - 204 null null 0.3352ms
2026-01-09 21:09:02.826 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/177 - null null
2026-01-09 21:09:02.826 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:09:02.827 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2026-01-09 21:09:02.830 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2026-01-09 21:09:02.831 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 21:09:02.831 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json.
2026-01-09 21:09:02.832 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2026-01-09 21:09:02.832 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/177 - 200 null application/json; charset=utf-8 6.0584ms
2026-01-09 21:09:09.668 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/429 - null null
2026-01-09 21:09:09.668 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:09:09.669 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/429 - 204 null null 1.0708ms
2026-01-09 21:09:09.724 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/429 - null null
2026-01-09 21:09:09.725 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:09:09.725 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2026-01-09 21:09:09.728 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2026-01-09 21:09:09.729 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 21:09:09.729 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json.
2026-01-09 21:09:09.729 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2026-01-09 21:09:09.729 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/429 - 200 null application/json; charset=utf-8 4.9862ms
2026-01-09 21:09:21.561 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/FLOR DE JAMAICA - null null
2026-01-09 21:09:21.562 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:09:21.562 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/FLOR DE JAMAICA - 204 null null 0.3012ms
2026-01-09 21:09:21.619 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/FLOR DE JAMAICA - null null
2026-01-09 21:09:21.620 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:09:21.620 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 21:09:21.623 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 21:09:21.627 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 21:09:21.627 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 21:09:21.627 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 21:09:21.628 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/FLOR DE JAMAICA - 200 null application/json; charset=utf-8 8.1989ms
2026-01-09 21:10:49.824 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ACEITE DE OREGANO - null null
2026-01-09 21:10:49.824 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:10:49.824 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ACEITE DE OREGANO - 204 null null 0.4522ms
2026-01-09 21:10:49.885 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ACEITE DE OREGANO - null null
2026-01-09 21:10:49.885 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:10:49.886 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 21:10:49.889 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 21:10:49.893 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 21:10:49.893 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 21:10:49.893 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 21:10:49.893 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ACEITE DE OREGANO - 200 null application/json; charset=utf-8 7.9981ms
2026-01-09 21:11:59.629 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-09 21:11:59.629 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:11:59.629 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3322ms
2026-01-09 21:11:59.684 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-09 21:11:59.684 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:11:59.685 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-09 21:11:59.687 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 21:11:59.687 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 21:11:59.687 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 21:11:59.687 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-09 21:11:59.687 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 3.392ms
2026-01-09 21:12:05.397 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/SAL MARINA - null null
2026-01-09 21:12:05.397 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:12:05.397 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/SAL MARINA - 204 null null 0.4226ms
2026-01-09 21:12:05.457 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/SAL MARINA - null null
2026-01-09 21:12:05.457 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:12:05.457 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 21:12:05.460 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 21:12:05.463 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 21:12:05.463 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 21:12:05.464 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 21:12:05.464 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/SAL MARINA - 200 null application/json; charset=utf-8 7.4265ms
2026-01-09 21:12:09.796 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/177 - null null
2026-01-09 21:12:09.796 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:12:09.796 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/177 - 204 null null 0.3865ms
2026-01-09 21:12:09.856 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/177 - null null
2026-01-09 21:12:09.856 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:12:09.856 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2026-01-09 21:12:09.858 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2026-01-09 21:12:09.859 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 21:12:09.860 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json.
2026-01-09 21:12:09.860 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2026-01-09 21:12:09.860 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/177 - 200 null application/json; charset=utf-8 4.4977ms
2026-01-09 21:12:10.545 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/429 - null null
2026-01-09 21:12:10.545 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:12:10.545 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/429 - 204 null null 0.2699ms
2026-01-09 21:12:10.605 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/429 - null null
2026-01-09 21:12:10.605 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:12:10.606 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2026-01-09 21:12:10.608 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2026-01-09 21:12:10.609 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 21:12:10.609 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json.
2026-01-09 21:12:10.609 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2026-01-09 21:12:10.610 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/429 - 200 null application/json; charset=utf-8 4.5352ms
2026-01-09 21:12:17.544 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/FLOR DE JAMAICA - null null
2026-01-09 21:12:17.544 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:12:17.544 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/FLOR DE JAMAICA - 204 null null 0.2953ms
2026-01-09 21:12:17.605 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/FLOR DE JAMAICA - null null
2026-01-09 21:12:17.605 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:12:17.605 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 21:12:17.609 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 21:12:17.610 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 21:12:17.610 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 21:12:17.611 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 21:12:17.611 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/FLOR DE JAMAICA - 200 null application/json; charset=utf-8 5.8392ms
2026-01-09 21:13:06.183 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-09 21:13:06.184 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:13:06.184 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3955ms
2026-01-09 21:13:06.243 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 179
2026-01-09 21:13:06.244 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:13:06.244 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-09 21:13:06.248 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2026-01-09 21:13:06.253 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2026-01-09 21:13:06.253 +00:00 [INF] Setting HTTP status code 201.
2026-01-09 21:13:06.254 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-09 21:13:06.254 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-09 21:13:06.254 +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.1084ms
2026-01-09 21:13:06.313 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41241 - null null
2026-01-09 21:13:06.313 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:13:06.313 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41241 - 204 null null 0.2529ms
2026-01-09 21:13:06.373 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-09 21:13:06.373 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:13:06.374 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3471ms
2026-01-09 21:13:06.393 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41241 - application/json 307
2026-01-09 21:13:06.394 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:13:06.394 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-09 21:13:06.396 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 21:13:06.430 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-09 21:13:06.430 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:13:06.430 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-09 21:13:06.449 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 21:13:06.450 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 21:13:06.450 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 21:13:06.450 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-09 21:13:06.450 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 20.931ms
2026-01-09 21:13:06.561 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2026-01-09 21:13:06.566 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p40='?' (DbType = Int32), @p23='?' (Size = 4000), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Int32), @p26='?' (DbType = Guid), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Boolean), @p29='?' (DbType = DateTime2), @p30='?' (DbType = Int32), @p31='?' (Size = 150), @p32='?' (Size = 500), @p33='?' (Size = -1) (DbType = Binary), @p34='?' (DbType = Int32), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p36='?' (Size = 4000), @p37='?' (DbType = Int32), @p38='?' (DbType = Guid), @p39='?' (DbType = DateTime2), @p58='?' (DbType = Int32), @p41='?' (Size = 4000), @p42='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p43='?' (DbType = Int32), @p44='?' (DbType = Guid), @p45='?' (DbType = DateTime2), @p46='?' (DbType = Boolean), @p47='?' (DbType = DateTime2), @p48='?' (DbType = Int32), @p49='?' (Size = 150), @p50='?' (Size = 500), @p51='?' (Size = -1) (DbType = Binary), @p52='?' (DbType = Int32), @p53='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p54='?' (Size = 4000), @p55='?' (DbType = Int32), @p56='?' (DbType = Guid), @p57='?' (DbType = DateTime2), @p59='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p60='?' (DbType = Guid), @p61='?' (DbType = DateTime2), @p62='?' (DbType = Boolean), @p63='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p64='?' (DbType = Int32), @p65='?' (DbType = Int32), @p66='?' (DbType = Int64), @p67='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p68='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p69='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p70='?' (DbType = Guid), @p71='?' (DbType = DateTime2), @p72='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p73='?' (DbType = Guid), @p74='?' (DbType = DateTime2), @p75='?' (DbType = Boolean), @p76='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p77='?' (DbType = Int32), @p78='?' (DbType = Int32), @p79='?' (DbType = Int64), @p80='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p81='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p82='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p83='?' (DbType = Guid), @p84='?' (DbType = DateTime2), @p85='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p86='?' (DbType = Guid), @p87='?' (DbType = DateTime2), @p88='?' (DbType = Boolean), @p89='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p90='?' (DbType = Int32), @p91='?' (DbType = Int32), @p92='?' (DbType = Int64), @p93='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p94='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p95='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p96='?' (DbType = Guid), @p97='?' (DbType = DateTime2), @p98='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p99='?' (DbType = Guid), @p100='?' (DbType = DateTime2), @p101='?' (DbType = Int32), @p102='?' (Size = 34), @p103='?' (DbType = Guid), @p104='?' (DbType = Int32), @p105='?' (DbType = Int32), @p106='?' (DbType = Int32), @p107='?' (Size = 4000), @p108='?' (Size = 4000), @p109='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p110='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p111='?' (DbType = Guid), @p112='?' (DbType = DateTime2), @p113='?' (DbType = Int32), @p114='?' (Size = 34), @p115='?' (DbType = Guid), @p116='?' (DbType = Int32), @p117='?' (DbType = Int32), @p118='?' (DbType = Int32), @p119='?' (Size = 4000), @p120='?' (Size = 4000), @p121='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p122='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p123='?' (DbType = Guid), @p124='?' (DbType = DateTime2), @p125='?' (DbType = Int32), @p126='?' (Size = 34), @p127='?' (DbType = Guid), @p128='?' (DbType = Int32), @p129='?' (DbType = Int32), @p130='?' (DbType = Int32), @p131='?' (Size = 4000), @p132='?' (Size = 4000), @p133='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
UPDATE [Products] SET [BarCode] = @p23, [BuyPrice] = @p24, [CategoryId] = @p25, [CreatedById] = @p26, [CreatedDate] = @p27, [DeleteFlag] = @p28, [ExpirationDate] = @p29, [MinimunStock] = @p30, [Name] = @p31, [Note] = @p32, [ProductImage] = @p33, [ProductTaxId] = @p34, [SalePrice] = @p35, [Status] = @p36, [Stock] = @p37, [UpdatedById] = @p38, [UpdatedDate] = @p39
OUTPUT 1
WHERE [Id] = @p40;
UPDATE [Products] SET [BarCode] = @p41, [BuyPrice] = @p42, [CategoryId] = @p43, [CreatedById] = @p44, [CreatedDate] = @p45, [DeleteFlag] = @p46, [ExpirationDate] = @p47, [MinimunStock] = @p48, [Name] = @p49, [Note] = @p50, [ProductImage] = @p51, [ProductTaxId] = @p52, [SalePrice] = @p53, [Status] = @p54, [Stock] = @p55, [UpdatedById] = @p56, [UpdatedDate] = @p57
OUTPUT 1
WHERE [Id] = @p58;
MERGE [SalesDetail] USING (
VALUES (@p59, @p60, @p61, @p62, @p63, @p64, @p65, @p66, @p67, @p68, @p69, @p70, @p71, 0),
(@p72, @p73, @p74, @p75, @p76, @p77, @p78, @p79, @p80, @p81, @p82, @p83, @p84, 1),
(@p85, @p86, @p87, @p88, @p89, @p90, @p91, @p92, @p93, @p94, @p95, @p96, @p97, 2)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[DeleteFlag], i.[DiscountAmount], i.[ProductId], i.[Quantity], i.[SalesId], i.[Tax], i.[Total], i.[UnitPrice], i.[UpdatedById], i.[UpdatedDate])
OUTPUT INSERTED.[Id], i._Position;
MERGE [InventoryMovements] USING (
VALUES (@p98, @p99, @p100, @p101, @p102, @p103, @p104, @p105, @p106, @p107, @p108, @p109, 0),
(@p110, @p111, @p112, @p113, @p114, @p115, @p116, @p117, @p118, @p119, @p120, @p121, 1),
(@p122, @p123, @p124, @p125, @p126, @p127, @p128, @p129, @p130, @p131, @p132, @p133, 2)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[Difference], i.[Discriminator], i.[InventoryMovementHeaderId], i.[NewStock], i.[OriginaStock], i.[ProductId], i.[ProductName], i.[Reazon], i.[SalePrice])
OUTPUT INSERTED.[Id], i._Position;
2026-01-09 21:13:06.571 +00:00 [INF] Setting HTTP status code 201.
2026-01-09 21:13:06.571 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-09 21:13:06.571 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41241 - 201 0 null 177.7849ms
2026-01-09 21:13:54.293 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ACEITE OREGANO - null null
2026-01-09 21:13:54.293 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:13:54.294 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ACEITE OREGANO - 204 null null 0.3644ms
2026-01-09 21:13:54.353 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ACEITE OREGANO - null null
2026-01-09 21:13:54.353 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:13:54.354 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 21:13:54.357 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 21:13:54.359 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 21:13:54.359 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 21:13:54.359 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 21:13:54.359 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ACEITE OREGANO - 200 null application/json; charset=utf-8 6.0761ms
2026-01-09 21:14:02.516 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/OREGANBO - null null
2026-01-09 21:14:02.517 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:14:02.517 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/OREGANBO - 204 null null 1.1358ms
2026-01-09 21:14:02.580 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/OREGANBO - null null
2026-01-09 21:14:02.581 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:14:02.581 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 21:14:02.587 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 21:14:02.587 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 21:14:02.587 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 21:14:02.588 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 21:14:02.588 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/OREGANBO - 200 null application/json; charset=utf-8 7.2138ms
2026-01-09 21:14:05.252 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/OR - null null
2026-01-09 21:14:05.252 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:14:05.252 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/OR - 204 null null 0.3982ms
2026-01-09 21:14:05.311 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/OR - null null
2026-01-09 21:14:05.311 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:14:05.311 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 21:14:05.314 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 21:14:05.342 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 21:14:05.342 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 21:14:05.626 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 21:14:05.626 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/OR - 200 null application/json; charset=utf-8 315.6094ms
2026-01-09 21:14:11.205 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/OREGANO - null null
2026-01-09 21:14:11.206 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:14:11.206 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/OREGANO - 204 null null 0.9993ms
2026-01-09 21:14:11.269 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/OREGANO - null null
2026-01-09 21:14:11.270 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:14:11.270 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 21:14:11.273 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 21:14:11.277 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 21:14:11.277 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 21:14:11.278 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 21:14:11.278 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/OREGANO - 200 null application/json; charset=utf-8 8.3448ms
2026-01-09 21:14:40.947 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-09 21:14:40.947 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:14:40.947 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3285ms
2026-01-09 21:14:41.013 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 191
2026-01-09 21:14:41.013 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:14:41.014 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-09 21:14:41.018 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2026-01-09 21:14:41.022 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2026-01-09 21:14:41.022 +00:00 [INF] Setting HTTP status code 201.
2026-01-09 21:14:41.022 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-09 21:14:41.022 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-09 21:14:41.023 +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.2837ms
2026-01-09 21:14:41.089 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41242 - null null
2026-01-09 21:14:41.089 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:14:41.089 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41242 - 204 null null 0.3427ms
2026-01-09 21:14:41.093 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-09 21:14:41.093 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:14:41.093 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2914ms
2026-01-09 21:14:41.145 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41242 - application/json 111
2026-01-09 21:14:41.145 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:14:41.145 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-09 21:14:41.147 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 21:14:41.153 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-09 21:14:41.153 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:14:41.153 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-09 21:14:41.156 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 21:14:41.156 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 21:14:41.157 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 21:14:41.157 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-09 21:14:41.157 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 4.3768ms
2026-01-09 21:14:41.286 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2026-01-09 21:14:41.288 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35);
INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
OUTPUT INSERTED.[Id]
VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47);
2026-01-09 21:14:41.292 +00:00 [INF] Setting HTTP status code 201.
2026-01-09 21:14:41.292 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-09 21:14:41.292 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41242 - 201 0 null 147.5389ms
2026-01-09 21:21:00.462 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/aceite - null null
2026-01-09 21:21:00.462 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:21:00.463 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/aceite - 204 null null 0.3072ms
2026-01-09 21:21:00.532 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/aceite - null null
2026-01-09 21:21:00.533 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:21:00.533 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 21:21:00.777 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-09 21:21:00.795 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 21:21:00.796 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 21:21:01.028 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-09 21:21:01.028 +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 496.1485ms
2026-01-09 21:23:16.932 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-09 21:23:16.932 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:23:16.932 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3423ms
2026-01-09 21:23:16.992 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 179
2026-01-09 21:23:16.992 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:23:16.992 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-09 21:23:16.997 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2026-01-09 21:23:17.001 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2026-01-09 21:23:17.002 +00:00 [INF] Setting HTTP status code 201.
2026-01-09 21:23:17.002 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-09 21:23:17.002 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-09 21:23:17.002 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 10.0741ms
2026-01-09 21:23:17.061 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41243 - null null
2026-01-09 21:23:17.061 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:23:17.062 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41243 - 204 null null 1.0911ms
2026-01-09 21:23:17.118 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-09 21:23:17.118 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:23:17.118 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3091ms
2026-01-09 21:23:17.122 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41243 - application/json 103
2026-01-09 21:23:17.122 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:23:17.122 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-09 21:23:17.125 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 21:23:17.180 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-09 21:23:17.181 +00:00 [INF] CORS policy execution successful.
2026-01-09 21:23:17.182 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-09 21:23:17.203 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-09 21:23:17.204 +00:00 [INF] Setting HTTP status code 200.
2026-01-09 21:23:17.204 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-09 21:23:17.204 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-09 21:23:17.204 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 24.0738ms
2026-01-09 21:23:17.323 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2026-01-09 21:23:17.326 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35);
INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
OUTPUT INSERTED.[Id]
VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47);
2026-01-09 21:23:17.329 +00:00 [INF] Setting HTTP status code 201.
2026-01-09 21:23:17.330 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-09 21:23:17.330 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41243 - 201 0 null 208.0991ms