Beispiel #1
0
        public void Edit(dvd dvd)
        {
            var repository  = new DvdLibraryEF();
            var newDirector = repository.Directors.FirstOrDefault(d => d.DirectorName == dvd.director);

            if (newDirector == null)
            {
                newDirector = repository.Directors.Add(new DirectorEF {
                    DirectorName = dvd.director
                });
                repository.SaveChanges();
            }

            var newRating = repository.Ratings.FirstOrDefault(d => d.RatingName == dvd.rating);

            if (newRating == null)
            {
                newRating = repository.Ratings.Add(new RatingEF {
                    RatingName = dvd.rating
                });
                repository.SaveChanges();
            }
            var TheDvd = repository.DVDs.FirstOrDefault(d => d.dvdId == dvd.dvdId);


            TheDvd.director     = newDirector;
            TheDvd.notes        = dvd.notes;
            TheDvd.realeaseYear = dvd.realeaseYear;
            TheDvd.rating       = newRating;
            TheDvd.title        = dvd.title;

            repository.SaveChanges();
        }
Beispiel #2
0
        public IHttpActionResult New(AddDvdRequest model)
        {
            dvd movie = new dvd();


            // if (ModelState.IsValid)
            // {


            movie.title        = model.title;
            movie.rating       = model.rating;
            movie.director     = model.director;
            movie.realeaseYear = model.realeaseYear;
            movie.notes        = model.notes;
            _dvdRepository.Add(movie);



            // DvdRepoMock.Edit(movie);

            return(Ok(movie));
            // }
            // else { return NotFound(); }

            // return Ok(DvdRepoMock.GetAll());
        }
Beispiel #3
0
        public dvd Get(int dvdid)
        {
            dvd dvds = new dvd();

            using (SqlConnection conn = new SqlConnection())
            {
                conn.ConnectionString = ConfigurationManager.ConnectionStrings["DvdLibrary"].ConnectionString;
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = conn;
                cmd.CommandType = System.Data.CommandType.StoredProcedure;
                cmd.CommandText = "RetreiveDvdByID";
                cmd.Parameters.AddWithValue("@DvdID", dvdid);
                conn.Open();
                using (SqlDataReader rdr = cmd.ExecuteReader())
                {
                    while (rdr.Read())
                    {
                        dvd currentRow = new dvd();
                        currentRow.dvdId        = (int)rdr["dvdId"];
                        currentRow.title        = rdr["title"].ToString();
                        currentRow.realeaseYear = (string)rdr["releaseYear"];

                        currentRow.director = rdr["Name"].ToString();
                        currentRow.rating   = rdr["Rating"].ToString();
                        if (rdr["Notes"] != DBNull.Value)
                        {
                            currentRow.notes = rdr["Notes"].ToString();
                        }
                        dvds = currentRow;
                    }
                }
            }
            return(dvds);
        }
Beispiel #4
0
        public List <dvd> GetAll()
        {
            List <dvd> dvds = new List <dvd>();

            using (SqlConnection conn = new SqlConnection())
            {
                conn.ConnectionString = ConfigurationManager.ConnectionStrings["DvdLibrary"].ConnectionString;
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = conn;
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandText = "RetreivingAllDvds";
                conn.Open();
                using (SqlDataReader rdr = cmd.ExecuteReader())
                {
                    while (rdr.Read())
                    {
                        dvd currentRow = new dvd();
                        currentRow.dvdId        = (int)rdr["dvdId"];
                        currentRow.title        = rdr["title"].ToString();
                        currentRow.realeaseYear = (string)rdr["releaseYear"];

                        currentRow.director = rdr["Name"].ToString();
                        currentRow.rating   = rdr["Rating"].ToString();
                        if (rdr["notes"] != DBNull.Value)
                        {
                            currentRow.notes = rdr["notes"].ToString();
                        }
                        dvds.Add(currentRow);
                    }
                }
            }
            return(dvds);
        }
