2026-01-22 02:59:34.030 +00:00 [INF] Request starting HTTP/1.1 GET http://localhost:5227/.env - null null
2026-01-22 02:59:34.037 +00:00 [INF] Request finished HTTP/1.1 GET http://localhost:5227/.env - 404 0 null 7.2212ms
2026-01-22 02:59:34.038 +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-22 02:59:45.228 +00:00 [INF] Request starting HTTP/1.1 GET http://localhost:5227/config/default.yml - null null
2026-01-22 02:59:45.229 +00:00 [INF] Request finished HTTP/1.1 GET http://localhost:5227/config/default.yml - 404 0 null 0.9619ms
2026-01-22 02:59:45.229 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://localhost:5227/config/default.yml, Response status code: 404
2026-01-22 02:59:56.108 +00:00 [INF] Request starting HTTP/1.1 GET http://localhost:5227/config/development.yml - null null
2026-01-22 02:59:56.108 +00:00 [INF] Request finished HTTP/1.1 GET http://localhost:5227/config/development.yml - 404 0 null 0.4825ms
2026-01-22 02:59:56.109 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://localhost:5227/config/development.yml, Response status code: 404
2026-01-22 05:07:48.453 +00:00 [INF] Request starting HTTP/1.0 GET http:/// - null null
2026-01-22 05:07:48.455 +00:00 [INF] Request finished HTTP/1.0 GET http:/// - 404 0 null 2.4226ms
2026-01-22 05:07:48.455 +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-22 06:11:57.557 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2026-01-22 06:11:57.559 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 2.6792ms
2026-01-22 06:11:57.559 +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-22 08:17:08.317 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2026-01-22 08:17:08.319 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 1.9044ms
2026-01-22 08:17:08.319 +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-22 08:17:18.465 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2026-01-22 08:17:18.465 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.4989ms
2026-01-22 08:17:18.465 +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-22 08:17:25.451 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/login - null null
2026-01-22 08:17:25.451 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/login - 404 0 null 0.3305ms
2026-01-22 08:17:25.451 +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-22 08:59:14.082 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2026-01-22 08:59:14.083 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 2.2502ms
2026-01-22 08:59:14.084 +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-22 09:00:04.817 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/security.txt - null null
2026-01-22 09:00:04.818 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/security.txt - 404 0 null 0.4569ms
2026-01-22 09:00:04.818 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/security.txt, Response status code: 404
2026-01-22 12:19:26.469 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null
2026-01-22 12:19:26.471 +00:00 [INF] CORS policy execution successful.
2026-01-22 12:19:26.471 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 2.4429ms
2026-01-22 12:19:26.541 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 65
2026-01-22 12:19:26.541 +00:00 [INF] CORS policy execution successful.
2026-01-22 12:19:26.542 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin'
2026-01-22 12:19:26.959 +00:00 [INF] Executed DbCommand (60ms) [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-22 12:19:27.092 +00:00 [INF] Executed DbCommand (8ms) [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-22 12:19:27.094 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 12:19:27.094 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json.
2026-01-22 12:19:27.094 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin'
2026-01-22 12:19:27.094 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 553.6901ms
2026-01-22 12:34:02.836 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null
2026-01-22 12:34:02.837 +00:00 [INF] CORS policy execution successful.
2026-01-22 12:34:02.836 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2026-01-22 12:34:02.837 +00:00 [INF] CORS policy execution successful.
2026-01-22 12:34:02.837 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.6095ms
2026-01-22 12:34:02.837 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 1.0021ms
2026-01-22 12:34:02.838 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-22 12:34:02.838 +00:00 [INF] CORS policy execution successful.
2026-01-22 12:34:02.838 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.1271ms
2026-01-22 12:34:02.842 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null
2026-01-22 12:34:02.843 +00:00 [INF] CORS policy execution successful.
2026-01-22 12:34:02.843 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.5819ms
2026-01-22 12:34:02.894 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null
2026-01-22 12:34:02.894 +00:00 [INF] CORS policy execution successful.
2026-01-22 12:34:02.896 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-22 12:34:02.896 +00:00 [INF] CORS policy execution successful.
2026-01-22 12:34:02.897 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2026-01-22 12:34:02.897 +00:00 [INF] CORS policy execution successful.
2026-01-22 12:34:02.900 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2026-01-22 12:34:02.900 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-22 12:34:02.900 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/'
2026-01-22 12:34:02.906 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null
2026-01-22 12:34:02.906 +00:00 [INF] CORS policy execution successful.
2026-01-22 12:34:02.907 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities'
2026-01-22 12:34:03.304 +00:00 [INF] Executed DbCommand (12ms) [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-22 12:34:03.307 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 12:34:03.307 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 12:34:03.307 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-22 12:34:03.307 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 411.0506ms
2026-01-22 12:34:03.324 +00:00 [INF] Executed DbCommand (8ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [ProductTaxes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-22 12:34:03.325 +00:00 [INF] Executed DbCommand (8ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate]
FROM [Settings] AS [s]
2026-01-22 12:34:03.326 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 12:34:03.326 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 12:34:03.326 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 12:34:03.326 +00:00 [INF] Writing value of type 'SettingDto' as Json.
2026-01-22 12:34:03.326 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/'
2026-01-22 12:34:03.327 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 433.0559ms
2026-01-22 12:34:03.327 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2026-01-22 12:34:03.327 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 430.5719ms
2026-01-22 12:34:03.335 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [n].[Id], [n].[Descripcion], [n].[Estatus], [n].[Gentilicio], [n].[Siglas]
FROM [Nationalities] AS [n]
2026-01-22 12:34:03.337 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 12:34:03.337 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 12:34:03.337 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities'
2026-01-22 12:34:03.338 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 431.8332ms
2026-01-22 12:34:05.892 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - null null
2026-01-22 12:34:05.892 +00:00 [INF] CORS policy execution successful.
2026-01-22 12:34:05.892 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - 204 null null 0.2963ms
2026-01-22 12:34:05.947 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan - null null
2026-01-22 12:34:05.947 +00:00 [INF] CORS policy execution successful.
2026-01-22 12:34:05.949 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 12:34:05.966 +00:00 [INF] Executed DbCommand (11ms) [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-22 12:34:05.974 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 12:34:05.974 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 12:34:06.086 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 12:34:06.087 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan - 200 null application/json; charset=utf-8 139.4591ms
2026-01-22 14:55:30.967 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2026-01-22 14:55:30.969 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 2.2633ms
2026-01-22 14:55:30.970 +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-22 15:16:48.618 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-22 15:16:48.619 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:16:48.619 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3066ms
2026-01-22 15:16:48.677 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 179
2026-01-22 15:16:48.677 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:16:48.682 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-22 15:16:49.048 +00:00 [INF] Executed DbCommand (32ms) [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-22 15:16:49.059 +00:00 [INF] Executed DbCommand (9ms) [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-22 15:16:49.059 +00:00 [INF] Setting HTTP status code 201.
2026-01-22 15:16:49.059 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-22 15:16:49.059 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-22 15:16:49.059 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 382.4408ms
2026-01-22 15:16:49.121 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41326 - null null
2026-01-22 15:16:49.121 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:16:49.121 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41326 - 204 null null 0.28ms
2026-01-22 15:16:49.177 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-22 15:16:49.178 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:16:49.178 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3291ms
2026-01-22 15:16:49.191 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41326 - application/json 104
2026-01-22 15:16:49.191 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:16:49.191 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-22 15:16:49.201 +00:00 [INF] Executed DbCommand (8ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-22 15:16:49.233 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-22 15:16:49.233 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:16:49.234 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-22 15:16:49.252 +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-22 15:16:49.253 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 15:16:49.254 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 15:16:49.254 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-22 15:16:49.254 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 21.1264ms
2026-01-22 15:16:49.390 +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-22 15:16:49.409 +00:00 [INF] Executed DbCommand (19ms) [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-22 15:16:49.415 +00:00 [INF] Setting HTTP status code 201.
2026-01-22 15:16:49.415 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-22 15:16:49.415 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41326 - 201 0 null 224.9337ms
2026-01-22 15:17:46.155 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/1 - null null
2026-01-22 15:17:46.156 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:17:46.156 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/1 - 204 null null 0.2781ms
2026-01-22 15:17:46.215 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/1 - null null
2026-01-22 15:17:46.216 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:17:46.216 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 15:17:46.223 +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-22 15:17:46.248 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 15:17:46.248 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 15:17:47.286 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 15:17:47.287 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/1 - 200 null application/json; charset=utf-8 1071.8504ms
2026-01-22 15:21:03.961 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/dra - null null
2026-01-22 15:21:03.962 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:21:03.962 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/dra - 204 null null 0.3301ms
2026-01-22 15:21:04.024 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/dra - null null
2026-01-22 15:21:04.024 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:21:04.025 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 15:21:04.028 +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-22 15:21:04.038 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 15:21:04.039 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 15:21:04.265 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 15:21:04.265 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/dra - 200 null application/json; charset=utf-8 240.9019ms
2026-01-22 15:21:24.887 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-22 15:21:24.888 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:21:24.888 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.4102ms
2026-01-22 15:21:24.948 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2026-01-22 15:21:24.948 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:21:24.948 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-22 15:21:24.954 +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-22 15:21:24.958 +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-22 15:21:24.959 +00:00 [INF] Setting HTTP status code 201.
2026-01-22 15:21:24.960 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-22 15:21:24.960 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-22 15:21:24.960 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 12.5109ms
2026-01-22 15:21:25.023 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41327 - null null
2026-01-22 15:21:25.023 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:21:25.023 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41327 - 204 null null 0.4355ms
2026-01-22 15:21:25.080 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-22 15:21:25.080 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:21:25.080 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3441ms
2026-01-22 15:21:25.081 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41327 - application/json 106
2026-01-22 15:21:25.081 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:21:25.081 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-22 15:21:25.084 +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-22 15:21:25.138 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-22 15:21:25.138 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:21:25.139 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-22 15:21:25.143 +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-22 15:21:25.143 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 15:21:25.144 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 15:21:25.144 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-22 15:21:25.144 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 6.4962ms
2026-01-22 15:21:25.293 +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-22 15:21:25.298 +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), @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-22 15:21:25.303 +00:00 [INF] Setting HTTP status code 201.
2026-01-22 15:21:25.304 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-22 15:21:25.304 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41327 - 201 0 null 223.4895ms
2026-01-22 15:57:09.749 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/oxituca - null null
2026-01-22 15:57:09.750 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:57:09.751 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/oxituca - 204 null null 1.3294ms
2026-01-22 15:57:09.817 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/oxituca - null null
2026-01-22 15:57:09.817 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:57:09.823 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 15:57:10.164 +00:00 [INF] Executed DbCommand (15ms) [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-22 15:57:10.166 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 15:57:10.166 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 15:57:10.166 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 15:57:10.167 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/oxituca - 200 null application/json; charset=utf-8 349.3609ms
2026-01-22 15:57:17.996 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Oxidativa - null null
2026-01-22 15:57:17.996 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:57:17.996 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Oxidativa - 204 null null 0.3371ms
2026-01-22 15:57:18.056 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/Oxidativa - null null
2026-01-22 15:57:18.056 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:57:18.056 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 15:57:18.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-22 15:57:18.063 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 15:57:18.064 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 15:57:18.064 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 15:57:18.064 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/Oxidativa - 200 null application/json; charset=utf-8 8.4675ms
2026-01-22 15:57:27.481 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/hojuela - null null
2026-01-22 15:57:27.481 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:57:27.481 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/hojuela - 204 null null 0.3069ms
2026-01-22 15:57:27.543 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/hojuela - null null
2026-01-22 15:57:27.544 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:57:27.544 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 15:57:27.549 +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-22 15:57:27.549 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 15:57:27.550 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 15:57:27.550 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 15:57:27.550 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/hojuela - 200 null application/json; charset=utf-8 7.1207ms
2026-01-22 15:57:32.516 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-22 15:57:32.516 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:57:32.516 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3767ms
2026-01-22 15:57:32.576 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2026-01-22 15:57:32.577 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:57:32.577 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-22 15:57:32.585 +00:00 [INF] Executed DbCommand (6ms) [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-22 15:57:32.589 +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-22 15:57:32.589 +00:00 [INF] Setting HTTP status code 201.
2026-01-22 15:57:32.589 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-22 15:57:32.589 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-22 15:57:32.589 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 12.9104ms
2026-01-22 15:57:32.652 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41328 - null null
2026-01-22 15:57:32.653 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:57:32.653 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41328 - 204 null null 0.3545ms
2026-01-22 15:57:32.723 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41328 - application/json 206
2026-01-22 15:57:32.723 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:57:32.724 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-22 15:57:32.724 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-22 15:57:32.724 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:57:32.724 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.1866ms
2026-01-22 15:57:32.727 +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-22 15:57:32.782 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-22 15:57:32.783 +00:00 [INF] CORS policy execution successful.
2026-01-22 15:57:32.783 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-22 15:57:32.806 +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-22 15:57:32.806 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 15:57:32.806 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 15:57:32.807 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-22 15:57:32.807 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 24.6932ms
2026-01-22 15:57:32.905 +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-22 15:57:32.970 +00:00 [INF] Executed DbCommand (64ms) [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-22 15:57:32.975 +00:00 [INF] Setting HTTP status code 201.
2026-01-22 15:57:32.975 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-22 15:57:32.975 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41328 - 201 0 null 252.0605ms
2026-01-22 16:01:26.703 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/po - null null
2026-01-22 16:01:26.703 +00:00 [INF] CORS policy execution successful.
2026-01-22 16:01:26.703 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/po - 204 null null 0.3433ms
2026-01-22 16:01:26.763 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/po - null null
2026-01-22 16:01:26.763 +00:00 [INF] CORS policy execution successful.
2026-01-22 16:01:26.764 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 16:01:26.766 +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-22 16:01:26.791 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 16:01:26.791 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 16:01:27.074 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 16:01:27.074 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/po - 200 null application/json; charset=utf-8 311.2829ms
2026-01-22 16:01:32.288 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/o - null null
2026-01-22 16:01:32.289 +00:00 [INF] CORS policy execution successful.
2026-01-22 16:01:32.289 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/o - 204 null null 0.4383ms
2026-01-22 16:01:32.345 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/o - null null
2026-01-22 16:01:32.345 +00:00 [INF] CORS policy execution successful.
2026-01-22 16:01:32.345 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 16:01:32.348 +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-22 16:01:32.490 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 16:01:32.491 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 16:01:33.056 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 16:01:33.057 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/o - 200 null application/json; charset=utf-8 711.8208ms
2026-01-22 16:01:35.611 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/po - null null
2026-01-22 16:01:35.611 +00:00 [INF] CORS policy execution successful.
2026-01-22 16:01:35.611 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/po - 204 null null 0.3854ms
2026-01-22 16:01:35.671 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/po - null null
2026-01-22 16:01:35.671 +00:00 [INF] CORS policy execution successful.
2026-01-22 16:01:35.672 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 16:01:35.675 +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-22 16:01:35.696 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 16:01:35.697 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 16:01:35.699 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 16:01:35.699 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/po - 200 null application/json; charset=utf-8 28.1882ms
2026-01-22 16:01:42.759 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/potassium - null null
2026-01-22 16:01:42.760 +00:00 [INF] CORS policy execution successful.
2026-01-22 16:01:42.760 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/potassium - 204 null null 0.3074ms
2026-01-22 16:01:42.819 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/potassium - null null
2026-01-22 16:01:42.820 +00:00 [INF] CORS policy execution successful.
2026-01-22 16:01:42.820 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 16:01:42.825 +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-22 16:01:42.825 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 16:01:42.825 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 16:01:42.825 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 16:01:42.825 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/potassium - 200 null application/json; charset=utf-8 5.6682ms
2026-01-22 16:01:50.518 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ptasio - null null
2026-01-22 16:01:50.518 +00:00 [INF] CORS policy execution successful.
2026-01-22 16:01:50.518 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ptasio - 204 null null 0.3389ms
2026-01-22 16:01:50.577 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ptasio - null null
2026-01-22 16:01:50.578 +00:00 [INF] CORS policy execution successful.
2026-01-22 16:01:50.578 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 16:01:50.587 +00:00 [INF] Executed DbCommand (8ms) [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-22 16:01:50.588 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 16:01:50.588 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 16:01:50.588 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 16:01:50.588 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ptasio - 200 null application/json; charset=utf-8 10.9982ms
2026-01-22 16:01:54.767 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/potasio - null null
2026-01-22 16:01:54.767 +00:00 [INF] CORS policy execution successful.
2026-01-22 16:01:54.767 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/potasio - 204 null null 0.4484ms
2026-01-22 16:01:54.827 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/potasio - null null
2026-01-22 16:01:54.827 +00:00 [INF] CORS policy execution successful.
2026-01-22 16:01:54.827 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 16:01:54.830 +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-22 16:01:54.833 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 16:01:54.833 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 16:01:54.834 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 16:01:54.834 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/potasio - 200 null application/json; charset=utf-8 7.1728ms
2026-01-22 16:02:50.595 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-22 16:02:50.595 +00:00 [INF] CORS policy execution successful.
2026-01-22 16:02:50.595 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3295ms
2026-01-22 16:02:50.655 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 179
2026-01-22 16:02:50.655 +00:00 [INF] CORS policy execution successful.
2026-01-22 16:02:50.655 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-22 16:02:50.660 +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-22 16:02:50.663 +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-22 16:02:50.663 +00:00 [INF] Setting HTTP status code 201.
2026-01-22 16:02:50.663 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-22 16:02:50.663 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-22 16:02:50.663 +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.4909ms
2026-01-22 16:02:50.725 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41329 - null null
2026-01-22 16:02:50.725 +00:00 [INF] CORS policy execution successful.
2026-01-22 16:02:50.725 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41329 - 204 null null 0.8086ms
2026-01-22 16:02:50.785 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-22 16:02:50.785 +00:00 [INF] CORS policy execution successful.
2026-01-22 16:02:50.785 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.6795ms
2026-01-22 16:02:50.805 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41329 - application/json 103
2026-01-22 16:02:50.805 +00:00 [INF] CORS policy execution successful.
2026-01-22 16:02:50.806 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-22 16:02:50.808 +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-22 16:02:50.845 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-22 16:02:50.845 +00:00 [INF] CORS policy execution successful.
2026-01-22 16:02:50.845 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-22 16:02:50.848 +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-22 16:02:50.848 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 16:02:50.848 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 16:02:50.848 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-22 16:02:50.848 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 3.4423ms
2026-01-22 16:02:50.954 +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-22 16:02:50.958 +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-22 16:02:50.963 +00:00 [INF] Setting HTTP status code 201.
2026-01-22 16:02:50.963 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-22 16:02:50.964 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41329 - 201 0 null 158.9848ms
2026-01-22 16:20:25.176 +00:00 [INF] Request starting HTTP/1.1 GET http://localhost:5227/.env - null null
2026-01-22 16:20:25.177 +00:00 [INF] Request finished HTTP/1.1 GET http://localhost:5227/.env - 404 0 null 1.1687ms
2026-01-22 16:20:25.177 +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-22 16:54:43.250 +00:00 [INF] Request starting HTTP/1.0 GET http:/// - null null
2026-01-22 16:54:43.250 +00:00 [INF] Request finished HTTP/1.0 GET http:/// - 404 0 null 0.3022ms
2026-01-22 16:54:43.250 +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-22 19:45:54.072 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null
2026-01-22 19:45:54.073 +00:00 [INF] CORS policy execution successful.
2026-01-22 19:45:54.074 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 2.5089ms
2026-01-22 19:45:54.125 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 58
2026-01-22 19:45:54.126 +00:00 [INF] CORS policy execution successful.
2026-01-22 19:45:54.127 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin'
2026-01-22 19:45:54.493 +00:00 [INF] Executed DbCommand (26ms) [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-22 19:45:54.620 +00:00 [INF] Executed DbCommand (5ms) [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-22 19:45:54.622 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 19:45:54.622 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json.
2026-01-22 19:45:54.622 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin'
2026-01-22 19:45:54.622 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 497.569ms
2026-01-22 19:46:00.173 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null
2026-01-22 19:46:00.173 +00:00 [INF] CORS policy execution successful.
2026-01-22 19:46:00.174 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.3154ms
2026-01-22 19:46:00.225 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2026-01-22 19:46:00.225 +00:00 [INF] CORS policy execution successful.
2026-01-22 19:46:00.225 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.4183ms
2026-01-22 19:46:00.229 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - null null
2026-01-22 19:46:00.229 +00:00 [INF] CORS policy execution successful.
2026-01-22 19:46:00.229 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - 204 null null 0.3727ms
2026-01-22 19:46:00.241 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null
2026-01-22 19:46:00.241 +00:00 [INF] CORS policy execution successful.
2026-01-22 19:46:00.243 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/'
2026-01-22 19:46:00.273 +00:00 [INF] Executed DbCommand (14ms) [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-22 19:46:00.274 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 19:46:00.274 +00:00 [INF] Writing value of type 'SettingDto' as Json.
2026-01-22 19:46:00.274 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/'
2026-01-22 19:46:00.274 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 33.1695ms
2026-01-22 19:46:00.276 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2026-01-22 19:46:00.276 +00:00 [INF] CORS policy execution successful.
2026-01-22 19:46:00.277 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2026-01-22 19:46:00.283 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [ProductTaxes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-22 19:46:00.283 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 19:46:00.283 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 19:46:00.284 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2026-01-22 19:46:00.284 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 7.5371ms
2026-01-22 19:46:00.285 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Products - null null
2026-01-22 19:46:00.285 +00:00 [INF] CORS policy execution successful.
2026-01-22 19:46:00.286 +00:00 [INF] Executing endpoint 'HTTP: GET /products'
2026-01-22 19:46:00.316 +00:00 [INF] Executed DbCommand (28ms) [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-22 19:46:00.499 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 19:46:00.499 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 19:46:01.932 +00:00 [INF] Executed endpoint 'HTTP: GET /products'
2026-01-22 19:46:01.933 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Products - 200 null application/json; charset=utf-8 1647.765ms
2026-01-22 19:47:08.236 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/crakers - null null
2026-01-22 19:47:08.236 +00:00 [INF] CORS policy execution successful.
2026-01-22 19:47:08.237 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/crakers - 204 null null 0.3261ms
2026-01-22 19:47:08.296 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/crakers - null null
2026-01-22 19:47:08.296 +00:00 [INF] CORS policy execution successful.
2026-01-22 19:47:08.297 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 19:47:08.316 +00:00 [INF] Executed DbCommand (17ms) [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-22 19:47:08.318 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 19:47:08.318 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 19:47:08.318 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 19:47:08.318 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/crakers - 200 null application/json; charset=utf-8 22.296ms
2026-01-22 19:47:45.669 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2026-01-22 19:47:45.669 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1583 - null null
2026-01-22 19:47:45.669 +00:00 [INF] CORS policy execution successful.
2026-01-22 19:47:45.669 +00:00 [INF] CORS policy execution successful.
2026-01-22 19:47:45.669 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.3604ms
2026-01-22 19:47:45.669 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1583 - 204 null null 0.3654ms
2026-01-22 19:47:45.670 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductCategory - null null
2026-01-22 19:47:45.670 +00:00 [INF] CORS policy execution successful.
2026-01-22 19:47:45.670 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductCategory - 204 null null 0.1536ms
2026-01-22 19:47:45.720 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/1583 - null null
2026-01-22 19:47:45.720 +00:00 [INF] CORS policy execution successful.
2026-01-22 19:47:45.721 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2026-01-22 19:47:45.726 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2026-01-22 19:47:45.726 +00:00 [INF] CORS policy execution successful.
2026-01-22 19:47:45.726 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2026-01-22 19:47:45.730 +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-22 19:47:45.732 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 19:47:45.732 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 19:47:45.732 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2026-01-22 19:47:45.733 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 6.6746ms
2026-01-22 19:47:45.738 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductCategory - null null
2026-01-22 19:47:45.739 +00:00 [INF] CORS policy execution successful.
2026-01-22 19:47:45.739 +00:00 [INF] Executing endpoint 'HTTP: GET ProductCategory/'
2026-01-22 19:47:45.743 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Description], [p].[UpdatedById], [p].[UpdatedDate]
FROM [ProductCategories] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-22 19:47:45.743 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 19:47:45.743 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 19:47:45.743 +00:00 [INF] Executed endpoint 'HTTP: GET ProductCategory/'
2026-01-22 19:47:45.743 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductCategory - 200 null application/json; charset=utf-8 5.0035ms
2026-01-22 19:47:45.752 +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-22 19:47:45.753 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 19:47:45.753 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json.
2026-01-22 19:47:45.753 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2026-01-22 19:47:45.753 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/1583 - 200 null application/json; charset=utf-8 33.1023ms
2026-01-22 19:47:55.210 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1583 - null null
2026-01-22 19:47:55.210 +00:00 [INF] CORS policy execution successful.
2026-01-22 19:47:55.210 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1583 - 204 null null 0.274ms
2026-01-22 19:47:55.262 +00:00 [INF] Request starting HTTP/1.1 PUT http://159.89.226.33:5227/products/1583 - application/json 23620
2026-01-22 19:47:55.262 +00:00 [INF] CORS policy execution successful.
2026-01-22 19:47:55.263 +00:00 [INF] Executing endpoint 'HTTP: PUT Products/{id}'
2026-01-22 19:47:55.315 +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-22 19:47:55.333 +00:00 [INF] Executed DbCommand (16ms) [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-22 19:47:55.333 +00:00 [INF] Setting HTTP status code 204.
2026-01-22 19:47:55.333 +00:00 [INF] Executed endpoint 'HTTP: PUT Products/{id}'
2026-01-22 19:47:55.333 +00:00 [INF] Request finished HTTP/1.1 PUT http://159.89.226.33:5227/products/1583 - 204 null null 71.2138ms
2026-01-22 19:47:57.397 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2026-01-22 19:47:57.397 +00:00 [INF] CORS policy execution successful.
2026-01-22 19:47:57.397 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.3536ms
2026-01-22 19:47:57.397 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - null null
2026-01-22 19:47:57.397 +00:00 [INF] CORS policy execution successful.
2026-01-22 19:47:57.397 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - 204 null null 0.1351ms
2026-01-22 19:47:57.397 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null
2026-01-22 19:47:57.398 +00:00 [INF] CORS policy execution successful.
2026-01-22 19:47:57.398 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.9835ms
2026-01-22 19:47:57.449 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null
2026-01-22 19:47:57.449 +00:00 [INF] CORS policy execution successful.
2026-01-22 19:47:57.449 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/'
2026-01-22 19:47:57.452 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate]
FROM [Settings] AS [s]
2026-01-22 19:47:57.452 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 19:47:57.452 +00:00 [INF] Writing value of type 'SettingDto' as Json.
2026-01-22 19:47:57.452 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/'
2026-01-22 19:47:57.452 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 3.5415ms
2026-01-22 19:47:57.453 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Products - null null
2026-01-22 19:47:57.453 +00:00 [INF] CORS policy execution successful.
2026-01-22 19:47:57.454 +00:00 [INF] Executing endpoint 'HTTP: GET /products'
2026-01-22 19:47:57.458 +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-22 19:47:57.466 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2026-01-22 19:47:57.467 +00:00 [INF] CORS policy execution successful.
2026-01-22 19:47:57.468 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2026-01-22 19:47:57.471 +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-22 19:47:57.471 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 19:47:57.472 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 19:47:57.472 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2026-01-22 19:47:57.472 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 6.0819ms
2026-01-22 19:47:57.624 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 19:47:57.624 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 19:47:58.345 +00:00 [INF] Executed endpoint 'HTTP: GET /products'
2026-01-22 19:47:58.346 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Products - 200 null application/json; charset=utf-8 892.6809ms
2026-01-22 20:33:35.547 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-22 20:33:35.548 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:33:35.548 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 1.8231ms
2026-01-22 20:33:35.606 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-22 20:33:35.607 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:33:35.608 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-22 20:33:35.927 +00:00 [INF] Executed DbCommand (26ms) [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-22 20:33:35.929 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 20:33:35.930 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 20:33:35.930 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-22 20:33:35.930 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 324.0653ms
2026-01-22 20:33:42.565 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/crakers - null null
2026-01-22 20:33:42.565 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:33:42.565 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/crakers - 204 null null 0.3378ms
2026-01-22 20:33:42.625 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/crakers - null null
2026-01-22 20:33:42.625 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:33:42.625 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 20:33:42.636 +00:00 [INF] Executed DbCommand (7ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-22 20:33:42.638 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 20:33:42.638 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 20:33:42.639 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 20:33:42.639 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/crakers - 200 null application/json; charset=utf-8 13.8239ms
2026-01-22 20:33:52.466 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ox - null null
2026-01-22 20:33:52.466 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:33:52.466 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ox - 204 null null 0.3149ms
2026-01-22 20:33:52.526 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ox - null null
2026-01-22 20:33:52.527 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:33:52.527 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 20:33:52.529 +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-22 20:33:52.533 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 20:33:52.534 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 20:33:52.648 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 20:33:52.648 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ox - 200 null application/json; charset=utf-8 121.7809ms
2026-01-22 20:34:09.479 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-22 20:34:09.480 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:34:09.480 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.2962ms
2026-01-22 20:34:09.539 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2026-01-22 20:34:09.539 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:34:09.540 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-22 20:34:09.558 +00:00 [INF] Executed DbCommand (17ms) [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-22 20:34:09.566 +00:00 [INF] Executed DbCommand (8ms) [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-22 20:34:09.566 +00:00 [INF] Setting HTTP status code 201.
2026-01-22 20:34:09.567 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-22 20:34:09.567 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-22 20:34:09.567 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 27.6395ms
2026-01-22 20:34:09.623 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41330 - null null
2026-01-22 20:34:09.623 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:34:09.623 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41330 - 204 null null 0.2861ms
2026-01-22 20:34:09.682 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-22 20:34:09.682 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:34:09.682 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2673ms
2026-01-22 20:34:09.690 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41330 - application/json 106
2026-01-22 20:34:09.690 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:34:09.691 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-22 20:34:09.698 +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]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-22 20:34:09.739 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-22 20:34:09.739 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:34:09.739 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-22 20:34:09.756 +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-22 20:34:09.756 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 20:34:09.756 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 20:34:09.756 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-22 20:34:09.756 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 17.1278ms
2026-01-22 20:34:09.845 +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-22 20:34:09.864 +00:00 [INF] Executed DbCommand (18ms) [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-22 20:34:09.869 +00:00 [INF] Setting HTTP status code 201.
2026-01-22 20:34:09.869 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-22 20:34:09.869 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41330 - 201 0 null 179.0605ms
2026-01-22 20:53:37.159 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null
2026-01-22 20:53:37.160 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:53:37.160 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.5782ms
2026-01-22 20:53:37.219 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 61
2026-01-22 20:53:37.219 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:53:37.220 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin'
2026-01-22 20:53:37.589 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName]
FROM [AspNetUsers] AS [a]
WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0
2026-01-22 20:53:37.703 +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-22 20:53:37.704 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 20:53:37.704 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json.
2026-01-22 20:53:37.704 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin'
2026-01-22 20:53:37.705 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 485.3299ms
2026-01-22 20:53:40.867 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-22 20:53:40.867 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:53:40.867 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2887ms
2026-01-22 20:53:40.923 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2026-01-22 20:53:40.923 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:53:40.924 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.2411ms
2026-01-22 20:53:40.928 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null
2026-01-22 20:53:40.929 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null
2026-01-22 20:53:40.929 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:53:40.929 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:53:40.929 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.8244ms
2026-01-22 20:53:40.929 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.5504ms
2026-01-22 20:53:40.932 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-22 20:53:40.932 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:53:40.935 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-22 20:53:40.948 +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-22 20:53:40.949 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 20:53:40.949 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 20:53:40.949 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-22 20:53:40.949 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 17.0083ms
2026-01-22 20:53:40.982 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2026-01-22 20:53:40.982 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:53:40.983 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2026-01-22 20:53:40.986 +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-22 20:53:40.986 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 20:53:40.986 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 20:53:40.987 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2026-01-22 20:53:40.987 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 4.9603ms
2026-01-22 20:53:40.987 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null
2026-01-22 20:53:40.987 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:53:40.988 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities'
2026-01-22 20:53:40.989 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null
2026-01-22 20:53:40.989 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:53:40.989 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/'
2026-01-22 20:53:40.999 +00:00 [INF] Executed DbCommand (10ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [n].[Id], [n].[Descripcion], [n].[Estatus], [n].[Gentilicio], [n].[Siglas]
FROM [Nationalities] AS [n]
2026-01-22 20:53:41.000 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 20:53:41.000 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 20:53:41.000 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities'
2026-01-22 20:53:41.001 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 13.4594ms
2026-01-22 20:53:41.006 +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-22 20:53:41.007 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 20:53:41.007 +00:00 [INF] Writing value of type 'SettingDto' as Json.
2026-01-22 20:53:41.007 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/'
2026-01-22 20:53:41.007 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 18.0309ms
2026-01-22 20:53:43.998 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - null null
2026-01-22 20:53:43.998 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:53:43.998 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - 204 null null 0.4344ms
2026-01-22 20:53:44.057 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan - null null
2026-01-22 20:53:44.058 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:53:44.058 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 20:53:44.063 +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-22 20:53:44.069 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 20:53:44.069 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 20:53:44.242 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 20:53:44.242 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan - 200 null application/json; charset=utf-8 184.9384ms
2026-01-22 20:53:53.996 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/leche - null null
2026-01-22 20:53:53.996 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:53:53.996 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/leche - 204 null null 0.4446ms
2026-01-22 20:53:54.055 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/leche - null null
2026-01-22 20:53:54.056 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:53:54.056 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 20:53:54.059 +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-22 20:53:54.062 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 20:53:54.062 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 20:53:54.062 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 20:53:54.062 +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 6.8808ms
2026-01-22 20:54:05.793 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/flor de jamaica - null null
2026-01-22 20:54:05.793 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:54:05.793 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/flor de jamaica - 204 null null 0.29ms
2026-01-22 20:54:05.853 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/flor de jamaica - null null
2026-01-22 20:54:05.853 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:54:05.853 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 20:54:05.857 +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-22 20:54:05.861 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 20:54:05.861 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 20:54:05.862 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 20:54:05.862 +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.8582ms
2026-01-22 20:54:18.723 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/mezcla - null null
2026-01-22 20:54:18.723 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:54:18.723 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/mezcla - 204 null null 0.3619ms
2026-01-22 20:54:18.790 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/mezcla - null null
2026-01-22 20:54:18.791 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:54:18.791 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 20:54:18.794 +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-22 20:54:18.797 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 20:54:18.797 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 20:54:18.797 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 20:54:18.797 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/mezcla - 200 null application/json; charset=utf-8 7.1471ms
2026-01-22 20:54:33.377 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ajon - null null
2026-01-22 20:54:33.377 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:54:33.377 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ajon - 204 null null 0.2808ms
2026-01-22 20:54:33.437 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ajon - null null
2026-01-22 20:54:33.437 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:54:33.438 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 20:54:33.441 +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-22 20:54:33.448 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 20:54:33.448 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 20:54:33.449 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 20:54:33.449 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ajon - 200 null application/json; charset=utf-8 11.943ms
2026-01-22 20:54:35.037 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/oli - null null
2026-01-22 20:54:35.037 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:54:35.037 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/oli - 204 null null 0.2688ms
2026-01-22 20:54:35.096 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/oli - null null
2026-01-22 20:54:35.097 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:54:35.097 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 20:54:35.100 +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-22 20:54:35.106 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 20:54:35.107 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 20:54:35.276 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 20:54:35.277 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/oli - 200 null application/json; charset=utf-8 180.2372ms
2026-01-22 20:55:59.619 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma gel - null null
2026-01-22 20:55:59.619 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:55:59.619 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma gel - 204 null null 0.3372ms
2026-01-22 20:55:59.678 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma gel - null null
2026-01-22 20:55:59.679 +00:00 [INF] CORS policy execution successful.
2026-01-22 20:55:59.679 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 20:55:59.683 +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-22 20:55:59.686 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 20:55:59.687 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 20:55:59.687 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 20:55:59.687 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma gel - 200 null application/json; charset=utf-8 8.6802ms
2026-01-22 21:13:04.718 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-22 21:13:04.718 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:13:04.718 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.2794ms
2026-01-22 21:13:04.778 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2026-01-22 21:13:04.779 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:13:04.779 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-22 21:13:05.046 +00:00 [INF] Executed DbCommand (7ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2026-01-22 21:13:05.050 +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-22 21:13:05.051 +00:00 [INF] Setting HTTP status code 201.
2026-01-22 21:13:05.051 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-22 21:13:05.051 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-22 21:13:05.051 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 272.8061ms
2026-01-22 21:13:05.113 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41331 - null null
2026-01-22 21:13:05.114 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:13:05.114 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41331 - 204 null null 0.7712ms
2026-01-22 21:13:05.170 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-22 21:13:05.170 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:13:05.171 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.8639ms
2026-01-22 21:13:05.178 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41331 - application/json 617
2026-01-22 21:13:05.179 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:13:05.179 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-22 21:13:05.181 +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-22 21:13:05.228 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-22 21:13:05.228 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:13:05.228 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-22 21:13:05.245 +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-22 21:13:05.246 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 21:13:05.246 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 21:13:05.246 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-22 21:13:05.246 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 17.922ms
2026-01-22 21:13:05.397 +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-22 21:13:05.518 +00:00 [INF] Executed DbCommand (120ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p40='?' (DbType = Int32), @p23='?' (Size = 4000), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Int32), @p26='?' (DbType = Guid), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Boolean), @p29='?' (DbType = DateTime2), @p30='?' (DbType = Int32), @p31='?' (Size = 150), @p32='?' (Size = 500), @p33='?' (Size = -1) (DbType = Binary), @p34='?' (DbType = Int32), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p36='?' (Size = 4000), @p37='?' (DbType = Int32), @p38='?' (DbType = Guid), @p39='?' (DbType = DateTime2), @p58='?' (DbType = Int32), @p41='?' (Size = 4000), @p42='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p43='?' (DbType = Int32), @p44='?' (DbType = Guid), @p45='?' (DbType = DateTime2), @p46='?' (DbType = Boolean), @p47='?' (DbType = DateTime2), @p48='?' (DbType = Int32), @p49='?' (Size = 150), @p50='?' (Size = 500), @p51='?' (Size = -1) (DbType = Binary), @p52='?' (DbType = Int32), @p53='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p54='?' (Size = 4000), @p55='?' (DbType = Int32), @p56='?' (DbType = Guid), @p57='?' (DbType = DateTime2), @p76='?' (DbType = Int32), @p59='?' (Size = 4000), @p60='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p61='?' (DbType = Int32), @p62='?' (DbType = Guid), @p63='?' (DbType = DateTime2), @p64='?' (DbType = Boolean), @p65='?' (DbType = DateTime2), @p66='?' (DbType = Int32), @p67='?' (Size = 150), @p68='?' (Size = 500), @p69='?' (Size = -1) (DbType = Binary), @p70='?' (DbType = Int32), @p71='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p72='?' (Size = 4000), @p73='?' (DbType = Int32), @p74='?' (DbType = Guid), @p75='?' (DbType = DateTime2), @p94='?' (DbType = Int32), @p77='?' (Size = 4000), @p78='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p79='?' (DbType = Int32), @p80='?' (DbType = Guid), @p81='?' (DbType = DateTime2), @p82='?' (DbType = Boolean), @p83='?' (DbType = DateTime2), @p84='?' (DbType = Int32), @p85='?' (Size = 150), @p86='?' (Size = 500), @p87='?' (Size = -1) (DbType = Binary), @p88='?' (DbType = Int32), @p89='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p90='?' (Size = 4000), @p91='?' (DbType = Int32), @p92='?' (DbType = Guid), @p93='?' (DbType = DateTime2), @p112='?' (DbType = Int32), @p95='?' (Size = 4000), @p96='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p97='?' (DbType = Int32), @p98='?' (DbType = Guid), @p99='?' (DbType = DateTime2), @p100='?' (DbType = Boolean), @p101='?' (DbType = DateTime2), @p102='?' (DbType = Int32), @p103='?' (Size = 150), @p104='?' (Size = 500), @p105='?' (Size = -1) (DbType = Binary), @p106='?' (DbType = Int32), @p107='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p108='?' (Size = 4000), @p109='?' (DbType = Int32), @p110='?' (DbType = Guid), @p111='?' (DbType = DateTime2), @p113='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p114='?' (DbType = Guid), @p115='?' (DbType = DateTime2), @p116='?' (DbType = Boolean), @p117='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p118='?' (DbType = Int32), @p119='?' (DbType = Int32), @p120='?' (DbType = Int64), @p121='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p122='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p123='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p124='?' (DbType = Guid), @p125='?' (DbType = DateTime2), @p126='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p127='?' (DbType = Guid), @p128='?' (DbType = DateTime2), @p129='?' (DbType = Boolean), @p130='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p131='?' (DbType = Int32), @p132='?' (DbType = Int32), @p133='?' (DbType = Int64), @p134='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p135='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p136='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p137='?' (DbType = Guid), @p138='?' (DbType = DateTime2), @p139='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p140='?' (DbType = Guid), @p141='?' (DbType = DateTime2), @p142='?' (DbType = Boolean), @p143='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p144='?' (DbType = Int32), @p145='?' (DbType = Int32), @p146='?' (DbType = Int64), @p147='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p148='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p149='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p150='?' (DbType = Guid), @p151='?' (DbType = DateTime2), @p152='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p153='?' (DbType = Guid), @p154='?' (DbType = DateTime2), @p155='?' (DbType = Boolean), @p156='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p157='?' (DbType = Int32), @p158='?' (DbType = Int32), @p159='?' (DbType = Int64), @p160='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p161='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p162='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p163='?' (DbType = Guid), @p164='?' (DbType = DateTime2), @p165='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p166='?' (DbType = Guid), @p167='?' (DbType = DateTime2), @p168='?' (DbType = Boolean), @p169='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p170='?' (DbType = Int32), @p171='?' (DbType = Int32), @p172='?' (DbType = Int64), @p173='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p174='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p175='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p176='?' (DbType = Guid), @p177='?' (DbType = DateTime2), @p178='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p179='?' (DbType = Guid), @p180='?' (DbType = DateTime2), @p181='?' (DbType = Boolean), @p182='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p183='?' (DbType = Int32), @p184='?' (DbType = Int32), @p185='?' (DbType = Int64), @p186='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p187='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p188='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p189='?' (DbType = Guid), @p190='?' (DbType = DateTime2), @p191='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p192='?' (DbType = Guid), @p193='?' (DbType = DateTime2), @p194='?' (DbType = Int32), @p195='?' (Size = 34), @p196='?' (DbType = Guid), @p197='?' (DbType = Int32), @p198='?' (DbType = Int32), @p199='?' (DbType = Int32), @p200='?' (Size = 4000), @p201='?' (Size = 4000), @p202='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p203='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p204='?' (DbType = Guid), @p205='?' (DbType = DateTime2), @p206='?' (DbType = Int32), @p207='?' (Size = 34), @p208='?' (DbType = Guid), @p209='?' (DbType = Int32), @p210='?' (DbType = Int32), @p211='?' (DbType = Int32), @p212='?' (Size = 4000), @p213='?' (Size = 4000), @p214='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p215='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p216='?' (DbType = Guid), @p217='?' (DbType = DateTime2), @p218='?' (DbType = Int32), @p219='?' (Size = 34), @p220='?' (DbType = Guid), @p221='?' (DbType = Int32), @p222='?' (DbType = Int32), @p223='?' (DbType = Int32), @p224='?' (Size = 4000), @p225='?' (Size = 4000), @p226='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p227='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p228='?' (DbType = Guid), @p229='?' (DbType = DateTime2), @p230='?' (DbType = Int32), @p231='?' (Size = 34), @p232='?' (DbType = Guid), @p233='?' (DbType = Int32), @p234='?' (DbType = Int32), @p235='?' (DbType = Int32), @p236='?' (Size = 4000), @p237='?' (Size = 4000), @p238='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p239='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p240='?' (DbType = Guid), @p241='?' (DbType = DateTime2), @p242='?' (DbType = Int32), @p243='?' (Size = 34), @p244='?' (DbType = Guid), @p245='?' (DbType = Int32), @p246='?' (DbType = Int32), @p247='?' (DbType = Int32), @p248='?' (Size = 4000), @p249='?' (Size = 4000), @p250='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p251='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p252='?' (DbType = Guid), @p253='?' (DbType = DateTime2), @p254='?' (DbType = Int32), @p255='?' (Size = 34), @p256='?' (DbType = Guid), @p257='?' (DbType = Int32), @p258='?' (DbType = Int32), @p259='?' (DbType = Int32), @p260='?' (Size = 4000), @p261='?' (Size = 4000), @p262='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
UPDATE [Products] SET [BarCode] = @p23, [BuyPrice] = @p24, [CategoryId] = @p25, [CreatedById] = @p26, [CreatedDate] = @p27, [DeleteFlag] = @p28, [ExpirationDate] = @p29, [MinimunStock] = @p30, [Name] = @p31, [Note] = @p32, [ProductImage] = @p33, [ProductTaxId] = @p34, [SalePrice] = @p35, [Status] = @p36, [Stock] = @p37, [UpdatedById] = @p38, [UpdatedDate] = @p39
OUTPUT 1
WHERE [Id] = @p40;
UPDATE [Products] SET [BarCode] = @p41, [BuyPrice] = @p42, [CategoryId] = @p43, [CreatedById] = @p44, [CreatedDate] = @p45, [DeleteFlag] = @p46, [ExpirationDate] = @p47, [MinimunStock] = @p48, [Name] = @p49, [Note] = @p50, [ProductImage] = @p51, [ProductTaxId] = @p52, [SalePrice] = @p53, [Status] = @p54, [Stock] = @p55, [UpdatedById] = @p56, [UpdatedDate] = @p57
OUTPUT 1
WHERE [Id] = @p58;
UPDATE [Products] SET [BarCode] = @p59, [BuyPrice] = @p60, [CategoryId] = @p61, [CreatedById] = @p62, [CreatedDate] = @p63, [DeleteFlag] = @p64, [ExpirationDate] = @p65, [MinimunStock] = @p66, [Name] = @p67, [Note] = @p68, [ProductImage] = @p69, [ProductTaxId] = @p70, [SalePrice] = @p71, [Status] = @p72, [Stock] = @p73, [UpdatedById] = @p74, [UpdatedDate] = @p75
OUTPUT 1
WHERE [Id] = @p76;
UPDATE [Products] SET [BarCode] = @p77, [BuyPrice] = @p78, [CategoryId] = @p79, [CreatedById] = @p80, [CreatedDate] = @p81, [DeleteFlag] = @p82, [ExpirationDate] = @p83, [MinimunStock] = @p84, [Name] = @p85, [Note] = @p86, [ProductImage] = @p87, [ProductTaxId] = @p88, [SalePrice] = @p89, [Status] = @p90, [Stock] = @p91, [UpdatedById] = @p92, [UpdatedDate] = @p93
OUTPUT 1
WHERE [Id] = @p94;
UPDATE [Products] SET [BarCode] = @p95, [BuyPrice] = @p96, [CategoryId] = @p97, [CreatedById] = @p98, [CreatedDate] = @p99, [DeleteFlag] = @p100, [ExpirationDate] = @p101, [MinimunStock] = @p102, [Name] = @p103, [Note] = @p104, [ProductImage] = @p105, [ProductTaxId] = @p106, [SalePrice] = @p107, [Status] = @p108, [Stock] = @p109, [UpdatedById] = @p110, [UpdatedDate] = @p111
OUTPUT 1
WHERE [Id] = @p112;
MERGE [SalesDetail] USING (
VALUES (@p113, @p114, @p115, @p116, @p117, @p118, @p119, @p120, @p121, @p122, @p123, @p124, @p125, 0),
(@p126, @p127, @p128, @p129, @p130, @p131, @p132, @p133, @p134, @p135, @p136, @p137, @p138, 1),
(@p139, @p140, @p141, @p142, @p143, @p144, @p145, @p146, @p147, @p148, @p149, @p150, @p151, 2),
(@p152, @p153, @p154, @p155, @p156, @p157, @p158, @p159, @p160, @p161, @p162, @p163, @p164, 3),
(@p165, @p166, @p167, @p168, @p169, @p170, @p171, @p172, @p173, @p174, @p175, @p176, @p177, 4),
(@p178, @p179, @p180, @p181, @p182, @p183, @p184, @p185, @p186, @p187, @p188, @p189, @p190, 5)) 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 (@p191, @p192, @p193, @p194, @p195, @p196, @p197, @p198, @p199, @p200, @p201, @p202, 0),
(@p203, @p204, @p205, @p206, @p207, @p208, @p209, @p210, @p211, @p212, @p213, @p214, 1),
(@p215, @p216, @p217, @p218, @p219, @p220, @p221, @p222, @p223, @p224, @p225, @p226, 2),
(@p227, @p228, @p229, @p230, @p231, @p232, @p233, @p234, @p235, @p236, @p237, @p238, 3),
(@p239, @p240, @p241, @p242, @p243, @p244, @p245, @p246, @p247, @p248, @p249, @p250, 4),
(@p251, @p252, @p253, @p254, @p255, @p256, @p257, @p258, @p259, @p260, @p261, @p262, 5)) 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-22 21:13:05.524 +00:00 [INF] Setting HTTP status code 201.
2026-01-22 21:13:05.524 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-22 21:13:05.524 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41331 - 201 0 null 345.8605ms
2026-01-22 21:16:37.570 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - null null
2026-01-22 21:16:37.570 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:16:37.570 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - 204 null null 0.3302ms
2026-01-22 21:16:37.630 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma - null null
2026-01-22 21:16:37.630 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:16:37.631 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 21:16:37.633 +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-22 21:16:37.641 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 21:16:37.641 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 21:16:37.807 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 21:16:37.807 +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 177.4786ms
2026-01-22 21:17:37.220 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-22 21:17:37.220 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:17:37.220 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.409ms
2026-01-22 21:17:37.280 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2026-01-22 21:17:37.280 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:17:37.280 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-22 21:17:37.285 +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-22 21:17:37.288 +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-22 21:17:37.288 +00:00 [INF] Setting HTTP status code 201.
2026-01-22 21:17:37.288 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-22 21:17:37.288 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-22 21:17:37.288 +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.8016ms
2026-01-22 21:17:37.350 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41332 - null null
2026-01-22 21:17:37.350 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:17:37.350 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41332 - 204 null null 0.3889ms
2026-01-22 21:17:37.410 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-22 21:17:37.410 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:17:37.410 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3036ms
2026-01-22 21:17:37.420 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41332 - application/json 211
2026-01-22 21:17:37.420 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:17:37.420 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-22 21:17:37.422 +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-22 21:17:37.470 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-22 21:17:37.470 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:17:37.471 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-22 21:17:37.473 +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-22 21:17:37.473 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 21:17:37.474 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 21:17:37.474 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-22 21:17:37.474 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 4.3594ms
2026-01-22 21:17:37.576 +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-22 21:17:37.613 +00:00 [INF] Executed DbCommand (36ms) [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-22 21:17:37.618 +00:00 [INF] Setting HTTP status code 201.
2026-01-22 21:17:37.618 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-22 21:17:37.618 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41332 - 201 0 null 198.4631ms
2026-01-22 21:24:48.187 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/acido - null null
2026-01-22 21:24:48.187 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:24:48.187 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/acido - 204 null null 0.3533ms
2026-01-22 21:24:48.247 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/acido - null null
2026-01-22 21:24:48.247 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:24:48.247 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 21:24:48.595 +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-22 21:24:48.601 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 21:24:48.601 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 21:24:48.710 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 21:24:48.710 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/acido - 200 null application/json; charset=utf-8 463.276ms
2026-01-22 21:30:23.895 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-22 21:30:23.896 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:30:23.896 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2907ms
2026-01-22 21:30:23.956 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-22 21:30:23.956 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:30:23.956 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-22 21:30:23.959 +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-22 21:30:23.959 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 21:30:23.959 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 21:30:23.959 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-22 21:30:23.959 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 3.6232ms
2026-01-22 21:35:24.527 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/acido - null null
2026-01-22 21:35:24.527 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:35:24.527 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/acido - 204 null null 0.4551ms
2026-01-22 21:35:24.590 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/acido - null null
2026-01-22 21:35:24.590 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:35:24.591 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 21:35:24.828 +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-22 21:35:24.835 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 21:35:24.835 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 21:35:24.944 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 21:35:24.945 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/acido - 200 null application/json; charset=utf-8 354.9694ms
2026-01-22 21:40:57.647 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/hy - null null
2026-01-22 21:40:57.647 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:40:57.647 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/hy - 204 null null 0.3037ms
2026-01-22 21:40:57.710 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/hy - null null
2026-01-22 21:40:57.710 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:40:57.710 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 21:40:57.713 +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-22 21:40:57.717 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 21:40:57.717 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 21:40:57.717 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 21:40:57.717 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/hy - 200 null application/json; charset=utf-8 7.6957ms
2026-01-22 21:46:43.795 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Hai - null null
2026-01-22 21:46:43.795 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:46:43.795 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Hai - 204 null null 0.3039ms
2026-01-22 21:46:43.851 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/Hai - null null
2026-01-22 21:46:43.852 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:46:43.852 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 21:46:44.109 +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-22 21:46:44.114 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 21:46:44.115 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 21:46:44.115 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 21:46:44.116 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/Hai - 200 null application/json; charset=utf-8 264.3032ms
2026-01-22 21:47:52.460 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/hy - null null
2026-01-22 21:47:52.460 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:47:52.460 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/hy - 204 null null 0.3239ms
2026-01-22 21:47:52.520 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/hy - null null
2026-01-22 21:47:52.520 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:47:52.520 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 21:47:52.523 +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-22 21:47:52.527 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 21:47:52.528 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 21:47:52.528 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 21:47:52.528 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/hy - 200 null application/json; charset=utf-8 8.123ms
2026-01-22 21:57:04.591 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-22 21:57:04.591 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:57:04.592 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 1.0261ms
2026-01-22 21:57:04.651 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-22 21:57:04.651 +00:00 [INF] CORS policy execution successful.
2026-01-22 21:57:04.652 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-22 21:57:04.888 +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-22 21:57:04.889 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 21:57:04.889 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 21:57:04.889 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-22 21:57:04.889 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 237.928ms
2026-01-22 22:21:35.089 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/sara - null null
2026-01-22 22:21:35.090 +00:00 [INF] CORS policy execution successful.
2026-01-22 22:21:35.090 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/sara - 204 null null 0.8434ms
2026-01-22 22:21:35.155 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/sara - null null
2026-01-22 22:21:35.155 +00:00 [INF] CORS policy execution successful.
2026-01-22 22:21:35.155 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 22:21:35.394 +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-22 22:21:35.401 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 22:21:35.401 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 22:21:35.401 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 22:21:35.401 +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 246.5074ms
2026-01-22 22:28:44.532 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/prueba - null null
2026-01-22 22:28:44.533 +00:00 [INF] CORS policy execution successful.
2026-01-22 22:28:44.533 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/prueba - 204 null null 1.3388ms
2026-01-22 22:28:44.593 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/prueba - null null
2026-01-22 22:28:44.593 +00:00 [INF] CORS policy execution successful.
2026-01-22 22:28:44.593 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 22:28:44.833 +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-22 22:28:44.833 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 22:28:44.833 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 22:28:44.833 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 22:28:44.833 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/prueba - 200 null application/json; charset=utf-8 240.7627ms
2026-01-22 22:28:50.981 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/prueva - null null
2026-01-22 22:28:50.981 +00:00 [INF] CORS policy execution successful.
2026-01-22 22:28:50.981 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/prueva - 204 null null 0.3401ms
2026-01-22 22:28:51.045 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/prueva - null null
2026-01-22 22:28:51.045 +00:00 [INF] CORS policy execution successful.
2026-01-22 22:28:51.045 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 22:28:51.052 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2026-01-22 22:28:51.052 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 22:28:51.052 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 22:28:51.052 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 22:28:51.053 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/prueva - 200 null application/json; charset=utf-8 7.9591ms
2026-01-22 22:28:55.220 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/prueba - null null
2026-01-22 22:28:55.220 +00:00 [INF] CORS policy execution successful.
2026-01-22 22:28:55.220 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/prueba - 204 null null 0.2751ms
2026-01-22 22:28:55.280 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/prueba - null null
2026-01-22 22:28:55.280 +00:00 [INF] CORS policy execution successful.
2026-01-22 22:28:55.280 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 22:28:55.285 +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-22 22:28:55.286 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 22:28:55.286 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 22:28:55.286 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 22:28:55.286 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/prueba - 200 null application/json; charset=utf-8 5.9617ms
2026-01-22 23:46:27.921 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/higadfo - null null
2026-01-22 23:46:27.922 +00:00 [INF] CORS policy execution successful.
2026-01-22 23:46:27.922 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/higadfo - 204 null null 1.2995ms
2026-01-22 23:46:27.983 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/higadfo - null null
2026-01-22 23:46:27.983 +00:00 [INF] CORS policy execution successful.
2026-01-22 23:46:27.986 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 23:46:28.398 +00:00 [INF] Executed DbCommand (13ms) [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-22 23:46:28.401 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 23:46:28.401 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 23:46:28.401 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 23:46:28.401 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/higadfo - 200 null application/json; charset=utf-8 418.1461ms
2026-01-22 23:46:33.821 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/higado - null null
2026-01-22 23:46:33.821 +00:00 [INF] CORS policy execution successful.
2026-01-22 23:46:33.821 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/higado - 204 null null 0.3807ms
2026-01-22 23:46:33.882 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/higado - null null
2026-01-22 23:46:33.882 +00:00 [INF] CORS policy execution successful.
2026-01-22 23:46:33.882 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 23:46:33.887 +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-22 23:46:33.891 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 23:46:33.891 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 23:46:33.893 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2026-01-22 23:46:33.894 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/higado - 200 null application/json; charset=utf-8 12.3941ms
2026-01-22 23:48:04.896 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2026-01-22 23:48:04.896 +00:00 [INF] CORS policy execution successful.
2026-01-22 23:48:04.896 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.4103ms
2026-01-22 23:48:04.952 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2026-01-22 23:48:04.952 +00:00 [INF] CORS policy execution successful.
2026-01-22 23:48:04.953 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2026-01-22 23:48:04.962 +00:00 [INF] Executed DbCommand (8ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2026-01-22 23:48:04.968 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2026-01-22 23:48:04.969 +00:00 [INF] Setting HTTP status code 201.
2026-01-22 23:48:04.969 +00:00 [INF] Writing value of type 'Int64' as Json.
2026-01-22 23:48:04.969 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2026-01-22 23:48:04.969 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 17.1621ms
2026-01-22 23:48:05.028 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41333 - null null
2026-01-22 23:48:05.029 +00:00 [INF] CORS policy execution successful.
2026-01-22 23:48:05.029 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41333 - 204 null null 0.3864ms
2026-01-22 23:48:05.092 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2026-01-22 23:48:05.092 +00:00 [INF] CORS policy execution successful.
2026-01-22 23:48:05.092 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3803ms
2026-01-22 23:48:05.094 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41333 - application/json 105
2026-01-22 23:48:05.095 +00:00 [INF] CORS policy execution successful.
2026-01-22 23:48:05.095 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-22 23:48:05.098 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-22 23:48:05.150 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2026-01-22 23:48:05.151 +00:00 [INF] CORS policy execution successful.
2026-01-22 23:48:05.151 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2026-01-22 23:48:05.200 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2026-01-22 23:48:05.200 +00:00 [INF] Setting HTTP status code 200.
2026-01-22 23:48:05.200 +00:00 [INF] Writing value of type 'List`1' as Json.
2026-01-22 23:48:05.200 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2026-01-22 23:48:05.200 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 50.2772ms
2026-01-22 23:48:05.301 +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-22 23:48:05.310 +00:00 [INF] Executed DbCommand (9ms) [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-22 23:48:05.314 +00:00 [INF] Setting HTTP status code 201.
2026-01-22 23:48:05.314 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2026-01-22 23:48:05.314 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41333 - 201 0 null 220.0924ms