コード例 #1
0
        public static List <Amazing_charts_sample_program_Patient_Format> getFirstName1(List <Amazing_charts_sample_program_Patient_Format> dataSet, Patient _patient)
        {
            string query = "SELECT * from credentials where first_name  like '" + _patient.FirstName + "%'";

            if (_patient.LastName.Length > 0)
            {
                query += " AND last_name like '" + _patient.LastName + "%'";
            }
            if (_patient.DateOfBirth.Length > 0)
            {
                query += " AND date_of_birth like '" + _patient.DateOfBirth + "%'";
            }
            var response = new FirstNameClass().PerformQuery(query);

            if (response.hasErrors == true)
            {
                return(dataSet);
            }
            int index = 0;

            while (response.reader.Read())
            {
                Patient patient = new Patient();
                patient.FirstName   = response.reader["first_name"].ToString();
                patient.LastName    = response.reader["last_name"].ToString();
                patient.DateOfBirth = response.reader["date_of_birth"].ToString();
                patient.PhoneNumber = response.reader["phone"].ToString();
                string[] tempDate = Helper_Classes_namespace.HelperClass.getSystemDateTime().Date.ToString().Split(' ');
                patient.Age = Helper_Classes_namespace.HelperClass.getTotAge(patient.DateOfBirth, tempDate[0]);
                dataSet.Insert(index, patient);
                index++;
            }
            Helper_Classes_namespace.DataBaseHelperClass.ClosePerformQuery();
            return(new FirstNameClass().QuickSortNow(dataSet, 0, dataSet.Count - 1));
        }