Exemplo n.º 1
0
        public DvdDetails Insert(DvdDetails dvd)
        {
            using (var cn = new SqlConnection(Settings.GetConnectionString()))
            {
                SqlCommand cmd = new SqlCommand("DvdInsert", cn);
                cmd.CommandType = CommandType.StoredProcedure;

                SqlParameter param = new SqlParameter("@DvdID", SqlDbType.Int);
                param.Direction = ParameterDirection.Output;
                cmd.Parameters.Add(param);

                cmd.Parameters.AddWithValue("@Title", dvd.Title);
                cmd.Parameters.AddWithValue("@Year", dvd.Year);
                cmd.Parameters.AddWithValue("@RatingValue", dvd.RatingValue);
                cmd.Parameters.AddWithValue("@DirectorName", dvd.DirectorName);
                cmd.Parameters.AddWithValue("@NoteInfo", dvd.Note);
                //cmd.Parameters.AddWithValue("@ReleaseID", dvd.ReleaseID);
                //cmd.Parameters.AddWithValue("@RatingID", dvd.RatingID);
                //cmd.Parameters.AddWithValue("@DirectorID", dvd.DirectorID);

                cn.Open();
                cmd.ExecuteNonQuery();

                dvd.DvdID = (int)param.Value;
            }

            return(dvd);
        }
Exemplo n.º 2
0
        public DvdDetails Update(DvdDetails dvd)
        {
            using (var context = new DvdContextModel())
            {
                var idParameter = new SqlParameter
                {
                    ParameterName = "@DvdID", SqlDbType = SqlDbType.Int, Value = dvd.DvdID
                };
                var titleParameter = new SqlParameter
                {
                    ParameterName = "@Title", SqlDbType = SqlDbType.VarChar, Value = dvd.Title
                };
                var yearParameter = new SqlParameter
                {
                    ParameterName = "@Year", SqlDbType = SqlDbType.Int, Value = dvd.Year
                };
                var directorParameter = new SqlParameter
                {
                    ParameterName = "@DirectorName", SqlDbType = SqlDbType.VarChar, Value = dvd.DirectorName
                };
                var ratingParameter = new SqlParameter
                {
                    ParameterName = "@RatingValue", SqlDbType = SqlDbType.VarChar, Value = dvd.RatingValue
                };
                var noteParameter = new SqlParameter
                {
                    ParameterName = "@Note", SqlDbType = SqlDbType.VarChar, Value = dvd.Note
                };

                context.Database.SqlQuery <DvdDetails>("DvdUpdate @DvdID, @Title, @Year, @DirectorName, @RatingValue, @Note", idParameter, titleParameter, yearParameter, directorParameter, ratingParameter, noteParameter).SingleOrDefault();
            }

            return(dvd);
        }
Exemplo n.º 3
0
        public void ADOCanEditDvd()
        {
            var repo     = new DvdRepoADO();
            var dvdToAdd = new DvdDetails();

            dvdToAdd.Title        = "Test";
            dvdToAdd.Year         = 2020;
            dvdToAdd.Note         = "Test, test";
            dvdToAdd.DirectorName = "Tester";
            dvdToAdd.RatingValue  = "X";
            //dvdToAdd.DirectorID = 15;
            //dvdToAdd.RatingID = 15;
            //dvdToAdd.ReleaseID = 15;

            repo.Insert(dvdToAdd);

            dvdToAdd.Title        = "Test2";
            dvdToAdd.Year         = 2022;
            dvdToAdd.Note         = "Test, test2";
            dvdToAdd.DirectorName = "Tester2";
            dvdToAdd.RatingValue  = "X2";

            repo.Update(dvdToAdd);

            Assert.AreEqual(7, dvdToAdd.DvdID);
            Assert.AreEqual("Test2", dvdToAdd.Title);
            Assert.AreEqual(2022, dvdToAdd.Year);
            Assert.AreEqual("Tester2", dvdToAdd.DirectorName);
            Assert.AreEqual("X2", dvdToAdd.RatingValue);
            Assert.AreEqual("Test, test2", dvdToAdd.Note);
        }
Exemplo n.º 4
0
        public void ADOCanDeleteDvd()
        {
            var repo     = new DvdRepoADO();
            var dvdToAdd = new DvdDetails();

            dvdToAdd.Title        = "Test";
            dvdToAdd.Year         = 2020;
            dvdToAdd.Note         = "Test, test";
            dvdToAdd.DirectorName = "Tester";
            dvdToAdd.RatingValue  = "X";
            //dvdToAdd.DirectorID = 15;
            //dvdToAdd.RatingID = 15;
            //dvdToAdd.ReleaseID = 15;

            repo.Insert(dvdToAdd);

            var loaded = repo.GetByID(7);

            Assert.IsNotNull(loaded);

            repo.Delete(7);
            loaded = repo.GetByID(7);

            Assert.IsNull(loaded);
        }
