public void TestFindAll()
        {
            IPerformanceDao     dao      = DALFactory.CreatePerformanceDao(DALFactory.CreateDatabase());
            IList <Performance> entities = dao.findAll();

            Assert.AreEqual(entities.Count, 2);
        }
        public void TestFindAll()
        {
            ICatagoryDao     dao      = DALFactory.CreateCatagoryDao(DALFactory.CreateDatabase());
            IList <Catagory> entities = dao.findAll();

            Assert.AreEqual(entities.Count, 2);
        }
Ejemplo n.º 3
0
        public void TestFindAll()
        {
            IArtistDao     dao      = DALFactory.CreateArtistDao(DALFactory.CreateDatabase());
            IList <Artist> entities = dao.findAll();

            Assert.AreEqual(entities.Count, 3);
        }
        public void TestFindById()
        {
            ICatagoryDao dao = DALFactory.CreateCatagoryDao(DALFactory.CreateDatabase());
            Catagory     cat = dao.findById(1);

            Assert.AreEqual(cat.Id, 1);
            Assert.AreEqual(cat.Name, "Klassik");
        }
Ejemplo n.º 5
0
        public void TestFindById()
        {
            IArtistDao dao    = DALFactory.CreateArtistDao(DALFactory.CreateDatabase());
            Artist     artist = dao.findById(1);

            Assert.AreEqual(artist.Id, 1);
            Assert.AreEqual(artist.Name, "Larry Page");
        }
Ejemplo n.º 6
0
        public void TestFindAll()
        {
            IDatabase    db       = DALFactory.CreateDatabase();
            IUserDao     dao      = DALFactory.CreateUserDao(db);
            IList <User> entities = dao.findAll();

            Assert.AreEqual(entities.Count, 2);
        }
        public void TestFindById()
        {
            IPerformanceDao dao         = DALFactory.CreatePerformanceDao(DALFactory.CreateDatabase());
            Performance     performance = dao.findById(1);

            Assert.AreEqual(performance.Id, 1);
            Assert.IsFalse(performance.Canceld);
        }
        public void TestFindById()
        {
            IDatabase db  = DALFactory.CreateDatabase();
            IVenueDao dao = DALFactory.CreateVenueDao(db);
            Venue     v   = dao.findById(1);

            Assert.AreEqual(v.Id, 1);
            Assert.AreEqual(v.Description, "Stage1");
        }
Ejemplo n.º 9
0
        public void TestFindById()
        {
            IDatabase db  = DALFactory.CreateDatabase();
            IUserDao  dao = DALFactory.CreateUserDao(db);
            User      u   = dao.findById(1);

            Assert.AreEqual(u.Id, 1);
            Assert.AreEqual(u.Email, "*****@*****.**");
        }
Ejemplo n.º 10
0
        public void TestFindByUniqueProperty()
        {
            IArtistDao   dao    = DALFactory.CreateArtistDao(DALFactory.CreateDatabase());
            PropertyInfo info   = typeof(Artist).GetProperty("Email");
            Artist       artist = dao.findByUniqueProperty(info, "*****@*****.**");

            Assert.AreEqual(artist.Id, 1);
            Assert.AreEqual(artist.Email, "*****@*****.**");
            Assert.AreEqual(artist.Name, "Larry Page");
        }
Ejemplo n.º 11
0
        public void TestFindByUniqueProperty()
        {
            IDatabase    db   = DALFactory.CreateDatabase();
            IUserDao     dao  = DALFactory.CreateUserDao(db);
            PropertyInfo info = typeof(User).GetProperty("Email");
            User         u    = dao.findByUniqueProperty(info, "*****@*****.**");

            Assert.AreEqual(u.Email, "*****@*****.**");
            Assert.AreEqual(u.Id, 1);
        }
        public void TestUpdate()
        {
            ICatagoryDao dao = DALFactory.CreateCatagoryDao(DALFactory.CreateDatabase());
            Catagory     cat = dao.findById(1);

            cat.Name = "Test";
            dao.Update(cat);

            Catagory result = dao.findById(1);

            Assert.AreEqual(result.Name, cat.Name);
        }
Ejemplo n.º 13
0
        public void TestUpdate()
        {
            IArtistDao dao    = DALFactory.CreateArtistDao(DALFactory.CreateDatabase());
            Artist     artist = dao.findById(1);

            artist.Email = "*****@*****.**";
            dao.Update(artist);

            Artist result = dao.findById(1);

            Assert.AreEqual(result.Email, artist.Email);
        }
Ejemplo n.º 14
0
        public void TestUpdate()
        {
            IDatabase db  = DALFactory.CreateDatabase();
            IUserDao  dao = DALFactory.CreateUserDao(db);
            User      u   = dao.findById(1);

            u.FirstName = "Larry";
            dao.Update(u);
            User result = dao.findById(1);

            Assert.AreEqual(result.FirstName, "Larry");
        }
