public Criteria(Criteria toCopy)
{
Id = toCopy.Id;
Unit = toCopy.Unit;
TargetValue = toCopy.TargetValue;
CurrentValue = toCopy.CurrentValue;
}
public static void DeleteCriteria(Criteria criteria)
{
var set = DAL.SqlRepository.Criterias;
var cr = set.Find(criteria.Id);
if (cr != null)
{
set.Remove(cr);
DAL.SqlRepository.Save();
}
}
/// <summary>
/// Method to add new task to the database
/// </summary>
/// <param name="task">Create using a simple constructor</param>
public static Task CreateTask(DateTime beginDate, DateTime endDate, string urgencyName, string importanceName,
Importance importance, Urgency urgency, int criteriaId, Criteria criteria, string description, Task parent, int parentId)
{
var set = DAL.SqlRepository.Tasks;
var task = (Task)set.Create(typeof(Task));
task.BeginDate = beginDate;
task.EndDate = endDate;
task.Urgency = urgency;
task.UrgencyName = urgencyName;
task.Importance = importance;
task.ImportanceName = importanceName;
task.Criteria = criteria;
task.CriteriaId = criteriaId;
task.Description = description;
task.Parent = parent;
task.ParentId = parentId;
DAL.SqlRepository.Tasks.Add(task);
DAL.SqlRepository.Save();
return task;
}
private void ChangeCurrentValueOfStep(object sender, RoutedEventArgs e)
{
int id = Convert.ToInt32((sender as Button).Name.Substring(1));
var step = BL.ChangesBuffer.CurrentState.StepBuffer.First(s => s.Id == id);
var crit = BL.ChangesBuffer.CurrentState.CriteriaBuffer.First(c => step.CriteriaId == c.Id);
var newStep = new Step(step);
var newCrit = new Criteria(crit);
newCrit.CurrentValue = Convert.ToInt32((_stepChanger.Children[1] as TextBox).Text);
var buff = new BL.Buffer(BL.ChangesBuffer.CurrentState);
buff.CriteriaBuffer.Remove(crit);
buff.CriteriaBuffer.Add(newCrit);
newStep.Criteria = newCrit;
buff.StepBuffer.Remove(step);
buff.StepBuffer.Add(newStep);
BL.ChangesBuffer.CaptureChanges(buff);
UpdateTree(BL.ChangesBuffer.CurrentState.TaskBuffer.First(t=>t.Description==_parent.Desc.Text),MoveDirections.None);
}
private void ApplyStep(object sender, RoutedEventArgs e)
{
var buff = new BL.Buffer(BL.ChangesBuffer.CurrentState);
int id = Convert.ToInt32(DescBox.Name.Substring(1));
var step = BL.ChangesBuffer.CurrentState.StepBuffer.First(s => s.Id == id);
var newStep = new Step(step);
var crit =
BL.ChangesBuffer.CurrentState.CriteriaBuffer.First(
c => c.Id == Convert.ToInt32(UnitBox.Name.Substring(1)));
var newCrit = new Criteria(crit);
buff.CriteriaBuffer.Remove(crit);
buff.CriteriaBuffer.Add(newCrit);
buff.StepBuffer.Remove(step);
newStep.Criteria = newCrit;
newStep.Description = DescBox.Text;
var tr = BL.ChangesBuffer.CurrentState.TimeRuleBuffer.First(t => t.Id == step.TimeRuleId);
var newtr = new TimeRule(tr);
if (Periodic.IsChecked.HasValue && Periodic.IsChecked.Value)
{
newtr.IsPeriodic = true;
newtr.Schedule =
DAL.SqlRepository.Schedules.Cast<Models.Schedule>().ToList()
.First(sc => sc.Id == Convert.ToInt32((Graphs.SelectedItem as ComboBoxItem).Content.ToString()));
newtr.ScheduleId = newtr.Schedule.Id;
}
else
{
newtr.IsPeriodic = false;
}
buff.TimeRuleBuffer.Remove(tr);
buff.TimeRuleBuffer.Add(newtr);
newStep.TimeRule = newtr;
buff.StepBuffer.Add(newStep);
BL.ChangesBuffer.CaptureChanges(buff);
UpdateTree(BL.ChangesBuffer.CurrentState.TaskBuffer.First(task=>task.Description==_parent.Desc.Text),MoveDirections.None);
OkButton.Click -= ApplyStep;
Discard_Click(sender, e);
}
private void Add_Click(object sender, RoutedEventArgs e)
{
if (
BL.ChangesBuffer.CurrentState.TaskBuffer.Any(
entity =>
Task.GetOldestParent(entity).Id == BL.Application.CurrentTree.MainTaskId &&
entity.Description == DescBox.Text))
{
MessageBox.Show("Такая цель уже есть в этом дереве!", "Warning", MessageBoxButton.OK,
MessageBoxImage.Warning);
return;
}
if (DescBox.Text.Length < 3)
{
MessageBox.Show("Слишком короткое описание!", "Warning", MessageBoxButton.OK,
MessageBoxImage.Warning);
return;
}
var imp =
DAL.SqlRepository.Importancies.Cast<Importance>()
.First(x => ((ComboBoxItem)Imp.SelectedItem).Content.ToString() == x.ImportanceName);
var buff = new BL.Buffer(BL.ChangesBuffer.CurrentState);
if (StepButton.IsChecked == true)
{
var tr = new TimeRule
{
IsPeriodic = Periodic.IsChecked == true,
Schedule =
DAL.SqlRepository.Schedules.Cast<Models.Schedule>().ToList()
.First(x => Periodic.IsChecked != true || x.Id == Convert.ToInt32(((ComboBoxItem)Graphs.SelectedItem).Content.ToString())),
};
tr.ScheduleId = tr.Schedule.Id;
var t = BL.ChangesBuffer.CurrentState.TaskBuffer.First(x => x.Description == _parent.Desc.Text);
if (
BL.ChangesBuffer.CurrentState.StepBuffer
.Any(x => x.TaskId == t.Id && x.Description == DescBox.Text))
{
MessageBox.Show("Такой шаг у цели уже есть!", "Warning", MessageBoxButton.OK,
MessageBoxImage.Warning);
}
var crit = new Criteria
{
CurrentValue = 0,
TargetValue = Convert.ToInt32(TargetVal.Text),
Unit = UnitBox.Text
};
var st = new Step
{
BeginDate = Begin.SelectedDate != null ? (DateTime) Begin.SelectedDate : DateTime.Now,
EndDate = End.SelectedDate != null ? (DateTime) End.SelectedDate : Interval.PIOS,
Criteria = crit,
CriteriaId = crit.Id,
Description = DescBox.Text,
Importance = imp,
ImportanceName = imp.ImportanceName,
TimeRule = tr,
TimeRuleId = tr.Id,
ParentTask = t,
TaskId = t.Id
};
st.UpdateUrgency();
buff.StepBuffer.Add(st);
BL.ChangesBuffer.CaptureChanges(buff);
UpdateTree(t,MoveDirections.None);
}
else
{
var crit = new Criteria
{
CurrentValue = 0,
TargetValue = 1,
Unit = "default"
};
var p = BL.ChangesBuffer.CurrentState.TaskBuffer.First(x => x.Description == _parent.Desc.Text);
var t = new Task
{
BeginDate = Begin.SelectedDate != null ? (DateTime)Begin.SelectedDate : DateTime.Now,
EndDate = End.SelectedDate != null ? (DateTime)End.SelectedDate : Interval.PIOS,
Criteria = crit,
CriteriaId = crit.Id,
Description = DescBox.Text,
Importance = imp,
ImportanceName = imp.ImportanceName,
Parent = p,
ParentId = p.Id,
Id = BL.ChangesBuffer.CurrentState.TaskBuffer.Max(taskk=>taskk.Id) + 1
};
t.UpdateUrgency();
buff.TaskBuffer.Add(t);
BL.ChangesBuffer.CaptureChanges(buff);
UpdateTree(p,MoveDirections.None);
}
UpdateRawView();
Discard_Click(sender,e);
}
/// <summary>
/// Method to add new step to the database
/// </summary>
/// <param name="step">Create using a simple constructor</param>
public static Step CreateStep(DateTime beginDate, DateTime endDate, string urgencyName, Urgency urgency,
string importanceName, Importance importance, int criteriaId, Criteria criteria,
int timeRuleId, TimeRule timeRule, string description, Task parentTask, int taskId, int order)
{
var set = DAL.SqlRepository.Steps;
var step = (Step)set.Create(typeof(Step));
step.BeginDate = beginDate;
step.EndDate = endDate;
step.UrgencyName = urgencyName;
step.Urgency = urgency;
step.ImportanceName = importanceName;
step.Importance = importance;
step.CriteriaId = criteriaId;
step.Criteria = criteria;
step.TimeRuleId = timeRuleId;
step.TimeRule = timeRule;
step.Description = description;
step.ParentTask = parentTask;
step.TaskId = taskId;
step.Order = order;
set.Add(step);
DAL.SqlRepository.Save();
return step;
}
//private static User[] users;
//private static Urgency[] urgencies;
//private static Importance[] importancies;
//private static Interval[] intervals;
//private static Criteria[] criterias;
//private static Models.Schedule[] schedules;
//private static TimeRule[] timeRules;
//private static TimeBinding[] timeBindings;
//private static Models.Task[] tasks;
//private static Step[] steps;
//private static Tree[] trees;
//PLEASE DO NOT CALL THIS METHOD IT IS TOTALLY BAD.
public static void Seed()
{
var user = User.CreateUser("xxxrassiyavperedxxx", "A.Pistoletov", new DateTime(1985, 3, 22), "secret_pass", DateTime.Now);
//var user = (User)DAL.SqlRepository.Users.Find("xxxrassiyavperedxxx");
var tree = Tree.CreateTree(user, user.Login, "new era of trees", "must work please");
// var tree = Tree.FindTreesForUser(user).First();
var importancies = Importance.GetViableImportanceLevels();
var urgencies = Urgency.GetViableUrgencyLevels();
var criterias = new Criteria[] {
Criteria.CreateCriteria(0, 10, "wtuk"),
Criteria.CreateCriteria(0, 1, "raz"),
Criteria.CreateCriteria(0, 666, "fragov v cs")
};
//var criterias = DAL.SqlRepository.Criterias.Cast<Criteria>().ToList();
var tasks = new Task[4];
tasks[0] = Task.CreateTask(DateTime.Now, DateTime.Now.AddDays(5), urgencies[0].UrgencyName, importancies[0].ImportanceName, importancies[0], urgencies[0], criterias[0].Id, criterias[0], "task 1", tree.MainTask, tree.MainTask.Id);
tasks[1] = Task.CreateTask(DateTime.Now, DateTime.Now.AddDays(5), urgencies[1].UrgencyName, importancies[2].ImportanceName, importancies[2], urgencies[1], criterias[1].Id, criterias[1], "task 2", tree.MainTask, tree.MainTask.Id);
tasks[2] = Task.CreateTask(DateTime.Now, DateTime.Now.AddDays(5), urgencies[2].UrgencyName, importancies[1].ImportanceName, importancies[1], urgencies[2], criterias[2].Id, criterias[2], "task 3", tasks[0], tasks[0].Id);
tasks[3] = Task.CreateTask(DateTime.Now, DateTime.Now.AddDays(5), urgencies[0].UrgencyName, importancies[0].ImportanceName, importancies[0], urgencies[0], criterias[0].Id, criterias[0], "task 4", tasks[1], tasks[1].Id);
var intervals = new Interval[] {
Interval.CreateInterval(DateTime.Now, DateTime.Now.AddHours(3)),
Interval.CreateInterval(DateTime.Now, DateTime.Now.AddHours(5)),
Interval.CreateInterval(DateTime.Now, DateTime.Now.AddHours(7)),
Interval.CreateInterval(DateTime.Now, DateTime.Now.AddHours(13)),
Interval.CreateInterval(DateTime.Now, DateTime.Now.AddHours(22)),
Interval.CreateInterval(DateTime.Now, DateTime.Now.AddHours(50))
};
var schedules = new Models.Schedule[] {
Models.Schedule.CreateSchedule(intervals[0],intervals[1],intervals[2],intervals[3],intervals[4],intervals[5],intervals[0], "first"),
Models.Schedule.CreateSchedule(intervals[1],intervals[2],intervals[3],intervals[4],intervals[5],intervals[0],intervals[1], "second"),
Models.Schedule.CreateSchedule(intervals[2],intervals[3],intervals[4],intervals[5],intervals[0],intervals[1],intervals[0], "third")
};
var timeRules = new TimeRule[] {
TimeRule.CreateTimeRule(false, schedules[0].Id, schedules[0]),
TimeRule.CreateTimeRule(true, schedules[1].Id, schedules[1]),
TimeRule.CreateTimeRule(false, schedules[2].Id, schedules[2]),
TimeRule.CreateTimeRule(true, schedules[0].Id, schedules[0]),
};
var steps = new Step[] {
Step.CreateStep(DateTime.Now, DateTime.Now.AddDays(30), urgencies[0].UrgencyName, urgencies[0], importancies[0].ImportanceName, importancies[0], criterias[2].Id, criterias[2], timeRules[1].Id, timeRules[0], "step 1", tasks[2], tasks[2].Id, 0),
Step.CreateStep(DateTime.Now, DateTime.Now.AddDays(30), urgencies[1].UrgencyName, urgencies[1], importancies[1].ImportanceName, importancies[1], criterias[1].Id, criterias[1], timeRules[2].Id, timeRules[0], "step 1", tasks[2], tasks[2].Id, 1),
Step.CreateStep(DateTime.Now, DateTime.Now.AddDays(30), urgencies[2].UrgencyName, urgencies[2], importancies[2].ImportanceName, importancies[2], criterias[0].Id, criterias[0], timeRules[3].Id, timeRules[0], "step 1", tasks[2], tasks[2].Id, 2),
Step.CreateStep(DateTime.Now, DateTime.Now.AddDays(30), urgencies[1].UrgencyName, urgencies[1], importancies[0].ImportanceName, importancies[0], criterias[1].Id, criterias[1], timeRules[0].Id, timeRules[0], "step 1", tasks[2], tasks[2].Id, 3),
Step.CreateStep(DateTime.Now, DateTime.Now.AddDays(30), urgencies[2].UrgencyName, urgencies[2], importancies[2].ImportanceName, importancies[2], criterias[2].Id, criterias[2], timeRules[1].Id, timeRules[0], "step 1", tasks[2], tasks[2].Id, 4),
Step.CreateStep(DateTime.Now, DateTime.Now.AddDays(30), urgencies[1].UrgencyName, urgencies[1], importancies[1].ImportanceName, importancies[1], criterias[0].Id, criterias[0], timeRules[2].Id, timeRules[0], "step 1", tasks[2], tasks[2].Id, 5),
Step.CreateStep(DateTime.Now, DateTime.Now.AddDays(30), urgencies[2].UrgencyName, urgencies[2], importancies[0].ImportanceName, importancies[0], criterias[0].Id, criterias[0], timeRules[3].Id, timeRules[0], "step 1", tasks[2], tasks[2].Id, 6),
Step.CreateStep(DateTime.Now, DateTime.Now.AddDays(30), urgencies[0].UrgencyName, urgencies[0], importancies[1].ImportanceName, importancies[1], criterias[0].Id, criterias[0], timeRules[0].Id, timeRules[0], "step 1", tasks[2], tasks[2].Id, 7),
Step.CreateStep(DateTime.Now, DateTime.Now.AddDays(30), urgencies[1].UrgencyName, urgencies[1], importancies[2].ImportanceName, importancies[2], criterias[2].Id, criterias[2], timeRules[1].Id, timeRules[0], "step 1", tasks[3], tasks[3].Id, 0),
Step.CreateStep(DateTime.Now, DateTime.Now.AddDays(30), urgencies[0].UrgencyName, urgencies[0], importancies[0].ImportanceName, importancies[0], criterias[0].Id, criterias[0], timeRules[2].Id, timeRules[0], "step 1", tasks[3], tasks[3].Id, 1),
Step.CreateStep(DateTime.Now, DateTime.Now.AddDays(30), urgencies[2].UrgencyName, urgencies[2], importancies[2].ImportanceName, importancies[2], criterias[1].Id, criterias[1], timeRules[3].Id, timeRules[0], "step 1", tasks[3], tasks[3].Id, 2),
Step.CreateStep(DateTime.Now, DateTime.Now.AddDays(30), urgencies[0].UrgencyName, urgencies[0], importancies[1].ImportanceName, importancies[1], criterias[0].Id, criterias[0], timeRules[0].Id, timeRules[0], "step 1", tasks[3], tasks[3].Id, 3),
Step.CreateStep(DateTime.Now, DateTime.Now.AddDays(30), urgencies[2].UrgencyName, urgencies[2], importancies[0].ImportanceName, importancies[0], criterias[0].Id, criterias[0], timeRules[1].Id, timeRules[0], "step 1", tasks[3], tasks[3].Id, 4),
Step.CreateStep(DateTime.Now, DateTime.Now.AddDays(30), urgencies[1].UrgencyName, urgencies[1], importancies[1].ImportanceName, importancies[1], criterias[2].Id, criterias[2], timeRules[2].Id, timeRules[0], "step 1", tasks[3], tasks[3].Id, 5),
Step.CreateStep(DateTime.Now, DateTime.Now.AddDays(30), urgencies[0].UrgencyName, urgencies[0], importancies[2].ImportanceName, importancies[2], criterias[0].Id, criterias[0], timeRules[3].Id, timeRules[0], "step 1", tasks[3], tasks[3].Id, 6),
Step.CreateStep(DateTime.Now, DateTime.Now.AddDays(30), urgencies[1].UrgencyName, urgencies[1], importancies[0].ImportanceName, importancies[0], criterias[0].Id, criterias[0], timeRules[0].Id, timeRules[0], "step 1", tasks[3], tasks[3].Id, 7)
};
}
protected bool Equals(Criteria other)
{
return Id == other.Id && CurrentValue == other.CurrentValue && TargetValue == other.TargetValue && string.Equals(Unit, other.Unit);
}
