bool Computerrepository::addToDatabase(Computer newComp) { QSqlQuery query; QString name = QString::fromStdString((newComp.getName())); int builtY = newComp.getBuildYear(); QString type = QString::fromStdString((newComp.getType())); bool builtOrNot = newComp.getBuild(); query.prepare("INSERT INTO Computers (Name, YearBuilt, Type, BuiltOrNot) " "VALUES (:Name, :YearBuilt, :Type, :BuiltOrNot)"); query.bindValue(":Name", name); query.bindValue(":YearBuilt", builtY); query.bindValue(":Type", type); query.bindValue(":BuiltOrNot", builtOrNot); return query.exec(); }
bool Computerrepository::updateComputer(Computer computerUpdate) { QSqlQuery query; int id = computerUpdate.getId(); QString name = QString::fromStdString((computerUpdate.getName())); int builtY = computerUpdate.getBuildYear(); QString type = QString::fromStdString((computerUpdate.getType())); bool builtOrNot = computerUpdate.getBuild(); query.prepare("UPDATE Computers SET Name=:Name, YearBuilt=:YearBuilt," " Type=:Type, BuiltOrNot=:BuiltOrNot WHERE id=:id"); query.bindValue(":id", id); query.bindValue(":Name", name); query.bindValue(":YearBuilt", builtY); query.bindValue(":Type", type); query.bindValue(":BuiltOrNot", builtOrNot); return query.exec(); }