public static void GetOrCreatePlayer(ref ServerPlayer a_player, string a_name)
{
if (!SQLWorker.m_inited)
{
SQLWorker.Init();
}
a_player = null;
using (IDbTransaction dbTransaction = SQLWorker.m_sqlConnection.BeginTransaction())
{
SQLWorker.m_sqlCommand.CommandText = "SELECT pid, x, y FROM player WHERE name='" + a_name + "' LIMIT 1;";
using (IDataReader dataReader = SQLWorker.m_sqlCommand.ExecuteReader())
{
if (dataReader.Read())
{
}
dataReader.Close();
}
if (a_player == null)
{
SQLWorker.m_sqlCommand.CommandText = "INSERT INTO player (name) VALUES('" + a_name + "');SELECT last_insert_rowid();";
using (IDataReader dataReader2 = SQLWorker.m_sqlCommand.ExecuteReader())
{
if (!dataReader2.Read())
{
Debug.Log("SQLWorker.cs: ERROR: Couldn't create new player in database?!");
}
dataReader2.Close();
}
}
dbTransaction.Commit();
}
}
public static string GetTitleOfTable(string strField, string strTable, string sWhere)
{
string result = "";
SqlConnection sqlConnection = SQLWorker.CreatedConnection();
DataSet dataSet = new DataSet();
string cmdText = string.Concat(new string[]
{
"SELECT ",
strField,
" FROM ",
strTable,
" WHERE ",
sWhere
});
SqlCommand selectCommand = new SqlCommand(cmdText, sqlConnection);
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(selectCommand);
try
{
sqlConnection.Open();
sqlDataAdapter.Fill(dataSet);
if (dataSet.Tables[0].Rows.Count > 0)
{
result = dataSet.Tables[0].Rows[0][strField].ToString();
}
}
finally
{
sqlConnection.Close();
sqlConnection.Dispose();
}
return(result);
}
public static bool CheckEmail(string email, string tb)
{
bool result = false;
SqlConnection sqlConnection = SQLWorker.CreatedConnection();
string cmdText = string.Concat(new string[]
{
"SELECT COUNT(*) FROM tbl_",
tb,
" WHERE ",
tb,
"_Email='",
email,
"'"
});
SqlCommand sqlCommand = new SqlCommand(cmdText, sqlConnection);
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
try
{
sqlConnection.Open();
int num = (int)sqlCommand.ExecuteScalar();
if (num != 0)
{
result = true;
}
}
finally
{
sqlConnection.Close();
sqlConnection.Dispose();
}
return(result);
}
public static bool SetStatus(string _Table, string _Field, string sqlWhere)
{
string cmdText = string.Concat(new string[]
{
"UPDATE ",
_Table,
" SET ",
_Field,
" WHERE ",
sqlWhere
});
SqlConnection sqlConnection = SQLWorker.CreatedConnection();
SqlCommand sqlCommand = new SqlCommand(cmdText, sqlConnection);
bool result;
try
{
sqlConnection.Open();
sqlCommand.ExecuteNonQuery();
result = true;
}
finally
{
sqlConnection.Close();
}
return(result);
}
public static ArrayList GetRowAsArrayList(DataSet ds, string sKey)
{
SqlConnection sqlConnection = SQLWorker.CreatedConnection();
ArrayList arrayList = new ArrayList();
try
{
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
arrayList.Add(ds.Tables[0].Rows[i][sKey].ToString().Trim());
}
}
}
catch (Exception)
{
}
finally
{
if (sqlConnection.State == ConnectionState.Open)
{
sqlConnection.Close();
sqlConnection.Dispose();
}
}
return(arrayList);
}
public static void ReadEventStream()
{
SQLWorker w = new SQLWorker();
Console.ReadKey();
w.RequestStop();
w.Thread.Join();
}
private void button1_Click(object sender, EventArgs e)
{
if (IsNull(textBox1) || IsNull(textBox2) || IsNull(folderBrowserDialog1.SelectedPath))
{
DialogManager.showDialogError("Empty Fields.");
return;
}
INIManager ini = new INIManager(iniName);
ini.WritePrivateString("Enter", "ServerName", textBox1.Text);
ini.WritePrivateString("Enter", "DataBaseName", textBox2.Text);
ini.WritePrivateString("Enter", "Path", folderBrowserDialog1.SelectedPath);
if (SQLWorker.IsCreate(textBox1.Text, textBox2.Text))
{
sqlWorker = new SQLWorker(textBox1.Text, textBox2.Text);
if (checkBox1.Checked)
{
DataViewPage form1 = new DataViewPage(sqlWorker);
form1.Show();
}
else
{
DialogManager.showDialogInfo("Sucsess! You can close window.");
}
}
else
{
if (DialogManager.showDialogYesNo("Data Base or Server not found. Create new Data Base?"))
{
if (!creater())
{
DialogManager.showDialogError("Error creating database. Try Again.");
if (!SQLWorker.delDB(textBox1.Text, textBox2.Text))
{
DialogManager.showDialogError("Error cleaning data.");
}
return;
}
else
{
sqlWorker = new SQLWorker(textBox1.Text, textBox2.Text);
if (checkBox1.Checked)
{
DataViewPage form1 = new DataViewPage(sqlWorker);
form1.Show();
}
else
{
DialogManager.showDialogInfo("Sucsess! You can close window.");
}
}
}
}
}
public static void ReadEventFile()
{
//SQLWorker w = new SQLWorker(@"c:\Pluralsight\system_health_0_130084612051920000.xel");
//SQLWorker w = new SQLWorker(@"c:\Pluralsight\system_health*xel");
SQLWorker w = new SQLWorker(new string[] { @"c:\Pluralsight\system_health_0_130084611231280000.xel", @"c:\Pluralsight\system_health_0_130084554100160000.xel" });
Console.ReadKey();
w.RequestStop();
w.Thread.Join();
}
public void Startup()
{
sqliteConnection = new SQLiteConnection();
SQLWorker sqlWorker = new SQLWorker(sqliteConnection);
sqlWorker.Initialize();
sqlWorker.Open();
sqlWorker.CreateProductTable();
sqlWorker.CreateProductHistoryTable();
sqlWorker.CreateKeywordHistoryTable();
CreateMainViewModel();
}
public static bool Update(string strTable, Hashtable htTable, string whereSql)
{
SqlConnection sqlConnection = SQLWorker.CreatedConnection();
IDictionaryEnumerator enumerator = htTable.GetEnumerator();
ICollection values = htTable.Values;
string text = "UPDATE [" + strTable + "] SET ";
int num = 0;
while (enumerator.MoveNext())
{
object obj = text;
text = string.Concat(new object[]
{
obj,
(num > 0) ? ", " : "",
enumerator.Key,
"=@value",
num
});
num++;
}
if (whereSql != null && 0 < whereSql.Length)
{
text = text + " WHERE " + whereSql;
}
SqlCommand sqlCommand = new SqlCommand(text, sqlConnection);
num = 0;
foreach (string value in values)
{
sqlCommand.Parameters.AddWithValue("@value" + num, value);
num++;
}
bool result;
try
{
sqlConnection.Open();
sqlCommand.ExecuteNonQuery();
result = true;
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
sqlConnection.Close();
}
return(result);
}
public static bool Insert(string strTable, Hashtable htFieldValue)
{
SqlConnection sqlConnection = SQLWorker.CreatedConnection();
ICollection keys = htFieldValue.Keys;
ICollection values = htFieldValue.Values;
string text = "INSERT INTO [" + strTable + "](";
int num = 0;
foreach (string str in keys)
{
text = text + ((num > 0) ? ", " : "") + str;
num++;
}
num = 0;
text += ") values(";
foreach (string value in values)
{
object obj = text;
text = string.Concat(new object[]
{
obj,
(num > 0) ? ", " : "",
"@value",
num
});
num++;
}
text += ")";
SqlCommand sqlCommand = new SqlCommand(text, sqlConnection);
num = 0;
foreach (string value in values)
{
sqlCommand.Parameters.AddWithValue("@value" + num, value);
num++;
}
bool result;
try
{
sqlConnection.Open();
sqlCommand.ExecuteNonQuery();
result = true;
}
finally
{
sqlConnection.Close();
}
return(result);
}
public DataTable dt_Contentsearch_view(int pagecurrent, int pagesize, string where, string order)
{
DataTable dataTable = new DataTable();
this.command = new SqlCommand("Content_search_view", SQLWorker.CreatedConnection());
this.command.CommandType = CommandType.StoredProcedure;
this.command.Parameters.AddWithValue("@pagesize", pagesize);
this.command.Parameters.AddWithValue("@gotopage", pagecurrent);
this.command.Parameters.AddWithValue("@where_text", where);
this.command.Parameters.AddWithValue("@order_text", order);
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(this.command);
sqlDataAdapter.Fill(dataTable);
sqlDataAdapter.Dispose();
return(dataTable);
}
public static bool SpawnPlayer(ref ServerPlayer a_player, string a_name)
{
SQLWorker.GetOrCreatePlayer(ref a_player, a_name);
if (a_player != null)
{
for (int i = 0; i < SQLManager.m_players.Length; i++)
{
if (SQLManager.m_players[i] == null)
{
SQLManager.m_players[i] = a_player;
SQLManager.m_players[i].m_onlineId = i;
break;
}
}
}
return(true);
}
public static int GetTotalRecord(string sql)
{
int value = 0;
SqlConnection sqlConnection = SQLWorker.CreatedConnection();
SqlCommand sqlCommand = new SqlCommand(sql, sqlConnection);
try
{
sqlConnection.Open();
value = (int)sqlCommand.ExecuteScalar();
}
finally
{
sqlConnection.Close();
}
return(Convert.ToInt32(value));
}
public static DataSet UpdateBySql(string sql)
{
SqlConnection sqlConnection = SQLWorker.CreatedConnection();
DataSet dataSet = new DataSet();
SqlCommand selectCommand = new SqlCommand(sql, sqlConnection);
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(selectCommand);
try
{
sqlDataAdapter.Fill(dataSet);
}
finally
{
sqlConnection.Close();
}
return(dataSet);
}
public static bool UpdateOrder(string sql)
{
SqlConnection sqlConnection = SQLWorker.CreatedConnection();
SqlCommand sqlCommand = new SqlCommand(sql, sqlConnection);
bool result;
try
{
sqlConnection.Open();
sqlCommand.ExecuteNonQuery();
result = true;
}
finally
{
sqlConnection.Close();
}
return(result);
}
//Thaodv modify 11/08/2016
public static object ExecuteSql(string sql)
{
SqlConnection sqlConnection = SQLWorker.CreatedConnection();
SqlCommand sqlCommand = new SqlCommand(sql, sqlConnection);
object result;
try
{
sqlConnection.Open();
result = sqlCommand.ExecuteScalar();
}
finally
{
sqlConnection.Close();
sqlConnection.Dispose();
}
return(result);
}
public static bool Delete(string strTableName, string sqlWhere)
{
SqlConnection sqlConnection = SQLWorker.CreatedConnection();
string commandText = "DELETE FROM [" + strTableName + "] WHERE " + sqlWhere;
IDbCommand dbCommand = sqlConnection.CreateCommand();
dbCommand.CommandText = commandText;
bool result;
try
{
sqlConnection.Open();
dbCommand.ExecuteNonQuery();
result = true;
}
finally
{
sqlConnection.Close();
}
return(result);
}
public static bool CheckUser(string username)
{
bool result = false;
SqlConnection sqlConnection = SQLWorker.CreatedConnection();
string cmdText = "SELECT COUNT(*) FROM tbl_User WHERE Username='******'";
SqlCommand sqlCommand = new SqlCommand(cmdText, sqlConnection);
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
try
{
sqlConnection.Open();
int num = (int)sqlCommand.ExecuteScalar();
if (num != 0)
{
result = true;
}
}
finally
{
sqlConnection.Close();
sqlConnection.Dispose();
}
return(result);
}
private bool creater()
{
return(SQLWorker.createDataBase(textBox1.Text, textBox2.Text, folderBrowserDialog1.SelectedPath));
}
