public void Delete(UserMenuItemRelation entity)
{
try
{
LogEventManager.Logger.Error("Delete(UserMenuItemRelation entity) execution has started");
//Db.Set<UserMenuItemRelation>().Add(entity);
var relatedParams = Db.Set <MenuItemRelationRouteValue>().Where(it => it.MenuItemRelationId == entity.Id);
foreach (var menuItemRelationRouteValue in relatedParams)
{
RemoveRouteParameter(menuItemRelationRouteValue);
}
//Db.ChangeTracker.DetectChanges();
Db.Entry(entity).State = EntityState.Deleted;
Db.SaveChanges();
}
catch (Exception ex)
{
LogEventManager.Logger.Error(ex.Message, ex);
throw;
}
finally
{
LogEventManager.Logger.Error("Delete(UserMenuItemRelation entity) execution has finished");
}
}
public void SaveById(UserMenuItemRelation entity)
{
try
{
LogEventManager.Logger.Error("SaveById(UserMenuItemRelation entity) execution has started");
Save(entity);
}
catch (Exception ex)
{
LogEventManager.Logger.Error(ex.Message, ex);
throw;
}
finally
{
LogEventManager.Logger.Error("SaveById(UserMenuItemRelation entity) execution has finished");
}
}
public ActionResult SaveMenuItemRelation(MenuItemRelationAdminVm <int> vm, string oper)
{
try
{
if (oper.Equals("del"))
{
_menuRelationRepository.Delete(vm.Id);
return(Json(new { success = 1 }));
}
var menuItem = _menuItemRepository.Get()
.Single(it => it.Code.Equals(vm.MenuCode, StringComparison.OrdinalIgnoreCase));
var routeName = _routeNameRepository.Get().Single(it => it.Code.Equals(vm.RouteCode, StringComparison.OrdinalIgnoreCase));
var relationGroup = _menuItemRelationGroupRepository.Get().Single(it => it.Code.Equals(vm.MenuItemRelationGroupCode, StringComparison.OrdinalIgnoreCase));
var menuRelation = new UserMenuItemRelation
{
Id = vm.Id,
IsDocked = vm.IsDocked,
RouteNameId = routeName.Id,
MenuItemRelationGroupId = relationGroup.Id,
MenuItemId = menuItem.Id,
};
if (vm.Login != "Is public menu" && !string.IsNullOrEmpty(vm.Login))
{
menuRelation.User = new User
{
UserName = vm.Login
}
}
;
_menuRelationRepository.Save(menuRelation);
return(Json(new { success = 1 }));
}
catch (Exception ex)
{
LogEventManager.Logger.Error(ex.Message, ex);
return(Json(new { success = false }));
}
finally
{
}
}
public void Save(UserMenuItemRelation entity)
{
try
{
LogEventManager.Logger.Error("Save(UserMenuItemRelation entity) execution has started");
if (entity.User != null && entity.User.Id == 0 && entity.UserId == 0 && !string.IsNullOrEmpty(entity.User.UserName))
{
entity.User = Db.Set <User>().Single(it => it.UserName.Equals(entity.User.UserName));
}
//AddOrUpdate(entity, e => e.Id == entity.Id);
//if (Db.Entry(entity).State ==EntityState.Detached)
//{
// Db.Attach(entity);
//}
if (Db.Set <UserMenuItemRelation>().Any(it => it.Id == entity.Id))
{
Db.Entry(entity).State = EntityState.Modified;
}
else
{
Db.Set <UserMenuItemRelation>().Add(entity);
}
Db.SaveChanges();
}
catch (Exception ex)
{
LogEventManager.Logger.Error(ex.Message, ex);
throw;
}
finally
{
LogEventManager.Logger.Error("Save(UserMenuItemRelation entity) execution has finished");
}
}
internal static void PopulateDefaultMenuDataUserCtx(DbContext db)
{
try
{
var home = new MenuItem
{
//Id = 1,
Code = "1",
Name = "Home",
DateCreated = DateTime.Today,
IsActive = true,
SortOrder = 0
};
db.Set <MenuItem>().Add(home);
var admin = new MenuItem
{
//Id = 2,
Code = "2",
Name = "Admin",
DateCreated = DateTime.Today,
IsActive = true,
SortOrder = 0
};
db.Set <MenuItem>().Add(admin);
var roles =
new MenuItem
{
//Id = 5,
Code = "6",
Name = "Roles",
DateCreated = DateTime.Today,
IsActive = true,
SortOrder = 0,
ParentId = admin.Id
};
db.Set <MenuItem>().Add(roles);
var about = new MenuItem
{
//Id = 7,
Code = "7",
Name = "About",
DateCreated = DateTime.Today,
IsActive = true,
SortOrder = 0,
ParentId = home.Id
};
db.Set <MenuItem>().Add(about);
var marketing = new MenuItem
{
//Id = 7,
Code = "10",
Name = "Marketing",
DateCreated = DateTime.Today,
IsActive = true,
SortOrder = 0,
ParentId = home.Id
};
db.Set <MenuItem>().Add(marketing);
var users = new MenuItem
{
//Id = 6,
Code = "6",
Name = "Users",
DateCreated = DateTime.Today,
IsActive = true,
SortOrder = 0,
ParentId = admin.Id
};
db.Set <MenuItem>().Add(users);
var andrew = new User
{
Id = 1,
UserName = "******",
};
db.Set <User>().Add(andrew);
var alex = new User
{
Id = 2,
UserName = "******",
};
db.Set <User>().Add(alex);
var defaultName = new RouteName
{
// Id = 1,
Code = "1",
Name = "Default",
DateCreated = DateTime.Today,
IsActive = true,
SortOrder = 0
};
db.Set <RouteName>().Add(defaultName);
var controller = new RouteParam
{
// Id = 1,
Code = "1",
Name = "controller",
DateCreated = DateTime.Today,
IsActive = true,
SortOrder = 0
};
db.Set <RouteParam>().Add(controller);
var action = new RouteParam
{
// Id = 2,
Code = "2",
Name = "action",
DateCreated = DateTime.Today,
IsActive = true,
SortOrder = 0
};
db.Set <RouteParam>().Add(action);
var area = new RouteParam
{
// Id = 3,
Code = "3",
Name = "area",
DateCreated = DateTime.Today,
IsActive = true,
SortOrder = 0
};
db.Set <RouteParam>().Add(area);
var layoutRelationGroup = new MenuItemRelationGroup
{
// Id = 1,
Code = "1",
Name = "Layout",
DateCreated = DateTime.Today,
IsActive = true,
SortOrder = 0
};
db.Set <MenuItemRelationGroup>().Add(layoutRelationGroup);
var homeMenuRelation = new UserMenuItemRelation
{
// Id = 1,
MenuItemId = home.Id,
MenuItemRelationGroupId = layoutRelationGroup.Id,
RouteNameId = defaultName.Id,
UserId = andrew.Id
};
db.Set <UserMenuItemRelation>().Add(homeMenuRelation);
var homeAlexRelation = new UserMenuItemRelation
{
// Id = 2,
MenuItemId = home.Id,
MenuItemRelationGroupId = layoutRelationGroup.Id,
RouteNameId = defaultName.Id,
UserId = alex.Id
};
db.Set <UserMenuItemRelation>().Add(homeAlexRelation);
var adminAndrewRelation = new UserMenuItemRelation
{
// Id = 3,
MenuItemId = admin.Id,
MenuItemRelationGroupId = layoutRelationGroup.Id,
RouteNameId = defaultName.Id,
UserId = andrew.Id
};
db.Set <UserMenuItemRelation>().Add(adminAndrewRelation);
var aboutAndrewRelation = new UserMenuItemRelation
{
// Id = 4,
MenuItemId = about.Id,
MenuItemRelationGroupId = layoutRelationGroup.Id,
RouteNameId = defaultName.Id,
UserId = andrew.Id
};
db.Set <UserMenuItemRelation>().Add(aboutAndrewRelation);
var aboutAlexRelation = new UserMenuItemRelation
{
// Id = 4,
MenuItemId = about.Id,
MenuItemRelationGroupId = layoutRelationGroup.Id,
RouteNameId = defaultName.Id,
UserId = alex.Id
};
db.Set <UserMenuItemRelation>().Add(aboutAlexRelation);
var usersAndrewRelation = new UserMenuItemRelation
{
// Id = 6,
MenuItemId = users.Id,
MenuItemRelationGroupId = layoutRelationGroup.Id,
RouteNameId = defaultName.Id,
UserId = andrew.Id
};
db.Set <UserMenuItemRelation>().Add(usersAndrewRelation);
var rolesAndrewRelation = new UserMenuItemRelation
{
//Id = 7,
MenuItemId = roles.Id,
MenuItemRelationGroupId = layoutRelationGroup.Id,
RouteNameId = defaultName.Id,
UserId = andrew.Id
};
db.Set <UserMenuItemRelation>().Add(rolesAndrewRelation);
var andrewMarketing = new UserMenuItemRelation
{
MenuItemId = marketing.Id,
MenuItemRelationGroupId = layoutRelationGroup.Id,
RouteNameId = defaultName.Id,
UserId = andrew.Id
};
db.Set <UserMenuItemRelation>().Add(andrewMarketing);
db.Set <MenuItemRelationRouteValue>().Add(new MenuItemRelationRouteValue
{
RouteParamId = controller.Id,
Value = "Home",
MenuItemRelationId = andrewMarketing.Id
});
db.Set <MenuItemRelationRouteValue>().Add(new MenuItemRelationRouteValue
{
RouteParamId = action.Id,
Value = "Index",
MenuItemRelationId = andrewMarketing.Id
});
db.Set <MenuItemRelationRouteValue>().Add(new MenuItemRelationRouteValue
{
RouteParamId = area.Id,
Value = "marketing",
MenuItemRelationId = andrewMarketing.Id
});
db.Set <MenuItemRelationRouteValue>().Add(new MenuItemRelationRouteValue
{
RouteParamId = controller.Id,
Value = "Home",
MenuItemRelationId = homeMenuRelation.Id
});
db.Set <MenuItemRelationRouteValue>().Add(new MenuItemRelationRouteValue
{
RouteParamId = controller.Id,
Value = "Home",
MenuItemRelationId = homeAlexRelation.Id
});
db.Set <MenuItemRelationRouteValue>().Add(new MenuItemRelationRouteValue
{
RouteParamId = controller.Id,
Value = "Home",
MenuItemRelationId = aboutAndrewRelation.Id
});
db.Set <MenuItemRelationRouteValue>().Add(new MenuItemRelationRouteValue
{
RouteParamId = action.Id,
Value = "About",
MenuItemRelationId = aboutAndrewRelation.Id
});
db.Set <MenuItemRelationRouteValue>().Add(new MenuItemRelationRouteValue
{
RouteParamId = action.Id,
Value = "Index",
MenuItemRelationId = homeAlexRelation.Id
});
db.Set <MenuItemRelationRouteValue>().Add(new MenuItemRelationRouteValue
{
RouteParamId = action.Id,
Value = "Index",
MenuItemRelationId = homeMenuRelation.Id
});
db.Set <MenuItemRelationRouteValue>().Add(new MenuItemRelationRouteValue
{
RouteParamId = controller.Id,
Value = "Admin",
MenuItemRelationId = adminAndrewRelation.Id
});
db.Set <MenuItemRelationRouteValue>().Add(new MenuItemRelationRouteValue
{
RouteParamId = controller.Id,
Value = "Admin",
MenuItemRelationId = rolesAndrewRelation.Id
});
db.Set <MenuItemRelationRouteValue>().Add(new MenuItemRelationRouteValue
{
RouteParamId = action.Id,
Value = "Roles",
MenuItemRelationId = rolesAndrewRelation.Id
});
db.Set <MenuItemRelationRouteValue>().Add(new MenuItemRelationRouteValue
{
RouteParamId = controller.Id,
Value = "Admin",
MenuItemRelationId = usersAndrewRelation.Id
});
db.Set <MenuItemRelationRouteValue>().Add(new MenuItemRelationRouteValue
{
RouteParamId = action.Id,
Value = "Users",
MenuItemRelationId = usersAndrewRelation.Id
});
db.Set <MenuItemRelationRouteValue>().Add(new MenuItemRelationRouteValue
{
RouteParamId = action.Id,
Value = "Index",
MenuItemRelationId = adminAndrewRelation.Id
});
db.SaveChanges();
}
catch (Exception ex)
{
LogEventManager.Logger.Error(ex.Message, ex);
throw;
}
}
