public async Task <Guid> CreateAsync(SchedulerAppointmentEntity entity)
{
if (await _schedulerAppointmentRepository.AddAsync(entity))
{
return(entity.Id);
}
return(Guid.Empty);
}
public async Task <bool> UpdateAsync(SchedulerAppointmentEntity entity)
{
var sql = $@"update scheduler_appointment
set task_id = @TaskId, task_name = @TaskName, price = @Price, user_id = @UserId
, ""start"" = @Start, ""end"" = @End, recurrence_id = @RecurrenceId, recurrence_rule = @RecurrenceRule
, recurrence_exception = @RecurrenceException
, is_all_day = @IsAllDay, is_off = @IsOff, updated_at=now(), notes = @Notes
where id = @Id";
return(await _dbContext.ExecuteAsync <bool>(sql, entity));
}
public async Task <bool> AddAsync(SchedulerAppointmentEntity entity)
{
var sql = $@"insert into scheduler_appointment
(id, task_id, task_name, price, user_id
, ""start"", ""end"", recurrence_id, recurrence_rule, recurrence_exception
, is_all_day, is_off, notes)
values(@Id, @TaskId, @TaskName, @price, @UserId
, @Start, @End, @RecurrenceId, @RecurrenceRule, @RecurrenceException
, @IsAllDay, @IsOff, @Notes);";
return(await _dbContext.ExecuteAsync <bool>(sql, entity));
}
public async Task <bool> UpdateAsync(SchedulerAppointmentEntity entity)
{
return(await _schedulerAppointmentRepository.UpdateAsync(entity));
}
