public List <RolesVM> GetRoles(RolesVM vm) { try { // DataPageRequestInfo info = JsonHelper.DeserializeJsonToObject<DataPageRequestInfo>(strData); StringBuilder where = new StringBuilder("where 1 = 1"); //var qm = JsonConvert.DeserializeAnonymousType(info.Conditions, new { Name = "" }); // RolesVM qm = JsonConvert.DeserializeObject<RolesVM>(info.Conditions); List <SqlParameter> parameters = new List <SqlParameter>(); if (!string.IsNullOrEmpty(vm.Name)) { SqlParameter param = new SqlParameter("@Name", string.Format("%{0}%", vm.Name)); where.Append(" and Name like @Name"); parameters.Add(param); } StringBuilder selectDataCommand = new StringBuilder(" SELECT [ID],[Name] ,[CreateTime] ,[Remark] FROM [RABC].[dbo].[Roles]"); selectDataCommand.Append(where.ToString()); return(DataTableToList.DataSetToList <RolesVM>(SqlHelper.ExecuteDataset(SqlHelper.GetConnSting(), CommandType.Text, selectDataCommand.ToString(), parameters.ToArray()))); // retJson = JsonHelper.SerializeObject(list); } catch (Exception ex) { return(null); } }
public async Task <Response> AddRole(RolesVM role) { var roleDto = Mapper.Map <RolesVM, Role>(role); Role roleExist = await _db.Roles.Where(x => x.Role1.Trim() == role.Role1.Trim()).FirstOrDefaultAsync(); if (roleExist != null) { return(GenericResponses <int> .ResponseStatus(true, Constant.MDGNoAlreadyExist, (int)Constant.httpStatus.NoContent, 0)); } _db.Roles.Add(roleDto); int result = await _db.SaveChangesAsync(); if (result == 1) { // Mapper.Initialize(cfg => cfg.CreateMap<User, UserVM>()); return(GenericResponses <int> .ResponseStatus(false, Constant.MSGRecordFound, (int)Constant.httpStatus.Ok, result)); } else { return(GenericResponses <int> .ResponseStatus(true, Constant.MDGNoLoginFailed, (int)Constant.httpStatus.NoContent, result)); } }
public async Task <Response> RemoveRole(RolesVM role) { try { var roleDto = await _db.Roles.Where(x => x.Id == role.Id).FirstOrDefaultAsync(); _db.Roles.Remove(roleDto); int result = await _db.SaveChangesAsync(); if (result == 1) { // Mapper.Initialize(cfg => cfg.CreateMap<User, UserVM>()); return(GenericResponses <int> .ResponseStatus(false, Constant.MSGRecordFound, (int)Constant.httpStatus.Ok, result)); } else { return(GenericResponses <int> .ResponseStatus(true, Constant.MSGFailed, (int)Constant.httpStatus.NoContent, result)); } } catch (Exception e) { return(GenericResponses <int> .ResponseStatus(true, e.Message, (int)Constant.httpStatus.NoContent, 0)); } }
public IHttpActionResult GetRoles() { string userId = User.Identity.GetUserId(); RolesVM vm = _unit.User.GetRoles(userId); return(Ok(vm)); }
public IActionResult OnGet() { var userlist = _context.Users.Select(u => new { Id = u.Id, Email = u.Email }).ToList(); ViewData["SelectUserId"] = new SelectList(userlist, "Id", "Email"); List <RolesVM> roleList = new List <RolesVM>(); RolesVM rolevm1 = new RolesVM { Id = 1, Name = "Admin" }; RolesVM rolevm2 = new RolesVM { Id = 2, Name = "Member" }; roleList.Add(rolevm1); roleList.Add(rolevm2); ViewData["SelectRole"] = new SelectList(roleList, "Id", "Name"); return(Page()); }
private void gvRoles_SelectionChanged(object sender, DevExpress.Data.SelectionChangedEventArgs e) { List <RolesVM> list = new List <RolesVM>(); int[] rowHandles = this.gvRoles.GetSelectedRows();//获取选中行号; for (int i = 0; i < rowHandles.Length; i++) { RolesVM pro = this.gvRoles.GetRow(rowHandles[i]) as RolesVM;//获取选中行的实体 list.Add(pro); } this.gcSelectedRoles.DataSource = null; this.gcSelectedRoles.DataSource = list; }
public RolesVM GetRoles(string id) { RolesVM vm = new RolesVM { IsAdmin = IsAdmin(id), IsManager = IsManager(id), IsVendor = IsVendor(id), IsRunner = IsRunner(id), IsSeat = IsSeat(id), IsCustomer = IsCustomer(id) }; return(vm); }
private void ribeDeleteRoles_Click(object sender, EventArgs e) { int[] rowHandles = this.gvRoles.GetSelectedRows(); //获取选中行号; RolesVM rolesVM = this.gvSelectedUsers.GetRow(this.gvSelectedUsers.FocusedRowHandle) as RolesVM; //获取选中行的实体 for (int i = 0; i < rowHandles.Length; i++) { RolesVM source = this.gvRoles.GetRow(rowHandles[i]) as RolesVM;//获取选中行的实体 if (rolesVM.ID == source.ID) { this.gvRoles.UnselectRow(rowHandles[i]); break; } } }
private void sbtDelete_Click(object sender, EventArgs e) { //List<int> selectedIDList = new List<int>(); int[] rowHandles = this.gvRoles.GetSelectedRows();//获取选中行号; if (rowHandles.Length == 0) { XtraMessageBox.Show("please select deleted rows!", "提示", MessageBoxButtons.OK); return; } if (DialogResult.OK == XtraMessageBox.Show("deleting these rows ?", "waring", MessageBoxButtons.OKCancel)) { List <RolesVM> selectedList = new List <RolesVM>(); foreach (var rowHandle in rowHandles) { ////获取选中行的ID //selectedIDList.Add(int.Parse(this.gvRoles.GetRowCellValue(rowHandle, "ID").ToString())); RolesVM vm = this.gvRoles.GetRow(rowHandle) as RolesVM; if (vm.Name.ToLower() == "admin") { XtraMessageBox.Show("can not delete role admin!", "提示", MessageBoxButtons.OK); return; } selectedList.Add(vm); } int res = _bll.DeleteRoles(selectedList.Select(p => p.ID).ToList()); if (res > 0) { XtraMessageBox.Show("保存成功!", "提示", MessageBoxButtons.OK); this.teRoleName.Text = string.Empty; RequestGridData(); } else { XtraMessageBox.Show("保存失败!", "提示", MessageBoxButtons.OK); } } }
/// <summary> /// 新增角色 /// </summary> /// <param name="UserVM"></param> /// <returns></returns> public int AddRoles(RolesVM role) { StringBuilder sb = new StringBuilder(); try { SqlParameter paramName = new SqlParameter("@Name", role.Name); string exitSql = @" SELECT count(ID) FROM [dbo].[Roles] where Name=@Name "; var count = (int)SqlHelper.ExecuteScalar(SqlHelper.GetConnSting(), CommandType.Text, exitSql, new SqlParameter[] { paramName }); if (count > 0) { return(-1); } string sql = @"INSERT INTO [dbo].[Roles] ([Name] ) VALUES (@Name) "; return(SqlHelper.ExecuteNonQuery(SqlHelper.GetConnSting(), CommandType.Text, sql, new SqlParameter[] { paramName })); } catch (Exception ex) { return(-1); } }
public NewRoleModal(RolesVM vm) { InitializeComponent(); DataContext = vm; }
/// <summary> /// 新增角色 /// </summary> /// <param name="UserVM"></param> /// <returns></returns> public int AddRoles(RolesVM vm) { return(_dal.AddRoles(vm)); }
public List <RolesVM> GetRoles(RolesVM vm) { return(_dal.GetRoles(vm)); }
public NuevoRoleCommand(RolesVM vm) { VM = vm; }
public EditRoleCommand(RolesVM vm) { VM = vm; }
public ActionResult DeleteRole(RolesVM role) { RolesDAL.DeleteRole(Mapper.Map <RolesDM>(role)); return(View()); }