private void btn_Remotes_Add_Click(object sender, RoutedEventArgs e) { btn_Settings_Remotes_Edit_Accept.Content = GetLocalizedString(14); ApiHelper.Instance().FillApiComboBox(lst_Settings_Remotes_Edit_Api, null); _remoteInfoEdit = new Yatse2Remote { OS = "Unknown" }; grd_Settings_Remotes_Edit.DataContext = _remoteInfoEdit; grd_Settings_Remotes_Edit.Visibility = Visibility.Visible; //_yatse2Properties.ShowSettingsRemotesEdit = true; }
public Yatse2Remote FillRemoteByComboIndex(Yatse2Remote remote, int index) { if (remote == null) return remote; remote.Api = _remotePlugins[index].Name; remote.ProcessName = "NotNeeded"; return remote; }
public long InsertRemote(Yatse2Remote remote) { if (remote == null) return 0; var sqlCmd = _dbConnection.CreateCommand(); sqlCmd.CommandText = @"INSERT INTO `Remotes` ( Name, Api, ProcessName, IP, Port, MacAddress, Login, Password, Version, Os, Additional, CacheFilled) VALUES ( ?,?,?,?,?,?,?,?,?,?,?,?);"; sqlCmd.Parameters.AddWithValue("a1", remote.Name); sqlCmd.Parameters.AddWithValue("a2", remote.Api); sqlCmd.Parameters.AddWithValue("a3", remote.ProcessName); sqlCmd.Parameters.AddWithValue("a4", remote.IP); sqlCmd.Parameters.AddWithValue("a5", remote.Port); sqlCmd.Parameters.AddWithValue("a6", remote.MacAddress); sqlCmd.Parameters.AddWithValue("a7", remote.Login); sqlCmd.Parameters.AddWithValue("a8", remote.Password); sqlCmd.Parameters.AddWithValue("a9", remote.Version); sqlCmd.Parameters.AddWithValue("a10", remote.OS); sqlCmd.Parameters.AddWithValue("a11", remote.Additional); sqlCmd.Parameters.AddWithValue("a12", remote.CacheFilled); return QueryInsert(sqlCmd); }
private Collection<Yatse2Remote> QueryRemote(SQLiteCommand query) { var remotes = new Collection<Yatse2Remote>(); if (!_connected) return remotes; try { LogQuery(query); var sqldReader = query.ExecuteReader(); while (sqldReader.Read()) { var remote = new Yatse2Remote { Id = GetLong(sqldReader, "Id"), Name = GetString(sqldReader, "Name"), Api = GetString(sqldReader, "Api"), ProcessName = GetString(sqldReader, "ProcessName"), IP = GetString(sqldReader, "IP"), Port = GetString(sqldReader, "Port"), MacAddress = GetString(sqldReader, "MacAddress"), Login = GetString(sqldReader, "Login"), Password = GetString(sqldReader, "Password"), Version = GetString(sqldReader, "Version"), OS = GetString(sqldReader, "Os"), Additional = GetString(sqldReader, "Additional"), CacheFilled = GetLong(sqldReader, "CacheFilled") }; remotes.Add(remote); } sqldReader.Dispose(); query.Dispose(); } catch (SQLiteException e) { Log(e.Message); } return remotes; }
public bool UpdateRemote(Yatse2Remote remote) { if (remote == null) return false; var sqlCmd = _dbConnection.CreateCommand(); sqlCmd.CommandText = @"UPDATE `Remotes` SET Name = ? , Api = ?, ProcessName = ?, IP = ?, Port = ?, MacAddress = ?, Login = ?, Password = ?, Version = ?, Os = ?, Additional = ?, CacheFilled = ? WHERE Id = @Id;"; sqlCmd.Parameters.AddWithValue("a1", remote.Name); sqlCmd.Parameters.AddWithValue("a2", remote.Api); sqlCmd.Parameters.AddWithValue("a3", remote.ProcessName); sqlCmd.Parameters.AddWithValue("a4", remote.IP); sqlCmd.Parameters.AddWithValue("a5", remote.Port); sqlCmd.Parameters.AddWithValue("a6", remote.MacAddress); sqlCmd.Parameters.AddWithValue("a7", remote.Login); sqlCmd.Parameters.AddWithValue("a8", remote.Password); sqlCmd.Parameters.AddWithValue("a9", remote.Version); sqlCmd.Parameters.AddWithValue("a10", remote.OS); sqlCmd.Parameters.AddWithValue("a12", remote.Additional); sqlCmd.Parameters.AddWithValue("a13", remote.CacheFilled); sqlCmd.Parameters.AddWithValue("@Id", remote.Id); return Query(sqlCmd); }
private void InitRemote() { if (_remote != null) { _remote.Close(); _remote.Dispose(); } _remoteConnected = false; _remoteLibraryRefreshed = !_config.RefreshOnConnect; _remote = ApiHelper.Instance().GetRemoteByApi(null); if (_currentRemoteId == 0) { Logger.Instance().Log("Yatse2", "No current Remote"); _remoteInfo = new Yatse2Remote { Id = 0, CacheFilled = 1 }; return; } var remotes = _database.GetRemote(_currentRemoteId); if (remotes.Count < 1) { Logger.Instance().Log("Yatse2", "No remote found"); return; } var remoteInfo = remotes[0]; Logger.Instance().Log("Yatse2", "Init remote : " + remoteInfo.Id + " - " + remoteInfo.Name + " (" + remoteInfo.Api + " / " + remoteInfo.Version + ")"); _remote = ApiHelper.Instance().GetRemoteByApi(remoteInfo.Api); if (_remote == null) { Logger.Instance().Log("Yatse2", "Error plugin not loaded for API : " + remoteInfo.Api); return; } _remotePlugin = ApiHelper.Instance().GetRemotePluginByApi(remoteInfo.Api); txb_Home_Movies.Visibility = (_remotePlugin.SupportedFunctions().MovieLibrary) ? Visibility.Visible : Visibility.Hidden; txb_Home_TvShows.Visibility = (_remotePlugin.SupportedFunctions().TvShowLibrary) ? Visibility.Visible : Visibility.Hidden; txb_Home_Artists.Visibility = (_remotePlugin.SupportedFunctions().AudioLibrary) ? Visibility.Visible : Visibility.Hidden; txb_Home_Albums.Visibility = (_remotePlugin.SupportedFunctions().AudioLibrary) ? Visibility.Visible : Visibility.Hidden; txb_Home_Genres.Visibility = (_remotePlugin.SupportedFunctions().AudioLibrary) ? Visibility.Visible : Visibility.Hidden; _failedRemoteCheck = false; _remote.Configure(remoteInfo.IP, remoteInfo.Port, remoteInfo.Login, remoteInfo.Password); _remoteInfo = remoteInfo; Helper.Instance.CurrentApi = _remoteInfo.Api; _yatse2Properties.Api = _remoteInfo.Api; ClearFiltersAndDataSource(); if (_currentGrid.Name == "grd_Home") { _gridHistory.Clear(); } else { _gridHistory.Clear(); _gridHistory.Add("grd_Home"); } }