2025-11-20 00:28:48.277 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-11-20 00:28:48.278 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-20 00:28:48.280 +00:00 [INF] CORS policy execution successful. 2025-11-20 00:28:48.280 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 2.167ms 2025-11-20 00:28:48.280 +00:00 [INF] CORS policy execution successful. 2025-11-20 00:28:48.280 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-11-20 00:28:48.280 +00:00 [INF] CORS policy execution successful. 2025-11-20 00:28:48.280 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.0627ms 2025-11-20 00:28:48.280 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 2.7994ms 2025-11-20 00:28:48.282 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null 2025-11-20 00:28:48.282 +00:00 [INF] CORS policy execution successful. 2025-11-20 00:28:48.282 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.1391ms 2025-11-20 00:28:48.342 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-20 00:28:48.342 +00:00 [INF] CORS policy execution successful. 2025-11-20 00:28:48.343 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null 2025-11-20 00:28:48.343 +00:00 [INF] CORS policy execution successful. 2025-11-20 00:28:48.345 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities' 2025-11-20 00:28:48.345 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-20 00:28:48.346 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-11-20 00:28:48.347 +00:00 [INF] CORS policy execution successful. 2025-11-20 00:28:48.347 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-11-20 00:28:48.348 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-11-20 00:28:48.348 +00:00 [INF] CORS policy execution successful. 2025-11-20 00:28:48.349 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-11-20 00:28:48.589 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-20 00:28:48.590 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 00:28:48.590 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 00:28:48.590 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-20 00:28:48.590 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 247.6541ms 2025-11-20 00:28:48.604 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [n].[Id], [n].[Descripcion], [n].[Estatus], [n].[Gentilicio], [n].[Siglas] FROM [Nationalities] AS [n] 2025-11-20 00:28:48.604 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 00:28:48.604 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 00:28:48.605 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities' 2025-11-20 00:28:48.605 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 262.3322ms 2025-11-20 00:28:48.608 +00:00 [INF] Executed DbCommand (10ms) [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-20 00:28:48.608 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 00:28:48.608 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 00:28:48.609 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-11-20 00:28:48.609 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 262.2378ms 2025-11-20 00:28:48.613 +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-20 00:28:48.614 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 00:28:48.614 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-11-20 00:28:48.614 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-11-20 00:28:48.614 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 266.3403ms 2025-11-20 00:28:52.018 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/sara - null null 2025-11-20 00:28:52.018 +00:00 [INF] CORS policy execution successful. 2025-11-20 00:28:52.018 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/sara - 204 null null 0.6019ms 2025-11-20 00:28:52.078 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/sara - null null 2025-11-20 00:28:52.078 +00:00 [INF] CORS policy execution successful. 2025-11-20 00:28:52.078 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 00:28:52.081 +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-20 00:28:52.083 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 00:28:52.083 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 00:28:52.084 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 00:28:52.084 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/sara - 200 null application/json; charset=utf-8 5.6574ms 2025-11-20 00:29:26.420 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null 2025-11-20 00:29:26.420 +00:00 [INF] CORS policy execution successful. 2025-11-20 00:29:26.420 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.2385ms 2025-11-20 00:29:26.478 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182 2025-11-20 00:29:26.478 +00:00 [INF] CORS policy execution successful. 2025-11-20 00:29:26.479 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd' 2025-11-20 00:29:26.483 +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-20 00:29:26.487 +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-20 00:29:26.487 +00:00 [INF] Setting HTTP status code 201. 2025-11-20 00:29:26.487 +00:00 [INF] Writing value of type 'Int64' as Json. 2025-11-20 00:29:26.487 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd' 2025-11-20 00:29:26.487 +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.9324ms 2025-11-20 00:29:26.548 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40971 - null null 2025-11-20 00:29:26.548 +00:00 [INF] CORS policy execution successful. 2025-11-20 00:29:26.548 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40971 - 204 null null 0.3152ms 2025-11-20 00:29:26.550 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-20 00:29:26.550 +00:00 [INF] CORS policy execution successful. 2025-11-20 00:29:26.550 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.1425ms 2025-11-20 00:29:26.604 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40971 - application/json 105 2025-11-20 00:29:26.604 +00:00 [INF] CORS policy execution successful. 2025-11-20 00:29:26.605 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-20 00:29:26.606 +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-20 00:29:26.610 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-20 00:29:26.610 +00:00 [INF] CORS policy execution successful. 2025-11-20 00:29:26.610 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-20 00:29:26.612 +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-20 00:29:26.612 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 00:29:26.612 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 00:29:26.612 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-20 00:29:26.612 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 2.4435ms 2025-11-20 00:29:26.758 +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-20 00:29:26.760 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (DbType = Guid), @p25='?' (DbType = DateTime2), @p26='?' (DbType = Boolean), @p27='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p28='?' (DbType = Int32), @p29='?' (DbType = Int32), @p30='?' (DbType = Int64), @p31='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p32='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p33='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p34='?' (DbType = Guid), @p35='?' (DbType = DateTime2), @p36='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p37='?' (DbType = Guid), @p38='?' (DbType = DateTime2), @p39='?' (DbType = Int32), @p40='?' (Size = 34), @p41='?' (DbType = Guid), @p42='?' (DbType = Int32), @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?' (Size = 4000), @p46='?' (Size = 4000), @p47='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21 OUTPUT 1 WHERE [Id] = @p22; INSERT INTO [SalesDetail] ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate]) OUTPUT INSERTED.[Id] VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35); INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice]) OUTPUT INSERTED.[Id] VALUES (@p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47); 2025-11-20 00:29:26.764 +00:00 [INF] Setting HTTP status code 201. 2025-11-20 00:29:26.764 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-20 00:29:26.764 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40971 - 201 0 null 160.4232ms 2025-11-20 05:41:47.301 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null 2025-11-20 05:41:47.302 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.9412ms 2025-11-20 05:41:47.302 +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-20 05:42:00.339 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null 2025-11-20 05:42:00.340 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.2245ms 2025-11-20 05:42:00.340 +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-20 05:42:21.117 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/wiki - null null 2025-11-20 05:42:21.117 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/wiki - 404 0 null 0.2474ms 2025-11-20 05:42:21.117 +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-20 06:00:42.500 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ - null null 2025-11-20 06:00:42.500 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ - 404 0 null 0.3117ms 2025-11-20 06:00:42.501 +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-20 06:01:16.491 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/sitemap.xml - null null 2025-11-20 06:01:16.492 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/sitemap.xml - 404 0 null 0.274ms 2025-11-20 06:01:16.492 +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/sitemap.xml, Response status code: 404 2025-11-20 07:04:26.814 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33/ - null null 2025-11-20 07:04:26.814 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33/ - 404 0 null 0.6593ms 2025-11-20 07:04:26.814 +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-20 07:04:27.686 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/favicon.ico - null null 2025-11-20 07:04:27.687 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/favicon.ico - 404 0 null 0.3158ms 2025-11-20 07:04:27.687 +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-20 12:24:59.909 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null 2025-11-20 12:24:59.910 +00:00 [INF] CORS policy execution successful. 2025-11-20 12:24:59.910 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.9846ms 2025-11-20 12:24:59.966 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 65 2025-11-20 12:24:59.966 +00:00 [INF] CORS policy execution successful. 2025-11-20 12:24:59.966 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin' 2025-11-20 12:25:00.295 +00:00 [INF] Executed DbCommand (19ms) [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-20 12:25:00.423 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__userId_0='?' (Size = 450)], CommandType='"Text"', CommandTimeout='30'] SELECT [a0].[Name] FROM [AspNetUserRoles] AS [a] INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id] WHERE [a].[UserId] = @__userId_0 2025-11-20 12:25:00.425 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 12:25:00.425 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json. 2025-11-20 12:25:00.425 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin' 2025-11-20 12:25:00.426 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 460.1705ms 2025-11-20 13:42:49.365 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-20 13:42:49.365 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-11-20 13:42:49.365 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:42:49.365 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.3433ms 2025-11-20 13:42:49.366 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-11-20 13:42:49.366 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:42:49.366 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.1946ms 2025-11-20 13:42:49.365 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:42:49.366 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 1.1076ms 2025-11-20 13:42:49.371 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null 2025-11-20 13:42:49.371 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:42:49.371 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.2259ms 2025-11-20 13:42:49.429 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-20 13:42:49.429 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:42:49.430 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-20 13:42:49.431 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-11-20 13:42:49.431 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:42:49.431 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-11-20 13:42:49.436 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-11-20 13:42:49.437 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:42:49.437 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-11-20 13:42:49.438 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null 2025-11-20 13:42:49.438 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:42:49.441 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities' 2025-11-20 13:42:49.678 +00:00 [INF] Executed DbCommand (10ms) [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-20 13:42:49.679 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 13:42:49.679 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 13:42:49.679 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-20 13:42:49.679 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 250.1691ms 2025-11-20 13:42:49.685 +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-20 13:42:49.685 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 13:42:49.685 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [s].[Id], [s].[AdminPassword], [s].[Discount], [s].[EmploymentDiscount], [s].[ExpirationDateAlert], [s].[ProductExpiredDiscount], [s].[UpdatedById], [s].[UpdatedDate] FROM [Settings] AS [s] 2025-11-20 13:42:49.685 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 13:42:49.685 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-11-20 13:42:49.685 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 13:42:49.685 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 249.2474ms 2025-11-20 13:42:49.685 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-11-20 13:42:49.686 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-11-20 13:42:49.687 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 256.0324ms 2025-11-20 13:42:49.697 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [n].[Id], [n].[Descripcion], [n].[Estatus], [n].[Gentilicio], [n].[Siglas] FROM [Nationalities] AS [n] 2025-11-20 13:42:49.699 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 13:42:49.699 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 13:42:49.700 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities' 2025-11-20 13:42:49.700 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 261.7936ms 2025-11-20 13:42:52.556 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/mary - null null 2025-11-20 13:42:52.556 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:42:52.556 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/mary - 204 null null 0.2764ms 2025-11-20 13:42:52.617 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/mary - null null 2025-11-20 13:42:52.617 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:42:52.618 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 13:42:52.626 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-20 13:42:52.628 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 13:42:52.628 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 13:42:52.628 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 13:42:52.628 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/mary - 200 null application/json; charset=utf-8 11.0755ms 2025-11-20 13:55:10.097 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null 2025-11-20 13:55:10.098 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:55:10.099 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 1.4287ms 2025-11-20 13:55:10.178 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 58 2025-11-20 13:55:10.178 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:55:10.178 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin' 2025-11-20 13:55:10.479 +00:00 [INF] Executed DbCommand (14ms) [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-20 13:55:10.671 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__userId_0='?' (Size = 450)], CommandType='"Text"', CommandTimeout='30'] SELECT [a0].[Name] FROM [AspNetUserRoles] AS [a] INNER JOIN [AspNetRoles] AS [a0] ON [a].[RoleId] = [a0].[Id] WHERE [a].[UserId] = @__userId_0 2025-11-20 13:55:10.673 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 13:55:10.673 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json. 2025-11-20 13:55:10.674 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin' 2025-11-20 13:55:10.674 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 496.4973ms 2025-11-20 13:56:03.264 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - null null 2025-11-20 13:56:03.264 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:56:03.264 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - 204 null null 0.2988ms 2025-11-20 13:56:03.326 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - null null 2025-11-20 13:56:03.327 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:56:03.328 +00:00 [INF] Executing endpoint 'HTTP: GET InventoryReplenishment/' 2025-11-20 13:56:03.354 +00:00 [INF] Executed DbCommand (8ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [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-20 13:56:03.506 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 13:56:03.506 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 13:56:03.507 +00:00 [INF] Executed endpoint 'HTTP: GET InventoryReplenishment/' 2025-11-20 13:56:03.507 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - 200 null application/json; charset=utf-8 180.9043ms 2025-11-20 13:57:26.083 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - null null 2025-11-20 13:57:26.083 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:57:26.083 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - 204 null null 0.337ms 2025-11-20 13:57:26.143 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - application/json 40 2025-11-20 13:57:26.143 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:57:26.143 +00:00 [INF] Executing endpoint 'HTTP: POST InventoryReplenishment/createInvRepHD' 2025-11-20 13:57:26.150 +00:00 [INF] Executed DbCommand (5ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); 2025-11-20 13:57:26.151 +00:00 [INF] Setting HTTP status code 201. 2025-11-20 13:57:26.151 +00:00 [INF] Writing value of type 'Guid' as Json. 2025-11-20 13:57:26.151 +00:00 [INF] Executed endpoint 'HTTP: POST InventoryReplenishment/createInvRepHD' 2025-11-20 13:57:26.152 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - 201 null application/json; charset=utf-8 9.2208ms 2025-11-20 13:57:26.213 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - null null 2025-11-20 13:57:26.213 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:57:26.214 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - 204 null null 1.0197ms 2025-11-20 13:57:26.274 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - application/json 653 2025-11-20 13:57:26.274 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:57:26.275 +00:00 [INF] Executing endpoint 'HTTP: POST InventoryReplenishment/createInvRepDet' 2025-11-20 13:57:26.280 +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-20 13:57:26.483 +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-20 13:57:26.485 +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-20 13:57:26.487 +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-20 13:57:26.541 +00:00 [INF] Executed DbCommand (52ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Int32), @p4='?' (Size = 34), @p5='?' (DbType = Guid), @p6='?' (DbType = Int32), @p7='?' (DbType = Int32), @p8='?' (DbType = Int32), @p9='?' (Size = 4000), @p10='?' (Size = 4000), @p11='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p12='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p13='?' (DbType = Guid), @p14='?' (DbType = DateTime2), @p15='?' (DbType = Int32), @p16='?' (Size = 34), @p17='?' (DbType = Guid), @p18='?' (DbType = Int32), @p19='?' (DbType = Int32), @p20='?' (DbType = Int32), @p21='?' (Size = 4000), @p22='?' (Size = 4000), @p23='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Guid), @p26='?' (DbType = DateTime2), @p27='?' (DbType = Int32), @p28='?' (Size = 34), @p29='?' (DbType = Guid), @p30='?' (DbType = Int32), @p31='?' (DbType = Int32), @p32='?' (DbType = Int32), @p33='?' (Size = 4000), @p34='?' (Size = 4000), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p53='?' (DbType = Int32), @p36='?' (Size = 4000), @p37='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p38='?' (DbType = Int32), @p39='?' (DbType = Guid), @p40='?' (DbType = DateTime2), @p41='?' (DbType = Boolean), @p42='?' (DbType = DateTime2), @p43='?' (DbType = Int32), @p44='?' (Size = 150), @p45='?' (Size = 500), @p46='?' (Size = -1) (DbType = Binary), @p47='?' (DbType = Int32), @p48='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p49='?' (Size = 4000), @p50='?' (DbType = Int32), @p51='?' (DbType = Guid), @p52='?' (DbType = DateTime2), @p71='?' (DbType = Int32), @p54='?' (Size = 4000), @p55='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p56='?' (DbType = Int32), @p57='?' (DbType = Guid), @p58='?' (DbType = DateTime2), @p59='?' (DbType = Boolean), @p60='?' (DbType = DateTime2), @p61='?' (DbType = Int32), @p62='?' (Size = 150), @p63='?' (Size = 500), @p64='?' (Size = -1) (DbType = Binary), @p65='?' (DbType = Int32), @p66='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p67='?' (Size = 4000), @p68='?' (DbType = Int32), @p69='?' (DbType = Guid), @p70='?' (DbType = DateTime2), @p89='?' (DbType = Int32), @p72='?' (Size = 4000), @p73='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p74='?' (DbType = Int32), @p75='?' (DbType = Guid), @p76='?' (DbType = DateTime2), @p77='?' (DbType = Boolean), @p78='?' (DbType = DateTime2), @p79='?' (DbType = Int32), @p80='?' (Size = 150), @p81='?' (Size = 500), @p82='?' (Size = -1) (DbType = Binary), @p83='?' (DbType = Int32), @p84='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p85='?' (Size = 4000), @p86='?' (DbType = Int32), @p87='?' (DbType = Guid), @p88='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; MERGE [InventoryMovements] USING ( VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, 0), (@p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, 1), (@p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35, 2)) 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] = @p36, [BuyPrice] = @p37, [CategoryId] = @p38, [CreatedById] = @p39, [CreatedDate] = @p40, [DeleteFlag] = @p41, [ExpirationDate] = @p42, [MinimunStock] = @p43, [Name] = @p44, [Note] = @p45, [ProductImage] = @p46, [ProductTaxId] = @p47, [SalePrice] = @p48, [Status] = @p49, [Stock] = @p50, [UpdatedById] = @p51, [UpdatedDate] = @p52 OUTPUT 1 WHERE [Id] = @p53; UPDATE [Products] SET [BarCode] = @p54, [BuyPrice] = @p55, [CategoryId] = @p56, [CreatedById] = @p57, [CreatedDate] = @p58, [DeleteFlag] = @p59, [ExpirationDate] = @p60, [MinimunStock] = @p61, [Name] = @p62, [Note] = @p63, [ProductImage] = @p64, [ProductTaxId] = @p65, [SalePrice] = @p66, [Status] = @p67, [Stock] = @p68, [UpdatedById] = @p69, [UpdatedDate] = @p70 OUTPUT 1 WHERE [Id] = @p71; UPDATE [Products] SET [BarCode] = @p72, [BuyPrice] = @p73, [CategoryId] = @p74, [CreatedById] = @p75, [CreatedDate] = @p76, [DeleteFlag] = @p77, [ExpirationDate] = @p78, [MinimunStock] = @p79, [Name] = @p80, [Note] = @p81, [ProductImage] = @p82, [ProductTaxId] = @p83, [SalePrice] = @p84, [Status] = @p85, [Stock] = @p86, [UpdatedById] = @p87, [UpdatedDate] = @p88 OUTPUT 1 WHERE [Id] = @p89; 2025-11-20 13:57:26.546 +00:00 [INF] Setting HTTP status code 201. 2025-11-20 13:57:26.547 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 13:57:26.547 +00:00 [INF] Executed endpoint 'HTTP: POST InventoryReplenishment/createInvRepDet' 2025-11-20 13:57:26.547 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - 201 null application/json; charset=utf-8 273.7276ms 2025-11-20 13:57:26.608 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - null null 2025-11-20 13:57:26.608 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:57:26.608 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - 204 null null 0.3101ms 2025-11-20 13:57:26.669 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - null null 2025-11-20 13:57:26.670 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:57:26.670 +00:00 [INF] Executing endpoint 'HTTP: GET InventoryReplenishment/' 2025-11-20 13:57:26.674 +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-20 13:57:26.815 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 13:57:26.815 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 13:57:26.817 +00:00 [INF] Executed endpoint 'HTTP: GET InventoryReplenishment/' 2025-11-20 13:57:26.817 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - 200 null application/json; charset=utf-8 147.7928ms 2025-11-20 13:57:38.140 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-11-20 13:57:38.140 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:57:38.140 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.2982ms 2025-11-20 13:57:38.184 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-11-20 13:57:38.184 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:57:38.184 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.2423ms 2025-11-20 13:57:38.189 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - null null 2025-11-20 13:57:38.189 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:57:38.189 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - 204 null null 0.2574ms 2025-11-20 13:57:38.199 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-11-20 13:57:38.199 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:57:38.200 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-11-20 13:57:38.202 +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-20 13:57:38.202 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 13:57:38.202 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-11-20 13:57:38.202 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-11-20 13:57:38.202 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 3.2024ms 2025-11-20 13:57:38.236 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-11-20 13:57:38.236 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:57:38.237 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-11-20 13:57:38.239 +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-20 13:57:38.239 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 13:57:38.239 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 13:57:38.239 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-11-20 13:57:38.239 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 2.8334ms 2025-11-20 13:57:38.244 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Products - null null 2025-11-20 13:57:38.244 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:57:38.245 +00:00 [INF] Executing endpoint 'HTTP: GET /products' 2025-11-20 13:57:38.249 +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-20 13:57:38.455 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 13:57:38.455 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 13:57:39.747 +00:00 [INF] Executed endpoint 'HTTP: GET /products' 2025-11-20 13:57:39.747 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Products - 200 null application/json; charset=utf-8 1503.0117ms 2025-11-20 13:58:03.333 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-11-20 13:58:03.334 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:58:03.334 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.3502ms 2025-11-20 13:58:03.334 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductCategory - null null 2025-11-20 13:58:03.334 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:58:03.334 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductCategory - 204 null null 0.0833ms 2025-11-20 13:58:03.341 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/4610 - null null 2025-11-20 13:58:03.342 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:58:03.342 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/4610 - 204 null null 0.575ms 2025-11-20 13:58:03.385 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductCategory - null null 2025-11-20 13:58:03.386 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:58:03.386 +00:00 [INF] Executing endpoint 'HTTP: GET ProductCategory/' 2025-11-20 13:58:03.388 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[Description], [p].[UpdatedById], [p].[UpdatedDate] FROM [ProductCategories] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-20 13:58:03.389 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 13:58:03.389 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 13:58:03.389 +00:00 [INF] Executed endpoint 'HTTP: GET ProductCategory/' 2025-11-20 13:58:03.389 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductCategory - 200 null application/json; charset=utf-8 3.6752ms 2025-11-20 13:58:03.389 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-11-20 13:58:03.389 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:58:03.391 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-11-20 13:58:03.393 +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-20 13:58:03.393 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 13:58:03.393 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 13:58:03.393 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-11-20 13:58:03.393 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 3.8393ms 2025-11-20 13:58:03.401 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/4610 - null null 2025-11-20 13:58:03.402 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:58:03.402 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}' 2025-11-20 13:58:03.404 +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-20 13:58:03.404 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 13:58:03.405 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json. 2025-11-20 13:58:03.405 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}' 2025-11-20 13:58:03.405 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/4610 - 200 null application/json; charset=utf-8 3.329ms 2025-11-20 13:58:22.648 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/4610 - null null 2025-11-20 13:58:22.648 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:58:22.648 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/4610 - 204 null null 0.2672ms 2025-11-20 13:58:22.711 +00:00 [INF] Request starting HTTP/1.1 PUT http://159.89.226.33:5227/products/4610 - application/json 23639 2025-11-20 13:58:22.711 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:58:22.711 +00:00 [INF] Executing endpoint 'HTTP: PUT Products/{id}' 2025-11-20 13:58:22.770 +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-20 13:58:22.775 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p17='?' (DbType = Int32), @p0='?' (Size = 4000), @p1='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p2='?' (DbType = Int32), @p3='?' (DbType = Guid), @p4='?' (DbType = DateTime2), @p5='?' (DbType = Boolean), @p6='?' (DbType = DateTime2), @p7='?' (DbType = Int32), @p8='?' (Size = 150), @p9='?' (Size = 500), @p10='?' (Size = -1) (DbType = Binary), @p11='?' (DbType = Int32), @p12='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p13='?' (Size = 4000), @p14='?' (DbType = Int32), @p15='?' (DbType = Guid), @p16='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; UPDATE [Products] SET [BarCode] = @p0, [BuyPrice] = @p1, [CategoryId] = @p2, [CreatedById] = @p3, [CreatedDate] = @p4, [DeleteFlag] = @p5, [ExpirationDate] = @p6, [MinimunStock] = @p7, [Name] = @p8, [Note] = @p9, [ProductImage] = @p10, [ProductTaxId] = @p11, [SalePrice] = @p12, [Status] = @p13, [Stock] = @p14, [UpdatedById] = @p15, [UpdatedDate] = @p16 OUTPUT 1 WHERE [Id] = @p17; 2025-11-20 13:58:22.775 +00:00 [INF] Setting HTTP status code 204. 2025-11-20 13:58:22.775 +00:00 [INF] Executed endpoint 'HTTP: PUT Products/{id}' 2025-11-20 13:58:22.776 +00:00 [INF] Request finished HTTP/1.1 PUT http://159.89.226.33:5227/products/4610 - 204 null null 64.9709ms 2025-11-20 13:58:24.832 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-11-20 13:58:24.832 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:58:24.833 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.9849ms 2025-11-20 13:58:24.833 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - null null 2025-11-20 13:58:24.833 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:58:24.833 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Products - 204 null null 0.4278ms 2025-11-20 13:58:24.840 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-11-20 13:58:24.840 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:58:24.840 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.2661ms 2025-11-20 13:58:24.885 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Products - null null 2025-11-20 13:58:24.886 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:58:24.886 +00:00 [INF] Executing endpoint 'HTTP: GET /products' 2025-11-20 13:58:24.889 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-11-20 13:58:24.889 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:58:24.889 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-11-20 13:58:24.891 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [t].[Id], [t].[CreatedById], [t].[CreatedDate], [t].[DeleteFlag], [t].[Description], [t].[UpdatedById], [t].[UpdatedDate], [t0].[Id], [t0].[CreatedById], [t0].[CreatedDate], [t0].[DeleteFlag], [t0].[Percentage], [t0].[TaxDescription], [t0].[UpdatedById], [t0].[UpdatedDate] FROM [Products] AS [p] INNER JOIN ( SELECT [p0].[Id], [p0].[CreatedById], [p0].[CreatedDate], [p0].[DeleteFlag], [p0].[Description], [p0].[UpdatedById], [p0].[UpdatedDate] FROM [ProductCategories] AS [p0] WHERE [p0].[DeleteFlag] = CAST(0 AS bit) ) AS [t] ON [p].[CategoryId] = [t].[Id] INNER JOIN ( SELECT [p1].[Id], [p1].[CreatedById], [p1].[CreatedDate], [p1].[DeleteFlag], [p1].[Percentage], [p1].[TaxDescription], [p1].[UpdatedById], [p1].[UpdatedDate] FROM [ProductTaxes] AS [p1] WHERE [p1].[DeleteFlag] = CAST(0 AS bit) ) AS [t0] ON [p].[ProductTaxId] = [t0].[Id] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-20 13:58:24.901 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-11-20 13:58:24.901 +00:00 [INF] CORS policy execution successful. 2025-11-20 13:58:24.901 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-11-20 13:58:24.911 +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-20 13:58:24.912 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 13:58:24.913 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 13:58:24.913 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-11-20 13:58:24.913 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 24.5993ms 2025-11-20 13:58:24.926 +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-20 13:58:24.932 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 13:58:24.932 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-11-20 13:58:24.933 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-11-20 13:58:24.933 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 32.3175ms 2025-11-20 13:58:25.062 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 13:58:25.062 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 13:58:25.632 +00:00 [INF] Executed endpoint 'HTTP: GET /products' 2025-11-20 13:58:25.632 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Products - 200 null application/json; charset=utf-8 747.1935ms 2025-11-20 15:03:37.934 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null 2025-11-20 15:03:37.935 +00:00 [INF] CORS policy execution successful. 2025-11-20 15:03:37.935 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 1.3955ms 2025-11-20 15:03:38.006 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 58 2025-11-20 15:03:38.006 +00:00 [INF] CORS policy execution successful. 2025-11-20 15:03:38.007 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin' 2025-11-20 15:03:38.320 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName] FROM [AspNetUsers] AS [a] WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0 2025-11-20 15:03:38.484 +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-20 15:03:38.485 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 15:03:38.486 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json. 2025-11-20 15:03:38.486 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin' 2025-11-20 15:03:38.486 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 480.5555ms 2025-11-20 15:03:48.406 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - null null 2025-11-20 15:03:48.407 +00:00 [INF] CORS policy execution successful. 2025-11-20 15:03:48.408 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - 204 null null 1.5956ms 2025-11-20 15:03:48.476 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - null null 2025-11-20 15:03:48.476 +00:00 [INF] CORS policy execution successful. 2025-11-20 15:03:48.476 +00:00 [INF] Executing endpoint 'HTTP: GET InventoryReplenishment/' 2025-11-20 15:03:48.499 +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-20 15:03:48.640 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 15:03:48.640 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 15:03:48.641 +00:00 [INF] Executed endpoint 'HTTP: GET InventoryReplenishment/' 2025-11-20 15:03:48.642 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - 200 null application/json; charset=utf-8 165.8473ms 2025-11-20 15:04:13.589 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - null null 2025-11-20 15:04:13.589 +00:00 [INF] CORS policy execution successful. 2025-11-20 15:04:13.590 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - 204 null null 0.3561ms 2025-11-20 15:04:13.658 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - application/json 55 2025-11-20 15:04:13.659 +00:00 [INF] CORS policy execution successful. 2025-11-20 15:04:13.659 +00:00 [INF] Executing endpoint 'HTTP: POST InventoryReplenishment/createInvRepHD' 2025-11-20 15:04:13.663 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); 2025-11-20 15:04:13.664 +00:00 [INF] Setting HTTP status code 201. 2025-11-20 15:04:13.664 +00:00 [INF] Writing value of type 'Guid' as Json. 2025-11-20 15:04:13.664 +00:00 [INF] Executed endpoint 'HTTP: POST InventoryReplenishment/createInvRepHD' 2025-11-20 15:04:13.664 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepHD - 201 null application/json; charset=utf-8 5.5675ms 2025-11-20 15:04:13.733 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - null null 2025-11-20 15:04:13.734 +00:00 [INF] CORS policy execution successful. 2025-11-20 15:04:13.734 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - 204 null null 0.2792ms 2025-11-20 15:04:13.802 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - application/json 226 2025-11-20 15:04:13.802 +00:00 [INF] CORS policy execution successful. 2025-11-20 15:04:13.803 +00:00 [INF] Executing endpoint 'HTTP: POST InventoryReplenishment/createInvRepDet' 2025-11-20 15:04:13.812 +00:00 [INF] Executed DbCommand (8ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [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-20 15:04:14.045 +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-20 15:04:14.049 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@p0='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Int32), @p4='?' (Size = 34), @p5='?' (DbType = Guid), @p6='?' (DbType = Int32), @p7='?' (DbType = Int32), @p8='?' (DbType = Int32), @p9='?' (Size = 4000), @p10='?' (Size = 4000), @p11='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p29='?' (DbType = Int32), @p12='?' (Size = 4000), @p13='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p14='?' (DbType = Int32), @p15='?' (DbType = Guid), @p16='?' (DbType = DateTime2), @p17='?' (DbType = Boolean), @p18='?' (DbType = DateTime2), @p19='?' (DbType = Int32), @p20='?' (Size = 150), @p21='?' (Size = 500), @p22='?' (Size = -1) (DbType = Binary), @p23='?' (DbType = Int32), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (Size = 4000), @p26='?' (DbType = Int32), @p27='?' (DbType = Guid), @p28='?' (DbType = DateTime2)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [InventoryMovements] ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11); UPDATE [Products] SET [BarCode] = @p12, [BuyPrice] = @p13, [CategoryId] = @p14, [CreatedById] = @p15, [CreatedDate] = @p16, [DeleteFlag] = @p17, [ExpirationDate] = @p18, [MinimunStock] = @p19, [Name] = @p20, [Note] = @p21, [ProductImage] = @p22, [ProductTaxId] = @p23, [SalePrice] = @p24, [Status] = @p25, [Stock] = @p26, [UpdatedById] = @p27, [UpdatedDate] = @p28 OUTPUT 1 WHERE [Id] = @p29; 2025-11-20 15:04:14.052 +00:00 [INF] Setting HTTP status code 201. 2025-11-20 15:04:14.053 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 15:04:14.053 +00:00 [INF] Executed endpoint 'HTTP: POST InventoryReplenishment/createInvRepDet' 2025-11-20 15:04:14.053 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/InventoryReplenishment/createInvRepDet - 201 null application/json; charset=utf-8 250.8777ms 2025-11-20 15:04:14.124 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - null null 2025-11-20 15:04:14.125 +00:00 [INF] CORS policy execution successful. 2025-11-20 15:04:14.125 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/InventoryReplenishment - 204 null null 0.8295ms 2025-11-20 15:04:14.194 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - null null 2025-11-20 15:04:14.194 +00:00 [INF] CORS policy execution successful. 2025-11-20 15:04:14.195 +00:00 [INF] Executing endpoint 'HTTP: GET InventoryReplenishment/' 2025-11-20 15:04:14.200 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate], [t].[Id], [t].[CreatedById], [t].[CreatedDate], [t].[DeleteFlag], [t].[Description], [t].[UpdatedById], [t].[UpdatedDate], [t0].[Id], [t0].[CreatedById], [t0].[CreatedDate], [t0].[DeleteFlag], [t0].[Percentage], [t0].[TaxDescription], [t0].[UpdatedById], [t0].[UpdatedDate] FROM [Products] AS [p] INNER JOIN ( SELECT [p0].[Id], [p0].[CreatedById], [p0].[CreatedDate], [p0].[DeleteFlag], [p0].[Description], [p0].[UpdatedById], [p0].[UpdatedDate] FROM [ProductCategories] AS [p0] WHERE [p0].[DeleteFlag] = CAST(0 AS bit) ) AS [t] ON [p].[CategoryId] = [t].[Id] INNER JOIN ( SELECT [p1].[Id], [p1].[CreatedById], [p1].[CreatedDate], [p1].[DeleteFlag], [p1].[Percentage], [p1].[TaxDescription], [p1].[UpdatedById], [p1].[UpdatedDate] FROM [ProductTaxes] AS [p1] WHERE [p1].[DeleteFlag] = CAST(0 AS bit) ) AS [t0] ON [p].[ProductTaxId] = [t0].[Id] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 3) 2025-11-20 15:04:14.334 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 15:04:14.334 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 15:04:14.336 +00:00 [INF] Executed endpoint 'HTTP: GET InventoryReplenishment/' 2025-11-20 15:04:14.337 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/InventoryReplenishment - 200 null application/json; charset=utf-8 143.3691ms 2025-11-20 19:25:15.583 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-20 19:25:15.584 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:25:15.584 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2819ms 2025-11-20 19:25:15.644 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-20 19:25:15.644 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:25:15.644 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-20 19:25:15.924 +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-20 19:25:15.925 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 19:25:15.925 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 19:25:15.925 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-20 19:25:15.925 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 281.2939ms 2025-11-20 19:25:23.222 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/arabje - null null 2025-11-20 19:25:23.222 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:25:23.222 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/arabje - 204 null null 0.321ms 2025-11-20 19:25:23.282 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/arabje - null null 2025-11-20 19:25:23.282 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:25:23.282 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 19:25:23.288 +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-20 19:25:23.288 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 19:25:23.288 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 19:25:23.288 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 19:25:23.289 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/arabje - 200 null application/json; charset=utf-8 6.8974ms 2025-11-20 19:25:29.061 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/arbaje - null null 2025-11-20 19:25:29.061 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:25:29.062 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/arbaje - 204 null null 0.8698ms 2025-11-20 19:25:29.130 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/arbaje - null null 2025-11-20 19:25:29.130 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:25:29.131 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 19:25:29.134 +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-20 19:25:29.142 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 19:25:29.142 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 19:25:29.310 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 19:25:29.310 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/arbaje - 200 null application/json; charset=utf-8 180.3012ms 2025-11-20 19:26:40.742 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan de - null null 2025-11-20 19:26:40.742 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:26:40.742 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/pan de - 204 null null 0.3603ms 2025-11-20 19:26:40.799 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan de - null null 2025-11-20 19:26:40.800 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:26:40.800 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 19:26:40.805 +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-20 19:26:40.808 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 19:26:40.808 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 19:26:40.808 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 19:26:40.808 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/pan de - 200 null application/json; charset=utf-8 8.7702ms 2025-11-20 19:27:26.165 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null 2025-11-20 19:27:26.165 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:27:26.166 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.2629ms 2025-11-20 19:27:26.225 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 191 2025-11-20 19:27:26.225 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:27:26.226 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd' 2025-11-20 19:27:26.230 +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-20 19:27:26.234 +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-20 19:27:26.235 +00:00 [INF] Setting HTTP status code 201. 2025-11-20 19:27:26.235 +00:00 [INF] Writing value of type 'Int64' as Json. 2025-11-20 19:27:26.235 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd' 2025-11-20 19:27:26.235 +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.1469ms 2025-11-20 19:27:26.295 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40972 - null null 2025-11-20 19:27:26.295 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:27:26.295 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40972 - 204 null null 0.6841ms 2025-11-20 19:27:26.353 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-20 19:27:26.353 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:27:26.353 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.7487ms 2025-11-20 19:27:26.366 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40972 - application/json 215 2025-11-20 19:27:26.366 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:27:26.367 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-20 19:27:26.368 +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-20 19:27:26.423 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-20 19:27:26.423 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:27:26.424 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-20 19:27:26.437 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-20 19:27:26.438 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 19:27:26.438 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 19:27:26.439 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-20 19:27:26.439 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 15.8994ms 2025-11-20 19:27:26.575 +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-20 19:27:26.580 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p40='?' (DbType = Int32), @p23='?' (Size = 4000), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Int32), @p26='?' (DbType = Guid), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Boolean), @p29='?' (DbType = DateTime2), @p30='?' (DbType = Int32), @p31='?' (Size = 150), @p32='?' (Size = 500), @p33='?' (Size = -1) (DbType = Binary), @p34='?' (DbType = Int32), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p36='?' (Size = 4000), @p37='?' (DbType = Int32), @p38='?' (DbType = Guid), @p39='?' (DbType = DateTime2), @p41='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p42='?' (DbType = Guid), @p43='?' (DbType = DateTime2), @p44='?' (DbType = Boolean), @p45='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p46='?' (DbType = Int32), @p47='?' (DbType = Int32), @p48='?' (DbType = Int64), @p49='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p50='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p51='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p52='?' (DbType = Guid), @p53='?' (DbType = DateTime2), @p54='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p55='?' (DbType = Guid), @p56='?' (DbType = DateTime2), @p57='?' (DbType = Boolean), @p58='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p59='?' (DbType = Int32), @p60='?' (DbType = Int32), @p61='?' (DbType = Int64), @p62='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p63='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p64='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p65='?' (DbType = Guid), @p66='?' (DbType = DateTime2), @p67='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p68='?' (DbType = Guid), @p69='?' (DbType = DateTime2), @p70='?' (DbType = Int32), @p71='?' (Size = 34), @p72='?' (DbType = Guid), @p73='?' (DbType = Int32), @p74='?' (DbType = Int32), @p75='?' (DbType = Int32), @p76='?' (Size = 4000), @p77='?' (Size = 4000), @p78='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p79='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p80='?' (DbType = Guid), @p81='?' (DbType = DateTime2), @p82='?' (DbType = Int32), @p83='?' (Size = 34), @p84='?' (DbType = Guid), @p85='?' (DbType = Int32), @p86='?' (DbType = Int32), @p87='?' (DbType = Int32), @p88='?' (Size = 4000), @p89='?' (Size = 4000), @p90='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21 OUTPUT 1 WHERE [Id] = @p22; UPDATE [Products] SET [BarCode] = @p23, [BuyPrice] = @p24, [CategoryId] = @p25, [CreatedById] = @p26, [CreatedDate] = @p27, [DeleteFlag] = @p28, [ExpirationDate] = @p29, [MinimunStock] = @p30, [Name] = @p31, [Note] = @p32, [ProductImage] = @p33, [ProductTaxId] = @p34, [SalePrice] = @p35, [Status] = @p36, [Stock] = @p37, [UpdatedById] = @p38, [UpdatedDate] = @p39 OUTPUT 1 WHERE [Id] = @p40; MERGE [SalesDetail] USING ( VALUES (@p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52, @p53, 0), (@p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62, @p63, @p64, @p65, @p66, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate], _Position) ON 1=0 WHEN NOT MATCHED THEN INSERT ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate]) VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[DeleteFlag], i.[DiscountAmount], i.[ProductId], i.[Quantity], i.[SalesId], i.[Tax], i.[Total], i.[UnitPrice], i.[UpdatedById], i.[UpdatedDate]) OUTPUT INSERTED.[Id], i._Position; MERGE [InventoryMovements] USING ( VALUES (@p67, @p68, @p69, @p70, @p71, @p72, @p73, @p74, @p75, @p76, @p77, @p78, 0), (@p79, @p80, @p81, @p82, @p83, @p84, @p85, @p86, @p87, @p88, @p89, @p90, 1)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice], _Position) ON 1=0 WHEN NOT MATCHED THEN INSERT ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice]) VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[Difference], i.[Discriminator], i.[InventoryMovementHeaderId], i.[NewStock], i.[OriginaStock], i.[ProductId], i.[ProductName], i.[Reazon], i.[SalePrice]) OUTPUT INSERTED.[Id], i._Position; 2025-11-20 19:27:26.584 +00:00 [INF] Setting HTTP status code 201. 2025-11-20 19:27:26.584 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-20 19:27:26.584 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40972 - 201 0 null 217.977ms 2025-11-20 19:49:48.515 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/omega - null null 2025-11-20 19:49:48.515 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:49:48.516 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/omega - 204 null null 0.3432ms 2025-11-20 19:49:48.578 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/omega - null null 2025-11-20 19:49:48.578 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:49:48.579 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 19:49:48.833 +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-20 19:49:48.839 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 19:49:48.839 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 19:49:48.955 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 19:49:48.955 +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 377.2981ms 2025-11-20 19:50:04.176 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/mile - null null 2025-11-20 19:50:04.176 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:50:04.176 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/mile - 204 null null 0.2532ms 2025-11-20 19:50:04.240 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/mile - null null 2025-11-20 19:50:04.240 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:50:04.241 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 19:50:04.246 +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-20 19:50:04.246 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 19:50:04.246 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 19:50:04.246 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 19:50:04.246 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/mile - 200 null application/json; charset=utf-8 5.7738ms 2025-11-20 19:50:08.381 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/miel - null null 2025-11-20 19:50:08.381 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:50:08.381 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/miel - 204 null null 0.2163ms 2025-11-20 19:50:08.441 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/miel - null null 2025-11-20 19:50:08.441 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:50:08.441 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 19:50:08.444 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-20 19:50:08.448 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 19:50:08.449 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 19:50:08.450 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 19:50:08.450 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/miel - 200 null application/json; charset=utf-8 9.1671ms 2025-11-20 19:52:17.004 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/customers/ByName/lui - null null 2025-11-20 19:52:17.005 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:52:17.005 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/customers/ByName/lui - 204 null null 0.4012ms 2025-11-20 19:52:17.063 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/customers/ByName/lui - null null 2025-11-20 19:52:17.064 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:52:17.064 +00:00 [INF] Executing endpoint 'HTTP: GET Customers/ByName/{name}' 2025-11-20 19:52:17.067 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__name_0_contains='?' (Size = 150)], CommandType='"Text"', CommandTimeout='30'] SELECT [c].[Id], [c].[Address], [c].[BirthDate], [c].[Cedula], [c].[CellPhone], [c].[CreatedById], [c].[CreatedDate], [c].[DeleteFlag], [c].[Email], [c].[Gender], [c].[HomePhone], [c].[Name], [c].[NationalityId], [c].[NationalityId1], [c].[Phone], [c].[UpdatedById], [c].[UpdatedDate] FROM [Customers] AS [c] WHERE [c].[DeleteFlag] = CAST(0 AS bit) AND [c].[Name] LIKE @__name_0_contains ESCAPE N'\' 2025-11-20 19:52:17.067 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 19:52:17.067 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 19:52:17.067 +00:00 [INF] Executed endpoint 'HTTP: GET Customers/ByName/{name}' 2025-11-20 19:52:17.067 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/customers/ByName/lui - 200 null application/json; charset=utf-8 3.9006ms 2025-11-20 19:52:17.626 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/customers/ByName/luisa - null null 2025-11-20 19:52:17.627 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:52:17.627 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/customers/ByName/luisa - 204 null null 0.4228ms 2025-11-20 19:52:17.693 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/customers/ByName/luisa - null null 2025-11-20 19:52:17.693 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:52:17.693 +00:00 [INF] Executing endpoint 'HTTP: GET Customers/ByName/{name}' 2025-11-20 19:52:17.696 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__name_0_contains='?' (Size = 150)], CommandType='"Text"', CommandTimeout='30'] SELECT [c].[Id], [c].[Address], [c].[BirthDate], [c].[Cedula], [c].[CellPhone], [c].[CreatedById], [c].[CreatedDate], [c].[DeleteFlag], [c].[Email], [c].[Gender], [c].[HomePhone], [c].[Name], [c].[NationalityId], [c].[NationalityId1], [c].[Phone], [c].[UpdatedById], [c].[UpdatedDate] FROM [Customers] AS [c] WHERE [c].[DeleteFlag] = CAST(0 AS bit) AND [c].[Name] LIKE @__name_0_contains ESCAPE N'\' 2025-11-20 19:52:17.697 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 19:52:17.697 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 19:52:17.697 +00:00 [INF] Executed endpoint 'HTTP: GET Customers/ByName/{name}' 2025-11-20 19:52:17.697 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/customers/ByName/luisa - 200 null application/json; charset=utf-8 4.1125ms 2025-11-20 19:56:50.083 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null 2025-11-20 19:56:50.083 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:56:50.083 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3194ms 2025-11-20 19:56:50.143 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 179 2025-11-20 19:56:50.143 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:56:50.144 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd' 2025-11-20 19:56:50.149 +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-20 19:56:50.152 +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-20 19:56:50.152 +00:00 [INF] Setting HTTP status code 201. 2025-11-20 19:56:50.153 +00:00 [INF] Writing value of type 'Int64' as Json. 2025-11-20 19:56:50.153 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd' 2025-11-20 19:56:50.153 +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.5551ms 2025-11-20 19:56:50.212 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40973 - null null 2025-11-20 19:56:50.212 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:56:50.212 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40973 - 204 null null 0.3872ms 2025-11-20 19:56:50.268 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/purchasedproducts - null null 2025-11-20 19:56:50.268 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:56:50.268 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/purchasedproducts - 204 null null 0.4721ms 2025-11-20 19:56:50.269 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40973 - application/json 207 2025-11-20 19:56:50.269 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-20 19:56:50.269 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:56:50.269 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:56:50.269 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.697ms 2025-11-20 19:56:50.270 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-20 19:56:50.272 +00:00 [INF] Executed DbCommand (1ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-20 19:56:50.324 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/purchasedproducts - application/json 40 2025-11-20 19:56:50.324 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:56:50.325 +00:00 [INF] Executing endpoint 'HTTP: POST PurchasedProducts/' 2025-11-20 19:56:50.327 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-20 19:56:50.328 +00:00 [INF] CORS policy execution successful. 2025-11-20 19:56:50.328 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-20 19:56:50.503 +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-20 19:56:50.509 +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-20 19:56:50.512 +00:00 [INF] Setting HTTP status code 201. 2025-11-20 19:56:50.512 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-20 19:56:50.512 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40973 - 201 0 null 243.7951ms 2025-11-20 19:56:50.657 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[@p0='?' (Size = 11), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Boolean), @p4='?' (DbType = Int64)], CommandType='"Text"', CommandTimeout='30'] SET IMPLICIT_TRANSACTIONS OFF; SET NOCOUNT ON; INSERT INTO [PurchasedProducts] ([Cedula], [CreatedById], [CreatedDate], [DeleteFlag], [SalesId]) OUTPUT INSERTED.[Id] VALUES (@p0, @p1, @p2, @p3, @p4); 2025-11-20 19:56:50.657 +00:00 [INF] Setting HTTP status code 201. 2025-11-20 19:56:50.657 +00:00 [INF] Writing value of type 'PurchasedProductsDto' as Json. 2025-11-20 19:56:50.657 +00:00 [INF] Executed endpoint 'HTTP: POST PurchasedProducts/' 2025-11-20 19:56:50.657 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/purchasedproducts - 201 null application/json; charset=utf-8 333.5194ms 2025-11-20 19:56:50.658 +00:00 [INF] Executed DbCommand (3ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[PaymentDescription], [p].[UpdatedById], [p].[UpdatedDate] FROM [PaymentTypes] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) 2025-11-20 19:56:50.658 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 19:56:50.658 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 19:56:50.658 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-20 19:56:50.658 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 330.9669ms 2025-11-20 21:33:50.911 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - null null 2025-11-20 21:33:50.911 +00:00 [INF] CORS policy execution successful. 2025-11-20 21:33:50.911 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/api/signin - 204 null null 0.2612ms 2025-11-20 21:33:50.976 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/api/signin - application/json 61 2025-11-20 21:33:50.976 +00:00 [INF] CORS policy execution successful. 2025-11-20 21:33:50.976 +00:00 [INF] Executing endpoint 'HTTP: POST /api/signin' 2025-11-20 21:33:51.203 +00:00 [INF] Executed DbCommand (4ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(2) [a].[Id], [a].[AccessFailedCount], [a].[ConcurrencyStamp], [a].[Discriminator], [a].[Email], [a].[EmailConfirmed], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName], [a].[FullName] FROM [AspNetUsers] AS [a] WHERE [a].[Discriminator] = N'AppUser' AND [a].[NormalizedEmail] = @__normalizedEmail_0 2025-11-20 21:33:51.306 +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-20 21:33:51.306 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 21:33:51.306 +00:00 [INF] Writing value of type '<>f__AnonymousType10`1' as Json. 2025-11-20 21:33:51.306 +00:00 [INF] Executed endpoint 'HTTP: POST /api/signin' 2025-11-20 21:33:51.306 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/api/signin - 200 null application/json; charset=utf-8 330.8368ms 2025-11-20 21:33:53.804 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-20 21:33:53.805 +00:00 [INF] CORS policy execution successful. 2025-11-20 21:33:53.805 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.2499ms 2025-11-20 21:33:53.861 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - null null 2025-11-20 21:33:53.861 +00:00 [INF] CORS policy execution successful. 2025-11-20 21:33:53.861 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/ProductTax - 204 null null 0.2324ms 2025-11-20 21:33:53.861 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - null null 2025-11-20 21:33:53.861 +00:00 [INF] CORS policy execution successful. 2025-11-20 21:33:53.861 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/nationalities - 204 null null 0.0592ms 2025-11-20 21:33:53.862 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - null null 2025-11-20 21:33:53.862 +00:00 [INF] CORS policy execution successful. 2025-11-20 21:33:53.862 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Settings - 204 null null 0.06ms 2025-11-20 21:33:53.864 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-20 21:33:53.865 +00:00 [INF] CORS policy execution successful. 2025-11-20 21:33:53.865 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-20 21:33:53.881 +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-20 21:33:53.881 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 21:33:53.881 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 21:33:53.881 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-20 21:33:53.881 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 16.7041ms 2025-11-20 21:33:53.918 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - null null 2025-11-20 21:33:53.918 +00:00 [INF] CORS policy execution successful. 2025-11-20 21:33:53.918 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/Settings - null null 2025-11-20 21:33:53.918 +00:00 [INF] CORS policy execution successful. 2025-11-20 21:33:53.919 +00:00 [INF] Executing endpoint 'HTTP: GET Settings/' 2025-11-20 21:33:53.920 +00:00 [INF] Executing endpoint 'HTTP: GET ProductTax/' 2025-11-20 21:33:53.920 +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-20 21:33:53.921 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 21:33:53.921 +00:00 [INF] Writing value of type 'SettingDto' as Json. 2025-11-20 21:33:53.922 +00:00 [INF] Executed endpoint 'HTTP: GET Settings/' 2025-11-20 21:33:53.922 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/Settings - 200 null application/json; charset=utf-8 3.4242ms 2025-11-20 21:33:53.924 +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-20 21:33:53.924 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 21:33:53.924 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 21:33:53.924 +00:00 [INF] Executed endpoint 'HTTP: GET ProductTax/' 2025-11-20 21:33:53.924 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/ProductTax - 200 null application/json; charset=utf-8 6.3831ms 2025-11-20 21:33:53.924 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/nationalities - null null 2025-11-20 21:33:53.924 +00:00 [INF] CORS policy execution successful. 2025-11-20 21:33:53.925 +00:00 [INF] Executing endpoint 'HTTP: GET /nationalities' 2025-11-20 21:33:53.926 +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-20 21:33:53.927 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 21:33:53.927 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 21:33:53.927 +00:00 [INF] Executed endpoint 'HTTP: GET /nationalities' 2025-11-20 21:33:53.928 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/nationalities - 200 null application/json; charset=utf-8 3.3954ms 2025-11-20 21:33:57.754 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/guineo - null null 2025-11-20 21:33:57.754 +00:00 [INF] CORS policy execution successful. 2025-11-20 21:33:57.754 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/guineo - 204 null null 0.2214ms 2025-11-20 21:33:57.814 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/guineo - null null 2025-11-20 21:33:57.814 +00:00 [INF] CORS policy execution successful. 2025-11-20 21:33:57.814 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 21:33:57.820 +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-20 21:33:57.823 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 21:33:57.823 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 21:33:57.940 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 21:33:57.940 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/guineo - 200 null application/json; charset=utf-8 125.9706ms 2025-11-20 21:34:07.672 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1561 - null null 2025-11-20 21:34:07.672 +00:00 [INF] CORS policy execution successful. 2025-11-20 21:34:07.672 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/1561 - 204 null null 0.2871ms 2025-11-20 21:34:07.732 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/1561 - null null 2025-11-20 21:34:07.732 +00:00 [INF] CORS policy execution successful. 2025-11-20 21:34:07.732 +00:00 [INF] Executing endpoint 'HTTP: GET Products/{id}' 2025-11-20 21:34:07.735 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__p_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[Id] = @__p_0 2025-11-20 21:34:07.736 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 21:34:07.736 +00:00 [INF] Writing value of type 'GetProductDetailsDto' as Json. 2025-11-20 21:34:07.737 +00:00 [INF] Executed endpoint 'HTTP: GET Products/{id}' 2025-11-20 21:34:07.737 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/1561 - 200 null application/json; charset=utf-8 5.4028ms 2025-11-20 21:34:12.281 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/sara - null null 2025-11-20 21:34:12.281 +00:00 [INF] CORS policy execution successful. 2025-11-20 21:34:12.281 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/sara - 204 null null 0.3232ms 2025-11-20 21:34:12.341 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/sara - null null 2025-11-20 21:34:12.341 +00:00 [INF] CORS policy execution successful. 2025-11-20 21:34:12.341 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 21:34:12.344 +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-20 21:34:12.347 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 21:34:12.347 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 21:34:12.348 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 21:34:12.348 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/sara - 200 null application/json; charset=utf-8 6.6835ms 2025-11-20 21:35:03.370 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null 2025-11-20 21:35:03.370 +00:00 [INF] CORS policy execution successful. 2025-11-20 21:35:03.370 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.3399ms 2025-11-20 21:35:03.430 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 224 2025-11-20 21:35:03.430 +00:00 [INF] CORS policy execution successful. 2025-11-20 21:35:03.430 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd' 2025-11-20 21:35:03.436 +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-20 21:35:03.439 +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-20 21:35:03.440 +00:00 [INF] Setting HTTP status code 201. 2025-11-20 21:35:03.440 +00:00 [INF] Writing value of type 'Int64' as Json. 2025-11-20 21:35:03.440 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd' 2025-11-20 21:35:03.440 +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.047ms 2025-11-20 21:35:03.503 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40974 - null null 2025-11-20 21:35:03.504 +00:00 [INF] CORS policy execution successful. 2025-11-20 21:35:03.504 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40974 - 204 null null 0.8625ms 2025-11-20 21:35:03.510 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-20 21:35:03.510 +00:00 [INF] CORS policy execution successful. 2025-11-20 21:35:03.511 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.5353ms 2025-11-20 21:35:03.560 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40974 - application/json 323 2025-11-20 21:35:03.560 +00:00 [INF] CORS policy execution successful. 2025-11-20 21:35:03.560 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-20 21:35:03.562 +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-20 21:35:03.570 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-20 21:35:03.570 +00:00 [INF] CORS policy execution successful. 2025-11-20 21:35:03.570 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-20 21:35:03.595 +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-20 21:35:03.596 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 21:35:03.596 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 21:35:03.596 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-20 21:35:03.596 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 26.2711ms 2025-11-20 21:35:03.748 +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-20 21:35:03.755 +00:00 [INF] Executed DbCommand (6ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p40='?' (DbType = Int32), @p23='?' (Size = 4000), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Int32), @p26='?' (DbType = Guid), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Boolean), @p29='?' (DbType = DateTime2), @p30='?' (DbType = Int32), @p31='?' (Size = 150), @p32='?' (Size = 500), @p33='?' (Size = -1) (DbType = Binary), @p34='?' (DbType = Int32), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p36='?' (Size = 4000), @p37='?' (DbType = Int32), @p38='?' (DbType = Guid), @p39='?' (DbType = DateTime2), @p58='?' (DbType = Int32), @p41='?' (Size = 4000), @p42='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p43='?' (DbType = Int32), @p44='?' (DbType = Guid), @p45='?' (DbType = DateTime2), @p46='?' (DbType = Boolean), @p47='?' (DbType = DateTime2), @p48='?' (DbType = Int32), @p49='?' (Size = 150), @p50='?' (Size = 500), @p51='?' (Size = -1) (DbType = Binary), @p52='?' (DbType = Int32), @p53='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p54='?' (Size = 4000), @p55='?' (DbType = Int32), @p56='?' (DbType = Guid), @p57='?' (DbType = DateTime2), @p59='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p60='?' (DbType = Guid), @p61='?' (DbType = DateTime2), @p62='?' (DbType = Boolean), @p63='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p64='?' (DbType = Int32), @p65='?' (DbType = Int32), @p66='?' (DbType = Int64), @p67='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p68='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p69='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p70='?' (DbType = Guid), @p71='?' (DbType = DateTime2), @p72='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p73='?' (DbType = Guid), @p74='?' (DbType = DateTime2), @p75='?' (DbType = Boolean), @p76='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p77='?' (DbType = Int32), @p78='?' (DbType = Int32), @p79='?' (DbType = Int64), @p80='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p81='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p82='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p83='?' (DbType = Guid), @p84='?' (DbType = DateTime2), @p85='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p86='?' (DbType = Guid), @p87='?' (DbType = DateTime2), @p88='?' (DbType = Boolean), @p89='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p90='?' (DbType = Int32), @p91='?' (DbType = Int32), @p92='?' (DbType = Int64), @p93='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p94='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p95='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p96='?' (DbType = Guid), @p97='?' (DbType = DateTime2), @p98='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p99='?' (DbType = Guid), @p100='?' (DbType = DateTime2), @p101='?' (DbType = Int32), @p102='?' (Size = 34), @p103='?' (DbType = Guid), @p104='?' (DbType = Int32), @p105='?' (DbType = Int32), @p106='?' (DbType = Int32), @p107='?' (Size = 4000), @p108='?' (Size = 4000), @p109='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p110='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p111='?' (DbType = Guid), @p112='?' (DbType = DateTime2), @p113='?' (DbType = Int32), @p114='?' (Size = 34), @p115='?' (DbType = Guid), @p116='?' (DbType = Int32), @p117='?' (DbType = Int32), @p118='?' (DbType = Int32), @p119='?' (Size = 4000), @p120='?' (Size = 4000), @p121='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p122='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p123='?' (DbType = Guid), @p124='?' (DbType = DateTime2), @p125='?' (DbType = Int32), @p126='?' (Size = 34), @p127='?' (DbType = Guid), @p128='?' (DbType = Int32), @p129='?' (DbType = Int32), @p130='?' (DbType = Int32), @p131='?' (Size = 4000), @p132='?' (Size = 4000), @p133='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21 OUTPUT 1 WHERE [Id] = @p22; UPDATE [Products] SET [BarCode] = @p23, [BuyPrice] = @p24, [CategoryId] = @p25, [CreatedById] = @p26, [CreatedDate] = @p27, [DeleteFlag] = @p28, [ExpirationDate] = @p29, [MinimunStock] = @p30, [Name] = @p31, [Note] = @p32, [ProductImage] = @p33, [ProductTaxId] = @p34, [SalePrice] = @p35, [Status] = @p36, [Stock] = @p37, [UpdatedById] = @p38, [UpdatedDate] = @p39 OUTPUT 1 WHERE [Id] = @p40; UPDATE [Products] SET [BarCode] = @p41, [BuyPrice] = @p42, [CategoryId] = @p43, [CreatedById] = @p44, [CreatedDate] = @p45, [DeleteFlag] = @p46, [ExpirationDate] = @p47, [MinimunStock] = @p48, [Name] = @p49, [Note] = @p50, [ProductImage] = @p51, [ProductTaxId] = @p52, [SalePrice] = @p53, [Status] = @p54, [Stock] = @p55, [UpdatedById] = @p56, [UpdatedDate] = @p57 OUTPUT 1 WHERE [Id] = @p58; MERGE [SalesDetail] USING ( VALUES (@p59, @p60, @p61, @p62, @p63, @p64, @p65, @p66, @p67, @p68, @p69, @p70, @p71, 0), (@p72, @p73, @p74, @p75, @p76, @p77, @p78, @p79, @p80, @p81, @p82, @p83, @p84, 1), (@p85, @p86, @p87, @p88, @p89, @p90, @p91, @p92, @p93, @p94, @p95, @p96, @p97, 2)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate], _Position) ON 1=0 WHEN NOT MATCHED THEN INSERT ([BuyPrice], [CreatedById], [CreatedDate], [DeleteFlag], [DiscountAmount], [ProductId], [Quantity], [SalesId], [Tax], [Total], [UnitPrice], [UpdatedById], [UpdatedDate]) VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[DeleteFlag], i.[DiscountAmount], i.[ProductId], i.[Quantity], i.[SalesId], i.[Tax], i.[Total], i.[UnitPrice], i.[UpdatedById], i.[UpdatedDate]) OUTPUT INSERTED.[Id], i._Position; MERGE [InventoryMovements] USING ( VALUES (@p98, @p99, @p100, @p101, @p102, @p103, @p104, @p105, @p106, @p107, @p108, @p109, 0), (@p110, @p111, @p112, @p113, @p114, @p115, @p116, @p117, @p118, @p119, @p120, @p121, 1), (@p122, @p123, @p124, @p125, @p126, @p127, @p128, @p129, @p130, @p131, @p132, @p133, 2)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice], _Position) ON 1=0 WHEN NOT MATCHED THEN INSERT ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice]) VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[Difference], i.[Discriminator], i.[InventoryMovementHeaderId], i.[NewStock], i.[OriginaStock], i.[ProductId], i.[ProductName], i.[Reazon], i.[SalePrice]) OUTPUT INSERTED.[Id], i._Position; 2025-11-20 21:35:03.759 +00:00 [INF] Setting HTTP status code 201. 2025-11-20 21:35:03.760 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-20 21:35:03.760 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40974 - 201 0 null 199.91ms 2025-11-20 22:26:44.222 +00:00 [INF] Request starting HTTP/1.1 GET http://localhost:5227/.git/config - null null 2025-11-20 22:26:44.223 +00:00 [INF] Request finished HTTP/1.1 GET http://localhost:5227/.git/config - 404 0 null 0.3231ms 2025-11-20 22:26:44.223 +00:00 [INF] Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://localhost:5227/.git/config, Response status code: 404 2025-11-20 23:16:24.404 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/aceite - null null 2025-11-20 23:16:24.404 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:16:24.404 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/aceite - 204 null null 0.335ms 2025-11-20 23:16:24.465 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/aceite - null null 2025-11-20 23:16:24.466 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:16:24.466 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:16:24.708 +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-20 23:16:24.726 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 23:16:24.726 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 23:16:24.959 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:16:24.959 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/aceite - 200 null application/json; charset=utf-8 493.7555ms 2025-11-20 23:17:34.042 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jara - null null 2025-11-20 23:17:34.042 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:17:34.042 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jara - 204 null null 0.3241ms 2025-11-20 23:17:34.110 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/jara - null null 2025-11-20 23:17:34.110 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:17:34.111 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:17:34.115 +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-20 23:17:34.118 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 23:17:34.118 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 23:17:34.118 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:17:34.119 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/jara - 200 null application/json; charset=utf-8 8.5071ms 2025-11-20 23:17:35.330 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/e - null null 2025-11-20 23:17:35.330 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:17:35.330 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/e - 204 null null 0.2948ms 2025-11-20 23:17:35.390 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/e - null null 2025-11-20 23:17:35.391 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:17:35.391 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:17:35.394 +00:00 [INF] Executed DbCommand (2ms) [Parameters=[@__tag_0_contains='?' (Size = 150), @__tag_0_contains_1='?' (Size = 4000)], CommandType='"Text"', CommandTimeout='30'] SELECT [p].[Id], [p].[BarCode], [p].[BuyPrice], [p].[CategoryId], [p].[CreatedById], [p].[CreatedDate], [p].[DeleteFlag], [p].[ExpirationDate], [p].[MinimunStock], [p].[Name], [p].[Note], [p].[ProductImage], [p].[ProductTaxId], [p].[SalePrice], [p].[Status], [p].[Stock], [p].[UpdatedById], [p].[UpdatedDate] FROM [Products] AS [p] WHERE [p].[DeleteFlag] = CAST(0 AS bit) AND [p].[CategoryId] IN (1, 2, 3) AND ([p].[Name] LIKE @__tag_0_contains ESCAPE N'\' OR ([p].[BarCode] IS NOT NULL AND [p].[BarCode] NOT LIKE N'' AND [p].[BarCode] LIKE @__tag_0_contains_1 ESCAPE N'\')) 2025-11-20 23:17:35.529 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 23:17:35.529 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 23:17:36.116 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:17:36.117 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/e - 200 null application/json; charset=utf-8 726.846ms 2025-11-20 23:17:40.989 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jarabe - null null 2025-11-20 23:17:40.989 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:17:40.989 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jarabe - 204 null null 0.2161ms 2025-11-20 23:17:41.049 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/jarabe - null null 2025-11-20 23:17:41.049 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:17:41.049 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:17:41.055 +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-20 23:17:41.057 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 23:17:41.057 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 23:17:41.057 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:17:41.058 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/jarabe - 200 null application/json; charset=utf-8 8.6674ms 2025-11-20 23:18:07.633 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/anticandida - null null 2025-11-20 23:18:07.634 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:18:07.634 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/anticandida - 204 null null 0.3585ms 2025-11-20 23:18:07.692 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/anticandida - null null 2025-11-20 23:18:07.692 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:18:07.693 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:18:07.704 +00:00 [INF] Executed DbCommand (10ms) [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-20 23:18:07.706 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 23:18:07.706 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 23:18:07.706 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:18:07.707 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/anticandida - 200 null application/json; charset=utf-8 14.5997ms 2025-11-20 23:18:16.168 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plata - null null 2025-11-20 23:18:16.168 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:18:16.168 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plata - 204 null null 0.4092ms 2025-11-20 23:18:16.225 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plata - null null 2025-11-20 23:18:16.225 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:18:16.225 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:18:16.231 +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-20 23:18:16.231 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 23:18:16.231 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 23:18:16.231 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:18:16.231 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/plata - 200 null application/json; charset=utf-8 6.6365ms 2025-11-20 23:18:20.286 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colloidad - null null 2025-11-20 23:18:20.286 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:18:20.286 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colloidad - 204 null null 0.2596ms 2025-11-20 23:18:20.350 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/colloidad - null null 2025-11-20 23:18:20.350 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:18:20.351 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:18:20.355 +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-20 23:18:20.355 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 23:18:20.356 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 23:18:20.356 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:18:20.356 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/colloidad - 200 null application/json; charset=utf-8 5.5007ms 2025-11-20 23:18:27.701 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/coloidal - null null 2025-11-20 23:18:27.701 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:18:27.701 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/coloidal - 204 null null 0.351ms 2025-11-20 23:18:27.762 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/coloidal - null null 2025-11-20 23:18:27.762 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:18:27.762 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:18:27.767 +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-20 23:18:27.768 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 23:18:27.768 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 23:18:27.768 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:18:27.769 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/coloidal - 200 null application/json; charset=utf-8 6.8645ms 2025-11-20 23:18:37.500 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jabomn - null null 2025-11-20 23:18:37.501 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:18:37.501 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jabomn - 204 null null 0.9647ms 2025-11-20 23:18:37.560 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/jabomn - null null 2025-11-20 23:18:37.560 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:18:37.561 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:18:37.566 +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-20 23:18:37.566 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 23:18:37.566 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 23:18:37.566 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:18:37.566 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/jabomn - 200 null application/json; charset=utf-8 6.3261ms 2025-11-20 23:18:42.349 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jjabon - null null 2025-11-20 23:18:42.350 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:18:42.350 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jjabon - 204 null null 1.0036ms 2025-11-20 23:18:42.415 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/jjabon - null null 2025-11-20 23:18:42.416 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:18:42.416 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:18:42.420 +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-20 23:18:42.421 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 23:18:42.421 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 23:18:42.421 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:18:42.421 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/jjabon - 200 null application/json; charset=utf-8 5.3767ms 2025-11-20 23:18:45.854 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jabon - null null 2025-11-20 23:18:45.855 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:18:45.855 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/jabon - 204 null null 0.9817ms 2025-11-20 23:18:45.915 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/jabon - null null 2025-11-20 23:18:45.915 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:18:45.916 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:18:45.920 +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-20 23:18:45.930 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 23:18:45.930 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 23:18:45.931 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:18:45.931 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/jabon - 200 null application/json; charset=utf-8 16.1383ms 2025-11-20 23:19:09.078 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colloidad - null null 2025-11-20 23:19:09.078 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:19:09.078 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colloidad - 204 null null 0.2827ms 2025-11-20 23:19:09.139 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/colloidad - null null 2025-11-20 23:19:09.140 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:19:09.140 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:19:09.145 +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-20 23:19:09.145 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 23:19:09.145 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 23:19:09.146 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:19:09.146 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/colloidad - 200 null application/json; charset=utf-8 6.2651ms 2025-11-20 23:19:13.669 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plata - null null 2025-11-20 23:19:13.669 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:19:13.669 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/plata - 204 null null 0.3438ms 2025-11-20 23:19:13.728 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/plata - null null 2025-11-20 23:19:13.729 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:19:13.729 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:19:13.735 +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-20 23:19:13.736 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 23:19:13.736 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 23:19:13.736 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:19:13.736 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/plata - 200 null application/json; charset=utf-8 7.5433ms 2025-11-20 23:19:22.693 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colloidal - null null 2025-11-20 23:19:22.693 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:19:22.694 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/colloidal - 204 null null 0.987ms 2025-11-20 23:19:22.757 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/colloidal - null null 2025-11-20 23:19:22.757 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:19:22.757 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:19:22.760 +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-20 23:19:22.763 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 23:19:22.764 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 23:19:22.764 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:19:22.764 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/colloidal - 200 null application/json; charset=utf-8 7.3732ms 2025-11-20 23:20:28.704 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/salami - null null 2025-11-20 23:20:28.704 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:20:28.704 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/salami - 204 null null 0.8395ms 2025-11-20 23:20:28.766 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/salami - null null 2025-11-20 23:20:28.766 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:20:28.766 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:20:28.769 +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-20 23:20:28.777 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 23:20:28.777 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 23:20:28.778 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:20:28.778 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/salami - 200 null application/json; charset=utf-8 12.0575ms 2025-11-20 23:21:23.811 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/kefir - null null 2025-11-20 23:21:23.811 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:21:23.811 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/products/find/kefir - 204 null null 0.3446ms 2025-11-20 23:21:23.870 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/products/find/kefir - null null 2025-11-20 23:21:23.870 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:21:23.871 +00:00 [INF] Executing endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:21:23.877 +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-20 23:21:23.878 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 23:21:23.878 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 23:21:23.878 +00:00 [INF] Executed endpoint 'HTTP: GET Products/find/{tag}' 2025-11-20 23:21:23.878 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/products/find/kefir - 200 null application/json; charset=utf-8 7.5735ms 2025-11-20 23:22:43.544 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - null null 2025-11-20 23:22:43.544 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:22:43.544 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/saleshd - 204 null null 0.2671ms 2025-11-20 23:22:43.603 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - application/json 182 2025-11-20 23:22:43.603 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:22:43.604 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/saleshd' 2025-11-20 23:22:43.608 +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-20 23:22:43.610 +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-20 23:22:43.611 +00:00 [INF] Setting HTTP status code 201. 2025-11-20 23:22:43.611 +00:00 [INF] Writing value of type 'Int64' as Json. 2025-11-20 23:22:43.611 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/saleshd' 2025-11-20 23:22:43.611 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/saleshd - 201 null application/json; charset=utf-8 7.8225ms 2025-11-20 23:22:43.673 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40975 - null null 2025-11-20 23:22:43.673 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:22:43.674 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/Sales/salesdetail/40975 - 204 null null 0.2666ms 2025-11-20 23:22:43.733 +00:00 [INF] Request starting HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - null null 2025-11-20 23:22:43.734 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:22:43.734 +00:00 [INF] Request finished HTTP/1.1 OPTIONS http://159.89.226.33:5227/SalePaymentType - 204 null null 0.6593ms 2025-11-20 23:22:43.752 +00:00 [INF] Request starting HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40975 - application/json 717 2025-11-20 23:22:43.753 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:22:43.753 +00:00 [INF] Executing endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-20 23:22:43.755 +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-20 23:22:43.793 +00:00 [INF] Request starting HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - null null 2025-11-20 23:22:43.794 +00:00 [INF] CORS policy execution successful. 2025-11-20 23:22:43.794 +00:00 [INF] Executing endpoint 'HTTP: GET SalePaymentType/' 2025-11-20 23:22:44.010 +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-20 23:22:44.065 +00:00 [INF] Executed DbCommand (54ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (DbType = Guid), @p2='?' (DbType = DateTime2), @p3='?' (Size = 4000), @p4='?' (DbType = Int32), @p22='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = Guid), @p9='?' (DbType = DateTime2), @p10='?' (DbType = Boolean), @p11='?' (DbType = DateTime2), @p12='?' (DbType = Int32), @p13='?' (Size = 150), @p14='?' (Size = 500), @p15='?' (Size = -1) (DbType = Binary), @p16='?' (DbType = Int32), @p17='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p18='?' (Size = 4000), @p19='?' (DbType = Int32), @p20='?' (DbType = Guid), @p21='?' (DbType = DateTime2), @p40='?' (DbType = Int32), @p23='?' (Size = 4000), @p24='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p25='?' (DbType = Int32), @p26='?' (DbType = Guid), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Boolean), @p29='?' (DbType = DateTime2), @p30='?' (DbType = Int32), @p31='?' (Size = 150), @p32='?' (Size = 500), @p33='?' (Size = -1) (DbType = Binary), @p34='?' (DbType = Int32), @p35='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p36='?' (Size = 4000), @p37='?' (DbType = Int32), @p38='?' (DbType = Guid), @p39='?' (DbType = DateTime2), @p58='?' (DbType = Int32), @p41='?' (Size = 4000), @p42='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p43='?' (DbType = Int32), @p44='?' (DbType = Guid), @p45='?' (DbType = DateTime2), @p46='?' (DbType = Boolean), @p47='?' (DbType = DateTime2), @p48='?' (DbType = Int32), @p49='?' (Size = 150), @p50='?' (Size = 500), @p51='?' (Size = -1) (DbType = Binary), @p52='?' (DbType = Int32), @p53='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p54='?' (Size = 4000), @p55='?' (DbType = Int32), @p56='?' (DbType = Guid), @p57='?' (DbType = DateTime2), @p76='?' (DbType = Int32), @p59='?' (Size = 4000), @p60='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p61='?' (DbType = Int32), @p62='?' (DbType = Guid), @p63='?' (DbType = DateTime2), @p64='?' (DbType = Boolean), @p65='?' (DbType = DateTime2), @p66='?' (DbType = Int32), @p67='?' (Size = 150), @p68='?' (Size = 500), @p69='?' (Size = -1) (DbType = Binary), @p70='?' (DbType = Int32), @p71='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p72='?' (Size = 4000), @p73='?' (DbType = Int32), @p74='?' (DbType = Guid), @p75='?' (DbType = DateTime2), @p94='?' (DbType = Int32), @p77='?' (Size = 4000), @p78='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p79='?' (DbType = Int32), @p80='?' (DbType = Guid), @p81='?' (DbType = DateTime2), @p82='?' (DbType = Boolean), @p83='?' (DbType = DateTime2), @p84='?' (DbType = Int32), @p85='?' (Size = 150), @p86='?' (Size = 500), @p87='?' (Size = -1) (DbType = Binary), @p88='?' (DbType = Int32), @p89='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p90='?' (Size = 4000), @p91='?' (DbType = Int32), @p92='?' (DbType = Guid), @p93='?' (DbType = DateTime2), @p112='?' (DbType = Int32), @p95='?' (Size = 4000), @p96='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p97='?' (DbType = Int32), @p98='?' (DbType = Guid), @p99='?' (DbType = DateTime2), @p100='?' (DbType = Boolean), @p101='?' (DbType = DateTime2), @p102='?' (DbType = Int32), @p103='?' (Size = 150), @p104='?' (Size = 500), @p105='?' (Size = -1) (DbType = Binary), @p106='?' (DbType = Int32), @p107='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p108='?' (Size = 4000), @p109='?' (DbType = Int32), @p110='?' (DbType = Guid), @p111='?' (DbType = DateTime2), @p130='?' (DbType = Int32), @p113='?' (Size = 4000), @p114='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p115='?' (DbType = Int32), @p116='?' (DbType = Guid), @p117='?' (DbType = DateTime2), @p118='?' (DbType = Boolean), @p119='?' (DbType = DateTime2), @p120='?' (DbType = Int32), @p121='?' (Size = 150), @p122='?' (Size = 500), @p123='?' (Size = -1) (DbType = Binary), @p124='?' (DbType = Int32), @p125='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p126='?' (Size = 4000), @p127='?' (DbType = Int32), @p128='?' (DbType = Guid), @p129='?' (DbType = DateTime2), @p131='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p132='?' (DbType = Guid), @p133='?' (DbType = DateTime2), @p134='?' (DbType = Boolean), @p135='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p136='?' (DbType = Int32), @p137='?' (DbType = Int32), @p138='?' (DbType = Int64), @p139='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p140='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p141='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p142='?' (DbType = Guid), @p143='?' (DbType = DateTime2), @p144='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p145='?' (DbType = Guid), @p146='?' (DbType = DateTime2), @p147='?' (DbType = Boolean), @p148='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p149='?' (DbType = Int32), @p150='?' (DbType = Int32), @p151='?' (DbType = Int64), @p152='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p153='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p154='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p155='?' (DbType = Guid), @p156='?' (DbType = DateTime2), @p157='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p158='?' (DbType = Guid), @p159='?' (DbType = DateTime2), @p160='?' (DbType = Boolean), @p161='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p162='?' (DbType = Int32), @p163='?' (DbType = Int32), @p164='?' (DbType = Int64), @p165='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p166='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p167='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p168='?' (DbType = Guid), @p169='?' (DbType = DateTime2), @p170='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p171='?' (DbType = Guid), @p172='?' (DbType = DateTime2), @p173='?' (DbType = Boolean), @p174='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p175='?' (DbType = Int32), @p176='?' (DbType = Int32), @p177='?' (DbType = Int64), @p178='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p179='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p180='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p181='?' (DbType = Guid), @p182='?' (DbType = DateTime2), @p183='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p184='?' (DbType = Guid), @p185='?' (DbType = DateTime2), @p186='?' (DbType = Boolean), @p187='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p188='?' (DbType = Int32), @p189='?' (DbType = Int32), @p190='?' (DbType = Int64), @p191='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p192='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p193='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p194='?' (DbType = Guid), @p195='?' (DbType = DateTime2), @p196='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p197='?' (DbType = Guid), @p198='?' (DbType = DateTime2), @p199='?' (DbType = Boolean), @p200='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p201='?' (DbType = Int32), @p202='?' (DbType = Int32), @p203='?' (DbType = Int64), @p204='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p205='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p206='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p207='?' (DbType = Guid), @p208='?' (DbType = DateTime2), @p209='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p210='?' (DbType = Guid), @p211='?' (DbType = DateTime2), @p212='?' (DbType = Boolean), @p213='?' (Precision = 10) (Scale = 2) (DbType = Decimal), @p214='?' (DbType = Int32), @p215='?' (DbType = Int32), @p216='?' (DbType = Int64), @p217='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p218='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p219='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p220='?' (DbType = Guid), @p221='?' (DbType = DateTime2), @p222='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p223='?' (DbType = Guid), @p224='?' (DbType = DateTime2), @p225='?' (DbType = Int32), @p226='?' (Size = 34), @p227='?' (DbType = Guid), @p228='?' (DbType = Int32), @p229='?' (DbType = Int32), @p230='?' (DbType = Int32), @p231='?' (Size = 4000), @p232='?' (Size = 4000), @p233='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p234='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p235='?' (DbType = Guid), @p236='?' (DbType = DateTime2), @p237='?' (DbType = Int32), @p238='?' (Size = 34), @p239='?' (DbType = Guid), @p240='?' (DbType = Int32), @p241='?' (DbType = Int32), @p242='?' (DbType = Int32), @p243='?' (Size = 4000), @p244='?' (Size = 4000), @p245='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p246='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p247='?' (DbType = Guid), @p248='?' (DbType = DateTime2), @p249='?' (DbType = Int32), @p250='?' (Size = 34), @p251='?' (DbType = Guid), @p252='?' (DbType = Int32), @p253='?' (DbType = Int32), @p254='?' (DbType = Int32), @p255='?' (Size = 4000), @p256='?' (Size = 4000), @p257='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p258='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p259='?' (DbType = Guid), @p260='?' (DbType = DateTime2), @p261='?' (DbType = Int32), @p262='?' (Size = 34), @p263='?' (DbType = Guid), @p264='?' (DbType = Int32), @p265='?' (DbType = Int32), @p266='?' (DbType = Int32), @p267='?' (Size = 4000), @p268='?' (Size = 4000), @p269='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p270='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p271='?' (DbType = Guid), @p272='?' (DbType = DateTime2), @p273='?' (DbType = Int32), @p274='?' (Size = 34), @p275='?' (DbType = Guid), @p276='?' (DbType = Int32), @p277='?' (DbType = Int32), @p278='?' (DbType = Int32), @p279='?' (Size = 4000), @p280='?' (Size = 4000), @p281='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p282='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p283='?' (DbType = Guid), @p284='?' (DbType = DateTime2), @p285='?' (DbType = Int32), @p286='?' (Size = 34), @p287='?' (DbType = Guid), @p288='?' (DbType = Int32), @p289='?' (DbType = Int32), @p290='?' (DbType = Int32), @p291='?' (Size = 4000), @p292='?' (Size = 4000), @p293='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p294='?' (Precision = 18) (Scale = 2) (DbType = Decimal), @p295='?' (DbType = Guid), @p296='?' (DbType = DateTime2), @p297='?' (DbType = Int32), @p298='?' (Size = 34), @p299='?' (DbType = Guid), @p300='?' (DbType = Int32), @p301='?' (DbType = Int32), @p302='?' (DbType = Int32), @p303='?' (Size = 4000), @p304='?' (Size = 4000), @p305='?' (Precision = 18) (Scale = 2) (DbType = Decimal)], CommandType='"Text"', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [InventoryMovementHeaders] ([Id], [CreatedById], [CreatedDate], [Description], [InventoryMovementType]) VALUES (@p0, @p1, @p2, @p3, @p4); UPDATE [Products] SET [BarCode] = @p5, [BuyPrice] = @p6, [CategoryId] = @p7, [CreatedById] = @p8, [CreatedDate] = @p9, [DeleteFlag] = @p10, [ExpirationDate] = @p11, [MinimunStock] = @p12, [Name] = @p13, [Note] = @p14, [ProductImage] = @p15, [ProductTaxId] = @p16, [SalePrice] = @p17, [Status] = @p18, [Stock] = @p19, [UpdatedById] = @p20, [UpdatedDate] = @p21 OUTPUT 1 WHERE [Id] = @p22; UPDATE [Products] SET [BarCode] = @p23, [BuyPrice] = @p24, [CategoryId] = @p25, [CreatedById] = @p26, [CreatedDate] = @p27, [DeleteFlag] = @p28, [ExpirationDate] = @p29, [MinimunStock] = @p30, [Name] = @p31, [Note] = @p32, [ProductImage] = @p33, [ProductTaxId] = @p34, [SalePrice] = @p35, [Status] = @p36, [Stock] = @p37, [UpdatedById] = @p38, [UpdatedDate] = @p39 OUTPUT 1 WHERE [Id] = @p40; UPDATE [Products] SET [BarCode] = @p41, [BuyPrice] = @p42, [CategoryId] = @p43, [CreatedById] = @p44, [CreatedDate] = @p45, [DeleteFlag] = @p46, [ExpirationDate] = @p47, [MinimunStock] = @p48, [Name] = @p49, [Note] = @p50, [ProductImage] = @p51, [ProductTaxId] = @p52, [SalePrice] = @p53, [Status] = @p54, [Stock] = @p55, [UpdatedById] = @p56, [UpdatedDate] = @p57 OUTPUT 1 WHERE [Id] = @p58; UPDATE [Products] SET [BarCode] = @p59, [BuyPrice] = @p60, [CategoryId] = @p61, [CreatedById] = @p62, [CreatedDate] = @p63, [DeleteFlag] = @p64, [ExpirationDate] = @p65, [MinimunStock] = @p66, [Name] = @p67, [Note] = @p68, [ProductImage] = @p69, [ProductTaxId] = @p70, [SalePrice] = @p71, [Status] = @p72, [Stock] = @p73, [UpdatedById] = @p74, [UpdatedDate] = @p75 OUTPUT 1 WHERE [Id] = @p76; UPDATE [Products] SET [BarCode] = @p77, [BuyPrice] = @p78, [CategoryId] = @p79, [CreatedById] = @p80, [CreatedDate] = @p81, [DeleteFlag] = @p82, [ExpirationDate] = @p83, [MinimunStock] = @p84, [Name] = @p85, [Note] = @p86, [ProductImage] = @p87, [ProductTaxId] = @p88, [SalePrice] = @p89, [Status] = @p90, [Stock] = @p91, [UpdatedById] = @p92, [UpdatedDate] = @p93 OUTPUT 1 WHERE [Id] = @p94; UPDATE [Products] SET [BarCode] = @p95, [BuyPrice] = @p96, [CategoryId] = @p97, [CreatedById] = @p98, [CreatedDate] = @p99, [DeleteFlag] = @p100, [ExpirationDate] = @p101, [MinimunStock] = @p102, [Name] = @p103, [Note] = @p104, [ProductImage] = @p105, [ProductTaxId] = @p106, [SalePrice] = @p107, [Status] = @p108, [Stock] = @p109, [UpdatedById] = @p110, [UpdatedDate] = @p111 OUTPUT 1 WHERE [Id] = @p112; UPDATE [Products] SET [BarCode] = @p113, [BuyPrice] = @p114, [CategoryId] = @p115, [CreatedById] = @p116, [CreatedDate] = @p117, [DeleteFlag] = @p118, [ExpirationDate] = @p119, [MinimunStock] = @p120, [Name] = @p121, [Note] = @p122, [ProductImage] = @p123, [ProductTaxId] = @p124, [SalePrice] = @p125, [Status] = @p126, [Stock] = @p127, [UpdatedById] = @p128, [UpdatedDate] = @p129 OUTPUT 1 WHERE [Id] = @p130; MERGE [SalesDetail] USING ( VALUES (@p131, @p132, @p133, @p134, @p135, @p136, @p137, @p138, @p139, @p140, @p141, @p142, @p143, 0), (@p144, @p145, @p146, @p147, @p148, @p149, @p150, @p151, @p152, @p153, @p154, @p155, @p156, 1), (@p157, @p158, @p159, @p160, @p161, @p162, @p163, @p164, @p165, @p166, @p167, @p168, @p169, 2), (@p170, @p171, @p172, @p173, @p174, @p175, @p176, @p177, @p178, @p179, @p180, @p181, @p182, 3), (@p183, @p184, @p185, @p186, @p187, @p188, @p189, @p190, @p191, @p192, @p193, @p194, @p195, 4), (@p196, @p197, @p198, @p199, @p200, @p201, @p202, @p203, @p204, @p205, @p206, @p207, @p208, 5), (@p209, @p210, @p211, @p212, @p213, @p214, @p215, @p216, @p217, @p218, @p219, @p220, @p221, 6)) 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 (@p222, @p223, @p224, @p225, @p226, @p227, @p228, @p229, @p230, @p231, @p232, @p233, 0), (@p234, @p235, @p236, @p237, @p238, @p239, @p240, @p241, @p242, @p243, @p244, @p245, 1), (@p246, @p247, @p248, @p249, @p250, @p251, @p252, @p253, @p254, @p255, @p256, @p257, 2), (@p258, @p259, @p260, @p261, @p262, @p263, @p264, @p265, @p266, @p267, @p268, @p269, 3), (@p270, @p271, @p272, @p273, @p274, @p275, @p276, @p277, @p278, @p279, @p280, @p281, 4), (@p282, @p283, @p284, @p285, @p286, @p287, @p288, @p289, @p290, @p291, @p292, @p293, 5), (@p294, @p295, @p296, @p297, @p298, @p299, @p300, @p301, @p302, @p303, @p304, @p305, 6)) AS i ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice], _Position) ON 1=0 WHEN NOT MATCHED THEN INSERT ([BuyPrice], [CreatedById], [CreatedDate], [Difference], [Discriminator], [InventoryMovementHeaderId], [NewStock], [OriginaStock], [ProductId], [ProductName], [Reazon], [SalePrice]) VALUES (i.[BuyPrice], i.[CreatedById], i.[CreatedDate], i.[Difference], i.[Discriminator], i.[InventoryMovementHeaderId], i.[NewStock], i.[OriginaStock], i.[ProductId], i.[ProductName], i.[Reazon], i.[SalePrice]) OUTPUT INSERTED.[Id], i._Position; 2025-11-20 23:22:44.073 +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-20 23:22:44.074 +00:00 [INF] Setting HTTP status code 201. 2025-11-20 23:22:44.074 +00:00 [INF] Executed endpoint 'HTTP: POST Sales/salesdetail/{id}' 2025-11-20 23:22:44.074 +00:00 [INF] Setting HTTP status code 200. 2025-11-20 23:22:44.074 +00:00 [INF] Request finished HTTP/1.1 POST http://159.89.226.33:5227/Sales/salesdetail/40975 - 201 0 null 321.4021ms 2025-11-20 23:22:44.074 +00:00 [INF] Writing value of type 'List`1' as Json. 2025-11-20 23:22:44.075 +00:00 [INF] Executed endpoint 'HTTP: GET SalePaymentType/' 2025-11-20 23:22:44.075 +00:00 [INF] Request finished HTTP/1.1 GET http://159.89.226.33:5227/SalePaymentType - 200 null application/json; charset=utf-8 281.9032ms