public List<sp_SearchPatientPrescriptionResult> getPatientPrescription(string appointmentId) { List<sp_SearchPatientPrescriptionResult> myList = new List<sp_SearchPatientPrescriptionResult>(); try { prescriptionsDataContext obj = new prescriptionsDataContext(); myList = obj.sp_SearchPatientPrescription(Convert.ToInt32(appointmentId)).ToList(); } catch (Exception ex) { clsCommon.saveError(ex); } return myList; }