public async Task <IActionResult> PutStatus(int id, Status status) { if (id != status.StatusId) { return(BadRequest()); } _context.Entry(status).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!StatusExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public HttpResponseMessage Put([FromBody] ProductosViewModel cambio) { try { if (cambio.Codpro == null || cambio.Codpro == "") { throw new Exception("Producto no existe"); } Productos pc = db.Productos.Where(a => a.Codpro == cambio.Codpro).FirstOrDefault(); if (pc == null) { throw new Exception("Producto no existe"); } db.Entry(pc).State = EntityState.Modified; pc.Codpro = cambio.Codpro; pc.Nompro = cambio.Nompro; pc.Descripcion = cambio.Descripcion; pc.CodCla = cambio.CodCla; pc.CodBarras = cambio.CodBarras; pc.Precio = cambio.Precio; pc.Cantidad = cambio.Cantidad; if (!String.IsNullOrEmpty(cambio.ImagenBase64)) { string Url = GuardaImagenBase64(cambio.ImagenBase64, "Productos", cambio.Codpro + "_" + cambio.CodBarras + ".jpg", System.Drawing.Imaging.ImageFormat.Jpeg); pc.Imagen = Url; } else { pc.Imagen = pc.Imagen; } pc.FechaCreacion = pc.FechaCreacion; pc.Activo = true; db.SaveChanges(); resp = new { Success = true }; return(Request.CreateResponse(HttpStatusCode.OK, resp)); } catch (Exception ex) { // EncuestasRegistroController.GuardarBitacoraTxt(ex.Message); return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message)); } }
public async Task <IActionResult> PutMessage(int id, Message message) { if (id != message.MessageId) { return(BadRequest()); } _context.Entry(message).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!MessageExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PutSystemParam(int id, SystemParam systemParam) { if (id != systemParam.SystemParamId) { return(BadRequest()); } User modifiedBy = _context.Users.Find(systemParam.ModifiedBy_UserId); systemParam.ModifiedBy = modifiedBy; systemParam.ModifiedBy_UserId = modifiedBy.UserId; systemParam.ModifiedDate = DateTime.Now; _context.Entry(systemParam).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!SystemParamExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PutNotificationItem(int id, NotificationItem notificationItem) { if (id != notificationItem.NotificationItemId) { return(BadRequest()); } _context.Entry(notificationItem).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!NotificationItemExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public void Update(TEntityDTO entity) { var mappedEntity = Mapper.Map <TEntity>(entity); Db.Entry(mappedEntity).State = EntityState.Modified; Db.SaveChanges(); }
public async Task <IActionResult> UpdateUser(User newUser) { var user = _context.Users.Find(newUser.UserId); if (user == null) { return(NotFound()); } user.DisplayName = newUser.DisplayName; user.FirstName = newUser.FirstName; user.LastName = newUser.LastName; user.Email = newUser.Email; user.Password = newUser.Password; _context.Entry(user).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (Exception ex) { return(BadRequest(new { message = ex.Message })); } return(NoContent()); }
public HttpResponseMessage Put([FromBody] ProductosClasificacion cambio) { try { if (cambio.CodClasificacion == null || cambio.CodClasificacion == null) { throw new Exception("Clasificacion no existe"); } ProductosClasificacion pc = db.ProductosClasificacion.Where(a => a.CodClasificacion == cambio.CodClasificacion).FirstOrDefault(); if (pc == null) { throw new Exception("Clasificacion no existe"); } db.Entry(pc).State = EntityState.Modified; pc.Nombre = cambio.Nombre; db.SaveChanges(); resp = new { Success = true }; return(Request.CreateResponse(HttpStatusCode.OK, resp)); } catch (Exception ex) { // EncuestasRegistroController.GuardarBitacoraTxt(ex.Message); return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message)); } }
public ActionResult Edit(User user) { if (ModelState.IsValid) { db.Entry(user).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(user)); }
public ActionResult Edit(Brand brand) { if (ModelState.IsValid) { db.Entry(brand).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.categoryID = new SelectList(db.Categorys, "categoryID", "categoryName", brand.categoryID); return(View(brand)); }
/// <summary> /// Add or update modifier and Item modifier /// </summary> /// <param name="modClient"></param> public void UpsertDeleteModiferAndItemModifier(Modifier modClient) { //load the modifier var modDb = _context.Modifier .Include(_ => _.ItemModifier) .FirstOrDefault(_ => _.Id == modClient.Id); if (modDb == null) { _context.Add(modClient); } else { //set values _context.Entry(modDb).CurrentValues.SetValues(modClient); //check what are in the db and update it foreach (var item in modClient.ItemModifier) { var itemDb = modDb.ItemModifier.FirstOrDefault(_ => _.Id == item.Id); if (itemDb == null) { item.ModifierId = modClient.Id; _context.ItemModifier.Add(item); } else { _context.Entry <ItemModifier>(itemDb).CurrentValues.SetValues(item); } } foreach (var item in modDb.ItemModifier) { if (!modClient.ItemModifier.Any(_ => _.Id == item.Id)) { _context.ItemModifier.Remove(item); } } } }
private async Task <bool> UpdateEntry(object obj) { _context.Entry(obj).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { return(false); } return(true); }
[HttpDelete]// [Route("api/Productos/Eliminar")] public async Task <IHttpActionResult> DesactivarUsuario(string nombre) { Usuarios user = db.Usuarios.Where(a => a.Nombre == nombre).FirstOrDefault(); if (user == null) { return(NotFound()); } db.Entry(user).State = EntityState.Modified; user.Activo = false; await db.SaveChangesAsync(); return(Ok("OK")); }
public HttpResponseMessage Put([FromBody] Clientes cambio) { try { if (cambio.CodCliente == null || cambio.CodCliente == 0) { throw new Exception("Cliente no existe"); } Clientes pc = db.Clientes.Where(a => a.CodCliente == cambio.CodCliente).FirstOrDefault(); if (pc == null) { throw new Exception("Cliente no existe"); } db.Entry(pc).State = EntityState.Modified; pc.Nombre = cambio.Nombre; pc.Email = cambio.Email; pc.Telefono = cambio.Telefono; pc.Direccion = cambio.Direccion; db.SaveChanges(); resp = new { Success = true }; return(Request.CreateResponse(HttpStatusCode.OK, resp)); } catch (Exception ex) { // EncuestasRegistroController.GuardarBitacoraTxt(ex.Message); return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message)); } }
public async Task <HttpResponseMessage> PutAsync([FromBody] Proforma cambio) { var transaccion = db.Database.BeginTransaction(); try { if (cambio.encProforma.NumProforma == null || cambio.encProforma.NumProforma == "") { throw new Exception("Proforma no existe"); } EncProforma pc = db.EncProforma.Where(a => a.NumProforma == cambio.encProforma.NumProforma).FirstOrDefault(); if (pc == null) { throw new Exception("Proforma no existe"); } db.Entry(pc).State = EntityState.Modified; pc.CodCliente = cambio.encProforma.CodCliente; pc.CodUsuario = pc.CodUsuario; pc.FecFactura = DateTime.Now; pc.SubTotal = cambio.encProforma.SubTotal; pc.Descuento = cambio.encProforma.Descuento; pc.Impuesto = cambio.encProforma.Impuesto; var dt = db.DetProforma.Where(a => a.NumProforma == pc.NumProforma).ToList(); foreach (var item in dt) { db.DetProforma.Remove(item); await db.SaveChangesAsync(); } foreach (var det in cambio.detProforma) { det.NumProforma = cambio.encProforma.NumProforma; det.Nompro = db.Productos.Where(a => a.Codpro == det.Codpro).Select(u => u.Nompro).FirstOrDefault(); db.DetProforma.Add(det); db.SaveChanges(); } db.SaveChanges(); resp = new { Success = true }; transaccion.Commit(); return(Request.CreateResponse(HttpStatusCode.OK, resp)); } catch (Exception ex) { transaccion.Rollback(); // EncuestasRegistroController.GuardarBitacoraTxt(ex.Message); return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message)); } }