using Cowain.Bake.Common.Core;
using Cowain.Bake.Common.Enums;
using Cowain.Bake.Model;
using Cowain.Bake.Model.Models;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity;
using System.Linq;
using System.Runtime.Remoting.Contexts;
using Unity;

namespace Cowain.Bake.BLL
{
    public class CavityInfoService : ServiceBase
    {
        public CavityInfoService(IUnityContainer unityContainer) : base(unityContainer)
        {
        }
        public List<TCavityInfo> GetAll()
        {
            using (var Context = new BakingEntities())
            {
                return Context.Set<TCavityInfo>().OrderBy(x => x.Id).ToList();
            }
        }
        public TCavityInfo GetStationDetailByName(string name)
        {
            using (var Context = new BakingEntities())
            {
                return Context.Set<TCavityInfo>().Where(x => x.Name == name).FirstOrDefault();
            }
        }
        public int UpdateStationNonePallet(string stationName)
        {
            using (var Context = new BakingEntities())
            {
                var stationDtl = Context.Set<TCavityInfo>().Where(x => x.Name == stationName).ToList().FirstOrDefault();
                stationDtl.PalletId = 0;
                stationDtl.Lock = false;
                return Context.SaveChanges();
            }
        }
        
        public int UpdateStationReq(string stationName, sbyte status)
        {
            using (var Context = new BakingEntities())
            {
                var cavityInfo = Context.Set<TCavityInfo>().Where(x => x.Name == stationName).FirstOrDefault();
                cavityInfo.Status = status;
                return Context.SaveChanges();
            }
        }

        public int ChangeStationStatus(string stationName, int status)
        {
            using (var Context = new BakingEntities())
            {
                TCavityInfo info = Context.Set<TCavityInfo>().Where(x => x.Name == stationName).FirstOrDefault();
                if (null == info)
                {
                    return 0;
                }
                info.Enable = status != 0 ;
                Context.Set<TCavityInfo>().Attach(info);//将数据附加到上下文，支持实体修改和新实体，重置为UnChanged
                Context.Entry<TCavityInfo>(info).State = EntityState.Modified;
                return Context.SaveChanges();
            }
        }

        public int UpdateLoadStatus(int machineId, int layer, int number, bool loadStatus)
        {
            using (var Context = new BakingEntities())
            {
                var model = Context.Set<TCavityInfo>().Where(x => x.StationId == machineId
                                      && x.Layer == layer
                                      && x.Column == number).FirstOrDefault();//.ForEach(x => x.IsLoad = loadStatus);
                model.IsLoad = loadStatus;
                return Context.SaveChanges();
            }
        }

        /// <summary>
        /// 是否符合请放，请取要求
        /// </summary>
        /// <param name="station"></param>
        /// <param name="number"></param>
        /// <param name="status"></param>
        /// <returns></returns>
        public bool IsAccordReq(TStation station, int number, sbyte status)
        {
            TCavityInfo model = new TCavityInfo();
            using (var Context = new BakingEntities())
            {
                if (station.Type == (int)EStationType.Loading
                || station.Type == (int)EStationType.UnLoading)
                {
                    if (status == (int)ECavityStatus.RequestPick) //请取
                    {
                        model = Context.Set<TCavityInfo>().Where(x => x.StationId == station.Id
                             && x.Column == number
                             && x.IsLoad == true
                             && x.PalletId != 0
                             ).FirstOrDefault();  //表示有盘
                    }
                    else if (status == (int)ECavityStatus.RequestPlace) //请放
                    {
                        model = Context.Set<TCavityInfo>().Where(x => x.StationId == station.Id
                           && x.Column == number
                           && x.IsLoad == false
                           && x.PalletId == 0
                           ).FirstOrDefault();  //表示无盘
                    }
                }
                else //炉子
                {
                    if (status == (int)ECavityStatus.RequestPick) //请取
                    {
                        model = Context.Set<TCavityInfo>().Where(x => x.StationId == station.Id
                             && x.Layer == number
                             && x.IsLoad == true
                             && x.PalletId != 0
                             ).FirstOrDefault();  //表示有盘
                    }
                    else if (status == (int)ECavityStatus.RequestPlace) //请放
                    {
                        model = Context.Set<TCavityInfo>().Where(x => x.StationId == station.Id
                           && x.Layer == number
                           && x.IsLoad == false
                           && x.PalletId == 0
                           ).FirstOrDefault();  //表示无盘
                    }
                }
                
            }

            if (null == model)
            {
                return false;
            }

            return true;
        }

