dbmanager.h

/*
 * TCN Field Booking Application
 * Copyright (C) 2018 Dzianis Lamouski
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program. If not, see <http://www.gnu.org/licenses/>.
 */

#ifndef DBMANAGER_H
#define DBMANAGER_H

#include <QDate>
#include <QSqlDatabase>
#include <QString>

#include "bookingdata.h"

class DbManager
{
public:
    DbManager(const QString& path);
    bool addMember(const QString &name, const QString &surname);
    bool importMembersFile(QString filename);

    bool addField(const QString& name, const int time_masks[7], const int seasons) const;
    bool updateFieldName(const int id, const QString& name) const;
    bool updateFieldTimeMask(const int id, const int day_index, const int time_mask) const;
    bool updateFieldSeasons(const int id, const int seasons) const;

    bool bookingSlotIsFree(const BookingSlot& slot, int &bookingId, BookingData& data);
    bool addBooking(const BookingSlot& slot, const BookingData& data);
    bool updateBooking(const int bookingId, const BookingData& data);
    bool cancleBooking(const int bookingId);

    bool markBookingAsPaid(const int bookingId);
    bool markBookingAsUnpaid(const int bookingId);

    bool changeBookingField(const int bookingID, const int fieldID);
    bool changeAboBookingField(const int bookingID, const int fieldID);

    int addBlock(const BookingSlot& slot, const BookingData& data);
    int numOfUsedBlocks(int blockID);
    bool deleteBlock(const int blockId);

    bool checkDB();

    static DbManager* instance();    
    static QSqlDatabase db();


private:
    static DbManager* m_instance;
    QSqlDatabase m_db;

};

#endif // DBMANAGER_H