/// <summary>
 /// The method of forming a string name = Last Name + First Name, which will be added to the list.
 /// Called by method Connect To Server ConnectToServer.
 /// For Storage2.
 /// </summary>
 /// <param name="context">The context of the interaction with the database.</param>
 /// <param name="f">The object to be added such as Friends.</param>
 /// <param name="listOfFriends">Friend list.</param>
 /// <returns>The format string "{Last Name} + {First Name}".</returns>
 public string FindFriendsStorage2(Storage2Context context, Friends f, List<int> listOfFriends)
 {
     var queryFriend = context.User.Where(x => x.Id == f.Friend_Id);
     var elementToAdd = queryFriend.ToList();
     listOfFriends.Add(elementToAdd[0].Id);
     return (elementToAdd[0].Last_Name + ' ' + elementToAdd[0].First_Name);
 }
 /// <summary>
 /// Cached Storage2.
 /// </summary>
 private static void CacheThreadStorage2()
 {
     using (Storage2Context connection = new Storage2Context())
     {
         var entity = connection.User.ToList().FirstOrDefault();
     }
 }
        /// <summary>
        /// Methods of adding a record in the database (Storage2).
        /// Called from the methods TransactionScopeWithStorage.
        /// </summary>
        /// <param name="context">The context of the interaction with the database.</param>
        /// <param name="entity">The object to add the type of User.</param>
        /// <param name="count">Counter.</param>
        /// <param name="commitCount">Meaning - "every time commitCount doing SaveChanges()".</param>
        /// <param name="recreateContext">It must be true.</param>
        /// <returns>The context of the interaction with the database.</returns>
        private static Storage2Context AddToStorage2(Storage2Context context, User entity, int count, int commitCount, bool recreateContext)
        {
            context.Set<User>().Add(entity);

            if (count%commitCount != 0)
                return context;

            context.SaveChanges();

            if (!recreateContext)
                return context;

            context.Dispose();
            context = new Storage2Context();
            context.Configuration.AutoDetectChangesEnabled = false;

            return context;
        }
        /// <summary>
        /// The method for forming transactions with Storage2.
        /// Called from an event handler btnFill_Click.
        /// </summary>
        /// <param name="users">The list of users you want to add.</param>
        public void TransactionScopeWithStorage2(List<User> users)
        {
            using (var scope = new TransactionScope())
            {
                Storage2Context context = null;
                try
                {
                    context = new Storage2Context();
                    context.Configuration.AutoDetectChangesEnabled = false;

                    var count = 0;
                    foreach (var entityToInsert in users)
                    {
                        ++count;
                        context = AddToStorage2(context, entityToInsert, count, 100, true);
                    }

                    context.SaveChanges();
                }
                finally
                {
                    context?.Dispose();
                }

                scope.Complete();
            }
        }
        /// <summary>
        /// Event: Make all friends.
        /// </summary>
        /// <param name="sender">Sender</param>
        /// <param name="e">Event Args</param>
        override protected void btnFriends_Click(object sender, RoutedEventArgs e)
        {
            var arrayNumberFriends = new int[500000];

            for (var i = 0; i < 500000; i++) arrayNumberFriends[i] = 0;

            var rnd = new Random();

            var storage1Context = new Storage1Context();
            var storage2Context = new Storage2Context();
            var storage3Context = new Storage3Context();
            var storage4Context = new Storage4Context();
            var storage5Context = new Storage5Context();

            storage1Context.Configuration.AutoDetectChangesEnabled = false;
            storage2Context.Configuration.AutoDetectChangesEnabled = false;
            storage3Context.Configuration.AutoDetectChangesEnabled = false;
            storage4Context.Configuration.AutoDetectChangesEnabled = false;
            storage5Context.Configuration.AutoDetectChangesEnabled = false;

            for (var i = 0; i < 500000; i++)
            {
                if (arrayNumberFriends[i] == 5)
                    continue;

                var shortage = 5 - arrayNumberFriends[i];
                for (var j = 0; j < shortage; j++)
                {
                    var friendId = rnd.Next(1, 500001);
                    if (i == friendId)
                        friendId = rnd.Next(1, 500001);

                    if (i <= 100000)
                    {
                        storage1Context.Friends.Add(new Friends { User_Id = i + 1, Friend_Id = friendId });
                        storage1Context.SaveChanges();
                        arrayNumberFriends[i]++;
                    }
                    else if (i > 100000 && i < 200000)
                    {
                        storage2Context.Friends.Add(new Friends { User_Id = i, Friend_Id = friendId });
                        storage2Context.SaveChanges();
                        arrayNumberFriends[i]++;
                    }
                    else if (i > 200000 && i < 300000)
                    {
                        storage3Context.Friends.Add(new Friends { User_Id = i, Friend_Id = friendId });
                        storage3Context.SaveChanges();
                        arrayNumberFriends[i]++;
                    }
                    else if (i > 300000 && i < 400000)
                    {
                        storage4Context.Friends.Add(new Friends { User_Id = i, Friend_Id = friendId });
                        storage4Context.SaveChanges();
                        arrayNumberFriends[i]++;
                    }
                    else if (i > 400000 && i < 500000)
                    {
                        storage5Context.Friends.Add(new Friends { User_Id = i, Friend_Id = friendId });
                        storage5Context.SaveChanges();
                        arrayNumberFriends[i]++;
                    }

                    if (friendId > 1 && friendId < 100000)
                    {
                        storage1Context.Friends.Add(new Friends { User_Id = friendId, Friend_Id = (i <= 100000) ? i + 1 : i });
                        storage1Context.SaveChanges();
                        arrayNumberFriends[friendId]++;
                    }
                    else if (friendId > 100000 && friendId < 200000)
                    {
                        storage2Context.Friends.Add(new Friends { User_Id = friendId, Friend_Id = (i <= 100000) ? i + 1 : i });
                        storage2Context.SaveChanges();
                        arrayNumberFriends[friendId]++;
                    }
                    else if (friendId > 200000 && friendId < 300000)
                    {
                        storage3Context.Friends.Add(new Friends { User_Id = friendId, Friend_Id = (i <= 100000) ? i + 1 : i });
                        storage3Context.SaveChanges();
                        arrayNumberFriends[friendId]++;
                    }
                    else if (friendId > 300000 && friendId < 400000)
                    {
                        storage4Context.Friends.Add(new Friends { User_Id = friendId, Friend_Id = (i <= 100000) ? i + 1 : i });
                        storage4Context.SaveChanges();
                        arrayNumberFriends[friendId]++;
                    }
                    else if (friendId > 400000 && friendId < 500000)
                    {
                        storage5Context.Friends.Add(new Friends { User_Id = friendId, Friend_Id = (i <= 100000) ? i + 1 : i });
                        storage5Context.SaveChanges();
                        arrayNumberFriends[friendId]++;
                    }
                }
            }
        }
        /// <summary>
        /// Determine the database with which it is necessary to make the connection.
        /// The method for the modal form.
        /// </summary>
        /// <param name="userId">User ID.</param>
        /// <param name="frm">An instance of a modal form.</param>
        private void Connected(int userId, InfoWindow frm)
        {
            try
            {
                var localDb = new DataBase();

                if (userId <= 100000)
                {
                    using (var context = new Storage1Context())
                    {
                        localDb.ConnectToServer1(context, userId, _services, _logging, _friend, lstFriends, frm);
                    }
                }
                else if (userId > 100000 && userId <= 200000)
                {
                    using (var context = new Storage2Context())
                    {
                        localDb.ConnectToServer2(context, userId, _services, _logging, _friend, lstFriends, frm);
                    }
                }
                else if (userId > 200000 && userId <= 300000)
                {
                    using (var context = new Storage3Context())
                    {
                        localDb.ConnectToServer3(context, userId, _services, _logging, _friend, lstFriends, frm);
                    }
                }
                else if (userId > 300000 && userId <= 400000)
                {
                    using (var context = new Storage4Context())
                    {
                        localDb.ConnectToServer4(context, userId, _services, _logging, _friend, lstFriends, frm);
                    }
                }
                else if (userId > 400000 && userId <= 500000)
                {
                    using (var context = new Storage5Context())
                    {
                        localDb.ConnectToServer5(context, userId, _services, _logging, _friend, lstFriends, frm);
                    }
                }
            }
            catch (ArgumentOutOfRangeException ex)
            {
                _logging.ProcessingException(ex);
                MessageBox.Show(ex.Message, "Connection error", MessageBoxButton.OK, MessageBoxImage.Error);
            }
        }
        /// <summary>
        /// Event: Get detailed information about a friend.
        /// </summary>
        /// <param name="sender">Sender</param>
        /// <param name="e">Event Args</param>
        private void lstFriends_MouseDoubleClick(object sender, MouseButtonEventArgs e)
        {
            #region The code required for diagnosis - measures the time
            var spectator = new Stopwatch();
            spectator.Start();
            #endregion

            if (lstFriends.SelectedItem == null)
                return;

            var userId = _listOfFriends[lstFriends.SelectedIndex];
            var frm = new InfoWindow {ShowInTaskbar = false /* Do not show on the taskbar. */};

            if (userId <= 100000)
            {
                using (var context = new Storage1Context())
                {
                    ConnectToServer1(context, userId, frm);
                }
            }
            else if (userId > 100000 && userId < 200000)
            {
                using (var context = new Storage2Context())
                {
                    ConnectToServer2(context, userId, frm);
                }
            }
            else if (userId > 200000 && userId < 300000)
            {
                using (var context = new Storage3Context())
                {
                    ConnectToServer3(context, userId, frm);
                }
            }
            else if (userId > 300000 && userId < 400000)
            {
                using (var context = new Storage4Context())
                {
                    ConnectToServer4(context, userId, frm);
                }
            }
            else if (userId > 400000 && userId < 500000)
            {
                using (var context = new Storage5Context())
                {
                    ConnectToServer5(context, userId, frm);
                }
            }

            #region The code required for diagnosis - measures the time
            spectator.Stop();
            var ts = spectator.Elapsed;
            frm.TimeParam = $"Lead time: {ts.Hours:00}:{ts.Minutes:00}:{ts.Seconds:00}.{ts.Milliseconds/10:00}";
            #endregion
            frm.Show();
        }
        /// <summary>
        /// The connection method to Storage5.
        /// Called from an event handler lstFriends_MouseDoubleClick.
        /// </summary>
        /// <param name="context">The context of the interaction with the database.</param>
        /// <param name="userId">User ID.</param>
        /// <param name="frm">Instance a modal window.</param>
        private void ConnectToServer5(Storage5Context context, int userId, InfoWindow frm)
        {
            RedisOrSQLStorage5(context, userId, frm);

            var queryFriendsStorage = context.Friends.Where(x => x.User_Id == userId);
            var friends = queryFriendsStorage.ToList();
            foreach (var f in friends)
            {
                if (f.Friend_Id < 100000)
                {
                    using (var storage1Context = new Storage1Context())
                    {
                        frm.FriendsParam = FindFriendsStorage1(storage1Context, f, frm);
                    }
                }
                else if (f.Friend_Id > 100000 && f.Friend_Id < 200000)
                {
                    using (var storage2Context = new Storage2Context())
                    {
                        frm.FriendsParam = FindFriendsStorage2(storage2Context, f, frm);
                    }
                }
                else if (f.Friend_Id > 200000 && f.Friend_Id < 300000)
                {
                    using (var storage3Context = new Storage3Context())
                    {
                        frm.FriendsParam = FindFriendsStorage3(storage3Context, f, frm);
                    }
                }
                else if (f.Friend_Id > 300000 && f.Friend_Id < 400000)
                {
                    using (var storage4Context = new Storage4Context())
                    {
                        frm.FriendsParam = FindFriendsStorage4(storage4Context, f, frm);
                    }
                }
                else if (f.Friend_Id > 400000 && f.Friend_Id < 500000)
                {
                    frm.FriendsParam = FindFriendsStorage5(context, f, frm);
                }
            }
        }
 /// <summary>
 /// Methods of forming a string name = Last Name + First Name, which will be added to the list.
 /// Called from the methods GetUserInfoFromStorage.
 /// </summary>
 /// <param name="context">The context of the interaction with the database.</param>
 /// <param name="f">The object to be added.</param>
 /// <param name="frm">Instance a modal window.</param>
 private static string FindFriendsStorage2(Storage2Context context, Friends f, InfoWindow frm)
 {
     var queryFriend = context.User.Where(x => x.Id == f.Friend_Id);
     var elementToAdd = queryFriend.ToList();
     frm.ListOfFriendsParam = elementToAdd[0].Id;
     return (elementToAdd[0].Last_Name + ' ' + elementToAdd[0].First_Name);
 }
        /// <summary>
        /// Check Method cached user in Redis or not.
        /// If the user is not cached in Redis then its cache.
        /// Called from the method ConnectToServer (modal).
        /// </summary>
        /// <param name="context">The context of the interaction with the database.</param>
        /// <param name="userId">User ID.</param>
        /// <param name="frm">Instance a modal window.</param>
        private void RedisOrSQLStorage2(Storage2Context context, int userId, InfoWindow frm)
        {
            IDatabase db = null;
            if (_redisIsStarted)
            {
                using (var redisClient = ConnectionMultiplexer.Connect("localhost"))
                {
                    db = redisClient.GetDatabase();
                    string value = db.StringGet($"user:{userId}");

                    if (string.IsNullOrEmpty(value))
                    {
                        var queryUserStorage = context.User.Where(x => x.Id == userId);
                        GetDataFromSQL(queryUserStorage, db, true, frm);
                    }
                    else
                    {
                        GetDataFromRedis(value, frm);
                    }
                }
            }
            else
            {
                var queryUserStorage = context.User.Where(x => x.Id == userId);
                GetDataFromSQL(queryUserStorage, db, false, frm);
            }
        }
        /// <summary>
        /// The connection method to Storage4 (modal).
        /// Called from an event handler lstFriends_MouseDoubleClick.
        /// </summary>
        /// <param name="context">The context of the interaction with the database.</param>
        /// <param name="userId">User ID.</param>
        /// <param name="services">Services class object to check - whether our services work.</param>
        /// <param name="logging">Logging class object to create the log.</param>
        /// <param name="friend">User friend.</param>
        /// <param name="lstFriends">ListBox control where your friends list will be added.</param>
        /// <param name="frm">Instance a modal window.</param>
        public void ConnectToServer4(Storage4Context context, int userId, Services services, Logging logging, Friend friend, System.Windows.Controls.ListBox lstFriends, InfoWindow frm)
        {
            RedisOrSQLStorage4(context, userId, services, logging, frm);

            var queryFriendsStorage = context.Friends.Where(x => x.User_Id == userId);
            var friends = queryFriendsStorage.ToList();
            foreach (var f in friends)
            {
                if (f.Friend_Id < 100000)
                {
                    using (var storage1Context = new Storage1Context())
                    {
                        frm.FriendsParam = friend.FindFriendsStorage1(storage1Context, f, frm);
                    }
                }
                else if (f.Friend_Id > 100000 && f.Friend_Id < 200000)
                {
                    using (var storage2Context = new Storage2Context())
                    {
                        frm.FriendsParam = friend.FindFriendsStorage2(storage2Context, f, frm);
                    }
                }
                else if (f.Friend_Id > 200000 && f.Friend_Id < 300000)
                {
                    using (var storage3Context = new Storage3Context())
                    {
                        frm.FriendsParam = friend.FindFriendsStorage3(storage3Context, f, frm);
                    }
                }
                else if (f.Friend_Id > 300000 && f.Friend_Id < 400000)
                {
                    frm.FriendsParam = friend.FindFriendsStorage4(context, f, frm);
                }
                else if (f.Friend_Id > 400000 && f.Friend_Id < 500000)
                {
                    using (var storage5Context = new Storage5Context())
                    {
                        frm.FriendsParam = friend.FindFriendsStorage5(storage5Context, f, frm);
                    }
                }
            }
        }
        /// <summary>
        /// The connection method to Storage5.
        /// Called from an event handler btnConnected_Click.
        /// </summary>
        /// <param name="context">The context of the interaction with the database.</param>
        /// <param name="userId">User ID.</param>
        /// <param name="listOfFriends">User's friends list.</param>
        /// <param name="services">Services class object to check - whether our services work.</param>
        /// <param name="logging">Logging class object to create the log.</param>
        /// <param name="friend">User friend.</param>
        /// <param name="view">View class object to display the changes.</param>
        /// <param name="textboxs">An array of text fields to fill.</param>
        /// <param name="lstFriends">ListBox control where your friends list will be added.</param>
        public void ConnectToServer5(Storage5Context context, int userId, List<int> listOfFriends, Services services, Logging logging, Friend friend, View.View view, System.Windows.Controls.TextBox[] textboxs, System.Windows.Controls.ListBox lstFriends)
        {
            RedisOrSQLStorage5(context, userId, services, logging, view, textboxs);

            var queryFriendsStorage = context.Friends.Where(x => x.User_Id == userId);
            var friends = queryFriendsStorage.ToList();
            foreach (var f in friends)
            {
                if (f.Friend_Id < 100000)
                {
                    using (var storage1Context = new Storage1Context())
                    {
                        lstFriends.Items.Add(friend.FindFriendsStorage1(storage1Context, f, listOfFriends));
                    }
                }
                else if (f.Friend_Id > 100000 && f.Friend_Id < 200000)
                {
                    using (var storage2Context = new Storage2Context())
                    {
                        lstFriends.Items.Add(friend.FindFriendsStorage2(storage2Context, f, listOfFriends));
                    }
                }
                else if (f.Friend_Id > 200000 && f.Friend_Id < 300000)
                {
                    using (var storage3Context = new Storage3Context())
                    {
                        lstFriends.Items.Add(friend.FindFriendsStorage3(storage3Context, f, listOfFriends));
                    }
                }
                else if (f.Friend_Id > 300000 && f.Friend_Id < 400000)
                {
                    using (var storage4Context = new Storage4Context())
                    {
                        lstFriends.Items.Add(friend.FindFriendsStorage4(storage4Context, f, listOfFriends));
                    }
                }
                else if (f.Friend_Id > 400000 && f.Friend_Id < 500000)
                {
                    lstFriends.Items.Add(friend.FindFriendsStorage5(context, f, listOfFriends));
                }
            }
        }
        /// <summary>
        /// Check Method cached user in Redis or not.
        /// If the user is not cached in Redis then its cache.
        /// Called from the method ConnectToServer.
        /// </summary>
        /// <param name="context">The context of the interaction with the database.</param>
        /// <param name="userId">User ID.</param>
        /// <param name="services">Services class object to check - whether our services work.</param>
        /// <param name="logging">Logging class object to create the log.</param>
        /// <param name="view">View class object to display the changes.</param>
        /// <param name="textboxs">An array of text fields to fill.</param>
        private static void RedisOrSQLStorage2(Storage2Context context, int userId, Services services, Logging logging, View.View view, System.Windows.Controls.TextBox[] textboxs)
        {
            IDatabase db = null;
            if (services.RedisIsStarted)
            {
                using (var redisClient = ConnectionMultiplexer.Connect("localhost"))
                {
                    db = redisClient.GetDatabase();
                    string value = db.StringGet($"user:{userId}");

                    if (string.IsNullOrEmpty(value))
                    {
                        var queryUserStorage = context.User.Where(x => x.Id == userId);
                        GetDataFromSQL(queryUserStorage, db, true, logging, view, textboxs);
                    }
                    else
                    {
                        GetDataFromRedis(value, view, textboxs);
                    }
                }
            }
            else
            {
                var queryUserStorage = context.User.Where(x => x.Id == userId);
                GetDataFromSQL(queryUserStorage, db, false, logging, view, textboxs);
            }
        }