示例#1
0
        private static void TestArtist(IDatabase db, DALFactory dalFactory)
        {
            Console.WriteLine("*************************************");
            Console.WriteLine("ARTIST TEST");

            IArtistDAO artistDAO = dalFactory.CreateArtistDAO(db);

            Console.WriteLine("\nAll artists:");
            foreach (var artist in artistDAO.GetAll()) {
                Console.WriteLine(artist);
            }

            Console.WriteLine("\nArtist with ID=1:");
            Console.WriteLine(artistDAO.GetById(1));

            Artist artist1 = new Artist() {
                Name = "Stefan the Rösch",
                CategoryId = 1,
                CountryId = 25
            };
            Artist newArtist = artistDAO.Create(artist1);
            Console.WriteLine("New Artist: " + newArtist);
            Console.WriteLine("Inserted Artist: " + artist1);

            artist1.Name = "Christoph the Wurst";
            artistDAO.Update(artist1);
            Console.WriteLine("Updated artist: " + artist1);

            artistDAO.Delete(artist1);
            Console.WriteLine("\nArtist deleted");
        }
示例#2
0
 /// <summary>
 /// Get a DALFactory instance
 /// </summary>
 /// <returns>An instance of DALFactory (singleton)</returns>
 public static DALFactory GetInstance()
 {
     if (instance == null) {
         instance = new DALFactory();
     }
     return instance;
 }
示例#3
0
 public BusinessLogic(DALFactory dalFactory, IMailService ms, IPdfMaker pdf)
 {
     this.db = dalFactory.CreateDatabase();
     this.dalFactory = dalFactory;
     this.ms = ms;
     this.pdf = pdf;
 }
示例#4
0
        private static void TestCategory(IDatabase db, DALFactory dalFactory)
        {
            Console.WriteLine("*************************************");
            Console.WriteLine("CATEGORY TEST");

            ICategoryDAO categoryDAO = dalFactory.CreateCategoryDAO(db);

            Console.WriteLine("\nAll categories:");
            foreach (var category in categoryDAO.GetAll()) {
                Console.WriteLine(category);
            }

            Console.WriteLine("\nCategory with ID=1:");
            Console.WriteLine(categoryDAO.GetById(1));
        }
示例#5
0
 public BusinessLogic(DALFactory dalFactory)
 {
     this.db = dalFactory.CreateDatabase();
     this.dalFactory = dalFactory;
     var appSettings = ConfigurationManager.AppSettings;
     var smtpServer = appSettings["smtpServer"];
     var mailAddress = new MailAddress(appSettings["mailAddress"], appSettings["sender"]);
     var user = appSettings["user"];
     var pwd = appSettings["pwd"];
     var port = int.Parse(appSettings["port"]);
     ms = new MailService(smtpServer, port, user, pwd, mailAddress);
     pdfPath = appSettings["pdfPath"];
     pdfName = appSettings["pdfName"];
     pdf = new PdfMaker(pdfPath, pdfName);
 }
示例#6
0
        private static void TestArea(IDatabase db, DALFactory dalFactory)
        {
            Console.WriteLine("*************************************");
            Console.WriteLine("AREA TEST");

            IAreaDAO areaDAO = dalFactory.CreateAreaDAO(db);

            Console.WriteLine("\nAll areas:");
            foreach (var area in areaDAO.GetAll()) {
                Console.WriteLine(area);
            }

            Console.WriteLine("\nArea with ID=1:");
            Area area1 = areaDAO.GetById(1);
            Console.WriteLine(area1);

            Area area2 = new Area() {
                Name = "Rathausplatz"
            };
        }
示例#7
0
        private static void TestVenue(IDatabase db, DALFactory dalFactory)
        {
            Console.WriteLine("*************************************");
            Console.WriteLine("VENUE TEST");

            IVenueDAO venueDAO = dalFactory.CreateVenueDAO(db);

            Console.WriteLine("\nAll VENUES:");
            foreach (var venue in venueDAO.GetAll()) {
                Console.WriteLine(venue);
            }

            Console.WriteLine("\nVENUE with ID=1:");
            Console.WriteLine(venueDAO.GetById(1));

            Venue venue1 = new Venue() {
                AreaId = 1,
                Description = "TestVenue",
                ShortDescription = "TV",
                Latitude = 0.0f,
                Longitude = 0.0f
            };
            Venue newVenue = venueDAO.Create(venue1);
            Console.WriteLine("New VENUE: " + newVenue);
            Console.WriteLine("Inserted VENUE: " + newVenue);

            venue1.Description = "Winzerhof Wurst";
            venueDAO.Update(venue1);
            Console.WriteLine("Updated VENUE: " + venue1);
        }
示例#8
0
        private static void TestUser(IDatabase db, DALFactory dalFactory)
        {
            Console.WriteLine("*************************************");
            Console.WriteLine("ARTIST TEST");

            IUserDAO userDAO = dalFactory.CreateUserDAO(db);

            Console.WriteLine("\nAll users:");
            foreach (var user in userDAO.GetAll()) {
                Console.WriteLine(user);
            }

            Console.WriteLine("\nUser with ID=1:");
            Console.WriteLine(userDAO.GetById(1));
        }
示例#9
0
        private static void TestPerformance(IDatabase db, DALFactory dalFactory)
        {
            Console.WriteLine("*************************************");
            Console.WriteLine("PERFORMANCE TEST");

            IPerformanceDAO performanceDAO = dalFactory.CreatePerformanceDAO(db);

            Console.WriteLine("\nAll performances:");
            foreach (var performance in performanceDAO.GetAll()) {
                Console.WriteLine(performance);
            }

            Console.WriteLine("\nPerformance with ID=1:");
            Console.WriteLine(performanceDAO.GetById(1));

            Performance performance1 = new Performance() {
                SpectacledayTimeSlot = 1,
                ArtistId = 1
            };
            Performance newPerformance = performanceDAO.Create(performance1);
            Console.WriteLine("New Artist: " + newPerformance);
            Console.WriteLine("Inserted Artist: " + newPerformance);

            newPerformance.ArtistId = 3;
            performanceDAO.Update(newPerformance);
            Console.WriteLine("Updated performance: " + newPerformance);

            performanceDAO.Delete(performance1);
            Console.WriteLine("\nPerformance deleted");
        }
示例#10
0
        private static void TestCountry(IDatabase db, DALFactory dalFactory)
        {
            Console.WriteLine("*************************************");
            Console.WriteLine("COUNTY TEST");

            ICountryDAO countryDAO = dalFactory.CreateCountryDAO(db);

            Console.WriteLine("\nAll countries:");
            foreach (var country in countryDAO.GetAll()) {
                Console.WriteLine(country);
            }

            Console.WriteLine("\nCountry with ID=1:");
            Console.WriteLine(countryDAO.GetById(1));
        }
示例#11
0
 public void SetUp()
 {
     factory = DALFactory.GetInstance();
     db = factory.CreateDatabase();
 }