private void MesPrets(Res response, Client model)
{
SqlConnection connection = Models.Connexion.Get("Server=localhost;Database=foot;User ID=sa;Password=itu;");
Models.PretDAO prdao = new Models.PretDAO(connection);
response.data = prdao.Select("WHERE client='" + model.id + "'");
response.error = false;
}
private void DefinitivePlan(Plan value, SqlConnection connection)
{
this.VerifierPlan(value); value.AddInteret(connection);
Models.PretDAO prdao = new Models.PretDAO(connection);
Models.ClientDAO cldao = new Models.ClientDAO(connection);
Models.RemboursementDAO rbdao = new Models.RemboursementDAO(connection);
Models.Pret pret = new Models.Pret(value.pret);
Models.Client client = cldao.SelectOne("WHERE id='" + value.pret.client.id + "'");
client.Solde += pret.Montant;
pret.Id = prdao.NextId();
pret.Client = client;
prdao.Insert(pret);
cldao.Update(client);
foreach (Remboursement r in value.remboursements)
{
Models.Remboursement rb = new Models.Remboursement(r); rb.Id = rbdao.NextId(); rb.Pret = pret;
rbdao.Insert(rb);
}
}
