public short DuzenleKurumParametreleri(TBLKURUM_PARAMETRELERI ptKurumParametreleri) { try { DbCommand dbCommand = db.GetSqlStringCommand("UPDATE TBLKURUM_PARAMETRELERI SET KURUM_ADI=@KURUM_ADI, ADRES=@ADRES, TELEFON=@TELEFON, FAX=@FAX, VERGI_DAIRESI=@VERGI_DAIRESI, VERGI_NO=@VERGI_NO, TIC_SICIL_NO=@TIC_SICIL_NO, SMTP_ADRES=@SMTP_ADRES, SMTP_PORT=@SMTP_PORT, MAIL=@MAIL, MAILSIFRE=@MAILSIFRE, AKTIF=@AKTIF WHERE ID=@ID"); db.AddInParameter(dbCommand, "ID", DbType.String, ptKurumParametreleri.ID); db.AddInParameter(dbCommand, "KURUM_ADI", DbType.String, ptKurumParametreleri.KURUM_ADI); db.AddInParameter(dbCommand, "ADRES", DbType.String, ptKurumParametreleri.ADRES); db.AddInParameter(dbCommand, "TELEFON", DbType.String, ptKurumParametreleri.TELEFON); db.AddInParameter(dbCommand, "FAX", DbType.String, ptKurumParametreleri.FAX); db.AddInParameter(dbCommand, "VERGI_DAIRESI", DbType.String, ptKurumParametreleri.VERGI_DAIRESI); db.AddInParameter(dbCommand, "VERGI_NO", DbType.String, ptKurumParametreleri.VERGI_NO); db.AddInParameter(dbCommand, "TIC_SICIL_NO", DbType.String, ptKurumParametreleri.TIC_SICIL_NO); db.AddInParameter(dbCommand, "SMTP_ADRES", DbType.String, ptKurumParametreleri.SMTP_ADRES); db.AddInParameter(dbCommand, "SMTP_PORT", DbType.Int32, ptKurumParametreleri.SMTP_PORT); db.AddInParameter(dbCommand, "MAIL", DbType.String, ptKurumParametreleri.MAIL); db.AddInParameter(dbCommand, "MAILSIFRE", DbType.String, ptKurumParametreleri.MAILSIFRE); db.AddInParameter(dbCommand, "AKTIF", DbType.Int16, (short)ptKurumParametreleri.AKTIF); db.ExecuteNonQuery(dbCommand); return(1); } catch (Exception ex) { cLog.Write(ex, _iKullaniciID); return(0); } }
public short EkleKurumParametreleri(TBLKURUM_PARAMETRELERI ptKurumParametreleri) { try { DbCommand dbCommand = db.GetSqlStringCommand("INSERT INTO TBLKURUM_PARAMETRELERI(KURUM_ADI, ADRES, TELEFON, FAX, VERGI_DAIRESI, VERGI_NO, TIC_SICIL_NO,SMTP_ADRES,SMTP_PORT,MAIL,MAILSIFRE,AKTIF) VALUES(@KURUM_ADI, @ADRES, @TELEFON, @FAX, @VERGI_DAIRESI, @VERGI_NO, @TIC_SICIL_NO, @SMTP_ADRES, @SMTP_PORT, @MAIL, @MAILSIFRE, @AKTIF) SELECT @@IDENTITY"); db.AddInParameter(dbCommand, "KURUM_ADI", DbType.String, ptKurumParametreleri.KURUM_ADI); db.AddInParameter(dbCommand, "ADRES", DbType.String, ptKurumParametreleri.ADRES); db.AddInParameter(dbCommand, "TELEFON", DbType.String, ptKurumParametreleri.TELEFON); db.AddInParameter(dbCommand, "FAX", DbType.String, ptKurumParametreleri.FAX); db.AddInParameter(dbCommand, "VERGI_DAIRESI", DbType.String, ptKurumParametreleri.VERGI_DAIRESI); db.AddInParameter(dbCommand, "VERGI_NO", DbType.String, ptKurumParametreleri.VERGI_NO); db.AddInParameter(dbCommand, "TIC_SICIL_NO", DbType.String, ptKurumParametreleri.TIC_SICIL_NO); db.AddInParameter(dbCommand, "SMTP_ADRES", DbType.String, ptKurumParametreleri.SMTP_ADRES); db.AddInParameter(dbCommand, "SMTP_PORT", DbType.Int32, ptKurumParametreleri.SMTP_PORT); db.AddInParameter(dbCommand, "MAIL", DbType.String, ptKurumParametreleri.MAIL); db.AddInParameter(dbCommand, "MAILSIFRE", DbType.String, ptKurumParametreleri.MAILSIFRE); db.AddInParameter(dbCommand, "AKTIF", DbType.Int16, (short)ptKurumParametreleri.AKTIF); return(db.ExecuteScalar(dbCommand).ToShort(0)); } catch (Exception ex) { cLog.Write(ex, _iKullaniciID); return(0); } }