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