public int GetUserNullInfo(string patientId)
        {
            DAL.AppointmentListDal dal = new DAL.AppointmentListDal();
            int nullColumnCount        = dal.getNullColumnCount(patientId);

            return(nullColumnCount);
        }
        public DataTable GetAppointmentList(PatientAppointment oPatientAppointment)
        {
            DAL.AppointmentListDal dal = new DAL.AppointmentListDal();
            //string serialNo = dal.GetSerialNo(oPatientAppointment);
            DataTable appointmentList = dal.AppointLisFromDB(oPatientAppointment);

            return(appointmentList);
        }