public static List <TopicClass> GetAllTopic()
{
using (var _context = new DBTopicContext())
{
var topics = (from t in _context.dbTopic.AsEnumerable()
select new
{
id = t.ID,
color = t.Color,
x = t.X,
y = t.Y,
width = t.Width,
height = t.Height,
text = t.Text,
lt = t.listTopics
})
.Select(x => new TopicClass
{
ID = x.id,
Color = x.color,
X = x.x,
Y = x.y,
Width = x.width,
Height = x.height,
Text = x.text,
listTopics = x.lt
});
return(topics.ToList());
}
}
public void load(string ID)
{
this.Controls.Clear();
{
using (var _context = new DBTopicContext())
{
if (ID == null)
{
return;
}
int idd = Int32.Parse(ID);
this.mindmap = MindMapControllers.LoadMindMap(idd);
foreach (var t in mindmap.listTopics)
{
var first = TopicControllers.GetTopic(t.ID);
foreach (var second in first.listTopics)
{
this.fish(first, second);
}
}
foreach (var t in mindmap.listTopics)
{
Shape s = new Shape(t);
this.Controls.Add(s);
s.BringToFront();
}
}
}
}
public static TopicClass GetTopic(int ID)
{
using (var _context = new DBTopicContext())
{
var topic = _context.dbTopic.Include("listTopics").Where(t => t.ID == ID).FirstOrDefault();
return(topic);
}
}
public static MindMapClass LoadMindMap(int ID)
{
using (var _context = new DBTopicContext())
{
var mm = _context.dbMM.Include("listTopics").Where(x => x.ID == ID).FirstOrDefault();
return(mm);
}
}
public static List <MindMapClass> LoadAllMindMap()
{
using (var _context = new DBTopicContext())
{
var mm = (from t in _context.dbMM.Include("listTopics")
select t).ToList();
return(mm);
}
}
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 int GetIDfromDB()
{
try
{
using (var _context = new DBTopicContext())
{
var ids = (from t in _context.dbTopic
select t.ID).Max() + 1;
return(ids);
}
}
catch
{
return(1);
}
}
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);
}
}