        public bool UpdateReqStatus(TStation station, int number, sbyte status)
        {
            TCavityInfo model = null;
            using (var Context = new BakingEntities())
            {
                if (station.Type == (int)EStationType.Loading
               || station.Type == (int)EStationType.UnLoading)
                {
                    model = Context.Set<TCavityInfo>().Where(x => x.StationId == station.Id
                        && x.Column == number
                        ).FirstOrDefault();
                }
                else
                {
                    model = Context.Set<TCavityInfo>().Where(x => x.StationId == station.Id
                      && x.Layer == number
                      ).FirstOrDefault();
                }

                model.Status = status;
                Context.Entry(model).State = EntityState.Modified;
                return Context.SaveChanges() > 0  ? true : false;
            }
        }

        public bool UpdateUnBinding(string stationName)
        {
            using (var Context = new BakingEntities())
            {
                var model = Context.Set<TCavityInfo>().Where(x => x.Name == stationName).FirstOrDefault();
                if (null != model)
                {
                    model.PalletId = 0;
                    Context.Entry(model).State = EntityState.Modified;
                    return Context.SaveChanges() > 0 ? true : false;
                }

                return false;
            }
        }

        public TCavityInfo GetStationID(string stationName)
        {
            using (var Context = new BakingEntities())
            {
                 return (from ci in Context.Set<TCavityInfo>()
                        join s in Context.Set<TStation>() on ci.StationId equals s.Id into cs
                        from s in cs.DefaultIfEmpty()            // 左连接 Scores
                        join pi in Context.Set<TDeviceConfig>() on s.DeviceId equals pi.Id into cp
                        from pi in cp.DefaultIfEmpty()           // 左连接 Parents
                        where ci.Name == stationName
                        select ci).FirstOrDefault();
            }

            //string sql = $@"SELECT td.Id,tc.IsConnect,td.PalletId ,td.IsLoad FROM TCavityInfo td 
            //    LEFT JOIN TStation t ON t.id=td.StationId
            //    LEFT JOIN TDeviceConfig tc ON tc.id=t.DeviceIds
            //    WHERE td.Name='{stationName}' LIMIT 1";
            //return GetDataTable(sql);
        }

        public List<string> GetCanUseStationName()
        {
            using (var Context = new BakingEntities())
            {
                string sql = $@"SELECT td.Name FROM TCavityInfo td
                LEFT JOIN TStation t ON td.StationId=t.Id
                LEFT JOIN TDeviceConfig tc ON t.DeviceId=tc.Id
                WHERE td.Name<>'AGV' AND td.Enable=1 AND td.Lock =0
                AND td.IsLoad = 0 AND tc.IsConnect=1 AND t.Enable = 1 ORDER BY td.Id";
                return Context.Database.SqlQuery<string>(sql).ToList();
            }
        }
        public bool UnLockStation(int stationId, int layer, int number)
        {
            using (var Context = new BakingEntities())
            {
                TCavityInfo station = (from sd in Context.Set<TCavityInfo>()
                                       where sd.StationId == stationId && sd.Layer == layer && sd.Column == number
                                       select sd).FirstOrDefault();  //将托盘号绑定到AGV

                if (null == station)
                {
                    return false;
                }

                station.Lock = false;
                Context.Entry(station).State = EntityState.Modified;
                if (0 != Context.SaveChanges())
                {
                    return true;
                }
                return false;
            }
        }

        public bool LockStation(int stationId, int layer, int number)
        {
            using (var Context = new BakingEntities())
            {
                TCavityInfo station = (from sd in Context.Set<TCavityInfo>()
                                       where sd.StationId == stationId && sd.Layer == layer && sd.Column == number
                                       select sd).FirstOrDefault();  //将托盘号绑定到AGV

                if (null == station)
                {
                    return false;
                }

                station.Lock = true;
                Context.Entry(station).State = EntityState.Modified;
                if (0 != Context.SaveChanges())
                {
                    return true;
                }
                return false;
            }
        }
        public TCavityInfo GetStationDetailById(int id)
        {
            using (var Context = new BakingEntities())
            {
                return Context.Set<TCavityInfo>().Where(x => x.Id == id).FirstOrDefault();
            }
        }

