public static ApplicationUser GetUserFromMail(string mail) { using (var db = new MyCoachDatabaseContext()) { var getUserTask = db.Users.FirstOrDefaultAsync(u => u.Email == mail); getUserTask.Wait(); var applicationUser = getUserTask.Result; if (applicationUser != null) { return(applicationUser); } else { return(null); } } }
public TrainingIndexViewModel(Training training) { ID = training.ID; AddDateTime = training.AddDateTime.ToShortDateString(); Purpose = training.Purpose; Title = training.Title; UpdateDateTime = training.UpdateDateTime; YoutubeURL = training.YoutubeURL; Tags = training.Tags.Select(x => x.Name).ToList(); using (var db = new MyCoachDatabaseContext()) { var userId = training.ApplicationUserId; var user = db.Users.FirstOrDefault(u => u.Id == userId); if (user != null) { UserName = user.UserName; } } }