public Task <LoginUserLicense> SaveAsync(LoginUserLicense license, CancellationToken token = default(CancellationToken)) { string query = @" MERGE INTO LoginUserLicense AS target USING ( SELECT @CompanyId AS CompanyId ,@LicenseKey AS LicenseKey ) AS source ON ( target.CompanyId = @CompanyId AND target.LicenseKey = @LicenseKey ) WHEN MATCHED THEN UPDATE SET LicenseKey = @LicenseKey WHEN NOT MATCHED THEN INSERT ( CompanyId, LicenseKey) VALUES (@CompanyId, @LicenseKey) OUTPUT inserted.*; "; return(dbHelper.ExecuteAsync <LoginUserLicense>(query, license, token)); }
public async Task <ActionResult <IEnumerable <LoginUserLicense> > > GetItems(LoginUserLicense license, CancellationToken token) => (await loginUserLicenseProcessor.GetAsync(license.CompanyId, token)).ToArray();