private void editButton_Click(object sender, RoutedEventArgs e) { if (proceduresGrid.SelectedItems.Count > 0) { var procedure = proceduresGrid.SelectedItems[0] as BaseProcedures; if (procedure == null) { return; } var dialog = new BaseProcedureEditWindow(procedure); if (dialog.ShowDialog() == true) { try { using (db = new SimSaprNewEntities()) { db.BaseProcedures_Update(procedure.BaseProcedureId, procedure.Name, procedure.DefaultFunctionExpression); proceduresGrid.ItemsSource = null; proceduresGrid.ItemsSource = db.BaseProcedures.ToList(); } } catch (Exception) { MessageBox.Show("Проверьте введённые значения"); } } } }
public BaseProceduresWindow() { InitializeComponent(); db = new SimSaprNewEntities(); db.BaseProcedures.Load(); proceduresGrid.ItemsSource = db.BaseProcedures.ToList(); this.Closing += MainWindow_Closing; }
public ResourceTypesWindow() { InitializeComponent(); db = new SimSaprNewEntities(); db.ResourceTypes.Load(); resTypesGrid.ItemsSource = db.ResourceTypes.ToList(); this.Closing += MainWindow_Closing; }
public BaseProcedureParametersNamesWindow(BaseProcedures baseProcedure) { InitializeComponent(); BaseProcedure = baseProcedure; db = new SimSaprNewEntities(); db.BaseProcedureParameterNames.Load(); parametersGrid.ItemsSource = db.BaseProcedureParameterNames.Where(p => p.BaseProcedureId == BaseProcedure.BaseProcedureId).ToList(); this.Closing += MainWindow_Closing; }
public ResourcesWindow() { InitializeComponent(); db = new SimSaprNewEntities(); db.ResourceNames.Load(); db.Resources.Load(); ResourceNames = db.ResourceNames.ToList(); ResourceParameterNames = db.ResourceParameterNames.ToList(); resourcesGrid.ItemsSource = db.Resources.Include(r => r.ResourceNames).ToList(); this.Closing += MainWindow_Closing; }
private void addButton_Click(object sender, RoutedEventArgs e) { var procedure = new BaseProcedures(); var dialog = new BaseProcedureEditWindow(procedure); if (dialog.ShowDialog() == true) { try { using (db = new SimSaprNewEntities()) { db.BaseProcedures_Create(procedure.Name, procedure.DefaultFunctionExpression); proceduresGrid.ItemsSource = null; proceduresGrid.ItemsSource = db.BaseProcedures.ToList(); } } catch (Exception) { MessageBox.Show("Проверьте введённые значения"); } } }
public ResourceParametersWindow(Resources resource) { InitializeComponent(); Resource = resource; db = new SimSaprNewEntities(); db.ResourceParameters.Load(); var resourceParameters = db.ResourceParameters.Include(rp => rp.Resources).Include(rp => rp.ResourceParameterNames).Where(rp => rp.ResourceId == Resource.ResourceId).ToList(); var resourceParameterNames = db.ResourceParameterNames.Include(rp => rp.ResourceNames).Where(rp => rp.ResourceNameId == Resource.ResourceNameId).ToList(); if (resourceParameters.Count == 0) { foreach (var parName in resourceParameterNames) { db.ResourceParameters_Create(parName.ResourceParameterNameId, Resource.ResourceId, null); } resourceParameters = db.ResourceParameters.Where(rp => rp.ResourceId == Resource.ResourceId).Include(rp => rp.Resources).Include(rp => rp.ResourceParameterNames).ToList(); } parametersGrid.ItemsSource = resourceParameters; this.Closing += MainWindow_Closing; }