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); } }