        public int SetRobotPos( int stationNumber)
        {
            using (var Context = new BakingEntities())
            {
                var model = (from a in Context.Set<TCavityInfo>()
                 join b in Context.Set<TStation>() on a.StationId equals b.Id
                 where b.Type == (int)EStationType.AGV
                 orderby a.Id
                 select a).FirstOrDefault();

                model.StationNumber = (sbyte)stationNumber;
                return Context.SaveChanges();
            }
        }

        public int GetPalletId(int machineType, int number)
        {
            using (var Context = new BakingEntities())
            {
                var station = (from a in Context.Set<TCavityInfo>()
                               join b in Context.Set<TStation>() on a.StationId equals b.Id
                               where b.Type == machineType && a.Column == number
                               orderby a.Id
                               select a).FirstOrDefault();

                if (null == station)
                {
                    LogHelper.Instance.GetCurrentClassError($"通过设备ID={machineType},编号={number},查找夹具ID失败！");
                    return 0;
                }

                return station.PalletId;
            }
        }


        //public TCavityInfo GetStationDetail(int StationId, int X, int Y)
        //{
        //    using (var Context = new BakingEntities())
        //    {
        //        TCavityInfo detail = (from s in Context.Set<TCavityInfo>()
        //                                 where s.StationId == StationId && s.Layer == X && s.Column == Y
        //                                 select s).FirstOrDefault();

        //        if (null == detail)
        //        {
        //            LogHelper.Instance.Error($"获取工站详细信息失败，StationId:{StationId},Layer{X},Number{Y}");
        //        }

        //        return detail;
        //    }
        //}
        public int GetCavityId(int stationId, int layer, int column = 1)
        {
            using (var Context = new BakingEntities())
            {
                TCavityInfo detail = (from s in Context.Set<TCavityInfo>()
                                         where s.StationId == stationId && s.Layer == layer && s.Column == column
                                      select s).FirstOrDefault();

                if (null == detail)
                {
                    LogHelper.Instance.GetCurrentClassError($"通过设备ID={stationId},Layer:{layer},编号={column},查找夹具ID失败！");
                    return 0;
                }
                else
                {
                    return detail.Id;
                }
            }
        }
        public int UpdateDoorStatus(int machineId, int layer, bool doorStatus)
        {
            using (var Context = new BakingEntities())
            {
                Context.Set<TCavityInfo>().Where(x => x.StationId == machineId
                                                && x.Layer == layer).ToList().ForEach(x => x.IsOpen = doorStatus);
                return Context.SaveChanges();
            }
        }

        public int UpdateCavitySignal(int stationId, int layer, Int16 status)
        {
            using (var Context = new BakingEntities())
            {
                Context.Set<TCavityInfo>().Where(x => x.StationId == stationId
                                                && x.Layer == layer).ToList().ForEach(x => x.Status = (sbyte)status);
                return Context.SaveChanges();
            }
        }

        public List<ExCavityInfoModel> GetAllExInfo()
        {
            using (var Context = new BakingEntities())
            {
                // 查询语法的三表联查
                return (from ci in Context.Set<TCavityInfo>()
                    join s in Context.Set<TStation>() on ci.StationId equals s.Id into cs
                    from s in cs.DefaultIfEmpty()            // 左连接 Scores
                    join pi in Context.Set<TPalletInfo>() on ci.PalletId equals pi.Id into cp
                    from pi in cp.DefaultIfEmpty()            // 左连接 Parents
                    //where s.Type != (int)EStationType.AGV
                    select new ExCavityInfoModel
                    {
                        StationId = s.Id,
                        Name = s.Name,
                        Desc = s.Desc,
                        Layers = s.Layers,
                        Columns = s.Columns,
                        Number = s.Number,
                        PosX = s.PosX,
                        PosY = s.PosY,
                        Type = s.Type,
                        LeftMargin = s.LeftMargin,
                        Enable = s.Enable,

                        Id = ci.Id,
                        CavityName = ci.Name,
                        IsLoad = ci.IsLoad,
                        PalletId = ci.PalletId,
                        Lock = ci.Lock,
                        Layer = ci.Layer,
                        Status = ci.Status??0,
                        Column = ci.Column,
                        StationX = ci.StationX,
                        StationY = ci.StationY,
                        IsOpen = ci.IsOpen,
                        CavityEnable = ci.Enable,
                        Remark = ci.Remark,

                        BakingPosition = pi.BakingPosition,
                        JobNum = pi.JobNum,
                        PalletStatus = pi.PalletStatus,
                        PalletCode = pi.PalletCode,
                        BatteryQty = pi.BatteryQty,
                        BakingCount = pi.BakingCount,
                        TotalBakingCount = pi.TotalBakingCount,
                        LoadingBegingTime = pi.LoadingBegingTime,
                        BakingBeginTime = pi.BakingBeginTime,
                        BakingOverTime = pi.BakingOverTime,
                        LastFlag = pi.LastFlag,
                        UnLoadingBegingTime = pi.LoadingBegingTime
                    }).OrderBy(x=>x.Id).ToList();

            }
        }
 
