public static void UpdateMemberInfo(Member OldMember, Member NewMember)
        {
            string UpdateRequest = DataBaseCommands.UpdateMemberInfo(OldMember, NewMember);


            command = new SQLiteCommand(UpdateRequest, connection);


            try
            {
                connection.Open();
                command.ExecuteNonQuery();
                connection.Close();
            }
            catch (Exception e)
            {
                MessageBox.Show("Error: " + e.Message);
            }
        }
        public static void RemoveMemberFromDB(string GroupName, Member member)
        {
            string DeleteRequest = DataBaseCommands.RemoveMember(GroupName, member);


            command = new SQLiteCommand(DeleteRequest, connection);


            try
            {
                connection.Open();
                command.ExecuteNonQuery();
                connection.Close();
            }
            catch (Exception e)
            {
                MessageBox.Show("Error: " + e.Message);
            }
        }
        public static void UpdateMemberInfo(string Key, string Value, string InitKey, string InitValue)
        {
            string UpdateRequest = DataBaseCommands.UpdateMemberInfo(Key, Value, InitKey, InitValue);


            command = new SQLiteCommand(UpdateRequest, connection);


            try
            {
                connection.Open();
                command.ExecuteNonQuery();
                connection.Close();
            }
            catch (Exception e)
            {
                MessageBox.Show("Error: " + e.Message);
            }
        }
        public static void AddMemberToDB(string GroupName, Member member)
        {
            string AddMemberCommand = DataBaseCommands.CreateTableListMembers();
            string request          = DataBaseCommands.InsertMemberIntoTable(GroupName, member);


            command  = new SQLiteCommand(AddMemberCommand, connection);
            command1 = new SQLiteCommand(request, connection);


            try
            {
                connection.Open();
                command.ExecuteNonQuery();
                command1.ExecuteNonQuery();
                connection.Close();
            }
            catch (Exception e)
            {
                MessageBox.Show("Error: " + e.Message);
            }
        }
        public static void FirstInitialize()
        {
            if (!File.Exists(database))
            {
                SQLiteConnection.CreateFile(database);
            }


            string StartCommand = DataBaseCommands.CreateTableListMembers();
            string request      = DataBaseCommands.SelectAll();


            command  = new SQLiteCommand(StartCommand, connection);
            command1 = new SQLiteCommand(request, connection);


            try
            {
                connection.Open();

                command.ExecuteNonQuery();

                using (DbDataReader reader = command1.ExecuteReader())
                {
                    string GroupName, _VusNumber, _FIO,
                           _rank, _YearOfBirth, _HomeAddress,
                           _PlaceOfWork, _TurnoutAddress, _Company;

                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            GroupName       = reader.GetString(0);
                            _VusNumber      = reader.GetString(1);
                            _FIO            = reader.GetString(2);
                            _rank           = reader.GetString(3);
                            _YearOfBirth    = reader.GetString(4).Split(' ')[0];
                            _HomeAddress    = reader.GetString(5);
                            _PlaceOfWork    = reader.GetString(6);
                            _TurnoutAddress = reader.GetString(7);
                            _Company        = reader.GetString(8);

                            GroupsArray.LastGroupName = GroupName;


                            if (!GroupsArray.IsCreated(GroupName))
                            {
                                GroupsArray.CreateNewGroup(GroupName);
                                EditableControls.GroupList.Items.Add(GroupName);
                            }


                            var member = new Member()
                            {
                                VusNumber      = _VusNumber,
                                FIO            = _FIO,
                                Rank           = _rank,
                                YearOfBirth    = _YearOfBirth,
                                HomeAddress    = _HomeAddress,
                                PlaceOfWork    = _PlaceOfWork,
                                TurnoutAddress = _TurnoutAddress,
                                Company        = _Company
                            };

                            GroupsArray.AddMemberToTheGroup(GroupsArray.LastGroupName, member);

                            Group group = GroupsArray.FindGroup(GroupsArray.LastGroupName);

                            if (!EditableControls.IsContained(GroupsArray.LastGroupName))
                            {
                                EditableControls.CreateNewTab(group);
                            }
                            else
                            {
                                EditableControls.AddMemberToTab(GroupsArray.LastGroupName, member);
                            }
                        }
                    }
                }
                connection.Close();
            }
            catch (Exception e)
            {
                MessageBox.Show("Error: " + e.Message);
            }
        }