private async Task <List <Establishment> > GetEstablismetnsAsync() { using (var db = new NerContext()) { return(await db.Establishments.ToListAsync()); } }
public async Task <List <Business> > GetBusinessesAsync() { using (var db = new NerContext()) { return(await db.Businesses.ToListAsync()); } }
private async Task CreateNewUser(User user) { using (var db = new NerContext()) { await db.AddAsync(user); db.SaveChanges(); } }
private async Task CreateNewCommandExecute() { using (var db = new NerContext()) { db.Add(NewEstab); await db.SaveChangesAsync(); } await LoadListCommandExecute(); }
private async Task LoadUsers() { using (var db = new NerContext()) { var _users = await db.Users.ToListAsync(); Users.Clear(); foreach (User user in _users) { Users.Add(user); } } LoadedUsers = Users.Count; }
private async Task CreateNewBusinessExecute() { Debug.WriteLine(NewBusiness.ToString()); await Task.Run(() => { using (var db = new NerContext()) { db.Businesses.Add(NewBusiness); db.SaveChanges(); } }); NewBusiness = new Business(); }
private async Task EditProfileExecute() { NewUser.Nationality = selectedNat.Name; await Task.Run(() => { using (var db = new NerContext()) { db.Users.Update(NewUser); db.SaveChanges(); } }); (Application.Current as App).SaveUserInProperties(NewUser); Debug.WriteLine(NewUser.ToString()); }
public AddNewBusinessViewModel() { AddNewBusinessCommand = new Command(() => { using (var db = new NerContext()) { db.Add(NewBusiness); db.SaveChanges(); } }); RefreshBusinessListCommand = new Command(async() => { await LoadBusinesses(); }); LoadBusinessListCommand = new Command(async() => { await LoadBusinesses(); }); }
protected override async void OnStart() { // Pre-load businesses await semaphore.WaitAsync(); // Make ViewModels wait for cached Businesses to load if (!Properties.ContainsKey("logged")) { MainPage = new NavigationPage(new LoginPage()); } else { MainAppPage = new MainPage(); MainPage = new NavigationPage(MainAppPage); } await Task.Run(async() => { Debug.WriteLine("Started loading to cache"); using (var db = new NerContext()) { CachedBusinesses = await db.Businesses .Include(b => b.BusinessTags) .ThenInclude(bt => bt.Tag) .Include(b => b.Category) .Include(b => b.Reviews) .ThenInclude(r => r.User) .Include(b => b.Links) .Include(b => b.Category) .OrderBy(b => b.Name) .ToListAsync();// TODO make this safer Debug.WriteLine("Loaded to cache"); CachedCategories = await db.Categories.ToListAsync(); } }); semaphore.Release(); }