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);
}