From 519b2392f16adbf179ef7a117513dc7a2b890b6e Mon Sep 17 00:00:00 2001
From: Arno <arno@disconnect.de>
Date: Wed, 4 Apr 2018 12:35:31 +0200
Subject: Fill MoviePropertiesDialog, part 1

---
 moviepropertiesdialog.cpp | 24 ++++++++++++++++++++++++
 1 file changed, 24 insertions(+)

(limited to 'moviepropertiesdialog.cpp')

diff --git a/moviepropertiesdialog.cpp b/moviepropertiesdialog.cpp
index 2b6fd80..6197526 100644
--- a/moviepropertiesdialog.cpp
+++ b/moviepropertiesdialog.cpp
@@ -3,6 +3,8 @@
 #include <QRadioButton>
 #include <QGroupBox>
 #include <QPushButton>
+#include <QSqlDatabase>
+#include <QSqlQuery>
 #include <QIntValidator>
 #include <QStandardItemModel>
 #include <QGridLayout>
@@ -92,3 +94,25 @@ void MoviePropertiesDialog::setupDialog(){
     mainLayout->addLayout(buttonLayout);
     setLayout(mainLayout);
 }
+
+void MoviePropertiesDialog::init(int seriesPartsId){
+    QSqlDatabase db = QSqlDatabase::database("treedb");
+    QSqlQuery genQ(db);
+    genQ.prepare("SELECT series.tseries_name, seriesparts.tsubtitle, seriesparts.iseriespart, metadata.tcomment, metadata.sireleaseyear, metadata.tsourcemedium FROM series, seriesparts, metadata WHERE seriesparts.iseriesparts_id = :id AND seriesparts.iseries_id = series.iseries_id AND metadata.iseriespart_id = seriesparts.iseriesparts_id");
+    genQ.bindValue(":id", seriesPartsId);
+    genQ.exec();
+    while(genQ.next()){
+        mSeriesNameLE->setText(genQ.value(0).toString());
+        mSubtitleLE->setText(genQ.value(1).toString());
+        mSeriesPartLE->setText(genQ.value(2).toString());
+        mCommentLE->setText(genQ.value(3).toString());
+        mReleaseYearLE->setText(genQ.value(4).toString());
+        QString src = genQ.value(5).toString().toLower();
+        if(src == "usenet"){
+            mUsenetRB->setChecked(true);
+        }
+        if(src == "torrent"){
+            mTorrentRB->setChecked(true);
+        }
+    }
+}
-- 
cgit v1.2.3-70-g09d2