2025-12-11 04:16:12.265 +00:00 [INF] Request starting HTTP/1.0 GET http:/// - null null
2025-12-11 04:16:12.267 +00:00 [INF] Request finished HTTP/1.0 GET http:/// - 404 0 null 2.0043ms
2025-12-11 04:16:12.268 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http:///, Response status code: 404
2025-12-11 07:57:13.287 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2025-12-11 07:57:13.289 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 2.8325ms
2025-12-11 07:57:13.289 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404
2025-12-11 07:57:40.109 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/security.txt - null null
2025-12-11 07:57:40.109 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/security.txt - 404 0 null 0.3603ms
2025-12-11 07:57:40.109 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/security.txt, Response status code: 404
2025-12-11 12:23:24.638 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null
2025-12-11 12:23:24.638 +00:00 [INF] CORS policy execution successful.
2025-12-11 12:23:24.638 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.3845ms
2025-12-11 12:23:24.698 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 65
2025-12-11 12:23:24.698 +00:00 [INF] CORS policy execution successful.
2025-12-11 12:23:24.698 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin'
2025-12-11 12:23:25.009 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName]
FROM [AspNetUsers] AS [a]
WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0
2025-12-11 12:23:25.123 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (Size = 450)], CommandType='"Text"', CommandTimeout='30']
SELECT [a0].[Name]
FROM [AspNetUserRoles] AS [a]
INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id]
WHERE [a].[UserId] = @__userId_0
2025-12-11 12:23:25.124 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 12:23:25.125 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json.
2025-12-11 12:23:25.125 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin'
2025-12-11 12:23:25.125 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 427.8468ms
2025-12-11 12:23:27.816 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 12:23:27.816 +00:00 [INF] CORS policy execution successful.
2025-12-11 12:23:27.816 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2594ms
2025-12-11 12:23:27.872 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null
2025-12-11 12:23:27.872 +00:00 [INF] CORS policy execution successful.
2025-12-11 12:23:27.873 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.3067ms
2025-12-11 12:23:27.872 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null
2025-12-11 12:23:27.873 +00:00 [INF] CORS policy execution successful.
2025-12-11 12:23:27.873 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.9761ms
2025-12-11 12:23:27.877 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null
2025-12-11 12:23:27.878 +00:00 [INF] CORS policy execution successful.
2025-12-11 12:23:27.878 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.2818ms
2025-12-11 12:23:27.883 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 12:23:27.883 +00:00 [INF] CORS policy execution successful.
2025-12-11 12:23:27.884 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 12:23:27.905 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-12-11 12:23:27.905 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 12:23:27.905 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 12:23:27.905 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 12:23:27.905 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 22.5089ms
2025-12-11 12:23:27.930 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null
2025-12-11 12:23:27.930 +00:00 [INF] CORS policy execution successful.
2025-12-11 12:23:27.930 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/'
2025-12-11 12:23:27.931 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null
2025-12-11 12:23:27.931 +00:00 [INF] CORS policy execution successful.
2025-12-11 12:23:27.931 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/'
2025-12-11 12:23:27.933 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate]
FROM [Settings] AS [s]
2025-12-11 12:23:27.934 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 12:23:27.934 +00:00 [INF] Writing value of type 'SettingDto' as Json.
2025-12-11 12:23:27.934 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/'
2025-12-11 12:23:27.934 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 4.6026ms
2025-12-11 12:23:27.937 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null
2025-12-11 12:23:27.937 +00:00 [INF] CORS policy execution successful.
2025-12-11 12:23:27.938 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities'
2025-12-11 12:23:27.941 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [n].[Id], [n].[Descripcion], [n].[Estatus], [n].[Gentilicio], [n].[Siglas]
FROM [Nationalities] AS [n]
2025-12-11 12:23:27.941 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 12:23:27.942 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 12:23:27.942 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities'
2025-12-11 12:23:27.942 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 5.1899ms
2025-12-11 12:23:27.953 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [ProductTaxes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-12-11 12:23:27.954 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 12:23:27.954 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 12:23:27.954 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/'
2025-12-11 12:23:27.954 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 23.3266ms
2025-12-11 12:23:32.949 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/valeriana - null null
2025-12-11 12:23:32.950 +00:00 [INF] CORS policy execution successful.
2025-12-11 12:23:32.950 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/valeriana - 204 null null 1.249ms
2025-12-11 12:23:33.016 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/valeriana - null null
2025-12-11 12:23:33.016 +00:00 [INF] CORS policy execution successful.
2025-12-11 12:23:33.017 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 12:23:33.026 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-12-11 12:23:33.028 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 12:23:33.028 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 12:23:33.029 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 12:23:33.029 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/valeriana - 200 null application/json; charset=utf-8 13.1245ms
2025-12-11 14:47:11.701 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 14:47:11.702 +00:00 [INF] CORS policy execution successful.
2025-12-11 14:47:11.702 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3302ms
2025-12-11 14:47:11.771 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 14:47:11.771 +00:00 [INF] CORS policy execution successful.
2025-12-11 14:47:11.771 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 14:47:12.104 +00:00 [INF] Executed DbCommand (7ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-12-11 14:47:12.105 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 14:47:12.106 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 14:47:12.106 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 14:47:12.106 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 335.6132ms
2025-12-11 14:47:21.388 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/echinacea - null null
2025-12-11 14:47:21.389 +00:00 [INF] CORS policy execution successful.
2025-12-11 14:47:21.389 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/echinacea - 204 null null 0.2792ms
2025-12-11 14:47:21.448 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/echinacea - null null
2025-12-11 14:47:21.448 +00:00 [INF] CORS policy execution successful.
2025-12-11 14:47:21.449 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 14:47:21.451 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-12-11 14:47:21.457 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 14:47:21.457 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 14:47:21.571 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 14:47:21.572 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/echinacea - 200 null application/json; charset=utf-8 124.0043ms
2025-12-11 14:47:32.296 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/arbaje - null null
2025-12-11 14:47:32.297 +00:00 [INF] CORS policy execution successful.
2025-12-11 14:47:32.297 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/arbaje - 204 null null 0.3344ms
2025-12-11 14:47:32.356 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/arbaje - null null
2025-12-11 14:47:32.356 +00:00 [INF] CORS policy execution successful.
2025-12-11 14:47:32.356 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 14:47:32.361 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-12-11 14:47:32.368 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 14:47:32.368 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 14:47:32.369 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 14:47:32.370 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/arbaje - 200 null application/json; charset=utf-8 13.8247ms
2025-12-11 14:47:57.032 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-12-11 14:47:57.032 +00:00 [INF] CORS policy execution successful.
2025-12-11 14:47:57.032 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3777ms
2025-12-11 14:47:57.101 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 224
2025-12-11 14:47:57.101 +00:00 [INF] CORS policy execution successful.
2025-12-11 14:47:57.101 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-12-11 14:47:57.108 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2025-12-11 14:47:57.117 +00:00 [INF] Executed DbCommand (7ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2025-12-11 14:47:57.118 +00:00 [INF] Setting HTTP status code 201.
2025-12-11 14:47:57.119 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-12-11 14:47:57.119 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-12-11 14:47:57.119 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 18.4979ms
2025-12-11 14:47:57.183 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41125 - null null
2025-12-11 14:47:57.183 +00:00 [INF] CORS policy execution successful.
2025-12-11 14:47:57.184 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41125 - 204 null null 0.9797ms
2025-12-11 14:47:57.244 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 14:47:57.244 +00:00 [INF] CORS policy execution successful.
2025-12-11 14:47:57.244 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.9457ms
2025-12-11 14:47:57.260 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41125 - application/json 215
2025-12-11 14:47:57.260 +00:00 [INF] CORS policy execution successful.
2025-12-11 14:47:57.261 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-12-11 14:47:57.264 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-12-11 14:47:57.303 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 14:47:57.304 +00:00 [INF] CORS policy execution successful.
2025-12-11 14:47:57.304 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 14:47:57.326 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-12-11 14:47:57.327 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 14:47:57.327 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 14:47:57.327 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 14:47:57.328 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 24.3214ms
2025-12-11 14:47:57.398 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2025-12-11 14:47:57.405 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p40='?' (DbType = Int32), @p23='?' (Size = 4000), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Int32), @p26='?' (DbType = Guid), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Boolean), @p29='?' (DbType = DateTime2), @p30='?' (DbType = Int32), @p31='?' (Size = 150), @p32='?' (Size = 500), @p33='?' (Size = -1) (DbType = Binary), @p34='?' (DbType = Int32), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p36='?' (Size = 4000), @p37='?' (DbType = Int32), @p38='?' (DbType = Guid), @p39='?' (DbType = DateTime2), @p41='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p42='?' (DbType = Guid), @p43='?' (DbType = DateTime2), @p44='?' (DbType = Boolean), @p45='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p46='?' (DbType = Int32), @p47='?' (DbType = Int32), @p48='?' (DbType = Int64), @p49='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p50='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p51='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p52='?' (DbType = Guid), @p53='?' (DbType = DateTime2), @p54='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p55='?' (DbType = Guid), @p56='?' (DbType = DateTime2), @p57='?' (DbType = Boolean), @p58='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p59='?' (DbType = Int32), @p60='?' (DbType = Int32), @p61='?' (DbType = Int64), @p62='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p63='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p64='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p65='?' (DbType = Guid), @p66='?' (DbType = DateTime2), @p67='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p68='?' (DbType = Guid), @p69='?' (DbType = DateTime2), @p70='?' (DbType = Int32), @p71='?' (Size = 34), @p72='?' (DbType = Guid), @p73='?' (DbType = Int32), @p74='?' (DbType = Int32), @p75='?' (DbType = Int32), @p76='?' (Size = 4000), @p77='?' (Size = 4000), @p78='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p79='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p80='?' (DbType = Guid), @p81='?' (DbType = DateTime2), @p82='?' (DbType = Int32), @p83='?' (Size = 34), @p84='?' (DbType = Guid), @p85='?' (DbType = Int32), @p86='?' (DbType = Int32), @p87='?' (DbType = Int32), @p88='?' (Size = 4000), @p89='?' (Size = 4000), @p90='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
UPDATE [Products] SET [BarCode] = @p23, [BuyPrice] = @p24, [CategoryId] = @p25, [CreatedById] = @p26, [CreatedDate] = @p27, [DeleteFlag] = @p28, [ExpirationDate] = @p29, [MinimunStock] = @p30, [Name] = @p31, [Note] = @p32, [ProductImage] = @p33, [ProductTaxId] = @p34, [SalePrice] = @p35, [Status] = @p36, [Stock] = @p37, [UpdatedById] = @p38, [UpdatedDate] = @p39
OUTPUT 1
WHERE [Id] = @p40;
MERGE [SalesDetail] USING (
VALUES (@p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52, @p53, 0),
(@p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62, @p63, @p64, @p65, @p66, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[DeleteFlag], i.[DiscountAmount], i.[ProductId], i.[Quantity], i.[SalesId], i.[Tax], i.[Total], i.[UnitPrice], i.[UpdatedById], i.[UpdatedDate])
OUTPUT INSERTED.[Id], i._Position;
MERGE [InventoryMovements] USING (
VALUES (@p67, @p68, @p69, @p70, @p71, @p72, @p73, @p74, @p75, @p76, @p77, @p78, 0),
(@p79, @p80, @p81, @p82, @p83, @p84, @p85, @p86, @p87, @p88, @p89, @p90, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[Difference], i.[Discriminator], i.[InventoryMovementHeaderId], i.[NewStock], i.[OriginaStock], i.[ProductId], i.[ProductName], i.[Reazon], i.[SalePrice])
OUTPUT INSERTED.[Id], i._Position;
2025-12-11 14:47:57.411 +00:00 [INF] Setting HTTP status code 201.
2025-12-11 14:47:57.412 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-12-11 14:47:57.412 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41125 - 201 0 null 152.0138ms
2025-12-11 15:25:44.484 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/echinacea - null null
2025-12-11 15:25:44.485 +00:00 [INF] CORS policy execution successful.
2025-12-11 15:25:44.485 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/echinacea - 204 null null 0.5662ms
2025-12-11 15:25:44.544 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/echinacea - null null
2025-12-11 15:25:44.545 +00:00 [INF] CORS policy execution successful.
2025-12-11 15:25:44.545 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 15:25:44.814 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-12-11 15:25:44.826 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 15:25:44.826 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 15:25:44.939 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 15:25:44.939 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/echinacea - 200 null application/json; charset=utf-8 394.9274ms
2025-12-11 15:25:52.616 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ptasi - null null
2025-12-11 15:25:52.616 +00:00 [INF] CORS policy execution successful.
2025-12-11 15:25:52.616 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ptasi - 204 null null 0.3331ms
2025-12-11 15:25:52.676 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ptasi - null null
2025-12-11 15:25:52.676 +00:00 [INF] CORS policy execution successful.
2025-12-11 15:25:52.677 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 15:25:52.682 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-12-11 15:25:52.682 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 15:25:52.682 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 15:25:52.682 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 15:25:52.682 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ptasi - 200 null application/json; charset=utf-8 6.1107ms
2025-12-11 15:25:57.521 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/potassium - null null
2025-12-11 15:25:57.522 +00:00 [INF] CORS policy execution successful.
2025-12-11 15:25:57.522 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/potassium - 204 null null 0.4458ms
2025-12-11 15:25:57.582 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/potassium - null null
2025-12-11 15:25:57.582 +00:00 [INF] CORS policy execution successful.
2025-12-11 15:25:57.582 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 15:25:57.588 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-12-11 15:25:57.588 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 15:25:57.588 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 15:25:57.588 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 15:25:57.588 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/potassium - 200 null application/json; charset=utf-8 6.5692ms
2025-12-11 15:26:01.618 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/po - null null
2025-12-11 15:26:01.618 +00:00 [INF] CORS policy execution successful.
2025-12-11 15:26:01.618 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/po - 204 null null 0.3663ms
2025-12-11 15:26:01.683 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/po - null null
2025-12-11 15:26:01.683 +00:00 [INF] CORS policy execution successful.
2025-12-11 15:26:01.683 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 15:26:01.687 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-12-11 15:26:01.736 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 15:26:01.737 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 15:26:01.965 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 15:26:01.966 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/po - 200 null application/json; charset=utf-8 283.3119ms
2025-12-11 15:26:06.000 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pota - null null
2025-12-11 15:26:06.000 +00:00 [INF] CORS policy execution successful.
2025-12-11 15:26:06.000 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pota - 204 null null 0.4566ms
2025-12-11 15:26:06.060 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/pota - null null
2025-12-11 15:26:06.060 +00:00 [INF] CORS policy execution successful.
2025-12-11 15:26:06.060 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 15:26:06.064 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-12-11 15:26:06.067 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 15:26:06.067 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 15:26:06.068 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 15:26:06.068 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/pota - 200 null application/json; charset=utf-8 8.4823ms
2025-12-11 15:26:49.720 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/customers/ByName/m - null null
2025-12-11 15:26:49.720 +00:00 [INF] CORS policy execution successful.
2025-12-11 15:26:49.721 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/customers/ByName/m - 204 null null 0.2914ms
2025-12-11 15:26:49.780 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/customers/ByName/m - null null
2025-12-11 15:26:49.780 +00:00 [INF] CORS policy execution successful.
2025-12-11 15:26:49.780 +00:00 [INF] Executing endpoint 'HTTP: GET Customers/ByName/{name}'
2025-12-11 15:26:49.783 +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-12-11 15:26:49.784 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 15:26:49.784 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 15:26:49.784 +00:00 [INF] Executed endpoint 'HTTP: GET Customers/ByName/{name}'
2025-12-11 15:26:49.784 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/customers/ByName/m - 200 null application/json; charset=utf-8 4.2081ms
2025-12-11 15:27:00.109 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-12-11 15:27:00.109 +00:00 [INF] CORS policy execution successful.
2025-12-11 15:27:00.110 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 1.1366ms
2025-12-11 15:27:00.168 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 191
2025-12-11 15:27:00.168 +00:00 [INF] CORS policy execution successful.
2025-12-11 15:27:00.168 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-12-11 15:27:00.174 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2025-12-11 15:27:00.180 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2025-12-11 15:27:00.181 +00:00 [INF] Setting HTTP status code 201.
2025-12-11 15:27:00.181 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-12-11 15:27:00.181 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-12-11 15:27:00.181 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 13.9668ms
2025-12-11 15:27:00.248 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41126 - null null
2025-12-11 15:27:00.248 +00:00 [INF] CORS policy execution successful.
2025-12-11 15:27:00.248 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41126 - 204 null null 0.6853ms
2025-12-11 15:27:00.305 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/purchasedproducts - null null
2025-12-11 15:27:00.305 +00:00 [INF] CORS policy execution successful.
2025-12-11 15:27:00.306 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/purchasedproducts - 204 null null 0.8537ms
2025-12-11 15:27:00.308 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 15:27:00.308 +00:00 [INF] CORS policy execution successful.
2025-12-11 15:27:00.308 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3484ms
2025-12-11 15:27:00.309 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/accountsReceivable - null null
2025-12-11 15:27:00.310 +00:00 [INF] CORS policy execution successful.
2025-12-11 15:27:00.310 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/accountsReceivable - 204 null null 0.5545ms
2025-12-11 15:27:00.317 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41126 - application/json 218
2025-12-11 15:27:00.318 +00:00 [INF] CORS policy execution successful.
2025-12-11 15:27:00.318 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-12-11 15:27:00.320 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-12-11 15:27:00.362 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/purchasedproducts - application/json 40
2025-12-11 15:27:00.362 +00:00 [INF] CORS policy execution successful.
2025-12-11 15:27:00.363 +00:00 [INF] Executing endpoint 'HTTP: POST PurchasedProducts/'
2025-12-11 15:27:00.367 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 15:27:00.368 +00:00 [INF] CORS policy execution successful.
2025-12-11 15:27:00.368 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 15:27:00.369 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/accountsReceivable - application/json 176
2025-12-11 15:27:00.369 +00:00 [INF] CORS policy execution successful.
2025-12-11 15:27:00.370 +00:00 [INF] Executing endpoint 'HTTP: POST AccountsReceivable/'
2025-12-11 15:27:00.410 +00:00 [INF] Executed DbCommand (4ms) [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-12-11 15:27:00.411 +00:00 [INF] Setting HTTP status code 201.
2025-12-11 15:27:00.411 +00:00 [INF] Writing value of type 'PurchasedProductsDto' as Json.
2025-12-11 15:27:00.411 +00:00 [INF] Executed endpoint 'HTTP: POST PurchasedProducts/'
2025-12-11 15:27:00.411 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/purchasedproducts - 201 null application/json; charset=utf-8 49.3545ms
2025-12-11 15:27:00.435 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p2='?' (DbType = Guid), @p3='?' (DbType = DateTime2), @p4='?' (DbType = Int32), @p5='?' (DbType = Boolean), @p6='?' (DbType = Date), @p7='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p8='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p9='?' (DbType = Int64), @p10='?' (DbType = Int64), @p11='?' (DbType = Int32), @p12='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p13='?' (DbType = Guid), @p14='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [CxC] ([Id], [CapitalAmount], [CreatedById], [CreatedDate], [CustomerId], [DeleteFlag], [ExpirationDate], [InterestAmount], [PenaltyAmount], [ReceiptNumber], [SalesId], [Sequence], [TotalAmount], [UpdatedById], [UpdatedDate])
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14);
2025-12-11 15:27:00.436 +00:00 [INF] Setting HTTP status code 201.
2025-12-11 15:27:00.436 +00:00 [INF] Writing value of type 'GetOrUpdateAccountsReceivableDto' as Json.
2025-12-11 15:27:00.436 +00:00 [INF] Executed endpoint 'HTTP: POST AccountsReceivable/'
2025-12-11 15:27:00.436 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/accountsReceivable - 201 null application/json; charset=utf-8 67.3556ms
2025-12-11 15:27:00.439 +00:00 [INF] Executed DbCommand (7ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-12-11 15:27:00.440 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 15:27:00.440 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 15:27:00.441 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 15:27:00.441 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 73.8044ms
2025-12-11 15:27:00.568 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2025-12-11 15:27:00.575 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p40='?' (DbType = Int32), @p23='?' (Size = 4000), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Int32), @p26='?' (DbType = Guid), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Boolean), @p29='?' (DbType = DateTime2), @p30='?' (DbType = Int32), @p31='?' (Size = 150), @p32='?' (Size = 500), @p33='?' (Size = -1) (DbType = Binary), @p34='?' (DbType = Int32), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p36='?' (Size = 4000), @p37='?' (DbType = Int32), @p38='?' (DbType = Guid), @p39='?' (DbType = DateTime2), @p41='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p42='?' (DbType = Guid), @p43='?' (DbType = DateTime2), @p44='?' (DbType = Boolean), @p45='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p46='?' (DbType = Int32), @p47='?' (DbType = Int32), @p48='?' (DbType = Int64), @p49='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p50='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p51='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p52='?' (DbType = Guid), @p53='?' (DbType = DateTime2), @p54='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p55='?' (DbType = Guid), @p56='?' (DbType = DateTime2), @p57='?' (DbType = Boolean), @p58='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p59='?' (DbType = Int32), @p60='?' (DbType = Int32), @p61='?' (DbType = Int64), @p62='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p63='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p64='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p65='?' (DbType = Guid), @p66='?' (DbType = DateTime2), @p67='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p68='?' (DbType = Guid), @p69='?' (DbType = DateTime2), @p70='?' (DbType = Int32), @p71='?' (Size = 34), @p72='?' (DbType = Guid), @p73='?' (DbType = Int32), @p74='?' (DbType = Int32), @p75='?' (DbType = Int32), @p76='?' (Size = 4000), @p77='?' (Size = 4000), @p78='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p79='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p80='?' (DbType = Guid), @p81='?' (DbType = DateTime2), @p82='?' (DbType = Int32), @p83='?' (Size = 34), @p84='?' (DbType = Guid), @p85='?' (DbType = Int32), @p86='?' (DbType = Int32), @p87='?' (DbType = Int32), @p88='?' (Size = 4000), @p89='?' (Size = 4000), @p90='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
UPDATE [Products] SET [BarCode] = @p23, [BuyPrice] = @p24, [CategoryId] = @p25, [CreatedById] = @p26, [CreatedDate] = @p27, [DeleteFlag] = @p28, [ExpirationDate] = @p29, [MinimunStock] = @p30, [Name] = @p31, [Note] = @p32, [ProductImage] = @p33, [ProductTaxId] = @p34, [SalePrice] = @p35, [Status] = @p36, [Stock] = @p37, [UpdatedById] = @p38, [UpdatedDate] = @p39
OUTPUT 1
WHERE [Id] = @p40;
MERGE [SalesDetail] USING (
VALUES (@p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52, @p53, 0),
(@p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62, @p63, @p64, @p65, @p66, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[DeleteFlag], i.[DiscountAmount], i.[ProductId], i.[Quantity], i.[SalesId], i.[Tax], i.[Total], i.[UnitPrice], i.[UpdatedById], i.[UpdatedDate])
OUTPUT INSERTED.[Id], i._Position;
MERGE [InventoryMovements] USING (
VALUES (@p67, @p68, @p69, @p70, @p71, @p72, @p73, @p74, @p75, @p76, @p77, @p78, 0),
(@p79, @p80, @p81, @p82, @p83, @p84, @p85, @p86, @p87, @p88, @p89, @p90, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[Difference], i.[Discriminator], i.[InventoryMovementHeaderId], i.[NewStock], i.[OriginaStock], i.[ProductId], i.[ProductName], i.[Reazon], i.[SalePrice])
OUTPUT INSERTED.[Id], i._Position;
2025-12-11 15:27:00.579 +00:00 [INF] Setting HTTP status code 201.
2025-12-11 15:27:00.580 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-12-11 15:27:00.580 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41126 - 201 0 null 262.7979ms
2025-12-11 15:28:46.558 +00:00 [INF] Request starting HTTP/1.0 GET http:/// - null null
2025-12-11 15:28:46.558 +00:00 [INF] Request finished HTTP/1.0 GET http:/// - 404 0 null 0.3794ms
2025-12-11 15:28:46.559 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http:///, Response status code: 404
2025-12-11 15:59:39.880 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/silver - null null
2025-12-11 15:59:39.880 +00:00 [INF] CORS policy execution successful.
2025-12-11 15:59:39.881 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/silver - 204 null null 0.3604ms
2025-12-11 15:59:39.940 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/silver - null null
2025-12-11 15:59:39.941 +00:00 [INF] CORS policy execution successful.
2025-12-11 15:59:39.941 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 15:59:40.212 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-12-11 15:59:40.215 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 15:59:40.216 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 15:59:40.216 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 15:59:40.217 +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 276.2624ms
2025-12-11 15:59:48.202 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jarabe - null null
2025-12-11 15:59:48.202 +00:00 [INF] CORS policy execution successful.
2025-12-11 15:59:48.202 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jarabe - 204 null null 0.3303ms
2025-12-11 15:59:48.259 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/jarabe - null null
2025-12-11 15:59:48.259 +00:00 [INF] CORS policy execution successful.
2025-12-11 15:59:48.259 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 15:59:48.265 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-12-11 15:59:48.267 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 15:59:48.267 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 15:59:48.268 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 15:59:48.268 +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 9.6365ms
2025-12-11 16:37:42.511 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 16:37:42.511 +00:00 [INF] CORS policy execution successful.
2025-12-11 16:37:42.511 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2903ms
2025-12-11 16:37:42.571 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 16:37:42.571 +00:00 [INF] CORS policy execution successful.
2025-12-11 16:37:42.572 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 16:37:42.816 +00:00 [INF] Executed DbCommand (8ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-12-11 16:37:42.817 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 16:37:42.817 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 16:37:42.817 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 16:37:42.817 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 245.8003ms
2025-12-11 16:37:46.560 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/L- - null null
2025-12-11 16:37:46.560 +00:00 [INF] CORS policy execution successful.
2025-12-11 16:37:46.560 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/L- - 204 null null 0.3732ms
2025-12-11 16:37:46.620 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/L- - null null
2025-12-11 16:37:46.620 +00:00 [INF] CORS policy execution successful.
2025-12-11 16:37:46.621 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 16:37:46.624 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-12-11 16:37:46.628 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 16:37:46.628 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 16:37:46.746 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 16:37:46.747 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/L- - 200 null application/json; charset=utf-8 126.4592ms
2025-12-11 16:38:15.015 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1536 - null null
2025-12-11 16:38:15.016 +00:00 [INF] CORS policy execution successful.
2025-12-11 16:38:15.016 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1536 - 204 null null 0.3976ms
2025-12-11 16:38:15.074 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/1536 - null null
2025-12-11 16:38:15.074 +00:00 [INF] CORS policy execution successful.
2025-12-11 16:38:15.074 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2025-12-11 16:38:15.082 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2025-12-11 16:38:15.083 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 16:38:15.083 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json.
2025-12-11 16:38:15.083 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2025-12-11 16:38:15.083 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/1536 - 200 null application/json; charset=utf-8 9.0043ms
2025-12-11 16:38:49.427 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-12-11 16:38:49.427 +00:00 [INF] CORS policy execution successful.
2025-12-11 16:38:49.427 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.4036ms
2025-12-11 16:38:49.489 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2025-12-11 16:38:49.490 +00:00 [INF] CORS policy execution successful.
2025-12-11 16:38:49.490 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-12-11 16:38:49.495 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2025-12-11 16:38:49.499 +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-12-11 16:38:49.499 +00:00 [INF] Setting HTTP status code 201.
2025-12-11 16:38:49.499 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-12-11 16:38:49.500 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-12-11 16:38:49.500 +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.2386ms
2025-12-11 16:38:49.563 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41127 - null null
2025-12-11 16:38:49.564 +00:00 [INF] CORS policy execution successful.
2025-12-11 16:38:49.565 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41127 - 204 null null 1.2978ms
2025-12-11 16:38:49.626 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 16:38:49.627 +00:00 [INF] CORS policy execution successful.
2025-12-11 16:38:49.627 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.8773ms
2025-12-11 16:38:49.627 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41127 - application/json 106
2025-12-11 16:38:49.627 +00:00 [INF] CORS policy execution successful.
2025-12-11 16:38:49.627 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-12-11 16:38:49.630 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-12-11 16:38:49.686 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 16:38:49.686 +00:00 [INF] CORS policy execution successful.
2025-12-11 16:38:49.686 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 16:38:49.699 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-12-11 16:38:49.699 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 16:38:49.699 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 16:38:49.699 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 16:38:49.699 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 13.4173ms
2025-12-11 16:38:49.836 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2025-12-11 16:38:49.839 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35);
INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
OUTPUT INSERTED.[Id]
VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47);
2025-12-11 16:38:49.843 +00:00 [INF] Setting HTTP status code 201.
2025-12-11 16:38:49.844 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-12-11 16:38:49.844 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41127 - 201 0 null 217.2987ms
2025-12-11 16:54:38.195 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ionic - null null
2025-12-11 16:54:38.195 +00:00 [INF] CORS policy execution successful.
2025-12-11 16:54:38.195 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ionic - 204 null null 0.3526ms
2025-12-11 16:54:38.255 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ionic - null null
2025-12-11 16:54:38.255 +00:00 [INF] CORS policy execution successful.
2025-12-11 16:54:38.256 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 16:54:38.505 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-12-11 16:54:38.507 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 16:54:38.508 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 16:54:38.508 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 16:54:38.508 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ionic - 200 null application/json; charset=utf-8 253.2124ms
2025-12-11 17:13:11.286 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/stevia - null null
2025-12-11 17:13:11.286 +00:00 [INF] CORS policy execution successful.
2025-12-11 17:13:11.286 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/stevia - 204 null null 0.4984ms
2025-12-11 17:13:11.346 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/stevia - null null
2025-12-11 17:13:11.346 +00:00 [INF] CORS policy execution successful.
2025-12-11 17:13:11.346 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 17:13:11.598 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-12-11 17:13:11.605 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 17:13:11.606 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 17:13:11.606 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 17:13:11.606 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/stevia - 200 null application/json; charset=utf-8 260.0075ms
2025-12-11 17:19:54.966 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-12-11 17:19:54.966 +00:00 [INF] CORS policy execution successful.
2025-12-11 17:19:54.966 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.2911ms
2025-12-11 17:19:55.026 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 191
2025-12-11 17:19:55.026 +00:00 [INF] CORS policy execution successful.
2025-12-11 17:19:55.027 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-12-11 17:19:55.288 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2025-12-11 17:19:55.291 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2025-12-11 17:19:55.292 +00:00 [INF] Setting HTTP status code 201.
2025-12-11 17:19:55.293 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-12-11 17:19:55.293 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-12-11 17:19:55.293 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 267.1556ms
2025-12-11 17:19:55.356 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41128 - null null
2025-12-11 17:19:55.356 +00:00 [INF] CORS policy execution successful.
2025-12-11 17:19:55.357 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41128 - 204 null null 0.4168ms
2025-12-11 17:19:55.416 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 17:19:55.416 +00:00 [INF] CORS policy execution successful.
2025-12-11 17:19:55.416 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3172ms
2025-12-11 17:19:55.425 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41128 - application/json 214
2025-12-11 17:19:55.426 +00:00 [INF] CORS policy execution successful.
2025-12-11 17:19:55.426 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-12-11 17:19:55.429 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-12-11 17:19:55.476 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 17:19:55.476 +00:00 [INF] CORS policy execution successful.
2025-12-11 17:19:55.477 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 17:19:55.500 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-12-11 17:19:55.500 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 17:19:55.500 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 17:19:55.501 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 17:19:55.501 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 24.7209ms
2025-12-11 17:19:55.572 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2025-12-11 17:19:55.577 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p40='?' (DbType = Int32), @p23='?' (Size = 4000), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Int32), @p26='?' (DbType = Guid), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Boolean), @p29='?' (DbType = DateTime2), @p30='?' (DbType = Int32), @p31='?' (Size = 150), @p32='?' (Size = 500), @p33='?' (Size = -1) (DbType = Binary), @p34='?' (DbType = Int32), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p36='?' (Size = 4000), @p37='?' (DbType = Int32), @p38='?' (DbType = Guid), @p39='?' (DbType = DateTime2), @p41='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p42='?' (DbType = Guid), @p43='?' (DbType = DateTime2), @p44='?' (DbType = Boolean), @p45='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p46='?' (DbType = Int32), @p47='?' (DbType = Int32), @p48='?' (DbType = Int64), @p49='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p50='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p51='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p52='?' (DbType = Guid), @p53='?' (DbType = DateTime2), @p54='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p55='?' (DbType = Guid), @p56='?' (DbType = DateTime2), @p57='?' (DbType = Boolean), @p58='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p59='?' (DbType = Int32), @p60='?' (DbType = Int32), @p61='?' (DbType = Int64), @p62='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p63='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p64='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p65='?' (DbType = Guid), @p66='?' (DbType = DateTime2), @p67='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p68='?' (DbType = Guid), @p69='?' (DbType = DateTime2), @p70='?' (DbType = Int32), @p71='?' (Size = 34), @p72='?' (DbType = Guid), @p73='?' (DbType = Int32), @p74='?' (DbType = Int32), @p75='?' (DbType = Int32), @p76='?' (Size = 4000), @p77='?' (Size = 4000), @p78='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p79='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p80='?' (DbType = Guid), @p81='?' (DbType = DateTime2), @p82='?' (DbType = Int32), @p83='?' (Size = 34), @p84='?' (DbType = Guid), @p85='?' (DbType = Int32), @p86='?' (DbType = Int32), @p87='?' (DbType = Int32), @p88='?' (Size = 4000), @p89='?' (Size = 4000), @p90='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
UPDATE [Products] SET [BarCode] = @p23, [BuyPrice] = @p24, [CategoryId] = @p25, [CreatedById] = @p26, [CreatedDate] = @p27, [DeleteFlag] = @p28, [ExpirationDate] = @p29, [MinimunStock] = @p30, [Name] = @p31, [Note] = @p32, [ProductImage] = @p33, [ProductTaxId] = @p34, [SalePrice] = @p35, [Status] = @p36, [Stock] = @p37, [UpdatedById] = @p38, [UpdatedDate] = @p39
OUTPUT 1
WHERE [Id] = @p40;
MERGE [SalesDetail] USING (
VALUES (@p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52, @p53, 0),
(@p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62, @p63, @p64, @p65, @p66, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[DeleteFlag], i.[DiscountAmount], i.[ProductId], i.[Quantity], i.[SalesId], i.[Tax], i.[Total], i.[UnitPrice], i.[UpdatedById], i.[UpdatedDate])
OUTPUT INSERTED.[Id], i._Position;
MERGE [InventoryMovements] USING (
VALUES (@p67, @p68, @p69, @p70, @p71, @p72, @p73, @p74, @p75, @p76, @p77, @p78, 0),
(@p79, @p80, @p81, @p82, @p83, @p84, @p85, @p86, @p87, @p88, @p89, @p90, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice], _Position) ON 1=0
WHEN NOT MATCHED THEN
INSERT ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[Difference], i.[Discriminator], i.[InventoryMovementHeaderId], i.[NewStock], i.[OriginaStock], i.[ProductId], i.[ProductName], i.[Reazon], i.[SalePrice])
OUTPUT INSERTED.[Id], i._Position;
2025-12-11 17:19:55.583 +00:00 [INF] Setting HTTP status code 201.
2025-12-11 17:19:55.583 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-12-11 17:19:55.583 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41128 - 201 0 null 157.8233ms
2025-12-11 19:29:32.620 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ia - null null
2025-12-11 19:29:32.620 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:29:32.620 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ia - 204 null null 0.2936ms
2025-12-11 19:29:32.690 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ia - null null
2025-12-11 19:29:32.690 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:29:32.691 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 19:29:32.925 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-12-11 19:29:32.948 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 19:29:32.949 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 19:29:33.387 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 19:29:33.388 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ia - 200 null application/json; charset=utf-8 697.5767ms
2025-12-11 19:29:35.964 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jarabe; - null null
2025-12-11 19:29:35.965 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:29:35.965 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jarabe; - 204 null null 1.0464ms
2025-12-11 19:29:36.021 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/jarabe; - null null
2025-12-11 19:29:36.021 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:29:36.022 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 19:29:36.027 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-12-11 19:29:36.028 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 19:29:36.028 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 19:29:36.028 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 19:29:36.028 +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 7.4917ms
2025-12-11 19:29:36.999 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - null null
2025-12-11 19:29:37.000 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:29:37.001 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - 204 null null 1.5756ms
2025-12-11 19:29:37.059 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - null null
2025-12-11 19:29:37.060 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:29:37.060 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2025-12-11 19:29:37.060 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2025-12-11 19:29:37.061 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - 400 0 null 1.4837ms
2025-12-11 19:29:39.408 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jarabe - null null
2025-12-11 19:29:39.408 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:29:39.408 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jarabe - 204 null null 0.2881ms
2025-12-11 19:29:39.468 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/jarabe - null null
2025-12-11 19:29:39.473 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:29:39.474 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 19:29:39.482 +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-12-11 19:29:39.484 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 19:29:39.484 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 19:29:39.485 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 19:29:39.485 +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 16.4361ms
2025-12-11 19:29:45.867 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1527 - null null
2025-12-11 19:29:45.867 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:29:45.867 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1527 - 204 null null 0.3187ms
2025-12-11 19:29:45.927 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/1527 - null null
2025-12-11 19:29:45.927 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:29:45.927 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2025-12-11 19:29:45.930 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2025-12-11 19:29:45.932 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 19:29:45.932 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json.
2025-12-11 19:29:45.932 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2025-12-11 19:29:45.932 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/1527 - 200 null application/json; charset=utf-8 5.3524ms
2025-12-11 19:30:02.593 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 19:30:02.593 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:30:02.593 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.5282ms
2025-12-11 19:30:02.663 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 19:30:02.664 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:30:02.664 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 19:30:02.669 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-12-11 19:30:02.670 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 19:30:02.670 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 19:30:02.670 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 19:30:02.671 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 7.2259ms
2025-12-11 19:30:06.912 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jarabe - null null
2025-12-11 19:30:06.914 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:30:06.914 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jarabe - 204 null null 1.3419ms
2025-12-11 19:30:06.973 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/jarabe - null null
2025-12-11 19:30:06.973 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:30:06.974 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 19:30:06.980 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-12-11 19:30:06.983 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 19:30:06.983 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 19:30:06.984 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 19:30:06.984 +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 10.9427ms
2025-12-11 19:30:09.332 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1527 - null null
2025-12-11 19:30:09.337 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:30:09.337 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1527 - 204 null null 5.6267ms
2025-12-11 19:30:09.395 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/1527 - null null
2025-12-11 19:30:09.396 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:30:09.396 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2025-12-11 19:30:09.403 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2025-12-11 19:30:09.404 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 19:30:09.405 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json.
2025-12-11 19:30:09.405 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2025-12-11 19:30:09.405 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/1527 - 200 null application/json; charset=utf-8 9.6832ms
2025-12-11 19:30:19.790 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-12-11 19:30:19.790 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:30:19.791 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3754ms
2025-12-11 19:30:19.858 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2025-12-11 19:30:19.858 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:30:19.858 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-12-11 19:30:19.863 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2025-12-11 19:30:19.868 +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-12-11 19:30:19.869 +00:00 [INF] Setting HTTP status code 201.
2025-12-11 19:30:19.869 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-12-11 19:30:19.869 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-12-11 19:30:19.869 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 11.1982ms
2025-12-11 19:30:19.929 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41129 - null null
2025-12-11 19:30:19.929 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:30:19.929 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41129 - 204 null null 0.296ms
2025-12-11 19:30:19.989 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 19:30:19.989 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:30:19.989 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3106ms
2025-12-11 19:30:19.999 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41129 - application/json 106
2025-12-11 19:30:20.000 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:30:20.000 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-12-11 19:30:20.003 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-12-11 19:30:20.049 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 19:30:20.050 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:30:20.050 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 19:30:20.075 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-12-11 19:30:20.075 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 19:30:20.076 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 19:30:20.076 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 19:30:20.076 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 27.0186ms
2025-12-11 19:30:20.186 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2025-12-11 19:30:20.188 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35);
INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
OUTPUT INSERTED.[Id]
VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47);
2025-12-11 19:30:20.193 +00:00 [INF] Setting HTTP status code 201.
2025-12-11 19:30:20.193 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-12-11 19:30:20.193 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41129 - 201 0 null 193.955ms
2025-12-11 19:39:43.454 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - null null
2025-12-11 19:39:43.454 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:39:43.454 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - 204 null null 0.4377ms
2025-12-11 19:39:43.517 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma - null null
2025-12-11 19:39:43.517 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:39:43.518 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 19:39:43.758 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-12-11 19:39:43.769 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 19:39:43.769 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 19:39:43.964 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 19:39:43.964 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma - 200 null application/json; charset=utf-8 447.5054ms
2025-12-11 19:39:52.262 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ozono - null null
2025-12-11 19:39:52.262 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:39:52.262 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ozono - 204 null null 0.3288ms
2025-12-11 19:39:52.325 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ozono - null null
2025-12-11 19:39:52.325 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:39:52.325 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 19:39:52.329 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-12-11 19:39:52.331 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 19:39:52.331 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 19:39:52.332 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 19:39:52.332 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ozono - 200 null application/json; charset=utf-8 7.2089ms
2025-12-11 19:39:59.190 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Vitamina - null null
2025-12-11 19:39:59.190 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:39:59.190 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/Vitamina - 204 null null 0.2736ms
2025-12-11 19:39:59.253 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/Vitamina - null null
2025-12-11 19:39:59.254 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:39:59.254 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 19:39:59.256 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-12-11 19:39:59.272 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 19:39:59.272 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 19:39:59.496 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 19:39:59.497 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/Vitamina - 200 null application/json; charset=utf-8 243.8705ms
2025-12-11 19:40:11.761 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-12-11 19:40:11.761 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:40:11.762 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.5055ms
2025-12-11 19:40:11.827 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2025-12-11 19:40:11.827 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:40:11.828 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-12-11 19:40:11.832 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2025-12-11 19:40:11.836 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2025-12-11 19:40:11.836 +00:00 [INF] Setting HTTP status code 201.
2025-12-11 19:40:11.836 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-12-11 19:40:11.837 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-12-11 19:40:11.837 +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.9435ms
2025-12-11 19:40:11.915 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41130 - null null
2025-12-11 19:40:11.916 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:40:11.916 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41130 - 204 null null 0.8039ms
2025-12-11 19:40:11.973 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 19:40:11.974 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:40:11.974 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3609ms
2025-12-11 19:40:11.974 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41130 - application/json 211
2025-12-11 19:40:11.974 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:40:11.975 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-12-11 19:40:11.977 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-12-11 19:40:12.030 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 19:40:12.030 +00:00 [INF] CORS policy execution successful.
2025-12-11 19:40:12.031 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 19:40:12.053 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-12-11 19:40:12.053 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 19:40:12.053 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 19:40:12.053 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 19:40:12.053 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 23.2975ms
2025-12-11 19:40:12.185 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2025-12-11 19:40:12.189 +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-12-11 19:40:12.194 +00:00 [INF] Setting HTTP status code 201.
2025-12-11 19:40:12.195 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-12-11 19:40:12.195 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41130 - 201 0 null 221.7327ms
2025-12-11 19:56:41.807 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null
2025-12-11 19:56:41.807 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.3543ms
2025-12-11 19:56:41.807 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404
2025-12-11 20:28:56.467 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/protein - null null
2025-12-11 20:28:56.468 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:28:56.468 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/protein - 204 null null 0.3988ms
2025-12-11 20:28:56.525 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/protein - null null
2025-12-11 20:28:56.525 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:28:56.525 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 20:28:56.763 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-12-11 20:28:56.773 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 20:28:56.774 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 20:28:56.890 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 20:28:56.891 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/protein - 200 null application/json; charset=utf-8 366.3502ms
2025-12-11 20:29:27.858 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-12-11 20:29:27.858 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:29:27.858 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.2874ms
2025-12-11 20:29:27.917 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 188
2025-12-11 20:29:27.918 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:29:27.918 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-12-11 20:29:27.923 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2025-12-11 20:29:27.928 +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-12-11 20:29:27.928 +00:00 [INF] Setting HTTP status code 201.
2025-12-11 20:29:27.929 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-12-11 20:29:27.929 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-12-11 20:29:27.929 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 11.3595ms
2025-12-11 20:29:27.990 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41131 - null null
2025-12-11 20:29:27.991 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:29:27.991 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41131 - 204 null null 0.4197ms
2025-12-11 20:29:28.057 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 20:29:28.058 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:29:28.058 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3075ms
2025-12-11 20:29:28.063 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41131 - application/json 110
2025-12-11 20:29:28.064 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:29:28.064 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-12-11 20:29:28.066 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-12-11 20:29:28.117 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 20:29:28.118 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:29:28.118 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 20:29:28.146 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-12-11 20:29:28.146 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 20:29:28.147 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 20:29:28.147 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 20:29:28.147 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 29.8033ms
2025-12-11 20:29:28.230 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2025-12-11 20:29:28.232 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35);
INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
OUTPUT INSERTED.[Id]
VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47);
2025-12-11 20:29:28.236 +00:00 [INF] Setting HTTP status code 201.
2025-12-11 20:29:28.236 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-12-11 20:29:28.236 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41131 - 201 0 null 172.6164ms
2025-12-11 20:41:42.443 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jarabe - null null
2025-12-11 20:41:42.443 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:41:42.443 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jarabe - 204 null null 0.3253ms
2025-12-11 20:41:42.503 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/jarabe - null null
2025-12-11 20:41:42.503 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:41:42.504 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 20:41:42.736 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-12-11 20:41:42.739 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 20:41:42.740 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 20:41:42.740 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 20:41:42.740 +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 237.0727ms
2025-12-11 20:42:16.304 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1527 - null null
2025-12-11 20:42:16.304 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:42:16.304 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1527 - 204 null null 0.3379ms
2025-12-11 20:42:16.366 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/1527 - null null
2025-12-11 20:42:16.366 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:42:16.366 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2025-12-11 20:42:16.373 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2025-12-11 20:42:16.375 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 20:42:16.375 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json.
2025-12-11 20:42:16.375 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2025-12-11 20:42:16.375 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/1527 - 200 null application/json; charset=utf-8 9.8078ms
2025-12-11 20:42:17.149 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/1527 - null null
2025-12-11 20:42:17.149 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:42:17.149 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}'
2025-12-11 20:42:17.152 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0
2025-12-11 20:42:17.153 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 20:42:17.153 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json.
2025-12-11 20:42:17.153 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}'
2025-12-11 20:42:17.153 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/1527 - 200 null application/json; charset=utf-8 4.7284ms
2025-12-11 20:42:38.783 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-12-11 20:42:38.783 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:42:38.783 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.2919ms
2025-12-11 20:42:38.841 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2025-12-11 20:42:38.841 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:42:38.841 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-12-11 20:42:38.846 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2025-12-11 20:42:38.850 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2025-12-11 20:42:38.850 +00:00 [INF] Setting HTTP status code 201.
2025-12-11 20:42:38.850 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-12-11 20:42:38.850 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-12-11 20:42:38.850 +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.6382ms
2025-12-11 20:42:38.914 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41132 - null null
2025-12-11 20:42:38.914 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:42:38.914 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41132 - 204 null null 0.3222ms
2025-12-11 20:42:38.971 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 20:42:38.971 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:42:38.971 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2793ms
2025-12-11 20:42:38.981 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41132 - application/json 106
2025-12-11 20:42:38.982 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:42:38.982 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-12-11 20:42:38.984 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-12-11 20:42:39.032 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 20:42:39.032 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:42:39.033 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 20:42:39.051 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-12-11 20:42:39.052 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 20:42:39.052 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 20:42:39.052 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 20:42:39.052 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 19.8475ms
2025-12-11 20:42:39.090 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2025-12-11 20:42:39.093 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35);
INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
OUTPUT INSERTED.[Id]
VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47);
2025-12-11 20:42:39.096 +00:00 [INF] Setting HTTP status code 201.
2025-12-11 20:42:39.096 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-12-11 20:42:39.096 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41132 - 201 0 null 114.689ms
2025-12-11 20:54:15.446 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/consulta - null null
2025-12-11 20:54:15.446 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:54:15.446 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/consulta - 204 null null 0.3384ms
2025-12-11 20:54:15.506 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/consulta - null null
2025-12-11 20:54:15.506 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:54:15.506 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 20:54:15.750 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-12-11 20:54:15.761 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 20:54:15.761 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 20:54:15.994 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 20:54:15.994 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/consulta - 200 null application/json; charset=utf-8 488.2428ms
2025-12-11 20:54:40.066 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-12-11 20:54:40.067 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:54:40.067 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3198ms
2025-12-11 20:54:40.127 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2025-12-11 20:54:40.128 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:54:40.128 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-12-11 20:54:40.133 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2025-12-11 20:54:40.137 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2025-12-11 20:54:40.138 +00:00 [INF] Setting HTTP status code 201.
2025-12-11 20:54:40.138 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-12-11 20:54:40.139 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-12-11 20:54:40.139 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 11.3869ms
2025-12-11 20:54:40.204 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41133 - null null
2025-12-11 20:54:40.205 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:54:40.205 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41133 - 204 null null 0.9839ms
2025-12-11 20:54:40.265 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 20:54:40.265 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:54:40.265 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.382ms
2025-12-11 20:54:40.269 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41133 - application/json 106
2025-12-11 20:54:40.270 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:54:40.270 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-12-11 20:54:40.272 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-12-11 20:54:40.324 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 20:54:40.324 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:54:40.324 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 20:54:40.353 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-12-11 20:54:40.354 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 20:54:40.354 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 20:54:40.354 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 20:54:40.355 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 30.9795ms
2025-12-11 20:54:40.472 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2025-12-11 20:54:40.474 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35);
INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
OUTPUT INSERTED.[Id]
VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47);
2025-12-11 20:54:40.478 +00:00 [INF] Setting HTTP status code 201.
2025-12-11 20:54:40.479 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-12-11 20:54:40.479 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41133 - 201 0 null 209.936ms
2025-12-11 20:55:14.446 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/consulta - null null
2025-12-11 20:55:14.446 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:55:14.446 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/consulta - 204 null null 0.2597ms
2025-12-11 20:55:14.502 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/consulta - null null
2025-12-11 20:55:14.502 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:55:14.502 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 20:55:14.505 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\'))
2025-12-11 20:55:14.515 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 20:55:14.515 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 20:55:14.737 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}'
2025-12-11 20:55:14.738 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/consulta - 200 null application/json; charset=utf-8 236.388ms
2025-12-11 20:55:25.087 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null
2025-12-11 20:55:25.087 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:55:25.087 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3775ms
2025-12-11 20:55:25.149 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182
2025-12-11 20:55:25.149 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:55:25.150 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd'
2025-12-11 20:55:25.154 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9);
2025-12-11 20:55:25.158 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
2025-12-11 20:55:25.158 +00:00 [INF] Setting HTTP status code 201.
2025-12-11 20:55:25.158 +00:00 [INF] Writing value of type 'Int64' as Json.
2025-12-11 20:55:25.158 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd'
2025-12-11 20:55:25.158 +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.2145ms
2025-12-11 20:55:25.219 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41134 - null null
2025-12-11 20:55:25.219 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:55:25.219 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41134 - 204 null null 0.2592ms
2025-12-11 20:55:25.231 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 20:55:25.231 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:55:25.231 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3023ms
2025-12-11 20:55:25.279 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41134 - application/json 106
2025-12-11 20:55:25.279 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:55:25.280 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-12-11 20:55:25.282 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate]
FROM [Products] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-12-11 20:55:25.290 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null
2025-12-11 20:55:25.291 +00:00 [INF] CORS policy execution successful.
2025-12-11 20:55:25.291 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 20:55:25.293 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate]
FROM [PaymentTypes] AS [p]
WHERE [p].[DeleteFlag] = CAST(0 AS bit)
2025-12-11 20:55:25.293 +00:00 [INF] Setting HTTP status code 200.
2025-12-11 20:55:25.294 +00:00 [INF] Writing value of type 'List`1' as Json.
2025-12-11 20:55:25.294 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/'
2025-12-11 20:55:25.294 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 3.977ms
2025-12-11 20:55:25.427 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
2025-12-11 20:55:25.429 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30']
SET NOCOUNT ON;
INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType])
VALUES (@p0, @p1, @p2, @p3, @p4);
UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21
OUTPUT 1
WHERE [Id] = @p22;
INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate])
OUTPUT INSERTED.[Id]
VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35);
INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice])
OUTPUT INSERTED.[Id]
VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47);
2025-12-11 20:55:25.432 +00:00 [INF] Setting HTTP status code 201.
2025-12-11 20:55:25.433 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}'
2025-12-11 20:55:25.433 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41134 - 201 0 null 153.5005ms