Get2gether/delete.cpp at master · CodingMorry7/Get2gether · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
#include "error.h"
#include "delete.h"

/*=================================================================================================================================*/
//                                          class Delete-Specific Methods
/*=================================================================================================================================*/

/*.------------------------.*/
/*|      Constructor       |*/
/*'------------------------'*/

Delete::Delete(){
    //does nothing
}

/* Purpose:         Allows event deletion
 * Postcondition:   Selected event is deleted from database and removed from calendar
*/
int Delete::Do_Delete(QString ID_Param, QString matchuser, QString currentuser, bool isGroupMode, QString TheGroup, QString GroupID)
{
    int updateEvents = 1;
    int updateMemebers = 2;
    bool isGroupEvent;                                          // to determine if group event
    QSqlQuery isGroupEventQ;                                    // To select groupID of returned event
    isGroupEventQ.exec("SELECT groupID "
                       "FROM innodb.EVENTS "
                       "WHERE ID = '" + ID_Param+ "'");
    isGroupEventQ.first();
    isGroupEvent = (isGroupEventQ.value(0).toInt() != 0);       // Determine if group event (i.e. groupID != 0)

    /* If event is a group event but in personal mode,
     *      Output error
    */
    if(isGroupEvent && !isGroupMode)
    {
        error::printError(DELETE_ERROR_INVALID_MODE);

        return 3;
    }

    if(currentuser == matchuser || TheGroup == matchuser)
    {
        QMessageBox::StandardButton choice;
        choice = QMessageBox::warning(NULL, "Delete Event?", "Are you sure you want to delete your event?", QMessageBox::Yes | QMessageBox::No);

        /* If user selects Yes,
        *      Query database removing selected event
        */
        if (choice == QMessageBox::Yes) {
            QSqlQuery query_delete;

            /* First, delete USER_EVENT eventID fk reference:
             * If not in group mode,
             *      Delete user event entry regularly
             * Else,
             *      Cycle through each group member
             *          Delete user event entry
            */
            if(!isGroupMode)
            {
                // update USER_EVENTS table
                query_delete.exec("DELETE FROM innodb.USER_EVENTS "
                                  "WHERE eventID ='" +ID_Param+
                                  "' AND username ='" +currentuser+ "'");

                // Print query status
                if(query_delete.isActive())
                {
                    qDebug().noquote() << "Deletion of Event " + ID_Param + " successful.";
                }
                else
                {
                    qDebug() << query_delete.lastError().text();
                }

                return updateEvents;
            }
            else
            {
                QSqlQuery selectMemberQ;
                QString groupMember;

                selectMemberQ.exec("SELECT username "
                                      "FROM innodb.GROUP_MEMBERS "
                                      "WHERE groupID = '" +GroupID+ "'");

                while(selectMemberQ.next())
                {
                     groupMember = selectMemberQ.value(0).toString();
                     query_delete.exec("DELETE FROM innodb.USER_EVENTS "
                                       "WHERE username = '" +groupMember+
                                       "' AND eventID = '" +ID_Param+ "'");
                }

                // Print query status
                if(query_delete.isActive())
                {
                    qDebug().noquote() << "Deletion of Event " + ID_Param + " successful.";
                }
                else
                {
                    qDebug() << query_delete.lastError().text();
                }
                return updateMemebers;
           }
        }
        else {
            qDebug().noquote() << "Deletion of Event " + ID_Param + " canceled.";
            return 3;
        }
    }
    else
    {
        // Output error message
        error::printError(DELETE_ERROR_UNAUTH_USER);
        return 3;
    }
}