public void SetUp()
 {
     testData = new TestDatabaseManager();
     testData.SetUpDatabase();
     testData.LoadTestData();
     context   = new SqlServerConnectionManager(testData.ConnectionString);
     landmarks = new SqlServerLandmarksRepository(context, testData.LandmarksImagesPath, testData.AudiosPath);
     tours     = new SqlServerToursRepository(context, landmarks, testData.ToursImagesPaths);
 }
        public void ShouldThrowExceptionIfToursDataIsInconsistent()
        {
            Mock <ISqlContext>          fakeContext     = new Mock <ISqlContext>();
            Dictionary <string, object> faultyToursData = new Dictionary <string, object>();

            faultyToursData.Add("ID", 1);
            faultyToursData.Add("TITLE", "");//incorrect.
            faultyToursData.Add("DESCRIPTION", "description 1");
            faultyToursData.Add("CATEGORY", "CULTURAL");
            faultyToursData.Add("IMAGE_EXTENSION", ".jpg");
            ICollection <Dictionary <string, object> > fakeReturn = new List <Dictionary <string, object> >()
            {
                faultyToursData
            };

            fakeContext.Setup(c => c.ExcecuteRead(It.IsAny <string>())).Returns(fakeReturn);
            tours = new SqlServerToursRepository(fakeContext.Object, landmarks, testData.ToursImagesPaths);
            tours.GetById(1);
        }