/// <summary> /// Get all channels from the database /// </summary> private void RefreshAllChannels() { Cursor.Current = Cursors.WaitCursor; IList <Card> dbsCards = Card.ListAll(); _cards = new Dictionary <int, CardType>(); foreach (Card card in dbsCards) { _cards[card.IdCard] = RemoteControl.Instance.Type(card.IdCard); } SqlBuilder sb = new SqlBuilder(StatementType.Select, typeof(Channel)); sb.AddConstraint(Operator.Equals, "isTv", true); sb.AddOrderByField(true, "sortOrder"); SqlStatement stmt = sb.GetStatement(true); _allChannels = ObjectFactory.GetCollection <Channel>(stmt.Execute()); tabControl1.TabPages[0].Text = string.Format("Channels ({0})", _allChannels.Count); _lvChannelHandler = new ChannelListViewHandler(mpListView1, _allChannels, _cards, txtFilterString, ChannelType.Tv); _lvChannelHandler.FilterListView(""); }