[10.04.2024 09:31:23.830 +00:00 INF] Migrations [10.04.2024 09:31:23.931 +00:00 INF] 20240229001: Migration_GetAllByStatus [10.04.2024 09:31:23.931 +00:00 INF] 20240229002: Migration_GetAll [10.04.2024 09:31:23.931 +00:00 INF] 20240229003: Migration_GetOrdersByUserId [10.04.2024 09:31:23.931 +00:00 INF] 20240105195988: Migration_20240105195988 [10.04.2024 09:31:23.931 +00:00 INF] 20240106150801: Migration_20240106150801 [10.04.2024 09:31:23.931 +00:00 INF] 20240222282856: Migration_20240222282856 [10.04.2024 09:31:23.931 +00:00 INF] 20240225185332: Migration_20240225185332 [10.04.2024 09:31:23.931 +00:00 INF] 20240226001548: Migration_20240226001548 [10.04.2024 09:31:23.931 +00:00 INF] 20240229112234: Migration_20240229112234 [10.04.2024 09:31:23.931 +00:00 INF] 20240404234500: Migration_20240404234500 (not applied) [10.04.2024 09:31:23.931 +00:00 INF] 20240703175787: Migration_20240703175787 [10.04.2024 09:31:23.931 +00:00 INF] 20240903164034: Migration_20240903164034 [10.04.2024 09:31:23.931 +00:00 INF] 20241003130612: Migration_20241003130612 [10.04.2024 09:31:23.931 +00:00 INF] 20241003184355: Migration_20241003184355 [10.04.2024 09:31:23.932 +00:00 INF] 20242403195365: Migration_20242403195365 [10.04.2024 09:31:23.932 +00:00 INF] 20242403210101: Migration_20242403210101 [10.04.2024 09:31:23.932 +00:00 INF] 202403091170645: Migration_202403091170645 [10.04.2024 09:31:23.932 +00:00 INF] 202404032111114: Migration_20240403211111 [10.04.2024 09:31:23.932 +00:00 WRN] 2024032122165643: Migration_2024032122165643 (current) [10.04.2024 09:31:23.932 +00:00 INF] 2024040820368776: Migration_2024040820368776 (not applied) [10.04.2024 09:31:23.950 +00:00 INF] 20240404234500: Migration_20240404234500 migrating [10.04.2024 09:31:23.951 +00:00 INF] Beginning Transaction [10.04.2024 09:31:23.963 +00:00 INF] BEGIN TRANSACTION [10.04.2024 09:31:24.020 +00:00 INF] CreateTable Subscribers [10.04.2024 09:31:24.041 +00:00 INF] CREATE TABLE [dbo].[Subscribers] ([Id] INT NOT NULL IDENTITY(1,1), [UserId] UNIQUEIDENTIFIER NOT NULL, [Deleted] BIT NOT NULL CONSTRAINT [DF_Subscribers_Deleted] DEFAULT 0, [CreatedDate] DATETIME NOT NULL CONSTRAINT [DF_Subscribers_CreatedDate] DEFAULT GETUTCDATE(), [UpdatedDate] DATETIME NOT NULL CONSTRAINT [DF_Subscribers_UpdatedDate] DEFAULT GETUTCDATE(), [CreatedUser] NVARCHAR(255), [UpdatedUser] NVARCHAR(255), CONSTRAINT [PK_Subscribers] PRIMARY KEY ([Id])) [10.04.2024 09:31:24.177 +00:00 INF] => 0.1549731s [10.04.2024 09:31:24.178 +00:00 INF] CreateForeignKey FK_Subscribers_UserId_AppUsers_Id Subscribers(UserId) AppUsers(Id) [10.04.2024 09:31:24.183 +00:00 INF] ALTER TABLE [dbo].[Subscribers] ADD CONSTRAINT [FK_Subscribers_UserId_AppUsers_Id] FOREIGN KEY ([UserId]) REFERENCES [dbo].[AppUsers] ([Id]) [10.04.2024 09:31:24.193 +00:00 INF] => 0.0146735s [10.04.2024 09:31:24.194 +00:00 INF] INSERT INTO [dbo].[VersionInfo] ([Version], [AppliedOn], [Description]) VALUES (20240404234500, '2024-04-10T09:31:24', N'Migration_20240404234500') [10.04.2024 09:31:24.203 +00:00 INF] Committing Transaction [10.04.2024 09:31:24.213 +00:00 INF] COMMIT TRANSACTION [10.04.2024 09:31:24.213 +00:00 INF] 20240404234500: Migration_20240404234500 migrated [10.04.2024 09:31:24.213 +00:00 INF] => 0.0353391s [10.04.2024 09:31:24.213 +00:00 INF] 2024040820368776: Migration_2024040820368776 migrating [10.04.2024 09:31:24.214 +00:00 INF] Beginning Transaction [10.04.2024 09:31:24.214 +00:00 INF] BEGIN TRANSACTION [10.04.2024 09:31:24.233 +00:00 INF] ExecuteEmbeddedSqlScript 2024040820368776-Alter_GetOrdersByUserId.sql [10.04.2024 09:31:24.293 +00:00 INF] /****** Object: StoredProcedure [dbo].[Order_GetOrdersByUserId] Script Date: 08.04.2024 20:21:27 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[Order_GetOrdersByUserId] ( @userId varchar(125), @offset int = 0, @limit int = 10, @status int = null, @lan nvarchar(5) ) AS BEGIN SET NOCOUNT ON; DECLARE @OfferInfo TABLE ( Id int IDENTITY(1,1), OrderId uniqueidentifier, Status INT, Count INT ) DECLARE @PageOrders TABLE ( Id UNIQUEIDENTIFIER ) INSERT INTO @PageOrders SELECT Id FROM Orders o WHERE o.Deleted=0 AND o.UserId = @userId AND (o.Status = @status OR @status IS NULL) ORDER BY o.UpdatedDate DESC, o.CreatedDate DESC, o.Id OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY INSERT INTO @OfferInfo SELECT offer.OrderId, offer.Status, Count(offer.Id) AS Count FROM Offers offer JOIN Orders orders ON orders.Id = offer.OrderId AND orders.UserId = @userId GROUP BY offer.Status, offer.OrderId SELECT o.*, offers.id AS AcceptedOfferId, oi.*, t.TranslationInfo AS CategoryName, offi.* FROM @PageOrders po JOIN Orders o ON o.Id = po.Id JOIN OrderItems oi ON oi.OrderId = o.Id AND oi.Deleted = 0 LEFT JOin @OfferInfo offi ON offi.OrderId = oi.OrderId JOIN ProductCategories pc on oi.ProductCategoryId = pc.Id JOIN TextContents tc ON tc.Id = pc.TextContentId JOIN Translations t ON t.TextContentId = tc.Id LEFT JOIN Offers offers ON o.Id = offers.OrderId WHERE o.Deleted=0 AND o.UserId = @userId AND (o.Status = @status OR @status IS NULL) AND oi.Deleted = 0 AND t.LanguageId = (SELECT id FROM Languages l WHERE l.LanguageKey = @lan) ORDER BY o.id, o.UpdatedDate SELECT COUNT(Id) TotalCount FROM Orders WHERE Deleted = 0 AND UserId = @userId AND (Status = @status OR @status IS NULL) END [10.04.2024 09:31:24.337 +00:00 INF] => 0.1039645s [10.04.2024 09:31:24.337 +00:00 INF] INSERT INTO [dbo].[VersionInfo] ([Version], [AppliedOn], [Description]) VALUES (2024040820368776, '2024-04-10T09:31:24', N'Migration_2024040820368776') [10.04.2024 09:31:24.339 +00:00 INF] Committing Transaction [10.04.2024 09:31:24.362 +00:00 INF] COMMIT TRANSACTION [10.04.2024 09:31:24.362 +00:00 INF] 2024040820368776: Migration_2024040820368776 migrated [10.04.2024 09:31:24.362 +00:00 INF] => 0.1297846s [10.04.2024 10:08:13.294 +00:00 INF] Migrations [10.04.2024 10:08:13.558 +00:00 INF] 20240229001: Migration_GetAllByStatus [10.04.2024 10:08:13.585 +00:00 INF] 20240229002: Migration_GetAll [10.04.2024 10:08:13.595 +00:00 INF] 20240229003: Migration_GetOrdersByUserId [10.04.2024 10:08:13.608 +00:00 INF] 20240105195988: Migration_20240105195988 [10.04.2024 10:08:13.636 +00:00 INF] 20240106150801: Migration_20240106150801 [10.04.2024 10:08:13.647 +00:00 INF] 20240222282856: Migration_20240222282856 [10.04.2024 10:08:13.666 +00:00 INF] 20240225185332: Migration_20240225185332 [10.04.2024 10:08:13.676 +00:00 INF] 20240226001548: Migration_20240226001548 [10.04.2024 10:08:13.686 +00:00 INF] 20240229112234: Migration_20240229112234 [10.04.2024 10:08:13.696 +00:00 INF] 20240404234500: Migration_20240404234500 [10.04.2024 10:08:13.706 +00:00 INF] 20240703175787: Migration_20240703175787 [10.04.2024 10:08:13.715 +00:00 INF] 20240903164034: Migration_20240903164034 [10.04.2024 10:08:13.785 +00:00 INF] 20241003130612: Migration_20241003130612 [10.04.2024 10:08:13.795 +00:00 INF] 20241003184355: Migration_20241003184355 [10.04.2024 10:08:13.805 +00:00 INF] 20242403195365: Migration_20242403195365 [10.04.2024 10:08:13.815 +00:00 INF] 20242403210101: Migration_20242403210101 [10.04.2024 10:08:13.847 +00:00 INF] 202403091170645: Migration_202403091170645 [10.04.2024 10:08:13.856 +00:00 INF] 202404032111114: Migration_20240403211111 [10.04.2024 10:08:13.866 +00:00 WRN] 2024032122165643: Migration_2024032122165643 (current) [10.04.2024 10:08:13.875 +00:00 INF] 2024040820368776: Migration_2024040820368776 (not applied) [10.04.2024 10:08:13.967 +00:00 INF] 2024040820368776: Migration_2024040820368776 migrating [10.04.2024 10:08:13.987 +00:00 INF] Beginning Transaction [10.04.2024 10:08:14.037 +00:00 INF] BEGIN TRANSACTION [10.04.2024 10:08:14.208 +00:00 INF] ExecuteEmbeddedSqlScript 2024040820368776-Alter_GetOrdersByUserId.sql [10.04.2024 10:08:14.333 +00:00 INF] /****** Object: StoredProcedure [dbo].[Order_GetOrdersByUserId] Script Date: 08.04.2024 20:21:27 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[Order_GetOrdersByUserId] ( @userId varchar(125), @offset int = 0, @limit int = 10, @status int = null, @lan nvarchar(5) ) AS BEGIN SET NOCOUNT ON; DECLARE @OfferInfo TABLE ( Id int IDENTITY(1,1), OrderId uniqueidentifier, Status INT, Count INT ) DECLARE @PageOrders TABLE ( Id UNIQUEIDENTIFIER ) INSERT INTO @PageOrders SELECT Id FROM Orders o WHERE o.Deleted=0 AND o.UserId = @userId AND (o.Status = @status OR @status IS NULL) ORDER BY o.UpdatedDate DESC, o.CreatedDate DESC, o.Id OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY INSERT INTO @OfferInfo SELECT offer.OrderId, offer.Status, Count(offer.Id) AS Count FROM Offers offer JOIN Orders orders ON orders.Id = offer.OrderId AND orders.UserId = @userId GROUP BY offer.Status, offer.OrderId SELECT o.*, offers.id AS AcceptedOfferId, oi.*, t.TranslationInfo AS CategoryName, offi.* FROM @PageOrders po JOIN Orders o ON o.Id = po.Id JOIN OrderItems oi ON oi.OrderId = o.Id AND oi.Deleted = 0 LEFT JOin @OfferInfo offi ON offi.OrderId = oi.OrderId JOIN ProductCategories pc on oi.ProductCategoryId = pc.Id JOIN TextContents tc ON tc.Id = pc.TextContentId JOIN Translations t ON t.TextContentId = tc.Id LEFT JOIN Offers offers ON o.Id = offers.OrderId WHERE o.Deleted=0 AND o.UserId = @userId AND (o.Status = @status OR @status IS NULL) AND oi.Deleted = 0 AND t.LanguageId = (SELECT id FROM Languages l WHERE l.LanguageKey = @lan) ORDER BY o.id, o.UpdatedDate SELECT COUNT(Id) TotalCount FROM Orders WHERE Deleted = 0 AND UserId = @userId AND (Status = @status OR @status IS NULL) END [10.04.2024 10:08:14.574 +00:00 INF] => 0.3565371s [10.04.2024 10:08:14.623 +00:00 INF] INSERT INTO [dbo].[VersionInfo] ([Version], [AppliedOn], [Description]) VALUES (2024040820368776, '2024-04-10T10:08:14', N'Migration_2024040820368776') [10.04.2024 10:08:14.627 +00:00 INF] Committing Transaction [10.04.2024 10:08:14.649 +00:00 INF] COMMIT TRANSACTION [10.04.2024 10:08:14.664 +00:00 INF] 2024040820368776: Migration_2024040820368776 migrated [10.04.2024 10:08:14.665 +00:00 INF] => 0.4486713s [10.04.2024 10:53:51.727 +00:00 INF] Migrations [10.04.2024 10:53:51.847 +00:00 INF] 20240229001: Migration_GetAllByStatus [10.04.2024 10:53:51.848 +00:00 INF] 20240229002: Migration_GetAll [10.04.2024 10:53:51.848 +00:00 INF] 20240229003: Migration_GetOrdersByUserId [10.04.2024 10:53:51.848 +00:00 INF] 20240105195988: Migration_20240105195988 [10.04.2024 10:53:51.849 +00:00 INF] 20240106150801: Migration_20240106150801 [10.04.2024 10:53:51.849 +00:00 INF] 20240222282856: Migration_20240222282856 [10.04.2024 10:53:51.850 +00:00 INF] 20240225185332: Migration_20240225185332 [10.04.2024 10:53:51.850 +00:00 INF] 20240226001548: Migration_20240226001548 [10.04.2024 10:53:51.856 +00:00 INF] 20240229112234: Migration_20240229112234 [10.04.2024 10:53:51.857 +00:00 INF] 20240404234500: Migration_20240404234500 [10.04.2024 10:53:51.857 +00:00 INF] 20240703175787: Migration_20240703175787 [10.04.2024 10:53:51.857 +00:00 INF] 20240903164034: Migration_20240903164034 [10.04.2024 10:53:51.858 +00:00 INF] 20241003130612: Migration_20241003130612 [10.04.2024 10:53:51.858 +00:00 INF] 20241003184355: Migration_20241003184355 [10.04.2024 10:53:51.858 +00:00 INF] 20242403195365: Migration_20242403195365 [10.04.2024 10:53:51.859 +00:00 INF] 20242403210101: Migration_20242403210101 [10.04.2024 10:53:51.859 +00:00 INF] 202403091170645: Migration_202403091170645 [10.04.2024 10:53:51.859 +00:00 INF] 202404032111114: Migration_20240403211111 [10.04.2024 10:53:51.860 +00:00 INF] 2024032122165643: Migration_2024032122165643 [10.04.2024 10:53:51.866 +00:00 WRN] 2024040820368776: Migration_2024040820368776 (current) [10.04.2024 11:55:34.836 +00:00 INF] 0HN2P9I1EQ07E:00000008 Start processing HTTP request POST https://www.google.com/recaptcha/api/siteverify [10.04.2024 11:55:34.854 +00:00 INF] 0HN2P9I1EQ07E:00000008 Sending HTTP request POST https://www.google.com/recaptcha/api/siteverify [10.04.2024 11:55:36.245 +00:00 INF] 0HN2P9I1EQ07E:00000008 Received HTTP response headers after 1367.9219ms - 200 [10.04.2024 11:55:36.255 +00:00 INF] 0HN2P9I1EQ07E:00000008 End processing HTTP request after 1431.7193ms - 200 [10.04.2024 11:55:37.208 +00:00 INF] 0HN2P9I1EQ07E:00000008 Start processing HTTP request GET https://sms.atltech.az:8090/index.php?app=quick_sms_redex&login=findinsms&key=0ea8a0b3079ccdcd9d36412bd64dbe68&sender=FindIn.Az&msisdn=994515156212&text=2761 [10.04.2024 11:55:37.209 +00:00 INF] 0HN2P9I1EQ07E:00000008 Sending HTTP request GET https://sms.atltech.az:8090/index.php?app=quick_sms_redex&login=findinsms&key=0ea8a0b3079ccdcd9d36412bd64dbe68&sender=FindIn.Az&msisdn=994515156212&text=2761 [10.04.2024 11:55:38.958 +00:00 INF] 0HN2P9I1EQ07E:00000008 Received HTTP response headers after 1748.422ms - 200 [10.04.2024 11:55:38.960 +00:00 INF] 0HN2P9I1EQ07E:00000008 End processing HTTP request after 1751.2703ms - 200 [10.04.2024 11:56:07.850 +00:00 INF] 0HN2P9I1EQ07E:0000000E Start processing HTTP request POST https://www.google.com/recaptcha/api/siteverify [10.04.2024 11:56:07.851 +00:00 INF] 0HN2P9I1EQ07E:0000000E Sending HTTP request POST https://www.google.com/recaptcha/api/siteverify [10.04.2024 11:56:08.345 +00:00 INF] 0HN2P9I1EQ07E:0000000E Received HTTP response headers after 487.7197ms - 200 [10.04.2024 11:56:08.347 +00:00 INF] 0HN2P9I1EQ07E:0000000E End processing HTTP request after 496.993ms - 200 [10.04.2024 11:56:08.368 +00:00 INF] 0HN2P9I1EQ07E:0000000E Start processing HTTP request GET https://sms.atltech.az:8090/index.php?app=quick_sms_redex&login=findinsms&key=0ea8a0b3079ccdcd9d36412bd64dbe68&sender=FindIn.Az&msisdn=994515621282&text=2673 [10.04.2024 11:56:08.369 +00:00 INF] 0HN2P9I1EQ07E:0000000E Sending HTTP request GET https://sms.atltech.az:8090/index.php?app=quick_sms_redex&login=findinsms&key=0ea8a0b3079ccdcd9d36412bd64dbe68&sender=FindIn.Az&msisdn=994515621282&text=2673 [10.04.2024 11:56:10.553 +00:00 INF] 0HN2P9I1EQ07E:0000000E Received HTTP response headers after 2183.2177ms - 200 [10.04.2024 11:56:10.554 +00:00 INF] 0HN2P9I1EQ07E:0000000E End processing HTTP request after 2186.0185ms - 200 [10.04.2024 14:27:11.494 +00:00 INF] Migrations [10.04.2024 14:27:11.676 +00:00 INF] 20240229001: Migration_GetAllByStatus [10.04.2024 14:27:11.685 +00:00 INF] 20240229002: Migration_GetAll [10.04.2024 14:27:11.685 +00:00 INF] 20240229003: Migration_GetOrdersByUserId [10.04.2024 14:27:11.685 +00:00 INF] 20240105195988: Migration_20240105195988 [10.04.2024 14:27:11.686 +00:00 INF] 20240106150801: Migration_20240106150801 [10.04.2024 14:27:11.686 +00:00 INF] 20240222282856: Migration_20240222282856 [10.04.2024 14:27:11.687 +00:00 INF] 20240225185332: Migration_20240225185332 [10.04.2024 14:27:11.694 +00:00 INF] 20240226001548: Migration_20240226001548 [10.04.2024 14:27:11.695 +00:00 INF] 20240229112234: Migration_20240229112234 [10.04.2024 14:27:11.695 +00:00 INF] 20240404234500: Migration_20240404234500 [10.04.2024 14:27:11.696 +00:00 INF] 20240703175787: Migration_20240703175787 [10.04.2024 14:27:11.696 +00:00 INF] 20240903164034: Migration_20240903164034 [10.04.2024 14:27:11.696 +00:00 INF] 20241003130612: Migration_20241003130612 [10.04.2024 14:27:11.701 +00:00 INF] 20241003184355: Migration_20241003184355 [10.04.2024 14:27:11.704 +00:00 INF] 20242403195365: Migration_20242403195365 [10.04.2024 14:27:11.714 +00:00 INF] 20242403210101: Migration_20242403210101 [10.04.2024 14:27:11.725 +00:00 INF] 202403091170645: Migration_202403091170645 [10.04.2024 14:27:11.730 +00:00 INF] 202404032111114: Migration_20240403211111 [10.04.2024 14:27:11.731 +00:00 INF] 2024032122165643: Migration_2024032122165643 [10.04.2024 14:27:11.740 +00:00 WRN] 2024040820368776: Migration_2024040820368776 (current) [10.04.2024 19:58:36.649 +00:00 INF] 0HN2PD98KMSQS:000000C8 Start processing HTTP request POST https://www.google.com/recaptcha/api/siteverify [10.04.2024 19:58:36.673 +00:00 INF] 0HN2PD98KMSQS:000000C8 Sending HTTP request POST https://www.google.com/recaptcha/api/siteverify [10.04.2024 19:58:38.066 +00:00 INF] 0HN2PD98KMSQS:000000C8 Received HTTP response headers after 1387.5014ms - 200 [10.04.2024 19:58:38.077 +00:00 INF] 0HN2PD98KMSQS:000000C8 End processing HTTP request after 1446.7073ms - 200