public void Update(LabTestResult result) { var adapter = new test_resultsTableAdapter(); try { DataRow resRow; using (adapter) { resRow = adapter.GetData().FirstOrDefault(res => res.test_result_id == result.ResultId); } if (resRow != null) { resRow[2] = result.TestResults; using (adapter) { adapter.Update(resRow); } } } catch (Exception e) { throw e; } }
public LabTestResult GetById(int id) { var adapter = new test_resultsTableAdapter(); try { using (adapter) { var result = adapter.GetData().FirstOrDefault(res => res.test_result_id == id); return(this.GetTestFromRow(result)); } } catch (Exception e) { throw e; } }
public IList <LabTestResult> GetAll() { var testList = new List <LabTestResult>(); var adapter = new test_resultsTableAdapter(); try { using (adapter) { foreach (var row in adapter.GetData().Rows) { var test = this.GetTestFromRow((cs3230f16bDataSet.test_resultsRow)row); testList.Add(test); } } return(testList); } catch (Exception e) { throw e; } }