public LabTest GetById(int id)
        {
            var adapter = new lab_testsTableAdapter();

            try
            {
                using (adapter)
                {
                    var test = adapter.GetData().FirstOrDefault(tst => tst.testCode == id);
                    return(this.GetTestFromRow(test));
                }
            }
            catch (Exception e)
            {
                throw e;
            }
        }
        public void Add(LabTest test)
        {
            var adapter  = new lab_testsTableAdapter();
            var testName = test.TestName;

            try
            {
                using (adapter)
                {
                    adapter.Insert(testName);
                }
            }
            catch (Exception e)
            {
                throw e;
            }
        }
        public IList <LabTest> GetAll()
        {
            var testList = new List <LabTest>();
            var adapter  = new lab_testsTableAdapter();

            try
            {
                using (adapter)
                {
                    foreach (var row in adapter.GetData().Rows)
                    {
                        var test = this.GetTestFromRow((cs3230f16bDataSet.lab_testsRow)row);
                        testList.Add(test);
                    }
                }
                return(testList);
            }
            catch (Exception e)
            {
                throw e;
            }
        }