public static void Destroy()
{
Logging.WriteLine("Destroying PhoenixEmu environment...");
if (GetGame() != null)
{
GetGame().Destroy();
Game = null;
}
if (GetConnectionManager() != null)
{
Logging.WriteLine("Destroying connection manager.");
GetConnectionManager().GetListener().Destroy();
GetConnectionManager().DestroyManager();
ConnectionManager = null;
}
if (GetDatabase() != null)
{
try
{
Logging.WriteLine("Destroying database manager.");
MySqlConnection.ClearAllPools();
DatabaseManager = null;
}
catch { }
}
Logging.WriteLine("Uninitialized successfully. Closing.");
}
public void TestBadConnections()
{
MySqlConnectionStringBuilder builder = new
MySqlConnectionStringBuilder();
builder.Pooling = true;
builder.Server = "xxxxxxxx"; // one that definitely does not exist.
builder.UserID = "whoever";
builder.Password = "******";
int numberOfConnections = 1;
for (int i = 0; i < numberOfConnections; ++i)
{
using (MySqlConnection connection = new MySqlConnection(builder.ConnectionString))
{
try
{
connection.Open();
Assert.Fail("Connection should throw an exception.");
}
catch (Exception ex)
{
}
}
Thread.Sleep(50);
}
MySqlConnection.ClearAllPools();
}
private MySqlProvider(MySqlTransaction trans = null)
{
if (trans != null)
{
this.Trans = trans;
this.Conn = trans.Connection;
InTrans = true;
}
else
{
var connString = MySqlConf.ConnString();
try
{
this.Conn = new MySqlConnection(connString);
Conn.Open();
}
catch
{
MySqlConnection.ClearAllPools();
this.Conn = new MySqlConnection(connString);
Conn.Open();
}
}
this.Parameters = new List <DbParameter>();
}
protected override void Dispose(bool disposing)
{
if (Interlocked.Decrement(ref total) == 0)
{
MySqlConnection.ClearAllPools();
}
}
private void fillPerTicket(int ticketId)
{
DataTable ticketTable = new DataTable();
using (MySqlConnection myConn = new MySqlConnection(myConnString))
{
//string query = "select * from TechDailyTicket where techId = " + box.SelectedValue + ";";
string query = "SELECT * FROM PerTicket WHERE ticketId=" + ticketId + ";"; //always add one for starters
Console.WriteLine(query);
using (MySqlCommand myComm = new MySqlCommand(query, myConn))
{
MySqlDataAdapter myAdapter = new MySqlDataAdapter();
myAdapter.SelectCommand = myComm;
myAdapter.Fill(ticketTable);
myComm.Dispose();
}
myConn.Close();
myConn.Dispose();
MySqlConnection.ClearPool(myConn);
}
MySqlConnection.ClearAllPools();
//this.perticketTableAdapter.Fill(ticketTable);
this.partsOnTixDisplay.DataSource = ticketTable;
resetPartsOnDisplayForRowOne();
}
private void deleteButton_Click(object sender, EventArgs e)
{
int ticketId = selectedTicket;
int itemId = selectedPartToRemove;
if (ticketId == -1 || itemId == -1)
{
return;
}
using (MySqlConnection myConn = new MySqlConnection(myConnString))
{
//string query = "select * from TechDailyTicket where techId = " + box.SelectedValue + ";";
string query = "DELETE FROM ItemsUsed WHERE ticketId=" + ticketId + " AND itemId=" + itemId + ";"; //always add one for starters
Console.WriteLine(query);
using (MySqlCommand myComm = new MySqlCommand(query, myConn))
{
myComm.Connection.Open();
myComm.ExecuteNonQuery();
myComm.Dispose();
}
myConn.Close();
myConn.Dispose();
MySqlConnection.ClearPool(myConn);
}
MySqlConnection.ClearAllPools();
//refresh the per ticket stuff
fillPerTicket(ticketId);
}
public static void smethod_16()
{
Logging.WriteLine("Destroying GoldTreeEmu environment...");
if (GoldTree.GetGame() != null)
{
GoldTree.GetGame().ContinueLoading();
GoldTree.Game = null;
}
if (GoldTree.smethod_14() != null)
{
Logging.WriteLine("Destroying connection manager.");
GoldTree.smethod_14().method_3().method_2();
GoldTree.smethod_14().method_0();
GoldTree.ConnectionManage = null;
}
if (GoldTree.GetDatabase() != null)
{
try
{
Logging.WriteLine("Destroying database manager.");
MySqlConnection.ClearAllPools();
GoldTree.DatabaseManager = null;
}
catch
{
}
}
Logging.WriteLine("Uninitialized successfully. Closing.");
}
public virtual void Teardown()
{
MySqlConnection.ClearAllPools();
#if !RT
CheckOrphanedConnections();
#endif
conn.Close();
if (Version.Major < 5)
{
suExecSQL("REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'test'");
}
else
{
suExecSQL("DROP USER 'test'@'localhost'");
}
DropDatabase(database0);
DropDatabase(database1);
DropDatabase("Perm");
if (rootConn.State == ConnectionState.Open)
{
rootConn.Close();
}
}
protected virtual void Dispose(bool disposing)
{
if (disposed)
{
return;
}
if (disposing)
{
MySqlConnection.ClearAllPools();
#if !RT
CheckOrphanedConnections();
#endif
if (rootConn.State == ConnectionState.Closed)
{
rootConn.Open();
}
DropDatabase(database0);
DropDatabase(database1);
DropDatabase("Perm");
rootConn.Close();
conn.Close();
}
disposed = true;
}
public System.Data.DataTable ExecuteDataTable(System.Data.CommandType cmdType, string cmdText, params System.Data.Common.DbParameter[] commandParameters)
{
MySqlCommand cmd = new MySqlCommand();
MySqlConnection conn = new MySqlConnection(connectionString);
try
{
MySqlConnection.ClearAllPools();
PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);
DataTable dt = new DataTable();
MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);
adapter.Fill(dt);
return(dt);
}
catch
{
conn.Close();
throw;
}
finally
{
conn.Close();
}
}
public static void Fatal(Exception ex, string Source)
{
HttpContext.Current.Response.StatusCode = 500;
try
{
try
{
if (ex.GetBaseException().GetType().ToString() == "MySql.Data.MySqlClient.MySqlException")
{
MySqlConnection.ClearAllPools();
}
}
catch { }
Fatal("[" + ex.GetBaseException().GetType().ToString() + "]" + ex.GetBaseException().Message, ex.GetBaseException().ToString(), "Fatal " + ex.GetBaseException().GetType().ToString(), Source);
}
catch
{
try
{
if (ex.GetType().ToString() == "MySql.Data.MySqlClient.MySqlException")
{
MySqlConnection.ClearAllPools();
}
}
catch { }
Fatal("[" + ex.GetType().ToString() + "]" + ex.Message, ex.ToString(), "Fatal " + ex.GetType().ToString(), Source);
}
}
public void SetupDatabase()
{
Thread.Sleep(10000);
const string database = "countries";
for (int i = 0; i < 20; i++)
{
try
{
using var connection = new MySqlConnection(Configuration.GetConnectionString("Root"));
connection.Open();
var command = new MySqlCommand($"create database if not exists `{database}`", connection);
command.ExecuteNonQuery();
connection.Close();
break;
}
catch (Exception)
{
if (i == 19)
{
throw;
}
}
MySqlConnection.ClearAllPools();
Thread.Sleep(5000);
}
CreateCountryTable();
}
public static void Destroy()
{
Program.DeleteMenu(Program.GetSystemMenu(Program.GetConsoleWindow(), true), Program.SC_CLOSE, Program.MF_BYCOMMAND);
Logging.WriteLine("Destroying GoldTreeEmu environment...");
if (GoldTree.GetGame() != null)
{
GoldTree.GetGame().ContinueLoading();
GoldTree.Internal_Game = null;
}
if (GoldTree.GetSocketsManager() != null)
{
Logging.WriteLine("Destroying connection manager.");
GoldTree.GetSocketsManager().method_3().method_2();
//GoldTree.smethod_14().Destroy();
GoldTree.GetSocketsManager().method_0();
GoldTree.SocketsManager = null;
}
if (GoldTree.GetDatabase() != null)
{
try
{
Logging.WriteLine("Destroying database manager.");
MySqlConnection.ClearAllPools();
GoldTree.DatabaseManager = null;
}
catch
{
}
}
Logging.WriteLine("Uninitialized successfully. Closing.");
}
protected void Button1_Click1(object sender, EventArgs e)
{
MySqlConnection.ClearAllPools();
using (MySqlConnection con = new MySqlConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
using (MySqlCommand com = new MySqlCommand("SELECT username,password FROM PROFILE", con))
{
using (MySqlDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
if (reader.GetString("username") == tbUsername.Text && reader.GetString("password") == tbPassword.Text)
{
Label1.Text = "พบผู้ใช้งาน";
Label1.Visible = true;
}
else
{
Label1.Text = "ไม่พบผู้ใช้งานหรือรหัสผ่านไม่ถูกต้อง";
Label1.Visible = true;
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertmessage", "alert('ไม่พบผู้ใช้งานหรือรหัสผ่านไม่ถูกต้อง')", true);
}
}
}
}
}
}
public static void BindGridView(GridView gv, string sql)
{
MySqlConnection.ClearAllPools();
SqlDataSource sds = CreateSQLDataSource(sql);
gv.DataSource = sds;
gv.DataBind();
}
public static void BindDropDownNon(DropDownList ddl, string sql, string text, string value)
{
MySqlConnection.ClearAllPools();
ddl.DataSource = CreateSQLDataSource(sql);
ddl.DataTextField = text;
ddl.DataValueField = value;
ddl.DataBind();
}
/// <summary>
/// 关闭MySql连接池，释放资源
/// </summary>
internal static void Close()
{
try
{
MySqlConnection.ClearAllPools();
}
catch { }
}
protected virtual void Dispose(bool disposing)
{
if (disposing)
{
Connection.Dispose();
MySqlConnection.ClearAllPools();
}
}
public override async Task DeleteAsync(CancellationToken cancellationToken = default(CancellationToken))
{
MySqlConnection.ClearAllPools();
using (var workingConnecton = _connection.CreateSystemConnection())
{
await _migrationCommandExecutor.ExecuteNonQueryAsync(GetDropOps(), workingConnecton, cancellationToken);
}
}
//public override void CreateTables()
//{
// IReadOnlyList<MigrationOperation> ops = modelDiffer.GetDifferences(null, Model);
// IReadOnlyList<SqlBatch> sqlBatches = sqlGenerator.Generate(ops, Model);
// SqlStatementExecutor.ExecuteNonQuery(connection, connection.DbTransaction, sqlBatches);
//}
//public override async Task CreateTablesAsync(CancellationToken cancellationToken = default(CancellationToken))
//{
// IReadOnlyList<MigrationOperation> ops = modelDiffer.GetDifferences(null, Model);
// IReadOnlyList<SqlBatch> sqlBatches = sqlGenerator.Generate(ops, Model);
// await SqlStatementExecutor.ExecuteNonQueryAsync(connection, connection.DbTransaction, sqlBatches, cancellationToken);
//}
public override void Delete()
{
MySqlConnection.ClearAllPools();
using (var workingConnecton = _connection.CreateSystemConnection())
{
_migrationCommandExecutor.ExecuteNonQuery(GetDropOps(), workingConnecton);
}
}
public static void BindDropDown(DropDownList ddl, string sql, string text, string value, string first)
{
MySqlConnection.ClearAllPools();
ddl.DataSource = CreateSQLDataSource(sql);
ddl.DataTextField = text;
ddl.DataValueField = value;
ddl.DataBind();
ddl.Items.Insert(0, new ListItem(first, ""));
}
public virtual void Dispose(bool disposing)
{
if (disposing)
{
MySqlConnection.ClearAllPools();
execSQL($"DROP DATABASE IF EXISTS `{Connection.Database}`");
Connection.Close();
}
}
/**
* Dispose all MySQL connections
*/
public static void mysqlDispose()
{
if (dbConn != null)
{
dbConn.Close();
dbConn.Dispose();
MySqlConnection.ClearAllPools();
}
}
/// <summary>
///
/// </summary>
public override void ClearAllPools()
{
try
{
MySqlConnection.ClearAllPools();
}
catch (Exception e)
{
TraceLog.WriteSqlError("ClearAllPools error:{0}", e);
}
}
public MySqlConnection baglan() // class içinde baglan adında fonksiyon oluşturduk
{
MySqlConnection baglanti = new MySqlConnection("Server=localhost;Database=schoolproject;Uid=root;Pwd=;");
//bağlantı yolunu verdik
baglanti.Open(); //bağlantıyı açtık
MySqlConnection.ClearPool(baglanti);
MySqlConnection.ClearAllPools(); //bundan önceki bağlantıları temizledik
return(baglanti); //çağırıldığı yere bağlantıyı yolladık
}
private bool disposedValue = false; // To detect redundant calls
protected virtual void Dispose(bool disposing)
{
if (!disposedValue)
{
if (disposing)
{
MySqlConnection.ClearAllPools();
}
disposedValue = true;
}
}
internal protected virtual void Initialize()
{
// we don't use FileVersion because it's not available
// on the compact framework
string fullname = Assembly.GetExecutingAssembly().FullName;
string[] parts = fullname.Split(new char[] { '=' });
string[] versionParts = parts[1].Split(new char[] { '.' });
database0 = String.Format("db{0}{1}{2}-a", versionParts[0], versionParts[1], port - 3300);
database1 = String.Format("db{0}{1}{2}-b", versionParts[0], versionParts[1], port - 3300);
MySqlConnection.ClearAllPools();
}
public void Refresh(string name, string master, params string[] slaves)
{
MySqlConnection.ClearAllPools();
ConnectionManager.Remove(name);
ConnectionManager.Add(name, master, false);
if (slaves?.Length > 0)
{
foreach (var conn in slaves)
{
ConnectionManager.Add(name, conn, true);
}
}
}
public void OneTimeTearDownAttribute()
{
MySqlConnection.ClearAllPools();
CleanupDatabase();
if (Connection != null && Connection.State == ConnectionState.Open)
{
Connection.Close();
}
if (Root != null && Root.State == ConnectionState.Open)
{
Root.Close();
}
}
protected virtual void Dispose(bool disposing)
{
if (disposed)
{
return;
}
if (disposing)
{
MySqlConnection.ClearAllPools();
CleanupDatabase();
}
disposed = true;
}