        //public int TransferStationToAGV(int fromStation, int fromX, int fromY)
        //{
        //    int result = 0;
        //    using (var Context = new BakingEntities())
        //    {
        //        TCavityInfo detail = (from s in Context.Set<TCavityInfo>()
        //                                 where s.StationId == fromStation && s.Layer == fromX && s.Column == fromY
        //                                 select s).FirstOrDefault();
        //        if (null == detail || 0 == detail.PalletId)
        //        {
        //            LogHelper.Instance.Error($"获取托盘失败StationId:{fromStation},Layer:{fromX},Number:{fromY}");
        //            return 0;
        //        }

        //        //using (var transaction = Context.Database.BeginTransaction())
        //        {
        //            try
        //            {
        //                (from a in Context.Set<TCavityInfo>()
        //                 join b in Context.Set<TStation>() on a.StationId equals b.Id
        //                 where b.Type == (int)EStationType.AGV
        //                 select a).ToList().ForEach(x => x.PalletId = detail.PalletId);  //将托盘号绑定到AGV

        //                result = Context.SaveChanges();

        //                if (0 == result)
        //                {
        //                    LogHelper.Instance.Warn($"托盘绑定AGV失败1! 托盘号;{detail.PalletId}");
        //                }
        //                /////////////////////////////////////////////////////////
        //                Context.Set<TCavityInfo>().Where(x => x.Id == detail.Id).ToList().ForEach(x => x.PalletId = 0); //解绑
        //                result = Context.SaveChanges();

        //                if (0 == result)
        //                {
        //                    LogHelper.Instance.Warn($"托盘绑定AGV失败2! 托盘号;{detail.PalletId}");
        //                }

        //            }
        //            catch (Exception ex)
        //            {
        //                // 回滚事务
        //                //transaction.Rollback();
        //                LogHelper.Instance.Warn("TransferPallet:" + ex.Message);
        //            }
        //        }
        //        return result;
        //    }
        //}
        public int UpdatePalletStatus(int palletId, string stationName, int statusCode)
        {
            using (var Context = new BakingEntities())
            {
                string sql = $@"UPDATE TCavityInfo t1 SET t1.`Lock`=0 
                WHERE t1.Name='{stationName}';";
                Context.Database.ExecuteSqlCommand(sql);

                sql = $@"UPDATE TPalletInfo set PalletStatus={statusCode}
                    WHERE Id={palletId};";
                return Context.Database.ExecuteSqlCommand(sql);
            }
        }

