Changeset 154
- Timestamp:
- 03/08/07 19:09:50 (2 years ago)
- Files:
-
- dmp/trunk/client/wpfclient/SongViewer.cs (modified) (3 diffs)
- dmp/trunk/client/wpfclient/main_window.xaml (modified) (1 diff)
- dmp/trunk/client/wpfclient/main_window.xaml.cs (modified) (4 diffs)
- dmp/trunk/daap-sharp/BridgeDatabase.cs (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
dmp/trunk/client/wpfclient/SongViewer.cs
r148 r154 38 38 } 39 39 40 private DataView currentView = new DataView();40 private DataView currentView; 41 41 public DataView CurrentView { 42 42 get { return currentView; } … … 55 55 HighlightedRow.LibId = -1; 56 56 HighlightedRow.LastIndex = -1; 57 58 currentView = SongDT.DefaultView; 57 59 } 58 60 … … 358 360 void SortOnColName(string colName) 359 361 { 362 if(currentView.Count==0) 363 return; 364 360 365 if(colName == currentSortCol){ 361 366 if(Ascending){ dmp/trunk/client/wpfclient/main_window.xaml
r148 r154 33 33 </StackPanel> 34 34 35 <TextBox Width=" 60" Height="20" Margin="5" Name="SearchBox" Grid.Row="0" Grid.Column="2"/>35 <TextBox Width="100" Height="20" Margin="5" Name="SearchBox" Grid.Row="0" Grid.Column="2"/> 36 36 37 37 <StackPanel Name="serverStack" Grid.Row="1" Grid.Column="0" Margin="5"> dmp/trunk/client/wpfclient/main_window.xaml.cs
r148 r154 2 2 using System.Collections.Generic; 3 3 using System.Text; 4 using System.Threading; 4 5 using System.Windows; 5 6 using System.Windows.Controls; … … 42 43 myBridge.ServerAdded += serverAdded; 43 44 myBridge.ServerRemoved += serverRemoved; 45 myBridge.SongListChanged += DataTableChanged; 44 46 myBridge.StartZeroConf(); 45 47 … … 47 49 songView.HorizScrollBar = horizScroll; 48 50 49 songView.SongDT = createTestTable();51 //songView.SongDT = createTestTable(); 50 52 51 53 songView.AddColumn("Title"); … … 193 195 } 194 196 197 Queue<string> serverAddQueue = new Queue<string>(); 195 198 private void OnServerAdd(object sender, MouseButtonEventArgs args){ 196 199 Button source = (Button)sender; 197 MessageBox.Show("Server "+(string)source.Content+" added!"); 200 //(string)source.Content; 201 202 lock(serverAddQueue){ 203 serverAddQueue.Enqueue((string)source.Content); 204 } 205 Thread newThread = new Thread(TServerAdd); 206 newThread.Start(); 207 } 208 209 void TServerAdd(){ 210 string serverName; 211 212 lock(serverAddQueue){ 213 serverName = serverAddQueue.Dequeue(); 214 } 215 216 myBridge.AddServerConnection(serverName); 198 217 } 199 218 dmp/trunk/daap-sharp/BridgeDatabase.cs
r152 r154 246 246 /// <returns>The libary ID if it's in the database, -1 otherwise</returns> 247 247 public int getLibraryIdForName(string libName) { 248 string commandText = "SELECT id FROM libraries WHERE name = @name"; 249 SQLiteDataAdapter adapter = new SQLiteDataAdapter(commandText, this.databaseConnection); 250 adapter.SelectCommand.Parameters.Add("name", DbType.String).Value = libName; 251 DataTable tempTable = new DataTable(); 252 this.databaseConnection.Open(); 253 adapter.Fill(tempTable); 254 this.databaseConnection.Close(); 255 if (tempTable.Rows.Count <= 0) { 256 return -1; 248 IDbCommand cmd = databaseConnection.CreateCommand(); 249 250 cmd.CommandText = "SELECT id FROM libraries WHERE name = ?"; 251 IDataParameter serverName = cmd.CreateParameter(); 252 cmd.Parameters.Add(serverName); 253 254 serverName.Value=libName; 255 256 int libId = -1; 257 258 databaseConnection.Open(); 259 try{ 260 libId = (int)cmd.ExecuteScalar(); 261 } 262 catch(Exception e) {} 263 finally { 264 databaseConnection.Close(); 257 265 } 258 else { 259 int libraryId = (int)tempTable.Rows[0]["id"]; 260 return libraryId; 261 } 266 267 return libId; 262 268 } 263 269
