public void ExecuteQuery( )
{
try
{
var dataReader = _provider.Accessor.ExecuteQuery(Query);
ReportViewModel report = new ReportViewModel(dataReader);
_manager.ShowDialog(report);
if (RequireUpdate != null)
{
RequireUpdate( );
}
}
catch (OracleException e)
{
_provider.ReportError(e.Message);
}
catch (InvalidOperationException)
{
_provider.ReportError("Invalid query text");
}
catch (NullReferenceException)
{
_provider.ReportError("Connection error");
}
}
public void CommitChanges( )
{
try
{
_provider.Accessor.UpdateTableContent(_tableName, _table);
}
catch (OracleException e)
{
_provider.ReportError(e.Message);
}
}
public void CommitChanges( )
{
List <string> queryList = _created ? CreateTable( ) : AlterTable( );
try
{
foreach (string query in queryList)
{
_provider.Accessor.ExecuteQuery(query).Dispose( );
}
TableName = _tableName.ToUpper( );
MessageBox.Show("Table successfully " + (_created ? "created" : "edited"), "Report", MessageBoxButton.OK, MessageBoxImage.Information);
_created = false;
if (TableEdited != null)
{
TableEdited( );
}
}
catch (Exception e)
{
_provider.ReportError(e.Message);
}
}
public void DeleteTable( )
{
if (SelectedItem == null)
{
return;
}
if (MessageBox.Show("Are you sure you want to delete table " + SelectedItem + '?', "Confirmation", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
try
{
_provider.Accessor.ExecuteQuery("DROP TABLE " + SelectedItem);
MessageBox.Show("Table " + SelectedItem + " has been successfully deleted", "Report", MessageBoxButton.OK, MessageBoxImage.Information);
SelectedItem = null;
Update( );
}
catch (OracleException e)
{
_provider.ReportError(e.Message);
}
}
}