void MainWindow::Ban_Unban()
{
    username = ui->SureNameCheck->text();
    password = ui->NameCheck->text();

    QSqlQuery query("select l.banned from login l where l.Username = '"+username+"' and l.password = '"+password+"';");
    query.exec();
    if(query.size()==1)
    {
        query.first();
         if(query.value(0)==0)
         {
             QSqlQuery update("update Login l set l.banned = '1' where Username = '"+username+"' and password = '"+password+"';");
             update.exec();
         }
         else
         {
             QSqlQuery update("update Login l set l.banned = '0' where Username = '"+username+"' and password = '"+password+"';");
             update.exec();
         }
    }

    model->setQuery("select Username,password,banned,Name,Firstname,Street from login l join personaldata pd on pd.PDID=l.LID;");
    ui->tableView->setModel(model);
    ui->tableView->resizeRowsToContents();
}