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); } }