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 ();
}
