private static void AddDataToDB() { MRandomatorDataContext context = new MRandomatorDataContext(); String text = System.IO.File.ReadAllText(@"C:\Users\Emre\Desktop\json files\imdbFull2.json"); JObject mov = JsonConvert.DeserializeObject<JObject>(text); JArray jar = (JArray)mov["movies"]; for (int i = 0; i < jar.Count; i++) { Movy movie = new Movy(); movie.Title = jar[i]["Title"].ToString(); movie.Year = Int32.Parse(jar[i]["Year"].ToString()); movie.Rated = jar[i]["Rated"].ToString(); movie.Released = jar[i]["Released"].ToString(); movie.Runtime = jar[i]["Runtime"].ToString(); movie.Genre = jar[i]["Genre"].ToString(); movie.Director = jar[i]["Director"].ToString(); movie.Writer = jar[i]["Writer"].ToString(); movie.Actors = jar[i]["Actors"].ToString(); movie.Plot = jar[i]["Plot"].ToString(); movie.Language = jar[i]["Language"].ToString(); movie.Country = jar[i]["Country"].ToString(); movie.Awards = jar[i]["Awards"].ToString(); movie.Poster = jar[i]["Poster"].ToString(); movie.Metascore = jar[i]["Metascore"].ToString(); movie.imdbRating = jar[i]["imdbRating"].ToString(); movie.imdbVotes = jar[i]["imdbVotes"].ToString(); //movie.Type = jar[i]["Type"].ToString(); movie.Trailer = jar[i]["Trailer"].ToString(); context.Movies.InsertOnSubmit(movie); //context.SubmitChanges(); Değişiklikleri uygular. } }
public static void AddMovie(Movy movie) { using (var database = new movieLibraryEntities()) { database.Movies.Add(movie); database.SaveChanges(); } }
public List <Avi> getAllAvisforIdMovie(Movy movi) { List <Avi> avis = new List <Avi>(); if (movi != null) { var query = DMCCTX.ctx.Avis.Where(m => m.Movies_Id.Equals(movi.Id)); DMCCTX.ctx.SaveChanges(); avis = (List <Avi>)query.ToList(); } return(avis); }
public IHttpActionResult DeleteMovy(int id) { Movy movy = db.Movies.Find(id); if (movy == null) { return(NotFound()); } db.Movies.Remove(movy); db.SaveChanges(); return(Ok(movy)); }
// GET: Movies/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Movy movy = db.Movies.Find(id); if (movy == null) { return(HttpNotFound()); } return(View(movy)); }
//Upodate Function protected void Update_btn_Click(object sender, EventArgs e) { Movy Obj_Ins_Movi = new Movy { MovieID = Convert.ToInt32(ddl_Movie.SelectedValue), Title = txt_title.Text, Year = txt_year.Text, Gener = txt_Gener.Text, RentPerDay = Convert.ToDecimal(txt_RentPerDay.Text) }; Database.Movies_DAL.UpdateMovie(Obj_Ins_Movi); Response.Redirect("default.aspx"); }
// GET: Movies/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Movy movy = db.Movies.Find(id); if (movy == null) { return(HttpNotFound()); } ViewBag.MovieGenre = new SelectList(db.Genres, "GenreID", "GenreName", movy.MovieGenre); return(View(movy)); }
// GET: Movies/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Movy movy = db.Movies.Find(id); if (movy == null) { return(HttpNotFound()); } ViewBag.UserID = new SelectList(db.Registrations, "UserID", "FirstName", movy.UserID); return(View(movy)); }
public Movy GetMovieByRandom() { //create random object Random random = new Random(); //get copy of data base MovieEntities db = new MovieEntities(); //create list of all movies from data base List <Movy> movies = db.Movies.ToList(); //use random object to generate a random number which is used as an index in my list //to pick a random movie to dissplay Movy mov = movies[random.Next(0, movies.Count)]; //return the movie return(mov); }
public ActionResult Delete(int?id) //? is saying its optional-- this is an action method for displaying and deleting a movie record { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Movy movie = db.Movies.Find(id); if (movie == null) { return(HttpNotFound()); } return(View(movie)); }
public static void AddNewMovieIntoTable(string MovieName, string MovieCategory) { string strConnectionString = DalUtils.GetConnectionSring(); List <Movy> movyList = new List <Movy>(); DataClasses1DataContext nw = new DataClasses1DataContext(strConnectionString); Movy NewMovie = new Movy { Name = MovieName, Category = MovieCategory }; nw.Movies.InsertOnSubmit(NewMovie); nw.SubmitChanges(); }
// GET: Movies/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Movy movy = db.Movies.Find(id); if (movy == null) { return(HttpNotFound()); } ViewBag.Producer_Id = new SelectList(db.Producers, "Id", "Name", movy.Producer_Id); return(View(movy)); }
// POST: Webflix/movies/New //This method adds a new movie in the database if there is not already a movie with the same title public HttpResponseMessage Post([FromBody] Movy value) //replace Movy by the class used in CA { if (value == null) { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Failed to read input")); } if (db.Movies.Count(p => p.Title.Equals(value.Title)) != 0) //check if there is any title in database which matches the title of the new movie to be inserted { return(Request.CreateResponse(HttpStatusCode.OK, "Movie " + value.Title + " already exists in database.")); } db.Movies.Add(value); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Created, "Movie " + value.Title + " added to database.")); }
public ActionResult SaveDeleteMovie(Models.Movie obj) { Repository rep = new Repository(); Movy list = new Movy(); var list1 = AutoMapper.Mapper.Map(obj, list); var status = rep.DeleteMovie(list1); if (status == true) { return(RedirectToAction("Details")); } else { return(View("Error")); } }
public ActionResult Edit(int id, Movy movies) { try { using (mvcEntities1 dbModel = new mvcEntities1()) { dbModel.Entry(movies).State = EntityState.Modified;//this edits the movie dbModel.SaveChanges(); } return(RedirectToAction("Index")); } catch { return(View()); } }
//Function of adding Movie button protected void btn_Submit_Click(object sender, EventArgs e) { //creating new object to get the new Movie details Movy Obj_Int_Movie = new Movy { Title = txt_title.Text, Year = txt_year.Text, Gener = txt_Gener.Text, RentPerDay = Convert.ToDecimal(txt_RentPerDay.Text) }; Database.Movies_DAL obj_Database = new Database.Movies_DAL(); // calling from database layer obj_Database.InsertMovies_DAL(Obj_Int_Movie); Response.Redirect("default.aspx"); }
public IHttpActionResult PostvMovieBook(vMovieBook vMovieBook) { Movy movy = db.Movies.Single(t => t.MovieName == vMovieBook.MovieName); User user = db.Users.Single(t => t.UserName == vMovieBook.UserName); Theater theater = db.Theaters.SingleOrDefault(t => t.ShowTime == vMovieBook.ShowTime && t.Price == vMovieBook.Price); if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var movieBooking = new MovieBooking() { MovieId = movy.MovieId, UserId = user.UserId, TheaterId = theater.TheaterId }; db.MovieBookings.Add(movieBooking); db.SaveChanges(); //if (!ModelState.IsValid) //{ // return BadRequest(ModelState); //} //db.vMovieBooks.Add(vMovieBook); //try //{ // db.SaveChanges(); //} //catch (DbUpdateException) //{ // if (vMovieBookExists(vMovieBook.MovieName)) // { // return Conflict(); // } // else // { // throw; // } //} return(CreatedAtRoute("DefaultApi", new { id = vMovieBook.MovieName }, vMovieBook)); }
public static void UpdateMovie(Movy movie,int id) { using (var database = new movieLibraryEntities()) { var movieToUpdate = database.Movies.Where(x => x.Id == id).FirstOrDefault(); if (movieToUpdate != null) { movieToUpdate.Title = movie.Title; movieToUpdate.description = movie.description; movieToUpdate.Director = movie.Director; movieToUpdate.ImdbLink = movie.ImdbLink; movieToUpdate.viewed = movie.viewed; movieToUpdate.Rating = movie.Rating; database.SaveChanges(); } } }
public Movy MovieTitle(string name) { MovieDatabaseEntities1 ORM = new MovieDatabaseEntities1(); Movy result = ORM.Movies.Find(name); if (result != null) { return(result); } else { Movy info = new Movy { Title = "movie not found" }; return(info); } }
public ActionResult SaveNewMovie(Movy ourMovie, Director ourDirector) { //DevBuildMoviesEntities ORM = new DevBuildMoviesEntities(); if (ourMovie != null) { //List<Movy> movieMatches = ORM.Movies.Where(m => //m.MovieTitle == ourMovie.MovieTitle && m.Year == //ourMovie.Year).ToList(); //if (movieMatches.Count == 0) { //ORM.Movies.Add(ourMovie); //ORM.Entry(ourMovie).State = EntityState.Added; //ORM.SaveChanges(); } } return(RedirectToAction("Index")); }
public void Add(Movy movie) { using (SqlConnection conn = new SqlConnection(connectionString)) { var commandText = "INSERT INTO Movies (Title, Rating, Year, Runtime, Director) VALUES (@Title, @Rating, @Year, @Runtime, @Director)"; SqlCommand command = new SqlCommand(commandText, conn); command.Parameters.AddWithValue("@Title", movie.Title); command.Parameters.AddWithValue("@Rating", movie.Rating); command.Parameters.AddWithValue("@Year", movie.Year); command.Parameters.AddWithValue("@Runtime", movie.Director); command.Parameters.AddWithValue("@Director", movie.Director); command.Connection.Open(); command.ExecuteNonQuery(); } }
/** *********** Methode Add Comment ******** **/ void AddCommentExe() { Validator.ValidateAll(); var validationResult = Validator.GetResult(); if (validationResult.IsValid) { /******************* Build Object for commit in Database *******************/ Avi avis = new Avi(); avis.Note = NoteAdd; avis.Commentaire = CommentAdd; Movy m = new Movy(); m = DAOF.getMovie(ViewModelLocator.homeViewModel.SelectedMovie); avis.Movy = m; avis.Movies_Id = m.Id; User u = new User(); u = DAOF.getUser(ViewModelLocator.mainViewModel.User); avis.User = u; avis.User_Id = u.Id; /******************* Insert in Database *******************/ DAOF.insertAvis(avis); /******************* Add Avis in front End *****************/ AvisList.Add(avis); /******************* Remove attribute front End *****************/ NoteAdd = 0; CommentAdd = ""; ErrorList = new List <String>(); } else { List <string> ErrorListLocal = new List <string>(); foreach (MvvmValidation.ValidationError validationError in validationResult.ErrorList) { ErrorListLocal.Add(validationError.ErrorText); } ErrorList = ErrorListLocal; } }
public HttpResponseMessage Delete(int id) { Movy movie = db.Movies.Where(m => m.MovieId == id).FirstOrDefault(); movie.UpdatedBy = 1; movie.UpdatedDt = DateTime.Now; if (movie.Active) { movie.Active = false; } else { movie.Active = true; } db.Entry(movie).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, "Record removed Successfully")); }
public ActionResult Delete(int id, FormCollection collection) { try { using (mvcEntities1 dbModel = new mvcEntities1()) { Movy movies = dbModel.Movies.Where(x => x.Id == id).FirstOrDefault();//this delets the movie dbModel.Movies.Remove(movies); dbModel.SaveChanges(); } return(RedirectToAction("Index")); } catch { return(View()); } }
// GET: MoviesBooking/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Movy movy = db.Movies.Find(id); MovieModel movieModel = new MovieModel(); movieModel.Name = movy.Name; movieModel.NoOfSeatsAvailable = movy.NoOfSeatsAvailable; movieModel.Id = movy.Id; if (movy == null) { return(HttpNotFound()); } return(View(movieModel)); }
public void Edit(Movy movie) { using (SqlConnection conn = new SqlConnection(connectionString)) { var commandText = "UPDATE Movies Set Title = @Title, Rating = @Rating, Year = @Year, Runtime = @Runtime, Director = @Director WHERE MovieId = @Id"; SqlCommand command = new SqlCommand(commandText, conn); command.Parameters.AddWithValue("@Id", movie.MovieID); command.Parameters.AddWithValue("@Title", movie.Title); command.Parameters.AddWithValue("@Rating", movie.Rating); command.Parameters.AddWithValue("@Year", movie.Year); command.Parameters.AddWithValue("@Runtime", movie.Director); command.Parameters.AddWithValue("@Director", movie.Director); command.Connection.Open(); command.ExecuteNonQuery(); } }
public void deleteMovy(Movy movy) { DAOFacadeSingleton DAOF = new DAOFacadeSingleton(); if (movy.Avis.Count != 0) { foreach (Avi a in movy.Avis.ToList()) { Avi aa = DAOF.getAvi(a.Id); DMCCTX.ctx.Avis.Attach(aa); DMCCTX.ctx.Avis.Remove(aa); } } DMCCTX.ctx.Movies.Attach(movy); DMCCTX.ctx.Movies.Remove(movy); DMCCTX.ctx.SaveChanges(); }
public ActionResult Create(Movy movie) { try { using (mvcEntities1 dbModel = new mvcEntities1())//this add the movie to the databse { dbModel.Movies.Add(movie); dbModel.SaveChanges(); } // TODO: Add insert logic here return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Edit([Bind(Include = "MovieID, Name, YearOfRelease, Plot, Poster, ActorID, ProducerID")] Movy movy, HttpPostedFileBase file) { string pic = null; if (file != null) { pic = System.IO.Path.GetFileName(file.FileName); string Path = System.IO.Path.Combine(Server.MapPath("~/Images/"), pic); file.SaveAs(Path); movy.Poster = file != null ? pic : movy.Poster; } if (ModelState.IsValid) { db.Entry(movy).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(movy)); }
public PartialViewResult AddMovie(Movy form, HttpPostedFileBase poster1) { try { Movy movie = new Movy(); movie.MovieName = form.MovieName; movie.ReleaseDate = Convert.ToDateTime(form.ReleaseDate).Date; movie.Synopsis = form.Synopsis; movie.VideoLink = form.VideoLink; if (poster1 != null) { movie.Poster = new byte[poster1.ContentLength]; poster1.InputStream.Read(movie.Poster, 0, poster1.ContentLength); } entities.Movies.Add(movie); entities.SaveChanges(); return(PartialView("_AddMovieSuccess")); } catch (Exception ex) { throw ex; } }
public static void DeleteMovie(string Obj_mov_Delete) { try { using (MovieRentalDBEntities db = new MovieRentalDBEntities()) { //Lembda expression to delete movie Movy c = db.Movies.SingleOrDefault(x => x.MovieID.ToString().Trim() == Obj_mov_Delete.Trim()); if (c != null) { db.Movies.Remove(c); db.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
// GET: Movies/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Movy movy = db.Movies.Find(id); if (movy == null) { return(HttpNotFound()); } else { Movie_User user = db.Movie_User.Find(2, "*****@*****.**"); db.Movie_User.Remove(user); db.SaveChanges(); } return(View(movy)); }
public List <Movy> GetRandomMovies(int quantity) { MoviesEntities db = new MoviesEntities(); Random random = new Random(); int pick = 0; List <Movy> movies = new List <Movy>(); for (int i = 0; i < quantity; i++) { pick = random.Next(1, (db.Movies.Count() + 1)); Movy movie = (from c in db.Movies where c.Id == pick select c).Single(); movies.Add(movie); } return(movies); }
public void EditMovie(Movy movie) { using (DataClasses1DataContext db = new DataClasses1DataContext()) { var movieUpdate = from m in db.Movies where m.Id == movie.Id select m; Movy movieTemp = movieUpdate.FirstOrDefault(); movieTemp.Title = movie.Title; movieTemp.Category = movie.Category + 1; movieTemp.Director = movie.Director; movieTemp.Cast = movie.Cast; movieTemp.Country = movie.Country; movieTemp.Year = movie.Year; movieTemp.Description = movie.Description; db.SubmitChanges(); } }
// GET: Movies/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Movy movy = db.Movies.Find(id); if (movy == null) { return(HttpNotFound()); } var moviedetail = new MovieDetail { movie = movy, movieID = movy.MovieID }; return(View(moviedetail)); }
public List<Movy> GetAllMoviesList() { List<Movy> movies = new List<Movy>(); using (SqlConnection conn = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand("SELECT * FROM Movies", conn); command.Connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Movy movie = new Movy(); movie.MovieID = reader.GetInt32(0); movie.Title = reader.GetString(1); movie.Rating = reader.GetString(2); movie.Year = reader.GetInt32(3); movie.Runtime = reader.GetInt32(4); movie.Director = reader.GetString(5); movie.Actors = new List<Actor>(); movies.Add(movie); } } return movies; }