public List <RolesEntity> GetAllRoles() { string strSql = @"SELECT * FROM [Roles] WHERE [Status]=0 OR [Status]=1 ORDER BY [RoleID] DESC"; List <RolesEntity> list = new List <RolesEntity>(); Database db = DatabaseFactory.CreateDatabase(); using (DbCommand dbCommand = db.GetSqlStringCommand(strSql)) { try { using (IDataReader dataReader = db.ExecuteReader(dbCommand)) while (dataReader.Read()) { list.Add(RolesEntity.ReaderBind(dataReader)); } } catch (Exception ex) { WebLogAgent.Write(string.Format("[SQLText:{0},{1}Messages:\r\n{2}]" , strSql.ToString(), base.FormatParameters(dbCommand.Parameters), ex.Message)); return(null); } } return(list); }
public async Task <RoleViewModel> Post(JObject json) { _invillaContext = new InvillaContext(); try { var model = JsonConvert.DeserializeObject <RoleViewModel>(json.ToString()); model.RegistrationDate = DateTime.Now; var role = new RolesEntity { Role = model.Role, RegistrationDate = model.RegistrationDate }; _invillaContext.Add(role); _invillaContext.SaveChanges(); return(model); } catch (Exception ex) { return(new RoleViewModel { }); } }
public JObject AddRolesInfo([FromBody] RolesEntity _userRoleEntity) { DataResult result = new DataResult() { Verifiaction = false }; try { if (_rolesRepsonsityService.IsExists(x => x.RolesName == _userRoleEntity.RolesName)) { result.Message = "角色名称已经存在!"; return(JObject.FromObject(result)); } RolesEntity userRoleEntity = new RolesEntity { ID = Guid.NewGuid().ToString(), RolesName = _userRoleEntity.RolesName, CreateDate = DateTime.Now.ToString(), Remark = _userRoleEntity.Remark }; _rolesRepsonsityService.Insert(userRoleEntity); result.Verifiaction = true; result.Message = "写入成功!"; } finally { } return(JObject.FromObject(result)); }
/// <summary> /// Get an object entity /// </summary> public RolesEntity Get(int RoleID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select RoleID,RoleName,Description,Status,CreatedOn,CreatedBy from Roles "); strSql.Append(" where RoleID=@RoleID "); Database db = DatabaseFactory.CreateDatabase(); using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString())) { try { db.AddInParameter(dbCommand, "RoleID", DbType.Int32, RoleID); RolesEntity model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = RolesEntity.ReaderBind(dataReader); } } return(model); } catch (Exception ex) { WebLogAgent.Write(string.Format("[SQLText:{0},{1}Messages:\r\n{2}]" , strSql.ToString(), base.FormatParameters(dbCommand.Parameters), ex.Message)); return(null); } } }
/// <summary> /// 增加一条记录,返回新的ID号。需要有一个单一主键,并且开启有标识符属性(异步方式) /// </summary> /// <param name="entity">实体模型</param> /// <returns></returns> public virtual async Task <int> InsertAsync(RolesEntity entity) { if (entity.RoleID <= 0) { entity.RoleID = GetNewID(); } Dictionary <string, object> dict = new Dictionary <string, object>(); GetParameters(entity, dict); string strSQL = "insert into Roles (" + "RoleID," + "RoleName," + "Description) " + "values(" + "@RoleID," + "@RoleName," + "@Description)"; if (await Task.Run(() => _DB.ExeSQLResult(strSQL, dict))) { return(DataConverter.CLng(entity.RoleID)); } return(-1); }
public bool AssignRoleToUser(ApplicationEntity application, UserEntity user, RolesEntity role) { try { using (IUnitOfWork uow = _UnitFactory.GetUnit(this)) { uow.BeginTransaction(); if (!uow.Query <AppUserRoleEntity>().Any(x => x.ApplicationId.Equals(application.IdApplication) && x.RoleId.Equals(role.Id) && x.UserId.Equals(user.Id))) { AppUserRoleEntity app = new AppUserRoleEntity(); app.ApplicationId = app.ApplicationId; app.RoleId = role.Id; app.UserId = user.Id; uow.SaveOrUpdate(app); uow.Commit(); return(true); } } } catch (Exception err) { //TODO:Add log here return(false); } return(true); }
public static void EnsureSampleData() { List <UserEntity> userList = RepositoryContext.Current.Users.GetAll(); if (userList == null || userList.Count == 0) { ApplicationEntity app = new ApplicationEntity(); app.ApplicationName = "SampleApp"; app.IsActive = true; app.StartDate = DateTime.Now; app.EndDate = DateTime.Now.AddYears(1); app.PublicKey = new Guid("{8C075ED0-45A7-495A-8E09-3A98FD6E8248}"); RepositoryContext.Current.Applications.Save(app); // Insert admin user UserEntity user = new UserEntity(); user.CreationDate = DateTime.Now; user.Email = "*****@*****.**"; user.IsAdmin = true; user.IsApproved = true; user.IsLockedOut = false; user.Password = UserHelper.EncodePassword("12345678"); user.Username = "******"; RepositoryContext.Current.Users.Save(user); RolesEntity role = RepositoryContext.Current.Roles.GetRoleByName(Constants.Roles.Admin); RepositoryContext.Current.Applications.AssignRoleToUser(app, user, role); } }
public int AddRole(RolesEntity role) { this.ClearBrokenRuleMessages(); int id = mgr.AddRole(role); this.AddBrokenRuleMessages(mgr.BrokenRuleMessages); return(id); }
public bool UpdateRole(RolesEntity role) { this.ClearBrokenRuleMessages(); bool updated = mgr.UpdateRole(role); this.AddBrokenRuleMessages(mgr.BrokenRuleMessages); return(updated); }
public RolesEntity GetRole(int roleID) { this.ClearBrokenRuleMessages(); RolesEntity role = mgr.GetRole(roleID); this.AddBrokenRuleMessages(mgr.BrokenRuleMessages); return(role); }
/// <summary> /// 通过数据读取器生成实体类 /// </summary> /// <param name="rdr"></param> /// <returns></returns> private static RolesEntity GetEntityFromrdr(NullableDataReader rdr) { RolesEntity info = new RolesEntity(); info.RoleID = rdr.GetInt32("RoleID"); info.RoleName = rdr.GetString("RoleName"); info.Description = rdr.GetString("Description"); return(info); }
private RolesEntity GetEntity() { RolesEntity model = userApp.GetRole(QS("id", 0)); model.RoleName = txtRoleName.Text.NoHTML(); model.Description = txtDesc.Text.NoHTML(); model.Status = int.Parse(ddlStatus.SelectedValue); return(model); }
private RolesEntity GetEntity() { RolesEntity model = UsersFactory.CreateRolesEntity(UserInfo.UserID, ObjectFactory.GetInstance <ISystemDateTime>()); model.RoleName = txtRoleName.Text.NoHTML(); model.Description = txtDesc.Text.NoHTML(); model.Status = int.Parse(ddlStatus.SelectedValue); return(model); }
public RoleDTO GetDTO(RolesEntity entity) { RoleDTO role = new RoleDTO() { Id = entity.Id, Name = entity.Name, CreateDateTime = entity.CreateDateTime }; return(role); }
protected void Page_Load(object sender, EventArgs e) { userApp = new UserApplication(); if (!IsPostBack) { RolesEntity entity = userApp.GetRole(QS("id", 0)); txtRoleName.Text = entity.RoleName; txtDesc.Text = entity.Description; ddlStatus.SelectedValue = entity.Status.ToString(); } }
public static void InsertRoleIfNotExists(string Rolename) { RolesEntity role = RepositoryContext.Current.Roles.GetRoleByName(Rolename); if (role == null) { RepositoryContext.Current.Roles.Save(new RolesEntity() { RoleName = Rolename }); } }
protected void btnSave_Click(object sender, EventArgs e) { RolesEntity model = GetEntity(); if (userApp.UpdateRole(model)) { Redirect(EmptyPopPageUrl, false, true); } else { this.ShowFailMessageToClient(userApp.BrokenRuleMessages); } }
/// <summary> /// 得到 roles 数据实体 /// </summary> /// <param name="dr">dr</param> /// <returns>roles 数据实体</returns> public RolesEntity Populate_RolesEntity_FromDr(IDataReader dr) { RolesEntity Obj = new RolesEntity(); Obj.RoleId = ((dr["RoleId"]) == DBNull.Value)?0:Convert.ToInt32(dr["RoleId"]); Obj.ShopId = ((dr["ShopId"]) == DBNull.Value)?0:Convert.ToInt32(dr["ShopId"]); Obj.Name = dr["Name"].ToString(); Obj.Permission = ((dr["Permission"]) == DBNull.Value)?0:Convert.ToInt32(dr["Permission"]); Obj.price = ((dr["price"]) == DBNull.Value)?0:Convert.ToDecimal(dr["price"]); Obj.Description = dr["Description"].ToString(); return(Obj); }
public string GetModel(string id) { try { RolesEntity rolesEntity = new RolesEntity(); rolesEntity = _rolesRepsonsityService.GetById(id); return(JsonConvert.SerializeObject(rolesEntity)); } catch (Exception ex) { } return("成功"); }
/// <summary> /// 更新一条记录 /// </summary> /// <param name="entity">实体模型</param> /// <returns></returns> public virtual bool Update(RolesEntity entity) { Dictionary <string, object> dict = new Dictionary <string, object>(); GetParameters(entity, dict); string strSQL = "Update Roles SET " + "RoleName = @RoleName," + "Description = @Description" + " WHERE " + "RoleID = @RoleID"; return(_DB.ExeSQLResult(strSQL, dict)); }
/// <summary> /// 更新一条记录(异步方式) /// </summary> /// <param name="entity">实体模型</param> /// <returns></returns> public virtual async Task <bool> UpdateAsync(RolesEntity entity) { Dictionary <string, object> dict = new Dictionary <string, object>(); GetParameters(entity, dict); string strSQL = "Update Roles SET " + "RoleName = @RoleName," + "Description = @Description" + " WHERE " + "RoleID = @RoleID"; return(await Task.Run(() => _DB.ExeSQLResult(strSQL, dict))); }
/// <summary> /// 获取实体 /// </summary> /// <param name="strWhere">参数化查询条件(例如: and Name = @Name )</param> /// <param name="dict">参数的名/值集合</param> /// <returns></returns> public virtual RolesEntity GetEntity(string strWhere, Dictionary <string, object> dict = null) { RolesEntity obj = null; string strSQL = "select top 1 * from Roles where 1=1 " + strWhere; using (NullableDataReader reader = _DB.GetDataReader(strSQL, dict)) { if (reader.Read()) { obj = GetEntityFromrdr(reader); } } return(obj); }
/// <summary> /// 获取实体(异步方式) /// </summary> /// <param name="strWhere">参数化查询条件(例如: and Name = @Name )</param> /// <param name="dict">参数的名/值集合</param> /// <returns></returns> public virtual async Task <RolesEntity> GetEntityAsync(string strWhere, Dictionary <string, object> dict = null) { RolesEntity obj = null; string strSQL = "select top 1 * from Roles where 1=1 " + strWhere; using (NullableDataReader reader = await Task.Run(() => _DB.GetDataReader(strSQL, dict))) { if (reader.Read()) { obj = GetEntityFromrdr(reader); } } return(obj); }
public string RolesTest1(string id) { try { RolesEntity rolesEntity = new RolesEntity(); _rolesRepsonsityService.Delete(id); _rolesRepsonsityService.SaveChange(); } catch (Exception ex) { } return("成功"); }
/// <summary> /// 账户修改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnEdit_Click(object sender, RoutedEventArgs e) { Button btn = sender as Button; RolesEntity role = btn.Tag as RolesEntity; RoleAddDialog view = new RoleAddDialog(role); bool? nullable = view.ShowDialog(); bool flag = true; if ((nullable.GetValueOrDefault() == flag ? (nullable.HasValue ? 1 : 0) : 0) == 0) { return; } RefreshData(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int id = QS("id", 0); if (id == 0) { this.ShowArgumentErrorMessageToClient(); return; } RolesEntity role = userApp.GetRole(id); InitControl(id); } }
protected void btnSave_Click(object sender, EventArgs e) { RolesEntity model = GetEntity(); int id = userApp.AddRole(model); if (id > 0) { this.ShowSuccessMessageToClient(); } else { this.ShowFailMessageToClient(userApp.BrokenRuleMessages); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int id = QS("id", 0); if (id == 0) { this.ShowArgumentErrorMessageToClient(); return; } RolesEntity role = userApp.GetRole(id); ltlRole.Text = string.Format("{0}[{1}]", role.RoleName, role.Description); InitControl(id); } }
/// <summary> /// 删除账户 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDel_Click(object sender, RoutedEventArgs e) { Button btn = sender as Button; RolesEntity role = btn.Tag as RolesEntity; //if (MessageBox.Show("确认删除该角色吗?", "提示", MessageBoxButton.OKCancel) != MessageBoxResult.OK) // return; if ((new RolesDB()).Delete(role) < 1) { //MessageBox.Show("删除数据过程出现错误!", "错误", MessageBoxButton.OK, MessageBoxImage.Warning); } else { AppContext.Current.RoleData.Remove(role); } }
public string RolesTest1() { try { RolesEntity rolesEntity = new RolesEntity(); rolesEntity.ID = "76d71a4d-daa1-4b9e-885a-be789579a4e5"; rolesEntity.RolesName = "李四"; rolesEntity.CreateDate = DateTime.Now.ToString(); _rolesRepsonsityService.Update(rolesEntity); _rolesRepsonsityService.SaveChange(); } catch (Exception ex) { } return("成功"); }