コード例 #1
0
ファイル: SearchClassTests.cs プロジェクト: trbielec/hospipal
        public void TestSearchEmployeesWithValidQueryWithCloseEid()
        {
            int eid1 = Employee.GenerateNextEid();
            Employee e1 = new Employee(eid1, "SearchFname1", "SearchLname1", "", "", 1);
            e1.Insert();

            int eid2 = Employee.GenerateNextEid();
            Employee e2 = new Employee(eid2, "SearchFname2", "SearchLname2", "", "", 1);
            e2.Insert();

            List<string> db = new List<string>();
            db.Add("eid");

            List<string> s = new List<string>();
            int test = eid1 / 10;
            s.Add(test.ToString());

            Search search = new Search("Employee");
            search.UseInputs(db, s);

            List<Employee> e = Search.SearchEmployees(search.GetBuiltQuery());
            Assert.True(e.Count >= 2);

            e1.Delete();
            e2.Delete();
        }
コード例 #2
0
ファイル: SearchClassTests.cs プロジェクト: trbielec/hospipal
        public void TestGetBuiltQuery()
        {
            Search s = new Search("Test");
            string q = s.GetBuiltQuery();

            Assert.True(q.Equals("SELECT * FROM Test WHERE "));
        }
コード例 #3
0
ファイル: SearchClassTests.cs プロジェクト: trbielec/hospipal
        public void TestBuildStringQueryWithTwoArguments()
        {
            Search s = new Search("Patient");
            s.BuildStringQuery("Test Arg1", "Test Arg2");

            string q = s.GetBuiltQuery();

            Assert.True(q.Equals("SELECT * FROM Patient WHERE (Test Arg1 LIKE '%Test Arg2%')"));
        }
コード例 #4
0
ファイル: SearchClassTests.cs プロジェクト: trbielec/hospipal
        public void TestBuildStringQueryWithSingleArgument()
        {
            Search s = new Search("Patient");
            s.BuildStringQuery("Test Arg");

            string q = s.GetBuiltQuery();

            Assert.True(q.Equals("SELECT * FROM Patient WHERE Test Arg"));
        }
コード例 #5
0
        public void validateInputs()
        {
            Search advancedSearch = new Search("Employee");
            List<string> dbSideVariables = new List<string>();
            List<string> cSideVariables = new List<string>();

            #region Box Checking
            if (!string.IsNullOrWhiteSpace(tbEID.Text))
            {

                dbSideVariables.Add("eid");
                cSideVariables.Add(tbEID.Text);
            }

            if (!string.IsNullOrWhiteSpace(tbFName.Text))
            {
                dbSideVariables.Add("fname");
                cSideVariables.Add(tbFName.Text);
            }

            if (!string.IsNullOrWhiteSpace(tbLName.Text))
            {
                dbSideVariables.Add("lname");
                cSideVariables.Add(tbLName.Text);
            }

            if (!string.IsNullOrWhiteSpace(cbSpecialty.Text))
            {
                dbSideVariables.Add("specialty");
                cSideVariables.Add(cbSpecialty.Text);
            }

            if (!string.IsNullOrWhiteSpace(cbEmployeeType.Text))
            {
                dbSideVariables.Add("employee_type");
                cSideVariables.Add(cbEmployeeType.Text);
            }

            if (!string.IsNullOrWhiteSpace(tbSupervisorID.Text))
            {
                dbSideVariables.Add("supervisor_id");
                cSideVariables.Add(tbSupervisorID.Text);
            }
            #endregion

            advancedSearch.UseInputs(dbSideVariables, cSideVariables);

            Employees = Search.SearchEmployees(advancedSearch.GetBuiltQuery());
            Employee_DataGrid.DataContext = Employees;
        }
