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