public void TestDBEntertainment() { //Assemble //Act //DBConnection dbc = new DBConnection EntertainmentDB eDB = new EntertainmentDB(); eDB.GetAllEntertainments(); //Assert Assert.AreEqual(1, 1); }
/// <summary> /// Constructer for EntertainmentController /// </summary> public EntertainmentController() { edb = new EntertainmentDB(); }
static void Main(string[] args) { EntertainmentDB edb = new EntertainmentDB(); EntertainmentService es = new EntertainmentService(); EntertainmentAdminService eas = new EntertainmentAdminService(); Service1 ss = new Service1(); SessionDB sDB = new SessionDB(); //List<Entertainment> temp = edb.GetAllEntertainments(); //foreach (Entertainment ent in temp) //{ // Console.WriteLine(ent.Id); // Console.WriteLine(ent.Title); // Console.WriteLine(ent.ReleaseDate); //} //edb.GetPersonalEntertainments(1); List <Entertainment> temp2 = es.FindAllEntertainments(); foreach (Entertainment ent2 in temp2) { Console.WriteLine(ent2.Id); Console.WriteLine(ent2.Title); Console.WriteLine(ent2.ReleaseDate); } //List<Genre> genres = edb.GetAllGenres(); //foreach (Genre genre in genres) //{ // Console.WriteLine(genre.Id); // Console.WriteLine(genre.Name); //} //List<Country> countries = edb.GetAllCountries(); //foreach (Country country in countries) //{ // Console.WriteLine(country.Id); // Console.WriteLine(country.Name); //} //Movie movie = new Movie //{ // Title = "Iron Man 4", // Genre = edb.FindGenreByName("Action"), // Country = edb.FindCountryByName("USA"), // Language = edb.FindLanguageByName("English"), // ReleaseDate = DateTime.Now, // StoryLine = "Something Explode", // FilmingLocation = "New York", // Information = "nice", // //IsMovie = true //}; //eas.StartInsertMovieTransaction(movie); //Movie testmovie = es.GetMovieById(1); //Console.WriteLine(testmovie.Title); Movie findMovie = es.GetMovieById(1); Console.WriteLine(findMovie.Title); Console.WriteLine(findMovie.Country.Name); Console.WriteLine(findMovie.Language.Name); Console.WriteLine(findMovie.Genre.Name); //long ticks = DateTime.Now.Ticks; //byte[] bytes = BitConverter.GetBytes(ticks); //string id = Convert.ToBase64String(bytes).Replace('+', '_').Replace('/', '-').TrimEnd('='); //Console.WriteLine(id); User user = new User { Password = "******", UserName = "******" }; User u = ss.LoginConfirmation(user); Console.WriteLine(u.Id); Console.WriteLine(u.Session.Session_id); Session sessiondb = sDB.FindSession(1); Session session = new Session { Id = sessiondb.Id, Session_id = sessiondb.Session_id }; User user1 = new User { Id = 1, Session = session }; Comment comment = new Comment { Entertainment_Id = 1, Message = "Awwww YEAH!", User = user1 }; es.InsertComment(comment); }