Exemplo n.º 5
0
        public IHttpActionResult Update(UpdateDvdRequest request)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            var repo = DvdRepoFactory.GetRepository();

            DvdDetails dvd = repo.GetByID(request.dvdId);

            if (dvd == null)
            {
                return(NotFound());
            }

            dvd.Title        = request.title;
            dvd.Year         = request.realeaseYear;
            dvd.DirectorName = request.director;
            dvd.RatingValue  = request.rating.ToUpper();
            dvd.Note         = request.notes;

            repo.Update(dvd);
            return(Ok(dvd));
        }
Exemplo n.º 6
0
        public ActionResult DeleteConfirmed(int id)
        {
            DvdDetails dvdDetails = db.DvdDetails.Find(id);

            db.DvdDetails.Remove(dvdDetails);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
Exemplo n.º 7
0
 public ActionResult Edit([Bind(Include = "DvdId,DvdTitle,DvdDescription,TotalDvdCopies,ReleaseDate,DateAdded,AgeRestiriction,Studio,Producer,Cast")] DvdDetails dvdDetails)
 {
     if (ModelState.IsValid)
     {
         db.Entry(dvdDetails).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(dvdDetails));
 }
Exemplo n.º 8
0
        public IHttpActionResult Delete(int dvdId)
        {
            DvdDetails dvd = DvdRepoFactory.GetRepository().GetByID(dvdId);

            if (dvd == null)
            {
                return(NotFound());
            }

            DvdRepoFactory.GetRepository().Delete(dvdId);
            return(Ok());
        }
Exemplo n.º 9
0
        public IHttpActionResult Get(int dvdId)
        {
            DvdDetails dvd = DvdRepoFactory.GetRepository().GetByID(dvdId);

            if (dvd == null)
            {
                return(NotFound());
            }
            else
            {
                return(Ok(dvd));
            }
        }
Exemplo n.º 10
0
        public static DvdDetails Delete(int dvdId)
        {
            DvdDetails dvdToDelete = _dvds.Where(d => d.DvdID == dvdId).FirstOrDefault();

            if (dvdToDelete == null)
            {
                return(null);
            }
            else
            {
                _dvds.RemoveAll(d => d.DvdID == dvdId);
                return(dvdToDelete);
            }
        }
Exemplo n.º 11
0
        public static DvdDetails Update(DvdDetails dvd)
        {
            var found = _dvds.FirstOrDefault(d => d.DvdID == dvd.DvdID);

            if (found != null)
            {
                //found = dvd;
                return(dvd);
            }
            else
            {
                return(null);
            }
        }
Exemplo n.º 12
0
        public static DvdDetails Insert(DvdDetails dvd)
        {
            if (_dvds.Count() == 0)
            {
                dvd.DvdID = 1;
            }
            else
            {
                dvd.DvdID = _dvds.Max(d => d.DvdID) + 1;
            }
            _dvds.Add(dvd);

            return(dvd);
        }
Exemplo n.º 13
0
        // GET: DvdDetails/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            DvdDetails dvdDetails = db.DvdDetails.Find(id);

            if (dvdDetails == null)
            {
                return(HttpNotFound());
            }
            return(View(dvdDetails));
        }
Exemplo n.º 14
0
        public DvdDetails GetByID(int DvdID)
        {
            DvdDetails dvd = new DvdDetails();

            using (var context = new DvdContextModel())
            {
                var idParameter = new SqlParameter
                {
                    ParameterName = "@DvdID", SqlDbType = SqlDbType.Int, Value = DvdID
                };

                dvd = context.Database.SqlQuery <DvdDetails>("DvdDetailsByID @DvdID", idParameter).SingleOrDefault();
            }

            return(dvd);
        }
Exemplo n.º 15
0
        public DvdDetails Delete(int dvdID)
        {
            DvdDetails dvdToDelete = this.GetByID(dvdID);

            using (var context = new DvdContextModel())
            {
                var idParamter = new SqlParameter
                {
                    ParameterName = "@DvdID", SqlDbType = SqlDbType.Int, Value = dvdID
                };

                context.Database.SqlQuery <DvdDetails>("DvdDelete @DvdID", idParamter).SingleOrDefault();
            }

            return(dvdToDelete);
        }
