public void Save(object sender, RoutedEventArgs e)
{
try
{
var columns = AddListBoxFields.Select(a => a.Text).Concat(AddListBoxCombo.Select(a => a.TableFieldName));
var values = AddListBoxFields.Select(a => a.Input).Concat(AddListBoxCombo.Select(a => a.GetId()));
if (AddListBoxFields.Any(a => a.Input == null) || AddListBoxCombo.Any(a => a.Selected == null))
{
Notification("Все поля должны быть заполнены");
return;
}
else if (InsertOrUpdate)
{
context.Update(SelectedTableName, Convert.ToInt32(values.First()), columns.Skip(1), values.Skip(1));
}
else
{
context.Insert(SelectedTableName, columns, values);
}
RefreshSelectedTable();
}
catch (Exception ex)
{
Notification(ex.Message);
}
}
public void ExecuteStoredProcedure(object sender, EventArgs e)
{
try
{
var fields = AddListBoxFields.Select(a => a.Text).Concat(AddListBoxCombo.Select(a => a.TableFieldName));
var values = AddListBoxFields.Select(a => a.Input).Concat(AddListBoxCombo.Select(a => a.GetId()));
if (AddListBoxFields.Any(a => a.Input == null) || AddListBoxCombo.Any(a => a.Selected == null))
{
Notification("Все поля должны быть заполнены");
return;
}
else
{
var data = context.ExecuteStoredProcedure(SelectedStoredProcedures, fields, values);
RefreshSelectedTable(data);
SelectedTableName = SelectedStoredProcedures;
UpdateStoredProcedures();
}
UpdateTables();
}
catch (Exception ex)
{
Notification(ex.Message);
}
}
public void Update(object sender, RoutedEventArgs e)
{
try
{
var columns = (TableView.ItemsSource as DataView).Table.Columns.Cast <DataColumn>().Select(a => a.ToString()).ToList();
var columnsData = (TableView.SelectedItem as DataRowView).Row.ItemArray.Select(a => a.ToString()).ToList();
RowDataEntryField(columns);
AddListBoxCombo.ForEach(a => a.Selected = columnsData[columns.IndexOf(a.TableFieldName)]);
AddListBoxFields.ForEach(a => a.Input = columnsData[columns.IndexOf(a.Text)]);
InsertOrUpdate = true;
}
catch (Exception ex)
{
Notification(ex.Message);
}
}
