Exemple #1
0
        public void AddRecording(Recording rec)
        {
            var recordingExists = false;

            if (_connection == null) return;

            rec.Id = _nextId;

            try
            {
                var sqlins = Hilfsfunktionen.GetTextRessource("SQL.InsertRecording.txt");
                var command = new MySqlCommand(sqlins, _connection);
                command.Parameters.AddWithValue("@id", rec.Id);
                command.Parameters.AddWithValue("@bong_id", rec.BongId);
                command.Parameters.AddWithValue("@title", rec.Title);
                command.Parameters.AddWithValue("@subtitle", rec.Subtitle);
                command.Parameters.AddWithValue("@description", rec.Description);
                command.Parameters.AddWithValue("@channel", rec.Channel);
                command.Parameters.AddWithValue("@start", rec.Start);
                command.Parameters.AddWithValue("@duration", rec.Duration);
                command.Parameters.AddWithValue("@genre", rec.Genre);
                command.Parameters.AddWithValue("@series_season", rec.SeriesSeason);
                command.Parameters.AddWithValue("@series_number", rec.SeriesNumber);
                command.Parameters.AddWithValue("@series_count", rec.SeriesCount);
                command.Parameters.AddWithValue("@image_url", rec.ImageUrl);
                command.Parameters.AddWithValue("@download_hd_url", rec.DownloadUrlHD);
                command.Parameters.AddWithValue("@download_hq_url", rec.DownloadUrlHQ);
                command.Parameters.AddWithValue("@download_nq_url", rec.DownloadUrlNQ);
                command.ExecuteNonQuery();
            }
            catch (MySql.Data.MySqlClient.MySqlException ex)
            {
                if (ex.Number != 1062) // alles außer: doppelter Schlüssel (Sender, Startzeitpunkt)
                {
                    Umgebung.Log.Error("MySql-Error {0}: BongRecording konnte nicht eingefügt werden:\n{1}\n{2}", ex.Number, ex.Message, ex.ToString());
                    throw;
                }
                else recordingExists = true;
            }
            catch (Exception ex)
            {
                Umgebung.Log.Error("BongRecording konnte nicht eingefügt werden: {0}", ex.Message);
                throw;
            }

            if (!recordingExists)
            {
                Umgebung.Log.Info("Neue Aufnahme {0}: {1}", rec.BongId, rec.Title);
                _nextId++;
            }
        }
Exemple #2
0
        public List<Recording> GetDownloadableRecordings()
        {
            var retval = new List<Recording>();
            var urlRecordings = String.Format(UrlRecordings, Umgebung.Web.User, Umgebung.Web.Password);

            var docRecordings = new XmlDocument();
            docRecordings.Load(urlRecordings);

            Umgebung.Log.Dump("Bong recordings.xml Ergebnisdokument:\n{0}", docRecordings.ToString());

            var root = docRecordings.DocumentElement;
            if (root != null)
            {
                var nodes = root.SelectNodes("/recordings/recording");

                if (nodes != null)
                    foreach (XmlNode node in nodes)
                    {
                        var docRecording = new XmlDocument();

                        try
                        {
                            docRecording.InnerXml = node.OuterXml;
                            var xmlDecl = docRecording.CreateXmlDeclaration("1.0", "UTF-8", null);
                            var rootRecording = docRecording.DocumentElement;
                            docRecording.InsertBefore(xmlDecl, rootRecording);

                            Umgebung.Log.Dump("Neues XML-Dokument erstellt:\n{0}", docRecording.ToString());

                            var rec = new Recording()
                                          {
                                              // Id wird erst später nachgetragen
                                              BongId = GetNodeText(docRecording, "/recording/id"),
                                              Title = GetNodeText(docRecording, "/recording/title"),
                                              Subtitle = GetNodeText(docRecording, "/recording/subtitle"),
                                              Description = GetNodeText(docRecording, "/recording/description"),
                                              Channel = GetNodeText(docRecording, "/recording/channel"),
                                              Start = DateTime.Parse(GetNodeText(docRecording, "/recording/start"), new CultureInfo("de-DE"), DateTimeStyles.None),
                                              Duration = TimeSpan.Parse(GetNodeText(docRecording, "/recording/duration"), new CultureInfo("de-DE")),
                                              Genre = GetNodeText(docRecording, "/recording/genre"),
                                              SeriesSeason = GetNodeText(docRecording, "/recording/series_season"),
                                              SeriesNumber = GetNodeText(docRecording, "/recording/series_number"),
                                              SeriesCount = GetNodeText(docRecording, "/recording/series_count"),
                                              ImageUrl = GetNodeText(docRecording, "/recording/image"),
                                              DownloadUrlHD = GetNodeText(docRecording, "/recording/files/file[type='download' and quality='HD']/url"),
                                              DownloadUrlHQ = GetNodeText(docRecording, "/recording/files/file[type='download' and quality='HQ']/url"),
                                              DownloadUrlNQ = GetNodeText(docRecording, "/recording/files/file[type='download' and quality='NQ']/url")
                                          };

                            rec.Dump("Recording-Instanz aus Bong-XML erstellt");

                            retval.Add(rec);
                        }
                        catch (Exception ex)
                        {
                            Umgebung.Log.Error("Initialisieren von Recording aus der XML-Struktur schlug fehl: {0}\n{1}", ex.Message, docRecording.ToString());
                        }
                    }
            }

            return retval;
        }
