// 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;
}
}
