public IHttpActionResult Putmovies(int id, movy movies)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != movies.id)
{
return(BadRequest());
}
db.Entry(movies).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!moviesExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult DeleteConfirmed(int id)
{
movy movy = db.movie.Find(id);
db.movie.Remove(movy);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Title,Director,DateReleased")] movy movy)
{
if (ModelState.IsValid)
{
db.Entry(movy).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(movy));
}
public ActionResult Create([Bind(Include = "Id,Title,Director,DateReleased")] movy movy)
{
if (ModelState.IsValid)
{
db.movie.Add(movy);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(movy));
}
public IHttpActionResult Getmovies(int id)
{
movy movies = db.movies.Find(id);
if (movies == null)
{
return(NotFound());
}
return(Ok(movies));
}
public IHttpActionResult Postmovies(movy movies)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.movies.Add(movies);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = movies.id }, movies));
}
public string GetAllProducts()
{
List <movy> pro = new List <movy>();
using (movieoutletEntities contex = new movieoutletEntities())
{
var productList = from m in contex.movies select m;
movy pros = new movy();
pro = productList.ToList();
JavaScriptSerializer json = new JavaScriptSerializer();
return(json.Serialize(pro));
}
}
public IHttpActionResult Deletemovies(int id)
{
movy movies = db.movies.Find(id);
if (movies == null)
{
return(NotFound());
}
db.movies.Remove(movies);
db.SaveChanges();
return(Ok(movies));
}
public string Delete(int id)
{
movy itm = new movy();
using (movieoutletEntities contex = new movieoutletEntities())
{
JavaScriptSerializer json = new JavaScriptSerializer();
var productList = from m in contex.movies where m.Id == id select m;
itm = productList.First();
contex.movies.Remove(itm);
contex.SaveChanges();
return(json.Serialize("Successful"));
}
}
// GET: movies/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
movy movy = db.movie.Find(id);
if (movy == null)
{
return(HttpNotFound());
}
return(View(movy));
}
public ObjectResponse <int> AddorUpdate(MovieDTO movieDTO)
{
try
{
if (movieDTO != null)
{
var movie = _unitOfWork.MoviesRepository.GetFirstWhere(x => x.movie_id == movieDTO.Id);
if (movie != null)
{
movie.price = movieDTO.Price;
movie.title = movieDTO.Title;
movie.year = movieDTO.Year;
}
else
{
var id = (_unitOfWork.MoviesRepository.GetAll().OrderByDescending(x => x.movie_id).FirstOrDefault()?.movie_id + 1) ?? 1;
movie = new movy
{
movie_id = id,
age_restriction = movieDTO.AgeRestriction,
title = movieDTO.Title,
price = movieDTO.Price,
year = movieDTO.Year,
};
_unitOfWork.MoviesRepository.Add(movie);
return(AddMovieCopy(movie));
}
return(_unitOfWork.SaveChanges() > 0 ?
new ObjectResponse <int> {
Success = true, Data = movie.movie_id
} : new ObjectResponse <int> {
Success = false, Error = DB_SAVE_ERROR
});
}
return(new ObjectResponse <int> {
Success = false, Error = "Invalid Supplied Parameters", Info = DB_SAVE_ERROR
});
}
catch (Exception ex)
{
return(new ObjectResponse <int>
{
Success = false,
Error = ex.GetBaseException().Message,
Info = DB_ERROR_INSERT
});
}
}
public string Post(movy pro)
{
JavaScriptSerializer json = new JavaScriptSerializer();
movy itm = new movy();
itm.Id = pro.Id;
itm.Name = pro.Name;
itm.Category = pro.Category;
itm.Price = pro.Price;
itm.Description = pro.Description;
using (movieoutletEntities contex = new movieoutletEntities())
{
contex.movies.Add(itm);
contex.SaveChanges();
return(json.Serialize("Successful"));
}
}
public IHttpActionResult GetCat(string category)
{
List <movy> pro = new List <movy>();
using (movieoutletEntities contex = new movieoutletEntities())
{
var productList = from m in contex.movies where m.Category == category select m;
movy pros = new movy();
pro = productList.ToList();
JavaScriptSerializer json = new JavaScriptSerializer();
if (pro == null)
{
return(NotFound());
}
return(Ok(json.Serialize(pro)));
}
}
public IHttpActionResult GetProduct(int id)
{
List <movy> pro = new List <movy>();
using (movieoutletEntities contex = new movieoutletEntities())
{
var movieList = from m in contex.movies select m;
movy pros = new movy();
pro = movieList.ToList();
JavaScriptSerializer json = new JavaScriptSerializer();
var product = pro.FirstOrDefault((p) => p.Id == id);
if (product == null)
{
return(NotFound());
}
return(Ok(json.Serialize(product)));
}
}
private ObjectResponse <int> AddMovieCopy(movy movie)
{
var movieCopy = _copiesLogic.GetLastCopy();
if (!movieCopy.Success)
{
return(new ObjectResponse <int> {
Success = false, Error = movieCopy.Error, Info = movieCopy.Info
});
}
var copyId = (movieCopy.Data?.Id + 1) ?? 1;
var addCopyResult = _copiesLogic.AddOrUpdate(copyId, movie.movie_id, true);
return(addCopyResult.Success ? new ObjectResponse <int> {
Success = true, Data = copyId
} :
new ObjectResponse <int> {
Success = false, Error = addCopyResult.Error, Info = addCopyResult.Info
});
}
public static MovieDTO Create(movy movie)
{
return(new MovieDTO
{
Id = movie.movie_id,
Title = movie.title,
Year = movie.year,
AgeRestriction = movie.age_restriction,
Price = movie.price.Value,
Actors = movie?.actors?.Select(x => new ActorDTO
{
Birthday = x.birthday?.DateTime,
FirstName = x.first_name,
LastName = x.last_name,
Id = x.actor_id
}).ToList(),
Copies = movie?.copies?.Select(x => new CopyDTO
{
Available = x.available,
Id = x.copy_id
}).ToList()
});
}
public string Update(int id, movy pro)
{
movy itm = new movy();
using (movieoutletEntities contex = new movieoutletEntities())
{
JavaScriptSerializer json = new JavaScriptSerializer();
var productList = from m in contex.movies where m.Id == id select m;
itm = productList.First();
contex.movies.Remove(itm);
contex.SaveChanges();
itm.Id = pro.Id;
itm.Name = pro.Name;
itm.Category = pro.Category;
itm.Price = pro.Price;
itm.Description = pro.Description;
contex.movies.Add(itm);
contex.SaveChanges();
return(json.Serialize("Successful"));
}
}
