public IActionResult Create() { if (User.IsInRole("user")) { var user = (from account in _context.UserAccount where account.Email.Equals(User.Identity.Name) select account).FirstOrDefault(); //Delete the existing reports var reports = (from rep in _context.MontlyExpenseReport where rep.UserAccountId == user.Id select rep ).ToList(); _context.RemoveRange(reports); _context.SaveChanges(); //Group by monthly var groupedMonthly = (from expenses in _context.ExpenseRecord where expenses.UserAccountId == user.Id group expenses by new { expenses.Date.Year, expenses.Date.Month } into monthly select new MontlyExpenseReport { Year = monthly.Key.Year, Month = monthly.Key.Month, TotalExpenses = monthly.Sum(e => e.Amount), UserAccountId = user.Id }).ToList(); _context.AddRange(groupedMonthly); _context.SaveChanges(); return(RedirectToAction(nameof(Index))); } return(View()); }
public async Task <IActionResult> OnPostAsync(string returnUrl = null) { returnUrl = returnUrl ?? Url.Content("~/"); ExternalLogins = (await _signInManager.GetExternalAuthenticationSchemesAsync()).ToList(); if (ModelState.IsValid) { var user = new IdentityUser { UserName = Input.Email, Email = Input.Email }; var result = await _userManager.CreateAsync(user, Input.Password); if (result.Succeeded) { var userAccount = new UserAccount { Email = user.Email, Name = Input.Name, }; dataContext.Add(userAccount); dataContext.SaveChanges(); var roleExistsResult = await _roleManager.RoleExistsAsync("user"); if (!roleExistsResult) { var roleReuslt = await _roleManager.CreateAsync(new IdentityRole("user")); if (roleReuslt.Succeeded) { await _userManager.AddToRoleAsync(user, "user"); } } else { await _userManager.AddToRoleAsync(user, "user"); } _logger.LogInformation("User created a new account with password."); var code = await _userManager.GenerateEmailConfirmationTokenAsync(user); code = WebEncoders.Base64UrlEncode(Encoding.UTF8.GetBytes(code)); var callbackUrl = Url.Page( "/Account/ConfirmEmail", pageHandler: null, values: new { area = "Identity", userId = user.Id, code = code }, protocol: Request.Scheme); await _emailSender.SendEmailAsync(Input.Email, "Confirm your email", $"Please confirm your account by <a href='{HtmlEncoder.Default.Encode(callbackUrl)}'>clicking here</a>."); if (_userManager.Options.SignIn.RequireConfirmedAccount) { return(RedirectToPage("RegisterConfirmation", new { email = Input.Email })); } else { await _signInManager.SignInAsync(user, isPersistent : false); return(LocalRedirect(returnUrl)); } } foreach (var error in result.Errors) { ModelState.AddModelError(string.Empty, error.Description); } } // If we got this far, something failed, redisplay form return(Page()); }