C# WEB SERVICE SORGULAMASI

using System;
using System.Windows.Forms;

namespace BMSLicenseKontrol
{
    public partial class Form1 : DevExpress.XtraEditors.XtraForm
    {
        public Form1()
        {
            InitializeComponent();
        }


        private void button1_Click(object sender, EventArgs e)
        {



        }

        private void simpleButton1_Click(object sender, EventArgs e)
        {
            ServiceBMSLicense.LicenseServiceSoapClient SBMSLicense = new ServiceBMSLicense.LicenseServiceSoapClient();
            SBMSLicense.LicenseQuery(lisans.Text, GetStatikIp.GetIPAddress());
            MessageBox.Show(SBMSLicense.LicenseQuery(lisans.Text, GetStatikIp.GetIPAddress()).Rows[0][6].ToString()); //0rıncı row 6ıncı column MSGBOXDA GOSTER
            gridControl1.DataSource = SBMSLicense.LicenseQuery(lisans.Text, GetStatikIp.GetIPAddress());//ISDERSEN DIREK DONUSU GRIDVIEWDE GOSTER


        }
    }
}

c# CLASS GET STATIK IP

using System;
using System.IO;
using System.Net;

namespace BMSLicenseKontrol
{
    class GetStatikIp
    {
        public static string GetIPAddress()

        {

            String address = "";

            WebRequest request = WebRequest.Create("http://checkip.dyndns.org/");

            using (WebResponse response = request.GetResponse())

            using (StreamReader stream = new StreamReader(response.GetResponseStream()))

            {

                address = stream.ReadToEnd();

            }

            int first = address.IndexOf("Address: "+ 9;

            int last = address.LastIndexOf("");

            address = address.Substring(first, last - first);

            return address;

        }
    }
}

alastyr plesk windows hostinge pcdeki sql serverden baglanma

once pleski acip sol tarafdan databesisden yeni kullanici yarat
ms sql secili olsun allow remote connections from secip altina who.isden ipni yaz

daha sonra database yeni database server sql server

sql serverede
server name sadece ornekserver.com yazilmasi yeterli
login pleskte database kısmında user managementta yaratilan kullanici ve parola

——————-
visual studio asp proje deploy,
pleske visual studio aspxlerin projelerini ataiblmek icin alastyre pleskte web deployu aktif etmelerini soyle.
bu tarz link mail atacaklar sana https://mywebsite.xyz:8172/msdeploy.axd?site=mywebsite.xyz
bunu visual studioda solutiona sag tikla publishden web deployu secerek.

server: https://mywebsite.xyz:8172/msdeploy.axd?site=mywebsite.xyz
site: mywebsite.xyz/sw/test
user name:mywebsite (hostu alirken attiklari kullanici adi)
password:parola (hostu alirken attiklari kullanici adi)
destination url:mywebsite.xyz/sw/test

Bootstrap Pass ID to Modal