Beispiel #5
0
        public List <dvd> GetYear(string dvdYear)
        {
            List <dvd> dvds = new List <dvd>();

            using (SqlConnection conn = new SqlConnection())
            {
                conn.ConnectionString = ConfigurationManager.ConnectionStrings["DvdLibrary"].ConnectionString;
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = conn;
                cmd.CommandType = System.Data.CommandType.StoredProcedure;
                cmd.CommandText = "RetreiveDvdByReleaseYear";
                cmd.Parameters.AddWithValue("@ReleaseYear", dvdYear);
                conn.Open();
                using (SqlDataReader rdr = cmd.ExecuteReader())
                {
                    while (rdr.Read())
                    {
                        dvd currentRow = new dvd();
                        currentRow.dvdId        = (int)rdr["dvdId"];
                        currentRow.title        = rdr["title"].ToString();
                        currentRow.realeaseYear = (string)rdr["releaseYear"];

                        currentRow.director = rdr["Name"].ToString();
                        currentRow.rating   = rdr["Rating"].ToString();



                        dvds.Add(currentRow);
                    }
                }
            }
            return(dvds);
        }
        public ActionResult DeleteConfirmed(int id)
        {
            dvd dvd = db.dvd.Find(id);

            db.dvd.Remove(dvd);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
Beispiel #7
0
        public void Edit(dvd dvd)
        {
            var found = _dvds.FirstOrDefault(m => m.dvdId == dvd.dvdId);

            if (found != null)
            {
                found = dvd;
            }
        }
 public ActionResult Edit([Bind(Include = "dvdId,dvdTitle,dvdDirector,genre")] dvd dvd)
 {
     if (ModelState.IsValid)
     {
         db.Entry(dvd).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(dvd));
 }
        public ActionResult Create([Bind(Include = "dvdId,dvdTitle,dvdDirector,genre")] dvd dvd)
        {
            if (ModelState.IsValid)
            {
                db.dvd.Add(dvd);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

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

            if (dvd == null)
            {
                return(HttpNotFound());
            }
            return(View(dvd));
        }
Beispiel #11
0
        public IHttpActionResult Get(int dvdId)
        {
            dvd movie = _dvdRepository.Get(dvdId);

            //dvd movie = DvdRepoMock.Get(dvdId);
            if (movie == null)
            {
                return(NotFound());
            }
            else
            {
                return(Ok(movie));
            }
        }
Beispiel #12
0
        // GET: Dvds/Edit/5
        public ActionResult Edit(byte?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            dvd dvd = db.dvd.Find(id);

            if (dvd == null)
            {
                return(HttpNotFound());
            }
            ViewBag.cast_id     = new SelectList(db.cast, "id", "first_name", dvd.cast_id);
            ViewBag.genres_id   = new SelectList(db.Genres, "id", "genres1", dvd.genres_id);
            ViewBag.producer_id = new SelectList(db.producer, "id", "first_name", dvd.producer_id);
            ViewBag.studio_id   = new SelectList(db.studio, "id", "name", dvd.studio_id);
            return(View(dvd));
        }
Beispiel #13
0
        public void Delete(int dvdid)
        {
            var repository = new DvdLibraryEF();
            var DVD        = repository.DVDs.Find(dvdid);

            if (DVD != null)
            {
                dvd deleted = new dvd
                {
                    dvdId        = DVD.dvdId,
                    director     = DVD.director.DirectorName,
                    notes        = DVD.notes,
                    realeaseYear = DVD.realeaseYear,
                    rating       = DVD.rating.RatingName,
                    title        = DVD.title
                };
                repository.DVDs.Remove(DVD);
                repository.SaveChanges();
            }
        }
Beispiel #14
0
        public dvd Get(int dvdid)
        {
            var repository = new DvdLibraryEF();
            var DVD        = repository.DVDs.Find(dvdid);
            dvd returnList = new dvd();

            if (DVD != null)
            {
                returnList.dvdId        = DVD.dvdId;
                returnList.director     = DVD.director.DirectorName;
                returnList.notes        = DVD.notes;
                returnList.realeaseYear = DVD.realeaseYear;
                returnList.rating       = DVD.rating.RatingName;
                returnList.title        = DVD.title;
                return(returnList);
            }
            else
            {
                return(null);
            }
        }
Beispiel #15
0
 public ActionResult Edit([Bind(Include = "id,copy_number,title,released_date,genres_id,stock,date_added,studio_id,producer_id,cast_id,cover")] dvd dvd, HttpPostedFileBase cover)
 {
     if (ModelState.IsValid)
     {
         if (cover != null)
         {
             string pic  = System.IO.Path.GetFileName(cover.FileName);
             string path = System.IO.Path.Combine(
                 Server.MapPath("~/media/dvdPoster"), pic);
             dvd.cover = cover.FileName;
             cover.SaveAs(path);
         }
         db.Entry(dvd).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.cast_id     = new SelectList(db.cast, "id", "first_name", dvd.cast_id);
     ViewBag.genres_id   = new SelectList(db.Genres, "id", "genres1", dvd.genres_id);
     ViewBag.producer_id = new SelectList(db.producer, "id", "first_name", dvd.producer_id);
     ViewBag.studio_id   = new SelectList(db.studio, "id", "name", dvd.studio_id);
     return(View(dvd));
 }
Beispiel #16
0
        public void Edit(dvd dvd)
        {
            using (SqlConnection conn = new SqlConnection())
            {
                conn.ConnectionString = ConfigurationManager.ConnectionStrings["DvdLibrary"].ConnectionString;
                SqlCommand cmd = new SqlCommand("UpdateDvd", conn);
                cmd.Connection  = conn;
                cmd.CommandType = System.Data.CommandType.StoredProcedure;


                cmd.Parameters.AddWithValue("@Title", dvd.title);
                cmd.Parameters.AddWithValue("@DirectorName", dvd.director);
                cmd.Parameters.AddWithValue("@Rating", dvd.rating);
                cmd.Parameters.AddWithValue("@ReleaseYear", dvd.realeaseYear);
                cmd.Parameters.AddWithValue("@Notes", dvd.notes);
                cmd.Parameters.AddWithValue("@DirectorID", SqlDbType.Int);
                cmd.Parameters.AddWithValue("@RatingID", SqlDbType.Int);
                cmd.Parameters.AddWithValue("@DvdID", dvd.dvdId);

                conn.Open();
                using (SqlDataReader rdr = cmd.ExecuteReader())
                {
                    if (rdr.Read())
                    {
                        dvd.dvdId        = (int)rdr["dvdId"];
                        dvd.title        = rdr["title"].ToString();
                        dvd.realeaseYear = (string)rdr["releaseYear"];

                        dvd.director = rdr["Name"].ToString();
                        dvd.rating   = rdr["Rating"].ToString();
                        if (rdr["Notes"] != DBNull.Value)
                        {
                            dvd.notes = rdr["Notes"].ToString();
                        }
                    }
                }
            }
        }
Beispiel #17
0
        public void Add(dvd dvd)
        {
            using (SqlConnection conn = new SqlConnection())
            {
                dvd dvds = new dvd();
                conn.ConnectionString = ConfigurationManager.ConnectionStrings["DvdLibrary"].ConnectionString;
                SqlCommand cmd = new SqlCommand("CreateNewDvd", conn);
                cmd.Connection  = conn;
                cmd.CommandType = System.Data.CommandType.StoredProcedure;

                conn.Open();
                cmd.Parameters.AddWithValue("@Title", dvd.title);
                cmd.Parameters.AddWithValue("@DirectorName", dvd.director);
                cmd.Parameters.AddWithValue("@Rating", dvd.rating);
                cmd.Parameters.AddWithValue("@ReleaseYear", dvd.realeaseYear);
                cmd.Parameters.AddWithValue("@Notes", dvd.notes);
                cmd.Parameters.AddWithValue("@DirectorID", SqlDbType.Int);
                cmd.Parameters.AddWithValue("@RatingID", SqlDbType.Int);
                cmd.Parameters.AddWithValue("@DvdID", SqlDbType.Int);


                cmd.ExecuteNonQuery();
            }
        }
Beispiel #18
0
        public IHttpActionResult Edit(EditViewModel model)
        {
            dvd movie = _dvdRepository.Get(model.dvdId);

            if (ModelState.IsValid)
            {
                movie.dvdId        = model.dvdId;
                movie.title        = model.title;
                movie.rating       = model.rating;
                movie.director     = model.director;
                movie.realeaseYear = model.realeaseYear;

                _dvdRepository.Edit(movie);
                // DvdRepoMock.Edit(movie);

                return(Ok(movie));
            }
            else
            {
                return(NotFound());
            }

            // return Ok(DvdRepoMock.GetAll());
        }
Beispiel #19
0
        public void Add(dvd dvd)
        {
            var repository  = new DvdLibraryEF();
            var newDirector = repository.Directors.FirstOrDefault(d => d.DirectorName == dvd.director);

            if (newDirector == null)
            {
                newDirector = repository.Directors.Add(new DirectorEF {
                    DirectorName = dvd.director
                });
                repository.SaveChanges();
            }

            var newRating = repository.Ratings.FirstOrDefault(d => d.RatingName == dvd.rating);

            if (newRating == null)
            {
                newRating = repository.Ratings.Add(new RatingEF {
                    RatingName = dvd.rating
                });
                repository.SaveChanges();
            }

            var DVD = repository.DVDs.Add(
                new EF.dvdEF
            {
                dvdId        = dvd.dvdId,
                director     = newDirector,
                notes        = dvd.notes,
                realeaseYear = dvd.realeaseYear,
                rating       = newRating,
                title        = dvd.title
            });

            repository.SaveChanges();
        }
Beispiel #20
0
        public void Dvd()
        {
            lock (testLock)
            {
                // Copy resource file to the run-time directory
                GetInputFilePath("Actor.xsd", Resources.Actor);

                // Copy resource file to the run-time directory
                string inputFilePath   = GetInputFilePath("Dvd.xsd", Resources.dvd);
                var    generatorParams = GetGeneratorParams(inputFilePath);
                generatorParams.CollectionObjectType = CollectionType.List;
                generatorParams.TargetFramework      = TargetFramework.Net35;
                generatorParams.EnableDataBinding    = true;
                generatorParams.Miscellaneous.EnableSummaryComment = true;
                generatorParams.GenerateDataContracts                   = false;
                generatorParams.GenericBaseClass.Enabled                = false;
                generatorParams.Serialization.GenerateXmlAttributes     = true;
                generatorParams.TrackingChanges.Enabled                 = false;
                generatorParams.TrackingChanges.GenerateTrackingClasses = false;
                generatorParams.Serialization.EnableEncoding            = false;
                generatorParams.Serialization.DefaultEncoder            = DefaultEncoder.UTF8;

                var xsdGen = new GeneratorFacade(generatorParams);
                var result = xsdGen.Generate();

                Assert.IsTrue(result.Success, result.Messages.ToString());

                // Create new dvd collection and save it to file
                var dvd = new DvdCollection();
                dvd.Dvds.Add(new dvd {
                    Title = "Matrix יא?"
                });
                var newitem = new dvd();
                newitem.Actor.Add(new Actor {
                    firstname = "Jamיs א&", nationality = "Us"
                });
                dvd.Dvds.Add(newitem);
                var originalXml = dvd.Serialize();
                var dvdFile     = Path.Combine(OutputFolder, "dvd.xml");
                dvd.SaveToFile(dvdFile);

                // Load data fom file and serialize it again.

                var loadedDvdCollection = DvdCollection.LoadFromFile(dvdFile);
                var finalXml            = loadedDvdCollection.Serialize();

                // Then comprate two xml string
                if (!originalXml.Equals(finalXml))
                {
                    Assert.Fail("Xml value are not equals");
                }
                Exception     exp;
                DvdCollection deserialiseDvd;

                var testEncodings = new [] {
                    Encoding.ASCII, Encoding.UTF8, Encoding.Unicode, Encoding.UTF32
                };
                foreach (var encoding in testEncodings)
                {
                    var encodedFile = Path.Combine(OutputFolder, "dvd" + encoding.EncodingName + ".xml");
                    dvd.SaveToFile(encodedFile, encoding);
                    if (!DvdCollection.LoadFromFile(encodedFile, encoding, out deserialiseDvd, out exp))
                    {
                        Assert.Fail("LoadFromFile failed on {0} encoding", encoding.EncodingName);
                    }
                    else if (!deserialiseDvd.Dvds[0].Title.Equals("Matrix יא?"))
                    {
                        Assert.Fail("LoadFromFile failed on {0} encoding", encoding.EncodingName);
                    }
                }

                var compileResult = CompileCSFile(generatorParams.OutputFilePath);
                Assert.IsTrue(compileResult.Success, compileResult.Messages.ToString());
            }
        }
Beispiel #21
0
        public void Dvd()
        {
            lock (testLock)
            {
                // Copy resource file to the run-time directory
                GetInputFilePath("Actor.xsd", Resources.Actor);

                // Copy resource file to the run-time directory
                string inputFilePath   = GetInputFilePath("Dvd.xsd", Resources.dvd);
                var    generatorParams = GetGeneratorParams(inputFilePath);
                generatorParams.CollectionObjectType = CollectionType.List;
                generatorParams.TargetFramework      = TargetFramework.Net35;
                generatorParams.EnableDataBinding    = true;
                generatorParams.Miscellaneous.EnableSummaryComment = true;
                generatorParams.GenerateDataContracts                   = false;
                generatorParams.GenericBaseClass.Enabled                = false;
                generatorParams.Serialization.GenerateXmlAttributes     = true;
                generatorParams.TrackingChanges.Enabled                 = false;
                generatorParams.TrackingChanges.GenerateTrackingClasses = false;
                generatorParams.Serialization.EnableEncoding            = false;
                generatorParams.Serialization.DefaultEncoder            = DefaultEncoder.UTF8;
                //generatorParams.PropertyParams.AutomaticProperties = true;

                GenerateAndCompile(generatorParams);

                // Create new dvd collection and save it to file
                var dvd = new DvdCollection();
                dvd.Dvds.Add(new dvd {
                    Title = "Matrix יא?"
                });
                var newitem = new dvd();
                newitem.Actor.Add(new Actor {
                    firstname = "Jamיs א&", nationality = "Us"
                });
                dvd.Dvds.Add(newitem);
                var originalXml        = dvd.Serialize();
                var dataOutputFileName = GetOutputFullFileName("dvd.xml");
                dvd.SaveToFile(dataOutputFileName);

                // Load data fom file and serialize it again.

                var loadedDvdCollection = DvdCollection.LoadFromFile(dataOutputFileName);
                var finalXml            = loadedDvdCollection.Serialize();

                // Then comprate two xml string
                if (!originalXml.Equals(finalXml))
                {
                    Assert.Fail("Xml value are not equals");
                }

                Exception exp;
                foreach (var encoding in encodings)
                {
                    DvdCollection deserialiseDvd;
                    var           dataEncodingOutputFileName = GetOutputFullFileName($"dvd{encoding.EncodingName}.xml");
                    dvd.SaveToFile(dataEncodingOutputFileName, encoding);
                    if (!DvdCollection.LoadFromFile(dataEncodingOutputFileName, encoding, out deserialiseDvd, out exp))
                    {
                        Assert.Fail($"LoadFromFile failed on {encoding.EncodingName} encoding ");
                    }
                    else
                    {
                        string title = /*(encoding == Encoding.ASCII) ? "Matrix ???" : */ "Matrix יא?";
                        if (!deserialiseDvd.Dvds[0].Title.Equals(title))
                        {
                            Assert.Fail($"LoadFromFile failed on {encoding.EncodingName} encoding ");
                        }
                    }
                }
            }
        }
Beispiel #22
0
        public ActionResult Create([Bind(Include = "id,date_out,num_copy,amount_paid,due,date_returned,penalty_charge,dvd_id,member_id,loan_status_id")] loan loan, dvd dvd)
        {
            if (ModelState.IsValid)
            {
                db.loan.Add(loan);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            ViewBag.dvd_id         = new SelectList(db.dvd, "id", "title", loan.dvd_id);
            ViewBag.member_id      = new SelectList(db.member, "id", "first_name", loan.member_id);
            ViewBag.loan_status_id = new SelectList(db.loan_status, "id", "loan_status", loan.loan_status_id);

            /*
             * db.Entry(dvd).State = EntityState.Modified;
             * var dv = db.dvd.Find(loan.dvd_id);
             * var result=dv.stock - loan.num_copy;
             * dvd dvd = new dvd()
             * {
             *
             * };
             */

            //db.SaveChanges();
            return(View(loan));
        }
Beispiel #23
0
 public void Add(dvd dvd)
 {
     dvd.dvdId = _dvds.Max(m => m.dvdId) + 1;
     _dvds.Add(dvd);
 }