public void AddRetard(SqlConnection connection)
{
TauxDAO tdao = new TauxDAO(connection);
RemboursementDAO rbdao = new RemboursementDAO(connection);
Taux retard = tdao.SelectOne("WHERE nom='Retard'");
float reste = pret.montant;
DateTime date1 = default(DateTime);
for (int i = 0; i < remboursements.Count(); i++)
{
Remboursement r = remboursements.ElementAt(i);
if (r.fait == 0 || (r.fait == 1 && r.id == null))
{
Models.Remboursement rb = rbdao.SelectOne("WHERE id='" + r.id + "'");
if ((r.id != null && rb != null) || r.id == null)
{
if (r.id != null)
{
date1 = Convert.ToDateTime(rb.DateRemboursement);
}
DateTime date2 = Convert.ToDateTime(r.dateRemboursement);
TimeSpan time = date2.Subtract(date1);
int nbJour = (int)time.TotalDays;
if (nbJour > 0)
{
r.interet += (retard.Valeur * nbJour * reste) / 100;
}
date1 = date2;
reste -= r.montant;
}
else
{
throw new Exception("ID du remboursement introuvable !");
}
}
else if (r.fait == 1 && r.id != null)
{
Models.Remboursement rb = rbdao.SelectOne("WHERE pret='" + pret.id + "' AND id='" + r.id + "' AND fait=1");
if (rb != null)
{
date1 = Convert.ToDateTime(rb.DateRemboursement);
reste -= rb.Montant;
}
else
{
throw new Exception("Le remboursement qui se dit etre deja fait est introuvable !");
}
}
}
}
private void ModifPlan(ModifPlan value, SqlConnection connection)
{
Models.RemboursementDAO rbdao = new Models.RemboursementDAO(connection);
rbdao.Delete("WHERE pret='" + value.pret.id + "'");
Models.Pret pret = new Models.Pret(value.pret); pret.Client = new Models.Client(); pret.Client.Id = value.pret.id;
foreach (Remboursement r in value.remboursements)
{
Models.Remboursement rb = new Models.Remboursement(r); rb.Pret = pret;
if (rb.Id == null)
{
rb.Id = rbdao.NextId();
}
rbdao.Insert(rb);
}
}
private void VerifierPlan(Plan value)
{
if (value.pret.client.id != null)
{
Models.Pret tmp1 = new Models.Pret(value.pret);
foreach (Remboursement r in value.remboursements)
{
Models.Remboursement rb = new Models.Remboursement(r);
}
value.Verifier();
}
else
{
throw new Exception("ID du client non recu !");
}
}
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);
}
}
