void KULLANICILAR_FORMU::DELETE_RECORD ( int p_kullanici_id ) { SQL_QUERY sql_query ( G_YONETIM_DB ); sql_query.PREPARE_DELETE ( "ynt_bilgisayar_kullanicilari","kullanici_id = :kullanici_id" ); sql_query.SET_VALUE ( ":kullanici_id" , p_kullanici_id ); sql_query.DELETE(); sql_query.PREPARE_DELETE ( "ynt_veritabani_kullanicilari","kullanici_id = :kullanici_id" ); sql_query.SET_VALUE ( ":kullanici_id" , p_kullanici_id ); sql_query.DELETE(); sql_query.PREPARE_UPDATE ( "ynt_kullanicilar","kullanici_id","silinmis_mi","kullanici_id = :kullanici_id ") ; sql_query.SET_VALUE ( ":silinmis_mi" , 1 ); sql_query.SET_VALUE ( ":kullanici_id" , p_kullanici_id ); sql_query.UPDATE(); BILGISAYARDA_KAYITLI_KUL_SAY_VE_KULLANICININ_KAYITLI_VERITABANI_SAY_GUNCELLE (); QString log_detaylari = tr("User ID: ") + QVariant( p_kullanici_id).toString() + tr(" # User Code: ") + m_ui->lineEdit_kullanici_kodu->text() + tr(" # User Name: ") + m_ui->lineEdit_kullanici_adi->text(); YONETIM_007_KAYIT ( LOG_KULLANICILAR, LOG_KAYIT_SILME, log_detaylari ); }
int KULLANICILAR_FORMU::ADD_RECORD () { SQL_QUERY sql_query ( G_YONETIM_DB ); sql_query.PREPARE_INSERT ( "ynt_kullanicilar","kullanici_id","kullanici_kodu, kullanici_adi, " "parola, email_adresi, email_kullanici_adi, aciklama, silinmis_mi "); sql_query.SET_VALUE ( ":kullanici_kodu", m_ui->lineEdit_kullanici_kodu->text() ); sql_query.SET_VALUE ( ":kullanici_adi" , m_ui->lineEdit_kullanici_adi->text() ); QByteArray hash = QCryptographicHash::hash ( m_ui->line_edit_yeni_sifre->text().toUtf8(), QCryptographicHash::Md5); m_kullanici_parolasi = QString ( hash.toHex() ); sql_query.SET_VALUE ( ":parola" , m_kullanici_parolasi ); sql_query.SET_VALUE ( ":email_adresi" , m_ui->lineEdit_email->text() ); sql_query.SET_VALUE ( ":email_kullanici_adi" , m_ui->line_edit_email_kullanici_adi->text() ); sql_query.SET_VALUE ( ":aciklama" , m_ui->limitedTextEdit_not->toPlainText() ); sql_query.SET_VALUE ( ":silinmis_mi" , 0 ); int kullanici_id = sql_query.INSERT(); int table_row_count = m_ui->table_widget_bilgisayarlar->rowCount(); if ( table_row_count NE 0 ) { for ( int i = 0; i < table_row_count; i++ ) { int bilgisayar_id = m_ui->table_widget_bilgisayarlar->item ( i,BILGISAYAR_ID_COLUMN )->text().toInt(); sql_query.PREPARE_INSERT ( "ynt_bilgisayar_kullanicilari","id","bilgisayar_id, kullanici_id" ); sql_query.SET_VALUE ( ":bilgisayar_id", bilgisayar_id ); sql_query.SET_VALUE ( ":kullanici_id" , kullanici_id ); sql_query.INSERT(); } } table_row_count = m_ui->table_widget_veritabanlari->rowCount(); if ( table_row_count NE 0 ) { for ( int i = 0; i < table_row_count; i++ ) { int veritabani_id = m_ui->table_widget_veritabanlari->item ( i, VERITABANI_ID_COLUMN )->text().toInt(); sql_query.PREPARE_INSERT ( "ynt_veritabani_kullanicilari","id","veritabani_id, kullanici_id"); sql_query.SET_VALUE ( ":veritabani_id", veritabani_id ); sql_query.SET_VALUE ( ":kullanici_id", kullanici_id ); sql_query.INSERT(); } } BILGISAYARDA_KAYITLI_KUL_SAY_VE_KULLANICININ_KAYITLI_VERITABANI_SAY_GUNCELLE (); QString log_detaylari = tr("User ID: ") + QVariant ( kullanici_id ).toString() + tr(" # User Code: ") + m_ui->lineEdit_kullanici_kodu->text() + tr(" # User Name: ") + m_ui->lineEdit_kullanici_adi->text(); YONETIM_007_KAYIT ( LOG_KULLANICILAR, LOG_KAYIT_EKLEME, log_detaylari ); return kullanici_id; }
void YONETIM_007_GIRIS_KAYDI () { SQL_QUERY sql_query ( G_YONETIM_DB ); sql_query.PREPARE_SELECT ( "ynt_veritabanlari","veritabani_ismi, veritabani_tanimi","veritabani_id = :veritabani_id"); sql_query.SET_VALUE (":veritabani_id",VERITABANI_ID() ); if ( sql_query.SELECT() EQ 0 ) { return; } sql_query.NEXT(); QString aciklama = "Giriş yapılan veritabanı: " + sql_query.VALUE(0).toString() + " # Giriş yapılan veritabanı tanımı: "+ sql_query.VALUE(1).toString(); YONETIM_007_KAYIT ( LOG_PROGRAM, LOG_PROGRAMA_GIRIS, aciklama ); }
void YONETIM_007_CIKIS_KAYDI () { G_YONETIM_DB->START_TRANSACTION(); SQL_QUERY sql_query ( G_YONETIM_DB ); sql_query.PREPARE_SELECT ( "ynt_veritabanlari","veritabani_ismi, veritabani_tanimi","veritabani_id = :veritabani_id"); sql_query.SET_VALUE ( ":veritabani_id",VERITABANI_ID()); if ( sql_query.SELECT() EQ 0 ) { G_YONETIM_DB->CANCEL_TRANSACTION(); return; } sql_query.NEXT(); QString aciklama = QObject::tr("Database Name: ") + sql_query.VALUE(0).toString() + QObject::tr(" # Database Definition: ")+ sql_query.VALUE(1).toString(); YONETIM_007_KAYIT ( LOG_PROGRAM, LOG_PROGRAMDAN_CIKIS, aciklama ); G_YONETIM_DB->COMMIT_TRANSACTION (); }
void KULLANICILAR_FORMU::UPDATE_RECORD ( int p_kullanici_id ) { SQL_QUERY sql_query ( G_YONETIM_DB ); sql_query.PREPARE_UPDATE ( "ynt_kullanicilar","kullanici_id","kullanici_kodu,kullanici_adi,parola,email_adresi,email_kullanici_adi,aciklama","kullanici_id = :kullanici_id"); sql_query.SET_VALUE ( ":kullanici_kodu", m_ui->lineEdit_kullanici_kodu->text() ); sql_query.SET_VALUE ( ":kullanici_adi", m_ui->lineEdit_kullanici_adi->text() ); if ( m_ui->check_box_sifre->isChecked() EQ true ) { QByteArray hash = QCryptographicHash::hash ( m_ui->line_edit_yeni_sifre->text().toUtf8(), QCryptographicHash::Md5); m_kullanici_parolasi = QString ( hash.toHex() ); } sql_query.SET_VALUE ( ":parola", m_kullanici_parolasi ); sql_query.SET_VALUE ( ":email_adresi", m_ui->lineEdit_email->text() ); sql_query.SET_VALUE ( ":email_kullanici_adi", m_ui->line_edit_email_kullanici_adi->text() ); sql_query.SET_VALUE ( ":aciklama", m_ui->limitedTextEdit_not->toPlainText() ); sql_query.SET_VALUE ( ":kullanici_id", p_kullanici_id ); sql_query.UPDATE(); QString log_detaylari = "Kullanıcı ID: " + QVariant ( p_kullanici_id).toString() + " # Kullanıcı Kodu: " + m_ui->lineEdit_kullanici_kodu->text() + " # Kullanıcı Adı: " + m_ui->lineEdit_kullanici_adi->text(); YONETIM_007_KAYIT ( LOG_KULLANICILAR, LOG_KAYIT_GUNCELLEME, log_detaylari ); sql_query.PREPARE_DELETE ( "ynt_bilgisayar_kullanicilari","kullanici_id = :kullanici_id"); sql_query.SET_VALUE ( ":kullanici_id", p_kullanici_id ); sql_query.DELETE(); int table_row_count = m_ui->table_widget_bilgisayarlar->rowCount(); if ( table_row_count NE 0 ) { for ( int i = 0; i < table_row_count; i++ ) { int bilgisayar_id = m_ui->table_widget_bilgisayarlar->item( i,BILGISAYAR_ID_COLUMN )->text().toInt(); sql_query.PREPARE_INSERT ( "ynt_bilgisayar_kullanicilari","id","bilgisayar_id,kullanici_id"); sql_query.SET_VALUE ( ":bilgisayar_id", bilgisayar_id ); sql_query.SET_VALUE ( ":kullanici_id", p_kullanici_id ); sql_query.INSERT(); } } sql_query.PREPARE_DELETE ( "ynt_veritabani_kullanicilari","kullanici_id = :kullanici_id" ); sql_query.SET_VALUE ( ":kullanici_id", p_kullanici_id ); sql_query.DELETE(); table_row_count = m_ui->table_widget_veritabanlari->rowCount(); if ( table_row_count NE 0) { for ( int i = 0; i < table_row_count; i++ ) { int veritabani_id = m_ui->table_widget_veritabanlari->item(i,VERITABANI_ID_COLUMN)->text().toInt(); sql_query.PREPARE_INSERT ( "ynt_veritabani_kullanicilari","id","veritabani_id, kullanici_id"); sql_query.SET_VALUE ( ":veritabani_id" , veritabani_id ); sql_query.SET_VALUE ( ":kullanici_id", p_kullanici_id ); sql_query.INSERT(); } } BILGISAYARDA_KAYITLI_KUL_SAY_VE_KULLANICININ_KAYITLI_VERITABANI_SAY_GUNCELLE (); }