 http://vendor/datatables/buttons/jquery-3.2.1.slim.min.js
 http://vendor/datatables/buttons/popper.min.js
 
 
 

Open Modal

Laravel Php QuickAdmin Github

https://github.com/LaravelDaily/quickadmin

c:\wamp64\www icine LaravelDaily klasor yarat not php 7 ve ustu olmalı systen enviromant path..
eğer pcde hem iis hem wamp kullanıyorsun portlar cakisacak wampin portunu deis

C:\wamp64\bin\apache\apache2.4.35\conf\httpd.conf
Listen 0.0.0.0:80>>Listen 0.0.0.0:8081
Listen [::0]:80>>Listen [::0]:8081

c:\wamp64\www icine LaravelDaily klasor yarat
ve cmdde oraya git
composer global require laravel/installer
composer create-project laravel/laravel QuickAdmin –prefer-dist

cd QuickAdmin
composer clear-cache
composer require laraveldaily/quickadmin

open;
C:\wamp64\www\LaravelDaily\QuickAdmin\config\app.php

in the $providers array;
Laraveldaily\Quickadmin\QuickadminServiceProvider::class,

C:\wamp64\www\LaravelDaily\QuickAdmin\.env
*database connection is required. Check your .env file
DB_CONNECTION=mysql

DB_HOST=localhost

DB_PORT=3306

DB_DATABASE=quickadmin

DB_USERNAME=root

DB_PASSWORD=

———————
C:\wamp64\www\LaravelDaily\QuickAdmin\app\Providers\AppServiceProvider.php dosyasını duzenle
use Illuminate\Support\Facades\Schema;
public function boot()
    {
 Schema::defaultStringLength(191);
}
——————
php artisan quickadmin:install
kullanıcı adı eposta sifre belirle
——————–
C:\wamp64\www\LaravelDaily\QuickAdmin\app\Http\Kernel.php
bu kismin icine asagidakini ekle protected $routeMiddleware = [
‘role’ => \Laraveldaily\Quickadmin\Middleware\HasPermissions::class,

————–
datatablellarda export etmesini isdersen : bu dosyayı bul ekle
C:\wamp64\www\LaravelDaily\QuickAdmin\resources\views\admin\partials\javascripts.blade.php

https://cdn.datatables.net/buttons/1.5.2/js/dataTables.buttons.min.js 
https://cdn.datatables.net/buttons/1.5.2/js/buttons.flash.min.js 
https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js 
https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/pdfmake.min.js 
https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/vfs_fonts.js 
https://cdn.datatables.net/buttons/1.5.2/js/buttons.html5.min.js 
https://cdn.datatables.net/buttons/1.5.2/js/buttons.print.min.js 

ve bu boyle olsun
    $(‘#datatable’).dataTable( {
        “language”: {
            “url”: “{{ trans(‘quickadmin::strings.datatable_url_language’) }}”
        },
        dom: ‘Bfrtip’
    });
—————
dili türkçeleştirmek için bu dosyadan:C:\wamp64\www\LaravelDaily\QuickAdmin\resources\lang\vendor\laraveldaily\en\admin.php
—————–
eger menuden fazlaliklari kaldirmak isdersen dosyayı düzenle : C:\wamp64\www\LaravelDaily\QuickAdmin\resources\views\admin\partials\sidebar.blade.php

son olarak
php artisan serve ve http://127.0.0.1:8000/admin git

React native app

https://nodejs.org/en/download/ indir ve kur
https://www.sublimetext.com/3 kur
sublime ac->view->show consolea gir ve burdaki kodlari ekle
https://packagecontrol.io/installation
android studio ve bluestack kur
https://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html
Windows x64 207.22 MB  jdk-8u191-windows-x64.exe kur

cmd
npm install -g expo-cli
npm install -g react-native-cli
npm install -g create-react-native-app
react-native init projectNameHere
cd projectNameHere
react-native run-android

ENVIRMNT USER PATH
%LOCALAPPDATA%\Android\sdk\platform-tools

SYSTEM PATH:C:\Program Files\Java\jdk1.8.0_191
SYSTEM NEW JAVA_HOME C:\Program Files\Java\jdk1.8.0_191
F:\masaustussd\react native\test\android\ klasorunun icine local.properties isminde dosya YARAT ve icine sdk.dir = C:\\Users\\Pnp\\AppData\\Local\\Android\\sdk

KanBoard Pano , Database ve Mail Yollama Ayarları

https://github.com/kanboard/kanboard indirip ftpye at direk çalışır…
Aşağıdaki sorguda Panoyu türkçe yapabilirsin. Ama database silip baştan yükleyince sıfırlanır.

update `columns` set title =’On Hazirlik’ WHERE title =’Backlog’;
update `columns` set title =’Yapilacaklar’ WHERE title =’Ready’;
update `columns` set title =’Tamamlandi’ WHERE title =’Done’;
update `columns` set title =’Yapiliyor’ WHERE title =’Work in progress’;
————————————————

Eğer Backlogun hiç cıkmasını isdemezsen
delete from `columns` WHERE title =’tBacklog’

—————————————————
NOT TÜRKÇE KARAKTER KULLANMA
Bir sonraki yeni proje yaratmalarında backlog otomatik olarak gelmesin ve diğer panolar türkçe olarak gelsin isdeniyorusa /app/Model/BoardModel.php içindeki return array(t(‘Backlog’), t(‘Ready’), t(‘Work in progress’), t(‘Done’)); satırını şu şekilde yap
return array( t(‘Yapilacaklar’), t(‘Yapiliyor’), t(‘Tamamlandi’));

————–

Eğer Database mail ayarlarını yapacaksan ana roottaki config.default.php adını config.php yapip değerlerini vermelisin ornegin default sqldb veritabanı olarak kullanılır ama mysql kullanılması isdeniyorsa ayarının config.php’nin içinden yapılması gerekir. Mail ayarınında aynı yerden yapılması gerekir(gönderen maili).

MYSQL Ayar örneği;
// Sendmail command to use when the transport is “sendmail”
define(‘MAIL_SENDMAIL_COMMAND’, ‘/usr/sbin/sendmail -bs’);

// Run automatically database migrations
// If set to false, you will have to run manually the SQL migrations from the CLI during the next Kanboard upgrade
// Do not run the migrations from multiple processes at the same time (example: web page + background worker)
define(‘DB_RUN_MIGRATIONS’, true);

// Database driver: sqlite, mysql or postgres (sqlite by default)
define(‘DB_DRIVER’, ‘mysql’);

// Mysql/Postgres username
define(‘DB_USERNAME’, ‘pnpwebdisign_trl’);

// Mysql/Postgres password
define(‘DB_PASSWORD’, ’12ssssw’);

// Mysql/Postgres hostname
define(‘DB_HOSTNAME’, ‘localhost’);

// Mysql/Postgres database name
define(‘DB_NAME’, ‘pnpwebdisign_trl’);

// Mysql/Postgres custom port (null = default port)
define(‘DB_PORT’, null);

// Mysql SSL key
define(‘DB_SSL_KEY’, null);
————————

Gmailden Mail Yollama Ayarı;

// Enable/disable email configuration from the user interface
define(‘MAIL_CONFIGURATION’, true);

// E-mail address used for the “From” header (notifications)
define(‘MAIL_FROM’, ‘pxxxx@gmail.com’);

// Mail transport available: “smtp”, “sendmail”, “mail” (PHP mail function), “postmark”, “mailgun”, “sendgrid”
define(‘MAIL_TRANSPORT’, ‘smtp’);

// SMTP configuration to use when the “smtp” transport is chosen
define(‘MAIL_SMTP_HOSTNAME’, ‘smtp.gmail.com’);
define(‘MAIL_SMTP_PORT’, 465);
define(‘MAIL_SMTP_USERNAME’, ‘pxxxx@gmail.com’);
define(‘MAIL_SMTP_PASSWORD’, ‘123sxe’);
define(‘MAIL_SMTP_ENCRYPTION’, ‘ssl’); // Valid values are “null”, “ssl” or “tls”

// Sendmail command to use when the transport is “sendmail”
define(‘MAIL_SENDMAIL_COMMAND’, ‘/usr/sbin/sendmail -bs’);

———————
Notificationlar mail olarak giderken mail başlığında admin via kanboard vb… yazar onu deiştirmek için /trello/1/app/Core/Mail/client.phpde

$author = e('%s via Kanboard', $this->helper->user->getFullname()); 

$author = e('%s Tarafından Gönderilen Bilgilendirme', $this->helper->user->getFullname()); 

Sentez Live web ayarı

/Live/WebApp/LiveWebReport_3004.zip indir

liveweb denetim masasından windows özellik yükleden internet information service>world wide web services>application development features .netler aspleri seç ve yükle

daha sonra Internet Information Services (IIS) Manager aç Add Website ye bas LiveWebReport_3004.zip  nereye cıkarttıysan orayı göster ve o klasore everyone yetkisi ver, Daha sonra yine iisden application poolsdan ekledğin siteye çift tıkla .net clr version v4 olsun ve classic olsun ok de ve recyclea bas, LiveServer.exeyi çalıştır ve siteye gir