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