public string GetTheBest() { using (var context = new SkillInfoContext()) { var userId = context.UserSkills.GroupBy(u => u.UserId) .Select(g => new {UserId = g.Key, Marks = g.Sum(m => m.Mark)}) .OrderByDescending(d => d.Marks) .First() .UserId; var name = context.UserProfiles.Where(u => u.UserId == userId).Select(u => u.UserName).First(); return name; } }
public Dictionary<string, string> GetBirthdayUsers() { using (var context = new SkillInfoContext()) { var users = context.UserProfiles.Where( user => user.Birthday.HasValue && user.Birthday.Value.Year == DateTime.Now.Year && user.Birthday.Value.Month == DateTime.Now.Month && user.Birthday.Value.Day == DateTime.Now.Day) .Select(user => new {user.UserName, user.Email}); return users.ToDictionary(user => user.UserName, user => user.Email); } }
public SearchRepository(SkillInfoContext context) { _context = context; }
public ActionResult ManageBirthday(BirthdayModel model) { if (ModelState.IsValid) { try { using (SkillInfoContext db = new SkillInfoContext()) { // Set Birthday date to the current user var user = db.UserProfiles.FirstOrDefault(u => u.UserName == User.Identity.Name); if (user != null) { user.Birthday = model.Date; } db.SaveChanges(); } return RedirectToAction("Index", "Home"); } catch {} } return View("Manage"); }
public ActionResult ExternalLoginConfirmation(RegisterExternalLoginModel model, string returnUrl) { string provider = null; string providerUserId = null; if (User.Identity.IsAuthenticated || !OAuthWebSecurity.TryDeserializeProviderUserId(model.ExternalLoginData, out provider, out providerUserId)) { return RedirectToAction("Manage"); } if (ModelState.IsValid) { // Insert a new user into the database using (SkillInfoContext db = new SkillInfoContext()) { UserProfile user = db.UserProfiles.FirstOrDefault(u => u.UserName.ToLower() == model.UserName.ToLower()); // Check if user already exists if (user == null) { // Insert name into the profile table db.UserProfiles.Add(new UserProfile { UserName = model.UserName }); db.SaveChanges(); OAuthWebSecurity.CreateOrUpdateAccount(provider, providerUserId, model.UserName); OAuthWebSecurity.Login(provider, providerUserId, createPersistentCookie: false); return RedirectToLocal(returnUrl); } else { ModelState.AddModelError("UserName", "User name already exists. Please enter a different user name."); } } } ViewBag.ProviderDisplayName = OAuthWebSecurity.GetOAuthClientData(provider).DisplayName; ViewBag.ReturnUrl = returnUrl; return View(model); }