예제 #1
0
        public async Task <ActionResult> Create([Bind(Include = "MovieId,Title,Length,Price,Amount,Date")] Movie movie)
        {
            if (ModelState.IsValid)
            {
                db.Movies.Add(movie);
                await db.SaveChangesAsync();

                return(RedirectToAction("Index"));
            }

            return(View(movie));
        }
예제 #2
0
        public static void addNewCartToDB(int userId, int movieId)
        {
            var  db      = new MovieStoreEntities();
            Cart newCart = new Cart {
                UserId = userId, MovieId = movieId, Count = 1
            };
            var currCart = db.Carts.SqlQuery("select * from carts where dbo.Carts.UserId = {0} and dbo.Carts.MovieId = {1}", userId, movieId);

            if (currCart.ToList().Count > 0)
            {
                //meaning its already exist
                db.Database.ExecuteSqlCommand("UPDATE dbo.Carts SET Count = Count+1 WHERE dbo.Carts.UserId = {0} and dbo.Carts.MovieId = {1} ", userId, movieId);
            }
            else
            {
                //meaning its a new cart.
                db.Carts.Add(newCart);
            }
            db.SaveChangesAsync();
        }