From 9954c11ac9bc51fe81cc9949ff9799ac87512d92 Mon Sep 17 00:00:00 2001
From: Arno <am@disconnect.de>
Date: Fri, 12 Jul 2013 14:25:59 +0200
Subject: Make PartNo and Subtitle editable

---
 archivemodel.cpp | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)

(limited to 'archivemodel.cpp')

diff --git a/archivemodel.cpp b/archivemodel.cpp
index 0a2c645..fe0ffff 100644
--- a/archivemodel.cpp
+++ b/archivemodel.cpp
@@ -95,6 +95,12 @@ QVariant ArchiveModel::data(const QModelIndex &index, int role) const{
     if(role == SeriesPartIdRole){
         return item->data(SeriesPartId);
     }
+    if(role == SeriesPartRole){
+        return item->data(SeriesPart);
+    }
+    if(role == SubtitleRole){
+        return item->data(Subtitle);
+    }
     return SmTreeModel::data(index, role);
 }
 
@@ -448,6 +454,21 @@ void ArchiveModel::setMetadata(int partId, const QList<QVariant> &data){
     mDb.commit();
 }
 
+bool ArchiveModel::setPartNo(int partId, int newPartId, const QString &subtitle){
+    mDb.transaction();
+    QSqlQuery updatePartNoQ(mDb);
+    updatePartNoQ.prepare("UPDATE seriesparts SET iseriespart = :npid, tsubtitle = :tsub WHERE iseriesparts_id = :pid");
+    updatePartNoQ.bindValue(":pid", partId);
+    updatePartNoQ.bindValue(":npid", newPartId);
+    updatePartNoQ.bindValue(":tsub", subtitle);
+    if(!updatePartNoQ.exec()){
+        mDb.rollback();
+        return false;
+    }
+    mDb.commit();
+    return true;
+}
+
 QStringList ArchiveModel::allSources() const{
     QSqlQuery sQ("SELECT DISTINCT(tsourcemedium) FROM metadata ORDER BY tsourcemedium ASC", mDb);
     QStringList retval;
-- 
cgit v1.2.3-70-g09d2