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"));
}
