public List <AnimalsResponse> PobierzDaneZwierzat(string sortBy)
{
List <AnimalsResponse> list = new List <AnimalsResponse>();
using (var client = new SqlConnection("Data Source = db-mssql; Initial Catalog = s18445; Integrated Security = True"))
using (var com = new SqlCommand())
{
com.Connection = client;
client.Open();
//usunalem sortowanie
com.CommandText = $"SELECT Name, Type, AdmissionDate, LastName FROM Animal, Owner WHERE Animal.IdOwner = Owner.IdOwner ORDER By {sortBy}";
var dr = com.ExecuteReader();
while (dr.Read())
{
var animal = new AnimalsResponse();
{
animal.Name = dr["Name"].ToString();
animal.Type = dr["Type"].ToString();
animal.AdmissionDate = DateTime.Parse(dr["AdmissionDate"].ToString());
animal.LastName = dr["LastName"].ToString();
};
list.Add(animal);
}
}
return(list);
}
public List <AnimalsResponse> GetAnimals(string sortBy, string ascDesc)
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
using (SqlCommand command = new SqlCommand())
{
command.Connection = connection;
connection.Open();
command.Parameters.AddWithValue("sortBy", sortBy);
command.Parameters.AddWithValue("asc", ascDesc);
command.CommandText = "SELECT * FROM Animal ORDER BY name asc";
SqlDataReader reader = command.ExecuteReader();
List <AnimalsResponse> animalResponse = new List <AnimalsResponse>();
while (reader.Read())
{
AnimalsResponse response = new AnimalsResponse();
response.Name = reader[1].ToString();
response.AnimalType = reader[2].ToString();
response.DateOfAdmission = DateTime.Parse(reader[3].ToString());
response.LastNameOfOwner = reader[4].ToString();
animalResponse.Add(response);
}
return(animalResponse);
}
}
