namespace WIDESEA_StorageTaskRepository;

public class Dt_TaskRepository : RepositoryBase<Dt_Task>, IDt_TaskRepository
{
    public Dt_TaskRepository(IUnitOfWorkManage unitOfWorkManage) : base(unitOfWorkManage)
    {
    }

    public async Task<Dt_Task> Create(Dt_Task model)
    {
        return await Db.Insertable(model).ExecuteReturnEntityAsync();
    }

    public async Task<bool> Create(List<Dt_Task> models)
    {
        var num = Db.Insertable(models).ExecuteCommand();
        if (num == models.Count)
            return await Task.FromResult(true);
        else
            return await Task.FromResult(false);
    }

    public async Task<bool> Delete(int id)
    {
        return await Db.Deleteable<Dt_Task>().In(id).ExecuteCommandHasChangeAsync();
    }

    public async Task<bool> Delete(List<int> ids)
    {
        return await Db.Deleteable<Dt_Task>().In(ids.ToArray()).ExecuteCommandHasChangeAsync();
    }

    public async Task<Dt_Task> GetById(int id)
    {
        return await Db.Queryable<Dt_Task>().InSingleAsync(id);
    }

    public async Task<List<Dt_Task>> GetList()
    {
        return await Db.Queryable<Dt_Task>().ToListAsync();
    }

    public Task<List<Dt_Task>> GetListByOutOrder(int outOrderId)
    {
        throw new NotImplementedException();
    }

    public Task<List<Dt_Task>> GetListByOutOrderAndStatus(int outOrderId, int status)
    {
        throw new NotImplementedException();
    }

    public async Task<List<Dt_Task>> GetListByStatus(int status)
    {
        return await Db.Queryable<Dt_Task>().Where(x => x.TaskState == status).ToListAsync();
    }

    public Task<int> GetTaskNo()
    {
        string sql = "select next value for dbo.GetTaskNum";
        return Db.Ado.SqlQuerySingleAsync<int>(sql);
    }

    public async Task<bool> Update(Dt_Task model)
    {
        return await Db.Updateable(model).ExecuteCommandHasChangeAsync();
    }

    public async Task<bool> Update(List<Dt_Task> models)
    {
        return await Db.Updateable(models).ExecuteCommandHasChangeAsync();
    }
}