Exemple #3
0
        public void MarkRecording(Recording rec, MarkRecordingState state)
        {
            if (_connection == null) return;

            var sql = "";

            switch (state)
            {
                case MarkRecordingState.DownloadCompleted:
                    sql = "UPDATE Recordings SET download_date = SYSDATE() WHERE id = @id AND download_date IS NULL";
                    Umgebung.Log.Info("Setze DownloadCompleted für {0}: {1}", rec.BongId, rec.Title);
                    break;

                case MarkRecordingState.WebRecordingDeleted:
                    sql = "UPDATE Recordings SET delete_date = SYSDATE() WHERE id = @id AND download_date IS NOT NULL AND delete_date IS NULL";
                    Umgebung.Log.Info("Setze WebRecordingDeleted für {0}: {1}", rec.BongId, rec.Title);
                    break;
            }

            var command = new MySqlCommand(sql, _connection);
            command.Parameters.AddWithValue("@id", rec.Id);
            command.ExecuteNonQuery();
        }
Exemple #4
0
        public List<Recording> GetRecordings(GetRecordingsFilter filter)
        {
            string sql = "";
            var retval = new List<Recording>();

            if (_connection == null) return retval;

            switch (filter)
            {
                case GetRecordingsFilter.AttendingDownload:
                    sql = Hilfsfunktionen.GetTextRessource("SQL.SelectRecordingsForDownload.txt");
                    break;

                case GetRecordingsFilter.DownloadCompleted:
                    sql = Hilfsfunktionen.GetTextRessource("SQL.SelectRecordingsForDeletion.txt");
                    break;
            }

            var command = _connection.CreateCommand();
            command.CommandText = sql;
            var reader = command.ExecuteReader();

            while (reader.Read())
            {
                var rec = new Recording();

                rec.Id = reader.GetInt32(0);
                rec.BongId = reader.GetString(1);
                rec.Title = reader.GetString(2);
                rec.Subtitle = reader.IsDBNull(3) ? "" : reader.GetString(3); ;
                rec.Description = reader.IsDBNull(4) ? "" : reader.GetString(4); ;
                rec.Channel = reader.GetString(5);
                rec.Start = reader.GetDateTime(6);
                rec.Duration = reader.GetTimeSpan(7);
                rec.Genre = reader.IsDBNull(8) ? "" : reader.GetString(8); ;
                rec.SeriesSeason = reader.IsDBNull(9) ? "" : reader.GetString(9); ;
                rec.SeriesNumber = reader.IsDBNull(10) ? "" : reader.GetString(10); ;
                rec.SeriesCount = reader.IsDBNull(11) ? "" : reader.GetString(11); ;
                rec.ImageUrl = reader.IsDBNull(12) ? "" : reader.GetString(12); ;
                rec.DownloadUrlHD = reader.IsDBNull(13) ? "" : reader.GetString(13); ;
                rec.DownloadUrlHQ = reader.IsDBNull(14) ? "" : reader.GetString(14); ;
                rec.DownloadUrlNQ = reader.IsDBNull(15) ? "" : reader.GetString(15); ;

                retval.Add(rec);
            }
            reader.Close();

            return retval;
        }