void AddLink::displayComp(vector<Computer>& computer) { ui->table_linking->setSortingEnabled(false); ui->table_linking->clearContents(); ui->table_linking->setColumnCount(5); ui->table_linking->setRowCount(computer.size()); ui->table_linking->setHorizontalHeaderItem(0,new QTableWidgetItem(QString("id"))); ui->table_linking->setHorizontalHeaderItem(1,new QTableWidgetItem(QString("Name"))); ui->table_linking->setHorizontalHeaderItem(2,new QTableWidgetItem(QString("Year"))); ui->table_linking->setHorizontalHeaderItem(3,new QTableWidgetItem(QString("Type"))); ui->table_linking->setHorizontalHeaderItem(4,new QTableWidgetItem(QString("Built"))); for(size_t i = 0; i < computer.size(); i++) { Computer temp = computer[i]; QTableWidgetItem* id = new QTableWidgetItem; id->setData(Qt::DisplayRole,temp.getID()); ui->table_linking->setItem(i,0, id); ui->table_linking->setItem(i,1, new QTableWidgetItem(QString::fromStdString(temp.getName()))); ui->table_linking->setItem(i,2, new QTableWidgetItem(QString::number(temp.getYear()))); ui->table_linking->setItem(i,3, new QTableWidgetItem(QString::fromStdString(temp.getType()))); ui->table_linking->setItem(i,4, new QTableWidgetItem(QString::number(temp.getBuilt()))); } ui->table_linking->setSortingEnabled(true); }
void ComputerRepository::add(Computer &comp) { auto query = SQLConnection::getInstance()->getQuery(); query->prepare("INSERT INTO computers (name, type, build_year, built) VALUES (?,?,?,?)"); query->addBindValue(QString::fromStdString(comp.getName())); query->addBindValue(QString::fromStdString(comp.getType())); query->addBindValue(comp.getBuildYear()); query->addBindValue(comp.getBuilt()); if(!query->exec()) throw std::runtime_error(query->lastError().text().toStdString()); }
void ComputerRepository::update(Computer &comp, Computer &replace) { auto query = SQLConnection::getInstance()->getQuery(); query->prepare("UPDATE computers SET name = ?, type = ?, build_year = ?, built = ? WHERE id = ?"); query->addBindValue(QString::fromStdString(replace.getName())); query->addBindValue(QString::fromStdString(replace.getType())); query->addBindValue(replace.getBuildYear()); query->addBindValue(replace.getBuilt()); query->addBindValue(comp.getID()); if(!query->exec()) throw std::runtime_error(query->lastError().text().toStdString()); }
bool ComputerRepository::add(Computer c) { db.open(); QSqlQuery query; query.prepare("INSERT INTO Computers(Name, BuildYear, Type, Built)" "VALUES (:name, :buildyear, :type, :built)"); query.bindValue(":name", QString::fromStdString(c.getName())); query.bindValue(":buildyear", QString::fromStdString(c.getBuildYear())); query.bindValue(":type", QString::fromStdString(c.getType())); query.bindValue(":built", QString::number(c.getBuilt())); query.exec(); db.close(); return true; }
bool DbManager::editComputer(Computer comp) { QString was_built = ""; switch (comp.getBuilt()) { case 0: was_built = "0"; break; case 1: was_built = "1"; break; } return execQuery("UPDATE Computers " "SET name = '" + comp.getName() + "', " "year = " + comp.getYear() + ", " "type = '" + comp.getType() + "', " "built = " + was_built + " " "WHERE cID = " + comp.getId()); }
bool DbManager::addComputer(Computer comp) { QString was_built = ""; switch (comp.getBuilt()) { case 0: was_built = "0"; break; case 1: was_built = "1"; break; } return execQuery("INSERT INTO Computers (name, year, type, built) " "VALUES ( '" + comp.getName() + "'," + comp.getYear() + ",'" + comp.getType() + "', " + was_built + " )"); }