public async Task <TResponse <bool> > CanInsert(InsertUserReq user) { try { var users = await _readOnlyRepository.QueryAsync <User>(SqlQuery.USER_FIND_BY_NAME, new { user.Username }); if (users != null) { if (users.IsSuccess) { if (users.Data.Any()) { return(await Fail <bool>(ErrorEnum.UserNameHasExist.GetStringValue())); } return(await Ok(true)); } return(await Fail <bool>(users.Message)); } return(await Ok(true)); } catch (Exception exception) { return(await Fail <bool>(exception)); } }
public void OnInsertUserReq(InsertUserReq packet) { var user = packet.User; var creatorId = packet.CreatorId; Sql.Instance.InsertUser(user, creatorId); }
public async Task <TResponse <bool> > Add(int userId, InsertUserReq user) { try { var canInsert = await CanInsert(user); if (canInsert.IsSuccess) { var result = await _writeRepository.ExecuteAsync(SqlQuery.USER_INSERT, new { user.Username, user.Email, user.Name, user.Phone, Password = Sha512(user.Password), UserCreated = userId, DateCreated = DateTime.Now, UserUpdated = userId, DateUpdated = DateTime.Now }); if (result != null) { if (result.IsSuccess) { if (result.Data == 0) { return(await Fail <bool>($"Insert USER {user.Username} is failure")); } return(await Ok(true)); } return(await Fail <bool>(result.Message)); } return(await Fail <bool>($"Insert USER {user.Username} is failure")); } return(await Fail <bool>(canInsert.Message)); } catch (Exception exception) { return(await Fail <bool>(exception)); } }
public async Task <ActionResult <int> > Add(InsertUserReq req) { return(Ok(await _userService.Add(UserId, req))); }