public Task <InvoiceTemplateSetting> SaveAsync(InvoiceTemplateSetting setting, CancellationToken token = default(CancellationToken))
{
#region merge query
var query = @"
MERGE INTO InvoiceTemplateSetting target
USING (
SELECT @CompanyId [CompanyId]
,@Code [Code]
) source
ON (
target.CompanyId = source.CompanyId
AND target.Code = source.Code
)
WHEN MATCHED THEN
UPDATE SET
Name = @Name
,CollectCategoryId = @CollectCategoryId
,Title = @Title
,Greeting = @Greeting
,DisplayStaff = @DisplayStaff
,DueDateComment = @DueDateComment
,DueDateFormat = @DueDateFormat
,TransferFeeComment = @TransferFeeComment
,FixedString = @FixedString
,UpdateBy = @UpdateBy
,UpdateAt = GETDATE()
WHEN NOT MATCHED THEN
INSERT (CompanyId, Code, Name, CollectCategoryId, Title, Greeting, DisplayStaff, DueDateComment, DueDateFormat, TransferFeeComment, FixedString, CreateBy, CreateAt, UpdateBy, UpdateAt)
VALUES (@CompanyId, @Code, @Name, @CollectCategoryId, @Title, @Greeting, @DisplayStaff, @DueDateComment, @DueDateFormat, @TransferFeeComment, @FixedString, @UpdateBy, GETDATE(), @UpdateBy, GETDATE())
OUTPUT inserted.*; ";
#endregion
return(dbHelper.ExecuteAsync <InvoiceTemplateSetting>(query, setting, token));
}
private async Task InitializeInvoiceTemplateAsync(CompanySource source, LoginUser loginUser, CancellationToken token)
{
var invoiceTemplateSetting = new InvoiceTemplateSetting
{
CompanyId = source.Company.Id,
Code = "00",
Name = "お振込",
Title = "請求書",
Greeting = @"平素は格別のご高配を賜り、厚く御礼申し上げます。
下記の通り請求書を同封いたしましたので、ご査収くださいますよう、よろしくお願いいたします。",
DisplayStaff = 0,
DueDateComment = "下記の口座に[YMD]までにご入金していただきますようよろしくお願いいたします。",
DueDateFormat = 0,
TransferFeeComment = "なお、手数料は貴社負担とさせていただきますが、ご了承ください。",
FixedString = string.Empty,
CreateBy = loginUser.Id,
UpdateBy = loginUser.Id,
};
await invoiceTemplateSettingProcessor.SaveAsync(invoiceTemplateSetting, token);
}
public async Task <ActionResult <InvoiceTemplateSetting> > SaveInvoiceTemplateSetting(InvoiceTemplateSetting setting, CancellationToken token) => await invoiceTemplateSettingProcessor.SaveAsync(setting, token);
public async Task <ActionResult <InvoiceTemplateSetting> > GetInvoiceTemplateSettingByCode(InvoiceTemplateSetting setting, CancellationToken token) => await invoiceTemplateSettingProcessor.GetByCodeAsync(setting.CompanyId, setting.Code, token);
public async Task <InvoiceTemplateSettingResult> SaveInvoiceTemplateSettingAsync(string SessionKey, InvoiceTemplateSetting InvoiceTemplateSetting)
{
return(await authorizationProcessor.DoAuthorizeAsync(SessionKey, async token =>
{
var result = await invoiceTemplateSettingProcessor.SaveAsync(InvoiceTemplateSetting, token);
return new InvoiceTemplateSettingResult
{
ProcessResult = new ProcessResult {
Result = true
},
InvoiceTemplateSetting = result,
};
}, logger));
}
public async Task <InvoiceTemplateSetting> SaveAsync(InvoiceTemplateSetting InvoiceTemplateSetting, CancellationToken token = default(CancellationToken)) => await addInvoiceTemplateSettingQueryProcessor.SaveAsync(InvoiceTemplateSetting, token);
