public Task <InvoiceNumberSetting> SaveAsync(InvoiceNumberSetting setting, CancellationToken token = default(CancellationToken))
{
#region merge query
var query = @"
MERGE INTO InvoiceNumberSetting target
USING (
SELECT @CompanyId [CompanyId]
) source
ON (
target.CompanyId = source.CompanyId
)
WHEN MATCHED THEN
UPDATE SET
UseNumbering = @UseNumbering
,Length = @Length
,ZeroPadding = @ZeroPadding
,ResetType = @ResetType
,ResetMonth = @ResetMonth
,FormatType = @FormatType
,DateType = @DateType
,DateFormat = @DateFormat
,FixedStringType = @FixedStringType
,FixedString = @FixedString
,DisplayFormat = @DisplayFormat
,Delimiter = @Delimiter
,UpdateBy = @UpdateBy
,UpdateAt = GETDATE()
WHEN NOT MATCHED THEN
INSERT (CompanyId, UseNumbering, Length, ZeroPadding, ResetType, ResetMonth, FormatType, DateType, DateFormat, FixedStringType, FixedString, DisplayFormat, Delimiter, CreateBy, CreateAt, UpdateBy, UpdateAt)
VALUES (@CompanyId, @UseNumbering, @Length, @ZeroPadding, @ResetType, @ResetMonth, @FormatType, @DateType, @DateFormat, @FixedStringType, @FixedString, @DisplayFormat, @Delimiter, @UpdateBy, GETDATE(), @UpdateBy, GETDATE())
OUTPUT inserted.*; ";
#endregion
return(dbHelper.ExecuteAsync <InvoiceNumberSetting>(query, setting, token));
}
private async Task InitializeInvoiceNumberAsync(CompanySource source, LoginUser loginUser, CancellationToken token)
{
var invoiceNumberSetting = new InvoiceNumberSetting
{
CompanyId = source.Company.Id,
UseNumbering = 0,
CreateBy = loginUser.Id,
UpdateBy = loginUser.Id,
};
await invoiceNumberSettingProcessor.SaveAsync(invoiceNumberSetting, token);
}
public async Task <ActionResult <InvoiceNumberSetting> > SaveInvoiceNumberSetting(InvoiceNumberSetting setting, CancellationToken token) => await invoiceNumberSettingProcessor.SaveAsync(setting, token);
public async Task <InvoiceNumberSettingResult> SaveInvoiceNumberSettingAsync(string SessionKey, InvoiceNumberSetting InvoiceNumberSetting)
{
return(await authorizationProcessor.DoAuthorizeAsync(SessionKey, async token =>
{
var result = await invoiceNumberSettingProcessor.SaveAsync(InvoiceNumberSetting, token);
return new InvoiceNumberSettingResult
{
ProcessResult = new ProcessResult {
Result = true
},
InvoiceNumberSetting = result,
};
}, logger));
}
public async Task <InvoiceNumberSetting> SaveAsync(InvoiceNumberSetting InvoiceNumberSetting, CancellationToken token = default(CancellationToken)) => await addInvoiceNumberSettingQueryProcessor.SaveAsync(InvoiceNumberSetting, token);
