using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Linq;

namespace IStation.DAL
{
    /// <summary>
    /// 
    /// </summary>	
    public class CurveAnalyzePacket
    {
        #region Path

        /// <summary>
        /// 查询文件路径
        /// </summary> 
        public string GetRootFolder(long monitorDataSourcesId)
        {
            var monitorDataSourcesFolder = FileHelper.GetMonitorDataSourcesFolder(Settings.Project.ID, monitorDataSourcesId);
            if (!Directory.Exists(monitorDataSourcesFolder))
                Directory.CreateDirectory(monitorDataSourcesFolder);
            var monitorDataSetFolder = Path.Combine(monitorDataSourcesFolder, Settings.File.CurveAnalyzeDataFolder);
            if (!Directory.Exists(monitorDataSetFolder))
                Directory.CreateDirectory(monitorDataSetFolder);
            return monitorDataSetFolder;
        }

        #endregion

        #region Get

        /// <summary>
        /// 查询全部
        /// </summary> 
        public List<Model.CurveAnalyzePacket> GetAll(long monitorDataSourcesId)
        {
            var path = GetRootFolder(monitorDataSourcesId);
            var all = FileIdHelper<Model.CurveAnalyzePacket>.GetAll(path);
            var models = all?.ToList();
            return models;
        }

        /// <summary>
        /// 根据 Id 查询
        /// </summary> 
        public Model.CurveAnalyzePacket GetByID(long monitorDataSourcesId, long Id)
        {
            if (Id < 1)
                return default;
            var all = GetAll(monitorDataSourcesId);
            var models = all?.ToList();
            return models?.Find(t => t.ID == Id);
        }

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

        /// <summary>
        /// 根据  EquipmentID 查询
        /// </summary> 
        public List<Model.CurveAnalyzePacket> GetByEquipmentID(long monitorDataSourcesId, long stationId, long equipmentId)
        {
            if (stationId < 1)
                return default;
            if (equipmentId < 1)
                return default;
            var all = GetAll(monitorDataSourcesId);
            var models = all?.Where(x => x.StationID == stationId && x.EquipmentID == equipmentId).ToList();
            return models;
        }

        /// <summary>
        /// 根据  CurveAnalyzeID 查询
        /// </summary> 
        public List<Model.CurveAnalyzePacket> GetByCurveAnalyzeID(long monitorDataSourcesId, long curveAnalyzeId)
        {
            if (curveAnalyzeId < 1)
                return default;
            var all = GetAll(monitorDataSourcesId);
            var models = all?.Where(x => x.CurveAnalyzeID == curveAnalyzeId).ToList();
            return models;
        }

        /// <summary>
        /// 根据  CurveAnalyzeIds 查询
        /// </summary> 
        public List<Model.CurveAnalyzePacket> GetByCurveAnalyzeIds(long monitorDataSourcesId, List<long> curveAnalyzeIds)
        {
            if (curveAnalyzeIds == null || curveAnalyzeIds.Count < 1)
                return default;
            var all = GetAll(monitorDataSourcesId);
            var models = all?.Where(x => curveAnalyzeIds.Contains(x.CurveAnalyzeID)).ToList();
            return models;
        }
        #endregion

        #region Insert

        /// <summary>
        /// 插入
        /// </summary>
        public long Insert(long monitorDataSourcesId, Model.CurveAnalyzePacket rhs)
        {
            if (rhs == null)
                return default;
            var path = GetRootFolder(monitorDataSourcesId);
            return FileIdHelper<Model.CurveAnalyzePacket>.Insert(path, rhs);
        }

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

        /// <summary>
        /// 插入并返回
        /// </summary>
        public Model.CurveAnalyzePacket InsertR(long monitorDataSourcesId, Model.CurveAnalyzePacket rhs)
        {
            if (rhs == null)
                return default;
            var path = GetRootFolder(monitorDataSourcesId);
            var entities = FileIdHelper<Model.CurveAnalyzePacket>.InsertR(path, rhs);
            return entities;
        }

        /// <summary>
        /// 批量插入并返回
        /// </summary>
        public List<Model.CurveAnalyzePacket> InsertRs(long monitorDataSourcesId, IEnumerable<Model.CurveAnalyzePacket> list)
        {
            if (list == null || list.Count() < 1)
                return default;
            var path = GetRootFolder(monitorDataSourcesId);
            var models = FileIdHelper<Model.CurveAnalyzePacket>.InsertRs(path, list);
            return models;
        }

        #endregion

