public bool UpdateAppointmentConfirmation(int PatId)
        {
            try
            {
                PatientDetail details = tran.PatientDetails.Where(x => x.Patient_Id == PatId).SingleOrDefault();
                details.IsConfirm = true;
                tran.SaveChanges();

                return(true);
            }
            catch
            {
                return(false);
            }
        }
        public bool RemoveAppointment(int PatId)
        {
            try
            {
                PatientDetail RemoveItem = tran.PatientDetails.Where(x => x.Patient_Id == PatId).FirstOrDefault();
                tran.PatientDetails.Remove(RemoveItem);
                tran.SaveChanges();

                return(true);
            }
            catch
            {
                return(false);
            }
        }