public BaseLayer()
{
DssDbContext = new DssDbEntities();
BaseMethods = new BaseMethods(DssDbContext);
Task = new Task();
SolvedTaskView = new SolvedTaskView();
CpMaxes = new List<CpMax>();
}
private void Delete_Click(object sender, RoutedEventArgs e)
{
if (gridTasks.SelectedItem != null)
{
using (DssDbEntities context = new DssDbEntities())
{
var tasks = context.Tasks.Select(t => t);
tasks.Where(t => t.Id == ((Task) gridTasks.SelectedItem).Id).Select(t => t).First().Deleted = 1;
context.SaveChanges();
RefreshTable();
}
}
}
public void LoadTasks(string taskUniq)
{
Tasks = new List<Task>();
try
{
using (var dssDbContext = new DssDbEntities())
{
var tasks = (from task in dssDbContext.Tasks
where task.TaskUniq == taskUniq && task.Deleted != 1
select task).ToList();
foreach (var t in tasks)
{
Tasks.Add(new Task { Comment = t.Comment, TaskUniq = t.TaskUniq, Id = t.Id, Recommendation = t.Recommendation,
Date = t.Date, Deleted = t.Deleted, TreeDiagramm = t.TreeDiagramm, SavingId = t.SavingId, TaskParams = t.TaskParams});
}
}
}
catch (Exception)
{
MessageBox.Show("Не удалось подключиться к базе данных.");
}
}
public Load(Task task)
{
BaseLayer = new BaseLayer();
dssDbContext = new DssDbEntities();
Task = task;
Combinations = (dssDbContext.Combinations.Where(c => c.TaskId == task.Id)).ToList();
if (Combinations.Count != 0)
{
Actions = (Combinations.Select(c => c.Action)).Distinct().ToList();
var nullableCombinations = Combinations.Where(combination => combination.Event == null).ToList();
foreach (var nullableCombination in nullableCombinations)
{
Combinations.Remove(nullableCombination);
}
Events = (Combinations.Select(c => c.Event)).Distinct().ToList();
}
else
{
Actions = (dssDbContext.Actions.Where(a => a.SavingId == task.SavingId)).ToList();
Events = (dssDbContext.Events.Where(ev => ev.SavingId == task.SavingId)).ToList();
}
}
public BaseMethods(DssDbEntities dssDbContext)
{
this.dssDbContext = dssDbContext;
}
