public ActionResult AddPeliculas(Pelicula model)
{
pelicula obj = new pelicula();
obj.idPelicula = model.Id;
obj.titulo = model.Titulo;
obj.duracion = model.Duracion;
obj.publicacion = model.Publicacion;
if (model.Id == 0)
{
dbobj.pelicula.Add(obj);
dbobj.SaveChanges();
}
else
{
dbobj.Entry(obj).State = System.Data.Entity.EntityState.Modified;
dbobj.SaveChanges();
}
return(Redirect("PeliculasList/"));
// return View("Peliculas");
}
public IHttpActionResult Putpelicula(int id, pelicula pelicula)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != pelicula.idpelicula)
{
return(BadRequest());
}
db.Entry(pelicula).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!peliculaExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Create([Bind(Include = "nombre,genero,duracion,director,sinopsis,lanzamiento,categoria,imagen")] pelicula pelicula)
{
if (isSession())
{
if (ModelState.IsValid)
{
/*string theFileName = Path.GetFileName(pelicula.img.FileName);
* byte[] thePictureAsBytes = new byte[pelicula.img.ContentLength];
* using (BinaryReader theReader = new BinaryReader(pelicula.img.InputStream))
* {
* thePictureAsBytes = theReader.ReadBytes(pelicula.img.ContentLength);
* }
* string thePictureDataAsString = Convert.ToBase64String(thePictureAsBytes);
* Console.Write("PRUEBA DAMIAN " + thePictureDataAsString);
* pelicula.imagen = thePictureDataAsString;*/
using (var context = new cineDBEntities())
{
HttpPostedFileBase file = Request.Files[0];
InputStream finput = new FileInputStream(file.InputStream);
byte[] imageBytes = new byte[(int)file.InputStream.Length];
finput.Read(imageBytes, 0, imageBytes.Length);
finput.Close();
String imageStr = Base64.ToBase64String(imageBytes);
var std = new pelicula()
{
nombre = pelicula.nombre,
genero = pelicula.genero,
duracion = pelicula.duracion,
director = pelicula.director,
sinopsis = pelicula.sinopsis,
lanzamiento = pelicula.lanzamiento,
categoria = pelicula.categoria,
imagen = imageStr
};
context.peliculas.Add(std);
try
{
context.SaveChanges();
}
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
System.Diagnostics.Debug.WriteLine("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
}
}
return(RedirectToAction("Index"));
}
return(View(pelicula));
}
else
{
return(RedirectToAction("Login", "Login"));
}
}
public ActionResult DeleteConfirmed(decimal id)
{
pelicula pelicula = db.pelicula.Find(id);
db.pelicula.Remove(pelicula);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "idpelicula,nombre,categoria,fecha_lanz,duracion_min")] pelicula pelicula)
{
if (ModelState.IsValid)
{
PeliculaBLL.Update(pelicula);
return(RedirectToAction("Index"));
}
return(View(pelicula));
}
public ActionResult Edit([Bind(Include = "pel_idPel,pel_nombre,pel_clasificacion,pel_idioma,pel_detalle")] pelicula pelicula)
{
if (ModelState.IsValid)
{
db.Entry(pelicula).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(pelicula));
}
public IHttpActionResult Getpelicula(int id)
{
pelicula pelicula = db.pelicula.Find(id);
if (pelicula == null)
{
return(NotFound());
}
return(Ok(pelicula));
}
public ActionResult Create([Bind(Include = "pel_idPel,pel_nombre,pel_clasificacion,pel_idioma,pel_detalle")] pelicula pelicula)
{
if (ModelState.IsValid)
{
db.pelicula.Add(pelicula);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(pelicula));
}
public bool CreateMovie(pelicula movie)
{
movieContext.pelicula.Add(movie);
if (movieContext.SaveChanges() == 1)
{
return(true);
}
else
{
return(false);
}
}
public IHttpActionResult Postpelicula(pelicula pelicula)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.pelicula.Add(pelicula);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = pelicula.idpelicula }, pelicula));
}
//CREAR PELICULA
public IHttpActionResult AgregaPelicula([FromBody] pelicula pel)
{
if (ModelState.IsValid)
{
dbContext.peliculas.Add(pel);
dbContext.SaveChanges();
return(Ok(pel));
}
else
{
return(BadRequest());
}
}
public ActionResult Edit([Bind(Include = "id,nombre,genero,duracion,director,sinopsis,lanzamiento,categoria,imagen")] pelicula pelicula)
{
if (isSession())
{
if (ModelState.IsValid)
{
using (var context = new cineDBEntities())
{
var result = db.peliculas.Find(pelicula.Id);
if (result != null)
{
HttpPostedFileBase file = Request.Files[0];
InputStream finput = new FileInputStream(file.InputStream);
byte[] imageBytes = new byte[(int)file.InputStream.Length];
finput.Read(imageBytes, 0, imageBytes.Length);
finput.Close();
String imageStr = Base64.ToBase64String(imageBytes);
result.nombre = pelicula.nombre;
result.genero = pelicula.genero;
result.duracion = pelicula.duracion;
result.director = pelicula.director;
result.sinopsis = pelicula.sinopsis;
result.lanzamiento = pelicula.lanzamiento;
result.categoria = pelicula.categoria;
result.imagen = imageStr;
/*var std = new pelicula()
* {
* Id = pelicula.Id,
* nombre = pelicula.nombre,
* genero = pelicula.genero,
* duracion = pelicula.duracion,
* director = pelicula.director,
* sinopsis = pelicula.sinopsis,
* lanzamiento = pelicula.lanzamiento,
* categoria = pelicula.categoria,
* imagen = imageStr
* };*/
context.Entry(result).State = EntityState.Modified;
db.SaveChanges();
}
}
}
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("Login", "Login"));
}
}
// GET: Peliculas/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
pelicula pelicula = PeliculaBLL.Get(id);
if (pelicula == null)
{
return(HttpNotFound());
}
return(View(pelicula));
}
public IHttpActionResult Deletepelicula(int id)
{
pelicula pelicula = db.pelicula.Find(id);
if (pelicula == null)
{
return(NotFound());
}
db.pelicula.Remove(pelicula);
db.SaveChanges();
return(Ok(pelicula));
}
public ActionResult DeleteConfirmed(int id)
{
if (isSession())
{
pelicula pelicula = db.peliculas.Find(id);
db.peliculas.Remove(pelicula);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("Login", "Login"));
}
}
// GET: peliculas/Delete/5
public ActionResult Delete(decimal id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
pelicula pelicula = db.pelicula.Find(id);
if (pelicula == null)
{
return(HttpNotFound());
}
return(View(pelicula));
}
// GET: peliculas/Details/5
public ActionResult Details(int?id)
{
if (isSession())
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
pelicula pelicula = db.peliculas.Find(id);
if (pelicula == null)
{
return(HttpNotFound());
}
return(View(pelicula));
}
else
{
return(RedirectToAction("Login", "Login"));
}
}
//TBLL Transactional Bissines Logic Layer
//Capa de Logica del Negocio
public static void Create(pelicula p)
{ //Se crea una instancia de la Entidad Base de datos
using (Entities db = new Entities())
{
//Se crea una instancia de la transaccion
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.peliculas.Add(p);
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public static void Update(pelicula pelicula)
{
using (Entities db = new Entities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.peliculas.Attach(pelicula);
db.Entry(pelicula).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public static void Delete(int?id)
{
using (Entities db = new Entities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
pelicula pelicula = db.peliculas.Find(id);
db.Entry(pelicula).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public bool updateMovie(pelicula movie)
{
var result = movieContext.pelicula.FirstOrDefault(m => m.id_pelicula == movie.id_pelicula);
if (result != null)
{
result.nombre = movie.nombre;
result.genero = movie.genero;
result.duracion = movie.duracion;
result.foto = movie.foto;
result.resumen = movie.resumen;
result.rango_fechas = "";
}
if (movieContext.SaveChanges() == 1)
{
return(true);
}
else
{
return(false);
}
}
public void RegistroPeliculaExitoso()
{
pelicula peli = new pelicula();
peli.nombre = "Endgame";
bool realResult;
bool result = true;
ViewModel.WorkingItem = peli;
ViewModel.Add(new object());
DbSet <pelicula> dbset = ViewModel.db.pelicula as DbSet <pelicula>;
if (dbset.Where(value => value.nombre == peli.nombre).Count() > 0)
{
realResult = true;
}
else
{
realResult = false;
}
Assert.AreEqual(realResult, result);
}
//Modificacion pelicula
public IHttpActionResult ActualizarPelicula(string id, [FromBody] pelicula pel)
{
if (ModelState.IsValid)
{
var PeliculaExiste = dbContext.peliculas.Count(c => c.id.Equals(id)) > 0;
if (PeliculaExiste)
{
dbContext.Entry(pel).State = EntityState.Modified;
dbContext.SaveChanges();
return(Ok());
}
else
{
return(NotFound());
}
}
else
{
return(BadRequest());
}
}
public ActionResult Peliculas(pelicula obj)
{
return(View(obj));
}
