public string PatientLoad(int patientId) { chsi.dat.CHSIEntities db = new chsi.dat.CHSIEntities(); var patient = (from p in db.payNewPatients join payers in db.payPatientPayers on p.payNewPatientId equals payers.payNewPatientId join busLines in db.payBusinessLines on p.payBusinessLineId equals busLines.payBusinessLineId where p.payNewPatientId == patientId select new {p.DOB, payers.HMOId, p.Address, p.City, p.State, p.Zip, p.Phone, p.NG_provider_id, BusinessLine =busLines.Name, Payer = payers.payPayers.Name }).FirstOrDefault(); chsi.dom.hlp.EFSerializer efs = new chsi.dom.hlp.EFSerializer(); return efs.EFSerialize(patient); }
public string PatientContactsLoad(int patientId) { chsi.dat.CHSIEntities db = new chsi.dat.CHSIEntities(); List<chsi.dat.payNewPatientContacts> contacts = (from c in db.payNewPatientContacts where c.payNewPatientId == patientId orderby c.ContactID select c).ToList(); chsi.dom.hlp.EFSerializer efs = new chsi.dom.hlp.EFSerializer(); return efs.EFSerialize(contacts); }