public IActionResult Get(int tmsId)
        {
            var tms = db.TMS.Find(tmsId);

            if (tms == null)
            {
                return(BadRequest());
            }

            // List<DTO_TMS> dto_tms = new List<DTO_TMS>();
            List <TMS>                  tmsList         = db.TMS.ToList();
            List <TF_Services>          list            = db.TF_Services.ToList();
            List <ServicesRunningOnTMS> RunningServices = db.RunningServices.ToList();


            var newDto = new DTO_TMS();

            newDto.tms         = tms;
            newDto.TF_Services = new List <TF_Services>();
            foreach (ServicesRunningOnTMS sr in RunningServices.Where(x => x.TMS_Id == tms.Id))
            {
                var service = list.FirstOrDefault(x => x.Id == sr.ServiceId);
                service.Status = sr.Status;
                service.Id     = sr.ServiceId;
                newDto.TF_Services.Add(new TF_Services {
                    Id = service.Id, Name = service.Name, DisplayName = service.DisplayName, Status = sr.Status
                });
            }



            return(Ok(newDto));
        }
        public async Task <ActionResult <DTO_TMS> > GetList(string category)

        {
            List <DTO_TMS>              dto_tms         = new List <DTO_TMS>();
            List <TMS>                  tmsList         = db.TMS.ToList();
            List <TF_Services>          list            = db.TF_Services.ToList();
            List <ServicesRunningOnTMS> RunningServices = db.RunningServices.ToList();


            if (category == "")
            {
                foreach (TMS tms in tmsList)
                {
                    var newDto = new DTO_TMS();
                    newDto.tms         = tms;
                    newDto.TF_Services = new List <TF_Services>();
                    foreach (ServicesRunningOnTMS sr in RunningServices)
                    {
                        if (sr.TMS_Id == tms.Id)
                        {
                            var service = list.Find(x => x.Id == sr.ServiceId);
                            service.Status = sr.Status;
                            newDto.TF_Services.Add(service);
                        }
                    }


                    dto_tms.Add(newDto);
                }
            }
            else
            {
                // My_TF_Services = db.TF_Services.ToList();


                foreach (TMS tms in tmsList.Where(x => x.Category == category))
                {
                    var newDto = new DTO_TMS();
                    newDto.tms         = tms;
                    newDto.TF_Services = new List <TF_Services>();
                    foreach (ServicesRunningOnTMS sr in RunningServices.Where(x => x.TMS_Id == tms.Id))
                    {
                        var service = list.FirstOrDefault(x => x.Id == sr.ServiceId);
                        service.Status = sr.Status;
                        newDto.TF_Services.Add(new TF_Services {
                            Name = service.Name, DisplayName = service.DisplayName, Status = sr.Status
                        });
                    }

                    dto_tms.Add(newDto);
                }
            }


            if (category == null)
            {
                return(NotFound());
            }

            return(Ok(dto_tms));
        }