using System;
using System.Text;
using System.Collections.Generic;
using System.Data;
using System.Runtime.Serialization;
using System.Linq;

namespace IStation.DAL.LocalFile
{
    /// <summary>
    /// 业务类别
    /// </summary>	
    public class LogicCatalog : IDAL.ILogicCatalog<Entity.LogicCatalog>
    {

        #region Path

        /// <summary>
        /// 查询文件路径
        /// </summary> 
        private string GetFolderPath(long projectId)
        {
            return FileHelper.GetProjectPath(projectId);
        }

        #endregion

        #region Get

        /// <summary>
        /// 查询全部
        /// </summary> 
        public List<Entity.LogicCatalog> GetAll(long projectId)
        {
            if (projectId < 1)
                return default;
            var path = GetFolderPath(projectId);
            var all = FileIdHelper<Entity.LogicCatalog>.GetAll(path);
            var entities = all?.OrderBy(x => x.SortCode).ToList();
            return entities;
        }

        /// <summary>
        /// 根据 Id查询
        /// </summary> 
        public Entity.LogicCatalog GetById(long projectId, long Id)
        {
            if (projectId < 1)
                return default;
            if (Id < 0)
                return default;
            var all = GetAll(projectId);
            var entities = all?.ToList();
            return entities?.Find(t => t.Id == Id);
        }

        /// <summary>
        /// 根据 Id集合查询
        /// </summary> 
        public List<Entity.LogicCatalog> GetByIds(long projectId, IEnumerable<long> Ids)
        {
            if (projectId < 1)
                return default;
            if (Ids == null || Ids.Count() < 1)
                return default;
            var all = GetAll(projectId);
            var entities = all?.Where(x => Ids.Contains(x.Id)).ToList();
            return entities;
        }

        #endregion

        #region Insert

        /// <summary>
        /// 插入
        /// </summary>
        public long Insert(long projectId, Entity.LogicCatalog rhs)
        {
            if (projectId < 1)
                return default;
            if (rhs == null)
                return default;
            var path = GetFolderPath(projectId);
            return FileIdHelper<Entity.LogicCatalog>.Insert(path, rhs);
        }

        /// <summary>
        /// 批量插入
        /// </summary>
        public bool Inserts(long projectId, IEnumerable<Entity.LogicCatalog> list)
        {
            if (projectId < 1)
                return default;
            if (list == null || list.Count() < 1)
                return default;
            var path = GetFolderPath(projectId);
            return FileIdHelper<Entity.LogicCatalog>.Inserts(path, list);
        }

        /// <summary>
        /// 插入并返回
        /// </summary>
        public Entity.LogicCatalog InsertR(long projectId, Entity.LogicCatalog rhs)
        {
            if (projectId < 1)
                return default;
            if (rhs == null)
                return default;
            var path = GetFolderPath(projectId);
            var entities = FileIdHelper<Entity.LogicCatalog>.InsertR(path, rhs);
            return entities;
        }

        /// <summary>
        /// 批量插入并返回
        /// </summary>
        public List<long> InsertsR(long projectId, IEnumerable<Entity.LogicCatalog> list)
        {
            if (projectId < 1)
                return default;
            if (list == null || list.Count() < 1)
                return default;
            var path = GetFolderPath(projectId);
            var entities = FileIdHelper<Entity.LogicCatalog>.InsertRs(path, list);
            return entities?.Select(x => x.Id).ToList();
        }

        #endregion

        #region Update

        /// <summary>
        /// 更新
        /// </summary>
        public bool Update(long projectId, Entity.LogicCatalog rhs)
        {
            if (projectId < 1)
                return default;
            if (rhs == null)
                return default;
            var path = GetFolderPath(projectId);
            return FileIdHelper<Entity.LogicCatalog>.Update(path, rhs);
        }

        /// <summary>
        /// 批量更新
        /// </summary>
        public bool Updates(long projectId, IEnumerable<Entity.LogicCatalog> list)
        {
            if (projectId < 1)
                return default;
            if (list == null || list.Count() < 1)
                return default;
            var path = GetFolderPath(projectId);
            return FileIdHelper<Entity.LogicCatalog>.Updates(path, list);
        }

        #endregion

        #region Delete

        /// <summary>
        /// 根据 Id删除
        /// </summary>
        public bool DeleteById(long projectId, long Id)
        {
            if (projectId < 1)
                return default;
            if (Id < 0)
                return default;
            var path = GetFolderPath(projectId);
            var bol = FileIdHelper<Entity.LogicCatalog>.DeleteById(path, Id);
            return bol;
        }

        /// <summary>
        /// 根据 Id集合删除
        /// </summary>
        public bool DeleteByIds(long projectId, IEnumerable<long> Ids)
        {
            if (projectId < 1)
                return default;
            if (Ids == null || Ids.Count() < 1)
                return default;
            var path = GetFolderPath(projectId);
            var bol = FileIdHelper<Entity.LogicCatalog>.DeleteByIds(path, Ids);
            return bol;
        }

        /// <summary>
        /// 删除
        /// </summary>
        public bool Delete(long projectId, Entity.LogicCatalog rhs)
        {
            if (projectId < 1)
                return default;
            if (rhs == null)
                return default;
            var path = GetFolderPath(projectId);
            var bol = FileIdHelper<Entity.LogicCatalog>.DeleteById(path, rhs.Id);
            return bol;
        }

        /// <summary>
        /// 批量删除
        /// </summary> 
        public bool Deletes(long projectId, IEnumerable<Entity.LogicCatalog> list)
        {
            if (projectId < 1)
                return default;
            if (list == null || list.Count() < 1)
                return default;
            var path = GetFolderPath(projectId);
            var Ids = list.Select(x => x.Id).ToList();
            var bol = FileIdHelper<Entity.LogicCatalog>.DeleteByIds(path, Ids);
            return bol;
        }

        /// <summary>
        /// 删除全部
        /// </summary>
        public bool DeleteAll(long projectId)
        {
            if (projectId < 1)
                return default;
            var path = GetFolderPath(projectId);
            var bol = FileIdHelper<Entity.LogicCatalog>.DeleteAll(path);
            return bol;
        }

        #endregion

        #region Cover 

        /// <summary>
        /// 批量覆盖
        /// </summary>
        public bool Covers(long projectId, IEnumerable<Entity.LogicCatalog> list)
        {
            if (projectId < 1)
                return default;
            if (list == null || list.Count() < 1)
                return default;
            var path = GetFolderPath(projectId);
            return FileIdHelper<Entity.LogicCatalog>.Covers(path, list);
        }

        /// <summary>
        /// 批量覆盖并返回
        /// </summary> 
        public List<Entity.LogicCatalog> CoversR(long projectId, IEnumerable<Entity.LogicCatalog> list)
        {
            if (projectId < 1)
                return default;
            if (list == null || list.Count() < 1)
                return default;
            var path = GetFolderPath(projectId);
            return FileIdHelper<Entity.LogicCatalog>.CoversR(path, list);
        }

        #endregion
    }

}