Exemplo n.º 16
0
        public DvdDetails Delete(int dvdID)
        {
            DvdDetails dvdDeleted = this.GetByID(dvdID);

            using (var cn = new SqlConnection(Settings.GetConnectionString()))
            {
                SqlCommand cmd = new SqlCommand("DvdDelete", cn);
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.AddWithValue("@DvdID", dvdID);

                cn.Open();

                cmd.ExecuteNonQuery();
            }

            return(dvdDeleted);
        }
Exemplo n.º 17
0
        public IHttpActionResult Add(AddDvdRequest request)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            DvdDetails dvd = new DvdDetails()
            {
                Title        = request.title,
                Year         = request.realeaseYear,
                DirectorName = request.director,
                RatingValue  = request.rating.ToUpper(),
                Note         = request.notes
            };

            DvdRepoFactory.GetRepository().Insert(dvd);
            return(Created($"dvd/{dvd.DvdID}", dvd));
        }
Exemplo n.º 18
0
        public DvdDetails Update(DvdDetails dvd)
        {
            using (var cn = new SqlConnection(Settings.GetConnectionString()))
            {
                SqlCommand cmd = new SqlCommand("DvdUpdate", cn);
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.AddWithValue("@DvdID", dvd.DvdID);
                cmd.Parameters.AddWithValue("@Title", dvd.Title);
                cmd.Parameters.AddWithValue("@Year", dvd.Year);
                cmd.Parameters.AddWithValue("@RatingValue", dvd.RatingValue);
                cmd.Parameters.AddWithValue("@DirectorName", dvd.DirectorName);
                cmd.Parameters.AddWithValue("@NoteInfo", dvd.Note);

                cn.Open();
                cmd.ExecuteNonQuery();
            }

            return(dvd);
        }
Exemplo n.º 19
0
        public List <DvdDetails> GetByDirector(string director)
        {
            List <DvdDetails> dvds = new List <DvdDetails>();

            using (var cn = new SqlConnection(Settings.GetConnectionString()))
            {
                SqlCommand cmd = new SqlCommand("DvdDetailsByDirector", cn);
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.AddWithValue("@DirectorName", director);
                cn.Open();

                //SELECT DvdID, Title, ReleaseID, DirectorID, RatingID, Note
                using (SqlDataReader dr = cmd.ExecuteReader())
                {
                    while (dr.Read())
                    {
                        DvdDetails currentRow = new DvdDetails();
                        currentRow.DvdID        = (int)dr["DvdID"];
                        currentRow.Title        = dr["Title"].ToString();
                        currentRow.ReleaseID    = (int)dr["ReleaseID"];
                        currentRow.DirectorID   = (int)dr["DirectorID"];
                        currentRow.RatingID     = (int)dr["RatingID"];
                        currentRow.DirectorName = dr["DirectorName"].ToString();
                        currentRow.RatingValue  = dr["RatingValue"].ToString();
                        currentRow.Year         = (int)dr["Year"];
                        if (dr["Note"] != DBNull.Value)
                        {
                            currentRow.Note = dr["Note"].ToString();
                        }

                        dvds.Add(currentRow);
                    }
                }
            }

            return(dvds);
        }
Exemplo n.º 20
0
        public DvdDetails GetByID(int DvdID)
        {
            DvdDetails dvd = null;

            using (var cn = new SqlConnection(Settings.GetConnectionString()))
            {
                SqlCommand cmd = new SqlCommand("DvdDetailsByID", cn);
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.AddWithValue("@DvdID", DvdID);
                cn.Open();

                //SELECT DvdID, Title, ReleaseID, DirectorID, RatingID, Note
                using (SqlDataReader dr = cmd.ExecuteReader())
                {
                    if (dr.Read())
                    {
                        dvd              = new DvdDetails();
                        dvd.DvdID        = (int)dr["DvdID"];
                        dvd.Title        = dr["Title"].ToString();
                        dvd.ReleaseID    = (int)dr["ReleaseID"];
                        dvd.DirectorID   = (int)dr["DirectorID"];
                        dvd.RatingID     = (int)dr["RatingID"];
                        dvd.DirectorName = dr["DirectorName"].ToString();
                        dvd.RatingValue  = dr["RatingValue"].ToString();
                        dvd.Year         = (int)dr["Year"];
                        if (dr["Note"] != DBNull.Value)
                        {
                            dvd.Note = dr["Note"].ToString();
                        }
                    }
                }
            }

            return(dvd);
        }
Exemplo n.º 21
0
 public DvdDetails Update(DvdDetails dvd)
 {
     return(MockRepo.Update(dvd));
 }
Exemplo n.º 22
0
 public DvdDetails Insert(DvdDetails dvd)
 {
     return(MockRepo.Insert(dvd));
 }