コード例 #6
0
ファイル: SearchClassTests.cs プロジェクト: trbielec/hospipal
        public void TestUseInputs()
        {
            List<string> db = new List<string>();
            db.Add("DB Test1");
            db.Add("DB Test2");

            List<string> s = new List<string>();
            s.Add("S Test1");
            s.Add("S Test2");

            Search search = new Search("Test");

            search.UseInputs(db, s);

            string expected = "SELECT * FROM Test WHERE (DB Test1 LIKE '%S Test1%') AND (DB Test2 LIKE '%S Test2%')";
            string actual = search.GetBuiltQuery();

            Assert.True(actual.Equals(expected));
        }
コード例 #7
0
ファイル: SearchClassTests.cs プロジェクト: trbielec/hospipal
        public void TestSearchPatientWithValidQueryByMultipleExactParamters()
        {
            Patient p1 = new Patient(10000, "SearchFname1", "SearchLname1", new DateTime(), "Test Address", "Test City1", "Test Provice", "TEST", "1111111111", "2222222222", "3333333333");
            p1.Insert();
            p1.Select();

            Patient p2 = new Patient(20000, "SearchFname2", "SearchLname2", new DateTime(), "Test Address", "Test City2", "Test Provice", "TEST", "4444444444", "5555555555", "6666666666");
            p2.Insert();
            p2.Select();

            List<string> db = new List<string>();
            db.Add("fname");
            db.Add("lname");
            db.Add("city");

            List<string> s = new List<string>();
            s.Add("SearchFname1");
            s.Add("SearchLname1");
            s.Add("Test City1");

            Search search = new Search("Patient");
            search.UseInputs(db, s);

            List<Patient> p = Search.SearchPatient(search.GetBuiltQuery());
            //Assert.True(p[0].PatientID == p1.PatientID);

            p1.Delete();
            p2.Delete();
        }
コード例 #8
0
ファイル: SearchClassTests.cs プロジェクト: trbielec/hospipal
        public void TestSearchPatientWithValidQueryByCloseProvice()
        {
            Patient p1 = new Patient(10000, "SearchFname1", "SearchLname1", new DateTime(), "Test Address", "Test City", "Test Provice", "TEST", "1111111111", "2222222222", "3333333333");
            p1.Insert();
            p1.Select();

            Patient p2 = new Patient(20000, "SearchFname2", "SearchLname2", new DateTime(), "Test Address", "Test City", "Test Provice", "TEST", "4444444444", "5555555555", "6666666666");
            p2.Insert();
            p2.Select();

            List<string> db = new List<string>();
            db.Add("province");

            List<string> s = new List<string>();
            s.Add("Test");

            Search search = new Search("Patient");
            search.UseInputs(db, s);

            List<Patient> p = Search.SearchPatient(search.GetBuiltQuery());
            Assert.True(p.Count >= 2);

            p1.Delete();
            p2.Delete();
        }
コード例 #9
0
ファイル: SearchClassTests.cs プロジェクト: trbielec/hospipal
        public void TestSearchEmployeeWithMultipleExactFields()
        {
            int eid1 = Employee.GenerateNextEid();
            Employee e1 = new Employee(eid1, "SearchFname1", "SearchLname1", "Spec1", "Doctor", 100000);
            e1.Insert();

            int eid2 = Employee.GenerateNextEid();
            Employee e2 = new Employee(eid2, "SearchFname2", "SearchLname2", "Spec2", "Nurse", 120000);
            e2.Insert();

            List<string> db = new List<string>();
            db.Add("fname");
            db.Add("lname");
            db.Add("specialty");

            List<string> s = new List<string>();
            s.Add("SearchFname1");
            s.Add("SearchLname1");
            s.Add("Spec1");

            Search search = new Search("Employee");
            search.UseInputs(db, s);

            List<Employee> e = Search.SearchEmployees(search.GetBuiltQuery());
            Assert.True(e[0].Eid == eid1);

            e1.Delete();
            e2.Delete();
        }
