public Patient GetPatientInformationBySl(string selectId)
        {
            DataTable table   = new IpdGateway().GetIndoorPatientInformationBySl(selectId);
            Patient   patient = new Patient();

            if (table.Rows.Count > 0)
            {
                patient.PatientName = table.Rows[0]["PatientName"].ToString();
                patient.Address     = table.Rows[0]["Address"].ToString();
                patient.Age         = table.Rows[0]["Age"].ToString();
                patient.BloodGroup  = table.Rows[0]["BloodGroup"].ToString();
                string docId  = table.Rows[0]["Doctor"].ToString();
                Doctor doctor = new MedicalManager().GetAllDoctorbyId(docId);
                patient.Doctor      = doctor.DoctorName;
                patient.Gender      = table.Rows[0]["Gender"].ToString();
                patient.Mobile      = table.Rows[0]["Mobile"].ToString();
                patient.Nationality = table.Rows[0]["Nationality"].ToString();
                patient.Phone       = table.Rows[0]["Phone"].ToString();
                patient.FatherName  = table.Rows[0]["FatherName"].ToString();
                patient.MotherName  = table.Rows[0]["MotherName"].ToString();
                patient.Gender      = table.Rows[0]["Gender"].ToString();
                patient.Relation    = table.Rows[0]["Relation"].ToString();
                patient.Gurdian     = table.Rows[0]["Gurdian"].ToString();
                patient.SelectedBed = table.Rows[0]["BedName"].ToString();
                patient.InputDate   = Convert.ToDateTime(table.Rows[0]["InputDate"]).Date;
                patient.RegNo       = table.Rows[0]["RegNo"].ToString();
                patient.Weight      = table.Rows[0]["Weight"].ToString();
                patient.SelectedBed = table.Rows[0]["BedName"].ToString();
                patient.OPID        = selectId;
            }
            return(patient);
        }
        public Patient GetPatientInformationBySl(string patientSlNo)
        {
            DataTable table   = new OpdGateway().GetPatientInformationBySl(patientSlNo);
            Patient   patient = new Patient();

            if (table.Rows.Count > 0)
            {
                patient.PatientName = table.Rows[0]["PatientName"].ToString();
                patient.Address     = table.Rows[0]["Address"].ToString();
                patient.Age         = table.Rows[0]["Age"].ToString();
                patient.BloodGroup  = table.Rows[0]["BloodGroup"].ToString();
                string docId  = table.Rows[0]["Doctor"].ToString();
                Doctor doctor = new MedicalManager().GetAllDoctorbyId(docId);
                patient.Doctor      = doctor.DoctorName; patient.Gender = table.Rows[0]["Gender"].ToString();
                patient.Mobile      = table.Rows[0]["Mobile"].ToString();
                patient.Nationality = table.Rows[0]["Nationality"].ToString();
                patient.Phone       = table.Rows[0]["Phone"].ToString();
            }
            return(patient);
        }