public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new AuthorizationContext(
serviceProvider.GetRequiredService <
DbContextOptions <AuthorizationContext> >()))
{
// Look for any movies.
if (context.MarsControllers.Any())
{
return; // DB has been seeded
}
context.MarsControllers.AddRange(
new MarsController
{
Login = "******",
Password = "******",
Email = "*****@*****.**",
Number = 0000007,
Country = "USA,Washington"
}
);
context.SaveChanges();
}
}
/// <summary>
/// ロールの登録を行える
/// </summary>
/// <param name="name"></param>
/// <param name="description"></param>
public void AddRole(string name, string description)
{
Contract.NotEmpty(name, "name");
using (AuthorizationContext context = AuthorizationContext.CreateContext())
{
CheckDuplicateRoleName(context, name);
var newRole = new Roles();
newRole.RoleID = GetNextRoleId(context);
newRole.RoleName = name;
newRole.Description = description;
newRole.CreatedDate = DateTime.Now;
newRole.CreatedUser = GetEmployeeID().ToString();
context.Roles.Add(newRole);
context.SaveChanges();
}
}
public void RemoveTargetInTargets(int targetId, int parentTargetId)
{
using (AuthorizationContext context = AuthorizationContext.CreateContext())
{
//get exist target in targets
var target = (from r in context.TargetInTargets
where r.TargetID == targetId &&
r.ParentTargetID == parentTargetId &&
r.DeletedFlag == "0"
select r).SingleOrDefault();
if (target == null)
{
throw new Exception("");
}
context.TargetInTargets.Remove(target);
context.SaveChanges();
}
}
/// <summary>
/// ターゲットに紐づくターゲットを削除する
/// </summary>
/// <param name="targetId"></param>
public void RemoveTarget(int targetId)
{
using (AuthorizationContext context = AuthorizationContext.CreateContext())
{
var parentTargets = GetParentTargets(context);
CheckTargetHaveChildTargetBeforeDelete(parentTargets, targetId);
CheckTargetHaveReferenceWithPermissionBeforeDelete(context, targetId);
//get target exist
var target = context.Targets.SingleOrDefault(x => x.TargetID == targetId && x.DeleteFlag == "0");
if (target == null)
{
throw new Exception("");
}
context.Targets.Remove(target);
context.SaveChanges();
}
}
/// <summary>
/// ターゲットの登録を行える
/// </summary>
/// <param name="title">ターゲットに紐づくターゲットが存在する場合はエラーメッセージを表示する</param>
/// <param name="content">ターゲットのコンテンツを登録する</param>
/// <param name="contentType">ターゲットのコンテンツタイプを登録する（URL、Control、グループなど）</param>
public void AddTargets(string title, string content, ContentTypes contentType)
{
Contract.NotEmpty(title, "title");
Contract.NotNull(contentType, "contentType");
using (AuthorizationContext context = AuthorizationContext.CreateContext())
{
CheckTargetByTitleOrContent(context, title, content);
var target = new Targets();
target.TargetID = GetNextTargetId();
target.Title = title;
target.Content = content;
target.ContentType = (short)contentType;
target.CreatedDate = DateTime.Now;
target.CreatedUser = GetEmployeeID();
context.Targets.Add(target);
context.SaveChanges();
}
}
/// <summary>
/// Remove role out of roles
/// </summary>
/// <param name="roleId"></param>
/// <param name="parentRoleId"></param>
public void RemoveRoleInRoles(int roleId, int parentRoleId)
{
using (AuthorizationContext context = AuthorizationContext.CreateContext())
{
//get exist role in roles
var role = (from r in context.RoleInRoles
where r.RoleID == roleId &&
r.ParentRoleID == parentRoleId &&
r.DeleteFlag == "0"
select r).SingleOrDefault();
if (role == null)
{
throw new Exception("");
}
context.RoleInRoles.Remove(role);
context.SaveChanges();
}
}
/// <summary>
/// ロールの削除が行える
/// </summary>
/// <param name="roleId"></param>
public void RemoveRole(int roleId)
{
using (AuthorizationContext context = AuthorizationContext.CreateContext())
{
var parentRoles = GetParentRoles(context);
//Cannot delete role if this role have child-role
CheckRoleHaveChildRoleBeforeDelete(parentRoles, roleId);
//Cannot delete role if this role have reference with user.
CheckRoleHaveReferenceWithUserBeforeDelete(roleId);
//Get exist role
var role = context.Roles.SingleOrDefault(x => x.RoleID == roleId && x.DeleteFlag == "0");
if (role == null)
{
throw new Exception("");
}
context.Roles.Remove(role);
context.SaveChanges();
}
}
public void Save()
{
db.SaveChanges();
}
