public static ICollection <string> RoomList(this AssetHubContext db) { var list = (from r in db.Rooms select r.Name).ToList(); return(list); }
public static ICollection <string> UserPositionList(this AssetHubContext db) { var list = (from p in db.UserPositions select p.Name).ToList(); return(list); }
public static IEnumerable <SelectListItem> AssetModelDropdown(this AssetHubContext db) { var assetModels = db.AssetModels.Select( m => new SelectListItem { Value = m.Id.ToString(), Text = m.Name, }); return(new SelectList(assetModels, "Value", "Text")); }
public static IEnumerable <SelectListItem> UserPositionDropdown(this AssetHubContext db) { var rooms = db.UserPositions.Select( m => new SelectListItem { Value = m.Id.ToString(), Text = m.Name, }); return(new SelectList(rooms, "Value", "Text")); }
public static UserPosition FindOrAddUserPosition(this AssetHubContext db, string name) { var position = (from p in db.UserPositions where p.Name.Equals(name, StringComparison.InvariantCultureIgnoreCase) select p).FirstOrDefault(); if (position == null) { position = new UserPosition { Name = name }; db.UserPositions.Add(position); db.SaveChanges(); } return(position); }
public static Room FindOrAddRoom(this AssetHubContext db, string name) { var room = (from r in db.Rooms where r.Name.Equals(name, StringComparison.InvariantCultureIgnoreCase) select r).FirstOrDefault(); if (room == null) { room = new Room { Name = name }; db.Rooms.Add(room); db.SaveChanges(); } return(room); }