public static MenuItem GetDbRecord(int id) { using (var context = new BasicWebContext()) { return(context.MenuItems.Find(id)); } }
public static List <MenuItem> GetSubMenuItems(int id) { using (var context = new BasicWebContext()) { return(context.MenuItems.Where(x => x.ParentID == id).ToList()); } }
public static List <T> Query <T>(System.Linq.Expressions.Expression <Func <T, bool> > condition) where T : class { using (var context = new BasicWebContext()) { return(context.Set <T>().Where(condition).ToList()); } }
public static List <T> GetAll <T>() where T : class { using (var context = new BasicWebContext()) { return(context.Set <T>().AsNoTracking().ToList()); } }
public static T Get <T>(object id) where T : class { using (var context = new BasicWebContext()) { return(context.Set <T>().Find(id)); } }
public static void DeleteMenuItem(int id) { using (var context = new BasicWebContext()) { context.MenuItems.Remove(context.MenuItems.Find(id)); context.SaveChanges(); } }
public static void New <T>(T record) where T : class { using (var context = new BasicWebContext()) { context.Set <T>().Add(record); context.SaveChanges(); } }
public static void Update <T>(object id, Action <T> action) where T : class { using (var context = new BasicWebContext()) { var record = context.Set <T>().Find(id); action(record); context.SaveChanges(); } }
public static void Delete <T>(object id) where T : class { using (var context = new BasicWebContext()) { var record = context.Set <T>().Find(id); context.Set <T>().Remove(record); context.SaveChanges(); } }
public static Dictionary <int, string> GetAllOtherMenuItemNames(int currentID) { using (var context = new BasicWebContext()) { var dict = context.MenuItems.ToDictionary(x => x.ID, x => x.Name); dict[0] = "<root>"; dict.Remove(currentID); return(dict); } }
public static void NewAll <T>(IEnumerable <T> records) where T : class { using (var context = new BasicWebContext()) { foreach (var record in records) { context.Set <T>().Add(record); } context.SaveChanges(); } }
public static void UpdateAll <T>(System.Linq.Expressions.Expression <Func <T, bool> > selector, Action <T> action) where T : class { using (var context = new BasicWebContext()) { var records = context.Set <T>().Where(selector); foreach (var record in records) { action(record); } context.SaveChanges(); } }
public static void EditMenuItem(int id, string name, string description, string type, string action, string icon, int parentID, int order, string allowedRoles) { using (var context = new BasicWebContext()) { var record = context.MenuItems.Find(id); record.Name = name; record.Description = description; record.Type = type; record.Action = action; record.Icon = icon; record.ParentID = parentID; record.Order = order; record.AllowedRoles = allowedRoles; context.SaveChanges(); } }
public static void UpdateFromJson(WorkflowJsonObject flow) { using (var context = new TongJi.Web.Models.BasicWebContext()) { foreach (var node in flow.nodes) { var flowNode = context.FlowNodes.Find(node.id); flowNode.Name = node.name; flowNode.FlowChartPositionX = node.xpos; flowNode.FlowChartPositionY = node.ypos; flowNode.AllowedUsers = node.user; flowNode.AllowedRoles = node.role; } context.SaveChanges(); } }
public static void NewMenuItem(string name, string description, string type, string action, string icon, int parentID, int order, string allowedRoles) { using (var context = new BasicWebContext()) { MenuItem item = new MenuItem { Name = name, Description = description, Type = type, Action = action, Icon = icon, ParentID = parentID, Order = order, CreateTime = DateTime.Now, AllowedRoles = allowedRoles }; context.MenuItems.Add(item); context.SaveChanges(); } }