public ActionResult Edit(tblLibros libros, int id) { db.Entry(libros).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "idotorgante,nombres,apellidos,redsocial,telefono,correo,fechanacimiento,lugarnacimiento,Id_Municipio,Id_Departamento")] tblOtorgante tblOtorgante) { if (ModelState.IsValid) { db.Entry(tblOtorgante).State = EntityState.Modified; db.SaveChanges(); /*NOTIFICACION*/ ApplicationDbContext dbs = new ApplicationDbContext(); Notifications notificacion = new Notifications(); notificacion.Module = "Otorgantes"; notificacion.Message = string.Format("Edito un Otorgante"); notificacion.Date = DateTime.Now; notificacion.Viewed = false; notificacion.Usuario_Id = User.Identity.GetUserId(); dbs.Notification.Add(notificacion); dbs.SaveChanges(); /*FIN NOTIFICACION*/ return(RedirectToAction("Index")); } ViewBag.Id_Departamento = new SelectList(db.tblDepartamentos, "Id_Departamento", "Departamento"); ViewBag.Id_Municipio = new SelectList(db.tblMunicipios, "id_Municipio", "Municipio"); return(View(tblOtorgante)); }
public IHttpActionResult PutinfoMaster(int id, infoMaster infoMaster) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != infoMaster.Id) { return(BadRequest()); } db.Entry(infoMaster).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!infoMasterExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PutLoginDetail(int id, LoginDetail loginDetail) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != loginDetail.loginid) { return(BadRequest()); } db.Entry(loginDetail).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!LoginDetailExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult Edit(tblAfavorde af) { ViewBag.Id_Departamento = new SelectList(db.tblDepartamentos, "Id_Departamento", "Departamento"); ViewBag.Id_Municipio = new SelectList(db.tblMunicipios, "id_Municipio", "Municipio"); if (ModelState.IsValid) { db.Entry(af).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); /*NOTIFICACION*/ ApplicationDbContext dbs = new ApplicationDbContext(); Notifications notificacion = new Notifications(); notificacion.Module = "A favor de"; notificacion.Message = string.Format("Edito un A/F"); notificacion.Date = DateTime.Now; notificacion.Viewed = false; notificacion.Usuario_Id = User.Identity.GetUserId(); dbs.Notification.Add(notificacion); dbs.SaveChanges(); /*FIN NOTIFICACION*/ return(RedirectToAction("Index")); } return(View()); }
public ActionResult Edit([Bind(Include = "Id_Personal,Nombres,Apellidos,redsocial,Telefono,Correo,Direccion,Fecha_Nacimiento,id_CategoriaPersonal,Id_EstadoRegistro,Fecha_Agregado")] tblPersonal tblPersonal) { if (ModelState.IsValid) { db.Entry(tblPersonal).State = EntityState.Modified; db.SaveChanges(); /*NOTIFICACION*/ ApplicationDbContext dbs = new ApplicationDbContext(); Notifications notificacion = new Notifications(); notificacion.Module = "Personal"; notificacion.Message = string.Format("Edito informacion de personal"); notificacion.Date = DateTime.Now; notificacion.Viewed = false; notificacion.Usuario_Id = User.Identity.GetUserId(); dbs.Notification.Add(notificacion); dbs.SaveChanges(); /*FIN NOTIFICACION*/ return(RedirectToAction("Index")); } ViewBag.id_CategoriaPersonal = new SelectList(db.tblCategoriaPersonal, "id_CategoriaPersonal", "CategoriaPersonal", tblPersonal.id_CategoriaPersonal); ViewBag.Id_EstadoRegistro = new SelectList(db.tblEstadosRegistros, "Id_EstadoRegistro", "Estado", tblPersonal.Id_EstadoRegistro); return(View(tblPersonal)); }
public IHttpActionResult PutUsuario(int id, Usuario usuario) { if (id != usuario.Id) { return(BadRequest()); } db.Entry(usuario).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!UsuarioExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult Edit([Bind(Include = "Id_Caso,Id_Cliente,Id_Categoria,Id_EstadoCaso,Id_Departamento,Id_Municipio,Id_Juzgado,Titulo,Numero_Caso,Fecha_Inicio,Fecha_Audiencia,Fecha_Agregado")] tblCasos tblCasos) { if (ModelState.IsValid) { db.Entry(tblCasos).State = EntityState.Modified; db.SaveChanges(); /*NOTIFICACION*/ ApplicationDbContext dbs = new ApplicationDbContext(); Notifications notificacion = new Notifications(); notificacion.Module = "Casos"; notificacion.Message = string.Format("Edito un caso"); notificacion.Date = DateTime.Now; notificacion.Viewed = false; notificacion.Usuario_Id = User.Identity.GetUserId(); dbs.Notification.Add(notificacion); dbs.SaveChanges(); /*FIN NOTIFICACION*/ return(RedirectToAction("Index")); } ViewBag.Id_Categoria = new SelectList(db.tblCategorias, "Id_Categoria", "Nombre_Categoria", tblCasos.Id_Categoria); ViewBag.Id_Cliente = new SelectList(db.tblClientes, "Id_Cliente", "NombreCompleto", tblCasos.Id_Cliente); ViewBag.Id_Departamento = new SelectList(db.tblDepartamentos, "Id_Departamento", "Departamento", tblCasos.Id_Departamento); ViewBag.Id_EstadoCaso = new SelectList(db.tblEstadosCasos, "Id_EstadoCaso", "Nombre_Estado", tblCasos.Id_EstadoCaso); ViewBag.Id_Juzgado = new SelectList(db.tblJuzgados, "Id_Juzgado", "Juzgado", tblCasos.Id_Juzgado); ViewBag.Id_Municipio = new SelectList(db.tblMunicipios, "id_Municipio", "Municipio", tblCasos.Id_Municipio); return(View(tblCasos)); }
public IHttpActionResult PutEmpolyee(int id, Empolyee empolyee) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != empolyee.EmployeeId) { return(BadRequest()); } db.Entry(empolyee).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!EmpolyeeExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PutDESIGNATION(int id, DESIGNATION dESIGNATION) { //if (!ModelState.IsValid) //{ // return BadRequest(ModelState); //} if (id != dESIGNATION.DG_ID) { return(BadRequest()); } db.Entry(dESIGNATION).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!DESIGNATIONExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult Edit([Bind(Include = "Id_Departamento,Departamento")] tblDepartamentos tblDepartamentos) { if (ModelState.IsValid) { db.Entry(tblDepartamentos).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tblDepartamentos)); }
public ActionResult Edit([Bind(Include = "Id_EstadoCaso,Nombre_Estado")] tblEstadosCasos tblEstadosCasos) { if (ModelState.IsValid) { db.Entry(tblEstadosCasos).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tblEstadosCasos)); }
public ActionResult Edit([Bind(Include = "Id_Categoria,Nombre_Categoria")] tblCategorias tblCategorias) { if (ModelState.IsValid) { db.Entry(tblCategorias).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tblCategorias)); }
public ActionResult Edit([Bind(Include = "id_Municipio,Municipio,Id_Departamento")] tblMunicipios tblMunicipios) { if (ModelState.IsValid) { db.Entry(tblMunicipios).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Id_Departamento = new SelectList(db.tblDepartamentos, "Id_Departamento", "Departamento", tblMunicipios.Id_Departamento); return(View(tblMunicipios)); }
/// <summary> /// Adds <paramref name="Donor"/> to the db. /// </summary> /// <param name="Donor">The donate.</param> /// <returns>Id of added donor</returns> public string CreateDonor(Donor Donor) { if (!context.Donors.Any(x => x.PESEL == Donor.PESEL)) { context.Entry(Donor).State = EntityState.Added; context.SaveChanges(); return(Donor.PESEL); } else { return(""); } }
/// <summary> /// Adds or edits the <paramref name="Acceptor"/> to the db. /// </summary> /// <param name="Acceptor">The donate.</param> /// <returns>ID of added of edited acceptor.</returns> public int CreateAcceptor(Acceptor Acceptor) { if ((Acceptor.User.Id == 0) && (context.Users.FirstOrDefault(x => x.Login == Acceptor.User.Login) != default(User))) { return(0); } context.Entry(Acceptor).State = Acceptor.Id == 0 ? EntityState.Added : EntityState.Modified; context.SaveChanges(); return(Acceptor.Id); }
public ActionResult Edit([Bind(Include = "idEditable,fecha,entidad,instrumento,documento,tipo_documento,img,descripcion")] tblEditables tblEditables) { if (ModelState.IsValid) { if (Request.Files.Count > 0) { HttpPostedFileBase file = Request.Files[0]; if (file.ContentLength > 0) { var img = (file.FileName).ToLower(); tblEditables.img = "/Content/Editables/" + img; file.SaveAs(Server.MapPath("~/Content/Editables/") + img); } var queryarchivo = (from x in db.tblEditables where x.idEditable == tblEditables.idEditable select x.img).First(); if (file.ContentLength == 0) { //var query = (from x in db.tblLibros // where x.idlibros == tblLibros.idlibros // select x.word).First(); //tblLibros.img = query.img; tblEditables.img = queryarchivo; } } db.Entry(tblEditables).State = EntityState.Modified; db.SaveChanges(); /*NOTIFICACION*/ ApplicationDbContext dbs = new ApplicationDbContext(); Notifications notificacion = new Notifications(); notificacion.Module = "Editables"; notificacion.Message = string.Format("Edito un archivo editable"); notificacion.Date = DateTime.Now; notificacion.Viewed = false; notificacion.Usuario_Id = User.Identity.GetUserId(); dbs.Notification.Add(notificacion); dbs.SaveChanges(); /*FIN NOTIFICACION*/ return(RedirectToAction("Index")); } return(View(tblEditables)); }
public ActionResult Edit([Bind(Include = "Id_Historial,Id_Caso,Fecha_Inicio,Fecha_Final,Descripcion,Archivo,Fecha_Agregado")] tblHistorial tblHistorial) { if (ModelState.IsValid) { if (Request.Files.Count > 0) { HttpPostedFileBase file = Request.Files[0]; if (file.ContentLength > 0) { var img = (file.FileName).ToLower(); tblHistorial.Archivo = "/Content/Historial/" + img; file.SaveAs(Server.MapPath("~/Content/Historial/") + img); } var queryarchivo = (from x in db.tblHistorial where x.Id_Historial == tblHistorial.Id_Historial select x.Archivo).First(); if (file.ContentLength == 0) { //var query = (from x in db.tblLibros // where x.idlibros == tblLibros.idlibros // select x.word).First(); //tblLibros.img = query.img; tblHistorial.Archivo = queryarchivo; } } db.Entry(tblHistorial).State = EntityState.Modified; db.SaveChanges(); /*NOTIFICACION*/ ApplicationDbContext dbs = new ApplicationDbContext(); Notifications notificacion = new Notifications(); notificacion.Module = "Historial"; notificacion.Message = string.Format("Edito un historial"); notificacion.Date = DateTime.Now; notificacion.Viewed = false; notificacion.Usuario_Id = User.Identity.GetUserId(); dbs.Notification.Add(notificacion); dbs.SaveChanges(); /*FIN NOTIFICACION*/ return(RedirectToAction("Index")); } ViewBag.Id_Caso = new SelectList(db.tblCasos, "Id_Caso", "Numero_Caso", tblHistorial.Id_Caso); return(View(tblHistorial)); }
public ActionResult Edit(int id, Table_1 table_1) { try { using (dbModel Dbmodel = new dbModel()) { Dbmodel.Entry(table_1).State = EntityState.Modified; Dbmodel.SaveChanges(); } // TODO: Add update logic here return(RedirectToAction("Index")); } catch { return(View()); } }
/// <summary> /// Adds <paramref name="Donate"/> th the db and makes changes to the statistics. /// </summary> /// <param name="Donate">The donate.</param> /// <returns>Id of added donate</returns> public int CreateDonate(Donate Donate) { context.Donates.Add(Donate); BloodTypeMarker BloodTypeMarker; switch (Donate.Donor.Blood_Type) { case BloodType.O: BloodTypeMarker = BloodTypeMarker.O; break; case BloodType.A: BloodTypeMarker = BloodTypeMarker.A; break; case BloodType.B: BloodTypeMarker = BloodTypeMarker.B; break; default: BloodTypeMarker = BloodTypeMarker.AB; break; } if (Donate.Donor.Blood_RhMarker) { BloodTypeMarker += 1; } var stat = context.Statistics.Find(BloodTypeMarker); stat.TotalAmount += Donate.Amount; context.Entry(stat).State = EntityState.Modified; context.SaveChanges(); return(Donate.Id); }
public ActionResult Edit([Bind(Include = "Id_EstadoRegistro,Estado")] tblEstadosRegistros tblEstadosRegistros) { if (ModelState.IsValid) { db.Entry(tblEstadosRegistros).State = EntityState.Modified; db.SaveChanges(); /*Notificacion*/ ApplicationDbContext bd = new ApplicationDbContext(); Notifications notificacion = new Notifications(); notificacion.Module = "Estado de registro Cliente/Personal"; notificacion.Message = string.Format("Edito un estado Cliente/Personal"); notificacion.Date = DateTime.Now; notificacion.Viewed = false; notificacion.Usuario_Id = User.Identity.GetUserId(); bd.Notification.Add(notificacion); bd.SaveChanges(); /*Fin Notificacion*/ return(RedirectToAction("Index")); } return(View(tblEstadosRegistros)); }
public ActionResult Edit([Bind(Include = "id_CategoriaPersonal,CategoriaPersonal")] tblCategoriaPersonal tblCategoriaPersonal) { if (ModelState.IsValid) { db.Entry(tblCategoriaPersonal).State = EntityState.Modified; db.SaveChanges(); /*Notificacion*/ ApplicationDbContext dbs = new ApplicationDbContext(); Notifications notificacion = new Notifications(); notificacion.Module = "Categoria personal"; notificacion.Message = string.Format("Edito una categoria registrada"); notificacion.Date = DateTime.Now; notificacion.Viewed = false; notificacion.Usuario_Id = User.Identity.GetUserId(); dbs.Notification.Add(notificacion); dbs.SaveChanges(); /*Fin Notificacion*/ return(RedirectToAction("Index")); } return(View(tblCategoriaPersonal)); }
public ActionResult Indexx(int txtID, string btnAgregar, string btnEditar, string btnEliminar, string txtFechaInicio, string txtFechaFin, string txtTitulo, string txtHora, string txtDescripcion, string txtColor, tblEventCalendar ev) { if (Request.HttpMethod == "POST") { if (btnAgregar == "agregar") { var datosevento = new tblEventCalendar { id_Event = txtID, title = txtTitulo, descripcion = txtDescripcion, color = txtColor, textColor = "#FFFFFF", start = Convert.ToDateTime(txtFechaInicio + " " + txtHora), end = Convert.ToDateTime(txtFechaFin + " " + txtHora) }; db.tblEventCalendar.Add(datosevento); db.SaveChanges(); /*NOTIFICACION*/ ApplicationDbContext dbs = new ApplicationDbContext(); Notifications notificacion = new Notifications(); notificacion.Module = "Eventos"; notificacion.Message = string.Format("Registro un nuevo evento"); notificacion.Date = DateTime.Now; notificacion.Viewed = false; notificacion.Usuario_Id = User.Identity.GetUserId(); dbs.Notification.Add(notificacion); dbs.SaveChanges(); /*FIN NOTIFICACION*/ return(RedirectToAction("Index", "Home")); } else if (btnEditar == "editar") { var datosevento = new tblEventCalendar { id_Event = txtID, title = txtTitulo, descripcion = txtDescripcion, color = txtColor, textColor = "#FFFFFF", start = Convert.ToDateTime(txtFechaInicio), end = Convert.ToDateTime(txtFechaFin) }; db.tblEventCalendar.Attach(datosevento); db.Entry(datosevento).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); /*NOTIFICACION*/ ApplicationDbContext dbs = new ApplicationDbContext(); Notifications notificacion = new Notifications(); notificacion.Module = "Eventos"; notificacion.Message = string.Format("Edito un evento"); notificacion.Date = DateTime.Now; notificacion.Viewed = false; notificacion.Usuario_Id = User.Identity.GetUserId(); dbs.Notification.Add(notificacion); dbs.SaveChanges(); /*FIN NOTIFICACION*/ return(RedirectToAction("Index", "Home")); } else if (btnEliminar == "eliminar") { var datosevento = new tblEventCalendar { id_Event = txtID, title = txtTitulo, descripcion = txtDescripcion, color = txtColor, textColor = "#FFFFFF", start = Convert.ToDateTime(txtFechaInicio), end = Convert.ToDateTime(txtFechaFin) }; db.tblEventCalendar.Attach(datosevento); db.tblEventCalendar.Remove(datosevento); db.SaveChanges(); /*NOTIFICACION*/ ApplicationDbContext dbs = new ApplicationDbContext(); Notifications notificacion = new Notifications(); notificacion.Module = "Eventos"; notificacion.Message = string.Format("Elimino un evento"); notificacion.Date = DateTime.Now; notificacion.Viewed = false; notificacion.Usuario_Id = User.Identity.GetUserId(); dbs.Notification.Add(notificacion); dbs.SaveChanges(); /*FIN NOTIFICACION*/ return(RedirectToAction("Index", "Home")); } } return(RedirectToAction("Index", "Home")); }
/// <summary> /// Changes Send value of the Order to true. /// </summary> /// <param name="Order">The order.</param> public void MarkAsSend(Order Order) { Order.Send = true; context.Entry(Order).State = EntityState.Modified; context.SaveChanges(); }
public ActionResult Edit([Bind(Include = "idlibros,fecha,correlativo,instrumento,folios,libro,img,word,idotorgante,idfavorde,id_Personal")] tblLibros tblLibros) { if (ModelState.IsValid) { if (Request.Files.Count > 0) { HttpPostedFileBase file = Request.Files[0]; HttpPostedFileBase file2 = Request.Files[1]; if (file.ContentLength > 0) { var img = (file.FileName).ToLower(); tblLibros.img = "/Content/Libros/" + img; file.SaveAs(Server.MapPath("~/Content/Libros/") + img); } if (file2.ContentLength > 0) { var doc = (file2.FileName).ToLower(); tblLibros.word = "/Content/Libros/" + doc; file2.SaveAs(Server.MapPath("~/Content/Libros/") + doc); } var querypdf = (from x in db.tblLibros where x.idlibros == tblLibros.idlibros select x.img).First(); var queryword = (from x in db.tblLibros where x.idlibros == tblLibros.idlibros select x.word).First(); if (file.ContentLength == 0) { tblLibros.img = querypdf; //tblLibros.word = query.word; } if (file2.ContentLength == 0) { //var query = (from x in db.tblLibros // where x.idlibros == tblLibros.idlibros // select x.word).First(); //tblLibros.img = query.img; tblLibros.word = queryword; } db.Entry(tblLibros).State = EntityState.Modified; db.SaveChanges(); } /*NOTIFICACION*/ ApplicationDbContext dbs = new ApplicationDbContext(); Notifications notificacion = new Notifications(); notificacion.Module = "Libros"; notificacion.Message = string.Format("Edito un libro"); notificacion.Date = DateTime.Now; notificacion.Viewed = false; notificacion.Usuario_Id = User.Identity.GetUserId(); dbs.Notification.Add(notificacion); dbs.SaveChanges(); /*FIN NOTIFICACION*/ return(RedirectToAction("Index")); } ViewBag.idfavorde = new SelectList(db.tblAfavorde, "idfavorde", "nombres", tblLibros.idfavorde); ViewBag.idotorgante = new SelectList(db.tblOtorgante, "idotorgante", "nombres", tblLibros.idotorgante); ViewBag.id_Personal = new SelectList(db.tblPersonal, "Id_Personal", "Nombres", tblLibros.id_Personal); return(View(tblLibros)); }
public ActionResult Edit(tblAfavorde favorde, int id) { db.Entry(favorde).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); }