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