2025-11-18 06:10:00.140 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2025-11-18 06:10:00.142 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 2.6317ms
2025-11-18 06:10:00.143 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404
2025-11-18 12:42:08.367 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null
2025-11-18 12:42:08.368 +00:00 [INF] CORS policy execution successful.
2025-11-18 12:42:08.368 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.5069ms
2025-11-18 12:42:08.428 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 65
2025-11-18 12:42:08.428 +00:00 [INF] CORS policy execution successful.
2025-11-18 12:42:08.428 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin'
2025-11-18 12:42:08.723 +00:00 [INF] Executed DbCommand (8ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName]
FROM [AspNetUsers] AS [a]
WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0
2025-11-18 12:42:08.841 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (Size = 450)], CommandType='"Text"', CommandTimeout='30']
SELECT [a0].[Name]
FROM [AspNetUserRoles] AS [a]
INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id]
WHERE [a].[UserId] = @__userId_0
2025-11-18 12:42:08.842 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 12:42:08.843 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json.
2025-11-18 12:42:08.843 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin'
2025-11-18 12:42:08.843 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 415.4044ms
2025-11-18 12:57:30.373 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2025-11-18 12:57:30.373 +00:00 [INF] CORS policy execution successful.
2025-11-18 12:57:30.373 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.3154ms
2025-11-18 12:57:30.374 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 12:57:30.374 +00:00 [INF] CORS policy execution successful.
2025-11-18 12:57:30.374 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.9111ms
2025-11-18 12:57:30.375 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null
2025-11-18 12:57:30.375 +00:00 [INF] CORS policy execution successful.
2025-11-18 12:57:30.375 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.4428ms
2025-11-18 12:57:30.376 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null
2025-11-18 12:57:30.376 +00:00 [INF] CORS policy execution successful.
2025-11-18 12:57:30.376 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.3659ms
2025-11-18 12:57:30.431 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2025-11-18 12:57:30.431 +00:00 [INF] CORS policy execution successful.
2025-11-18 12:57:30.431 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2025-11-18 12:57:30.433 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 12:57:30.433 +00:00 [INF] CORS policy execution successful.
2025-11-18 12:57:30.434 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 12:57:30.435 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null
2025-11-18 12:57:30.435 +00:00 [INF] CORS policy execution successful.
2025-11-18 12:57:30.436 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/'
2025-11-18 12:57:30.442 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null
2025-11-18 12:57:30.443 +00:00 [INF] CORS policy execution successful.
2025-11-18 12:57:30.443 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities'
2025-11-18 12:57:30.671 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [ProductTaxes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 12:57:30.672 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 12:57:30.672 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 12:57:30.672 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2025-11-18 12:57:30.672 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 241.3782ms
2025-11-18 12:57:30.678 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate]
FROM [Settings] AS [s]
2025-11-18 12:57:30.679 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 12:57:30.679 +00:00 [INF] Writing value of type 'SettingDto' as Json.
2025-11-18 12:57:30.679 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/'
2025-11-18 12:57:30.679 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 244.106ms
2025-11-18 12:57:30.679 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 12:57:30.680 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 12:57:30.680 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 12:57:30.680 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 12:57:30.680 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 247.405ms
2025-11-18 12:57:30.682 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [n].[Id], [n].[Descripcion], [n].[Estatus], [n].[Gentilicio], [n].[Siglas]
FROM [Nationalities] AS [n]
2025-11-18 12:57:30.682 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 12:57:30.683 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 12:57:30.683 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities'
2025-11-18 12:57:30.683 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 240.853ms
2025-11-18 12:57:34.494 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/omega - null null
2025-11-18 12:57:34.495 +00:00 [INF] CORS policy execution successful.
2025-11-18 12:57:34.496 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/omega - 204 null null 1.749ms
2025-11-18 12:57:34.554 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/omega - null null
2025-11-18 12:57:34.555 +00:00 [INF] CORS policy execution successful.
2025-11-18 12:57:34.555 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 12:57:34.559 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-18 12:57:34.565 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 12:57:34.566 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 12:57:34.675 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 12:57:34.675 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/omega - 200 null application/json; charset=utf-8 121.2101ms
2025-11-18 12:58:22.683 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 12:58:22.683 +00:00 [INF] CORS policy execution successful.
2025-11-18 12:58:22.684 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3128ms
2025-11-18 12:58:22.743 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 12:58:22.743 +00:00 [INF] CORS policy execution successful.
2025-11-18 12:58:22.744 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 12:58:22.746 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 12:58:22.746 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 12:58:22.746 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 12:58:22.747 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 12:58:22.747 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 3.3213ms
2025-11-18 12:59:49.569 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/omega 3 - null null
2025-11-18 12:59:49.569 +00:00 [INF] CORS policy execution successful.
2025-11-18 12:59:49.569 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/omega 3 - 204 null null 0.2323ms
2025-11-18 12:59:49.634 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/omega 3 - null null
2025-11-18 12:59:49.634 +00:00 [INF] CORS policy execution successful.
2025-11-18 12:59:49.635 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 12:59:49.639 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-18 12:59:49.642 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 12:59:49.642 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 12:59:49.643 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 12:59:49.643 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/omega 3 - 200 null application/json; charset=utf-8 8.6406ms
2025-11-18 13:04:00.310 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 13:04:00.311 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:04:00.311 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.235ms
2025-11-18 13:04:00.371 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 13:04:00.371 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:04:00.371 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 13:04:00.601 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 13:04:00.601 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 13:04:00.601 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 13:04:00.601 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 13:04:00.601 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 230.5836ms
2025-11-18 13:04:05.120 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/rohe - null null
2025-11-18 13:04:05.120 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:04:05.120 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/rohe - 204 null null 0.384ms
2025-11-18 13:04:05.184 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/rohe - null null
2025-11-18 13:04:05.184 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:04:05.185 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 13:04:05.189 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-18 13:04:05.190 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 13:04:05.190 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 13:04:05.191 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 13:04:05.191 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/rohe - 200 null application/json; charset=utf-8 6.7636ms
2025-11-18 13:04:11.165 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-11-18 13:04:11.165 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:04:11.165 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.2464ms
2025-11-18 13:04:11.222 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 179
2025-11-18 13:04:11.222 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:04:11.223 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-11-18 13:04:11.228 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2025-11-18 13:04:11.232 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2025-11-18 13:04:11.232 +00:00 [INF] Setting HTTP status code 201.
2025-11-18 13:04:11.232 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-11-18 13:04:11.232 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-11-18 13:04:11.232 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 9.9982ms
2025-11-18 13:04:11.298 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40943 - null null
2025-11-18 13:04:11.298 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:04:11.298 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40943 - 204 null null 0.3615ms
2025-11-18 13:04:11.353 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 13:04:11.353 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:04:11.354 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.281ms
2025-11-18 13:04:11.369 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40943 - application/json 104
2025-11-18 13:04:11.369 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:04:11.370 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-18 13:04:11.373 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 13:04:11.412 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 13:04:11.413 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:04:11.414 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 13:04:11.437 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 13:04:11.437 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 13:04:11.437 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 13:04:11.437 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 13:04:11.437 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 25.2426ms
2025-11-18 13:04:11.549 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2025-11-18 13:04:11.554 +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);
2025-11-18 13:04:11.560 +00:00 [INF] Setting HTTP status code 201.
2025-11-18 13:04:11.560 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-18 13:04:11.560 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40943 - 201 0 null 190.9443ms
2025-11-18 13:53:07.764 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/cafe - null null
2025-11-18 13:53:07.764 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:53:07.764 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/cafe - 204 null null 0.2907ms
2025-11-18 13:53:07.824 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/cafe - null null
2025-11-18 13:53:07.824 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:53:07.825 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 13:53:08.058 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-18 13:53:08.058 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 13:53:08.058 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 13:53:08.058 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 13:53:08.058 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/cafe - 200 null application/json; charset=utf-8 234.191ms
2025-11-18 13:53:38.087 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Ca - null null
2025-11-18 13:53:38.087 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:53:38.088 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Ca - 204 null null 0.2697ms
2025-11-18 13:53:38.148 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/Ca - null null
2025-11-18 13:53:38.148 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:53:38.148 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 13:53:38.150 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-18 13:53:38.199 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 13:53:38.199 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 13:53:38.621 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 13:53:38.621 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/Ca - 200 null application/json; charset=utf-8 473.4502ms
2025-11-18 13:53:45.102 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Carbon - null null
2025-11-18 13:53:45.102 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:53:45.102 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Carbon - 204 null null 0.3627ms
2025-11-18 13:53:45.162 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/Carbon - null null
2025-11-18 13:53:45.162 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:53:45.163 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 13:53:45.169 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-18 13:53:45.176 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 13:53:45.176 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 13:53:45.177 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 13:53:45.177 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/Carbon - 200 null application/json; charset=utf-8 15.0927ms
2025-11-18 13:54:14.221 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 13:54:14.221 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:54:14.221 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.4102ms
2025-11-18 13:54:14.280 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 13:54:14.280 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:54:14.280 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 13:54:14.282 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 13:54:14.283 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 13:54:14.283 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 13:54:14.284 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 13:54:14.284 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 3.8111ms
2025-11-18 13:54:19.129 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Salami - null null
2025-11-18 13:54:19.129 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:54:19.129 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Salami - 204 null null 0.3331ms
2025-11-18 13:54:19.189 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/Salami - null null
2025-11-18 13:54:19.189 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:54:19.190 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 13:54:19.193 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-18 13:54:19.200 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 13:54:19.200 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 13:54:19.201 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 13:54:19.201 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/Salami - 200 null application/json; charset=utf-8 12.2086ms
2025-11-18 13:54:37.666 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Curcuma - null null
2025-11-18 13:54:37.666 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:54:37.666 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Curcuma - 204 null null 0.36ms
2025-11-18 13:54:37.725 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/Curcuma - null null
2025-11-18 13:54:37.725 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:54:37.725 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 13:54:37.729 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-18 13:54:37.733 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 13:54:37.733 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 13:54:37.733 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 13:54:37.733 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/Curcuma - 200 null application/json; charset=utf-8 8.4686ms
2025-11-18 13:54:50.193 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Sal - null null
2025-11-18 13:54:50.194 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:54:50.194 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Sal - 204 null null 0.9915ms
2025-11-18 13:54:50.262 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/Sal - null null
2025-11-18 13:54:50.262 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:54:50.263 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 13:54:50.265 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-18 13:54:50.283 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 13:54:50.283 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 13:54:50.284 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 13:54:50.285 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/Sal - 200 null application/json; charset=utf-8 22.4984ms
2025-11-18 13:57:20.810 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null
2025-11-18 13:57:20.810 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:57:20.810 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.305ms
2025-11-18 13:57:20.865 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 58
2025-11-18 13:57:20.866 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:57:20.866 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin'
2025-11-18 13:57:20.881 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName]
FROM [AspNetUsers] AS [a]
WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0
2025-11-18 13:57:20.993 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (Size = 450)], CommandType='"Text"', CommandTimeout='30']
SELECT [a0].[Name]
FROM [AspNetUserRoles] AS [a]
INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id]
WHERE [a].[UserId] = @__userId_0
2025-11-18 13:57:20.993 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 13:57:20.994 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json.
2025-11-18 13:57:20.994 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin'
2025-11-18 13:57:20.994 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 128.9094ms
2025-11-18 13:57:25.716 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - null null
2025-11-18 13:57:25.716 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:57:25.717 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - 204 null null 0.2406ms
2025-11-18 13:57:25.770 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - null null
2025-11-18 13:57:25.770 +00:00 [INF] CORS policy execution successful.
2025-11-18 13:57:25.771 +00:00 [INF] Executing endpoint 'HTTP: GET InventoryReplenishment/'
2025-11-18 13:57:25.775 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [t].[Id], [t].[CreatedById], [t].[CreatedDate], [t].[DeleteFlag], [t].[Description], [t].[UpdatedById], [t].[UpdatedDate], [t0].[Id], [t0].[CreatedById], [t0].[CreatedDate], [t0].[DeleteFlag], [t0].[Percentage], [t0].[TaxDescription], [t0].[UpdatedById], [t0].[UpdatedDate]
FROM [Products] AS [p]
INNER JOIN (
    SELECT [p0].[Id], [p0].[CreatedById], [p0].[CreatedDate], [p0].[DeleteFlag], [p0].[Description], [p0].[UpdatedById], [p0].[UpdatedDate]
    FROM [ProductCategories] AS [p0]
    WHERE [p0].[DeleteFlag] = CAST(0 AS bit)
) AS [t] ON [p].[CategoryId] = [t].[Id]
INNER JOIN (
    SELECT [p1].[Id], [p1].[CreatedById], [p1].[CreatedDate], [p1].[DeleteFlag], [p1].[Percentage], [p1].[TaxDescription], [p1].[UpdatedById], [p1].[UpdatedDate]
    FROM [ProductTaxes] AS [p1]
    WHERE [p1].[DeleteFlag] = CAST(0 AS bit)
) AS [t0] ON [p].[ProductTaxId] = [t0].[Id]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 3)
2025-11-18 13:57:25.926 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 13:57:25.926 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 13:57:25.927 +00:00 [INF] Executed endpoint 'HTTP: GET InventoryReplenishment/'
2025-11-18 13:57:25.927 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - 200 null application/json; charset=utf-8 156.9246ms
2025-11-18 14:01:31.677 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - null null
2025-11-18 14:01:31.677 +00:00 [INF] CORS policy execution successful.
2025-11-18 14:01:31.677 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - 204 null null 0.3441ms
2025-11-18 14:01:31.749 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - application/json 46
2025-11-18 14:01:31.749 +00:00 [INF] CORS policy execution successful.
2025-11-18 14:01:31.750 +00:00 [INF] Executing endpoint 'HTTP: POST InventoryReplenishment/createInvRepHD'
2025-11-18 14:01:31.756 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
2025-11-18 14:01:31.756 +00:00 [INF] Setting HTTP status code 201.
2025-11-18 14:01:31.756 +00:00 [INF] Writing value of type 'Guid' as Json.
2025-11-18 14:01:31.756 +00:00 [INF] Executed endpoint 'HTTP: POST InventoryReplenishment/createInvRepHD'
2025-11-18 14:01:31.756 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - 201 null application/json; charset=utf-8 7.4612ms
2025-11-18 14:01:31.829 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - null null
2025-11-18 14:01:31.829 +00:00 [INF] CORS policy execution successful.
2025-11-18 14:01:31.829 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - 204 null null 0.3343ms
2025-11-18 14:01:31.903 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - application/json 1485
2025-11-18 14:01:31.903 +00:00 [INF] CORS policy execution successful.
2025-11-18 14:01:31.904 +00:00 [INF] Executing endpoint 'HTTP: POST InventoryReplenishment/createInvRepDet'
2025-11-18 14:01:31.909 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [t].[Id], [t].[CreatedById], [t].[CreatedDate], [t].[DeleteFlag], [t].[Description], [t].[UpdatedById], [t].[UpdatedDate], [t0].[Id], [t0].[CreatedById], [t0].[CreatedDate], [t0].[DeleteFlag], [t0].[Percentage], [t0].[TaxDescription], [t0].[UpdatedById], [t0].[UpdatedDate]
FROM [Products] AS [p]
INNER JOIN (
    SELECT [p0].[Id], [p0].[CreatedById], [p0].[CreatedDate], [p0].[DeleteFlag], [p0].[Description], [p0].[UpdatedById], [p0].[UpdatedDate]
    FROM [ProductCategories] AS [p0]
    WHERE [p0].[DeleteFlag] = CAST(0 AS bit)
) AS [t] ON [p].[CategoryId] = [t].[Id]
INNER JOIN (
    SELECT [p1].[Id], [p1].[CreatedById], [p1].[CreatedDate], [p1].[DeleteFlag], [p1].[Percentage], [p1].[TaxDescription], [p1].[UpdatedById], [p1].[UpdatedDate]
    FROM [ProductTaxes] AS [p1]
    WHERE [p1].[DeleteFlag] = CAST(0 AS bit)
) AS [t0] ON [p].[ProductTaxId] = [t0].[Id]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 14:01:32.154 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2025-11-18 14:01:32.156 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2025-11-18 14:01:32.158 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2025-11-18 14:01:32.160 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2025-11-18 14:01:32.162 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2025-11-18 14:01:32.163 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2025-11-18 14:01:32.164 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2025-11-18 14:01:32.224 +00:00 [INF] Executed DbCommand (57ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Int32), @p4='?' (Size = 34), @p5='?' (DbType = Guid), @p6='?' (DbType = Int32), @p7='?' (DbType = Int32), @p8='?' (DbType = Int32), @p9='?' (Size = 4000), @p10='?' (Size = 4000), @p11='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p12='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p13='?' (DbType = Guid), @p14='?' (DbType = DateTime2), @p15='?' (DbType = Int32), @p16='?' (Size = 34), @p17='?' (DbType = Guid), @p18='?' (DbType = Int32), @p19='?' (DbType = Int32), @p20='?' (DbType = Int32), @p21='?' (Size = 4000), @p22='?' (Size = 4000), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Guid), @p26='?' (DbType = DateTime2), @p27='?' (DbType = Int32), @p28='?' (Size = 34), @p29='?' (DbType = Guid), @p30='?' (DbType = Int32), @p31='?' (DbType = Int32), @p32='?' (DbType = Int32), @p33='?' (Size = 4000), @p34='?' (Size = 4000), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @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), @p48='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p49='?' (DbType = Guid), @p50='?' (DbType = DateTime2), @p51='?' (DbType = Int32), @p52='?' (Size = 34), @p53='?' (DbType = Guid), @p54='?' (DbType = Int32), @p55='?' (DbType = Int32), @p56='?' (DbType = Int32), @p57='?' (Size = 4000), @p58='?' (Size = 4000), @p59='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p60='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p61='?' (DbType = Guid), @p62='?' (DbType = DateTime2), @p63='?' (DbType = Int32), @p64='?' (Size = 34), @p65='?' (DbType = Guid), @p66='?' (DbType = Int32), @p67='?' (DbType = Int32), @p68='?' (DbType = Int32), @p69='?' (Size = 4000), @p70='?' (Size = 4000), @p71='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p72='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p73='?' (DbType = Guid), @p74='?' (DbType = DateTime2), @p75='?' (DbType = Int32), @p76='?' (Size = 34), @p77='?' (DbType = Guid), @p78='?' (DbType = Int32), @p79='?' (DbType = Int32), @p80='?' (DbType = Int32), @p81='?' (Size = 4000), @p82='?' (Size = 4000), @p83='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p101='?' (DbType = Int32), @p84='?' (Size = 4000), @p85='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p86='?' (DbType = Int32), @p87='?' (DbType = Guid), @p88='?' (DbType = DateTime2), @p89='?' (DbType = Boolean), @p90='?' (DbType = DateTime2), @p91='?' (DbType = Int32), @p92='?' (Size = 150), @p93='?' (Size = 500), @p94='?' (Size = -1) (DbType = Binary), @p95='?' (DbType = Int32), @p96='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p97='?' (Size = 4000), @p98='?' (DbType = Int32), @p99='?' (DbType = Guid), @p100='?' (DbType = DateTime2), @p119='?' (DbType = Int32), @p102='?' (Size = 4000), @p103='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p104='?' (DbType = Int32), @p105='?' (DbType = Guid), @p106='?' (DbType = DateTime2), @p107='?' (DbType = Boolean), @p108='?' (DbType = DateTime2), @p109='?' (DbType = Int32), @p110='?' (Size = 150), @p111='?' (Size = 500), @p112='?' (Size = -1) (DbType = Binary), @p113='?' (DbType = Int32), @p114='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p115='?' (Size = 4000), @p116='?' (DbType = Int32), @p117='?' (DbType = Guid), @p118='?' (DbType = DateTime2), @p137='?' (DbType = Int32), @p120='?' (Size = 4000), @p121='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p122='?' (DbType = Int32), @p123='?' (DbType = Guid), @p124='?' (DbType = DateTime2), @p125='?' (DbType = Boolean), @p126='?' (DbType = DateTime2), @p127='?' (DbType = Int32), @p128='?' (Size = 150), @p129='?' (Size = 500), @p130='?' (Size = -1) (DbType = Binary), @p131='?' (DbType = Int32), @p132='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p133='?' (Size = 4000), @p134='?' (DbType = Int32), @p135='?' (DbType = Guid), @p136='?' (DbType = DateTime2), @p155='?' (DbType = Int32), @p138='?' (Size = 4000), @p139='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p140='?' (DbType = Int32), @p141='?' (DbType = Guid), @p142='?' (DbType = DateTime2), @p143='?' (DbType = Boolean), @p144='?' (DbType = DateTime2), @p145='?' (DbType = Int32), @p146='?' (Size = 150), @p147='?' (Size = 500), @p148='?' (Size = -1) (DbType = Binary), @p149='?' (DbType = Int32), @p150='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p151='?' (Size = 4000), @p152='?' (DbType = Int32), @p153='?' (DbType = Guid), @p154='?' (DbType = DateTime2), @p173='?' (DbType = Int32), @p156='?' (Size = 4000), @p157='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p158='?' (DbType = Int32), @p159='?' (DbType = Guid), @p160='?' (DbType = DateTime2), @p161='?' (DbType = Boolean), @p162='?' (DbType = DateTime2), @p163='?' (DbType = Int32), @p164='?' (Size = 150), @p165='?' (Size = 500), @p166='?' (Size = -1) (DbType = Binary), @p167='?' (DbType = Int32), @p168='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p169='?' (Size = 4000), @p170='?' (DbType = Int32), @p171='?' (DbType = Guid), @p172='?' (DbType = DateTime2), @p191='?' (DbType = Int32), @p174='?' (Size = 4000), @p175='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p176='?' (DbType = Int32), @p177='?' (DbType = Guid), @p178='?' (DbType = DateTime2), @p179='?' (DbType = Boolean), @p180='?' (DbType = DateTime2), @p181='?' (DbType = Int32), @p182='?' (Size = 150), @p183='?' (Size = 500), @p184='?' (Size = -1) (DbType = Binary), @p185='?' (DbType = Int32), @p186='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p187='?' (Size = 4000), @p188='?' (DbType = Int32), @p189='?' (DbType = Guid), @p190='?' (DbType = DateTime2), @p209='?' (DbType = Int32), @p192='?' (Size = 4000), @p193='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p194='?' (DbType = Int32), @p195='?' (DbType = Guid), @p196='?' (DbType = DateTime2), @p197='?' (DbType = Boolean), @p198='?' (DbType = DateTime2), @p199='?' (DbType = Int32), @p200='?' (Size = 150), @p201='?' (Size = 500), @p202='?' (Size = -1) (DbType = Binary), @p203='?' (DbType = Int32), @p204='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p205='?' (Size = 4000), @p206='?' (DbType = Int32), @p207='?' (DbType = Guid), @p208='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
MERGE [InventoryMovements] USING (
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, 0),
(@p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, 1),
(@p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35, 2),
(@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47, 3),
(@p48, @p49, @p50, @p51, @p52, @p53, @p54, @p55, @p56, @p57, @p58, @p59, 4),
(@p60, @p61, @p62, @p63, @p64, @p65, @p66, @p67, @p68, @p69, @p70, @p71, 5),
(@p72, @p73, @p74, @p75, @p76, @p77, @p78, @p79, @p80, @p81, @p82, @p83, 6)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[Difference], i.[Discriminator], i.[InventoryMovementHeaderId], i.[NewStock], i.[OriginaStock], i.[ProductId], i.[ProductName], i.[Reazon], i.[SalePrice])
OUTPUT INSERTED.[Id], i._Position;
UPDATE [Products] SET [BarCode] = @p84, [BuyPrice] = @p85, [CategoryId] = @p86, [CreatedById] = @p87, [CreatedDate] = @p88, [DeleteFlag] = @p89, [ExpirationDate] = @p90, [MinimunStock] = @p91, [Name] = @p92, [Note] = @p93, [ProductImage] = @p94, [ProductTaxId] = @p95, [SalePrice] = @p96, [Status] = @p97, [Stock] = @p98, [UpdatedById] = @p99, [UpdatedDate] = @p100
OUTPUT 1
WHERE [Id] = @p101;
UPDATE [Products] SET [BarCode] = @p102, [BuyPrice] = @p103, [CategoryId] = @p104, [CreatedById] = @p105, [CreatedDate] = @p106, [DeleteFlag] = @p107, [ExpirationDate] = @p108, [MinimunStock] = @p109, [Name] = @p110, [Note] = @p111, [ProductImage] = @p112, [ProductTaxId] = @p113, [SalePrice] = @p114, [Status] = @p115, [Stock] = @p116, [UpdatedById] = @p117, [UpdatedDate] = @p118
OUTPUT 1
WHERE [Id] = @p119;
UPDATE [Products] SET [BarCode] = @p120, [BuyPrice] = @p121, [CategoryId] = @p122, [CreatedById] = @p123, [CreatedDate] = @p124, [DeleteFlag] = @p125, [ExpirationDate] = @p126, [MinimunStock] = @p127, [Name] = @p128, [Note] = @p129, [ProductImage] = @p130, [ProductTaxId] = @p131, [SalePrice] = @p132, [Status] = @p133, [Stock] = @p134, [UpdatedById] = @p135, [UpdatedDate] = @p136
OUTPUT 1
WHERE [Id] = @p137;
UPDATE [Products] SET [BarCode] = @p138, [BuyPrice] = @p139, [CategoryId] = @p140, [CreatedById] = @p141, [CreatedDate] = @p142, [DeleteFlag] = @p143, [ExpirationDate] = @p144, [MinimunStock] = @p145, [Name] = @p146, [Note] = @p147, [ProductImage] = @p148, [ProductTaxId] = @p149, [SalePrice] = @p150, [Status] = @p151, [Stock] = @p152, [UpdatedById] = @p153, [UpdatedDate] = @p154
OUTPUT 1
WHERE [Id] = @p155;
UPDATE [Products] SET [BarCode] = @p156, [BuyPrice] = @p157, [CategoryId] = @p158, [CreatedById] = @p159, [CreatedDate] = @p160, [DeleteFlag] = @p161, [ExpirationDate] = @p162, [MinimunStock] = @p163, [Name] = @p164, [Note] = @p165, [ProductImage] = @p166, [ProductTaxId] = @p167, [SalePrice] = @p168, [Status] = @p169, [Stock] = @p170, [UpdatedById] = @p171, [UpdatedDate] = @p172
OUTPUT 1
WHERE [Id] = @p173;
UPDATE [Products] SET [BarCode] = @p174, [BuyPrice] = @p175, [CategoryId] = @p176, [CreatedById] = @p177, [CreatedDate] = @p178, [DeleteFlag] = @p179, [ExpirationDate] = @p180, [MinimunStock] = @p181, [Name] = @p182, [Note] = @p183, [ProductImage] = @p184, [ProductTaxId] = @p185, [SalePrice] = @p186, [Status] = @p187, [Stock] = @p188, [UpdatedById] = @p189, [UpdatedDate] = @p190
OUTPUT 1
WHERE [Id] = @p191;
UPDATE [Products] SET [BarCode] = @p192, [BuyPrice] = @p193, [CategoryId] = @p194, [CreatedById] = @p195, [CreatedDate] = @p196, [DeleteFlag] = @p197, [ExpirationDate] = @p198, [MinimunStock] = @p199, [Name] = @p200, [Note] = @p201, [ProductImage] = @p202, [ProductTaxId] = @p203, [SalePrice] = @p204, [Status] = @p205, [Stock] = @p206, [UpdatedById] = @p207, [UpdatedDate] = @p208
OUTPUT 1
WHERE [Id] = @p209;
2025-11-18 14:01:32.228 +00:00 [INF] Setting HTTP status code 201.
2025-11-18 14:01:32.229 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 14:01:32.229 +00:00 [INF] Executed endpoint 'HTTP: POST InventoryReplenishment/createInvRepDet'
2025-11-18 14:01:32.229 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - 201 null application/json; charset=utf-8 326.0497ms
2025-11-18 14:01:32.307 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - null null
2025-11-18 14:01:32.307 +00:00 [INF] CORS policy execution successful.
2025-11-18 14:01:32.307 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - 204 null null 0.2578ms
2025-11-18 14:01:32.378 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - null null
2025-11-18 14:01:32.378 +00:00 [INF] CORS policy execution successful.
2025-11-18 14:01:32.378 +00:00 [INF] Executing endpoint 'HTTP: GET InventoryReplenishment/'
2025-11-18 14:01:32.382 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [t].[Id], [t].[CreatedById], [t].[CreatedDate], [t].[DeleteFlag], [t].[Description], [t].[UpdatedById], [t].[UpdatedDate], [t0].[Id], [t0].[CreatedById], [t0].[CreatedDate], [t0].[DeleteFlag], [t0].[Percentage], [t0].[TaxDescription], [t0].[UpdatedById], [t0].[UpdatedDate]
FROM [Products] AS [p]
INNER JOIN (
    SELECT [p0].[Id], [p0].[CreatedById], [p0].[CreatedDate], [p0].[DeleteFlag], [p0].[Description], [p0].[UpdatedById], [p0].[UpdatedDate]
    FROM [ProductCategories] AS [p0]
    WHERE [p0].[DeleteFlag] = CAST(0 AS bit)
) AS [t] ON [p].[CategoryId] = [t].[Id]
INNER JOIN (
    SELECT [p1].[Id], [p1].[CreatedById], [p1].[CreatedDate], [p1].[DeleteFlag], [p1].[Percentage], [p1].[TaxDescription], [p1].[UpdatedById], [p1].[UpdatedDate]
    FROM [ProductTaxes] AS [p1]
    WHERE [p1].[DeleteFlag] = CAST(0 AS bit)
) AS [t0] ON [p].[ProductTaxId] = [t0].[Id]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 3)
2025-11-18 14:01:32.507 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 14:01:32.508 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 14:01:32.509 +00:00 [INF] Executed endpoint 'HTTP: GET InventoryReplenishment/'
2025-11-18 14:01:32.509 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - 200 null application/json; charset=utf-8 130.8769ms
2025-11-18 14:04:43.831 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null
2025-11-18 14:04:43.832 +00:00 [INF] CORS policy execution successful.
2025-11-18 14:04:43.832 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.856ms
2025-11-18 14:04:43.885 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 58
2025-11-18 14:04:43.885 +00:00 [INF] CORS policy execution successful.
2025-11-18 14:04:43.885 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin'
2025-11-18 14:04:44.123 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName]
FROM [AspNetUsers] AS [a]
WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0
2025-11-18 14:04:44.240 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (Size = 450)], CommandType='"Text"', CommandTimeout='30']
SELECT [a0].[Name]
FROM [AspNetUserRoles] AS [a]
INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id]
WHERE [a].[UserId] = @__userId_0
2025-11-18 14:04:44.240 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 14:04:44.241 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json.
2025-11-18 14:04:44.241 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin'
2025-11-18 14:04:44.241 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 356.2488ms
2025-11-18 14:04:48.172 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - null null
2025-11-18 14:04:48.172 +00:00 [INF] CORS policy execution successful.
2025-11-18 14:04:48.173 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - 204 null null 1.1615ms
2025-11-18 14:04:48.224 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - null null
2025-11-18 14:04:48.225 +00:00 [INF] CORS policy execution successful.
2025-11-18 14:04:48.225 +00:00 [INF] Executing endpoint 'HTTP: GET InventoryReplenishment/'
2025-11-18 14:04:48.240 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [t].[Id], [t].[CreatedById], [t].[CreatedDate], [t].[DeleteFlag], [t].[Description], [t].[UpdatedById], [t].[UpdatedDate], [t0].[Id], [t0].[CreatedById], [t0].[CreatedDate], [t0].[DeleteFlag], [t0].[Percentage], [t0].[TaxDescription], [t0].[UpdatedById], [t0].[UpdatedDate]
FROM [Products] AS [p]
INNER JOIN (
    SELECT [p0].[Id], [p0].[CreatedById], [p0].[CreatedDate], [p0].[DeleteFlag], [p0].[Description], [p0].[UpdatedById], [p0].[UpdatedDate]
    FROM [ProductCategories] AS [p0]
    WHERE [p0].[DeleteFlag] = CAST(0 AS bit)
) AS [t] ON [p].[CategoryId] = [t].[Id]
INNER JOIN (
    SELECT [p1].[Id], [p1].[CreatedById], [p1].[CreatedDate], [p1].[DeleteFlag], [p1].[Percentage], [p1].[TaxDescription], [p1].[UpdatedById], [p1].[UpdatedDate]
    FROM [ProductTaxes] AS [p1]
    WHERE [p1].[DeleteFlag] = CAST(0 AS bit)
) AS [t0] ON [p].[ProductTaxId] = [t0].[Id]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 3)
2025-11-18 14:04:48.376 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 14:04:48.376 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 14:04:48.376 +00:00 [INF] Executed endpoint 'HTTP: GET InventoryReplenishment/'
2025-11-18 14:04:48.376 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - 200 null application/json; charset=utf-8 152.1893ms
2025-11-18 14:05:14.606 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - null null
2025-11-18 14:05:14.607 +00:00 [INF] CORS policy execution successful.
2025-11-18 14:05:14.607 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - 204 null null 0.3029ms
2025-11-18 14:05:14.658 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - application/json 48
2025-11-18 14:05:14.658 +00:00 [INF] CORS policy execution successful.
2025-11-18 14:05:14.658 +00:00 [INF] Executing endpoint 'HTTP: POST InventoryReplenishment/createInvRepHD'
2025-11-18 14:05:14.663 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
2025-11-18 14:05:14.663 +00:00 [INF] Setting HTTP status code 201.
2025-11-18 14:05:14.663 +00:00 [INF] Writing value of type 'Guid' as Json.
2025-11-18 14:05:14.663 +00:00 [INF] Executed endpoint 'HTTP: POST InventoryReplenishment/createInvRepHD'
2025-11-18 14:05:14.663 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - 201 null application/json; charset=utf-8 5.331ms
2025-11-18 14:05:14.717 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - null null
2025-11-18 14:05:14.717 +00:00 [INF] CORS policy execution successful.
2025-11-18 14:05:14.717 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - 204 null null 0.4082ms
2025-11-18 14:05:14.769 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - application/json 211
2025-11-18 14:05:14.769 +00:00 [INF] CORS policy execution successful.
2025-11-18 14:05:14.769 +00:00 [INF] Executing endpoint 'HTTP: POST InventoryReplenishment/createInvRepDet'
2025-11-18 14:05:14.774 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [t].[Id], [t].[CreatedById], [t].[CreatedDate], [t].[DeleteFlag], [t].[Description], [t].[UpdatedById], [t].[UpdatedDate], [t0].[Id], [t0].[CreatedById], [t0].[CreatedDate], [t0].[DeleteFlag], [t0].[Percentage], [t0].[TaxDescription], [t0].[UpdatedById], [t0].[UpdatedDate]
FROM [Products] AS [p]
INNER JOIN (
    SELECT [p0].[Id], [p0].[CreatedById], [p0].[CreatedDate], [p0].[DeleteFlag], [p0].[Description], [p0].[UpdatedById], [p0].[UpdatedDate]
    FROM [ProductCategories] AS [p0]
    WHERE [p0].[DeleteFlag] = CAST(0 AS bit)
) AS [t] ON [p].[CategoryId] = [t].[Id]
INNER JOIN (
    SELECT [p1].[Id], [p1].[CreatedById], [p1].[CreatedDate], [p1].[DeleteFlag], [p1].[Percentage], [p1].[TaxDescription], [p1].[UpdatedById], [p1].[UpdatedDate]
    FROM [ProductTaxes] AS [p1]
    WHERE [p1].[DeleteFlag] = CAST(0 AS bit)
) AS [t0] ON [p].[ProductTaxId] = [t0].[Id]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 14:05:14.931 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2025-11-18 14:05:14.934 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Int32), @p4='?' (Size = 34), @p5='?' (DbType = Guid), @p6='?' (DbType = Int32), @p7='?' (DbType = Int32), @p8='?' (DbType = Int32), @p9='?' (Size = 4000), @p10='?' (Size = 4000), @p11='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p29='?' (DbType = Int32), @p12='?' (Size = 4000), @p13='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p14='?' (DbType = Int32), @p15='?' (DbType = Guid), @p16='?' (DbType = DateTime2), @p17='?' (DbType = Boolean), @p18='?' (DbType = DateTime2), @p19='?' (DbType = Int32), @p20='?' (Size = 150), @p21='?' (Size = 500), @p22='?' (Size = -1) (DbType = Binary), @p23='?' (DbType = Int32), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (Size = 4000), @p26='?' (DbType = Int32), @p27='?' (DbType = Guid), @p28='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11);
UPDATE [Products] SET [BarCode] = @p12, [BuyPrice] = @p13, [CategoryId] = @p14, [CreatedById] = @p15, [CreatedDate] = @p16, [DeleteFlag] = @p17, [ExpirationDate] = @p18, [MinimunStock] = @p19, [Name] = @p20, [Note] = @p21, [ProductImage] = @p22, [ProductTaxId] = @p23, [SalePrice] = @p24, [Status] = @p25, [Stock] = @p26, [UpdatedById] = @p27, [UpdatedDate] = @p28
OUTPUT 1
WHERE [Id] = @p29;
2025-11-18 14:05:14.938 +00:00 [INF] Setting HTTP status code 201.
2025-11-18 14:05:14.938 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 14:05:14.938 +00:00 [INF] Executed endpoint 'HTTP: POST InventoryReplenishment/createInvRepDet'
2025-11-18 14:05:14.939 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - 201 null application/json; charset=utf-8 169.5486ms
2025-11-18 14:05:14.991 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - null null
2025-11-18 14:05:14.991 +00:00 [INF] CORS policy execution successful.
2025-11-18 14:05:14.991 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - 204 null null 0.2441ms
2025-11-18 14:05:15.042 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - null null
2025-11-18 14:05:15.042 +00:00 [INF] CORS policy execution successful.
2025-11-18 14:05:15.042 +00:00 [INF] Executing endpoint 'HTTP: GET InventoryReplenishment/'
2025-11-18 14:05:15.046 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [t].[Id], [t].[CreatedById], [t].[CreatedDate], [t].[DeleteFlag], [t].[Description], [t].[UpdatedById], [t].[UpdatedDate], [t0].[Id], [t0].[CreatedById], [t0].[CreatedDate], [t0].[DeleteFlag], [t0].[Percentage], [t0].[TaxDescription], [t0].[UpdatedById], [t0].[UpdatedDate]
FROM [Products] AS [p]
INNER JOIN (
    SELECT [p0].[Id], [p0].[CreatedById], [p0].[CreatedDate], [p0].[DeleteFlag], [p0].[Description], [p0].[UpdatedById], [p0].[UpdatedDate]
    FROM [ProductCategories] AS [p0]
    WHERE [p0].[DeleteFlag] = CAST(0 AS bit)
) AS [t] ON [p].[CategoryId] = [t].[Id]
INNER JOIN (
    SELECT [p1].[Id], [p1].[CreatedById], [p1].[CreatedDate], [p1].[DeleteFlag], [p1].[Percentage], [p1].[TaxDescription], [p1].[UpdatedById], [p1].[UpdatedDate]
    FROM [ProductTaxes] AS [p1]
    WHERE [p1].[DeleteFlag] = CAST(0 AS bit)
) AS [t0] ON [p].[ProductTaxId] = [t0].[Id]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 3)
2025-11-18 14:05:15.176 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 14:05:15.177 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 14:05:15.178 +00:00 [INF] Executed endpoint 'HTTP: GET InventoryReplenishment/'
2025-11-18 14:05:15.181 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - 200 null application/json; charset=utf-8 139.5093ms
2025-11-18 14:34:33.827 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - null null
2025-11-18 14:34:33.827 +00:00 [INF] CORS policy execution successful.
2025-11-18 14:34:33.827 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - 204 null null 0.3228ms
2025-11-18 14:34:33.897 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - null null
2025-11-18 14:34:33.897 +00:00 [INF] CORS policy execution successful.
2025-11-18 14:34:33.897 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2025-11-18 14:34:33.897 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2025-11-18 14:34:33.897 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - 400 0 null 0.73ms
2025-11-18 14:42:24.016 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - null null
2025-11-18 14:42:24.016 +00:00 [INF] CORS policy execution successful.
2025-11-18 14:42:24.017 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - 204 null null 0.3657ms
2025-11-18 14:42:24.076 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - null null
2025-11-18 14:42:24.076 +00:00 [INF] CORS policy execution successful.
2025-11-18 14:42:24.077 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2025-11-18 14:42:24.077 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2025-11-18 14:42:24.077 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - 400 0 null 0.7462ms
2025-11-18 14:55:23.776 +00:00 [INF] Request starting HTTP/1.1 GET http://localhost:5227/.env - null null
2025-11-18 14:55:23.777 +00:00 [INF] Request finished HTTP/1.1 GET http://localhost:5227/.env - 404 0 null 0.2737ms
2025-11-18 14:55:23.777 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://localhost:5227/.env, Response status code: 404
2025-11-18 16:10:05.558 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/silver - null null
2025-11-18 16:10:05.558 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:10:05.558 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/silver - 204 null null 0.3914ms
2025-11-18 16:10:05.618 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/silver - null null
2025-11-18 16:10:05.618 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:10:05.619 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 16:10:05.853 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-18 16:10:05.859 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 16:10:05.859 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 16:10:05.859 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 16:10:05.859 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/silver - 200 null application/json; charset=utf-8 241.1232ms
2025-11-18 16:10:16.449 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/customers/ByName/l - null null
2025-11-18 16:10:16.450 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:10:16.450 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/customers/ByName/l - 204 null null 0.3109ms
2025-11-18 16:10:16.512 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/customers/ByName/l - null null
2025-11-18 16:10:16.512 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:10:16.512 +00:00 [INF] Executing endpoint 'HTTP: GET Customers/ByName/{name}'
2025-11-18 16:10:16.515 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__name_0_contains='?' (Size = 150)], CommandType='"Text"', CommandTimeout='30']
SELECT [c].[Id], [c].[Address], [c].[BirthDate], [c].[Cedula], [c].[CellPhone], [c].[CreatedById], [c].[CreatedDate], [c].[DeleteFlag], [c].[Email], [c].[Gender], [c].[HomePhone], [c].[Name], [c].[NationalityId], [c].[NationalityId1], [c].[Phone], [c].[UpdatedById], [c].[UpdatedDate]
FROM [Customers] AS [c]
WHERE [c].[DeleteFlag] = CAST(0 AS bit) AND [c].[Name] LIKE @__name_0_contains ESCAPE N'\'
2025-11-18 16:10:16.515 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 16:10:16.515 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 16:10:16.515 +00:00 [INF] Executed endpoint 'HTTP: GET Customers/ByName/{name}'
2025-11-18 16:10:16.515 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/customers/ByName/l - 200 null application/json; charset=utf-8 3.3724ms
2025-11-18 16:10:16.958 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/customers/ByName/lui - null null
2025-11-18 16:10:16.959 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:10:16.959 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/customers/ByName/lui - 204 null null 0.3392ms
2025-11-18 16:10:17.025 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/customers/ByName/lui - null null
2025-11-18 16:10:17.025 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:10:17.025 +00:00 [INF] Executing endpoint 'HTTP: GET Customers/ByName/{name}'
2025-11-18 16:10:17.029 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__name_0_contains='?' (Size = 150)], CommandType='"Text"', CommandTimeout='30']
SELECT [c].[Id], [c].[Address], [c].[BirthDate], [c].[Cedula], [c].[CellPhone], [c].[CreatedById], [c].[CreatedDate], [c].[DeleteFlag], [c].[Email], [c].[Gender], [c].[HomePhone], [c].[Name], [c].[NationalityId], [c].[NationalityId1], [c].[Phone], [c].[UpdatedById], [c].[UpdatedDate]
FROM [Customers] AS [c]
WHERE [c].[DeleteFlag] = CAST(0 AS bit) AND [c].[Name] LIKE @__name_0_contains ESCAPE N'\'
2025-11-18 16:10:17.029 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 16:10:17.029 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 16:10:17.029 +00:00 [INF] Executed endpoint 'HTTP: GET Customers/ByName/{name}'
2025-11-18 16:10:17.030 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/customers/ByName/lui - 200 null application/json; charset=utf-8 4.5607ms
2025-11-18 16:10:17.575 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/customers/ByName/luisa - null null
2025-11-18 16:10:17.575 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:10:17.575 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/customers/ByName/luisa - 204 null null 0.2155ms
2025-11-18 16:10:17.645 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/customers/ByName/luisa - null null
2025-11-18 16:10:17.645 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:10:17.645 +00:00 [INF] Executing endpoint 'HTTP: GET Customers/ByName/{name}'
2025-11-18 16:10:17.648 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__name_0_contains='?' (Size = 150)], CommandType='"Text"', CommandTimeout='30']
SELECT [c].[Id], [c].[Address], [c].[BirthDate], [c].[Cedula], [c].[CellPhone], [c].[CreatedById], [c].[CreatedDate], [c].[DeleteFlag], [c].[Email], [c].[Gender], [c].[HomePhone], [c].[Name], [c].[NationalityId], [c].[NationalityId1], [c].[Phone], [c].[UpdatedById], [c].[UpdatedDate]
FROM [Customers] AS [c]
WHERE [c].[DeleteFlag] = CAST(0 AS bit) AND [c].[Name] LIKE @__name_0_contains ESCAPE N'\'
2025-11-18 16:10:17.649 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 16:10:17.649 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 16:10:17.649 +00:00 [INF] Executed endpoint 'HTTP: GET Customers/ByName/{name}'
2025-11-18 16:10:17.649 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/customers/ByName/luisa - 200 null application/json; charset=utf-8 4.4998ms
2025-11-18 16:10:21.554 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/customers/ByName/luisa mercedes muñoz de los santo - null null
2025-11-18 16:10:21.555 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:10:21.555 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/customers/ByName/luisa mercedes muñoz de los santo - 204 null null 1.0728ms
2025-11-18 16:10:21.614 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/customers/ByName/luisa mercedes muñoz de los santo - null null
2025-11-18 16:10:21.614 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:10:21.614 +00:00 [INF] Executing endpoint 'HTTP: GET Customers/ByName/{name}'
2025-11-18 16:10:21.617 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__name_0_contains='?' (Size = 150)], CommandType='"Text"', CommandTimeout='30']
SELECT [c].[Id], [c].[Address], [c].[BirthDate], [c].[Cedula], [c].[CellPhone], [c].[CreatedById], [c].[CreatedDate], [c].[DeleteFlag], [c].[Email], [c].[Gender], [c].[HomePhone], [c].[Name], [c].[NationalityId], [c].[NationalityId1], [c].[Phone], [c].[UpdatedById], [c].[UpdatedDate]
FROM [Customers] AS [c]
WHERE [c].[DeleteFlag] = CAST(0 AS bit) AND [c].[Name] LIKE @__name_0_contains ESCAPE N'\'
2025-11-18 16:10:21.617 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 16:10:21.617 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 16:10:21.617 +00:00 [INF] Executed endpoint 'HTTP: GET Customers/ByName/{name}'
2025-11-18 16:10:21.617 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/customers/ByName/luisa mercedes muñoz de los santo - 200 null application/json; charset=utf-8 3.042ms
2025-11-18 16:10:24.063 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/customers/ByName/l - null null
2025-11-18 16:10:24.064 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:10:24.064 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/customers/ByName/l - 204 null null 0.2845ms
2025-11-18 16:10:24.123 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/customers/ByName/l - null null
2025-11-18 16:10:24.124 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:10:24.124 +00:00 [INF] Executing endpoint 'HTTP: GET Customers/ByName/{name}'
2025-11-18 16:10:24.127 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__name_0_contains='?' (Size = 150)], CommandType='"Text"', CommandTimeout='30']
SELECT [c].[Id], [c].[Address], [c].[BirthDate], [c].[Cedula], [c].[CellPhone], [c].[CreatedById], [c].[CreatedDate], [c].[DeleteFlag], [c].[Email], [c].[Gender], [c].[HomePhone], [c].[Name], [c].[NationalityId], [c].[NationalityId1], [c].[Phone], [c].[UpdatedById], [c].[UpdatedDate]
FROM [Customers] AS [c]
WHERE [c].[DeleteFlag] = CAST(0 AS bit) AND [c].[Name] LIKE @__name_0_contains ESCAPE N'\'
2025-11-18 16:10:24.128 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 16:10:24.128 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 16:10:24.128 +00:00 [INF] Executed endpoint 'HTTP: GET Customers/ByName/{name}'
2025-11-18 16:10:24.128 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/customers/ByName/l - 200 null application/json; charset=utf-8 4.7719ms
2025-11-18 16:10:24.574 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/customers/ByName/lui - null null
2025-11-18 16:10:24.574 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:10:24.574 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/customers/ByName/lui - 204 null null 0.3607ms
2025-11-18 16:10:24.633 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/customers/ByName/lui - null null
2025-11-18 16:10:24.634 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:10:24.634 +00:00 [INF] Executing endpoint 'HTTP: GET Customers/ByName/{name}'
2025-11-18 16:10:24.636 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__name_0_contains='?' (Size = 150)], CommandType='"Text"', CommandTimeout='30']
SELECT [c].[Id], [c].[Address], [c].[BirthDate], [c].[Cedula], [c].[CellPhone], [c].[CreatedById], [c].[CreatedDate], [c].[DeleteFlag], [c].[Email], [c].[Gender], [c].[HomePhone], [c].[Name], [c].[NationalityId], [c].[NationalityId1], [c].[Phone], [c].[UpdatedById], [c].[UpdatedDate]
FROM [Customers] AS [c]
WHERE [c].[DeleteFlag] = CAST(0 AS bit) AND [c].[Name] LIKE @__name_0_contains ESCAPE N'\'
2025-11-18 16:10:24.636 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 16:10:24.636 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 16:10:24.636 +00:00 [INF] Executed endpoint 'HTTP: GET Customers/ByName/{name}'
2025-11-18 16:10:24.636 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/customers/ByName/lui - 200 null application/json; charset=utf-8 2.9248ms
2025-11-18 16:10:25.123 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/customers/ByName/luisa - null null
2025-11-18 16:10:25.124 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:10:25.124 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/customers/ByName/luisa - 204 null null 0.302ms
2025-11-18 16:10:25.183 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/customers/ByName/luisa - null null
2025-11-18 16:10:25.184 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:10:25.184 +00:00 [INF] Executing endpoint 'HTTP: GET Customers/ByName/{name}'
2025-11-18 16:10:25.186 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__name_0_contains='?' (Size = 150)], CommandType='"Text"', CommandTimeout='30']
SELECT [c].[Id], [c].[Address], [c].[BirthDate], [c].[Cedula], [c].[CellPhone], [c].[CreatedById], [c].[CreatedDate], [c].[DeleteFlag], [c].[Email], [c].[Gender], [c].[HomePhone], [c].[Name], [c].[NationalityId], [c].[NationalityId1], [c].[Phone], [c].[UpdatedById], [c].[UpdatedDate]
FROM [Customers] AS [c]
WHERE [c].[DeleteFlag] = CAST(0 AS bit) AND [c].[Name] LIKE @__name_0_contains ESCAPE N'\'
2025-11-18 16:10:25.187 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 16:10:25.187 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 16:10:25.187 +00:00 [INF] Executed endpoint 'HTTP: GET Customers/ByName/{name}'
2025-11-18 16:10:25.187 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/customers/ByName/luisa - 200 null application/json; charset=utf-8 3.4817ms
2025-11-18 16:10:30.065 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-11-18 16:10:30.066 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:10:30.066 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.34ms
2025-11-18 16:10:30.125 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 179
2025-11-18 16:10:30.126 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:10:30.126 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-11-18 16:10:30.130 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2025-11-18 16:10:30.133 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2025-11-18 16:10:30.133 +00:00 [INF] Setting HTTP status code 201.
2025-11-18 16:10:30.133 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-11-18 16:10:30.133 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-11-18 16:10:30.133 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 7.8508ms
2025-11-18 16:10:30.196 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40944 - null null
2025-11-18 16:10:30.196 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:10:30.196 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40944 - 204 null null 0.2479ms
2025-11-18 16:10:30.253 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/purchasedproducts - null null
2025-11-18 16:10:30.253 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:10:30.254 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/purchasedproducts - 204 null null 0.5977ms
2025-11-18 16:10:30.261 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40944 - application/json 102
2025-11-18 16:10:30.261 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:10:30.261 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-18 16:10:30.262 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 16:10:30.262 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:10:30.262 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.1563ms
2025-11-18 16:10:30.264 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 16:10:30.312 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/purchasedproducts - application/json 40
2025-11-18 16:10:30.313 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:10:30.313 +00:00 [INF] Executing endpoint 'HTTP: POST PurchasedProducts/'
2025-11-18 16:10:30.329 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 16:10:30.329 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:10:30.329 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 16:10:30.337 +00:00 [INF] Executed DbCommand (7ms) [Parameters=[@p0='?' (Size = 11), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int64)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [PurchasedProducts] ([Cedula], [CreatedById], [CreatedDate], [DeleteFlag], [SalesId])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4);
2025-11-18 16:10:30.337 +00:00 [INF] Setting HTTP status code 201.
2025-11-18 16:10:30.337 +00:00 [INF] Writing value of type 'PurchasedProductsDto' as Json.
2025-11-18 16:10:30.337 +00:00 [INF] Executed endpoint 'HTTP: POST PurchasedProducts/'
2025-11-18 16:10:30.337 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/purchasedproducts - 201 null application/json; charset=utf-8 25.1015ms
2025-11-18 16:10:30.347 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 16:10:30.347 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 16:10:30.347 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 16:10:30.347 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 16:10:30.347 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 18.593ms
2025-11-18 16:10:30.422 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2025-11-18 16:10:30.424 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35);
INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
OUTPUT INSERTED.[Id]
VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47);
2025-11-18 16:10:30.427 +00:00 [INF] Setting HTTP status code 201.
2025-11-18 16:10:30.427 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-18 16:10:30.427 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40944 - 201 0 null 166.2949ms
2025-11-18 16:48:22.625 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null
2025-11-18 16:48:22.625 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:48:22.626 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.3679ms
2025-11-18 16:48:22.695 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 58
2025-11-18 16:48:22.695 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:48:22.695 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin'
2025-11-18 16:48:22.993 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName]
FROM [AspNetUsers] AS [a]
WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0
2025-11-18 16:48:23.105 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (Size = 450)], CommandType='"Text"', CommandTimeout='30']
SELECT [a0].[Name]
FROM [AspNetUserRoles] AS [a]
INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id]
WHERE [a].[UserId] = @__userId_0
2025-11-18 16:48:23.105 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 16:48:23.105 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json.
2025-11-18 16:48:23.105 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin'
2025-11-18 16:48:23.105 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 410.6625ms
2025-11-18 16:48:27.254 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null
2025-11-18 16:48:27.254 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:48:27.254 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.2381ms
2025-11-18 16:48:27.309 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2025-11-18 16:48:27.310 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:48:27.310 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.2869ms
2025-11-18 16:48:27.322 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - null null
2025-11-18 16:48:27.322 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:48:27.322 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - 204 null null 0.2081ms
2025-11-18 16:48:27.322 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null
2025-11-18 16:48:27.322 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:48:27.323 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/'
2025-11-18 16:48:27.335 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate]
FROM [Settings] AS [s]
2025-11-18 16:48:27.336 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 16:48:27.336 +00:00 [INF] Writing value of type 'SettingDto' as Json.
2025-11-18 16:48:27.336 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/'
2025-11-18 16:48:27.336 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 14.3177ms
2025-11-18 16:48:27.364 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2025-11-18 16:48:27.365 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:48:27.365 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2025-11-18 16:48:27.367 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [ProductTaxes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 16:48:27.368 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 16:48:27.368 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 16:48:27.368 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2025-11-18 16:48:27.369 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 4.5237ms
2025-11-18 16:48:27.383 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Products - null null
2025-11-18 16:48:27.383 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:48:27.384 +00:00 [INF] Executing endpoint 'HTTP: GET /products'
2025-11-18 16:48:27.388 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [t].[Id], [t].[CreatedById], [t].[CreatedDate], [t].[DeleteFlag], [t].[Description], [t].[UpdatedById], [t].[UpdatedDate], [t0].[Id], [t0].[CreatedById], [t0].[CreatedDate], [t0].[DeleteFlag], [t0].[Percentage], [t0].[TaxDescription], [t0].[UpdatedById], [t0].[UpdatedDate]
FROM [Products] AS [p]
INNER JOIN (
    SELECT [p0].[Id], [p0].[CreatedById], [p0].[CreatedDate], [p0].[DeleteFlag], [p0].[Description], [p0].[UpdatedById], [p0].[UpdatedDate]
    FROM [ProductCategories] AS [p0]
    WHERE [p0].[DeleteFlag] = CAST(0 AS bit)
) AS [t] ON [p].[CategoryId] = [t].[Id]
INNER JOIN (
    SELECT [p1].[Id], [p1].[CreatedById], [p1].[CreatedDate], [p1].[DeleteFlag], [p1].[Percentage], [p1].[TaxDescription], [p1].[UpdatedById], [p1].[UpdatedDate]
    FROM [ProductTaxes] AS [p1]
    WHERE [p1].[DeleteFlag] = CAST(0 AS bit)
) AS [t0] ON [p].[ProductTaxId] = [t0].[Id]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 16:48:27.541 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 16:48:27.542 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 16:48:28.181 +00:00 [INF] Executed endpoint 'HTTP: GET /products'
2025-11-18 16:48:28.181 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Products - 200 null application/json; charset=utf-8 798.1792ms
2025-11-18 16:48:30.207 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2025-11-18 16:48:30.208 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:48:30.208 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2025-11-18 16:48:30.210 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [ProductTaxes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 16:48:30.211 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 16:48:30.211 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 16:48:30.211 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2025-11-18 16:48:30.212 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 4.2186ms
2025-11-18 16:48:30.214 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductCategory - null null
2025-11-18 16:48:30.214 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:48:30.214 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductCategory - 204 null null 0.6573ms
2025-11-18 16:48:30.274 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductCategory - null null
2025-11-18 16:48:30.274 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:48:30.274 +00:00 [INF] Executing endpoint 'HTTP: GET ProductCategory/'
2025-11-18 16:48:30.276 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Description], [p].[UpdatedById], [p].[UpdatedDate]
FROM [ProductCategories] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 16:48:30.277 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 16:48:30.277 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 16:48:30.277 +00:00 [INF] Executed endpoint 'HTTP: GET ProductCategory/'
2025-11-18 16:48:30.278 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductCategory - 200 null application/json; charset=utf-8 3.931ms
2025-11-18 16:49:16.093 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products - null null
2025-11-18 16:49:16.093 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:49:16.093 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products - 204 null null 0.334ms
2025-11-18 16:49:16.154 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/products - application/json 23607
2025-11-18 16:49:16.154 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:49:16.154 +00:00 [INF] Executing endpoint 'HTTP: POST Products/'
2025-11-18 16:49:16.218 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@p0='?' (Size = 4000), @p1='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p2='?' (DbType = Int32), @p3='?' (DbType = Guid), @p4='?' (DbType = DateTime2), @p5='?' (DbType = Boolean), @p6='?' (DbType = DateTime2), @p7='?' (DbType = Int32), @p8='?' (Size = 150), @p9='?' (Size = 500), @p10='?' (Size = -1) (DbType = Binary), @p11='?' (DbType = Int32), @p12='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p13='?' (Size = 4000), @p14='?' (DbType = Int32), @p15='?' (DbType = Guid), @p16='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Products] ([BarCode], [BuyPrice], [CategoryId], [CreatedById], [CreatedDate], [DeleteFlag], [ExpirationDate], [MinimunStock], [Name], [Note], [ProductImage], [ProductTaxId], [SalePrice], [Status], [Stock], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16);
2025-11-18 16:49:16.219 +00:00 [INF] Setting HTTP status code 201.
2025-11-18 16:49:16.219 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json.
2025-11-18 16:49:16.219 +00:00 [INF] Executed endpoint 'HTTP: POST Products/'
2025-11-18 16:49:16.219 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/products - 201 null application/json; charset=utf-8 65.7619ms
2025-11-18 16:49:18.341 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - null null
2025-11-18 16:49:18.341 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:49:18.341 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - 204 null null 0.3257ms
2025-11-18 16:49:18.342 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2025-11-18 16:49:18.342 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:49:18.342 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.1951ms
2025-11-18 16:49:18.348 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null
2025-11-18 16:49:18.349 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:49:18.349 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.6384ms
2025-11-18 16:49:18.398 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2025-11-18 16:49:18.398 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:49:18.398 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2025-11-18 16:49:18.401 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [ProductTaxes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 16:49:18.401 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 16:49:18.401 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 16:49:18.401 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2025-11-18 16:49:18.401 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 3.4924ms
2025-11-18 16:49:18.409 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null
2025-11-18 16:49:18.409 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:49:18.410 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/'
2025-11-18 16:49:18.410 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Products - null null
2025-11-18 16:49:18.410 +00:00 [INF] CORS policy execution successful.
2025-11-18 16:49:18.410 +00:00 [INF] Executing endpoint 'HTTP: GET /products'
2025-11-18 16:49:18.412 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate]
FROM [Settings] AS [s]
2025-11-18 16:49:18.413 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 16:49:18.413 +00:00 [INF] Writing value of type 'SettingDto' as Json.
2025-11-18 16:49:18.413 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/'
2025-11-18 16:49:18.413 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 4.182ms
2025-11-18 16:49:18.426 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [t].[Id], [t].[CreatedById], [t].[CreatedDate], [t].[DeleteFlag], [t].[Description], [t].[UpdatedById], [t].[UpdatedDate], [t0].[Id], [t0].[CreatedById], [t0].[CreatedDate], [t0].[DeleteFlag], [t0].[Percentage], [t0].[TaxDescription], [t0].[UpdatedById], [t0].[UpdatedDate]
FROM [Products] AS [p]
INNER JOIN (
    SELECT [p0].[Id], [p0].[CreatedById], [p0].[CreatedDate], [p0].[DeleteFlag], [p0].[Description], [p0].[UpdatedById], [p0].[UpdatedDate]
    FROM [ProductCategories] AS [p0]
    WHERE [p0].[DeleteFlag] = CAST(0 AS bit)
) AS [t] ON [p].[CategoryId] = [t].[Id]
INNER JOIN (
    SELECT [p1].[Id], [p1].[CreatedById], [p1].[CreatedDate], [p1].[DeleteFlag], [p1].[Percentage], [p1].[TaxDescription], [p1].[UpdatedById], [p1].[UpdatedDate]
    FROM [ProductTaxes] AS [p1]
    WHERE [p1].[DeleteFlag] = CAST(0 AS bit)
) AS [t0] ON [p].[ProductTaxId] = [t0].[Id]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 16:49:18.601 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 16:49:18.602 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 16:49:19.362 +00:00 [INF] Executed endpoint 'HTTP: GET /products'
2025-11-18 16:49:19.362 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Products - 200 null application/json; charset=utf-8 952.1013ms
2025-11-18 17:06:45.138 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/SAL - null null
2025-11-18 17:06:45.138 +00:00 [INF] CORS policy execution successful.
2025-11-18 17:06:45.138 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/SAL - 204 null null 0.2861ms
2025-11-18 17:06:45.203 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/SAL - null null
2025-11-18 17:06:45.203 +00:00 [INF] CORS policy execution successful.
2025-11-18 17:06:45.204 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 17:06:45.444 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-18 17:06:45.457 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 17:06:45.458 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 17:06:45.691 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 17:06:45.691 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/SAL - 200 null application/json; charset=utf-8 487.8968ms
2025-11-18 17:07:51.060 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 17:07:51.060 +00:00 [INF] CORS policy execution successful.
2025-11-18 17:07:51.060 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3026ms
2025-11-18 17:07:51.119 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 17:07:51.119 +00:00 [INF] CORS policy execution successful.
2025-11-18 17:07:51.119 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 17:07:51.121 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 17:07:51.121 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 17:07:51.121 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 17:07:51.122 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 17:07:51.122 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 2.9632ms
2025-11-18 17:42:12.043 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/PROBIOTICO - null null
2025-11-18 17:42:12.043 +00:00 [INF] CORS policy execution successful.
2025-11-18 17:42:12.043 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/PROBIOTICO - 204 null null 0.3055ms
2025-11-18 17:42:12.104 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/PROBIOTICO - null null
2025-11-18 17:42:12.104 +00:00 [INF] CORS policy execution successful.
2025-11-18 17:42:12.104 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 17:42:12.383 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-18 17:42:12.384 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 17:42:12.384 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 17:42:12.385 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 17:42:12.385 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/PROBIOTICO - 200 null application/json; charset=utf-8 281.6105ms
2025-11-18 17:42:48.287 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/RED - null null
2025-11-18 17:42:48.287 +00:00 [INF] CORS policy execution successful.
2025-11-18 17:42:48.287 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/RED - 204 null null 0.238ms
2025-11-18 17:42:48.356 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/RED - null null
2025-11-18 17:42:48.356 +00:00 [INF] CORS policy execution successful.
2025-11-18 17:42:48.356 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 17:42:48.359 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-18 17:42:48.362 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 17:42:48.362 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 17:42:48.473 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 17:42:48.473 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/RED - 200 null application/json; charset=utf-8 117.09ms
2025-11-18 17:43:32.077 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 17:43:32.077 +00:00 [INF] CORS policy execution successful.
2025-11-18 17:43:32.077 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2902ms
2025-11-18 17:43:32.146 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 17:43:32.146 +00:00 [INF] CORS policy execution successful.
2025-11-18 17:43:32.146 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 17:43:32.148 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 17:43:32.149 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 17:43:32.149 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 17:43:32.149 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 17:43:32.150 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 3.6062ms
2025-11-18 19:21:49.908 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/vii - null null
2025-11-18 19:21:49.908 +00:00 [INF] CORS policy execution successful.
2025-11-18 19:21:49.908 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/vii - 204 null null 0.3701ms
2025-11-18 19:21:49.971 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/vii - null null
2025-11-18 19:21:49.971 +00:00 [INF] CORS policy execution successful.
2025-11-18 19:21:49.971 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 19:21:50.245 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-18 19:21:50.246 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 19:21:50.246 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 19:21:50.246 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 19:21:50.247 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/vii - 200 null application/json; charset=utf-8 275.7885ms
2025-11-18 19:21:53.730 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Vivian - null null
2025-11-18 19:21:53.730 +00:00 [INF] CORS policy execution successful.
2025-11-18 19:21:53.730 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Vivian - 204 null null 0.2277ms
2025-11-18 19:21:53.790 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/Vivian - null null
2025-11-18 19:21:53.790 +00:00 [INF] CORS policy execution successful.
2025-11-18 19:21:53.790 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 19:21:53.793 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-18 19:21:53.796 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 19:21:53.796 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 19:21:53.796 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 19:21:53.796 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/Vivian - 200 null application/json; charset=utf-8 6.0808ms
2025-11-18 19:21:59.859 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-11-18 19:21:59.859 +00:00 [INF] CORS policy execution successful.
2025-11-18 19:21:59.859 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3468ms
2025-11-18 19:21:59.919 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2025-11-18 19:21:59.919 +00:00 [INF] CORS policy execution successful.
2025-11-18 19:21:59.919 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-11-18 19:21:59.924 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2025-11-18 19:21:59.928 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2025-11-18 19:21:59.929 +00:00 [INF] Setting HTTP status code 201.
2025-11-18 19:21:59.929 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-11-18 19:21:59.929 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-11-18 19:21:59.930 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 10.6871ms
2025-11-18 19:21:59.989 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40945 - null null
2025-11-18 19:21:59.990 +00:00 [INF] CORS policy execution successful.
2025-11-18 19:21:59.990 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40945 - 204 null null 0.673ms
2025-11-18 19:22:00.047 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 19:22:00.047 +00:00 [INF] CORS policy execution successful.
2025-11-18 19:22:00.047 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2711ms
2025-11-18 19:22:00.078 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40945 - application/json 105
2025-11-18 19:22:00.079 +00:00 [INF] CORS policy execution successful.
2025-11-18 19:22:00.079 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-18 19:22:00.082 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 19:22:00.109 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 19:22:00.109 +00:00 [INF] CORS policy execution successful.
2025-11-18 19:22:00.110 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 19:22:00.140 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 19:22:00.140 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 19:22:00.140 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 19:22:00.140 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 19:22:00.140 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 31.3654ms
2025-11-18 19:22:00.222 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2025-11-18 19:22:00.224 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35);
INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
OUTPUT INSERTED.[Id]
VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47);
2025-11-18 19:22:00.227 +00:00 [INF] Setting HTTP status code 201.
2025-11-18 19:22:00.227 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-18 19:22:00.227 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40945 - 201 0 null 148.8215ms
2025-11-18 21:20:27.252 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/omega - null null
2025-11-18 21:20:27.253 +00:00 [INF] CORS policy execution successful.
2025-11-18 21:20:27.253 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/omega - 204 null null 0.6106ms
2025-11-18 21:20:27.312 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/omega - null null
2025-11-18 21:20:27.313 +00:00 [INF] CORS policy execution successful.
2025-11-18 21:20:27.313 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 21:20:27.576 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-18 21:20:27.585 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 21:20:27.585 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 21:20:27.697 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 21:20:27.698 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/omega - 200 null application/json; charset=utf-8 385.5294ms
2025-11-18 21:20:35.841 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/miel - null null
2025-11-18 21:20:35.841 +00:00 [INF] CORS policy execution successful.
2025-11-18 21:20:35.841 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/miel - 204 null null 0.2692ms
2025-11-18 21:20:35.901 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/miel - null null
2025-11-18 21:20:35.901 +00:00 [INF] CORS policy execution successful.
2025-11-18 21:20:35.901 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 21:20:35.904 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-18 21:20:35.910 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 21:20:35.910 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 21:20:35.911 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 21:20:35.911 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/miel - 200 null application/json; charset=utf-8 10.7479ms
2025-11-18 21:21:46.276 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-11-18 21:21:46.276 +00:00 [INF] CORS policy execution successful.
2025-11-18 21:21:46.276 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.2558ms
2025-11-18 21:21:46.335 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 188
2025-11-18 21:21:46.336 +00:00 [INF] CORS policy execution successful.
2025-11-18 21:21:46.336 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-11-18 21:21:46.340 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2025-11-18 21:21:46.345 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2025-11-18 21:21:46.345 +00:00 [INF] Setting HTTP status code 201.
2025-11-18 21:21:46.345 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-11-18 21:21:46.345 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-11-18 21:21:46.345 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 10.186ms
2025-11-18 21:21:46.409 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40946 - null null
2025-11-18 21:21:46.409 +00:00 [INF] CORS policy execution successful.
2025-11-18 21:21:46.409 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40946 - 204 null null 0.2714ms
2025-11-18 21:21:46.464 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 21:21:46.465 +00:00 [INF] CORS policy execution successful.
2025-11-18 21:21:46.465 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2585ms
2025-11-18 21:21:46.495 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40946 - application/json 211
2025-11-18 21:21:46.496 +00:00 [INF] CORS policy execution successful.
2025-11-18 21:21:46.496 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-18 21:21:46.498 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 21:21:46.525 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 21:21:46.525 +00:00 [INF] CORS policy execution successful.
2025-11-18 21:21:46.526 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 21:21:46.539 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 21:21:46.539 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 21:21:46.539 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 21:21:46.539 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 21:21:46.539 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 14.3359ms
2025-11-18 21:21:46.630 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2025-11-18 21:21:46.633 +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), @p40='?' (DbType = Int32), @p23='?' (Size = 4000), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Int32), @p26='?' (DbType = Guid), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Boolean), @p29='?' (DbType = DateTime2), @p30='?' (DbType = Int32), @p31='?' (Size = 150), @p32='?' (Size = 500), @p33='?' (Size = -1) (DbType = Binary), @p34='?' (DbType = Int32), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p36='?' (Size = 4000), @p37='?' (DbType = Int32), @p38='?' (DbType = Guid), @p39='?' (DbType = DateTime2), @p41='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p42='?' (DbType = Guid), @p43='?' (DbType = DateTime2), @p44='?' (DbType = Boolean), @p45='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p46='?' (DbType = Int32), @p47='?' (DbType = Int32), @p48='?' (DbType = Int64), @p49='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p50='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p51='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p52='?' (DbType = Guid), @p53='?' (DbType = DateTime2), @p54='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p55='?' (DbType = Guid), @p56='?' (DbType = DateTime2), @p57='?' (DbType = Boolean), @p58='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p59='?' (DbType = Int32), @p60='?' (DbType = Int32), @p61='?' (DbType = Int64), @p62='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p63='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p64='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p65='?' (DbType = Guid), @p66='?' (DbType = DateTime2), @p67='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p68='?' (DbType = Guid), @p69='?' (DbType = DateTime2), @p70='?' (DbType = Int32), @p71='?' (Size = 34), @p72='?' (DbType = Guid), @p73='?' (DbType = Int32), @p74='?' (DbType = Int32), @p75='?' (DbType = Int32), @p76='?' (Size = 4000), @p77='?' (Size = 4000), @p78='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p79='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p80='?' (DbType = Guid), @p81='?' (DbType = DateTime2), @p82='?' (DbType = Int32), @p83='?' (Size = 34), @p84='?' (DbType = Guid), @p85='?' (DbType = Int32), @p86='?' (DbType = Int32), @p87='?' (DbType = Int32), @p88='?' (Size = 4000), @p89='?' (Size = 4000), @p90='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
UPDATE [Products] SET [BarCode] = @p23, [BuyPrice] = @p24, [CategoryId] = @p25, [CreatedById] = @p26, [CreatedDate] = @p27, [DeleteFlag] = @p28, [ExpirationDate] = @p29, [MinimunStock] = @p30, [Name] = @p31, [Note] = @p32, [ProductImage] = @p33, [ProductTaxId] = @p34, [SalePrice] = @p35, [Status] = @p36, [Stock] = @p37, [UpdatedById] = @p38, [UpdatedDate] = @p39
OUTPUT 1
WHERE [Id] = @p40;
MERGE [SalesDetail] USING (
VALUES (@p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52, @p53, 0),
(@p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62, @p63, @p64, @p65, @p66, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[DeleteFlag], i.[DiscountAmount], i.[ProductId], i.[Quantity], i.[SalesId], i.[Tax], i.[Total], i.[UnitPrice], i.[UpdatedById], i.[UpdatedDate])
OUTPUT INSERTED.[Id], i._Position;
MERGE [InventoryMovements] USING (
VALUES (@p67, @p68, @p69, @p70, @p71, @p72, @p73, @p74, @p75, @p76, @p77, @p78, 0),
(@p79, @p80, @p81, @p82, @p83, @p84, @p85, @p86, @p87, @p88, @p89, @p90, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[Difference], i.[Discriminator], i.[InventoryMovementHeaderId], i.[NewStock], i.[OriginaStock], i.[ProductId], i.[ProductName], i.[Reazon], i.[SalePrice])
OUTPUT INSERTED.[Id], i._Position;
2025-11-18 21:21:46.638 +00:00 [INF] Setting HTTP status code 201.
2025-11-18 21:21:46.638 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-18 21:21:46.638 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40946 - 201 0 null 142.5469ms
2025-11-18 21:52:39.065 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null
2025-11-18 21:52:39.066 +00:00 [INF] CORS policy execution successful.
2025-11-18 21:52:39.066 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.3342ms
2025-11-18 21:52:39.125 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 61
2025-11-18 21:52:39.126 +00:00 [INF] CORS policy execution successful.
2025-11-18 21:52:39.126 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin'
2025-11-18 21:52:39.357 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName]
FROM [AspNetUsers] AS [a]
WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0
2025-11-18 21:52:39.469 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (Size = 450)], CommandType='"Text"', CommandTimeout='30']
SELECT [a0].[Name]
FROM [AspNetUserRoles] AS [a]
INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id]
WHERE [a].[UserId] = @__userId_0
2025-11-18 21:52:39.470 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 21:52:39.470 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json.
2025-11-18 21:52:39.470 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin'
2025-11-18 21:52:39.470 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 344.8243ms
2025-11-18 21:52:46.341 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 21:52:46.341 +00:00 [INF] CORS policy execution successful.
2025-11-18 21:52:46.341 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.6402ms
2025-11-18 21:52:46.396 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2025-11-18 21:52:46.397 +00:00 [INF] CORS policy execution successful.
2025-11-18 21:52:46.397 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.5426ms
2025-11-18 21:52:46.403 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null
2025-11-18 21:52:46.403 +00:00 [INF] CORS policy execution successful.
2025-11-18 21:52:46.403 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.5204ms
2025-11-18 21:52:46.403 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 21:52:46.403 +00:00 [INF] CORS policy execution successful.
2025-11-18 21:52:46.404 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 21:52:46.404 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null
2025-11-18 21:52:46.404 +00:00 [INF] CORS policy execution successful.
2025-11-18 21:52:46.404 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.3709ms
2025-11-18 21:52:46.416 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 21:52:46.416 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 21:52:46.416 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 21:52:46.416 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 21:52:46.416 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 13.1914ms
2025-11-18 21:52:46.457 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2025-11-18 21:52:46.457 +00:00 [INF] CORS policy execution successful.
2025-11-18 21:52:46.457 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2025-11-18 21:52:46.459 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [ProductTaxes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 21:52:46.459 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 21:52:46.459 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 21:52:46.459 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2025-11-18 21:52:46.459 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 2.6289ms
2025-11-18 21:52:46.483 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null
2025-11-18 21:52:46.483 +00:00 [INF] CORS policy execution successful.
2025-11-18 21:52:46.483 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null
2025-11-18 21:52:46.484 +00:00 [INF] CORS policy execution successful.
2025-11-18 21:52:46.484 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities'
2025-11-18 21:52:46.484 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/'
2025-11-18 21:52:46.486 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [n].[Id], [n].[Descripcion], [n].[Estatus], [n].[Gentilicio], [n].[Siglas]
FROM [Nationalities] AS [n]
2025-11-18 21:52:46.487 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 21:52:46.487 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 21:52:46.487 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities'
2025-11-18 21:52:46.488 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 4.1919ms
2025-11-18 21:52:46.489 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate]
FROM [Settings] AS [s]
2025-11-18 21:52:46.489 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 21:52:46.489 +00:00 [INF] Writing value of type 'SettingDto' as Json.
2025-11-18 21:52:46.489 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/'
2025-11-18 21:52:46.490 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 6.8622ms
2025-11-18 21:52:52.281 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/vitamina c - null null
2025-11-18 21:52:52.281 +00:00 [INF] CORS policy execution successful.
2025-11-18 21:52:52.281 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/vitamina c - 204 null null 0.3342ms
2025-11-18 21:52:52.339 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/vitamina c - null null
2025-11-18 21:52:52.339 +00:00 [INF] CORS policy execution successful.
2025-11-18 21:52:52.339 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 21:52:52.342 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-18 21:52:52.348 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 21:52:52.349 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 21:52:52.467 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 21:52:52.467 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/vitamina c - 200 null application/json; charset=utf-8 128.7649ms
2025-11-18 21:54:47.068 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 21:54:47.069 +00:00 [INF] CORS policy execution successful.
2025-11-18 21:54:47.069 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 1.1838ms
2025-11-18 21:54:47.127 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 21:54:47.128 +00:00 [INF] CORS policy execution successful.
2025-11-18 21:54:47.128 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 21:54:47.130 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 21:54:47.131 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 21:54:47.131 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 21:54:47.131 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 21:54:47.131 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 4.1668ms
2025-11-18 22:26:46.222 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ja - null null
2025-11-18 22:26:46.222 +00:00 [INF] CORS policy execution successful.
2025-11-18 22:26:46.222 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ja - 204 null null 0.2979ms
2025-11-18 22:26:46.282 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ja - null null
2025-11-18 22:26:46.282 +00:00 [INF] CORS policy execution successful.
2025-11-18 22:26:46.282 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 22:26:46.576 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-18 22:26:46.589 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 22:26:46.590 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 22:26:46.817 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 22:26:46.818 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ja - 200 null application/json; charset=utf-8 536.2899ms
2025-11-18 22:26:49.941 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/r - null null
2025-11-18 22:26:49.941 +00:00 [INF] CORS policy execution successful.
2025-11-18 22:26:49.941 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/r - 204 null null 0.2376ms
2025-11-18 22:26:50.001 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/r - null null
2025-11-18 22:26:50.001 +00:00 [INF] CORS policy execution successful.
2025-11-18 22:26:50.002 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 22:26:50.004 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-18 22:26:50.114 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 22:26:50.115 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 22:26:50.700 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 22:26:50.701 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/r - 200 null application/json; charset=utf-8 699.4454ms
2025-11-18 22:26:52.766 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ja - null null
2025-11-18 22:26:52.766 +00:00 [INF] CORS policy execution successful.
2025-11-18 22:26:52.766 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ja - 204 null null 0.2736ms
2025-11-18 22:26:52.824 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ja - null null
2025-11-18 22:26:52.824 +00:00 [INF] CORS policy execution successful.
2025-11-18 22:26:52.824 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 22:26:52.827 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-18 22:26:52.847 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 22:26:52.847 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 22:26:52.849 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 22:26:52.849 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ja - 200 null application/json; charset=utf-8 25.4091ms
2025-11-18 22:27:08.337 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jarta - null null
2025-11-18 22:27:08.338 +00:00 [INF] CORS policy execution successful.
2025-11-18 22:27:08.338 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jarta - 204 null null 0.3258ms
2025-11-18 22:27:08.397 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/jarta - null null
2025-11-18 22:27:08.397 +00:00 [INF] CORS policy execution successful.
2025-11-18 22:27:08.397 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 22:27:08.402 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-18 22:27:08.402 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 22:27:08.402 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 22:27:08.402 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 22:27:08.402 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/jarta - 200 null application/json; charset=utf-8 5.5288ms
2025-11-18 22:27:14.956 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jarabe - null null
2025-11-18 22:27:14.956 +00:00 [INF] CORS policy execution successful.
2025-11-18 22:27:14.956 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jarabe - 204 null null 0.3373ms
2025-11-18 22:27:15.024 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/jarabe - null null
2025-11-18 22:27:15.024 +00:00 [INF] CORS policy execution successful.
2025-11-18 22:27:15.024 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 22:27:15.030 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-18 22:27:15.032 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 22:27:15.032 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 22:27:15.038 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 22:27:15.038 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/jarabe - 200 null application/json; charset=utf-8 14.1765ms
2025-11-18 22:28:55.605 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-11-18 22:28:55.605 +00:00 [INF] CORS policy execution successful.
2025-11-18 22:28:55.605 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3873ms
2025-11-18 22:28:55.664 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 179
2025-11-18 22:28:55.664 +00:00 [INF] CORS policy execution successful.
2025-11-18 22:28:55.664 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-11-18 22:28:55.669 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2025-11-18 22:28:55.673 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2025-11-18 22:28:55.673 +00:00 [INF] Setting HTTP status code 201.
2025-11-18 22:28:55.673 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-11-18 22:28:55.673 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-11-18 22:28:55.673 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 9.5813ms
2025-11-18 22:28:55.744 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40947 - null null
2025-11-18 22:28:55.744 +00:00 [INF] CORS policy execution successful.
2025-11-18 22:28:55.744 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40947 - 204 null null 0.2967ms
2025-11-18 22:28:55.801 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 22:28:55.802 +00:00 [INF] CORS policy execution successful.
2025-11-18 22:28:55.802 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2533ms
2025-11-18 22:28:55.816 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40947 - application/json 104
2025-11-18 22:28:55.817 +00:00 [INF] CORS policy execution successful.
2025-11-18 22:28:55.817 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-18 22:28:55.819 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 22:28:55.863 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 22:28:55.864 +00:00 [INF] CORS policy execution successful.
2025-11-18 22:28:55.864 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 22:28:55.883 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 22:28:55.883 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 22:28:55.883 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 22:28:55.883 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 22:28:55.883 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 20.0017ms
2025-11-18 22:28:55.984 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2025-11-18 22:28:55.987 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35);
INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
OUTPUT INSERTED.[Id]
VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47);
2025-11-18 22:28:55.993 +00:00 [INF] Setting HTTP status code 201.
2025-11-18 22:28:55.994 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-11-18 22:28:55.994 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40947 - 201 0 null 177.9265ms
2025-11-18 23:06:17.208 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/altar - null null
2025-11-18 23:06:17.208 +00:00 [INF] CORS policy execution successful.
2025-11-18 23:06:17.208 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/altar - 204 null null 0.2293ms
2025-11-18 23:06:17.265 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/altar - null null
2025-11-18 23:06:17.266 +00:00 [INF] CORS policy execution successful.
2025-11-18 23:06:17.266 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 23:06:17.570 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-18 23:06:17.574 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 23:06:17.574 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 23:06:17.575 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 23:06:17.575 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/altar - 200 null application/json; charset=utf-8 309.1675ms
2025-11-18 23:06:22.257 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/altarrey - null null
2025-11-18 23:06:22.257 +00:00 [INF] CORS policy execution successful.
2025-11-18 23:06:22.257 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/altarrey - 204 null null 0.2565ms
2025-11-18 23:06:22.317 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/altarrey - null null
2025-11-18 23:06:22.317 +00:00 [INF] CORS policy execution successful.
2025-11-18 23:06:22.318 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 23:06:22.322 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-11-18 23:06:22.323 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 23:06:22.323 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 23:06:22.323 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-11-18 23:06:22.324 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/altarrey - 200 null application/json; charset=utf-8 7.0462ms
2025-11-18 23:09:28.427 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 23:09:28.427 +00:00 [INF] CORS policy execution successful.
2025-11-18 23:09:28.427 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.8269ms
2025-11-18 23:09:28.488 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-11-18 23:09:28.488 +00:00 [INF] CORS policy execution successful.
2025-11-18 23:09:28.488 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 23:09:28.490 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-11-18 23:09:28.490 +00:00 [INF] Setting HTTP status code 200.
2025-11-18 23:09:28.490 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-11-18 23:09:28.491 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-11-18 23:09:28.491 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 3.1483ms
2025-11-18 23:32:08.848 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2025-11-18 23:32:08.848 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.2718ms
2025-11-18 23:32:08.848 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404
2025-11-18 23:40:39.147 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/.well-known/security.txt - null null
2025-11-18 23:40:39.148 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/.well-known/security.txt - 404 0 null 0.3178ms
2025-11-18 23:40:39.148 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/.well-known/security.txt, Response status code: 404