public void update_a_corporation()
        {
            //Create corporation

            Connection one = new Connection();

            CorporationRepo repo = new CorporationRepo(new Connection());

            CorporationModel corporation = new CorporationModel();

            corporation.name    = "name";
            corporation.email   = "email";
            corporation.zip     = "3434-kj";
            corporation.address = "address";

            int id = repo.store(corporation);

            corporation.id = id;

            //Give corporation a new name

            corporation.name = "new name!";
            repo.update(corporation);

            one.Connect();
            SqlCommand    sqlCommand = new SqlCommand("select * from corporation where name = 'new name!'", one.getConnection());
            SqlDataReader reader     = sqlCommand.ExecuteReader();

            Assert.AreEqual(true, reader.HasRows);
            one.disConnect();

            repo.destroy(id);
        }
        public void store_and_delete_a_corporation()
        {
            Connection one = new Connection();
            Connection two = new Connection();

            CorporationRepo repo = new CorporationRepo(new Connection());

            //Create corporation

            CorporationModel corporation = new CorporationModel();

            corporation.name    = "name";
            corporation.email   = "email";
            corporation.zip     = "3434-kj";
            corporation.address = "address";

            int id = repo.store(corporation);


            one.Connect();
            SqlCommand    sqlCommand = new SqlCommand("select * from corporation where name = 'name' and email ='email' and zip = '3434-kj' and address = 'address'", one.getConnection());
            SqlDataReader reader     = sqlCommand.ExecuteReader();

            Assert.AreEqual(true, reader.HasRows);
            one.disConnect();

            repo.destroy(id);

            two.Connect();

            //Delete corporation

            SqlCommand    sqlCommandTwo = new SqlCommand("select * from corporation where name = 'name' and email ='email' and zip = '3434-kj' and address = 'address'", two.getConnection());
            SqlDataReader readerTwo     = sqlCommandTwo.ExecuteReader();

            Assert.AreEqual(false, readerTwo.HasRows);
            one.disConnect();
        }