Notes

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Globalization;
using System.Runtime.InteropServices;
using System.IO;
using System.Data.SqlClient;

using System.Windows.Forms;
using System.Threading;

namespace Mouse_Tıklatıcı_PRO
{
class sunucu
{
public SqlConnection Baglanti { get; set; }
public int OnlineKisi { get; set; }
public void SQLCOMMAND(string cmd)
{
SqlCommand kmt;
SqlDataReader oku;
switch (cmd)
{
case "kackisi":
try
{
if (BaglantiKapaliysaAc() == false) return;
BaglantiKapaliysaAc();
kmt = new SqlCommand("SELECT * FROM tiklaTablo", Baglanti);
oku = kmt.ExecuteReader();
while (oku.Read())
{
OnlineKisi = int.Parse(oku["Aktif"].ToString());
}
Baglanti.Close();
}
catch { }
break;

case "güncelle":
try
{
if (BaglantiKapaliysaAc() == false) return;

SQLCOMMAND("kackisi");
BaglantiKapaliysaAc();
kmt = new SqlCommand("UPDATE tiklaTablo SET Aktif=@1", Baglanti);
kmt.Parameters.AddWithValue("@1", OnlineKisi + 1);
kmt.ExecuteNonQuery();
SQLCOMMAND("kackisi");
Baglanti.Close();
}
catch (Exception hata) { MessageBox.Show(hata.Message + "n" + hata.StackTrace); }
break;
case "azalt":
try
{
if (BaglantiKapaliysaAc() == false) return;
SQLCOMMAND("kackisi");
BaglantiKapaliysaAc();
kmt = new SqlCommand("UPDATE tiklaTablo SET Aktif=@1", Baglanti);
kmt.Parameters.AddWithValue("@1", OnlineKisi - 1);
kmt.ExecuteNonQuery();
SQLCOMMAND("kackisi");
Baglanti.Close();
}
catch { }
break;
}
}
bool birkere = false;
public bool BaglantiKapaliysaAc()
{

if (!birkere)
{
Baglanti = new SqlConnection("workstation id = fenerbahceBot.mssql.somee.com; packet size = 4096; user id = ozi59_SQLLogin_1; pwd = k6eo4v4gij; data source = fenerbahceBot.mssql.somee.com; persist security info = False; initial catalog = fenerbahceBot; MultipleActiveResultSets = True;");
// Baglanti = new SqlConnection("Data Source=.; Database=emredb;Integrated Security=True");
birkere = true;
}
try {
if (Baglanti.State != System.Data.ConnectionState.Open)
{
Baglanti.Open();
}
return true;
}
catch {
return false;
//MessageBox.Show("Sunucuya Bağlanılamadı!","Class Error");

}
}
public int OnlineKisiBul()
{
SQLCOMMAND("kackisi");
BaglantiKapaliysaAc();
return OnlineKisi;
}
}
}