// Cadastra um pagamento na tabela public Boolean Insert(Debt debt) { try { Connection connection = Connection.Instance; Payment payment = new Payment(); payment.Date = DateTime.Now; payment.Value = debt.Value; payment.FriendIdIn = debt.FriendIdIn; payment.FriendIdOut = debt.FriendIdOut; connection.dateBase.Payments.Add(payment); // Ao pagar a dívida excluir ela do banco DebtRepository debtRepository = new DebtRepository(); debtRepository.DeleteObject(debt); connection.dateBase.SaveChanges(); return(true); } catch (DbEntityValidationException e) { return(false); throw e; } }
// Atualiza a dívida na tabela. public Boolean Update(Debt debt, int debtId) { try { Connection connection = Connection.Instance; connection.dateBase = new DebSystemDatabaseEntities(); DebtRepository debtRepository = new DebtRepository(); Debt updateDebt = debtRepository.GetDebtById(debtId); if (debt.Value > 0) { updateDebt.Value = debt.Value; } if (debt.Description != "") { updateDebt.Description = debt.Description; } if (debt.FriendIdIn > 0) { updateDebt.FriendIdIn = debt.FriendIdIn; } if (debt.FriendIdOut > 0) { updateDebt.FriendIdOut = debt.FriendIdOut; } connection.dateBase.Debts.Attach(updateDebt); connection.dateBase.Entry(updateDebt).State = EntityState.Modified; connection.dateBase.SaveChanges(); return(true); } catch (DbEntityValidationException e) { return(false); throw e; } }