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