public static List <TOPIC> getListTopic(int idboard)
{
using (var _context = new MINDMAPEntities())
{
var topics = (from t in _context.TOPICs.AsEnumerable()
where t.ID_BOARD == idboard
select t)
.Select(x => new TOPIC
{
ID = x.ID,
ID_BOARD = x.ID_BOARD,
BOARD = x.BOARD,
ID_PARENT = x.ID_PARENT,
POS_X = x.POS_X,
POS_Y = x.POS_Y,
WIDTH = x.WIDTH,
HEIGHT = x.HEIGHT,
LABEL_TP = x.LABEL_TP,
BACKCOLOR = x.BACKCOLOR,
FORECOLOR = x.FORECOLOR,
COLOR_PATH = x.COLOR_PATH,
SIZE_PATH = x.SIZE_PATH,
STYLE_PATH = x.STYLE_PATH,
SHAPE = x.SHAPE,
SIZE = x.SIZE,
TEXT_SIZE = x.TEXT_SIZE,
FONT = x.FONT
}).ToList();
return(topics);
}
}
public static string getNameStorage(int idboard)
{
using (var _context = new MINDMAPEntities())
{
var s = _context.STORAGEs.Where(x => x.ID_BOARD == idboard).First();
return(s.NAME_S);
}
}
public static List <STORAGE> getListStorage()
{
using (var _context = new MINDMAPEntities())
{
var storage = (from s in _context.STORAGEs.AsEnumerable()
select s)
.Select(x => new STORAGE
{
NAME_S = x.NAME_S,
ID_BOARD = x.ID_BOARD,
DATE_MODIFIED = x.DATE_MODIFIED
}).ToList();
return(storage);
}
}
public static int getID()
{
using (var _context = new MINDMAPEntities())
{
var id = (from t in _context.TOPICs
select t.ID).ToList();
if (id.Count <= 0)
{
return(1);
}
else
{
return(id.Max() + 1);
}
}
}
public static bool updateStorage(STORAGE storage)
{
try
{
using (var _context = new MINDMAPEntities())
{
_context.STORAGEs.AddOrUpdate(storage);
_context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public static int getIDBoard(string name)
{
using (var _context = new MINDMAPEntities())
{
var storage = (from s in _context.STORAGEs.AsEnumerable()
where s.NAME_S == name
select s)
.Select(x => new STORAGE
{
NAME_S = x.NAME_S,
ID_BOARD = x.ID_BOARD,
DATE_MODIFIED = x.DATE_MODIFIED
}).ToList();
return(storage[0].ID_BOARD);
}
}
public static bool updateBoard(BOARD board)
{
try
{
using (var _context = new MINDMAPEntities())
{
_context.BOARDs.AddOrUpdate(board);
_context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public static bool checkName(string txt)
{
using (var _context = new MINDMAPEntities())
{
var name = (from s in _context.STORAGEs
where s.NAME_S == txt
select s).ToList();
if (name.Count >= 1)
{
return(false);
}
else
{
return(true);
}
}
}
public static BOARD getBOARD(int idboard)
{
using (var _context = new MINDMAPEntities())
{
var board = (from b in _context.BOARDs.AsEnumerable()
where b.ID == idboard
select b).
Select(x => new BOARD
{
ID = x.ID,
COLOR = x.COLOR,
WIDTH = x.WIDTH,
HEIGHT = x.HEIGHT
}).ToList();
return(board[0]);
}
}
public static bool deleteBoardAndStorage(int id)
{
try
{
using (var _context = new MINDMAPEntities())
{
var board = _context.BOARDs.Where(x => x.ID == id).First();
board.STORAGEs.Clear();
_context.BOARDs.Remove(board);
_context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public static bool addListTopic(List <TOPIC> listTopic)
{
try
{
using (var _context = new MINDMAPEntities())
{
foreach (TOPIC topic in listTopic)
{
_context.TOPICs.Add(topic);
}
_context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public static List <MENU> getListMenu()
{
using (var _context = new MINDMAPEntities())
{
var menus = (from m in _context.MENUs.AsEnumerable()
select m)
.Select(x => new MENU
{
ID = x.ID,
SHAPE_CHILD = x.SHAPE_CHILD,
SHAPE_PARENT = x.SHAPE_PARENT,
COLOR_BOARD = x.COLOR_BOARD,
COLOR_CHILD = x.COLOR_CHILD,
COLOR_PARENT = x.COLOR_PARENT,
COLOR_PATH = x.COLOR_PATH,
STYLE_PATH = x.STYLE_PATH
}).ToList();
return(menus);
}
}
public static bool deleteNode(int idboard)
{
try
{
using (var _context = new MINDMAPEntities())
{
var nodes = _context.TOPICs.Where(x => x.ID_BOARD == idboard).ToList();
foreach (TOPIC node in nodes.AsEnumerable())
{
_context.TOPICs.Remove(node);
}
_context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public static bool removeNode(List <TOPIC> listTopic)
{
try
{
using (var _context = new MINDMAPEntities())
{
foreach (TOPIC topic in listTopic)
{
var t = _context.TOPICs.Where(x => x.ID == topic.ID).First();
_context.TOPICs.Remove(t);
}
_context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public static bool addListTopic(List <TOPIC> listTopic, int idboard)
{
try
{
using (var _context = new MINDMAPEntities())
{
var board = _context.BOARDs.Where(x => x.ID == idboard).First();
foreach (TOPIC topic in listTopic.AsEnumerable())
{
topic.BOARD = board;
_context.TOPICs.Add(topic);
_context.Entry(board).State = EntityState.Unchanged;
}
_context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
