C# (CSharp) TaskScheduleSearch Examples

Example #1

        public async Task <bool> ExistsAsync(TaskScheduleSearch option, CancellationToken token = default(CancellationToken))
        {
            var query = @"
SELECT      1
WHERE EXISTS (
            SELECT      1
            FROM        TaskSchedule ts
            WHERE       ts.CompanyId        = @CompanyId";

            if (option.ImportType.HasValue)
            {
                query += @"
            AND         ts.ImportType       = @ImportType";
            }
            if (option.ImportSubType.HasValue)
            {
                query += @"
            AND         ts.ImportSubType    = @ImportSubType";
            }
            query += @"
            )";
            return((await dbHelper.ExecuteAsync <int?>(query, option, token)).HasValue);
        }

Example #2

        public Task <IEnumerable <TaskSchedule> > GetAsync(TaskScheduleSearch option, CancellationToken token = default(CancellationToken))
        {
            var query = @"
SELECT        ts.*
            , uc.Name AS CreateUserName
            , uu.Name AS UpdateUserName
FROM        TaskSchedule ts
LEFT JOIN   LoginUser uc        ON ts.CreateBy  = uc.id
LEFT JOIN   LoginUser uu        ON ts.UpdateBy  = uu.id
WHERE       ts.CompanyId        = @CompanyId";

            if (option.ImportType.HasValue)
            {
                query += @"
AND         ts.ImportType       = @ImportType";
            }
            if (option.ImportSubType.HasValue)
            {
                query += @"
AND         ts.ImportSubType    = @ImportSubType";
            }
            return(dbHelper.GetItemsAsync <TaskSchedule>(query, option, token));
        }

Example #3

 public async Task <ActionResult <bool> > Exists(TaskScheduleSearch option, CancellationToken token)
 => await taskScheduleProcessor.ExistsAsync(option, token);

Example #4

 public async Task <ActionResult <IEnumerable <TaskSchedule> > > GetItems(TaskScheduleSearch option, CancellationToken token)
 => (await taskScheduleProcessor.GetAsync(option, token)).ToArray();

Example #5

 public async Task <bool> ExistsAsync(TaskScheduleSearch option, CancellationToken token = default(CancellationToken))
 => await taskScheduleQueryProcessor.ExistsAsync(option, token);

Example #6

 public async Task <IEnumerable <TaskSchedule> > GetAsync(TaskScheduleSearch option, CancellationToken token = default(CancellationToken))
 => await taskScheduleQueryProcessor.GetAsync(option, token);