Ejemplo n.º 15
0
        public void TestFindByIdAndCheckFetchCatagory()
        {
            IArtistDao dao    = DALFactory.CreateArtistDao(DALFactory.CreateDatabase());
            Artist     artist = dao.findById(1);

            Assert.AreEqual(artist.Id, 1);
            Assert.AreEqual(artist.Name, "Larry Page");

            ICatagoryDao catDao = DALFactory.CreateCatagoryDao(DALFactory.CreateDatabase());
            Catagory     cat    = catDao.findById(1);

            Assert.AreEqual(artist.Catagory.Id, cat.Id);
        }
Ejemplo n.º 16
0
        private static void CreateCatagories()
        {
            Console.WriteLine("Insert Catagories ");
            ICatagoryDao catagoryDao = DALFactory.CreateCatagoryDao(DALFactory.CreateDatabase());

            for (int i = 1; i <= 10; i++)
            {
                Catagory c = new Catagory();
                c.Name        = "Catagory " + i;
                c.Description = "Catagory Description for " + i;
                catagoryDao.Insert(c);
            }
        }
Ejemplo n.º 17
0
        public void TestUpdate()
        {
            IDatabase db  = DALFactory.CreateDatabase();
            IVenueDao dao = DALFactory.CreateVenueDao(db);
            Venue     v   = dao.findById(1);

            v.Description = "TEST-DESCRIPTION";

            dao.Update(v);
            Venue result = dao.findById(1);

            Assert.AreEqual(result.Description, v.Description);
        }
Ejemplo n.º 18
0
        static void Main(string[] args)
        {
            //string connectionString = ConfigurationManager.ConnectionStrings["PhoneTariffConnectionString"].ConnectionString;
            //IDatabase database = new Database(connectionString);
            //ITariffDao tariffDao = new TariffDao(database);

            IDatabase  database  = DALFactory.CreateDatabase();
            ITariffDao tariffDao = DALFactory.CreateTariffDao(database);

            var tariff = tariffDao.FindById("A1");

            Console.WriteLine(tariff.BasicFee);
            Console.ReadKey();
        }
Ejemplo n.º 19
0
        public void TestInsert()
        {
            IDatabase db  = DALFactory.CreateDatabase();
            IUserDao  dao = DALFactory.CreateUserDao(db);
            User      u   = new User();

            u.Email     = "*****@*****.**";
            u.FirstName = "Unit Test";
            u.LastName  = "Unit Test";
            u.Password  = "******";
            dao.Insert(u);
            PropertyInfo info   = typeof(User).GetProperty("Email");
            User         result = dao.findByUniqueProperty(info, "*****@*****.**");

            Assert.AreEqual(result.Email, "*****@*****.**");
        }
        public void TestInsert()
        {
            Catagory cat = new Catagory();

            cat.Name        = "UNIT-TEST";
            cat.Description = "asdf";

            ICatagoryDao dao = DALFactory.CreateCatagoryDao(DALFactory.CreateDatabase());

            dao.Insert(cat);
            PropertyInfo info   = typeof(Catagory).GetProperty("Name");
            Catagory     result = dao.findByUniqueProperty(info, "UNIT-TEST");

            Assert.AreEqual(result.Name, cat.Name);
            Assert.AreEqual(result.Description, cat.Description);
        }
        public void TestUpdate()
        {
            IPerformanceDao dao         = DALFactory.CreatePerformanceDao(DALFactory.CreateDatabase());
            Performance     performance = dao.findById(1);
            IArtistDao      artistDao   = DALFactory.CreateArtistDao(DALFactory.CreateDatabase());
            Artist          artist      = artistDao.findById(2);

            performance.Artist      = artist;
            performance.StagingTime = DateTime.UtcNow;
            dao.Update(performance);

            Performance result = dao.findById(1);

            //Assert.AreEqual(result.StagingTime, performance.StagingTime);
            Assert.AreEqual(result.Artist.Id, performance.Artist.Id);
        }
Ejemplo n.º 22
0
        public void TestInsert()
        {
            IDatabase db  = DALFactory.CreateDatabase();
            IVenueDao dao = DALFactory.CreateVenueDao(db);
            Venue     v   = new Venue();

            v.Description      = "UNIT-TEST";
            v.Latitude         = 2;
            v.Longitude        = 2;
            v.ShortDescription = "NO";
            v.Address          = "TestAddress";

            dao.Insert(v);

            Assert.AreEqual(dao.findAll().Count, 3);
        }
