using WIDESEA_IStorageOutTaskRepository;

namespace WIDESEA_StorageOutTaskRepository
{
    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 async Task<List<Dt_Task>> GetListByOutOrder(int outOrderId)
        {
            return await Db.Queryable<Dt_Task>().Where(x => x.InboundNo == outOrderId.ToString()).ToListAsync();
        }

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

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

        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();
        }
    }
}