/// <summary>
/// Delete record
/// </summary>
/// <param name="dbContext"></param>
/// <method>Delete(AuthorizationServiceDbContext dbContext)</method>
public void Delete(AuthorizationServiceDbContext dbContext)
{
if (!this.IsNew)
{
dbContext.Attach <DataModel <T> >(this);
dbContext.Remove <DataModel <T> >(this);
dbContext.SaveChanges();
}
}
/// <summary>
/// Add/Update record
/// </summary>
/// <method>AddUpdate(CDCavellDbContext dbContext)</method>
public virtual void AddUpdate(AuthorizationServiceDbContext dbContext)
{
if (this.IsNew)
{
dbContext.Add <DataModel <T> >(this);
}
else
{
dbContext.Update <DataModel <T> >(this);
}
dbContext.SaveChanges();
}
/// <summary>
/// Initialize method
/// <br />
/// To Initialize: dotnet ef migrations add InitialCreate
/// <br />
/// To Update: dotnet ef migrations add UpdateDatabase_<<YYYY-MM-DD>>
/// <br /><br />
/// EF Core tools reference: https://docs.microsoft.com/en-us/ef/core/cli/dotnet
/// <br />
/// Install EF Core Tools: dotnet tool install --global dotnet-ef
/// <br />
/// Upgrade EF Core Tools: dotnet tool update --global dotnet-ef
/// <br /><br />
/// _Before you can use the tools on a specific project, you'll need to add the `Microsoft.EntityFrameworkCore.Design` package to it._
/// </summary>
/// <param name="context">AuthorizationServiceDbContext</param>
/// <param name="siteAdministrator">SiteAdministrator</param>
/// <method>Initialize(MigrateDdContext context)</method>
public static void Initialize(AuthorizationServiceDbContext context, SiteAdministrator siteAdministrator)
{
IEnumerable <string> pending = context.Database.GetPendingMigrations();
if (pending.Any())
{
context.Database.Migrate();
}
if (!context.Roles.Any())
{
var role = new ApplicationRole();
role.Name = "SysAdmin";
role.NormalizedName = role.Name.ToUpper();
context.Roles.Add(role);
context.SaveChanges();
var roleClaim = new ApplicationRoleClaim();
roleClaim.RoleId = role.Id;
roleClaim.ClaimType = "SysAdmin";
roleClaim.ClaimValue = "Active";
role.RoleClaims.Add(roleClaim);
context.Roles.Update(role);
context.SaveChanges();
role = new ApplicationRole();
role.Name = "Admin";
role.NormalizedName = role.Name.ToUpper();
context.Roles.Add(role);
context.SaveChanges();
roleClaim = new ApplicationRoleClaim();
roleClaim.RoleId = role.Id;
roleClaim.ClaimType = "View";
roleClaim.ClaimValue = "Active";
role.RoleClaims.Add(roleClaim);
roleClaim = new ApplicationRoleClaim();
roleClaim.RoleId = role.Id;
roleClaim.ClaimType = "Edit";
roleClaim.ClaimValue = "Active";
role.RoleClaims.Add(roleClaim);
roleClaim = new ApplicationRoleClaim();
roleClaim.RoleId = role.Id;
roleClaim.ClaimType = "Remove";
roleClaim.ClaimValue = "Active";
role.RoleClaims.Add(roleClaim);
roleClaim = new ApplicationRoleClaim();
roleClaim.RoleId = role.Id;
roleClaim.ClaimType = "Approve";
roleClaim.ClaimValue = "Active";
role.RoleClaims.Add(roleClaim);
context.Roles.Update(role);
context.SaveChanges();
role = new ApplicationRole();
role.Name = "User";
role.NormalizedName = role.Name.ToUpper();
context.Roles.Add(role);
context.SaveChanges();
roleClaim = new ApplicationRoleClaim();
roleClaim.RoleId = role.Id;
roleClaim.ClaimType = "View";
roleClaim.ClaimValue = "Active";
role.RoleClaims.Add(roleClaim);
roleClaim = new ApplicationRoleClaim();
roleClaim.RoleId = role.Id;
roleClaim.ClaimType = "Edit";
roleClaim.ClaimValue = "Active";
role.RoleClaims.Add(roleClaim);
roleClaim = new ApplicationRoleClaim();
roleClaim.RoleId = role.Id;
roleClaim.ClaimType = "Remove";
roleClaim.ClaimValue = "Active";
role.RoleClaims.Add(roleClaim);
context.Roles.Update(role);
context.SaveChanges();
}
if (!context.Users.Any())
{
var role = context.Roles.Include("RoleClaims")
.Where(x => x.NormalizedName == "SYSADMIN")
.FirstOrDefault();
if (role != null)
{
var roleClaim = role.RoleClaims
.Where(x => x.NormalizedClaimType == "SYSADMIN")
.Where(x => x.NormalizedClaimValue == "ACTIVE")
.FirstOrDefault();
if (roleClaim != null)
{
var user = new ApplicationUser();
user.Email = siteAdministrator.Email;
user.NormalizedEmail = user.Email.ToUpper();
user.EmailConfirmed = true;
user.UserName = user.Email;
user.NormalizedUserName = user.UserName.ToUpper();
user.FirstName = siteAdministrator.FirstName;
user.LastName = siteAdministrator.LastName;
user.RequestDate = DateTime.Now;
user.ApprovedDate = DateTime.Now;
user.RoleClaims.Add(new AspNetUserRoleClaim()
{
User = user,
Role = role,
RoleClaim = roleClaim,
Status = AspNetUserRoleClaim.RoleClaimStatus.Approved
});
context.Add(user);
context.SaveChanges();
user.ApprovedById = user.Id;
foreach (AspNetUserRoleClaim userRoleClaim in user.RoleClaims)
{
userRoleClaim.History.Add(new AspNetUserRoleClaimHistory()
{
UserRoleClaimId = userRoleClaim.Id,
ActionOn = DateTime.Now,
ActionById = user.Id,
Status = userRoleClaim.Status
});
}
context.Update(user);
context.SaveChanges();
}
}
}
}