Example #1
0
        public void GetAllProgressesTest()
        {
            ProgressRepository repository = new ProgressRepository(resConnect);
            List <Progress>    loadList   = new List <Progress>();
            string             query      = "SELECT *  from dbo.Progress";

            using (SqlConnection connection =
                       new SqlConnection(resConnect))
            {
                SqlCommand command = new SqlCommand(query, connection);

                connection.Open();
                SqlDataReader reader = command.ExecuteReader();

                while (reader.Read())
                {
                    loadList.Add(
                        new Progress(
                            idProgress: (int)reader[0],
                            statusProgress: (string)reader[1]
                            )
                        );
                }
                reader.Close();
            }

            int count = repository.GetAllProgresses().Count;

            Assert.AreEqual(count, loadList.Count);
        }