2025-11-25 03:40:52.268 +00:00 [INF] Request starting HTTP/1.0 GET http:/// - null null 2025-11-25 03:40:52.269 +00:00 [INF] Request finished HTTP/1.0 GET http:/// - 404 0 null 0.6724ms 2025-11-25 03:40:52.269 +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-11-25 05:53:29.615 +00:00 [INF] Request starting HTTP/1.1 GET http://localhost:5227/.env - null null 2025-11-25 05:53:29.616 +00:00 [INF] Request finished HTTP/1.1 GET http://localhost:5227/.env - 404 0 null 0.291ms 2025-11-25 05:53:29.616 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://localhost:5227/.env, Response status code: 404 2025-11-25 07:05:48.109 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null 2025-11-25 07:05:48.110 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.6441ms 2025-11-25 07:05:48.110 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404 2025-11-25 07:05:58.619 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null 2025-11-25 07:05:58.619 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.2813ms 2025-11-25 07:05:58.619 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/, Response status code: 404 2025-11-25 07:06:04.642 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/wiki - null null 2025-11-25 07:06:04.643 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/wiki - 404 0 null 0.3907ms 2025-11-25 07:06:04.643 +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/wiki, Response status code: 404 2025-11-25 09:58:06.651 +00:00 [INF] Request starting HTTP/1.1 GET http://localhost:5227/.env - null null 2025-11-25 09:58:06.654 +00:00 [INF] Request finished HTTP/1.1 GET http://localhost:5227/.env - 404 0 null 2.5114ms 2025-11-25 09:58:06.654 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://localhost:5227/.env, Response status code: 404 2025-11-25 12:31:35.631 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null 2025-11-25 12:31:35.632 +00:00 [INF] CORS policy execution successful. 2025-11-25 12:31:35.632 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.521ms 2025-11-25 12:31:35.692 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 65 2025-11-25 12:31:35.692 +00:00 [INF] CORS policy execution successful. 2025-11-25 12:31:35.692 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin' 2025-11-25 12:31:35.988 +00:00 [INF] Executed DbCommand (11ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName] FROM [AspNetUsers] AS [a] WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0 2025-11-25 12:31:36.106 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (Size = 450)], CommandType='"Text"', CommandTimeout='30'] SELECT [a0].[Name] FROM [AspNetUserRoles] AS [a] INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id] WHERE [a].[UserId] = @__userId_0 2025-11-25 12:31:36.107 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 12:31:36.107 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json. 2025-11-25 12:31:36.108 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin' 2025-11-25 12:31:36.108 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 416.1046ms 2025-11-25 15:41:10.342 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-25 15:41:10.342 +00:00 [INF] CORS policy execution successful. 2025-11-25 15:41:10.342 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.303ms 2025-11-25 15:41:10.343 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-11-25 15:41:10.343 +00:00 [INF] CORS policy execution successful. 2025-11-25 15:41:10.343 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.3271ms 2025-11-25 15:41:10.343 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-11-25 15:41:10.343 +00:00 [INF] CORS policy execution successful. 2025-11-25 15:41:10.343 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.0701ms 2025-11-25 15:41:10.352 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null 2025-11-25 15:41:10.353 +00:00 [INF] CORS policy execution successful. 2025-11-25 15:41:10.353 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.2876ms 2025-11-25 15:41:10.400 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-25 15:41:10.400 +00:00 [INF] CORS policy execution successful. 2025-11-25 15:41:10.401 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-25 15:41:10.402 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-11-25 15:41:10.402 +00:00 [INF] CORS policy execution successful. 2025-11-25 15:41:10.402 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-11-25 15:41:10.403 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-11-25 15:41:10.403 +00:00 [INF] CORS policy execution successful. 2025-11-25 15:41:10.403 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-11-25 15:41:10.413 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null 2025-11-25 15:41:10.413 +00:00 [INF] CORS policy execution successful. 2025-11-25 15:41:10.413 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities' 2025-11-25 15:41:10.670 +00:00 [INF] Executed DbCommand (12ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-25 15:41:10.671 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 15:41:10.671 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 15:41:10.672 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-25 15:41:10.672 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 272.1951ms 2025-11-25 15:41:10.675 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [ProductTaxes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-25 15:41:10.676 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 15:41:10.676 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 15:41:10.676 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-11-25 15:41:10.676 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 274.603ms 2025-11-25 15:41:10.678 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate] FROM [Settings] AS [s] 2025-11-25 15:41:10.678 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 15:41:10.679 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-11-25 15:41:10.679 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-11-25 15:41:10.679 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 276.0512ms 2025-11-25 15:41:10.680 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [n].[Id], [n].[Descripcion], [n].[Estatus], [n].[Gentilicio], [n].[Siglas] FROM [Nationalities] AS [n] 2025-11-25 15:41:10.681 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 15:41:10.681 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 15:41:10.682 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities' 2025-11-25 15:41:10.682 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 269.133ms 2025-11-25 15:41:14.222 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - null null 2025-11-25 15:41:14.222 +00:00 [INF] CORS policy execution successful. 2025-11-25 15:41:14.222 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - 204 null null 0.2477ms 2025-11-25 15:41:14.282 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma - null null 2025-11-25 15:41:14.282 +00:00 [INF] CORS policy execution successful. 2025-11-25 15:41:14.282 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 15:41:14.289 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-25 15:41:14.308 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 15:41:14.308 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 15:41:14.532 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 15:41:14.532 +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 250.5662ms 2025-11-25 15:41:20.950 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/consulta - null null 2025-11-25 15:41:20.951 +00:00 [INF] CORS policy execution successful. 2025-11-25 15:41:20.951 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/consulta - 204 null null 0.3913ms 2025-11-25 15:41:21.010 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/consulta - null null 2025-11-25 15:41:21.011 +00:00 [INF] CORS policy execution successful. 2025-11-25 15:41:21.011 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 15:41:21.015 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-25 15:41:21.024 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 15:41:21.024 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 15:41:21.025 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 15:41:21.025 +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 14.9664ms 2025-11-25 15:42:12.879 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null 2025-11-25 15:42:12.881 +00:00 [INF] CORS policy execution successful. 2025-11-25 15:42:12.881 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 1.3723ms 2025-11-25 15:42:12.941 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182 2025-11-25 15:42:12.942 +00:00 [INF] CORS policy execution successful. 2025-11-25 15:42:12.942 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd' 2025-11-25 15:42:12.950 +00:00 [INF] Executed DbCommand (7ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9); 2025-11-25 15:42:12.954 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7); 2025-11-25 15:42:12.955 +00:00 [INF] Setting HTTP status code 201. 2025-11-25 15:42:12.955 +00:00 [INF] Writing value of type 'Int64' as Json. 2025-11-25 15:42:12.955 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd' 2025-11-25 15:42:12.955 +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.6365ms 2025-11-25 15:42:13.019 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40997 - null null 2025-11-25 15:42:13.020 +00:00 [INF] CORS policy execution successful. 2025-11-25 15:42:13.020 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40997 - 204 null null 1.1696ms 2025-11-25 15:42:13.031 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-25 15:42:13.031 +00:00 [INF] CORS policy execution successful. 2025-11-25 15:42:13.032 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2912ms 2025-11-25 15:42:13.078 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40997 - application/json 211 2025-11-25 15:42:13.079 +00:00 [INF] CORS policy execution successful. 2025-11-25 15:42:13.080 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-25 15:42:13.083 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-25 15:42:13.089 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-25 15:42:13.089 +00:00 [INF] CORS policy execution successful. 2025-11-25 15:42:13.089 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-25 15:42:13.092 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-25 15:42:13.093 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 15:42:13.093 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 15:42:13.093 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-25 15:42:13.093 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 4.4425ms 2025-11-25 15:42:13.278 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'. 2025-11-25 15:42:13.286 +00:00 [INF] Executed DbCommand (8ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p40='?' (DbType = Int32), @p23='?' (Size = 4000), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Int32), @p26='?' (DbType = Guid), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Boolean), @p29='?' (DbType = DateTime2), @p30='?' (DbType = Int32), @p31='?' (Size = 150), @p32='?' (Size = 500), @p33='?' (Size = -1) (DbType = Binary), @p34='?' (DbType = Int32), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p36='?' (Size = 4000), @p37='?' (DbType = Int32), @p38='?' (DbType = Guid), @p39='?' (DbType = DateTime2), @p41='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p42='?' (DbType = Guid), @p43='?' (DbType = DateTime2), @p44='?' (DbType = Boolean), @p45='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p46='?' (DbType = Int32), @p47='?' (DbType = Int32), @p48='?' (DbType = Int64), @p49='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p50='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p51='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p52='?' (DbType = Guid), @p53='?' (DbType = DateTime2), @p54='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p55='?' (DbType = Guid), @p56='?' (DbType = DateTime2), @p57='?' (DbType = Boolean), @p58='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p59='?' (DbType = Int32), @p60='?' (DbType = Int32), @p61='?' (DbType = Int64), @p62='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p63='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p64='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p65='?' (DbType = Guid), @p66='?' (DbType = DateTime2), @p67='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p68='?' (DbType = Guid), @p69='?' (DbType = DateTime2), @p70='?' (DbType = Int32), @p71='?' (Size = 34), @p72='?' (DbType = Guid), @p73='?' (DbType = Int32), @p74='?' (DbType = Int32), @p75='?' (DbType = Int32), @p76='?' (Size = 4000), @p77='?' (Size = 4000), @p78='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p79='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p80='?' (DbType = Guid), @p81='?' (DbType = DateTime2), @p82='?' (DbType = Int32), @p83='?' (Size = 34), @p84='?' (DbType = Guid), @p85='?' (DbType = Int32), @p86='?' (DbType = Int32), @p87='?' (DbType = Int32), @p88='?' (Size = 4000), @p89='?' (Size = 4000), @p90='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21 OUTPUT 1 WHERE [Id] = @p22; UPDATE [Products] SET [BarCode] = @p23, [BuyPrice] = @p24, [CategoryId] = @p25, [CreatedById] = @p26, [CreatedDate] = @p27, [DeleteFlag] = @p28, [ExpirationDate] = @p29, [MinimunStock] = @p30, [Name] = @p31, [Note] = @p32, [ProductImage] = @p33, [ProductTaxId] = @p34, [SalePrice] = @p35, [Status] = @p36, [Stock] = @p37, [UpdatedById] = @p38, [UpdatedDate] = @p39 OUTPUT 1 WHERE [Id] = @p40; MERGE [SalesDetail] USING ( VALUES (@p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52, @p53, 0), (@p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62, @p63, @p64, @p65, @p66, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate], _Position) ON 1=0 WHEN NOT MATCHED THEN INSERT ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate]) VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[DeleteFlag], i.[DiscountAmount], i.[ProductId], i.[Quantity], i.[SalesId], i.[Tax], i.[Total], i.[UnitPrice], i.[UpdatedById], i.[UpdatedDate]) OUTPUT INSERTED.[Id], i._Position; MERGE [InventoryMovements] USING ( VALUES (@p67, @p68, @p69, @p70, @p71, @p72, @p73, @p74, @p75, @p76, @p77, @p78, 0), (@p79, @p80, @p81, @p82, @p83, @p84, @p85, @p86, @p87, @p88, @p89, @p90, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice], _Position) ON 1=0 WHEN NOT MATCHED THEN INSERT ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice]) VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[Difference], i.[Discriminator], i.[InventoryMovementHeaderId], i.[NewStock], i.[OriginaStock], i.[ProductId], i.[ProductName], i.[Reazon], i.[SalePrice]) OUTPUT INSERTED.[Id], i._Position; 2025-11-25 15:42:13.293 +00:00 [INF] Setting HTTP status code 201. 2025-11-25 15:42:13.293 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-25 15:42:13.293 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40997 - 201 0 null 215.044ms 2025-11-25 15:48:27.389 +00:00 [INF] Request starting HTTP/1.0 GET http:/// - null null 2025-11-25 15:48:27.390 +00:00 [INF] Request finished HTTP/1.0 GET http:/// - 404 0 null 0.3173ms 2025-11-25 15:48:27.390 +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-11-25 16:29:01.915 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - null null 2025-11-25 16:29:01.915 +00:00 [INF] CORS policy execution successful. 2025-11-25 16:29:01.915 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plasma - 204 null null 0.4404ms 2025-11-25 16:29:01.975 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plasma - null null 2025-11-25 16:29:01.976 +00:00 [INF] CORS policy execution successful. 2025-11-25 16:29:01.976 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 16:29:02.303 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-25 16:29:02.324 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 16:29:02.324 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 16:29:02.502 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 16:29:02.502 +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 527.0384ms 2025-11-25 16:29:09.883 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null 2025-11-25 16:29:09.883 +00:00 [INF] CORS policy execution successful. 2025-11-25 16:29:09.884 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3438ms 2025-11-25 16:29:09.941 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182 2025-11-25 16:29:09.941 +00:00 [INF] CORS policy execution successful. 2025-11-25 16:29:09.941 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd' 2025-11-25 16:29:09.946 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9); 2025-11-25 16:29:09.949 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7); 2025-11-25 16:29:09.950 +00:00 [INF] Setting HTTP status code 201. 2025-11-25 16:29:09.950 +00:00 [INF] Writing value of type 'Int64' as Json. 2025-11-25 16:29:09.950 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd' 2025-11-25 16:29:09.950 +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.5254ms 2025-11-25 16:29:10.020 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40998 - null null 2025-11-25 16:29:10.020 +00:00 [INF] CORS policy execution successful. 2025-11-25 16:29:10.020 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40998 - 204 null null 0.3295ms 2025-11-25 16:29:10.080 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-25 16:29:10.080 +00:00 [INF] CORS policy execution successful. 2025-11-25 16:29:10.080 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3344ms 2025-11-25 16:29:10.095 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40998 - application/json 106 2025-11-25 16:29:10.096 +00:00 [INF] CORS policy execution successful. 2025-11-25 16:29:10.096 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-25 16:29:10.099 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-25 16:29:10.140 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-25 16:29:10.140 +00:00 [INF] CORS policy execution successful. 2025-11-25 16:29:10.141 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-25 16:29:10.186 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-25 16:29:10.187 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 16:29:10.187 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 16:29:10.188 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-25 16:29:10.188 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 48.0317ms 2025-11-25 16:29:10.300 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'. 2025-11-25 16:29:10.303 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21 OUTPUT 1 WHERE [Id] = @p22; INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35); INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice]) OUTPUT INSERTED.[Id] VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47); 2025-11-25 16:29:10.307 +00:00 [INF] Setting HTTP status code 201. 2025-11-25 16:29:10.308 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-25 16:29:10.308 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40998 - 201 0 null 212.7201ms 2025-11-25 16:29:41.967 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/terapia - null null 2025-11-25 16:29:41.968 +00:00 [INF] CORS policy execution successful. 2025-11-25 16:29:41.968 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/terapia - 204 null null 1.36ms 2025-11-25 16:29:42.023 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/terapia - null null 2025-11-25 16:29:42.023 +00:00 [INF] CORS policy execution successful. 2025-11-25 16:29:42.024 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 16:29:42.027 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-25 16:29:42.042 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 16:29:42.043 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 16:29:42.209 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 16:29:42.210 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/terapia - 200 null application/json; charset=utf-8 186.3223ms 2025-11-25 16:29:49.942 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null 2025-11-25 16:29:49.943 +00:00 [INF] CORS policy execution successful. 2025-11-25 16:29:49.944 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 1.9261ms 2025-11-25 16:29:50.002 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182 2025-11-25 16:29:50.002 +00:00 [INF] CORS policy execution successful. 2025-11-25 16:29:50.002 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd' 2025-11-25 16:29:50.009 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9); 2025-11-25 16:29:50.013 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7); 2025-11-25 16:29:50.014 +00:00 [INF] Setting HTTP status code 201. 2025-11-25 16:29:50.014 +00:00 [INF] Writing value of type 'Int64' as Json. 2025-11-25 16:29:50.014 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd' 2025-11-25 16:29:50.015 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 12.6607ms 2025-11-25 16:29:50.072 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40999 - null null 2025-11-25 16:29:50.073 +00:00 [INF] CORS policy execution successful. 2025-11-25 16:29:50.073 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40999 - 204 null null 1.0951ms 2025-11-25 16:29:50.075 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-25 16:29:50.075 +00:00 [INF] CORS policy execution successful. 2025-11-25 16:29:50.075 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3644ms 2025-11-25 16:29:50.128 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40999 - application/json 106 2025-11-25 16:29:50.129 +00:00 [INF] CORS policy execution successful. 2025-11-25 16:29:50.129 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-25 16:29:50.132 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-25 16:29:50.132 +00:00 [INF] CORS policy execution successful. 2025-11-25 16:29:50.133 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-25 16:29:50.133 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-25 16:29:50.136 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-25 16:29:50.138 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 16:29:50.138 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 16:29:50.138 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-25 16:29:50.139 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 6.6274ms 2025-11-25 16:29:50.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-11-25 16:29:50.402 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21 OUTPUT 1 WHERE [Id] = @p22; INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35); INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice]) OUTPUT INSERTED.[Id] VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47); 2025-11-25 16:29:50.408 +00:00 [INF] Setting HTTP status code 201. 2025-11-25 16:29:50.408 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-25 16:29:50.408 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40999 - 201 0 null 279.8011ms 2025-11-25 16:33:05.587 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/msm - null null 2025-11-25 16:33:05.587 +00:00 [INF] CORS policy execution successful. 2025-11-25 16:33:05.587 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/msm - 204 null null 0.3014ms 2025-11-25 16:33:05.646 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/msm - null null 2025-11-25 16:33:05.647 +00:00 [INF] CORS policy execution successful. 2025-11-25 16:33:05.647 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 16:33:05.650 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-25 16:33:05.653 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 16:33:05.653 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 16:33:05.654 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 16:33:05.654 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/msm - 200 null application/json; charset=utf-8 7.4754ms 2025-11-25 16:33:20.287 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-25 16:33:20.287 +00:00 [INF] CORS policy execution successful. 2025-11-25 16:33:20.287 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3848ms 2025-11-25 16:33:20.356 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-25 16:33:20.356 +00:00 [INF] CORS policy execution successful. 2025-11-25 16:33:20.357 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-25 16:33:20.359 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-25 16:33:20.360 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 16:33:20.360 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 16:33:20.360 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-25 16:33:20.360 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 3.9348ms 2025-11-25 17:03:48.649 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - null null 2025-11-25 17:03:48.649 +00:00 [INF] CORS policy execution successful. 2025-11-25 17:03:48.649 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - 204 null null 0.586ms 2025-11-25 17:03:48.710 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan - null null 2025-11-25 17:03:48.710 +00:00 [INF] CORS policy execution successful. 2025-11-25 17:03:48.711 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 17:03:48.972 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-25 17:03:48.982 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 17:03:48.982 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 17:03:49.096 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 17:03:49.096 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan - 200 null application/json; charset=utf-8 385.9057ms 2025-11-25 17:03:58.088 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null 2025-11-25 17:03:58.088 +00:00 [INF] CORS policy execution successful. 2025-11-25 17:03:58.089 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.358ms 2025-11-25 17:03:58.148 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 188 2025-11-25 17:03:58.148 +00:00 [INF] CORS policy execution successful. 2025-11-25 17:03:58.148 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd' 2025-11-25 17:03:58.153 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9); 2025-11-25 17:03:58.157 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7); 2025-11-25 17:03:58.157 +00:00 [INF] Setting HTTP status code 201. 2025-11-25 17:03:58.157 +00:00 [INF] Writing value of type 'Int64' as Json. 2025-11-25 17:03:58.157 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd' 2025-11-25 17:03:58.157 +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.0598ms 2025-11-25 17:03:58.222 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41000 - null null 2025-11-25 17:03:58.222 +00:00 [INF] CORS policy execution successful. 2025-11-25 17:03:58.223 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41000 - 204 null null 0.3138ms 2025-11-25 17:03:58.288 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-25 17:03:58.288 +00:00 [INF] CORS policy execution successful. 2025-11-25 17:03:58.288 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3707ms 2025-11-25 17:03:58.304 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41000 - application/json 110 2025-11-25 17:03:58.304 +00:00 [INF] CORS policy execution successful. 2025-11-25 17:03:58.305 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-25 17:03:58.307 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-25 17:03:58.348 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-25 17:03:58.349 +00:00 [INF] CORS policy execution successful. 2025-11-25 17:03:58.349 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-25 17:03:58.388 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-25 17:03:58.389 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 17:03:58.389 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 17:03:58.389 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-25 17:03:58.389 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 41.1523ms 2025-11-25 17:03:58.521 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'. 2025-11-25 17:03:58.528 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21 OUTPUT 1 WHERE [Id] = @p22; INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35); INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice]) OUTPUT INSERTED.[Id] VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47); 2025-11-25 17:03:58.533 +00:00 [INF] Setting HTTP status code 201. 2025-11-25 17:03:58.534 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-25 17:03:58.534 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41000 - 201 0 null 230.2042ms 2025-11-25 17:04:20.935 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/oemga - null null 2025-11-25 17:04:20.935 +00:00 [INF] CORS policy execution successful. 2025-11-25 17:04:20.936 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/oemga - 204 null null 0.4715ms 2025-11-25 17:04:20.994 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/oemga - null null 2025-11-25 17:04:20.994 +00:00 [INF] CORS policy execution successful. 2025-11-25 17:04:20.995 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 17:04:21.001 +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-11-25 17:04:21.001 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 17:04:21.001 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 17:04:21.001 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 17:04:21.001 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/oemga - 200 null application/json; charset=utf-8 7.3151ms 2025-11-25 17:04:24.464 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/omega - null null 2025-11-25 17:04:24.464 +00:00 [INF] CORS policy execution successful. 2025-11-25 17:04:24.464 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/omega - 204 null null 0.3911ms 2025-11-25 17:04:24.523 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/omega - null null 2025-11-25 17:04:24.523 +00:00 [INF] CORS policy execution successful. 2025-11-25 17:04:24.524 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 17:04:24.527 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-25 17:04:24.534 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 17:04:24.535 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 17:04:24.653 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 17:04:24.654 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/omega - 200 null application/json; charset=utf-8 130.833ms 2025-11-25 17:04:45.429 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-25 17:04:45.429 +00:00 [INF] CORS policy execution successful. 2025-11-25 17:04:45.429 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.3257ms 2025-11-25 17:04:45.489 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-25 17:04:45.489 +00:00 [INF] CORS policy execution successful. 2025-11-25 17:04:45.489 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-25 17:04:45.491 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-25 17:04:45.491 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 17:04:45.491 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 17:04:45.492 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-25 17:04:45.492 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 2.8884ms 2025-11-25 18:25:52.107 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - null null 2025-11-25 18:25:52.108 +00:00 [INF] CORS policy execution successful. 2025-11-25 18:25:52.108 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - 204 null null 0.2606ms 2025-11-25 18:25:52.167 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - null null 2025-11-25 18:25:52.167 +00:00 [INF] CORS policy execution successful. 2025-11-25 18:25:52.167 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}' 2025-11-25 18:25:52.167 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}' 2025-11-25 18:25:52.167 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - 400 0 null 0.5797ms 2025-11-25 19:23:43.751 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - null null 2025-11-25 19:23:43.751 +00:00 [INF] CORS policy execution successful. 2025-11-25 19:23:43.751 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ - 204 null null 0.3542ms 2025-11-25 19:23:43.809 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - null null 2025-11-25 19:23:43.810 +00:00 [INF] CORS policy execution successful. 2025-11-25 19:23:43.810 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}' 2025-11-25 19:23:43.810 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}' 2025-11-25 19:23:43.810 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - 400 0 null 0.7261ms 2025-11-25 19:23:47.161 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - null null 2025-11-25 19:23:47.161 +00:00 [INF] CORS policy execution successful. 2025-11-25 19:23:47.161 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}' 2025-11-25 19:23:47.161 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}' 2025-11-25 19:23:47.161 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ - 400 0 null 0.6978ms 2025-11-25 21:29:22.866 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null 2025-11-25 21:29:22.866 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:29:22.866 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.289ms 2025-11-25 21:29:22.925 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 61 2025-11-25 21:29:22.926 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:29:22.926 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin' 2025-11-25 21:29:23.159 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName] FROM [AspNetUsers] AS [a] WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0 2025-11-25 21:29:23.333 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (Size = 450)], CommandType='"Text"', CommandTimeout='30'] SELECT [a0].[Name] FROM [AspNetUserRoles] AS [a] INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id] WHERE [a].[UserId] = @__userId_0 2025-11-25 21:29:23.334 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 21:29:23.334 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json. 2025-11-25 21:29:23.334 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin' 2025-11-25 21:29:23.335 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 409.3285ms 2025-11-25 21:29:30.269 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-25 21:29:30.269 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:29:30.269 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2614ms 2025-11-25 21:29:30.344 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null 2025-11-25 21:29:30.344 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:29:30.344 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-25 21:29:30.345 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:29:30.345 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 1.1215ms 2025-11-25 21:29:30.345 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-11-25 21:29:30.345 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:29:30.345 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.2807ms 2025-11-25 21:29:30.346 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-11-25 21:29:30.346 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:29:30.346 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.1319ms 2025-11-25 21:29:30.347 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-25 21:29:30.363 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-25 21:29:30.364 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 21:29:30.364 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 21:29:30.364 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-25 21:29:30.364 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 19.5729ms 2025-11-25 21:29:30.409 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-11-25 21:29:30.410 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:29:30.410 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-11-25 21:29:30.411 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-11-25 21:29:30.412 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:29:30.412 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-11-25 21:29:30.413 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Percentage], [p].[TaxDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [ProductTaxes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-25 21:29:30.413 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 21:29:30.413 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 21:29:30.413 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-11-25 21:29:30.413 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 4.0276ms 2025-11-25 21:29:30.414 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null 2025-11-25 21:29:30.414 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:29:30.415 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate] FROM [Settings] AS [s] 2025-11-25 21:29:30.415 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 21:29:30.415 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-11-25 21:29:30.415 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-11-25 21:29:30.415 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 3.667ms 2025-11-25 21:29:30.415 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities' 2025-11-25 21:29:30.417 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [n].[Id], [n].[Descripcion], [n].[Estatus], [n].[Gentilicio], [n].[Siglas] FROM [Nationalities] AS [n] 2025-11-25 21:29:30.418 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 21:29:30.418 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 21:29:30.418 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities' 2025-11-25 21:29:30.418 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 3.8905ms 2025-11-25 21:35:00.631 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null 2025-11-25 21:35:00.631 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:35:00.631 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.2993ms 2025-11-25 21:35:00.683 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 58 2025-11-25 21:35:00.683 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:35:00.683 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin' 2025-11-25 21:35:00.685 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName] FROM [AspNetUsers] AS [a] WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0 2025-11-25 21:35:00.792 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (Size = 450)], CommandType='"Text"', CommandTimeout='30'] SELECT [a0].[Name] FROM [AspNetUserRoles] AS [a] INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id] WHERE [a].[UserId] = @__userId_0 2025-11-25 21:35:00.793 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 21:35:00.793 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json. 2025-11-25 21:35:00.793 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin' 2025-11-25 21:35:00.793 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 110.1428ms 2025-11-25 21:35:10.155 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - null null 2025-11-25 21:35:10.155 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:35:10.155 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - 204 null null 0.2632ms 2025-11-25 21:35:10.206 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - null null 2025-11-25 21:35:10.206 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:35:10.206 +00:00 [INF] Executing endpoint 'HTTP: GET InventoryReplenishment/' 2025-11-25 21:35:10.215 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [t].[Id], [t].[CreatedById], [t].[CreatedDate], [t].[DeleteFlag], [t].[Description], [t].[UpdatedById], [t].[UpdatedDate], [t0].[Id], [t0].[CreatedById], [t0].[CreatedDate], [t0].[DeleteFlag], [t0].[Percentage], [t0].[TaxDescription], [t0].[UpdatedById], [t0].[UpdatedDate] FROM [Products] AS [p] INNER JOIN ( SELECT [p0].[Id], [p0].[CreatedById], [p0].[CreatedDate], [p0].[DeleteFlag], [p0].[Description], [p0].[UpdatedById], [p0].[UpdatedDate] FROM [ProductCategories] AS [p0] WHERE [p0].[DeleteFlag] = CAST(0 AS bit) ) AS [t] ON [p].[CategoryId] = [t].[Id] INNER JOIN ( SELECT [p1].[Id], [p1].[CreatedById], [p1].[CreatedDate], [p1].[DeleteFlag], [p1].[Percentage], [p1].[TaxDescription], [p1].[UpdatedById], [p1].[UpdatedDate] FROM [ProductTaxes] AS [p1] WHERE [p1].[DeleteFlag] = CAST(0 AS bit) ) AS [t0] ON [p].[ProductTaxId] = [t0].[Id] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 3) 2025-11-25 21:35:10.366 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 21:35:10.366 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 21:35:10.366 +00:00 [INF] Executed endpoint 'HTTP: GET InventoryReplenishment/' 2025-11-25 21:35:10.366 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - 200 null application/json; charset=utf-8 160.6469ms 2025-11-25 21:35:46.533 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - null null 2025-11-25 21:35:46.533 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:35:46.533 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - 204 null null 0.3373ms 2025-11-25 21:35:46.585 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - application/json 46 2025-11-25 21:35:46.585 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:35:46.585 +00:00 [INF] Executing endpoint 'HTTP: POST InventoryReplenishment/createInvRepHD' 2025-11-25 21:35:46.589 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); 2025-11-25 21:35:46.589 +00:00 [INF] Setting HTTP status code 201. 2025-11-25 21:35:46.589 +00:00 [INF] Writing value of type 'Guid' as Json. 2025-11-25 21:35:46.589 +00:00 [INF] Executed endpoint 'HTTP: POST InventoryReplenishment/createInvRepHD' 2025-11-25 21:35:46.589 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - 201 null application/json; charset=utf-8 4.7884ms 2025-11-25 21:35:46.645 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - null null 2025-11-25 21:35:46.645 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:35:46.645 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - 204 null null 0.6768ms 2025-11-25 21:35:46.697 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - application/json 427 2025-11-25 21:35:46.697 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:35:46.698 +00:00 [INF] Executing endpoint 'HTTP: POST InventoryReplenishment/createInvRepDet' 2025-11-25 21:35:46.702 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [t].[Id], [t].[CreatedById], [t].[CreatedDate], [t].[DeleteFlag], [t].[Description], [t].[UpdatedById], [t].[UpdatedDate], [t0].[Id], [t0].[CreatedById], [t0].[CreatedDate], [t0].[DeleteFlag], [t0].[Percentage], [t0].[TaxDescription], [t0].[UpdatedById], [t0].[UpdatedDate] FROM [Products] AS [p] INNER JOIN ( SELECT [p0].[Id], [p0].[CreatedById], [p0].[CreatedDate], [p0].[DeleteFlag], [p0].[Description], [p0].[UpdatedById], [p0].[UpdatedDate] FROM [ProductCategories] AS [p0] WHERE [p0].[DeleteFlag] = CAST(0 AS bit) ) AS [t] ON [p].[CategoryId] = [t].[Id] INNER JOIN ( SELECT [p1].[Id], [p1].[CreatedById], [p1].[CreatedDate], [p1].[DeleteFlag], [p1].[Percentage], [p1].[TaxDescription], [p1].[UpdatedById], [p1].[UpdatedDate] FROM [ProductTaxes] AS [p1] WHERE [p1].[DeleteFlag] = CAST(0 AS bit) ) AS [t0] ON [p].[ProductTaxId] = [t0].[Id] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-25 21:35:46.907 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0 2025-11-25 21:35:46.909 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0 2025-11-25 21:35:46.913 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Int32), @p4='?' (Size = 34), @p5='?' (DbType = Guid), @p6='?' (DbType = Int32), @p7='?' (DbType = Int32), @p8='?' (DbType = Int32), @p9='?' (Size = 4000), @p10='?' (Size = 4000), @p11='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p12='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p13='?' (DbType = Guid), @p14='?' (DbType = DateTime2), @p15='?' (DbType = Int32), @p16='?' (Size = 34), @p17='?' (DbType = Guid), @p18='?' (DbType = Int32), @p19='?' (DbType = Int32), @p20='?' (DbType = Int32), @p21='?' (Size = 4000), @p22='?' (Size = 4000), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p41='?' (DbType = Int32), @p24='?' (Size = 4000), @p25='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p26='?' (DbType = Int32), @p27='?' (DbType = Guid), @p28='?' (DbType = DateTime2), @p29='?' (DbType = Boolean), @p30='?' (DbType = DateTime2), @p31='?' (DbType = Int32), @p32='?' (Size = 150), @p33='?' (Size = 500), @p34='?' (Size = -1) (DbType = Binary), @p35='?' (DbType = Int32), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (Size = 4000), @p38='?' (DbType = Int32), @p39='?' (DbType = Guid), @p40='?' (DbType = DateTime2), @p59='?' (DbType = Int32), @p42='?' (Size = 4000), @p43='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p44='?' (DbType = Int32), @p45='?' (DbType = Guid), @p46='?' (DbType = DateTime2), @p47='?' (DbType = Boolean), @p48='?' (DbType = DateTime2), @p49='?' (DbType = Int32), @p50='?' (Size = 150), @p51='?' (Size = 500), @p52='?' (Size = -1) (DbType = Binary), @p53='?' (DbType = Int32), @p54='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p55='?' (Size = 4000), @p56='?' (DbType = Int32), @p57='?' (DbType = Guid), @p58='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; MERGE [InventoryMovements] USING ( VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, 0), (@p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice], _Position) ON 1=0 WHEN NOT MATCHED THEN INSERT ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice]) VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[Difference], i.[Discriminator], i.[InventoryMovementHeaderId], i.[NewStock], i.[OriginaStock], i.[ProductId], i.[ProductName], i.[Reazon], i.[SalePrice]) OUTPUT INSERTED.[Id], i._Position; UPDATE [Products] SET [BarCode] = @p24, [BuyPrice] = @p25, [CategoryId] = @p26, [CreatedById] = @p27, [CreatedDate] = @p28, [DeleteFlag] = @p29, [ExpirationDate] = @p30, [MinimunStock] = @p31, [Name] = @p32, [Note] = @p33, [ProductImage] = @p34, [ProductTaxId] = @p35, [SalePrice] = @p36, [Status] = @p37, [Stock] = @p38, [UpdatedById] = @p39, [UpdatedDate] = @p40 OUTPUT 1 WHERE [Id] = @p41; UPDATE [Products] SET [BarCode] = @p42, [BuyPrice] = @p43, [CategoryId] = @p44, [CreatedById] = @p45, [CreatedDate] = @p46, [DeleteFlag] = @p47, [ExpirationDate] = @p48, [MinimunStock] = @p49, [Name] = @p50, [Note] = @p51, [ProductImage] = @p52, [ProductTaxId] = @p53, [SalePrice] = @p54, [Status] = @p55, [Stock] = @p56, [UpdatedById] = @p57, [UpdatedDate] = @p58 OUTPUT 1 WHERE [Id] = @p59; 2025-11-25 21:35:46.916 +00:00 [INF] Setting HTTP status code 201. 2025-11-25 21:35:46.917 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 21:35:46.917 +00:00 [INF] Executed endpoint 'HTTP: POST InventoryReplenishment/createInvRepDet' 2025-11-25 21:35:46.917 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - 201 null application/json; charset=utf-8 219.9534ms 2025-11-25 21:35:46.973 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - null null 2025-11-25 21:35:46.973 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:35:46.973 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - 204 null null 0.3281ms 2025-11-25 21:35:47.025 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - null null 2025-11-25 21:35:47.025 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:35:47.026 +00:00 [INF] Executing endpoint 'HTTP: GET InventoryReplenishment/' 2025-11-25 21:35:47.029 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [t].[Id], [t].[CreatedById], [t].[CreatedDate], [t].[DeleteFlag], [t].[Description], [t].[UpdatedById], [t].[UpdatedDate], [t0].[Id], [t0].[CreatedById], [t0].[CreatedDate], [t0].[DeleteFlag], [t0].[Percentage], [t0].[TaxDescription], [t0].[UpdatedById], [t0].[UpdatedDate] FROM [Products] AS [p] INNER JOIN ( SELECT [p0].[Id], [p0].[CreatedById], [p0].[CreatedDate], [p0].[DeleteFlag], [p0].[Description], [p0].[UpdatedById], [p0].[UpdatedDate] FROM [ProductCategories] AS [p0] WHERE [p0].[DeleteFlag] = CAST(0 AS bit) ) AS [t] ON [p].[CategoryId] = [t].[Id] INNER JOIN ( SELECT [p1].[Id], [p1].[CreatedById], [p1].[CreatedDate], [p1].[DeleteFlag], [p1].[Percentage], [p1].[TaxDescription], [p1].[UpdatedById], [p1].[UpdatedDate] FROM [ProductTaxes] AS [p1] WHERE [p1].[DeleteFlag] = CAST(0 AS bit) ) AS [t0] ON [p].[ProductTaxId] = [t0].[Id] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 3) 2025-11-25 21:35:47.118 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 21:35:47.119 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 21:35:47.119 +00:00 [INF] Executed endpoint 'HTTP: GET InventoryReplenishment/' 2025-11-25 21:35:47.120 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - 200 null application/json; charset=utf-8 94.7281ms 2025-11-25 21:36:36.212 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/paqn - null null 2025-11-25 21:36:36.212 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:36:36.212 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/paqn - 204 null null 0.3758ms 2025-11-25 21:36:36.270 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/paqn - null null 2025-11-25 21:36:36.270 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:36:36.271 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 21:36:36.275 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-25 21:36:36.276 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 21:36:36.276 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 21:36:36.276 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 21:36:36.276 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/paqn - 200 null application/json; charset=utf-8 5.8376ms 2025-11-25 21:36:41.224 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - null null 2025-11-25 21:36:41.225 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:36:41.225 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan - 204 null null 0.9494ms 2025-11-25 21:36:41.281 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan - null null 2025-11-25 21:36:41.281 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:36:41.281 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 21:36:41.285 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-25 21:36:41.289 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 21:36:41.290 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 21:36:41.394 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 21:36:41.394 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan - 200 null application/json; charset=utf-8 113.431ms 2025-11-25 21:38:52.215 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null 2025-11-25 21:38:52.215 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:38:52.215 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.237ms 2025-11-25 21:38:52.275 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 188 2025-11-25 21:38:52.275 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:38:52.275 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd' 2025-11-25 21:38:52.280 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9); 2025-11-25 21:38:52.283 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7); 2025-11-25 21:38:52.284 +00:00 [INF] Setting HTTP status code 201. 2025-11-25 21:38:52.284 +00:00 [INF] Writing value of type 'Int64' as Json. 2025-11-25 21:38:52.284 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd' 2025-11-25 21:38:52.284 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 8.935ms 2025-11-25 21:38:52.349 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41001 - null null 2025-11-25 21:38:52.349 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:38:52.349 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41001 - 204 null null 0.4265ms 2025-11-25 21:38:52.411 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-25 21:38:52.411 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:38:52.412 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2731ms 2025-11-25 21:38:52.422 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41001 - application/json 110 2025-11-25 21:38:52.422 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:38:52.423 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-25 21:38:52.425 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-25 21:38:52.471 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-25 21:38:52.472 +00:00 [INF] CORS policy execution successful. 2025-11-25 21:38:52.472 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-25 21:38:52.624 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'. 2025-11-25 21:38:52.627 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21 OUTPUT 1 WHERE [Id] = @p22; INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35); INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice]) OUTPUT INSERTED.[Id] VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47); 2025-11-25 21:38:52.630 +00:00 [INF] Setting HTTP status code 201. 2025-11-25 21:38:52.630 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-25 21:38:52.631 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41001 - 201 0 null 208.2331ms 2025-11-25 21:38:52.730 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-25 21:38:52.730 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 21:38:52.730 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 21:38:52.730 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-25 21:38:52.730 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 259.0037ms 2025-11-25 22:24:32.990 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33/ - null null 2025-11-25 22:24:32.990 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33/ - 404 0 null 0.2976ms 2025-11-25 22:24:32.990 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33/, Response status code: 404 2025-11-25 22:24:33.589 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/favicon.ico - null null 2025-11-25 22:24:33.590 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/favicon.ico - 404 0 null 0.2581ms 2025-11-25 22:24:33.590 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://159.89.226.33:5227/favicon.ico, Response status code: 404 2025-11-25 23:16:24.147 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/trace - null null 2025-11-25 23:16:24.147 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:16:24.147 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/trace - 204 null null 0.3551ms 2025-11-25 23:16:24.201 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/trace - null null 2025-11-25 23:16:24.201 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:16:24.201 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 23:16:24.432 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-25 23:16:24.438 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 23:16:24.438 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 23:16:24.438 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 23:16:24.439 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/trace - 200 null application/json; charset=utf-8 237.8437ms 2025-11-25 23:16:50.343 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/oi - null null 2025-11-25 23:16:50.343 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:16:50.343 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/oi - 204 null null 0.2686ms 2025-11-25 23:16:50.398 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/oi - null null 2025-11-25 23:16:50.399 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:16:50.399 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 23:16:50.401 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-25 23:16:50.409 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 23:16:50.410 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 23:16:50.574 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 23:16:50.575 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/oi - 200 null application/json; charset=utf-8 176.3456ms 2025-11-25 23:20:04.108 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null 2025-11-25 23:20:04.109 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:20:04.109 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3054ms 2025-11-25 23:20:04.169 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 191 2025-11-25 23:20:04.170 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:20:04.170 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd' 2025-11-25 23:20:04.175 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9); 2025-11-25 23:20:04.179 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7); 2025-11-25 23:20:04.180 +00:00 [INF] Setting HTTP status code 201. 2025-11-25 23:20:04.181 +00:00 [INF] Writing value of type 'Int64' as Json. 2025-11-25 23:20:04.181 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd' 2025-11-25 23:20:04.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 12.2349ms 2025-11-25 23:20:04.245 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41002 - null null 2025-11-25 23:20:04.246 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:20:04.246 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41002 - 204 null null 0.6618ms 2025-11-25 23:20:04.302 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-25 23:20:04.303 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:20:04.303 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.7366ms 2025-11-25 23:20:04.303 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41002 - application/json 214 2025-11-25 23:20:04.303 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:20:04.304 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-25 23:20:04.306 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-25 23:20:04.359 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-25 23:20:04.360 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:20:04.360 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-25 23:20:04.394 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-25 23:20:04.395 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 23:20:04.395 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 23:20:04.395 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-25 23:20:04.395 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 35.4704ms 2025-11-25 23:20:04.505 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'. 2025-11-25 23:20:04.511 +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-11-25 23:20:04.517 +00:00 [INF] Setting HTTP status code 201. 2025-11-25 23:20:04.517 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-25 23:20:04.517 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41002 - 201 0 null 214.2527ms 2025-11-25 23:21:58.398 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/amarilis - null null 2025-11-25 23:21:58.398 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:21:58.398 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/amarilis - 204 null null 0.3288ms 2025-11-25 23:21:58.455 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/amarilis - null null 2025-11-25 23:21:58.455 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:21:58.455 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 23:21:58.458 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-25 23:21:58.463 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 23:21:58.464 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 23:21:58.522 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 23:21:58.522 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/amarilis - 200 null application/json; charset=utf-8 67.609ms 2025-11-25 23:22:18.534 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null 2025-11-25 23:22:18.534 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:22:18.535 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3337ms 2025-11-25 23:22:19.290 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182 2025-11-25 23:22:19.290 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:22:19.290 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd' 2025-11-25 23:22:19.295 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9); 2025-11-25 23:22:19.298 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7); 2025-11-25 23:22:19.298 +00:00 [INF] Setting HTTP status code 201. 2025-11-25 23:22:19.298 +00:00 [INF] Writing value of type 'Int64' as Json. 2025-11-25 23:22:19.298 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd' 2025-11-25 23:22:19.298 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 8.4348ms 2025-11-25 23:22:20.083 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41003 - null null 2025-11-25 23:22:20.083 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:22:20.083 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41003 - 204 null null 0.4098ms 2025-11-25 23:22:20.140 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-25 23:22:20.140 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:22:20.140 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2998ms 2025-11-25 23:22:20.889 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41003 - application/json 105 2025-11-25 23:22:20.890 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:22:20.890 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-25 23:22:20.890 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-25 23:22:20.890 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:22:20.891 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-25 23:22:20.892 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-25 23:22:20.894 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-25 23:22:20.894 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 23:22:20.894 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 23:22:20.895 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-25 23:22:20.895 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 4.8719ms 2025-11-25 23:22:21.046 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'. 2025-11-25 23:22:21.049 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21 OUTPUT 1 WHERE [Id] = @p22; INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35); INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice]) OUTPUT INSERTED.[Id] VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47); 2025-11-25 23:22:21.056 +00:00 [INF] Setting HTTP status code 201. 2025-11-25 23:22:21.057 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-25 23:22:21.057 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41003 - 201 0 null 167.4218ms 2025-11-25 23:23:01.342 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ama - null null 2025-11-25 23:23:01.343 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:23:01.343 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/ama - 204 null null 0.3186ms 2025-11-25 23:23:01.401 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/ama - null null 2025-11-25 23:23:01.401 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:23:01.401 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 23:23:01.405 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-25 23:23:01.413 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 23:23:01.414 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 23:23:01.891 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 23:23:01.892 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/ama - 200 null application/json; charset=utf-8 491.0985ms 2025-11-25 23:23:13.728 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null 2025-11-25 23:23:13.729 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:23:13.729 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3383ms 2025-11-25 23:23:13.788 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182 2025-11-25 23:23:13.788 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:23:13.788 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd' 2025-11-25 23:23:13.793 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9); 2025-11-25 23:23:13.796 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7); 2025-11-25 23:23:13.796 +00:00 [INF] Setting HTTP status code 201. 2025-11-25 23:23:13.796 +00:00 [INF] Writing value of type 'Int64' as Json. 2025-11-25 23:23:13.796 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd' 2025-11-25 23:23:13.796 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 8.6425ms 2025-11-25 23:23:13.853 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41004 - null null 2025-11-25 23:23:13.853 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:23:13.853 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41004 - 204 null null 0.6702ms 2025-11-25 23:23:13.856 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-25 23:23:13.856 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:23:13.857 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.6848ms 2025-11-25 23:23:13.906 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41004 - application/json 105 2025-11-25 23:23:13.907 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:23:13.907 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-25 23:23:13.909 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-25 23:23:13.921 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-25 23:23:13.922 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:23:13.922 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-25 23:23:13.925 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-25 23:23:13.927 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 23:23:13.928 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 23:23:13.928 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-25 23:23:13.929 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 7.9353ms 2025-11-25 23:23:14.061 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'. 2025-11-25 23:23:14.063 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21 OUTPUT 1 WHERE [Id] = @p22; INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35); INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice]) OUTPUT INSERTED.[Id] VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47); 2025-11-25 23:23:14.068 +00:00 [INF] Setting HTTP status code 201. 2025-11-25 23:23:14.068 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-25 23:23:14.068 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41004 - 201 0 null 162.0207ms 2025-11-25 23:26:57.358 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/amaril;is - null null 2025-11-25 23:26:57.358 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:26:57.359 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/amaril;is - 204 null null 0.3558ms 2025-11-25 23:26:57.421 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/amaril;is - null null 2025-11-25 23:26:57.421 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:26:57.422 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 23:26:57.427 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-25 23:26:57.428 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 23:26:57.428 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 23:26:57.428 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 23:26:57.428 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/amaril;is - 200 null application/json; charset=utf-8 7.3296ms 2025-11-25 23:27:09.909 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/amarilis - null null 2025-11-25 23:27:09.909 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:27:09.909 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/amarilis - 204 null null 0.3437ms 2025-11-25 23:27:09.972 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/amarilis - null null 2025-11-25 23:27:09.972 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:27:09.972 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 23:27:09.975 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-25 23:27:09.981 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 23:27:09.982 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 23:27:10.104 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-25 23:27:10.104 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/amarilis - 200 null application/json; charset=utf-8 132.8376ms 2025-11-25 23:27:20.009 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null 2025-11-25 23:27:20.010 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:27:20.010 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 1.0132ms 2025-11-25 23:27:20.069 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182 2025-11-25 23:27:20.070 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:27:20.070 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd' 2025-11-25 23:27:20.074 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = DateTime2), @p2='?' (DbType = Boolean), @p3='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p4='?' (Precision = 6) (Scale = 2) (DbType = Decimal), @p5='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p6='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p7='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [Sales] ([CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [DiscountPercentage], [TotalAmount], [TotalNetAmount], [TotalTax], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9); 2025-11-25 23:27:20.078 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int32), @p5='?' (DbType = Int64), @p6='?' (DbType = Guid), @p7='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [SalesPaymentTypesDetails] ([Amount], [CreatedById], [CreatedDate], [DeleteFlag], [PaymentTypeId], [SalesId], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7); 2025-11-25 23:27:20.079 +00:00 [INF] Setting HTTP status code 201. 2025-11-25 23:27:20.079 +00:00 [INF] Writing value of type 'Int64' as Json. 2025-11-25 23:27:20.079 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd' 2025-11-25 23:27:20.079 +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.2939ms 2025-11-25 23:27:20.146 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41005 - null null 2025-11-25 23:27:20.146 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:27:20.147 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/41005 - 204 null null 0.419ms 2025-11-25 23:27:20.206 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-25 23:27:20.207 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:27:20.207 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.6379ms 2025-11-25 23:27:20.215 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41005 - application/json 105 2025-11-25 23:27:20.215 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:27:20.216 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-25 23:27:20.218 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-25 23:27:20.266 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-25 23:27:20.267 +00:00 [INF] CORS policy execution successful. 2025-11-25 23:27:20.268 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-25 23:27:20.271 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-25 23:27:20.271 +00:00 [INF] Setting HTTP status code 200. 2025-11-25 23:27:20.271 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-25 23:27:20.271 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-25 23:27:20.271 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 5.0359ms 2025-11-25 23:27:20.401 +00:00 [WRN] Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'. 2025-11-25 23:27:20.403 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21 OUTPUT 1 WHERE [Id] = @p22; INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35); INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice]) OUTPUT INSERTED.[Id] VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47); 2025-11-25 23:27:20.407 +00:00 [INF] Setting HTTP status code 201. 2025-11-25 23:27:20.407 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-25 23:27:20.408 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/41005 - 201 0 null 192.8642ms