public int GetTotalRowsPatients(Connections connections, HHAXPatientSearch patientSearch) { QueryHHAXPatients _query = new QueryHHAXPatients(); int totalRows = 0; string connectionString = $"Server={connections.ServerName};Database={connections.DatabaseName};User Id={connections.DatabaseUsername};Password={connections.DatabasePassword};"; string queryString = _query.CrateQueryStringCountRowsPatients(patientSearch); using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(queryString, connection); command = _query.EmbedParameters(command, patientSearch); try { connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { totalRows = Convert.ToInt32(reader[0]); } reader.Close(); return(totalRows); } catch (Exception ex) { connection.Close(); Console.WriteLine(ex.ToString()); return(0); } } }
public List <HHAXPatientResult> GetHHAXPatientResults(Connections connections, HHAXPatientSearch patientSearch, Paging paging) { QueryHHAXPatients _query = new QueryHHAXPatients(); string connectionString = $"Server={connections.ServerName};Database={connections.DatabaseName};User Id={connections.DatabaseUsername};Password={connections.DatabasePassword};"; string queryString = _query.CreateQueryStringPatients(patientSearch, paging); using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(queryString, connection); command = _query.EmbedParameters(command, patientSearch); try { List <HHAXPatientResult> results = new List <HHAXPatientResult>(); connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { HHAXPatientResult patientResult = new HHAXPatientResult(); patientResult.SetValuesFromReader(reader); results.Add(patientResult); } reader.Close(); connection.Close(); return(results); } catch (Exception ex) { Console.WriteLine(ex.ToString()); return(null); } finally { connection.Close(); } } }