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(); }