Пример #1
0
        public bool InsertMovie(string name, string storageLocation, DateTime releaseDate, string genre, int runTimeinMinutes, decimal budget, decimal revenue, string homePage, string overview, string castDetails)
        {
            using (var db = new MyMediaDBEntities())
            {
                var movie = new Movie()
                {
                    Name            = name,
                    StorageLocation = storageLocation,
                    ReleaseDate     = releaseDate,
                    Genre           = genre,
                    RunTimeMinutes  = runTimeinMinutes,
                    Budget          = budget,
                    Revenue         = revenue,
                    HomePage        = homePage,
                    Overview        = overview,
                    CastDetails     = castDetails
                };

                db.Entry(movie).State = EntityState.Added;

                db.Movies.Add(movie);

                int result = db.SaveChanges();

                if (result > 0)
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
        }
Пример #2
0
        public bool UpdateMovie(int id, string name, string storageLocation, DateTime releaseDate, string genre, int runTimeinMinutes, decimal budget, decimal revenue, string homePage, string overview, string castDetails)
        {
            using (var db = new MyMediaDBEntities())
            {
                var movie = new Movie {
                    Id = id
                };

                movie.Name            = name;
                movie.StorageLocation = storageLocation;
                movie.ReleaseDate     = releaseDate;
                movie.Genre           = genre;
                movie.RunTimeMinutes  = runTimeinMinutes;
                movie.Budget          = budget;
                movie.Revenue         = revenue;
                movie.HomePage        = homePage;
                movie.Overview        = overview;
                movie.CastDetails     = castDetails;

                db.Entry(movie).State = EntityState.Modified;

                int result = db.SaveChanges();

                if (result > 0)
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
        }
Пример #3
0
        public bool DeleteMovie(int id)
        {
            using (var db = new MyMediaDBEntities())
            {
                var movie = new Movie {
                    Id = id
                };

                db.Entry(movie).State = EntityState.Deleted;

                int result = db.SaveChanges();

                if (result > 0)
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
        }