public string ExecuteNonQuery(string sql_query, SQLiteParameter[] parameters)
{
string res = string.Empty;
if (_connection.State == ConnectionState.Open)
{
CloseConnection();
}
_connection.Open();
_command = _connection.CreateCommand();
_command.CommandText = sql_query;
if (parameters != null)
{
_command.Parameters.AddRange(parameters);
}
try
{
_command.ExecuteNonQuery();
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("ERROR! " + ex.Message + "\r\n" + ex.StackTrace);
res = CreateExceptionMessage(ex);
}
_connection.Close();
return res;
}