        #region Update

        /// <summary>
        /// 更新
        /// </summary>
        public bool Update(long monitorDataSourcesId, Model.CurveAnalyzePacket rhs)
        {
            if (rhs == null)
                return default;
            var path = GetRootFolder(monitorDataSourcesId);
            return FileIdHelper<Model.CurveAnalyzePacket>.Update(path, rhs);
        }

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

        #endregion

        #region Delete 

        /// <summary>
        /// 根据 Id删除
        /// </summary>
        public bool DeleteByID(long monitorDataSourcesId, long Id)
        {
            if (Id < 0)
                return default;
            var path = GetRootFolder(monitorDataSourcesId);
            var bol = FileIdHelper<Model.CurveAnalyzePacket>.DeleteByID(path, Id);
            return bol;
        }


        /// <summary>
        /// 根据 Id删除
        /// </summary>
        public bool DeleteByCurveAnalyzeID(long monitorDataSourcesId, long curveAnalyzeId)
        {
            if (curveAnalyzeId < 0)
                return default;
            var list = GetByCurveAnalyzeID(monitorDataSourcesId, curveAnalyzeId);
            if (list == null || !list.Any())
                return true;
            var ids = list.Select(x => x.ID).ToList();
            var path = GetRootFolder(monitorDataSourcesId);
            var bol = FileIdHelper<Model.CurveAnalyzePacket>.DeleteByIds(path, ids);
            return bol;
        }

        /// <summary>
        /// 根据  CurveAnalyzeIds 删除
        /// </summary>
        public bool DeleteByCurveAnalyzeIds(long monitorDataSourcesId, List<long> curveAnalyzeIds)
        {
            if (curveAnalyzeIds == null || curveAnalyzeIds.Count < 0)
                return default;
            var list = GetByCurveAnalyzeIds(monitorDataSourcesId, curveAnalyzeIds);
            if (list == null || !list.Any())
                return true;
            var ids = list.Select(x => x.ID).ToList();
            var path = GetRootFolder(monitorDataSourcesId);
            var bol = FileIdHelper<Model.CurveAnalyzePacket>.DeleteByIds(path, ids);
            return bol;
        }


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

        /// <summary>
        /// 删除
        /// </summary>
        public bool Delete(long monitorDataSourcesId, Model.CurveAnalyzePacket rhs)
        {
            if (rhs == null)
                return default;
            var path = GetRootFolder(monitorDataSourcesId);
            var bol = FileIdHelper<Model.CurveAnalyzePacket>.DeleteByID(path, rhs.ID);
            return bol;
        }

        /// <summary>
        /// 批量删除
        /// </summary> 
        public bool Deletes(long monitorDataSourcesId, IEnumerable<Model.CurveAnalyzePacket> list)
        {
            if (list == null || list.Count() < 1)
                return default;
            var path = GetRootFolder(monitorDataSourcesId);
            var Ids = list.Select(x => x.ID).ToList();
            var bol = FileIdHelper<Model.CurveAnalyzePacket>.DeleteByIds(path, Ids);
            return bol;
        }

        /// <summary>
        /// 删除全部
        /// </summary>
        public bool DeleteAll(long monitorDataSourcesId)
        {
            var path = GetRootFolder(monitorDataSourcesId);
            var bol = FileIdHelper<Model.CurveAnalyzePacket>.DeleteAll(path);
            return bol;
        }

        #endregion 

        #region Exist

        /// <summary>
        /// 是否存在文件
        /// </summary>
        public bool IsExist(long monitorDataSourcesId)
        {
            var path = GetRootFolder(monitorDataSourcesId);
            return FileIdHelper<Model.CurveAnalyzePacket>.IsExist(path);
        }

        /// <summary>
        /// 是否存在对象
        /// </summary>
        public bool ExistByCurveAnalyzeID(long monitorDataSourcesId, long curveAnalyzeId)
        {
            if (curveAnalyzeId < 1)
                return default;
            var list = GetAll(monitorDataSourcesId);
            if (list == null || list.Count < 1)
                return default;
            return list.Exists(x => x.CurveAnalyzeID == curveAnalyzeId);
        }


        /// <summary>
        /// 是否存在对象
        /// </summary>
        public bool Exist(long monitorDataSourcesId, long id)
        {
            if (id < 1)
                return default;
            var list = GetAll(monitorDataSourcesId);
            if (list == null || list.Count < 1)
                return default;
            return list.Exists(x => x.ID == id);
        }

        #endregion

    }
}