public async Task DeleteEmployees(GroupModel group, IEnumerable <string> employeeIDs)
{
_exceptions.Clear();
try
{
if (!_context.Entry(group).Collection(g => g.UserGroups.Where(ug => !ug.IsManager)).IsLoaded)
{
_context.Entry(group).Collection(g => g.UserGroups.Where(ug => !ug.IsManager)).Load();
}
employeeIDs.ToList().ForEach(id =>
{
UserGroupModel groupEmployee = group.UserGroups.FirstOrDefault(ug => ug.UserId == id);
group.UserGroups.Remove(groupEmployee);
});
group.UpdateDate = _updateDate;
_groupRepository.Update(group);
}
catch (Exception ex)
{
_exceptions.Add(ex);
}
finally
{
if (_exceptions.Count != 0)
{
throw new TimeTrakerResult(_exceptions);
}
}
}
public static void Add(UserGroupModel model)
{
string sql = "INSERT INTO odnshop_usergroup(groupid,groupname,picurl,grouplevel,isdefalut,upgradejf,discount) VALUES(?groupid,?groupname,?picurl,?grouplevel,?isdefalut,?upgradejf,?discount)";
MySqlParameter[] parameters =
{
new MySqlParameter("?groupid", MySqlDbType.Int32, 11),
new MySqlParameter("?groupname", MySqlDbType.VarChar, 50),
new MySqlParameter("?picurl", MySqlDbType.VarChar, 50),
new MySqlParameter("?grouplevel", MySqlDbType.Int32, 11),
new MySqlParameter("?isdefalut", MySqlDbType.Int32),
new MySqlParameter("?upgradejf", MySqlDbType.Int32, 11),
new MySqlParameter("?discount", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.groupid;
parameters[1].Value = model.groupname;
parameters[2].Value = model.picurl;
parameters[3].Value = model.grouplevel;
parameters[4].Value = model.isdefalut?1:0;
parameters[5].Value = model.upgradejf;
parameters[5].Value = model.discount;
MySqlDbHelper.ExecuteSql(sql, parameters);
}
public UserGroupModel GetUserList(Int64 userGroupID)
{
UserGroupModel model = new UserGroupModel();
var userList = _user.GetAll().Select(x => new UserGroupModel
{
UserID = x.Id,
Name = x.Name,
UserTypeName = x.UserType.Name,
IsSelected = false
}).ToList();
var userIds = userList.Select(x => x.UserID).ToList();
var userMapping = _userGroupMap.GetWithInclude(x => userIds.Contains(x.UserID.Value) && x.UserGroupID == userGroupID && x.IsActive == true).ToList();
if (userMapping.Count == 0)
{
model.UserList = userList;
return(model);
}
userList.ForEach(x =>
{
x.IsSelected = userMapping.Any(z => z.UserID == x.UserID);
});
model.UserList = userList;
return(model);
}
private void LoadAuthorisationPermissions(UserGroupModel groupModel)
{
groupModel.PermissionGroups = new ObservableCollection <PermissionGroupModel>();
var groupPermissions = groupModel.UserGroup.UserGroupPermissions.Select(x => x.Permission);
foreach (var permissionGroup in PermissionGroups)
{
var premissionGroupModel = new PermissionGroupModel(permissionGroup);
premissionGroupModel.Permissions = new ObservableCollection <PermissionModel>();
foreach (Permission permission in permissionGroup.Permissions)
{
var permissionModel = new PermissionModel(permission)
{
IsChecked = groupPermissions.Contains(permission)
};
permissionModel.PropertyChanged += PermissionModelOnPropertyChanged;
permissionModel.Permission.PropertyChanged += OnPropertyChanged;
premissionGroupModel.Permissions.Add(permissionModel);
}
premissionGroupModel.IsChecked = premissionGroupModel.Permissions.Any() && premissionGroupModel.Permissions.All((x) => x.IsChecked);
premissionGroupModel.PropertyChanged += PremissionGroupModelOnPropertyChanged;
premissionGroupModel.PermissionGroup.PropertyChanged += PremissionGroupOnPropertyChanged;
groupModel.PermissionGroups.Add(premissionGroupModel);
groupModel.PropertyChanged += OnPropertyChanged;
groupModel.UserGroup.PropertyChanged += OnPropertyChanged;
}
}
//add or edit
protected void Button3_Click(object sender, EventArgs e)
{
id = BasePage.GetRequestId(Request.QueryString["id"]);
UserGroupModel model = new UserGroupModel();
model.GroupName = txtGroupName.Text;
model.ShowOnReg = int.Parse(txtShowOnReg.SelectedValue);
model.Descript = txtDescript.Text;
model.PowerList = GetChecked(this.PowerList, ",");
model.id = id;
if (id == 0)
{
int i = new UserGroupBll().Add(model);
if (i > 0)
{
BasePage.JscriptPrint(Page, "添加成功！", "UserGroup.aspx");
}
}
else
{
bool bb = new UserGroupBll().Update(model);
if (bb)
{
BasePage.JscriptPrint(Page, "修改成功！", "UserGroup.aspx");
}
}
}
public ActionResult AddUsersToGroup(string usersId)
{
var ids = usersId.Split(',');
List <Guid> usersIds = new List <Guid>();
foreach (var id in ids)
{
try
{
usersIds.Add(Guid.Parse(id));
}
catch (Exception)
{
}
}
var groupList =
this.storage.GetGroups().Select(
g => new SelectListItem {
Text = g.Name, Value = g.Id.ToString(), Selected = false
});
var userGroup = new UserGroupModel {
GroupList = groupList
};
return(this.View(userGroup));
}
public int Insert_UserGroup(UserGroupModel data)
{
int resp = -1;
try
{
using (MSSql mssql = new MSSql(DBConnectionType.RBAC, _EnvironmentModel))
{
string query = string.Format(@"INSERT INTO SYS_USER_GROUP
(code, name_thai, name_eng, group_level, theme_code, create_date)
VALUES ('{0}','{1}','{2}','{3}','{4}','{5}')",
data.code, data.name_thai, data.name_eng, data.group_level, data.theme_code, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
int rest = mssql.ExcuteNonQueryStr(query);
if (rest >= 0)
{
resp = 0;
}
}
}
catch (Exception ex)
{
_ILogs.LogError("Insert UserGroup Repository: ", ex.Message.ToString(), ex.StackTrace);
}
return(resp);
}
public ActionResult AddToGroup(Guid id, int?groupRef)
{
var user = _Storage.GetUser(u => u.Id == id);
if (groupRef == null)
{
var groupList =
_Storage.GetGroupsAvailableToUser(user).Select(
g => new SelectListItem {
Text = g.Name, Value = g.Id.ToString(), Selected = false
});
var userGroup = new UserGroupModel {
GroupList = groupList
};
ModelState.AddModelError("GroupRef", "Please select group from list");
return(View(userGroup));
}
var group = _Storage.GetGroup(groupRef.Value);
_Storage.AddUserToGroup(group, user);
return(RedirectToAction("Details", new { Id = id }));
}
public AdminPermissionGroupsViewModel()
{
CreateNewOrEditExistingGroupCommand = new CreateNewOrEditExistingGroupCommand(this);
CancelAndClearGroupActionCommand = new CancelAndClearGroupActionCommand(this);
RemoveGroupCommand = new RemoveGroupCommand(this);
UpdateAvaliableGroupsCommand = new UpdateAvaliableGroupsCommand(this);
LoadGroupForEditionCommand = new LoadGroupForEditionCommand(this);
DisplayedGroup = new UserGroupModel();
Groups = new ObservableCollection <UserGroupModel>();
if (DesignerProperties.GetIsInDesignMode(new DependencyObject()))
{
#region Design Placeholders
CommandsStr = "sm_ban\nsm_kick\nsm_mute";
EditMode = true;
Groups.AddRange(new List <UserGroupModel>
{
new UserGroupModel
{
CreatedDate = DateTime.Now,
GroupCode = "Admin 2",
GroupName = "Moderator",
PermissionRank = 9
},
new UserGroupModel
{
CreatedDate = DateTime.Now,
GroupCode = "Admin 3",
GroupName = "Helper",
PermissionRank = 7
},
new UserGroupModel
{
CreatedDate = DateTime.Now,
GroupCode = "Admin 5",
GroupName = "Rookie",
PermissionRank = 5
}
});
DisplayedGroup.CreatedDate = DateTime.Now;
DisplayedGroup.GroupCode = "admin";
DisplayedGroup.GroupName = "Administrator 1";
DisplayedGroup.PermissionRank = 10;
DisplayedGroup.AvaliableCommands = new List <string>
{
"sm_ban",
"sm_kick",
"sm_mute"
};
#endregion
}
else
{
UpdateAvaliableGroups();
}
}
public Guid SaveUserGroup(UserGroupModel data, SaveMode saveMode)
{
var userGroup = userGroupRepository.GetAll().Where(t => t.Id == data.Id).FirstOrDefault();
if (saveMode == SaveMode.CreateNew)
{
if (userGroup != null)
{
throw new DataValidationException(MessageResource.Error_InsertDuplicateKey);
}
userGroup = new UserGroup();
userGroup.Id = Guid.NewGuid();
}
else
{
if (userGroup == null)
{
throw new DataValidationException(string.Format(MessageResource.Error_DataNotFoundForUpdate, "User group"));
}
}
var isDup = userGroupRepository.GetAll().Where(t => t.Id != userGroup.Id && t.Code == data.Code).Any();
if (isDup)
{
throw new DataValidationException(string.Format(MessageResource.Error_UpdateDuplicateUniqeField, "code"));
}
userGroup.Code = data.Code;
userGroup.Name = data.Name;
userGroup.Description = data.Description;
userGroup.IsActive = data.IsActive;
unitOfWork.SaveChanges();
return(userGroup.Id);
}
public int CreateUserGroup(UserGroupModel UGM)
{
try
{
using (var context = new MCQ_Quiz_DBEntities())
{
tblUserGroup TUG = new tblUserGroup();
TUG.UserId = UGM.UserId;
TUG.QuizId = UGM.QuizId;
TUG.RoleId = UGM.RoleId;
TUG.CreatedON = UGM.CreatedON;
TUG.UpdatedON = UGM.UpdatedON;
context.tblUserGroups.Add(TUG);
context.SaveChanges();
return(TUG.UserGrpId);
}
}
catch (Exception)
{
return(0);
}
}
public ResponseUserGroup Insert_UserGroup(UserGroupModel data)
{
ResponseUserGroup resp = new ResponseUserGroup();
try
{
var _validate = Validate_MasterUserGroup(data);
if (_validate != null)
{
resp = _validate;
}
else
{
var rest = _IUserGroupRepository.Insert_UserGroup(data);
resp.status = rest >= 0 ? StatusResponse.Success : StatusResponse.Error;
resp.message = rest >= 0 ? "Insert Successfull." : "Insert Fail.";
}
return(resp);
}
catch (Exception ex)
{
_ILogs.LogError("User Group Service: ", ex.Message.ToString(), ex.StackTrace);
}
return(null);
}
public UserGroupRelationWindow(UserGroupModel entity, OperationAction operationAction, IUserOperationDAL userOperationDAL)
: this(userOperationDAL)
{
UserAction = operationAction;
InitData(entity);
InitControl();
}
public ActionResult GetUserGroupsView()
{
UserGroupModel model = new UserGroupModel();
UserGroupServiceClient client = null;
try
{
var UsergroupId = Request.QueryString["usergroupid"];
client = new UserGroupServiceClient();
UserGroupDto ugdto = client.GetById(UsergroupId != null ? Convert.ToInt32(UsergroupId) : 0);
client.Close();
model.UserGroupId = ugdto.UserGroupId;
model.UserGroupName = ugdto.UserGroupName;
model.Description = ugdto.Description;
model.IsActive = ugdto.IsActive;
model.AllowEdit = ugdto.AllowEdit;
}
catch (Exception ex)
{
return(RedirectToAction("Error"));
}
finally
{
if (client != null && client.State == System.ServiceModel.CommunicationState.Opened)
{
client.Close();
}
}
return(View("UserGroupsView", model));
}
public UserGroup_Mapping(UserGroupModel item)
{
Id = item.Id;
UserGroupID = item.UserGroupID;
UserID = item.UserID;
IsActive = item.IsActive;
CreatedOn = item.CreatedOn;
}
private void btnSaveNew_Click(object sender, EventArgs e)
{
if (saveData())
{
UserGroup = new UserGroupModel();
loadData();
}
}
public static void ToEntity(ref Models.UserGroup entity, UserGroupModel source)
{
if (source != null)
{
var objectHelper = new ObjectHelper();
objectHelper.CopyValue(source, entity, IgnoreList);
}
}
public async Task <UserGroupModel> UpdateAsync(UserGroupModel entity)
{
var _local = await _db.UpdateAsync(Mapper.Map <UserGroup>(entity));
return(new UserGroupModel {
UserGroupId = entity.UserGroupId
});
}
public UserGroupModel Update(UserGroupModel entity)
{
var _local = _db.Update(Mapper.Map <UserGroup>(entity));
return(new UserGroupModel {
UserGroupId = entity.UserGroupId
});
}
public ActionResult Edit(UserGroupModel userGroup)
{
if (ModelState.IsValid)
{
userGroup.Save(_factory.CreateUserGroupDao());
return(RedirectToAction("Index"));
}
return(View(userGroup));
}
public static int InsertUserGroups(out long insertId, UserGroupModel userGroup)
{
var changedCount = Insert(out insertId, UserGroupTable.TableName, new ParamtersMap
{
[UserGroupTable.UserId] = userGroup.UserId,
[UserGroupTable.GroupId] = userGroup.GroupId
});
return(changedCount);
}
public UserGroup(UserGroupModel item)
{
Id = item.Id;
Name = item.Name;
IsActive = item.IsActive;
CreatedOn = item.CreatedOn;
CreatedBy = item.CreatedBy;
UpdatedOn = item.UpdatedOn;
UpdatedBy = item.UpdatedBy;
}
public async Task <FuncResult> Add([FromBody] UserGroupModel model)
{
if (!ModelState.IsValid)
{
return(new FuncResult()
{
IsSuccess = false, Message = "参数错误"
});
}
return(await userGroupService.Add(model, CurrentUser.Get().Id));
}
public static void ManageUserGroup(UserGroupModel model)
{
if (model.UserGroupID == -1 || model.UserGroupID == 0)
{
AddUserGroup(model);
}
else
{
EditUserGroup(model);
}
}
public async Task SetSubscribeDate()
{
UserWithGroupsModel userGroups = await ChannelSession.Connection.GetUserInChannel(ChannelSession.Channel, this.ID);
if (userGroups != null && userGroups.groups != null)
{
UserGroupModel subscriberGroup = userGroups.groups.FirstOrDefault(g => g.name.Equals("Subscriber") && g.deletedAt == null);
if (subscriberGroup != null)
{
this.SubscribeDate = subscriberGroup.createdAt;
}
}
}
/// <summary>
/// View information of usergroup
/// </summary>
/// <param name="id">usergroup's id</param>
/// <returns></returns>
public ActionResult ViewDetail(int id = 0)
{
//variables
crm_Roles roleItem;
UserGroupModel model = new UserGroupModel();
crm_Tenants tenant;
try
{
//Check invalid id
if (id == 0)
{
return(View("Index"));
}
//Get role detail
roleItem = _roleService.GetRoleByID(id);
//Check null data
if (roleItem == null)
{
return(View("Index"));
}
//Set permission type name
foreach (UserGroupEnum usergroup in Enum.GetValues(typeof(UserGroupEnum)))
{
if (roleItem.PermissionType.HasValue)
{
if (roleItem.PermissionType.Value == Convert.ToInt32(usergroup))
{
model.PermissionTypeName = usergroup.ToString();
break;
}
}
}
tenant = _tenantService.Find(roleItem.TenantId);
//set value for model
model.ID = roleItem.ID;
model.Name = roleItem.RoleName;
model.Active = roleItem.Active.HasValue ? roleItem.Active.Value : false;
model.Description = roleItem.Description;
model.TenantName = tenant == null ? "" : tenant.TenantName;
return(View(model));
}
catch
{
return(View("Index"));
}
}
public JsonResult Manage(UserGroupModel model, GridManagingModel manageModel)
{
if (ModelState.IsValid || manageModel.Operation == GridOperationEnums.Del)
{
return(Json(_userGroupServices.ManageUserGroup(manageModel.Operation, model)));
}
return(Json(new ResponseModel
{
Success = false,
Message = GetFirstValidationResults(ModelState).Message
}));
}
public ActionResult Create(int?id)
{
UserGroupModel model = new UserGroupModel();
if (id != null)
{
var Varial = _userGroupBs.GetById(Convert.ToInt32(id));
return(View(Varial));
}
return(View(model));
}
private void InitData(UserGroupModel entity)
{
TxtGroupName.Text = entity.GroupName;
TxtGroupDisplayName.Text = entity.GroupDisplayName;
ClearItems();
ExistRoleInfoList = UserOperationDAL.QueryAllUserRoleByUserGroupId(entity.Id);
ExistUserInfoList = UserOperationDAL.QueryAllUserInfoByUserGroupId(entity.Id);
LvGroupRole.ItemsSource = ExistRoleInfoList.DeepCopy();
LvUserName.ItemsSource = ExistUserInfoList.DeepCopy();
Id = entity.Id;
CreateDateTime = entity.CreateDateTime;
IsDelete = entity.IsDelete;
}
public async Task <HttpResponseMessage> Delete(UserGroupModel data)
{
try
{
await _local.DeleteAsync(data);
}
catch (Exception ex)
{
Common.MyLogger.Error(ex.Message + ex.StackTrace + ex.InnerException.ToString());
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Update Error"));
}
return(Request.CreateResponse(HttpStatusCode.OK, "Data Updated"));
}
protected override void Because_of()
{
var categoryModel = new CategoryModel();
categoryModel.Category = categoryModel;
var userModel = new UserModel();
var userGroupModel = new UserGroupModel();
userModel.Category = categoryModel;
userModel.Group = userGroupModel;
userGroupModel.Users.Add(userModel);
_destination = Mapper.Map<UserDto>(userModel);
}
