예제 #1
0
        /// <summary>
        /// 検索処理の実行
        /// </summary>
        /// <returns></returns>
        private async Task ExecuteSearch()
        {
            try
            {
                EnableProcessingMode();

                // DBが古い場合はアップグレードする
                if (DatabaseMigration.GetCurrentVersion() < DatabaseContext.Version)
                {
                    DatabaseMigration.UpgradeDatabase();
                }

                var parameter = new ActivityLogSearchParameter
                {
                    IsJoinedRoom                    = joinCheckBox.IsChecked ?? false,
                    IsMetPlayer                     = meetCheckBox.IsChecked ?? false,
                    IsSendInvite                    = sendInvCheckBox.IsChecked ?? false,
                    IsSendRequestInvite             = sendReqInvCheckBox.IsChecked ?? false,
                    IsReceivedInvite                = recvInvCheckBox.IsChecked ?? false,
                    IsReceivedRequestInvite         = recvReqInvCheckBox.IsChecked ?? false,
                    IsSendFriendRequest             = sendFriendReqCheckBox.IsChecked ?? false,
                    IsReceivedFriendRequest         = recvFriendReqCheckBox.IsChecked ?? false,
                    IsAcceptFriendRequest           = acptFriendReqCheckBox.IsChecked ?? false,
                    FromDateTime                    = fromDatePicker.SelectedDate,
                    UntilDateTime                   = untilDatePicker.SelectedDate?.AddDays(1),
                    IsReceivedInviteResponse        = recvInvResCheckBox.IsChecked ?? false,
                    IsReceivedRequestInviteResponse = recvReqInvResCheckBox.IsChecked ?? false,
                    IsPlayedVideo                   = videoCheckBox.IsChecked ?? false,
                };
                var activityLogs = await VRChatActivityLogModel.SearchActivityLogs(parameter);

                var keywords = keywordBox.Text.Split(' ').Where(s => s != string.Empty).ToArray();

                ActivityLogGridModelCollection.Clear();

                foreach (var activityLog in activityLogs)
                {
                    var gridModel = new ActivityLogGridModel(activityLog);

                    if (keywords.Any())
                    {
                        var contained = keywords.All(k => gridModel.Content?.Contains(k, StringComparison.CurrentCultureIgnoreCase) ?? false);
                        if (!contained)
                        {
                            continue;
                        }
                    }

                    ActivityLogGridModelCollection.Add(gridModel);
                }

                DisableProcessingMode();
            }
            catch (Exception)
            {
                MessageBox.Show("エラーが発生しました。プログラムを終了します。", "VRChatActivityLogViewer", MessageBoxButton.OK, MessageBoxImage.Error);
                Application.Current.Shutdown();
            }
        }
        /// <summary>
        /// アクティビティを検索する
        /// </summary>
        /// <param name="parameter"></param>
        /// <returns></returns>
        public static async Task <List <ActivityLog> > SearchActivityLogs(ActivityLogSearchParameter parameter)
        {
            return(await Task.Run(() =>
            {
                var searchActivityTypes = new List <ActivityType>();
                if (parameter.IsJoinedRoom)
                {
                    searchActivityTypes.Add(ActivityType.JoinedRoom);
                }
                if (parameter.IsMetPlayer)
                {
                    searchActivityTypes.Add(ActivityType.MetPlayer);
                }
                if (parameter.IsSendInvite)
                {
                    searchActivityTypes.Add(ActivityType.SendInvite);
                }
                if (parameter.IsSendRequestInvite)
                {
                    searchActivityTypes.Add(ActivityType.SendRequestInvite);
                }
                if (parameter.IsReceivedInvite)
                {
                    searchActivityTypes.Add(ActivityType.ReceivedInvite);
                }
                if (parameter.IsReceivedRequestInvite)
                {
                    searchActivityTypes.Add(ActivityType.ReceivedRequestInvite);
                }
                if (parameter.IsSendFriendRequest)
                {
                    searchActivityTypes.Add(ActivityType.SendFriendRequest);
                }
                if (parameter.IsReceivedFriendRequest)
                {
                    searchActivityTypes.Add(ActivityType.ReceivedFriendRequest);
                }
                if (parameter.IsAcceptFriendRequest)
                {
                    searchActivityTypes.Add(ActivityType.AcceptFriendRequest);
                }

                List <ActivityLog> activityLogs = new List <ActivityLog>();
                using (var db = new DatabaseContext())
                {
                    activityLogs = db.ActivityLogs
                                   .Where(a => searchActivityTypes.Contains(a.ActivityType))
                                   .Where(a => a.Timestamp >= parameter.FromDateTime)
                                   .Where(a => a.Timestamp < parameter.UntilDateTime)
                                   .OrderByDescending(a => a.Timestamp)
                                   .ToList();
                }
                return activityLogs;
            }));
        }
예제 #3
0
        /// <summary>
        /// Searchボタンクリック時のイベント
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private async void searchButton_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                EnableProcessingMode();

                var parameter = new ActivityLogSearchParameter
                {
                    IsJoinedRoom            = joinCheckBox.IsChecked ?? false,
                    IsMetPlayer             = meetCheckBox.IsChecked ?? false,
                    IsSendInvite            = sendInvCheckBox.IsChecked ?? false,
                    IsSendRequestInvite     = sendReqInvCheckBox.IsChecked ?? false,
                    IsReceivedInvite        = recvInvCheckBox.IsChecked ?? false,
                    IsReceivedRequestInvite = recvReqInvCheckBox.IsChecked ?? false,
                    IsSendFriendRequest     = sendFriendReqCheckBox.IsChecked ?? false,
                    IsReceivedFriendRequest = recvFriendReqCheckBox.IsChecked ?? false,
                    IsAcceptFriendRequest   = acptFriendReqCheckBox.IsChecked ?? false,
                    FromDateTime            = fromDatePicker.SelectedDate,
                    UntilDateTime           = untilDatePicker.SelectedDate?.AddDays(1),
                };
                var activityLogs = await VRChatActivityLogModel.SearchActivityLogs(parameter);

                ActivityLogGridModelCollection.Clear();
                foreach (var activityLog in activityLogs)
                {
                    ActivityLogGridModelCollection.Add(new ActivityLogGridModel(activityLog));
                }

                DisableProcessingMode();
            }
            catch (Exception)
            {
                MessageBox.Show("エラーが発生しました。プログラムを終了します。", "VRChatActivityLogViewer");
                Application.Current.Shutdown();
            }
        }