foodpurchase.cpp

#include "foodpurchase.h"
#include "ui_foodpurchase.h"
#include "dbhandler.h"
#include <QListView>
#include <QTableView>
#include <QSqlQuery>
#include "CustomComboBox.h"

void showFoods(Ui::FoodPurchase* ui);
//GlobalData globalData;


FoodPurchase::FoodPurchase(QWidget *parent) :
    QMainWindow(parent),
    ui(new Ui::FoodPurchase)
{
    ui->setupUi(this);

    ui->tableWidget->setEditTriggers(QAbstractItemView::NoEditTriggers);
     showFoods(ui);
}

FoodPurchase::~FoodPurchase()
{
    delete ui;
}



void showFoods(Ui::FoodPurchase* ui)
{
    _vector.clear();
    QMessageBox msgBox;
    QString city,food;
    double price;
    int id;
    int row = 0;
    int column = 0;
   // QTableWidgetItem *item = new QTableWidgetItem;

    ui->tableWidget->setColumnCount(4);
    ui->tableWidget->setRowCount(60);


    QStringList labels = { "City Name","Traditional Food", "Price", "Quantity" };
    ui->tableWidget->setHorizontalHeaderLabels(labels);


    DbHandler dbHandler(DATABASE_PATH,DATABASE_CONNECTION_NAME);
    if(dbHandler.open())
    {
        QSqlQuery query1("SELECT ID, City, Food, Price FROM Foods WHERE IsActive=1 AND IsFoodActive=1");

                    while(query1.next())
                    {
                        id = query1.value(0).toInt();
                        city = query1.value(1).toString();
                        food = query1.value(2).toString();
                        price = query1.value(3).toDouble();

                       // item = new QTableWidgetItem();
                        //item->setText(city);

                       // ui->tableWidget->setItem(row,column++,item);

                        ui->tableWidget->setItem(row,column++,new QTableWidgetItem(city));

                        ui->tableWidget->setItem(row,column++,new QTableWidgetItem(food));

                        ui->tableWidget->setItem(row,column++,new QTableWidgetItem(QString::number(price)));



                        //**************************************************

                        CustomComboBox* _customComboBox = new CustomComboBox(id,city,food,price);

                        for(int i=0;i<=20;i++)
                            _customComboBox->addItem(QString::number(i));

                        ui->tableWidget->setCellWidget(row,column++,_customComboBox);


                        //**************************************************


                        column = 0;
                        row++;
                    }


        dbHandler.close();
    }
    else
    {
        msgBox.setText(FAILED_MESSAGE_DATABASE_OPENING);
        msgBox.exec();
    }
}




void FoodPurchase::on_pushButton_2_clicked()
{
    QMessageBox msgBox;
   // QSqlQuery qry;
     //QSqlQuery query;
    QString city;
    QString food;
    QString price;
    QString quantity;
    QString totalPriceStr;


    DbHandler dbHandler(DATABASE_PATH,DATABASE_CONNECTION_NAME);
    if(dbHandler.open())

    {

        QString str="";
        double totalPrice;
        str += "Purchased Items:\n\n";
        for(int i=0;i<_vector.size();i++)
        {
             city = _vector[i].city;
             food = _vector[i].food;
             price = QString::number(_vector[i].price);
             quantity = QString::number(_vector[i].quantity);


            str +="ID:  " + QString::number(_vector[i].id)+" \n";
            str +="City:  " + city+" \n";
            str +="Food:  " + food+" \n";
            str +="Price:  " + price+"$ US \n";
            str +="Quntity:  " + quantity+" \n";
            totalPrice = _vector[i].price*_vector[i].quantity;
            totalPriceStr = QString::number(totalPrice);
            str +="Total Pricce:  " + totalPriceStr+"$ US \n";
            str += "\n\n\n";

                QSqlQuery query;
                query.prepare("INSERT INTO Purchase_History (City_Name, Food_Name, Price, Quantity, Total_Price) "
                              "VALUES (:City_Name, :Food_Name, :Price, :Quantity, :Total_Price)");
                query.bindValue(":City_Name", city);
                query.bindValue(":Food_Name", food);
                query.bindValue(":Price", price);
                query.bindValue(":Quantity", quantity);
                query.bindValue(":Total_Price", totalPriceStr);
                query.exec();

        }
        msgBox.setText(str);
        msgBox.exec();




        dbHandler.close();
        showFoods(ui);
    }


    else
    {
        msgBox.setText(FAILED_MESSAGE_DATABASE_OPENING);
        msgBox.exec();
    }
}