public Task <IEnumerable <BankBranch> > GetAsync(BankBranchSearch option, CancellationToken token = default(CancellationToken))
{
var query = @"
SELECT *
FROM BankBranch bb
WHERE bb.CompanyId = @CompanyId";
if (option.BankCodes?.Any() ?? false)
{
query += @"
AND bb.BankCode IN (SELECT Code FROM @BankCodes)";
}
if (option.BranchCodes?.Any() ?? false)
{
query += @"
AND bb.BranchCode IN (SELECT Code FROM @BranchCodes)";
}
if (!string.IsNullOrWhiteSpace(option.BankName))
{
option.BankName = Sql.GetWrappedValue(option.BankName);
query += @"
AND (bb.BankCode LIKE @BankName
OR bb.BankName LIKE @BankName
OR bb.BankKana LIKE @BankName)";
}
if (!string.IsNullOrWhiteSpace(option.BranchName))
{
option.BranchName = Sql.GetWrappedValue(option.BranchName);
query += @"
AND (bb.BranchCode LIKE @BranchName
OR bb.BranchName LIKE @BranchName
OR bb.BranchKana LIKE @BranchName)";
}
query += @"
ORDER BY bb.CompanyId ASC
, bb.BankCode ASC
, bb.BranchCode ASC
";
return(dbHelper.GetItemsAsync <BankBranch>(query, new {
option.CompanyId,
option.BankName,
option.BranchName,
BankCodes = option.BankCodes.GetTableParameter(),
BranchCodes = option.BranchCodes.GetTableParameter(),
}, token));
}
public async Task<ActionResult<IEnumerable<BankBranch>>> GetItems(BankBranchSearch option, CancellationToken token)
=> (await bankBranchProcess.GetAsync(option)).ToArray();
public async Task <IEnumerable <BankBranch> > GetAsync(BankBranchSearch option, CancellationToken token = default(CancellationToken)) => await bankBranchQueryProcessor.GetAsync(option, token);
public async Task <BankBranchsResult> GetItemsAsync(string Sessionkey, int CompanyId, BankBranchSearch BankBranchSearch)
{
return(await authorizationProcessor.DoAuthorizeAsync(Sessionkey, async token =>
{
BankBranchSearch.CompanyId = CompanyId;
var result = (await bankBranchProcessor.GetAsync(BankBranchSearch)).ToList();
return new BankBranchsResult
{
ProcessResult = new ProcessResult {
Result = true
},
BankBranches = result,
};
}, logger));
}
