public Widget GetWidget(Guid id) { using (var db = new AppDbContext()) { return db.Widgets.First(u => u.Id == (Guid)id); } }
public IList<Widget> GetWidgets() { using (var db = new AppDbContext()) { return db.Widgets.AsNoTracking().OrderBy(u => u.Name).ToList(); } }
public IList<Widget> GetWidgets(string searchString) { using (var db = new AppDbContext()) { return db.Widgets.AsNoTracking().Where(u => u.Name.ToLower().Contains(searchString.ToLower())).OrderBy(u => u.Name).ToList(); } }
public IList<User> GetUsers(string searchString) { using (var db = new AppDbContext()) { return db.Users.AsNoTracking().Where(u => u.Nickname.ToLower().Contains(searchString.ToLower())).OrderBy(u => u.Nickname).ToList(); } }
public User GetUser(Guid id) { using (var db = new AppDbContext()) { return db.Users.FirstOrDefault(u => u.Id == id); } }
public IList<User> GetUsers() { using (var db = new AppDbContext()) { return db.Users.AsNoTracking().OrderBy(u=>u.Nickname).ToList(); } }
public async Task SaveWidget(Widget widget) { using (var db = new AppDbContext()) { db.Widgets.Add(widget); await db.SaveChangesAsync(); } }
public async Task SaveUser(User user) { using (var db = new AppDbContext()) { db.Users.Add(user); await db.SaveChangesAsync(); } }
public async Task DeleteWidget(Guid id) { using (var db = new AppDbContext()) { var widget = GetWidget(id); db.Widgets.Attach(widget); db.Widgets.Remove(widget); await db.SaveChangesAsync(); } }
public async Task DeleteUser(Guid id) { using (var db = new AppDbContext()) { var user = GetUser(id); db.Users.Attach(user); db.Users.Remove(user); await db.SaveChangesAsync(); } }