public void CreateRoles()
{
if (foundAudience == null)
{
CreateAudiences();
}
/*
* create test roles
*/
foundRole = _uow.Roles.Get(QueryExpressionFactory.GetQueryExpression <tbl_Role>()
.Where(x => x.Name == TestDefaultConstants.RoleName).ToLambda())
.SingleOrDefault();
if (foundRole == null)
{
foundRole = _uow.Roles.Create(
_map.Map <tbl_Role>(new RoleV1()
{
AudienceId = foundAudience.Id,
Name = TestDefaultConstants.RoleName,
IsEnabled = true,
IsDeletable = true,
}));
_uow.Commit();
}
}
public bool IsInRole(tbl_User user, tbl_Role role)
{
if (_context.Set<tbl_UserRole>()
.Any(x => x.UserId == user.Id && x.RoleId == role.Id))
return true;
return false;
}
public bool IsInRole(tbl_Audience audience, tbl_Role role)
{
if (_context.Set <tbl_AudienceRole>()
.Any(x => x.AudienceId == audience.Id && x.RoleId == role.Id))
{
return(true);
}
return(false);
}
public ActionResult Manage(RoleInfo info)
{
var service = Container.GetService <IRoleService>();
var data = new AjaxResult();
try
{
if (info.Key > 0)
{
var role = service.GetModels(r => r.keyid == info.Key).FirstOrDefault();
if (role != null)
{
role.C_Name = info.Name;
role.C_Description = info.Description;
role.C_ParentRole = info.ParentKey;
role.C_UpdatedDate = DateTime.Now;
var success = service.Update(role);
if (success)
{
data.Message = "修改成功";
}
else
{
data.Message = "修改失败";
}
}
else
{
data.Message = "不存在的角色";
}
}
else
{
var role = new tbl_Role();
role.C_Name = info.Name;
role.C_Description = info.Description;
role.C_ParentRole = info.ParentKey;
role.C_CreatedDate = DateTime.Now;
var success = service.Add(role);
if (success)
{
data.Message = "添加成功";
}
else
{
data.Message = "添加失败";
}
}
}
catch (Exception ex) {
data.Message = ex.Message;
}
return(Json(data));
}
public async Task <IHttpActionResult> AddRole(tbl_Role item)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
CRUDOperation operation = new CRUDOperation();
tbl_Role dbitem = operation.AddRole(item);
return(Ok(dbitem));
}
public async Task <IHttpActionResult> UpdateRole(tbl_Role item)
{
CRUDOperation operation = new CRUDOperation();
if (item == null)
{
return(NotFound());
}
else
{
var dbitem = operation.UpdateRole(item);
return(Ok(dbitem));
}
}
public IActionResult GetV1([FromRoute] string roleValue)
{
Guid roleID;
tbl_Role role = null;
if (Guid.TryParse(roleValue, out roleID))
{
role = uow.Roles.Get(x => x.Id == roleID)
.SingleOrDefault();
}
else
{
role = uow.Roles.Get(x => x.Name == roleValue)
.SingleOrDefault();
}
if (role == null)
{
ModelState.AddModelError(MessageType.RoleNotFound.ToString(), $"Role:{roleValue}");
return(NotFound(ModelState));
}
return(Ok(map.Map <RoleV1>(role)));
}
public void update(tbl_Role item)
{
rep.update(item);
}
public void add(tbl_Role item)
{
rep.add(item);
}
public void CreateRoles()
{
if (foundAudience_Alert == null ||
foundAudience_Identity == null)
{
CreateAudiences();
}
/*
* create default roles
*/
foundRoleForAdmin_Alert = _uow.Roles.Get(QueryExpressionFactory.GetQueryExpression <tbl_Role>()
.Where(x => x.Name == DefaultConstants.RoleForAdmins_Alert).ToLambda())
.SingleOrDefault();
if (foundRoleForAdmin_Alert == null)
{
foundRoleForAdmin_Alert = _uow.Roles.Create(
_map.Map <tbl_Role>(new RoleV1()
{
AudienceId = foundAudience_Alert.Id,
Name = DefaultConstants.RoleForAdmins_Alert,
IsEnabled = true,
IsDeletable = false,
}));
_uow.Commit();
}
foundRoleForUser_Alert = _uow.Roles.Get(QueryExpressionFactory.GetQueryExpression <tbl_Role>()
.Where(x => x.Name == DefaultConstants.RoleForUsers_Alert).ToLambda())
.SingleOrDefault();
if (foundRoleForUser_Alert == null)
{
foundRoleForUser_Alert = _uow.Roles.Create(
_map.Map <tbl_Role>(new RoleV1()
{
AudienceId = foundAudience_Alert.Id,
Name = DefaultConstants.RoleForUsers_Alert,
IsEnabled = true,
IsDeletable = false,
}));
_uow.Commit();
}
foundRoleForAdmin_Identity = _uow.Roles.Get(QueryExpressionFactory.GetQueryExpression <tbl_Role>()
.Where(x => x.Name == DefaultConstants.RoleForAdmins_Identity).ToLambda())
.SingleOrDefault();
if (foundRoleForAdmin_Identity == null)
{
foundRoleForAdmin_Identity = _uow.Roles.Create(
_map.Map <tbl_Role>(new RoleV1()
{
AudienceId = foundAudience_Identity.Id,
Name = DefaultConstants.RoleForAdmins_Identity,
IsEnabled = true,
IsDeletable = false,
}));
_uow.Commit();
}
foundRoleForUser_Identity = _uow.Roles.Get(QueryExpressionFactory.GetQueryExpression <tbl_Role>()
.Where(x => x.Name == DefaultConstants.RoleForUsers_Identity).ToLambda())
.SingleOrDefault();
if (foundRoleForUser_Identity == null)
{
foundRoleForUser_Identity = _uow.Roles.Create(
_map.Map <tbl_Role>(new RoleV1()
{
AudienceId = foundAudience_Identity.Id,
Name = DefaultConstants.RoleForUsers_Identity,
IsEnabled = true,
IsDeletable = false,
}));
_uow.Commit();
}
}
public ActionResult CreateUser(tbl_User tbl_User, tbl_Role tbl_Role)
{
using (var _context = new Entities())
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
string password = string.Empty;
if (tbl_User.Pno != null)
{
password = "******" + tbl_User.Pno.Trim();
}
if (!ModelState.IsValid)
{
UserRoleViewModel vm = new UserRoleViewModel()
{
_tbl_Role = _context.tbl_Role.ToList(),
_tbl_Unit = _context.tbl_Unit.ToList(),
};
return(PartialView("_CreateUser", vm));
}
if (tbl_User.Pno != null)
{
tbl_User.UserId = tbl_User.Pno;
tbl_User.Password = password;
_context.tbl_User.Add(tbl_User);
_context.SaveChanges();
if (tbl_Role.RoleId != null)
{
var obj = new tbl_UserRole()
{
UserId = tbl_User.UserId,
RoleId = tbl_Role.RoleId,
IsDefault = 1,
IsActive = 1,
};
_context.tbl_UserRole.Add(obj);
_context.SaveChanges();
}
}
#region User Injection
var UserName = tbl_User.UserId;
var Password = password;
var objNewAdminUser = new ApplicationUser {
Id = tbl_User.UserId, UserName = tbl_User.UserId, Email = tbl_User.UserId
};
var AdminUserCreateResult = UserManager.Create(objNewAdminUser, Password);
if (AdminUserCreateResult.Succeeded)
{
transaction.Commit();
}
else
{
transaction.Rollback();
}
#endregion
return(RedirectToAction("UserIndex"));
}
catch (Exception ex)
{
transaction.Rollback();
// Exception(ex);
// Alert("Their is something went wrong!!!", NotificationType.error);
return(RedirectToAction("UserIndex"));
}
}
}
}
public ActionResult Edit(string id, tbl_Role tbl_Role, string selectedItems)
{
using (var _context = new Entities())
{
using (var transaction = _context.Database.BeginTransaction())
{
List <TreeViewNode> parentItems = new List <TreeViewNode>();
var vm = new RolesViewModel();
try
{
if (id != null)
{
_context.tbl_RolePermission.RemoveRange(_context.tbl_RolePermission.Where(x => x.RoleId == id));
_context.SaveChanges();
}
if (selectedItems != "[]")
{
List <TreeViewNode> items = (new JavaScriptSerializer()).Deserialize <List <TreeViewNode> >(selectedItems);
List <string> newListOfParent = new List <string>();
foreach (var temp in items.Select(x => x.parents))
{
newListOfParent = newListOfParent.Concat(temp).ToList();
}
newListOfParent = newListOfParent.Distinct().ToList();
foreach (var selected in items)
{
if (selected.parent == "#")
{
selected.parent = "0";
}
if (!_context.tbl_RolePermission.Where(x => x.RoleId == tbl_Role.RoleId).Any(x => x.PermissionId == selected.id))
{
var model = new tbl_RolePermission
{
PermissionId = selected.id,
RoleId = tbl_Role.RoleId,
};
_context.tbl_RolePermission.Add(model);
}
}
foreach (var selected in newListOfParent)
{
if (!items.Where(x => x.id == selected).Any() && selected != "#")
{
tbl_Permission permission = _context.tbl_Permission.Where(x => x.PermissionId == selected).FirstOrDefault();
if (!_context.tbl_RolePermission.Where(x => x.RoleId == tbl_Role.RoleId).Any(x => x.PermissionId == selected))
{
var model = new tbl_RolePermission
{
PermissionId = selected,
RoleId = tbl_Role.RoleId,
};
_context.tbl_RolePermission.Add(model);
}
}
}
_context.SaveChanges();
}
//Serialize to JSON string.
// Alert("Data Saved Sucessfully!!!", NotificationType.success);
transaction.Commit();
return(RedirectToAction("ViewRoles"));
}
catch (Exception ex)
{
transaction.Rollback();
// Exception(ex);
// Alert("Their is something went wrong!!!", NotificationType.error);
return(RedirectToAction("ViewRoles"));
}
}
}
}
