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