예제 #1
0
        public RSSItemDTO[] GetAllRSSItems(int tabid)
        {
            List <RSSItemDTO> listOfItem = new List <RSSItemDTO>();

            try
            {
                RSSDBDataContext data = new RSSDBDataContext();

                int        currentUserID  = GetCurrentUserID();
                List <Tab> listOfTab_test = (from tab in data.Tabs
                                             where tab.ID == tabid && tab.UserID == currentUserID
                                             select tab).ToList();
                List <Share> listOfShare_test = (from share in data.Shares
                                                 where share.TabID == tabid && share.AccountID == currentUserID
                                                 select share).ToList();
                if (listOfShare_test.Count == 0 && listOfTab_test.Count == 0)
                {
                    listOfItem = new List <RSSItemDTO>();
                    return(listOfItem.ToArray());
                }

                List <RSSItem> list = (from rssItem in data.RSSItems
                                       where rssItem.TabID == tabid
                                       select rssItem).ToList();
                foreach (RSSItem item in list)
                {
                    RSSItemDTO temp = new RSSItemDTO();
                    temp.Id          = item.ID;
                    temp.Name        = item.Name;
                    temp.Description = item.Description;
                    temp.RSSLink     = item.RSSLink;
                    temp.TabID       = item.TabID;
                    listOfItem.Add(temp);
                }
            }
            catch
            {
                listOfItem = null;
            }
            finally
            {
            }
            return(listOfItem.ToArray());
        }
        public RSSItemDTO[] GetAllRSSItems(int tabid)
        {
            List<RSSItemDTO> listOfItem = new List<RSSItemDTO>();
            try
            {
                RSSDBDataContext data = new RSSDBDataContext();

                int currentUserID = GetCurrentUserID();
                List<Tab> listOfTab_test = (from tab in data.Tabs
                                            where tab.ID == tabid && tab.UserID == currentUserID
                                            select tab).ToList();
                List<Share> listOfShare_test = (from share in data.Shares
                                                where share.TabID == tabid && share.AccountID == currentUserID
                                                select share).ToList();
                if (listOfShare_test.Count == 0 && listOfTab_test.Count == 0)
                {
                    listOfItem = new List<RSSItemDTO>();
                    return listOfItem.ToArray();
                }

                List<RSSItem> list = (from rssItem in data.RSSItems
                                      where rssItem.TabID == tabid
                                      select rssItem).ToList();
                foreach (RSSItem item in list)
                {
                    RSSItemDTO temp = new RSSItemDTO();
                    temp.Id = item.ID;
                    temp.Name = item.Name;
                    temp.Description = item.Description;
                    temp.RSSLink = item.RSSLink;
                    temp.TabID = item.TabID;
                    listOfItem.Add(temp);
                }
            }
            catch
            {
                listOfItem = null;
            }
            finally
            {

            }
            return listOfItem.ToArray();
        }