Пример #1
0
        // POST: Movies/Edit/5
        // To protect from overposting attacks, please enable the specific properties you want to bind to, for
        // more details see https://go.microsoft.com/fwlink/?LinkId=317598.
        //[HttpPost]
        //[ValidateAntiForgeryToken]
        //public ActionResult Edit([Bind(Include = "ID,Title,WeekendRevenure,GrossRevenue,Released,Recommended")] Movie movie)
        //{
        //    if (ModelState.IsValid)
        //    {
        //        db.Entry(movie).State = EntityState.Modified;
        //        db.SaveChanges();
        //        return RedirectToAction("Index");
        //    }
        //    return View(movie);
        //}

        // GET: Movies/Delete/5
        //public ActionResult Delete(int? id)
        //{
        //    if (id == null)
        //    {
        //        return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
        //    }
        //    Movie movie = db.Movies.Find(id);
        //    if (movie == null)
        //    {
        //        return HttpNotFound();
        //    }
        //    return View(movie);
        //}

        // POST: Movies/Delete/5
        //[HttpPost, ActionName("Delete")]
        //[ValidateAntiForgeryToken]
        //public ActionResult DeleteConfirmed(int id)
        //{
        //    Movie movie = db.Movies.Find(id);
        //    db.Movies.Remove(movie);
        //    db.SaveChanges();
        //    return RedirectToAction("Index");
        //}

        protected override void Dispose(bool disposing)
        {
            if (disposing)
            {
                repository.Dispose();
            }
            base.Dispose(disposing);
        }
 protected override void Dispose(bool disposing)
 {
     _movie.Dispose();
 }
Пример #3
0
        static void Main(string[] args)
        {
            using (MyDatabase db = new MyDatabase())
            {
                MovieRepository movieRepo = new MovieRepository();
                var             lista     = movieRepo.GetAll().Where(x => x.Title.Contains("e"));



                foreach (var movie in lista)
                {
                    Console.WriteLine(movie.Title);
                    foreach (var actor in movie.Actors)   // de douleuei
                    {
                        Console.WriteLine(actor.FirstName);
                    }
                }

                Console.WriteLine("wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww");


                var lista2 = movieRepo.GetAll().Where(x => x.Title.Contains("a"));



                foreach (var movie in lista2)
                {
                    Console.WriteLine(movie.Title);
                    foreach (var actor in movie.Actors)
                    {
                        Console.WriteLine(actor.FirstName);
                    }
                }

                movieRepo.Dispose();
                //AUTO gia ton allo tropo Sta Services!!!!!!!!!!1 chack it out
                //giati mporo na anoigokeliso to service opote opote opote goustarw
                //ALLA an eisai LAzy Loading sthn GetAll PREPEI na kanw include(x=>x. ... ) tou les fere kai auto


                ActorRepository actorRepository = new ActorRepository();

                foreach (var item in actorRepository.GetAll())   // de douleuei
                {
                    Console.WriteLine(item.FirstName);
                }

                actorRepository.Dispose();



                //var movies = db.Movies; //san I quirable interfase // tha steilei SQL QUERY STI BASI //zitao ka8e fora apo toservar na mou stelnei thn katallili pliroforia // de me endiaferei gia ena sugkekrimeno query sti basi kai exo para polu RAM
                //foreach (var movie in movies)
                //{
                //    Console.WriteLine("{0,-6}{0,-15}", movie.MovieId, movie.Title);
                //}


                //var movies = db.Movies.ToList(); //simbato me IEnumerable //tha stalei query sti basi poy 8a sou ferei ol aosa xxreiazomai sato run time
                ////tha to xrismopoiiso gia polla//tha ferei osa xreiazomai sto run time
                ////fere mou AUTOO apo ti basi, stoxeuMENA!!!!! me linq



                //Console.WriteLine("====================================");


                //Goldennn.Services.MovieRepository movieRepository = new MovieRepository();
                //var movies1 = movieRepository.GetAll().Where(x => x.Title.Contains("e"));
                ////auti ti stigmi i linq psaxnei sto run, momeory (oxi ston sql server, auto einai allos dromos).


                //foreach (var movie in movies1)
                //{
                //    Console.WriteLine("{0,-6}{0,-15}", movie.MovieId, movie.Title);
                //}


                ////App.PrintMoviess();
                //Console.WriteLine("psakse tainia");
                //string choice = Console.ReadLine();

                //int id;
                //if (Int32.TryParse(choice, out id))
                //{
                //    App.PrintById(2);
                //}
                //else
                //{
                //    App.PrintById(null);
                //}



                ////app.PrintMovies()
                //Movie m = new Movie() { MovieId = 10, Title = "Battleship Potemkin" };
                //movieRepository.Insert(m);

                //App.PrintMovies(); // kai ektipono gt exo ftiaksei auton ton mixanismo

                //Console.WriteLine("=================================================");

                //movieRepository.Insert(m);
                //App.PrintMovies();

                ////app.PrintMovies()
                //Movie m1 = new Movie() { MovieId = 10, Title = "Amelie" };
                //movieRepository.Update(m);

                //App.PrintMovies(); // kai ektipono gt exo ftiaksei auton ton mixanismo

                //Console.WriteLine("=================================================");

                //movieRepository.Insert(m);
                //App.PrintMovies();

                ////app.PrintMovies()
                //Movie m3 = new Movie() { Title = "Lion Kings" };
                //var movie3 = movieRepository.GetById(10);
                //if (!(movie3 is null))
                //{
                //    movie3.Title = m3.Title;
                //}
                //movieRepository.Update(movie3);
                //App.PrintById(10);
                //App.PrintMovies();

                //Console.WriteLine("=========================================");
            }

            Console.ReadKey();
        }