public ActionResult Create(Vacation vacation) { DateTime vacationDate = vacation.VacationDate; int userId = vacation.UserId; int vacationCount = db.Vacations.Where(c => c.UserId == userId && c.VacationDate.Year == vacationDate.Year).Count(); String errorMsg = "More than 10 days is not allowed for the year " + vacationDate.Year; try { if (vacationCount >= 10) { throw new ValidationException("More than 10 days is not allowed for the year " + vacationDate.Year); } } catch (ValidationException e) { errorMsg = e.Message; } if (ModelState.IsValid && vacationCount < 10) { db.Vacations.Add(vacation); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.UserId = new SelectList(db.UserProfiles, "UserId", "UserName", vacation.UserId); ViewBag.ErrorMsg = errorMsg; return(View(vacation)); }
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 (MainContextDb db = new MainContextDb()) { 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)); }