/// <summary>
/// Function For strQuery sql return boolean
/// </summary>
/// <param name="SerialByte"></param>
/// <param name="DBConfig"></param>
/// <returns></returns>
public static bool DBRowsAffected(string strstrQuery, Connection.Database DBConfig)
{
bool result = false;
using (MySqlConnection conn = new MySqlConnection())
{
DBConfig.OpenConnection(conn);
using (var cmd = new MySqlCommand(strstrQuery, conn))
{
using (MySqlDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
result = true;
}
}
}
}
return(result);
}
/// <summary>
/// Function For Queries Result to String
/// </summary>
/// <param name="ColumnName">Target Column Name</param>
/// <param name="strQuery">strQuery</param>
/// <param name="DBConfig">Database Configuration</param>
/// <returns></returns>
public static string DBRowsString(string strColumnName, string strQuery, Connection.Database DBConfig)
{
string result = "NULL";
using (MySqlConnection conn = new MySqlConnection())
{
DBConfig.OpenConnection(conn);
using (var cmd = new MySqlCommand(strQuery, conn))
{
using (MySqlDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
reader.Read();
result = reader.GetString(strColumnName);
}
}
}
}
return(result);
}
