public static void Load()
{
using (SQLiteConnection conn = LocalStorage.DataBaseUtility.GetConnection())
{
conn.Open();
using (SQLiteCommand comm = new SQLiteCommand(conn))
{
comm.CommandText = "SELECT groupname, userid, exclusive, users.screenname FROM usersInGroups INNER JOIN users ON usersInGroups.userid = users.id";
using (SQLiteDataReader r = comm.ExecuteReader())
{
while (r.Read())
{
string groupName = r.GetString(0);
string userID = r.GetString(1);
bool exclusive = r.GetBoolean(2);
string screenName = r.GetString(3);
SpecialTimeLine thisLine = new SpecialTimeLine();
if (_Items.ContainsKey(groupName))
{
thisLine = _Items[groupName];
}
else
{
thisLine.name = groupName;
Add(thisLine);
}
thisLine.AddItem(userID,screenName, exclusive);
}
}
}
}
}
private void AddUserToGroup(SpecialTimeLine t, bool Exclusive)
{
FingerUI.StatusItem selectedItem = (FingerUI.StatusItem)statList.SelectedItem;
if (selectedItem == null) { return ; }
if (selectedItem.Tweet.user == null) { return; }
string Message = "";
switch (Exclusive)
{
case true:
Message="This will move "+selectedItem.Tweet.user.screen_name+
" out of the Friends timeline and into the " + t.name +
" group.\n\nAre you sure you want to proceed?";
break;
case false:
Message = "This will copy " + selectedItem.Tweet.user.screen_name +
" into the " + t.name + " group and still show them in the Friends timeline.\n\n" +
"Are you sure you want to proceed?";
break;
}
if (MessageBox.Show(Message, "Group " + selectedItem.Tweet.user.screen_name, MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
t.AddItem(selectedItem.Tweet.user.id, selectedItem.Tweet.user.screen_name, Exclusive);
SpecialTimeLines.Save();
}
if(Exclusive)
{
Cursor.Current = Cursors.WaitCursor;
ReloadTimeLine();
Cursor.Current = Cursors.Default;
}
}
