public static Timing_Option ContainsTimeOption(Fixture fixture, Timing_Option timing_Option)
        {
            var result = fixture.Timing_Option.Where(r => r.Name == timing_Option.Name &&
                                                     r.Categories.Equals(timing_Option.Categories) &&
                                                     r.Parameters.Equals(timing_Option.Parameters) &&
                                                     r.Fixture == timing_Option.Fixture &&
                                                     r.Timing_WorkStations == timing_Option.Timing_WorkStations).FirstOrDefault();


            return(result);
        }
        public static Timing_Option addTimeOptionCustom(Fixture fixture, List <Category> Categories, List <Parameter> Parameters, Timing_WorkStations workStations, string OptionName, decimal OptionValue)
        {
            Timing_Option Input = new Timing_Option()
            {
                Name                = OptionName,
                Time                = OptionValue,
                Fixture             = fixture,
                Categories          = Categories,
                Parameters          = Parameters,
                Timing_WorkStations = workStations
            };

            return(Input);
        }
        public static Timing_Option addTimeOptionCustom(Fixture fixture, Category Category, Parameter Parameter, Timing_WorkStations workStations, string OptionName, decimal OptionValue)
        {
            Timing_Option Input = new Timing_Option()
            {
                Name                = OptionName,
                Time                = OptionValue,
                Fixture             = fixture,
                Timing_WorkStations = workStations
            };

            //Input.Categories.Add(Category);
            Input.Parameters.Add(Parameter);
            return(Input);
        }
        public static void addTimeOption()
        {
            HashSet <Timing_Option> globalopts = new HashSet <Timing_Option>();

            List <Fixture> fixtures = new List <Fixture>();

            using (var DWdb = new DWModel())
            {
                using (var db = new SSRS())
                {
                    var prod = db.ProdTBs.ToList();
                    foreach (var item in prod)
                    {
                        foreach (var opt in item.OptionTBs)
                        {
                            var fixture     = DWdb.Fixtures.Where(r => r.Code == item.Code).FirstOrDefault();
                            var workstation = DWdb.Timing_WorkStations.Where(r => r.Name == item.WorkCenter).FirstOrDefault();
                            if (fixture != null && workstation != null)
                            {
                                var optnew = new Timing_Option()
                                {
                                    Name    = opt.OptionName,
                                    Time    = (decimal)opt.ProdTime,
                                    Fixture = fixture,

                                    Timing_WorkStations = workstation
                                };
                                //DWdb.Timing_Option.Add(optnew);
                                //DWdb.SaveChanges();
                                globalopts.Add(optnew);
                            }
                        }
                    }
                }

                foreach (var item in globalopts)
                {
                    DWdb.Timing_Option.Add(item);
                    DWdb.SaveChanges();
                }
            }
        }