public LabTestOrder GetById(int id)
{
var adapter = new test_orderedTableAdapter();
try
{
using (adapter)
{
var labTestOrdered = adapter.GetData().FirstOrDefault(lto => lto.test_ordered_id == id);
return(this.GetTestOrderedFromRow(labTestOrdered));
}
}
catch (Exception e)
{
throw e;
}
}
public void Add(LabTestOrder labTestOrder)
{
var adapter = new test_orderedTableAdapter();
var testId = labTestOrder.TestId;
var doctorId = labTestOrder.DoctorId;
var testDate = labTestOrder.TestDate;
try
{
using (adapter)
{
adapter.Insert(testId, doctorId, testDate);
}
}
catch (Exception e)
{
throw e;
}
}
public int GetLastId()
{
var adapter = new test_orderedTableAdapter();
try
{
using (adapter)
{
var labTestOrdered = adapter.GetData().LastOrDefault();
if (labTestOrdered != null)
{
return(labTestOrdered.test_ordered_id);
}
return(-1);
}
}
catch (Exception e)
{
throw e;
}
}
public IList <LabTestOrder> GetAll()
{
var testOrderedList = new List <LabTestOrder>();
var adapter = new test_orderedTableAdapter();
try
{
using (adapter)
{
foreach (var row in adapter.GetData().Rows)
{
var test = this.GetTestOrderedFromRow((cs3230f16bDataSet.test_orderedRow)row);
testOrderedList.Add(test);
}
}
return(testOrderedList);
}
catch (Exception e)
{
throw e;
}
}
