public ActionResult Create(int?id) { List <SelectListItem> Producer = new List <SelectListItem>(); using (var ctx = new IMDBEntities()) { Producer = ctx.Producers.Where(c => c.IsDeleted == false).Select(c => new SelectListItem() { Value = c.ID.ToString(), Text = c.Name.ToString() }).ToList <SelectListItem>(); } ViewData["Producer"] = Producer; if (id != null) { using (var ctx = new IMDBEntities()) { var updateMovie = ctx.Movies.FirstOrDefault(m => m.ID == id); if (updateMovie != null) { var editMovie = Mapper.Map <Movie, MovieModel>(updateMovie); return(View(editMovie)); } } } return(View()); }
public ActionResult Create(int?id) { List <SelectListItem> Movie = new List <SelectListItem>(); using (var ctx = new IMDBEntities()) { Movie = ctx.Movies.Where(c => c.IsDeleted == false).Select(c => new SelectListItem() { Value = c.ID.ToString(), Text = c.Name.ToString() }).ToList <SelectListItem>(); } ViewData["Movie"] = Movie; if (id != null) { using (var ctx = new IMDBEntities()) { var existActor = ctx.Actors.FirstOrDefault(a => a.ID == id); if (existActor != null) { var editActor = Mapper.Map <Actor, ActorModel>(existActor); return(View(editActor)); } } } return(View()); }
public ActionResult Save(Movy mov) { bool status = false; if (ModelState.IsValid) { using (IMDBEntities dc = new IMDBEntities()) { if (mov.MovieID > 0) { //Edit var v = dc.Movies.Where(a => a.MovieID == mov.MovieID).FirstOrDefault(); if (v != null) { v.MovieName = mov.MovieName; v.Cast = mov.Cast; v.Director = mov.Director; v.Producer = mov.Producer; v.RDate = mov.RDate; } } else { //Save dc.Movies.Add(mov); } dc.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
public int CD(string category) { using (var entities = new IMDBEntities()) { var categories = entities.Categories.SingleOrDefault(b => b.Category == category); return(_mapper.Map <CategoriesDTO>(categories.CategoryID)); } }
public void GetBasketById(int id) { using (var entities = new IMDBEntities()) { var basket = entities.Baskets.SingleOrDefault(b => b.BasketID == id); // return _mapper.Map<BasketDTO>(basket); } }
public List <BooksDTO> Sort(string category, string column) { using (var entities = new IMDBEntities()) { var books = entities.Books.ToList(b => b.Category == category); return(_mapper.Map <List <BooksDTO> >(books)); } }
public ActionResult Save(int id) { using (IMDBEntities dc = new IMDBEntities()) { var v = dc.Movies.Where(a => a.MovieID == id).FirstOrDefault(); return(View(v)); } }
public int UD(string username) { using (var entities = new IMDBEntities()) { var user = entities.Users.SingleOrDefault(b => b.Login == username); return _mapper.Map<BasketDTO>(user.UserID); } }
public List<BasketDTO> GetAllBaskets() { using (var entities = new IMDBEntities()) { var baskets = entities.Basket.ToList(); return _mapper.Map<List<BasketDTO>>(baskets); } }
public List <CategoriesDTO> GetAllCategories() { using (var entities = new IMDBEntities()) { var categories = entities.Category.ToList(); return(_mapper.Map <List <CategoriesDTO> >(categories)); } }
public ActionResult GetMovieDetails() { using (IMDBEntities dc = new IMDBEntities()) { var movies = dc.Movies.OrderBy(a => a.MovieName).ToList(); return(Json(new { data = movies }, JsonRequestBehavior.AllowGet)); } }
public void AddBook(string t, int id) { using (var entities = new IMDBEntities()) { Basket b = _mapper.Map<Basket>(basket); entities.Basket.AddBook(t,id); entities.SaveChanges(); } }
public BasketDTO CreateBasket(BasketDTO basket) { using (var entities = new IMDBEntities()) { Basket b = _mapper.Map<Basket>(basket); entities.Basket.Add(b); entities.SaveChanges(); return _mapper.Map<BasketDTO>(b); } }
public ActionResult Create(MovieModel movie) { IList <MovieModel> newMovie = new List <MovieModel>(); var upload = new MovieModel(); using (var ctx = new IMDBEntities()) { if (movie.ID == 0) { upload = new MovieModel { ID = movie.ID, Name = movie.Name, Plot = movie.Plot, ProducerId = movie.ProducerId, producerName = movie.producerName, YearOfRelease = movie.YearOfRelease, IsDeleted = false }; if (movie.File != null) { string name = Path.GetFileName(movie.File.FileName); string relativePath = "~/uploads/" + name; string physicalPath = Server.MapPath(relativePath); movie.File.SaveAs(physicalPath); upload.Poster = name; } else { TempData["ErrorMessage"] = "Try Again"; return(RedirectToAction("Index")); } ctx.Movies.Add(Mapper.Map <MovieModel, Movie>(upload)); ctx.SaveChanges(); } else { if (movie.File != null) { string name = Path.GetFileName(movie.File.FileName); string relativePath = "~/uploads/" + name; string physicalPath = Server.MapPath(relativePath); movie.File.SaveAs(physicalPath); movie.Poster = name; } var existMovie = ctx.Movies.FirstOrDefault(m => m.ID == movie.ID); existMovie.IsDeleted = false; Mapper.Map(movie, existMovie); ctx.SaveChanges(); } } return(RedirectToAction("Index")); }
public ActionResult Delete(int id) { using (var ctx = new IMDBEntities()) { var existRecord = ctx.Movies.Single(m => m.ID == id); if (existRecord != null) { existRecord.IsDeleted = true; ctx.SaveChanges(); } } return(RedirectToAction("Index")); }
public ActionResult Delete(int id) { using (var ctx = new IMDBEntities()) { var existRecord = ctx.Producers.FirstOrDefault(p => p.ID == id); if (existRecord != null) { existRecord.IsDeleted = true; ctx.SaveChanges(); } } return(RedirectToAction("Index")); }
public ActionResult Delete(int id) { using (IMDBEntities dc = new IMDBEntities()) { var v = dc.Movies.Where(a => a.MovieID == id).FirstOrDefault(); if (v != null) { return(View(v)); } else { return(HttpNotFound()); } } }
public void DeleteBasket(int id) { using (var entities = new IMDBEntities()) { var b = entities.Baskets.SingleOrDefault(bb => bb.BasketID == id); if (b == null) { return; } entities.Baskets.Remove(b); entities.SaveChanges(); } }
public List <BooksDTO> Find(string text, string category) { using (var entities = new IMDBEntities()) { var bookInDB = entities.Books.SingleOrDefault(b => b.Title == text && b.Category == category); if (bookInDB == null) { entities.Books.Add(bookInDB); } else { _mapper.Map(bookInDB); } entities.SaveChanges(); return(_mapper.Map <BooksDTO>(bookInDB)); } }
public ActionResult Create(int?id) { if (id != null) { using (var ctx = new IMDBEntities()) { var existProducer = ctx.Producers.FirstOrDefault(p => p.ID == id); if (existProducer != null) { var editProducer = Mapper.Map <Producer, ProducerModel>(existProducer); return(View(editProducer)); } } } return(View()); }
// GET: Producer public ActionResult Index() { IList <ProducerModel> producers = new List <ProducerModel>(); using (var ctx = new IMDBEntities()) { producers = ctx.Producers.Where(p => p.IsDeleted == false).Select(p => new ProducerModel() { ID = p.ID, Name = p.Name, Bio = p.Bio, DOB = p.DOB, Sex = p.Sex, }).ToList <ProducerModel>(); } return(View(producers)); }
public void UpdateBasket(int id,int Sid) { using (var entities = new IMDBEntities()) { var basketInDB = entities.Baskets.SingleOrDefault(b => b.ID == id); if (basketInDB == null) { entities.Baskets.Add(basketInDB); } else { _mapper.Map(basketInDB); } entities.SaveChanges(); //return _mapper.Map<BasketDTO>(basketInDB); } }
public ActionResult DeleteMovie(int id) { bool status = false; using (IMDBEntities dc = new IMDBEntities()) { var v = dc.Movies.Where(a => a.MovieID == id).FirstOrDefault(); if (v != null) { dc.Movies.Remove(v); dc.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
public ActionResult Index() { IList <ActorModel> actors = new List <ActorModel>(); using (var ctx = new IMDBEntities()) { actors = ctx.ActorDetails.Where(a => a.IsDeleted == false).Select(a => new ActorModel() { ID = a.ID, Name = a.Name, Bio = a.Bio, DOB = a.DOB, Sex = a.Sex, MovieName = a.MovieName }).ToList <ActorModel>(); } return(View(actors)); }
// GET: Movie public ActionResult Index() { IList <MovieModel> movies = new List <MovieModel>(); using (var ctx = new IMDBEntities()) { movies = ctx.MovieDetails.Where(m => m.IsDeleted == false).Select(m => new MovieModel() { ID = m.ID, Name = m.Name, Plot = m.Plot, Poster = m.Poster, producerName = m.ProducerName, YearOfRelease = m.YearOfRelease, }).ToList <MovieModel>(); } return(View(movies)); }
public ActionResult Create(ProducerModel producer) { using (var ctx = new IMDBEntities()) { if (producer.ID == 0) { var newProducer = ctx.Producers.Add(Mapper.Map <ProducerModel, Producer>(producer)); newProducer.IsDeleted = false; } else { var existProducer = ctx.Producers.FirstOrDefault(p => p.ID == producer.ID); if (existProducer != null) { existProducer.IsDeleted = false; Mapper.Map(producer, existProducer); } } ctx.SaveChanges(); } return(RedirectToAction("Index")); }
public ActionResult Create(ActorModel actor) { using (var ctx = new IMDBEntities()) { if (actor.ID == 0) { var newActor = ctx.Actors.Add(Mapper.Map <ActorModel, Actor>(actor)); newActor.IsDeleted = false; } else { var existActor = ctx.Producers.FirstOrDefault(p => p.ID == actor.ID); if (existActor != null) { existActor.IsDeleted = false; Mapper.Map(actor, existActor); } } ctx.SaveChanges(); } return(RedirectToAction("Index")); }