public List <PatientAppointment> GetByDate(DateTime date)
        {
            IPatientAppointmentRepository patientAppointmentRepository = new PatientAppointmentRepository();
            List <PatientAppointment>     patientAppointment           = patientAppointmentRepository.FindBy(p => DbFunctions.TruncateTime(p.AppointmentDate) == DbFunctions.TruncateTime(date)).ToList();

            return(patientAppointment);
        }
        public List <PatientAppointment> GetAppointmentId(int PatientId, int PatientMasterVisitId, DateTime date)
        {
            IPatientAppointmentRepository patientAppointmentRepository = new PatientAppointmentRepository();
            List <PatientAppointment>     patientAppointment           = patientAppointmentRepository.FindBy(p => DbFunctions.TruncateTime(p.AppointmentDate) == DbFunctions.TruncateTime(date) & p.PatientId == PatientId & p.PatientMasterVisitId == PatientMasterVisitId).ToList();

            return(patientAppointment);
        }
        public List <PatientAppointment> GetByDateRange(DateTime startDate, DateTime endDate)
        {
            IPatientAppointmentRepository patientAppointmentRepository = new PatientAppointmentRepository();
            List <PatientAppointment>     patientAppointment           = patientAppointmentRepository
                                                                         .FindBy(p => p.AppointmentDate >= DbFunctions.TruncateTime(startDate) && p.AppointmentDate <= DbFunctions.TruncateTime(endDate)).ToList();

            return(patientAppointment);
        }
        public List <PatientAppointment> GetByPatientId(int patientId)
        {
            IPatientAppointmentRepository patientAppointmentRepository = new PatientAppointmentRepository();

            List <PatientAppointment> patientAppointment = patientAppointmentRepository.FindBy(p => p.PatientId == patientId).ToList();

            return(patientAppointment);
        }