public void Read()
        {
            foreach (var item in _db.Anesthetists.ToList())
            {
                Anesthetist.Add(item);
            }

            foreach (var item in _db.Hospitals.ToList())
            {
                Hospital.Add(item);
            }

            foreach (var item in _db.OperatingRooms.ToList())
            {
                OperatingRoom.Add(item);
            }

            foreach (var item in OperatingRoom)
            {
                foreach (var x in Hospital)
                {
                    if (item.HospitalId == x.HospitalId)
                    {
                        item.HospitalName = x.Name;
                    }
                }
            }
        }
        public void Read(int id)
        {
            pId = id;
            foreach (var item in _db.Surgeons.ToList())
            {
                if (item.LoginId == LoginController.LoggedInUser)
                {
                    SiD = item.SurgeonId;
                }
            }

            foreach (var item in _db.Anesthetists.ToList())
            {
                Anesthetist.Add(item);
            }

            foreach (var item in _db.Hospitals.ToList())
            {
                Hospital.Add(item);
            }

            foreach (var item in _db.OperatingRooms.ToList())
            {
                OperatingRoom.Add(item);
            }

            foreach (var item in OperatingRoom)
            {
                foreach (var x in Hospital)

                {
                    if (item.HospitalId == x.HospitalId)
                    {
                        item.HospitalName = x.Name;
                    }
                }
            }

            foreach (var item in _db.Procedures.ToList())
            {
                if (id == item.ProcedureId)
                {
                    Procedure.ProcedureName            = item.ProcedureName;
                    Procedure.EstimatedProcedureLength = item.EstimatedProcedureLength;
                    Procedure.ActualStart  = item.ActualStart;
                    Procedure.ActualFinish = item.ActualFinish;
                    Procedure.Status       = item.Status;
                }
            }
        }