public IList <LabTestOrder> GetByPatientId(int patientId)
{
var testList = new List <LabTestOrder>();
var adapter = new appointment_has_lab_orderTableAdapter();
try
{
using (adapter)
{
foreach (
var row in
adapter.GetData()
.Where(
tst =>
new AppointmentController().GetById(tst.appointment_id).PatientId ==
patientId))
{
var test = this.GetById(row.lab_order_id);
testList.Add(test);
}
}
return(testList);
}
catch (Exception e)
{
throw e;
}
}
public AppointmentLabOrder GetById(int id)
{
var adapter = new appointment_has_lab_orderTableAdapter();
try
{
using (adapter)
{
var aptLabOrder = adapter.GetData().FirstOrDefault(alo => alo.appointment_id == id);
return(this.GetAptTestOrderedFromRow(aptLabOrder));
}
}
catch (Exception e)
{
throw e;
}
}
public void Add(AppointmentLabOrder aptLabOrder)
{
var adapter = new appointment_has_lab_orderTableAdapter();
var appointmentId = aptLabOrder.AppointmentId;
var labOrderId = aptLabOrder.LabOrderId;
try
{
using (adapter)
{
adapter.Insert(appointmentId, labOrderId);
}
}
catch (Exception e)
{
throw e;
}
}
public IList <AppointmentLabOrder> GetAll()
{
var aptTestOrderedList = new List <AppointmentLabOrder>();
var adapter = new appointment_has_lab_orderTableAdapter();
try
{
using (adapter)
{
foreach (var row in adapter.GetData().Rows)
{
var test = this.GetAptTestOrderedFromRow((cs3230f16bDataSet.appointment_has_lab_orderRow)row);
aptTestOrderedList.Add(test);
}
}
return(aptTestOrderedList);
}
catch (Exception e)
{
throw e;
}
}
