public ActionResult DeleteConfirmed(int id)
        {
            ObraArtistica obraArtistica = db.ObraArtisticas.Find(id);

            db.ObraArtisticas.Remove(obraArtistica);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "ID,nombre,numeroAutores")] ObraArtistica obraArtistica)
 {
     if (ModelState.IsValid)
     {
         db.Entry(obraArtistica).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(obraArtistica));
 }
        // GET: ObraArtistica/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            ObraArtistica obraArtistica = db.ObraArtisticas.Find(id);

            if (obraArtistica == null)
            {
                return(HttpNotFound());
            }
            return(View(obraArtistica));
        }
        public ActionResult createObraArtistica([Bind(Include = "ID,nombre,numeroAutores,autores,autorXObraArtis")] ObraArteAutor arteAutor, HttpPostedFileBase upload, HttpPostedFileBase uploadCert)
        {
            try
            {
                ObraArtistica obraArte = new ObraArtistica();
                obraArte.nombre        = arteAutor.nombre;
                obraArte.numeroAutores = arteAutor.numeroAutores;
                db.ObraArtisticas.Add(obraArte);
                db.SaveChanges();

                PersonaXObraArtistica personaX = new PersonaXObraArtistica();
                personaX.id_persona        = Int32.Parse(Session["ID"].ToString());
                personaX.id_obra_artistica = obraArte.ID;
                db.PersonaXObraArtisticas.Add(personaX);
                db.SaveChanges();

                for (int i = 0; i < arteAutor.numeroAutores; i++)
                {
                    Autor autor = new Autor();
                    autor.nombre            = arteAutor.autores.ElementAt(i).nombre;
                    autor.correoElectronico = arteAutor.autores.ElementAt(i).correoElectronico;
                    db.Autors.Add(autor);
                    db.SaveChanges();
                    AutorXObraArtistica autorXobraArte = new AutorXObraArtistica();
                    autorXobraArte.id_obra_artistica   = obraArte.ID;
                    autorXobraArte.id_autor            = autor.ID;
                    autorXobraArte.distribucionAutoria = Convert.ToDecimal(arteAutor.autorXObraArtis.ElementAt(i).distribucionAutoria);
                    db.AutorXObraArtisticas.Add(autorXobraArte);
                    db.SaveChanges();
                }

                if (upload != null)
                {
                    upload.SaveAs(Path.Combine(Server.MapPath("~/App_Data/uploads"), upload.FileName));
                    string fullPath = Path.Combine(Server.MapPath("~/App_Data/uploads"), upload.FileName);
                    InsertObraArte(System.Guid.NewGuid(), System.IO.Path.GetFileName(upload.FileName), fullPath, 0, obraArte.ID);
                    //Path.GetFullPath(upload.FileName);
                }
                if (uploadCert != null)
                {
                    upload.SaveAs(Path.Combine(Server.MapPath("~/App_Data/uploads"), uploadCert.FileName));
                    string fullPath = Path.Combine(Server.MapPath("~/App_Data/uploads"), uploadCert.FileName);
                    InsertObraArte(System.Guid.NewGuid(), System.IO.Path.GetFileName(uploadCert.FileName), fullPath, 1, obraArte.ID);
                    //Path.GetFullPath(upload.FileName);
                }

                ViewBag.obraAgregado = obraArte.nombre;
                return(View());
            }
            catch (DbEntityValidationException dbEx)
            {
                foreach (var validationErrors in dbEx.EntityValidationErrors)
                {
                    foreach (var validationError in validationErrors.ValidationErrors)
                    {
                        ViewBag.errorObra = "Error: " + dbEx;
                        Trace.TraceInformation("Property: {0} Error: {1}",
                                               validationError.PropertyName,
                                               validationError.ErrorMessage);
                    }
                }
                return(View());
            }
        }