/// <summary>
/// Add new row event handler
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void AddNewRowHandler(object sender, TableModel args)
{
ToggleRowFlyout();
MainWindowViewModel.FlyoutRowModel = new TableRowModel();
_flyoutTableModel = args;
_flyoutRowEventArgs = null;
}
/// <summary>
/// Edit row event handler
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void EditRowHandler(object sender, EditRowEventArgs args)
{
ToggleRowFlyout();
MainWindowViewModel.FlyoutRowModel = new TableRowModel(args.RowModel.Name, args.RowModel.Datatype);
MainWindowViewModel.FlyoutRowModel.AllowNull = args.RowModel.AllowNull;
_flyoutRowEventArgs = args;
_flyoutTableModel = args.TableModel;
}
/// <summary>
/// Drop column handler
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public async void RemoveRowHandler(object sender, EditRowEventArgs e)
{
_flyoutTableModel = e.TableModel;
_flyoutRowEventArgs = e;
var res = _updater.RemoveColumn(_flyoutTableModel, ref _flyoutRowEventArgs);
if (res != null)
{
await this.ShowMessageAsync("Drop column", res);
Output.WriteLine(OutputPanelListener.PrepareException(res));
}
}
private bool TryGetSelectedRow(out EditRowEventArgs args)
{
int index = TableDataGrid.SelectedIndex;
if (index < 0)
{
args = null;
return(false);
}
args = new EditRowEventArgs()
{
RowModel = ViewModel.Model.Attributes[index],
TableModel = ViewModel.Model
};
return(true);
}
/// <summary>
/// Drop column in table
/// </summary>
/// <param name="table">Table model</param>
/// <param name="args">Arguments provided by drop event</param>
/// <returns>Exception message if failed, NULL if not</returns>
public string RemoveColumn(TableModel table, ref EditRowEventArgs args)
{
var ctx = new DatabaseContext(SessionProvider.Instance.ConnectionType);
try
{
ctx.RemoveColumn(table.Title, args.RowModel.Name);
return(null);
}
catch (Exception exception) when(exception is SqlException || exception is OracleException || exception is ApplicationException)
{
Output.WriteLine(OutputPanelListener.PrepareException(exception.Message));
return(exception.Message);
}
finally
{
TableModel model = ctx.ReadTableDetails(table.Id, table.Title);
table.RefreshModel(model);
args = null;
}
}
private static void grid_EditRowPostBackCancel(object sender, EditRowEventArgs e)
{
e.AcceptChanges = false;
}
private static void grid_EditRowSuccess(object sender, EditRowEventArgs e)
{
e.AcceptChanges = true;
}
protected virtual void OnRemoveSelectedRow(EditRowEventArgs e)
{
RemoveSelectedRow?.Invoke(this, e);
}
protected virtual void OnEditSelectedRow(EditRowEventArgs e)
{
EditSelectedRow?.Invoke(this, e);
}
private static void grid_EditRowSuccess(object sender, EditRowEventArgs e)
{
e.AcceptChanges = true;
}
private static void grid_EditRowPostBackCancel(object sender, EditRowEventArgs e)
{
e.AcceptChanges = false;
}
/// <summary>
/// Add new column or update existing in DB
/// </summary>
/// <param name="model">Table model</param>
/// <param name="column">Column model</param>
/// <param name="refreshedModel">Model with new attributes</param>
/// <param name="args">Arguments provided by add/update event</param>
/// <returns>Exception message if failed, NULL if not</returns>
public string AddOrUpdateCollumn(TableModel model, TableRowModel column, out TableModel refreshedModel, ref EditRowEventArgs args)
{
var err = args == null?AddColumn(model.Title, column) : UpdateColumn(model.Title, column);
if (args != null)
{
if (!args.RowModel.Name.Equals(column.Name))
{
err = RenameColumn(model.Title, args.RowModel.Name, column.Name);
}
}
refreshedModel = err != null ? null : RefreshModel(model);
args = null;
return(err);
}
private void ControlOnEditSelectedRow(object sender, EditRowEventArgs editRowEventArgs)
{
OnEditSelectedRow(editRowEventArgs);
}
