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());
}