コード例 #1
0
ファイル: SearchRepository.cs プロジェクト: jdehlin/Twitta
        public IList <Search> GetItems(SearchDependencies?dependencies = null)
        {
            using (_connection = Utilities.Database.GetProfiledOpenConnection())
            {
                var result = _connection.GetList <Search>().ToList();
                if (result.Any() && dependencies != null)
                {
                    if ((dependencies & SearchDependencies.Logs) == SearchDependencies.Logs)
                    {
                        List <SearchHistoryLog> Logs = null;
                        var searchIds = (from s in result let searchId = s.SearchId select searchId).ToList();
                        if (searchIds.Any())
                        {
                            Logs = _searchHistoryLogRepository.GetItems(searchIds).ToList();
                        }

                        if (Logs != null && Logs.Any())
                        {
                            foreach (var search in result)
                            {
                                search.Logs    = Logs.FindAll(s => s.SearchId == search.SearchId).ToList();
                                search.LastLog = search.Logs.OrderByDescending(l => l.SearchDate).FirstOrDefault();
                            }
                        }
                    }
                }
                return(result.ToList());
            }
        }