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); } }