Ejemplo n.º 23
0
        private static void CreateArtists()
        {
            Console.WriteLine("Insert Artists ");
            Random       r = new Random();
            RootObject   generatedEntries = FetchPersons();
            IArtistDao   dao         = DALFactory.CreateArtistDao(DALFactory.CreateDatabase());
            ICatagoryDao catagoryDao = DALFactory.CreateCatagoryDao(DALFactory.CreateDatabase());

            generatedEntries.results.ToList().ForEach(x => {
                Console.WriteLine(x.user.name.first);
                Artist artist   = new Artist();
                artist.Catagory = catagoryDao.findById(r.Next(1, 10));
                artist.Name     = x.user.name.first + " " + x.user.name.last;
                artist.Email    = x.user.email;
                artist.Country  = "AUT";
                artist.Picture  = GetBase64EncodedImageFromUrl(x.user.picture.thumbnail);
                dao.Insert(artist);
                Console.WriteLine("Inserted ");
            });
        }
        public void TestInsert()
        {
            Performance performance = new Performance();
            IArtistDao  artistDao   = DALFactory.CreateArtistDao(DALFactory.CreateDatabase());
            Artist      artist      = artistDao.findById(1);

            IVenueDao venueDao = DALFactory.CreateVenueDao(DALFactory.CreateDatabase());
            Venue     venue    = venueDao.findById(1);

            performance.Artist      = artist;
            performance.Venue       = venue;
            performance.StagingTime = DateTime.Now;

            IPerformanceDao dao = DALFactory.CreatePerformanceDao(DALFactory.CreateDatabase());

            dao.Insert(performance);

            IList <Performance> result = dao.findAll();

            Assert.AreEqual(result.Count, 3);
        }
Ejemplo n.º 25
0
        private static void CreateVenues()
        {
            Console.WriteLine("Insert Venues ");

            Random    rand     = new Random();
            IVenueDao venueDao = DALFactory.CreateVenueDao(DALFactory.CreateDatabase());

            for (int i = 1; i <= 60; i++)
            {
                Venue v = new Venue();
                v.Address          = "My Random Place " + i;
                v.Description      = "This is Random Stage No " + i;
                v.ShortDescription = "Random Stage " + i;
                v.Latitude         = (int)(48.30613 * 1000000);
                v.Longitude        = (int)(14.286813 * 1000000);
                v.Latitude         = v.Latitude + rand.Next(1, 100);
                v.Longitude        = v.Longitude + rand.Next(1, 100);

                venueDao.Insert(v);
            }
        }
Ejemplo n.º 26
0
        public void TestInsert()
        {
            PropertyInfo info   = typeof(Artist).GetProperty("Email");
            Artist       artist = new Artist();

            artist.Email   = "*****@*****.**";
            artist.Name    = "UnitTestArtist";
            artist.Link    = "I do not have any Link";
            artist.Country = "AUT";

            IArtistDao dao = DALFactory.CreateArtistDao(DALFactory.CreateDatabase());

            dao.Insert(artist);

            Artist result = dao.findByUniqueProperty(info, "*****@*****.**");

            Assert.AreEqual(result.Email, artist.Email);
            Assert.AreEqual(result.Name, artist.Name);
            Assert.AreEqual(result.Link, artist.Link);
            Assert.AreEqual(result.Country, artist.Country);
        }
Ejemplo n.º 27
0
        private static void CreatePerformances()
        {
            Console.WriteLine("Insert Performances ");
            IVenueDao       venueDao       = DALFactory.CreateVenueDao(DALFactory.CreateDatabase());
            IPerformanceDao performanceDao = DALFactory.CreatePerformanceDao(DALFactory.CreateDatabase());
            IArtistDao      artistDao      = DALFactory.CreateArtistDao(DALFactory.CreateDatabase());
            int             year           = 2016;
            int             month          = 01;
            int             day            = 23;

            for (int i = 0; i < 3; i++)
            {
                int count  = 1;
                int hour   = 14;
                int min    = 00;
                int second = 00;
                for (int j = 1; j <= 40; j++)
                {
                    count++;
                    if (count == 10)
                    {
                        hour  = hour + 2;
                        count = 1;
                    }
                    DateTime dt = new DateTime(year, month, day, hour, min, second);

                    Venue       venue  = venueDao.findById(j);
                    Artist      artist = artistDao.findById(j);
                    Performance p      = new Performance();
                    p.Artist      = artist;
                    p.Venue       = venue;
                    p.StagingTime = dt;
                    performanceDao.Insert(p);
                }
                day++;
            }
        }
Ejemplo n.º 28
0
 public AuthenticationService()
 {
     database = DALFactory.CreateDatabase();
 }
 public AdministrationServices()
 {
     database              = DALFactory.CreateDatabase();
     queryService          = ServiceFactory.GetQueryService();
     authenticationService = ServiceFactory.GetAuthenticationService();
 }
Ejemplo n.º 30
0
 public QueryService()
 {
     database = DALFactory.CreateDatabase();
 }