public Task <int> UpdateAsync(string id, AccountInputDto inputDto) { var model = inputDto.MapTo <TAccount>(); model.Id = id; return(_repository.UpdateAsync(model)); }
public void AddStaticAccount() { var payload = new AccountInputDto { Description = "Equity Again Swap - ACX AU SWAP - GSCO - MSCO", Type = 3, Tags = new List <AccountTagInputDto>(new[] { new AccountTagInputDto { Id = 2, Value = "Equity" }, new AccountTagInputDto { Id = 4, Value = "ACX AU SWAP" } }) }; var accounts = Utils.PostWebApi("FinanceWebApi", $"{AccountsUrl}", payload); Task.WaitAll(accounts); var response = JsonConvert.DeserializeObject <Response>(accounts.Result); Assert.IsTrue(response.isSuccessful, "Account Added"); }
public async Task AddDynamicAccount() { var accountCategories = await GetList <AccountCategoryOutputDto>(AccountCategoriesUrl); var accountTypes = await GetList <AccountTypeOutputDto>( $"{AccountTypesUrl}?accountCategoryId={accountCategories.FirstOrDefault()?.Id}"); var accountTags = await GetList <AccountTagOutputDto>(AccountTagsUrl); var payload = new AccountInputDto { Description = accountTypes.FirstOrDefault()?.Name, Type = accountTypes.FirstOrDefault()?.Id, Tags = new List <AccountTagInputDto>(new[] { new AccountTagInputDto { Id = accountTags.FirstOrDefault()?.Id, Value = accountCategories.FirstOrDefault()?.Name } }) }; var accounts = Utils.PostWebApi("FinanceWebApi", $"{AccountsUrl}", payload); Task.WaitAll(accounts); var response = JsonConvert.DeserializeObject <Response>(accounts.Result); Assert.IsTrue(response.isSuccessful, "Account Added"); }
public async Task <bool> UserVilidata(AccountInputDto data) { if (string.IsNullOrEmpty(data.AccountNumber) || string.IsNullOrEmpty(data.PassWord)) { return(false); } var entity = await _accountRepository.FirstOrDefaultAsync(s => s.AccountNumber == data.AccountNumber && s.PassWord == Common.GetMD5(data.PassWord)); return(entity != null); }
public async Task <bool> SaveAccountPWD(AccountInputDto data) { var entity = await _accountRepository.FirstOrDefaultAsync(s => s.AccountNumber == data.AccountNumber); if (entity == null) { return(false); } entity.UpdateTime = DateTime.Now; entity.OldPassWord = entity.PassWord; entity.PassWord = Common.GetMD5(data.PassWord); return(await _accountRepository.CommitAsync() > 0); }
public async Task <AccountResponseDto> Post(AccountInputDto input) { //Check for validity if (!input.IsValid()) { throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.BadRequest) { ReasonPhrase = "Input data is invalid." }); } var result = await Services.User.RegisterUser(input.AccountId); return(new AccountResponseDto(result)); }
public void AddInvalidAccount() { var payload = new AccountInputDto { Description = "", Type = 0, Tags = new List <AccountTagInputDto>() }; var accounts = Utils.PostWebApi("FinanceWebApi", $"{AccountsUrl}", payload); Task.WaitAll(accounts); var response = JsonConvert.DeserializeObject <Response>(accounts.Result); Assert.IsTrue(response.isSuccessful == false, "Account not Added"); }
public async Task <IActionResult> OnGetAsync() { var account = (await _accountService.GetFilteredAsync( new AccountQueryModel { Id = Guid.Parse(RouteData.Values["id"]?.ToString()), ApplicationUserId = HttpContext.User.Claims .FirstOrDefault(x => x.Type == ClaimTypes.NameIdentifier)?.Value })).FirstOrDefault(); if (account == null) { return(NotFound()); } InputDto = _mapper.Map <AccountInputDto>(account); return(Page()); }
public async Task <AccountDto> CreateAsync(AccountInputDto inputDto) { if (await _repository.ExistsAccountAsync(inputDto.Account)) { throw new BusiException("登录帐号已存在"); } var model = inputDto.MapTo <TAccount>(); model.Id = IdentityHelper.Guid32; model.PasswordSalt = IdentityHelper.Guid16; model.Password = $"{model.Password},{model.PasswordSalt}".Md5(); model.CreateTime = Clock.Now; var result = await _repository.InsertAsync(model); if (result <= 0) { throw new BusiException("创建账户失败"); } return(model.MapTo <AccountDto>()); }
public async Task UpdateNonEditableAccount() { var accounts = await GetAccounts(); var lastAccount = accounts.Item1.FirstOrDefault(x => x.CanEdited == false); var payload = new AccountInputDto { Description = lastAccount?.Description + " Updated", Type = lastAccount?.TypeId, Tags = new List <AccountTagInputDto>() }; var account = Utils.PutWebApi("FinanceWebApi", $"{AccountsUrl}/{lastAccount?.AccountId}", payload); Task.WaitAll(account); var response = JsonConvert.DeserializeObject <Response>(account.Result); Assert.IsTrue(response.isSuccessful == false, "Account not Updated"); }
public object UpdateAccount(int id, AccountInputDto account) { return(!ModelState.IsValid || account == null ? BadRequest(ModelState) : controller.UpdateAccount(id, account)); }
public object CreateAccount(AccountInputDto account) { SqlHelper sqlHelper = new SqlHelper(connectionString); try { sqlHelper.VerifyConnection(); sqlHelper.SqlBeginTransaction(); var accountName = GetAccountName(account.Tags, account.Type); List<SqlParameter> accountParameters = new List<SqlParameter> { new SqlParameter("name", accountName), new SqlParameter("description", account.Description), new SqlParameter("type", account.Type) }; var accountQuery = $@"INSERT INTO [account] ([name] ,[description] ,[account_type_id]) VALUES (@name ,@description ,@type) SELECT SCOPE_IDENTITY() AS 'Identity'"; sqlHelper.Insert(accountQuery, CommandType.Text, accountParameters.ToArray(), out int accountId); if (account.Tags.Count > 0) { foreach (var accountTag in account.Tags) { List<SqlParameter> tagParameters = new List<SqlParameter> { new SqlParameter("accountId", accountId), new SqlParameter("tagId", accountTag.Id), new SqlParameter("tagValue", accountTag.Value) }; var tagQuery = $@"INSERT INTO [account_tag] ([account_id] ,[tag_id] ,[tag_value]) VALUES (@accountId ,@tagId ,@tagValue)"; sqlHelper.Insert(tagQuery, CommandType.Text, tagParameters.ToArray()); } } sqlHelper.SqlCommitTransaction(); sqlHelper.CloseConnection(); } catch (Exception ex) { sqlHelper.SqlRollbackTransaction(); sqlHelper.CloseConnection(); Console.WriteLine($"SQL Rollback Transaction Exception: {ex}"); return Utils.Wrap(false); } return Utils.Wrap(true); }
public object UpdateAccount(int id, AccountInputDto account) { SqlHelper sqlHelper = new SqlHelper(connectionString); if (AccountHasJournal(id)) { return Utils.Wrap(false, null, HttpStatusCode.OK, "An Account having Journal cannot be Edited"); } try { sqlHelper.VerifyConnection(); sqlHelper.SqlBeginTransaction(); var accountName = GetAccountName(account.Tags, account.Type); List<SqlParameter> accountParameters = new List<SqlParameter> { new SqlParameter("id", id), new SqlParameter("name", accountName), new SqlParameter("description", account.Description), new SqlParameter("type", account.Type) }; List<SqlParameter> tagDeleteParameters = new List<SqlParameter> { new SqlParameter("id", id) }; var accountQuery = $@"UPDATE [account] SET [name] = @name ,[description] = @description ,[account_type_id] = @type WHERE [id] = @id"; var tagDeleteQuery = $@"DELETE FROM [account_tag] WHERE [account_tag].[account_id] = @id"; sqlHelper.Update(accountQuery, CommandType.Text, accountParameters.ToArray()); sqlHelper.Delete(tagDeleteQuery, CommandType.Text, tagDeleteParameters.ToArray()); if (account.Tags.Count > 0) { foreach (var accountTag in account.Tags) { List<SqlParameter> tagParameters = new List<SqlParameter> { new SqlParameter("accountId", id), new SqlParameter("tagId", accountTag.Id), new SqlParameter("tagValue", accountTag.Value) }; var tagQuery = $@"INSERT INTO [account_tag] ([account_id] ,[tag_id] ,[tag_value]) VALUES (@accountId ,@tagId ,@tagValue)"; sqlHelper.Insert(tagQuery, CommandType.Text, tagParameters.ToArray()); } } sqlHelper.SqlCommitTransaction(); sqlHelper.CloseConnection(); } catch (Exception ex) { sqlHelper.SqlRollbackTransaction(); sqlHelper.CloseConnection(); Console.WriteLine($"SQL Rollback Transaction Exception: {ex}"); return Utils.Wrap(false); } return Utils.Wrap(true); }
/// <summary> /// 用户修改密码 /// </summary> /// <param name="data"></param> /// <returns></returns> public async Task <IActionResult> SaveAccountPWD(AccountInputDto data) { bool result = await _service.SaveAccountPWD(data); return(Json(new { code = result, msg = result ? "修改成功" : "修改失败" })); }
/// <summary> /// 验证用户信息 /// </summary> /// <param name="data"></param> /// <returns></returns> public async Task <IActionResult> UserVilidata(AccountInputDto data) { bool result = await _service.UserVilidata(data); return(Json(new { code = result, msg = result ? "验证成功" : "验证失败" })); }
public object UpdateAccount(int id, AccountInputDto account) { throw new System.NotImplementedException(); }
public object CreateAccount(AccountInputDto account) { throw new System.NotImplementedException(); }
public object CreateAccount(AccountInputDto account) { return(!ModelState.IsValid || account == null ? BadRequest(ModelState) : controller.CreateAccount(account)); }