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