        public int UpdateStationPalletCode(string stationName, string palletCode)
        {
            //先解绑原来的
            using (var Context = new BakingEntities())
            {
                var palletDtl = Context.Set<TPalletInfo>().Where(x => x.PalletCode == palletCode).ToList().FirstOrDefault();
                var stationBindingDtl = Context.Set<TCavityInfo>().Where(x => x.PalletId == palletDtl.Id)
                    .ToList().FirstOrDefault(); //老工站如果是新夹具，就不解绑

                if (stationBindingDtl != null)
                {
                    if (1 != stationBindingDtl.PalletId) //新夹具
                    {
                        stationBindingDtl.PalletId = 0;
                        Context.SaveChanges();
                    }
                }

                //绑定现在的
                var stationDtl = Context.Set<TCavityInfo>().Where(x => x.Name == stationName).ToList().FirstOrDefault();
                if (stationDtl.PalletId == palletDtl.Id)
                {
                    return 1;
                }
                if (stationDtl != null)
                {
                    stationDtl.PalletId = palletDtl.Id;
                    stationDtl.Lock = false;
                }
                return Context.SaveChanges();
            }
        }
        public int UpdateRemark(string stationName, string msg)
        {
            using (var Context = new BakingEntities())
            {
                TCavityInfo model = Context.Set<TCavityInfo>().Where(x => x.Name == stationName).FirstOrDefault();
                if (null == model)
                {
                    return 0;
                }

                var models = Context.Set<TCavityInfo>().Where(x => x.StationId == model.StationId && x.Layer == model.Layer).ToList();

                foreach (var entity in models)
                {
                    entity.Remark = msg;
                    Context.Entry<TCavityInfo>(entity).State = EntityState.Modified;
                }

                return Context.SaveChanges();
            }
        }
        //public string GetStation(int? StationId)
        //{
        //    using (var Context = new BakingEntities())
        //    {
        //        TCavityInfo detail = (from s in Context.Set<TCavityInfo>()
        //                                 where s.Id == StationId
        //                                 select s).FirstOrDefault();
        //        if (null == detail)
        //        {
        //            return null;
        //        }
        //        else
        //        {
        //            return detail.Name;
        //        }
        //    }
        //}
        public void GetPalletBakingPosAndUpdateLock(string palletCode)
        {
            using (var Context = new BakingEntities())
            {
                TPalletInfo palletInfo = Context.Set<TPalletInfo>().Where(x => x.PalletCode == palletCode).FirstOrDefault();
                Context.Set<TCavityInfo>().Where(x => x.Id == palletInfo.BakingPosition).ToList().ForEach(x => x.Lock = false); //测试OK加在下料位，解绑
                Context.SaveChanges();
            }
        }

        //public int[] GetLayerPalletId(int Layer, int StationId)
        //{
        //    using (var Context = new BakingEntities())
        //    {
        //        return Context.Set<TCavityInfo>()
        //            .Where(x => x.Layer == Layer && x.StationId == (byte)StationId)
        //           .Select(x => x.PalletId).ToArray();
        //    }
        //}

        //5，4，5一层的水含量
        public int[] GetLayerTypePalletId(int LayerType, int StationId)
        {
            using (var Context = new BakingEntities())
            {
                return Context.Set<TCavityInfo>()
                    .Where(x => x.LayerType == LayerType && x.StationId == (byte)StationId)
                   .Select(x => x.PalletId).ToArray();
            }
        }

        public CavityHeaderModel GetHeadInfo(string cavityName)
        {
            string sql = $@"SELECT IFNULL(ti.BatteryQty , 0) BatteryQty,IFNULL(ti.TotalBakingCount , 0) TotalBakingCount,IFNULL(ti.BakingCount , 0) BakingCount,ti.JobNum,IFNULL(ti.VirtualId ,  0) VirtualId,td.Lock,td.Id,td.Remark
                ,IF(td.Enable,'可用','禁用') Enable,IF(COALESCE(tb.DummyFlag, 0) = 1, '带水', '不带水') AS IsWater
                ,IFNULL(ti.Id , 0) PalletId,ti.PalletCode,ti.PalletStatus,ti.WaterValue,ti.LastFlag,td.Layer,td.LayerType,IFNULL(ti.BakingPosition , 0) BakingPosition
                FROM TCavityInfo td
                LEFT JOIN TPalletInfo ti ON td.PalletId=ti.Id
                LEFT JOIN TBatteryInfo tb ON ti.VirtualId = tb.PalletVirtualId AND tb.DummyFlag = 1
                WHERE td.Name='{cavityName}' limit 1";
            using (var Context = new BakingEntities())
            {
                return Context.Database.SqlQuery<CavityHeaderModel>(sql).FirstOrDefault();
            }
        }
        public CavityInfoModel GetCavityDetailByName(string name)
        {
            using (var Context = new BakingEntities())
            {
                return (from a in Context.Set<TStation>()
                        join b in Context.Set<TCavityInfo>() on a.Id equals b.StationId
                        where b.Name == name
                        select new CavityInfoModel
                        {
                            StationId = a.Id,
                            Name = a.Name,
                            Desc = a.Desc,
                            Layers = a.Layers,
                            Columns = a.Columns,
                            Number = a.Number,
                            PosX = a.PosX,
                            PosY = a.PosY,
                            Type = a.Type,
                            LeftMargin = a.LeftMargin,
                            Enable = a.Enable,

                            Id = b.Id,
                            CavityName = b.Name,
                            IsLoad = b.IsLoad,
                            PalletId = b.PalletId,
                            Lock = b.Lock,
                            Layer = b.Layer,
                            Column = b.Column,             
                            StationX = b.StationX,
                            StationY = b.StationY,
                            IsOpen = b.IsOpen,
                            Status = b.Status ?? 0,
                            CavityEnable = b.Enable,
                            Remark = b.Remark,
                        }).FirstOrDefault();
            }
        }

