public static bool UpdateMindMap(MindMapClass mindmap)
{
using (var _context = new DBTopicContext())
{
_context.dbMM.AddOrUpdate(mindmap);
_context.SaveChanges();
return(true);
}
}
public static bool AddTopic(TopicClass topic)
{
using (var _context = new DBTopicContext())
{
_context.dbTopic.Add(topic);
_context.SaveChanges();
return(true);
}
}
public static void RemoveMindMap(int taskID)
{
using (var _context = new DBTopicContext())
{
var task = (from t in _context.dbMM
where t.ID == taskID
select t).FirstOrDefault();
foreach (TopicClass topic in task.listTopics)
{
TopicControllers.RemoveTask(topic.ID);
}
_context.dbMM.Remove(task);
_context.SaveChanges();
}
}
public static bool DeleteTopicConnection(TopicClass first, TopicClass second)
{
using (var _context = new DBTopicContext())
{
var a = (from u in _context.dbTopic
where u.ID == first.ID
select u).Single();
var b = (from u in _context.dbTopic
where u.ID == second.ID
select u).Single();
a.listTopics.Remove(b);
_context.dbTopic.AddOrUpdate(a);
_context.SaveChanges();
return(true);
}
}
public static void RemoveTask(int taskID)
{
using (var _context = new DBTopicContext())
{
var task = (from t in _context.dbTopic
where t.ID == taskID
select t).FirstOrDefault();
foreach (TopicClass topic in task.listTopics)
{
topic.listTopics.Remove(task);
}
task.listTopics.Clear();
_context.dbTopic.Remove(task);
_context.SaveChanges();
}
}
public static bool UpdateTopic(TopicClass topic)
{
using (var _context = new DBTopicContext())
{
var a = (from u in _context.dbTopic.Include("mindMap")
where u.ID == topic.ID
select u).Single();
foreach (var t in topic.listTopics)
{
var to = (from u in _context.dbTopic.Include("listTopics")
where u.ID == t.ID
select u).Single();
if (!to.listTopics.Contains(a))
{
to.listTopics.Add(a);
}
else
{
continue;
}
}
a.Text = topic.Text;
a.Width = topic.Width;
a.Height = topic.Height;
a.X = topic.X;
a.Y = topic.Y;
if (a.mindMap == null)
{
a.mindMap = (from u in _context.dbMM
where u.ID == topic.mindMap.ID
select u).Single();
}
_context.SaveChanges();
return(true);
}
}
