public UserOperatorResult Create(User user, List <Guid> workTypeList) { if (user == null) { return(UserOperatorResult.Failed); } List <CommandParameter> list = new List <CommandParameter>(); list.Add(new CommandParameter("@account", user.Account)); if (int.Parse(this._dataBase.ExecuteScalar("SELECT COUNT(Id) FROM [User] WHERE [Account] = @account AND [Removed] = 0", list).ToString()) > 0) { return(UserOperatorResult.AccountExistent); } user.Password = IOHelper.GetMD5HashFromString("123"); this._dataBase.Insert(user); list = new List <CommandParameter>(); list.Add(new CommandParameter("@user", user.Id)); this._dataBase.ExecuteNonQuery("DELETE [UserWorkType] WHERE [User] = @user", list); if (workTypeList != null && workTypeList.Count > 0) { foreach (Guid current in workTypeList) { UserWorkType userWorkType = new UserWorkType(); userWorkType.Domain = user.DomainId; userWorkType.User = user.Id; userWorkType.WorkType = current; this._dataBase.Insert(userWorkType); } } return(UserOperatorResult.Success); }
public async Task <IActionResult> Edit(int id, [Bind("UserWorkTypeId,UserWorkTypeName")] UserWorkType userWorkType) { if (id != userWorkType.UserWorkTypeId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(userWorkType); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!UserWorkTypeExists(userWorkType.UserWorkTypeId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(userWorkType)); }
public UserRegisterResult Register(UserRegisterArgs args) { UserRegisterResult userRegisterResult = new UserRegisterResult(); if (args == null) { userRegisterResult.Result = UserRegisterResultEnum.UserInfoInvalid; return(userRegisterResult); } object lockObj = this._lockObj; lock (lockObj) { List <CommandParameter> list = new List <CommandParameter>(); list.Add(new CommandParameter("@account", args.Account)); if (int.Parse(this._dataBase.ExecuteScalar("SELECT Count(Id) FROM [User] WHERE [Account] = @account", list).ToString()) > 0) { userRegisterResult.Result = UserRegisterResultEnum.AccountInUse; return(userRegisterResult); } Domain domain = new Domain(); UserManager._domainManager.Create(domain); Organization organization = new Organization { Id = domain.Id, Domain = domain.Id, Name = args.DomainName }; UserManager._domainManager.CreateOrganization(organization); User user = new User { Account = args.Account, Password = args.Password, Name = args.Name, Telphone = args.Telphone, Email = args.Email, DomainId = domain.Id, OrganizationId = organization.Id, Notify = true }; this._dataBase.Insert(user); Dictionary <string, object> dictionary = new Dictionary <string, object> { { "Domain", domain.Id } }; WorkType workType = this._dataBase.Select <WorkType>(dictionary)[0]; UserWorkType userWorkType = new UserWorkType { Domain = domain.Id, User = user.Id, WorkType = workType.Id }; this._dataBase.Insert(userWorkType); userRegisterResult.User = user; userRegisterResult.Domain = domain; } userRegisterResult.Result = UserRegisterResultEnum.Success; return(userRegisterResult); }
public async Task <IActionResult> Create([Bind("UserWorkTypeId,UserWorkTypeName")] UserWorkType userWorkType) { if (ModelState.IsValid) { _context.Add(userWorkType); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(userWorkType)); }
public async Task <UserWorkType> SaveWorkType(UserWorkType obj) { return(await WithConnection(async c => { string sql = $@" INSERT INTO `user_work_type`( user_id, work_type_id ) VALUES ( @UserId, @WorkTypeId ); "; sql += "SELECT LAST_INSERT_ID() "; int newid = await c.QueryFirstOrDefaultAsync <int>(sql, obj); obj.Id = newid; return obj; })); }
public UserOperatorResult Update(User user, List <Guid> workTypeList) { if (user == null) { return(UserOperatorResult.Failed); } List <CommandParameter> list = new List <CommandParameter>(); list.Add(new CommandParameter("@id", user.Id)); list.Add(new CommandParameter("@account", user.Account)); if (int.Parse(this._dataBase.ExecuteScalar("SELECT COUNT(Id) FROM [User] WHERE [Id] <> @id AND [Account] = @account AND [Removed] = 0", list).ToString()) > 0) { return(UserOperatorResult.AccountExistent); } SqlExpression sqlExpression = RelationalMappingUnity.GetSqlExpression(user, new SqlExpressionArgs { Type = SqlExpressionType.Update, ExcludeFields = "Password" }); this._dataBase.ExcuteSqlExpression(sqlExpression); list = new List <CommandParameter>(); list.Add(new CommandParameter("@user", user.Id)); this._dataBase.ExecuteNonQuery("DELETE [UserWorkType] WHERE [User] = @user", list); if (workTypeList != null && workTypeList.Count > 0) { foreach (Guid current in workTypeList) { UserWorkType userWorkType = new UserWorkType(); userWorkType.Domain = user.DomainId; userWorkType.User = user.Id; userWorkType.WorkType = current; this._dataBase.Insert(userWorkType); } } return(UserOperatorResult.Success); }