        public List<CavityInfoModel> GetAllStation()
        {
            using (var Context = new BakingEntities())
            {
                return (from a in Context.Set<TStation>()
                        join b in Context.Set<TCavityInfo>() on a.Id equals b.StationId
                        select new CavityInfoModel
                        {
                            StationId = a.Id,
                            Name = a.Name,
                            Desc = a.Desc,
                            Layers = a.Layers,
                            Columns = a.Columns,
                            Number = a.Number,
                            PosX = a.PosX,
                            PosY = a.PosY,
                            Type = a.Type,
                            LeftMargin = a.LeftMargin,
                            Enable = a.Enable,

                            Id = b.Id,
                            CavityName = b.Name,
                            IsLoad = b.IsLoad,
                            PalletId = b.PalletId,
                            Lock = b.Lock,
                            Layer = b.Layer,
                            Column = b.Column,
                            Status = b.Status ?? 0,

                            StationX = b.StationX,
                            StationY = b.StationY,
                            IsOpen = b.IsOpen,
                            CavityEnable = b.Enable,
                            Remark = b.Remark,
                        }).ToList();
            }
        }

        public CavityInfoModel GetCavitynDetailById(int id)
        {
            using (var Context = new BakingEntities())
            {
                return (from a in Context.Set<TStation>()
                        join b in Context.Set<TCavityInfo>() on a.Id equals b.StationId
                        where b.Id == id
                        select new CavityInfoModel
                        {
                            StationId = a.Id,
                            Name = a.Name,
                            Desc = a.Desc,
                            Layers = a.Layers,
                            Columns = a.Columns,
                            Number = a.Number,
                            PosX = a.PosX,
                            PosY = a.PosY,
                            Type = a.Type,
                            LeftMargin = a.LeftMargin,
                            Enable = a.Enable,

                            Id = b.Id,
                            CavityName = b.Name,
                            IsLoad = b.IsLoad,
                            PalletId = b.PalletId,
                            Lock = b.Lock,
                            Layer = b.Layer,
                            Column = b.Column,
                            StationNumber = b.StationNumber,
                            StationX = b.StationX,
                            StationY = b.StationY,
                            Status = b.Status ?? 0,
                            IsOpen = b.IsOpen,
                            CavityEnable = b.Enable,
                            Remark = b.Remark,
                        }).FirstOrDefault();
            }
        }

        public List<CavityInfoModel> GetExAll()
        {
            using (var Context = new BakingEntities())
            {
                return (from a in Context.Set<TStation>()
                join b in Context.Set<TCavityInfo>() on a.Id equals b.StationId
                select new CavityInfoModel
                {
                    StationId = a.Id,
                    Name = a.Name,
                    Desc = a.Desc,
                    Layers = a.Layers,
                    Columns = a.Columns,
                    Number = a.Number,
                    PosX = a.PosX,
                    PosY = a.PosY,
                    Type = a.Type,
                    LeftMargin = a.LeftMargin,
                    Enable = a.Enable,

                    Id = b.Id,
                    CavityName = b.Name,
                    IsLoad =b.IsLoad,
                    PalletId = b.PalletId,
                    Lock = b.Lock,
                    Layer = b.Layer,
                    Column = b.Column,
                    StationNumber = b.StationNumber,
                    StationX = b.StationX,
                    StationY = b.StationY,
                    IsOpen = b.IsOpen,
                    CavityEnable = b.Enable,
                    Remark = b.Remark,
                    Status = b.Status ?? 0,
                }).ToList();
            }  
        }
    }
}