public Task <EBExcludeAccountSetting> SaveAsync(EBExcludeAccountSetting setting, CancellationToken token = default(CancellationToken)) { #region insert query var query = @" INSERT INTO EBExcludeAccountSetting ( CompanyId , BankCode , BranchCode , AccountTypeId , PayerCode , CreateBy , CreateAt , UpdateBy , UpdateAt ) OUTPUT inserted.* VALUES (@CompanyId ,@BankCode ,@BranchCode ,@AccountTypeId ,@PayerCode ,@CreateBy ,GETDATE() ,@UpdateBy ,GETDATE() ) "; #endregion return(dbHelper.ExecuteAsync <EBExcludeAccountSetting>(query, setting, token)); }
private void F01_RegisterSettings() { try { var error = ValidateForRegister(); if (error != null) { if (error is ValidationError <Control> ) { var actualError = (ValidationError <Control>)error; if (actualError.FocusTarget != null) { actualError.FocusTarget.Focus(); } } ShowWarningDialog(error.MessageId, error.MessageArgs); return; } if (!ShowConfirmDialog(MsgQstConfirmSave)) { DispStatusMessage(MsgInfProcessCanceled); return; } var setting = new EBExcludeAccountSetting { CompanyId = CompanyId, BankCode = txtBankCode.Text.PadLeft(4, '0'), BranchCode = txtBranchCode.Text.PadLeft(3, '0'), AccountTypeId = AccountTypeDictionary.Single(kv => kv.Value == cmbAccountType.Text).Key, PayerCode = txtPayerCode1.Text.PadLeft(3, '0') + txtPayerCode2.Text.PadLeft(7, '0'), CreateBy = Login.UserId, UpdateBy = Login.UserId, }; var task = SaveEBExcludeAccountSettingListAsync(SessionKey, setting); ProgressDialog.Start(BaseForm, task, false, SessionKey); if (task.Result == null) { ShowWarningDialog(MsgErrSaveError); return; } ClearScreen(); LoadGridData(); ShowWarningDialog(MsgInfSaveSuccess); } catch (Exception ex) { Debug.Fail(ex.Message); NLogHandler.WriteErrorLog(this, ex, SessionKey); } }
public Task <int> DeleteAsync(EBExcludeAccountSetting setting, CancellationToken token = default(CancellationToken)) { var query = @" DELETE EBExcludeAccountSetting WHERE CompanyId = @CompanyId AND BankCode = @BankCode AND BranchCode = @BranchCode AND AccountTypeId = @AccountTypeId AND PayerCode = @PayerCode "; return(dbHelper.ExecuteAsync(query, setting, token)); }
public async Task <CountResult> DeleteAsync(string SessionKey, EBExcludeAccountSetting ebExcludeAccountSetting) { return(await authorizationProcessor.DoAuthorizeAsync(SessionKey, async token => { var result = await ebExcludeAccountSettingProcessor.DeleteAsync(ebExcludeAccountSetting, token); return new CountResult { ProcessResult = new ProcessResult { Result = true }, Count = result, }; }, logger)); }
public GridRow(EBExcludeAccountSetting model) { // グリッド編集機能を持たないのでコンストラクタ内で全てのプロパティ値をセットする。モデルも保持しない。 BankCode = model.BankCode; BranchCode = model.BranchCode; var accountType = ""; AccountTypeDictionary.TryGetValue(model.AccountTypeId, out accountType); AccountType = accountType; var code = model.PayerCode; if (!string.IsNullOrWhiteSpace(code) && 10 <= code.Length) { PayerCode1 = code.Substring(0, 3); PayerCode2 = code.Substring(3, 7); } }
public async Task <ActionResult <int> > Delete(EBExcludeAccountSetting setting, CancellationToken token) => await ebExcludeAccountSettingProcessor.DeleteAsync(setting, token);
public async Task <ActionResult <EBExcludeAccountSetting> > Save(EBExcludeAccountSetting setting, CancellationToken token) => await ebExcludeAccountSettingProcessor.SaveAsync(setting, token);
private static async Task <int?> DeleteEBExcludeAccountSettingListAsync(string sessionKey, EBExcludeAccountSetting target) { CountResult result = null; await ServiceProxyFactory.LifeTime(async factory => { var client = factory.Create <EBExcludeAccountSettingMasterService.EBExcludeAccountSettingMasterClient>(); result = await client.DeleteAsync(sessionKey, target); }); if (result == null || result.ProcessResult.Result == false) { return(null); } return(result.Count); }
private static async Task <EBExcludeAccountSetting> SaveEBExcludeAccountSettingListAsync(string sessionKey, EBExcludeAccountSetting setting) { EBExcludeAccountSettingResult result = null; await ServiceProxyFactory.LifeTime(async factory => { var client = factory.Create <EBExcludeAccountSettingMasterService.EBExcludeAccountSettingMasterClient>(); result = await client.SaveAsync(sessionKey, setting); }); if (result == null || result.ProcessResult.Result == false) { return(null); } return(result.EBExcludeAccountSetting); }
public async Task <int> DeleteAsync(EBExcludeAccountSetting setting, CancellationToken token = default(CancellationToken)) => await ebExcludeAccountSettingQueryProcessor.DeleteAsync(setting, token);