Hi. I have a question. So, I'm registering a user, but a table is created for me (empty), and I can't figure out how to save my data when registering in the database? I tried to write various functions, but I failed. Below I send the code:
Users.cs:
using Microsoft.AspNetCore.Mvc;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using TestBlazor.Models;
namespace TestBlazor.Data
{
//public interface IToDoListService
//{
// Task<User> Add(User user);
//}
public class Users
{
//public static void AddUsers()
//{
// using (var context = new AppDbContext())
// {
// //var user = new User { Url = "" };
// context.User.Add(User);
// context.SaveChanges();
// }
//}
private readonly AppDbContext _dataContext;
public Users(AppDbContext dataContext)
{
_dataContext = dataContext;
}
//public void Save()
//{
// _dataContext.SaveChanges();
//}
//public async Task<User> Add(User user)
//{
// _dataContext.User.Add(user);
// await _dataContext.SaveChangesAsync();
// return user;
//}
//[HttpPost]
//public void Add([FromBody] User user)
//{
// _dataContext.User.Add(user);
// _dataContext.SaveChanges();
//}
//[HttpPost]
//public void Add(User user)
//{
// //Determine the next ID
// var newID = _dataContext.User.Select(x => x.UserId).Max() + 1;
// user.UserId = newID;
// _dataContext.User.Add(user);
// _dataContext.SaveChanges();
// //return RedirectToAction("Index");
//}
public void AddUser(User user)
{
try
{
_dataContext.User.Add(user);
_dataContext.SaveChanges();
}
catch
{
throw;
}
}
}
}AppDbContext.cs:
using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using TestBlazor.Models;
namespace TestBlazor.Data
{
public class AppDbContext : DbContext
{
public AppDbContext()
{
}
public AppDbContext(DbContextOptions<AppDbContext> options) : base(options)
{
}
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
if (!optionsBuilder.IsConfigured)
{
optionsBuilder.UseSqlServer("Data Source=(LocalDb)\\MSSQLLocalDB;Initial Catalog=testblazor;Integrated Security=True;");
}
}
//protected override void OnModelCreating(ModelBuilder modelBuilder)
//{
// base.OnModelCreating(modelBuilder);
// modelBuilder.Entity<User>()
//}
public DbSet<User> User { get; set; }
public DbSet<Item> Items { get; set; }
}
}User.cs:
using FluentValidation;
using Microsoft.AspNetCore.Mvc;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Threading;
using System.Threading.Tasks;
namespace TestBlazor.Models
{
[Table("Users")]
public class User
{
[Display(AutoGenerateField = false)]
public int UserId { get; set; }
[Display(Name = "UserName")]
[Required(ErrorMessage = "UserName is required.")]
public string UserName { get; set; }
[Display(Name = "Password")]
[Required]
[MinLength(8, ErrorMessage = "password must be atleast 8 characters")]
[DataType(DataType.Password)]
public string Password { get; set; }
[Display(Name = "Email")]
[Required(ErrorMessage = "Email is required.")]
public string Email { get; set; }
[Display(Name = "Company")]
[StringLength(255)]
[Required(ErrorMessage = "Company is required.")]
[Remote("doesCompanyExist", "Company", HttpMethod = "POST", ErrorMessage = "Company already exists. Please enter a different company.")]
public string Company { get; set; }
public User GetRegisteredUser()
{
return new User
{
UserName = UserName,
Password = Password,
Email = Email,
Company = Company,
};
}
}
}Register.razor:
@page "/register"
@using TestBlazor.Models
@using TestBlazor.Data
@*@inject IToDoListService user*@
<br />
<br />
<h3><b>Register</b></h3>
<br />
<EditForm class="needs-validation" Model="@_user" OnValidSubmit="@HandleValidSubmit" OnInvalidSubmit="@HandleInvalidSubmit">
<div class="alert @StatusClass">@StatusMessage</div>
<DataAnnotationsValidator />
<ValidationSummary />
<div class="form-group">
<p><b>User name</b></p>
<input id="username" class="solid" name="username" placeholder="Your username.." @bind-value="_user.UserName" />
<ValidationMessage For="@(() => @_user.UserName)"></ValidationMessage>
</div>
<div class="form-group">
<p><b>Password</b></p>
<input type="password" class="solid" id="password" placeholder="Your password.." @bind-value="_user.Password" />
<ValidationMessage For="@(() => @_user.Password)"></ValidationMessage>
</div>
<div class="form-group">
<p><b>Email</b></p>
<input id="email" class="solid" placeholder="you@example.com" @bind-value="_user.Email" />
<ValidationMessage For="@(() => @_user.Email)"></ValidationMessage>
</div>
<div class="form-group">
<p><b>Company</b></p>
<input id="company" class="solid" placeholder="Your company.." @bind-value="_user.Company" />
<ValidationMessage For="@(() => @_user.Company)"></ValidationMessage>
</div>
<br />
<button disabled="@loading" class="btn btn-primary">
@if (loading)
{
<span class="spinner-border spinner-border-sm mr-1"></span>
<NavLink href="/login" class="btn btn-link">Register</NavLink>
}
Register
</button>
<NavLink href="/login" class="btn btn-link">Login</NavLink>
</EditForm>
@code {
private User _user = new User();
private string StatusMessage;
private string StatusClass;
private bool loading;
private void OnValidSubmit()
{
if (loading == true)
{
Console.WriteLine("You have successfully registered!");
}
else
{
loading = false;
Console.WriteLine("Check your information again!");
}
}
protected void HandleValidSubmit()
{
StatusClass = "alert-info";
StatusMessage = " You have successfully registered! Please click the Login button to log in!";
}
protected void HandleInvalidSubmit()
{
StatusClass = "alert-danger";
StatusMessage = " Check your information again!";
}
public bool doesCompanyExist(string Company)
{
try
{
if (Company != null)
{
return true;
}
}
catch (Exception)
{
return false;
}
return false;
}
}