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);
