public Task <Films> AddMovie(Films film) { _CinemaDbContext.Entry(film).State = EntityState.Added; _CinemaDbContext.Films.Add(film); _CinemaDbContext.SaveChanges(); return(Task.FromResult(film)); }
// Add to Database #region public Task <Reserveringen> AddReservering(Reserveringen res, ReserveringenVertoningen rVert) { _CinemaDbContext.Entry(res).State = EntityState.Added; _CinemaDbContext.Reserveringen.Add(res); _CinemaDbContext.SaveChanges(); _CinemaDbContext.Entry(rVert).State = EntityState.Added; _CinemaDbContext.ReserveringenVertoningen.Add(rVert); _CinemaDbContext.SaveChanges(); return(Task.FromResult(res)); }
public User Update(User user) { _context.Users.Attach(user); _context.Entry(user).State = EntityState.Modified; _context.SaveChanges(); return(user); }
public async Task <IActionResult> Edit(int id, [Bind("FilmeId,Titulo,Classificacao,GeneroId,Ativa")] Filme filme, IFormFile Imagem) { if (id != filme.FilmeId) { return(NotFound()); } if (ModelState.IsValid) { try { if (Imagem != null && Imagem.Length > 0) { using (var stream = new MemoryStream()) { await Imagem.CopyToAsync(stream); filme.Imagem = stream.ToArray(); } _context.Update(filme); } else { _context.Entry(filme).State = EntityState.Unchanged; _context.Entry(filme).Property("Titulo").IsModified = true; _context.Entry(filme).Property("Classificacao").IsModified = true; _context.Entry(filme).Property("GeneroId").IsModified = true; } await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!FilmeExists(filme.FilmeId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["GeneroId"] = new SelectList(_context.Generos, "GeneroId", "Descricao", filme.GeneroId); return(View(filme)); }
public void Update(object obj) { db.Entry(obj).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); if (db.SaveChanges() > 0) { NotifyObservers(obj.GetType()); // OBSERVER NOTIFICATION } }
public ActionResult Edit([Bind(Include = "Id,Name")] Hall hall) { if (ModelState.IsValid) { db.Entry(hall).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(hall)); }
/// <summary> /// Updates information about a ticket /// </summary> /// <param name="ticket">Updated ticket object</param> public async Task UpdateAsync(ProjectionTicket ticket) { var ticketDataInContext = await context.ProjectionTickets.FindAsync(ticket.Id); if (ticketDataInContext != null) { context.Entry(ticketDataInContext).CurrentValues.SetValues(ticket); await context.SaveChangesAsync(); } }
public ActionResult Edit(Pelicula pelicula) { if (ModelState.IsValid) { db.Entry(pelicula).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(pelicula)); }
/// <summary> /// Update the selected review if exists /// </summary> /// <param name="filmReview">An updated review of the film</param> public async Task UpdateAsync(FilmReview filmReview) { var filmInContext = await context.FilmReviews.FindAsync(filmReview.Id); if (filmInContext != null) { context.Entry(filmInContext).CurrentValues.SetValues(filmReview); await context.SaveChangesAsync(); } }
public ActionResult Edit([Bind(Include = "Extra_id,Descripcion,Precio,Activo")] Extra extra) { if (ModelState.IsValid) { db.Entry(extra).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(extra)); }
/// <summary> /// Updates the data about a selected film /// </summary> /// <param name="filmData">The updated data of the film</param> public async Task UpdateAsync(FilmData filmData) { var filmDataInContext = await context.FilmDatas.FindAsync(filmData.FilmId); if (filmDataInContext != null) { context.Entry(filmDataInContext).CurrentValues.SetValues(filmData); await context.SaveChangesAsync(); } }
public ActionResult Edit(UserEditViewModel user) { if (!ModelState.IsValid) { return(View(user)); } int userId = HttpContext.User.Identity.GetUserId <int>(); var entity = db.Users.FirstOrDefault(UserViewEdit => UserViewEdit.Id == userId); if (entity != null) { entity.Name = user.Name; entity.Surname = user.Surname; //entity.Password = user.Password; entity.BirthDate = user.BirthDate; if (entity.BirthDate > DateTime.Now.AddYears(-5)) { ModelState.AddModelError("", "Data urodzenia jest nieprawidłowa."); return(View(user)); } entity.Address = user.Address; entity.Phone = user.Phone; var city = db.Cities.FirstOrDefault(c => c.Name == user.City); if (city == null) { city = new City(); city.Name = user.City; entity.City = city; db.Cities.Add(city); } entity.City = city; entity.Email = user.Email; db.Users.Attach(entity); var entry = db.Entry(entity); entry.Property(e => e.Name).IsModified = true; entry.Property(e => e.Surname).IsModified = true; entry.Property(e => e.Password).IsModified = true; entry.Property(e => e.BirthDate).IsModified = true; entry.Property(e => e.Address).IsModified = true; entry.Property(e => e.Phone).IsModified = true; entry.Property(e => e.Email).IsModified = true; db.SaveChanges(); } ViewBag.Message = "Twoje konto zostało edytowane"; return(View(user)); }
public ActionResult Edit(UserEditViewModel user) { if (!ModelState.IsValid) { return(View(user)); } CinemaDbContext db = new CinemaDbContext(); var sessionId = Session["LoggedUserID"]; if (sessionId == null) { return(View("")); } int userId = (int)sessionId; var entity = db.Users.FirstOrDefault(UserViewEdit => UserViewEdit.Id == userId); if (entity != null) { entity.Name = user.Name; entity.Surname = user.Surname; entity.Password = user.Password; entity.BirthDate = user.BirthDate; entity.Address = user.Address; entity.Phone = user.Phone; var city = db.Cities.FirstOrDefault(c => c.Name == user.City); if (city == null) { city = new City(); city.Name = user.City; entity.City = city; db.Cities.Add(city); } entity.Email = user.Email; db.Users.Attach(entity); var entry = db.Entry(entity); entry.Property(e => e.Name).IsModified = true; entry.Property(e => e.Surname).IsModified = true; entry.Property(e => e.Password).IsModified = true; entry.Property(e => e.BirthDate).IsModified = true; entry.Property(e => e.Address).IsModified = true; entry.Property(e => e.Phone).IsModified = true; entry.Property(e => e.Email).IsModified = true; db.SaveChanges(); } ViewBag.Message = "Twoje konto zostało edytowane"; return(View(user)); }
public ActionResult Edit([Bind(Include = "Id,Row,Number,HallId,ShowId,IsAvaliable")] Seat seat) { if (ModelState.IsValid) { db.Entry(seat).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.HallId = new SelectList(db.Halls, "Id", "Name", seat.HallId); return(View(seat)); }
public ActionResult Edit([Bind(Include = "Id,ShowId,SeatId,CustomerId")] Ticket ticket) { if (ModelState.IsValid) { db.Entry(ticket).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CustomerId = new SelectList(db.Customers, "Id", "Name", ticket.CustomerId); ViewBag.SeatId = new SelectList(db.Seats, "Id", "Row", ticket.SeatId); ViewBag.ShowId = new SelectList(db.Shows, "Id", "Id", ticket.ShowId); return(View(ticket)); }
public ITicket BuyTicket(TicketBuyingModel ticketBuyingModel) { var ticket = new Ticket(); ticket.ColumnNumber = ticketBuyingModel.ColumnNumber; ticket.RowNumber = ticketBuyingModel.RowNumber; ticket.ProjectionId = ticketBuyingModel.ProjectionId; this.dbContext.Tickets.Add(ticket); dbContext.SaveChanges(); dbContext.Entry(ticket).Reference(a => a.Projection).Load(); dbContext.Entry(ticket.Projection).Reference(a => a.Movie).Load(); dbContext.Entry(ticket.Projection).Reference(a => a.Room).Load(); dbContext.Entry(ticket.Projection.Room).Reference(a => a.Cinema).Load(); return(ticket); }
public void AddReservedSeat(int seatId, CinemaDbContext context = null) { if (_reservedSeats != null) { _reservedSeats.Add(new ReservedSeat(seatId)); } else if (context == null) { throw new ArgumentNullException(nameof(context), "You must provide a context if the ReservedSeats collection isn't valid."); } else if (context.Entry(this).IsKeySet) { context.Add(new ReservedSeat(seatId, Id)); } else { throw new InvalidOperationException("Could not add a reservedSeat."); } }
/// <summary> /// Update a cinema in the database /// and send email to people who had reserved tickets to inform about the changes. /// </summary> /// <param name="id">The id of the cinema</param> /// <param name="id">The URL of the projection</param> public async Task UpdateAsync(Cinema cinema, string ticketUrlPattern) { var cinemaInContext = await context.Cinemas.FindAsync(cinema.Id); if (cinemaInContext != null) { var projections = context.FilmProjections.Where(x => x.CinemaId == cinemaInContext.Id).ToList(); foreach (var projection in projections) { var projectionTickets = projection.ProjectionTickets.ToList(); foreach (var ticket in projectionTickets) { await emailSender.SendTicketUpdateEmailAsync(ticket.Holder.Email, ticket.Projection, ticketUrlPattern); } } context.Entry(cinemaInContext).CurrentValues.SetValues(cinema); await context.SaveChangesAsync(); } }
public ActionResult Update(Film films, int[] countryIds, int[] janreIds) { if (films.Name != null && films.PublicationDate != null && films.Link != null && janreIds != null && countryIds != null && films.Duration != 0) { User user = Session["User"] as User; films.UserId = user.Id; db.Entry(films).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); DeleteRelations(films.Id); foreach (int item in countryIds) { FilmCountry filmCountry = new FilmCountry() { FilmId = films.Id, CountryId = item }; db.FilmCountries.Add(filmCountry); db.SaveChanges(); } foreach (int item in janreIds) { FilmJanre filmGenre = new FilmJanre() { FilmId = films.Id, JanreId = item }; db.FilmJanres.Add(filmGenre); db.SaveChanges(); } return(RedirectToAction("Index", "Home")); } return(Content("Xanalai doldurun")); }
/// <summary> /// Updates information for a selected projection /// and send email to infrom about the update /// </summary> /// <param name="projection">New projection object</param> /// <param name="projectionsUrlPattern">Projection page reference url</param> /// <param name="ticketsUrlPattern">Tickets page reference url</param> public async Task UpdateAsync(FilmProjection projection, string projectionsUrlPattern, string ticketsUrlPattern) { var projectionInContext = await context.FilmProjections.FindAsync(projection.Id); if (projectionInContext != null) { foreach (var ticket in context.ProjectionTickets.Where(x => x.ProjectionId == projection.Id).ToList()) { if (ticket.Seat > projection.TotalTickets) { await emailSender.SendTicketCancelationEmailAsync(ticket.Holder.Email, projectionInContext, projectionsUrlPattern); context.ProjectionTickets.Remove(ticket); } else { switch (ticket.Type) { case TicketType.Adult: ticket.Price = projection.TicketPrices.AdultPrice; break; case TicketType.Children: ticket.Price = projection.TicketPrices.ChildrenPrice; break; case TicketType.Student: ticket.Price = projection.TicketPrices.StudentPrice; break; } await emailSender.SendTicketUpdateEmailAsync(ticket.Holder.Email, projectionInContext, ticketsUrlPattern); } } context.Entry(projectionInContext).CurrentValues.SetValues(projection); projectionInContext.TicketPrices.AdultPrice = projection.TicketPrices.AdultPrice; projectionInContext.TicketPrices.StudentPrice = projection.TicketPrices.StudentPrice; projectionInContext.TicketPrices.ChildrenPrice = projection.TicketPrices.ChildrenPrice; await context.SaveChangesAsync(); } }
public void Update(TEntity entityToBeUpdated) { dbSet.Attach(entityToBeUpdated); cinemaDbContext.Entry(entityToBeUpdated).State = EntityState.Modified; }
public bool SeatIsReserved(int row, int col, Projection projection) { db.Entry(projection).Collection(a => a.Reservations).Load(); return(projection.Reservations.Any(a => (a.ColumnNumber == col && a.RowNumber == row && a.IsActive))); }
public ActionResult EditFilm(AddFilmViewModel model) { //var film = db.Films.Find(id); var film = db.Films.FirstOrDefault(x => x.Id == model.Id); if (!ModelState.IsValid) { model.FilmGenres = db.FilmGenres.Select(x => new SelectListItem { Text = x.Name, Value = x.Id.ToString() }).ToList(); model.Creators = db.Creators.Select(x => new SelectListItem { Text = x.Name, Value = x.Id.ToString() }).ToList(); model.Image = film.Image; return(View(model)); } if (db.Films.Any(x => x.Title == model.Title)) { model.FilmGenres = db.FilmGenres.Select(x => new SelectListItem { Text = x.Name, Value = x.Id.ToString() }).ToList(); model.Creators = db.Creators.Select(x => new SelectListItem { Text = x.Name, Value = x.Id.ToString() }).ToList(); model.Image = film.Image; ModelState.AddModelError(String.Empty, "Ten tytuł jest już w bazie."); return(View(model)); } if (Request.Files.Count > 0) { var file = Request.Files[0]; if (file != null && file.ContentLength > 0) { var fileName = Path.GetFileNameWithoutExtension(model.ImageFile.FileName); string extension = Path.GetExtension(model.ImageFile.FileName); fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension; model.Image = "~/Content/img/" + fileName; fileName = Path.Combine(Server.MapPath("~/Content/img/"), fileName); model.ImageFile.SaveAs(fileName); film.Image = model.Image; } } film.Deleted = model.Deleted; film.Duration = model.Duration; film.Title = model.Title; film.Description = model.Description; var filmGenre = db.FilmGenres.FirstOrDefault(c => c.Id == model.FilmGenre); film.FilmGenre = filmGenre; var creator = db.Creators.FirstOrDefault(c => c.Id == model.Creator); film.Creator = creator; db.Entry(film).State = EntityState.Modified; db.SaveChanges(); ModelState.Clear(); return(RedirectToAction("FilmList")); }