public UserArc UpdateUserArc(UserArc modifyUserArc, UserArc originalUserArc) { dbContext.Entry(originalUserArc).CurrentValues.SetValues(modifyUserArc); dbContext.Entry(originalUserArc).Property(x => x.UserId).IsModified = false; dbContext.Entry(originalUserArc).Property(x => x.CreateTime).IsModified = false; originalUserArc.UpdateTime = DateTime.UtcNow; dbContext.SaveChanges(); return(modifyUserArc); }
public void UpdateTransactionStatus(long recordId, short transactionStatus, string comment) { var record = _context.RemitRecord.SingleOrDefault(x => x.Id == recordId); _context.Entry(record).Reference(record => record.ToCurrency).Load(); var exchangeRate = _context.ExchangeRate.SingleOrDefault(x => x.CurrencyName.Equals(record.ToCurrency.CurrencyName)); var originalTransactionStatus = record.TransactionStatus; if (record == null) { return; } record.TransactionStatus = transactionStatus; record.TransactionExchangeRate = exchangeRate.Rate; RemitAdminReviewLog reviewLog = new RemitAdminReviewLog() { RemitRecordId = recordId, FromTransactionStatus = originalTransactionStatus, ToTransactionStatus = transactionStatus, Note = comment }; record.RemitAdminReviewLog.Add(reviewLog); _context.Update(record); _context.SaveChanges(); }
public async Task <IActionResult> PutUserPreferences([FromRoute] int id, [FromBody] UserPreferences userPreferences) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { UserPreferences oldUserPreferences = await _context.UserPreference.FirstOrDefaultAsync(e => e.UserID == id); if (oldUserPreferences == null) { return(NotFound()); } if (id != userPreferences.UserID) { return(BadRequest()); } oldUserPreferences.SystemLanguange = userPreferences.SystemLanguange; oldUserPreferences.Currency = userPreferences.Currency; _context.Entry(userPreferences).State = EntityState.Modified; await _context.SaveChangesAsync(); return(NoContent()); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public async Task <IActionResult> PutHouse(long id, House house) { if (id != house.Id) { return(BadRequest()); } _context.Entry(house).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!HouseExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PutApartment(long id, Apartment apartment) { if (id != apartment.Id) { return(BadRequest()); } _context.Entry(apartment).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ApartmentExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public ActionResult Edit([Bind(Include = "Id,Nombre,Apellido,Direccion")] Cliente cliente) { if (ModelState.IsValid) { db.Entry(cliente).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cliente)); }
public ActionResult Edit(Cliente cliente) { if (ModelState.IsValid) { db.Entry(cliente).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cliente)); }
public ActionResult Edit([Bind(Include = "Id,Nombre,CodigoPostal,Edad,Email,TarjetaCredito")] Persona persona) { if (ModelState.IsValid) { db.Entry(persona).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(persona)); }
public ActionResult Edit([Bind(Include = "Id,Capital,Intereses,Periodo,ClientesId")] Prestamos prestamos) { if (ModelState.IsValid) { db.Entry(prestamos).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ClientesId = new SelectList(db.Clientes, "Id", "Nombre", prestamos.ClientesId); return(View(prestamos)); }
public OftenBeneficiary AddBeneficiar(OftenBeneficiary Beneficiary) { dbContext.OftenBeneficiary.Add(Beneficiary); dbContext.SaveChanges(); dbContext.Entry(Beneficiary).Reference(Beneficiary => Beneficiary.PayeeType).Load(); return(Beneficiary); }
public bool ModifyPayeeRelation(PayeeRelationType modifyRelation) { try { PayeeRelationType relation = dbContext.PayeeRelationType.Single(x => x.Id == modifyRelation.Id); dbContext.Entry(relation).CurrentValues.SetValues(modifyRelation); dbContext.SaveChanges(); return(true); } catch (Exception ex) { logger.LogDebug(ex.Message); } return(false); }
public bool ModifyReceiveBank(ReceiveBank modifyBank) { try { ReceiveBank bank = dbContext.ReceiveBank.Single(x => x.Id == modifyBank.Id); dbContext.Entry(bank).CurrentValues.SetValues(modifyBank); dbContext.SaveChanges(); return(true); } catch (Exception ex) { logger.LogDebug(ex.Message); } return(false); }
public bool ModifyCurrency(CurrencyCode modifyCurrency) { try { CurrencyCode currency = dbContext.CurrencyCode.Single(x => x.Id == modifyCurrency.Id); dbContext.Entry(currency).CurrentValues.SetValues(modifyCurrency); dbContext.SaveChanges(); return(true); } catch (Exception ex) { logger.LogDebug(ex.Message); } return(false); }
public bool ModifyRemitSetting(BussinessUnitRemitSetting modifyRemitSetting) { try { BussinessUnitRemitSetting remitSetting = dbContext.BussinessUnitRemitSetting.Single(x => x.Id == modifyRemitSetting.Id); dbContext.Entry(remitSetting).CurrentValues.SetValues(modifyRemitSetting); dbContext.SaveChanges(); return(true); } catch (Exception ex) { logger.LogDebug(ex.Message); } return(false); }
public RemitRecord CreateRemitRecordByUserArc(UserArc userArc, RemitRecord remitRecord, PayeeTypeEnum payeeTypeEnum) { remitRecord.UserId = userArc.UserId; remitRecord.ArcName = userArc.ArcName; remitRecord.ArcNo = userArc.ArcNo; remitRecord.PayeeType = (byte)payeeTypeEnum; dbContext.RemitRecord.Add(remitRecord); dbContext.SaveChanges(); dbContext.Entry(remitRecord).Reference(record => record.Beneficiary).Query() .Include(Beneficiary => Beneficiary.PayeeRelation) .Load(); dbContext.Entry(remitRecord).Reference(record => record.ToCurrency).Load(); return(remitRecord); }
public void Modify(User user) { _context.Entry(user).State = EntityState.Modified; _context.SaveChanges(); }
public IHttpActionResult Post([FromBody] Personas persona) { if (persona.status == "guardar") { db.Personas.Add(persona); db.SaveChanges(); } else if (persona.status == "eliminar") { var pp = db.Personas.ToList().Find(x => x.IdPersona == persona.IdPersona); db.Personas.Remove(pp); db.SaveChanges(); } else if (persona.status == "editar") { var pp = db.Personas.ToList().Find(x => x.IdPersona == persona.IdPersona); pp.Nombre = persona.Nombre; pp.Apellido = persona.Apellido; pp.Correo = persona.Correo; pp.Telefono = persona.Telefono; db.Entry(pp).State = EntityState.Modified; db.SaveChanges(); } else if (persona.status == "buscar") { if (persona.Nombre == "id") { persona.IdPersona = Convert.ToInt32(persona.Apellido); var pp = db.Personas.ToList().Find(x => x.IdPersona == persona.IdPersona); var list = new List <Personas>(); list.Add(pp); return(Json(list)); } else if (persona.Nombre == "nombre") { var pp = BuscarNombre(persona.Apellido); return(Json(pp)); } else if (persona.Nombre == "apellido") { var pp = BuscarApellido(persona.Apellido); return(Json(pp)); } else if (persona.Nombre == "correo") { var pp = BuscarCorreo(persona.Apellido); return(Json(pp)); } else if (persona.Nombre == "telefono") { var pp = BuscarTelefono(persona.Apellido); return(Json(pp)); } } return(Ok()); }