|
public GetData ( |
||
| command | ||
| return | System.Data.SqlClient.SqlDataReader | |
public IList <Template> Load()
{
const string query = "SELECT * FROM Template";
var command = new SqlCommand(query);
var reader = _databaseProvider.GetData(command);
return(GetTemplates(reader));
}
public IList <Person> Load()
{
const string query = "SELECT * FROM Persons";
var command = new SqlCommand(query);
var reader = _databaseProvider.GetData(command);
return(GetPersons(reader));
}
public IList <Person> Load()
{
const string query = "SELECT * FROM Persons";
var command = new SqlCommand(query);
var stopwtach = new Stopwatch();
stopwtach.Start();
SqlDataReader reader = _databaseProvider.GetData(command);
stopwtach.Stop();
HospitalLogger.LogInfo("GetData method execution time: {0}", stopwtach.Elapsed.ToString());
return(GetPersons(reader));
}
public IList <Analysis> Load(Person person)
{
const string query = "SELECT Analysis, AnalysisId FROM Analysis WHERE PersonId = @PersonId";
var command = new SqlCommand(query);
command.Parameters.AddWithValue("@PersonId", person.Id);
SqlDataReader reader = _databaseProvider.GetData(command);
return(GetAnalyzes(reader));
}
