softProjector Code

#include "slideshow.h"

SlideShowItem::SlideShowItem()
{
    slideId = -1;
    order = -1;
}

SlideShowInfo::SlideShowInfo()
{
}

SlideShow::SlideShow()
{
    slideShowId = -1;
}

void SlideShow::loadSlideShow(int id)
{
    slides.clear();
    slideShowId = id;
    QSqlQuery sq;
    sq.exec(QString("SELECT name, info FROM SlideShows WHERE id = %1").arg(slideShowId));
    sq.first();
    name = sq.value(0).toString();
    info = sq.value(1).toString();

    QProgressDialog progress;
    progress.setMaximum(100);
    progress.setValue(1);
    sq.exec(QString("SELECT id, p_order, name, path, pix, pix_small, pix_prev FROM Slides WHERE ss_id = %1").arg(slideShowId));

    int max(0);
    while(sq.next())
        ++max;

    sq.first();
    progress.setLabelText("Loading Slides...");
    progress.setMaximum(max+1);
    int ct(0);

//    while(sq.next())
    QList<SlideShowItem> ss;
    do
    {
        SlideShowItem si;
        si.slideId = sq.value(0).toInt();
        si.order = sq.value(1).toInt();
        si.name = sq.value(2).toString();
        si.path = sq.value(3).toString();
        si.image.loadFromData(sq.value(4).toByteArray());
        si.imageSmall.loadFromData(sq.value(5).toByteArray());
        si.imagePreview.loadFromData(sq.value(6).toByteArray());

        ss.append(si);
        ++ct;
        progress.setValue(ct);
    }while(sq.next());

    // Sort to proper oder number
    for(int i(0);i<ss.count();++i)
    {
        foreach(const SlideShowItem &ssi, ss)
        {
            if(ssi.order == i)
            {
                slides.append(ssi);
                break;
            }
        }
    }

    ++ct;
    progress.setValue(ct);
}

void SlideShow::saveSideShow(QString savelbl, QWidget *ptW, QList<int> delList)
{
    QSqlQuery sq;
    QSqlDatabase::database().transaction();

    QProgressDialog prg(savelbl,"Cancel",0,slides.count()+1+delList.count(),ptW);

    int ct(0);

    // Create new slide show in not yet in database
    if(slideShowId == -1)
    {
        sq.prepare("INSERT INTO SlideShows (name, info) VALUES (?,?)");
        sq.addBindValue(name);
        sq.addBindValue(info);
        sq.exec();
        sq.clear();

        // get currently added slideShow id
        sq.exec("SELECT seq FROM sqlite_sequence WHERE name = 'SlideShows'");
        sq.first();
        slideShowId = sq.value(0).toInt();
        sq.clear();

        // Insert new slides
        sq.prepare("INSERT INTO Slides (ss_id, p_order, name, path, pix, pix_small, pix_prev) VALUES (?,?,?,?,?,?,?)");
        foreach(const SlideShowItem &si, slides)
        {
            sq.addBindValue(slideShowId);
            sq.addBindValue(ct);
            sq.addBindValue(si.name);
            sq.addBindValue(si.path);
            sq.addBindValue(pixToByte(si.image));
            sq.addBindValue(pixToByte(si.imageSmall));
            sq.addBindValue(pixToByte(si.imagePreview));
            sq.exec();
            ++ct;
            prg.setValue(ct);
        }
        QSqlDatabase::database().commit();
        return;
    }
    else
    {
        // Update Slide Show
        // Update slide show info
        sq.prepare("UPDATE SlideShows SET name = ?, info = ? WHERE id  = ?");
        sq.addBindValue(name);
        sq.addBindValue(info);
        sq.addBindValue(slideShowId);
        sq.exec();
        sq.clear();

        // Update slides (order only can be updated)
        int c(0);
        foreach(const SlideShowItem &si, slides)
        {
            if(si.slideId != -1)
            {
                sq.exec(QString("UPDATE Slides SET p_order = %1 WHERE id = %2").arg(c).arg(si.slideId));
                ++ct;
                prg.setValue(ct);
            }
            ++c;
        }
        sq.clear();

        // Insert new slides
        c = 0;
        sq.prepare("INSERT INTO Slides (ss_id, p_order, name, path, pix, pix_small, pix_prev) VALUES (?,?,?,?,?,?,?)");
        foreach(const SlideShowItem &si, slides)
        {
            if(si.slideId == -1)
            {
                sq.addBindValue(slideShowId);
                sq.addBindValue(c);
                sq.addBindValue(si.name);
                sq.addBindValue(si.path);
                sq.addBindValue(pixToByte(si.image));
                sq.addBindValue(pixToByte(si.imageSmall));
                sq.addBindValue(pixToByte(si.imagePreview));
                sq.exec();
                ++ct;
                prg.setValue(ct);
            }
            ++c;
        }
    }
    sq.clear();

    // Delete slides
    foreach(const int sid, delList)
    {
        if(sid>=0)
            sq.exec(QString("DELETE FROM Slides WHERE id = %1").arg(sid));
        ++ct;
        prg.setValue(ct);
    }

    prg.setLabelText("Saving Slide Show to Database");
    QSqlDatabase::database().commit();
    ++ct;
    prg.setValue(ct);
}