/// <summary>
/// Выполняет запрос SQL
/// </summary>
/// <param name="query"> запрос SQL</param>
public static void QuerySQL(string query)
{
try
{
SqlCommand sqlComm = new SqlCommand();
sqlComm = mySqlConnection.CreateCommand();
sqlComm.CommandText = query;
mySqlConnection.Open();
sqlComm.ExecuteNonQuery();
mySqlConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButton.OK);
Log.Write(ex, "Ошибка при выполнения запроса !!!");
ConnectionStringDataBase.Delete();
Environment.Exit(0);
throw ex;
}
finally
{
if (mySqlConnection != null && mySqlConnection.State != ConnectionState.Closed)
{
mySqlConnection.Dispose();
}
}
}
/// <summary>
/// Метод принимает запроси возвращает таблицу DataTable
/// </summary>
/// <param name="query">запрос Sql</param>
/// <returns>DateTable</returns>
public static DataTable SelectToDateTable(string query)
{
try
{
SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
mySqlCommand.CommandText = query;
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();
mySqlDataAdapter.SelectCommand = mySqlCommand;
DataSet myDataSet = new DataSet();
mySqlConnection.Open();
mySqlDataAdapter.Fill(myDataSet, "table");
mySqlConnection.Close();
DataTable myDataTable = myDataSet.Tables["table"];
return(myDataTable);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButton.OK);
Log.Write(ex, "Ошибка при выполнения запроса !!! ");
ConnectionStringDataBase.Delete();
Environment.Exit(0);
throw ex;
}
finally
{
if (mySqlConnection != null && mySqlConnection.State != ConnectionState.Closed)
{
mySqlConnection.Dispose();
}
}
}
/// <summary>
/// Проверка подключения к БД
/// </summary>
/// <returns></returns>
public static bool CheckConnection()
{
try
{
using (SqlConnection connection = new SqlConnection(ConnectionStringDataBase.Read()))
{
int dircount = 0;
connection.Open();
SqlCommand cmd = new SqlCommand("SELECT count(*) FROM sys.Tables", connection);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
dircount = Convert.ToInt32(reader[0]);
}
}
if (dircount > 0)
{
return(true);
}
else
{
return(false);
}
}
}
catch
{
return(false);
}
}
/// <summary>
/// Возвращает строку подключения
/// </summary>
/// <returns>string </returns>
public static string ConnectionString()
{
try
{
ConfigTxt config = new ConfigTxt();
return(ConnectionStringDataBase.Read());
}
catch (Exception ex)
{
Log.Write(ex, " - Ошибкав с троке подключения !!!");
throw ex;
}
}