コード例 #10
0
ファイル: SearchClassTests.cs プロジェクト: trbielec/hospipal
        public void TestSearchEmployeesWithValidQueryWithOtherSpecialty()
        {
            int eid1 = Employee.GenerateNextEid();
            Employee e1 = new Employee(eid1, "SearchFname1", "SearchLname1", "Spec1", "Doctor", 100000);
            e1.Insert();

            int eid2 = Employee.GenerateNextEid();
            Employee e2 = new Employee(eid2, "SearchFname2", "SearchLname2", "Spec2", "Nurse", 120000);
            e2.Insert();

            List<string> db = new List<string>();
            db.Add("specialty");

            List<string> s = new List<string>();
            s.Add("Spec");

            Search search = new Search("Employee");
            search.UseInputs(db, s);

            List<Employee> e = Search.SearchEmployees(search.GetBuiltQuery());
            Assert.True(e.Count >= 2);

            e1.Delete();
            e2.Delete();
        }
コード例 #11
0
ファイル: SearchClassTests.cs プロジェクト: trbielec/hospipal
        public void TestSearchEmployeesWithValidQueryWithExactType()
        {
            int eid1 = Employee.GenerateNextEid();
            Employee e1 = new Employee(eid1, "SearchFname1", "SearchLname1", "", "Type1", 100000);
            e1.Insert();

            int eid2 = Employee.GenerateNextEid();
            Employee e2 = new Employee(eid2, "SearchFname2", "SearchLname2", "", "Type2", 120000);
            e2.Insert();

            List<string> db = new List<string>();
            db.Add("employee_type");

            List<string> s = new List<string>();
            s.Add("Type1");

            Search search = new Search("Employee");
            search.UseInputs(db, s);

            List<Employee> e = Search.SearchEmployees(search.GetBuiltQuery());
            //Assert.True(e[0].Eid == eid1);

            e1.Delete();
            e2.Delete();
        }
コード例 #12
0
        public void validateInputs()
        {
            Search advancedSearch = new Search("Patient");
            List<string> dbSideVariables = new List<string>();
            List<string> cSideVariables = new List<string>();

            #region Box Checking
            if (!string.IsNullOrWhiteSpace(tbHealthCare.Text))
            {
                cSideVariables.Add(tbHealthCare.Text);
                dbSideVariables.Add("hc_no");
            }
            if (!string.IsNullOrWhiteSpace(tbFName.Text))
            {
                cSideVariables.Add(tbFName.Text);
                dbSideVariables.Add("fname");
            }

            if (!string.IsNullOrWhiteSpace(tbLName.Text))
            {
                cSideVariables.Add(tbLName.Text);
                dbSideVariables.Add("lname");
            }

            if (!(dpDOB.SelectedDate == null))
            {
                cSideVariables.Add(dpDOB.SelectedDate.Value.Day.ToString());
                cSideVariables.Add(dpDOB.SelectedDate.Value.Month.ToString());
                cSideVariables.Add(dpDOB.SelectedDate.Value.Year.ToString());

                dbSideVariables.Add("dob_day");
                dbSideVariables.Add("dob_month");
                dbSideVariables.Add("dob_year");
            }

            if (!string.IsNullOrWhiteSpace(tbAddress.Text))
            {
                cSideVariables.Add(tbAddress.Text);
                dbSideVariables.Add("street_address");
            }

            if (!string.IsNullOrWhiteSpace(tbCity.Text))
            {
                cSideVariables.Add(tbCity.Text);
                dbSideVariables.Add("city");
            }
            if (!string.IsNullOrWhiteSpace(tbProvince.Text))
            {
                cSideVariables.Add(tbProvince.Text);
                dbSideVariables.Add("province");
            }

            if (!string.IsNullOrWhiteSpace(tbPostalCode.Text))
            {
                cSideVariables.Add(tbPostalCode.Text);
                dbSideVariables.Add("postal_code");
            }

            if (!string.IsNullOrWhiteSpace(tbPhoneNumber.Text))
            {
                cSideVariables.Add(tbPhoneNumber.Text);
                dbSideVariables.Add("home_phone_no");
            }
            #endregion

            advancedSearch.UseInputs(dbSideVariables, cSideVariables);

            Patients = Search.SearchPatient(advancedSearch.GetBuiltQuery());
            Patients_DataGrid.DataContext = Patients;
        }