public void InsertUpdateTypeAssurance(TypeAssurance obj)
{
InitializeConnexion();
using (IDbCommand cmd = ImplementConnection.Instance.Con.CreateCommand())
{
if (obj.Id == 0)
{
cmd.CommandText = "INSERT INTO `sonas_bdd`.`type_assurance` (`designation`) " +
"VALUES (@designation);";
cmd.Parameters.Add(GetParameter(cmd, "@designation", 50, DbType.String, obj.Designation));
}
else
{
cmd.CommandText = "UPDATE `sonas_bdd`.`type_assurance` SET `designation` = @designation " +
"WHERE `id` = @id ;";
cmd.Parameters.Add(GetParameter(cmd, "@id", 4, DbType.Int32, obj.Id));
cmd.Parameters.Add(GetParameter(cmd, "@designation", 50, DbType.String, obj.Designation));
}
cmd.ExecuteNonQuery();
}
}
private void CréerAssurances()
{
ConsoleHelper.AfficherEntete("Créer une Assurance");
decimal montant = OutilsConsole.PosezPrix("Montant : ");
TypeAssurance typeAssurance = OutilsConsole.PosezTypeAssurance("Type D'assurance : \n0-Annulation");
Services.CreerAssurance(montant, typeAssurance);
}
public IEnumerable <Assurance> FiltrerAssurance(TypeAssurance typeAssurance)
{
using (Context context = new Context())
{
return(context.Assurances
.Where(x => x.Type == typeAssurance)
.ToList());
}
}
public SequenceCredit()
{
_TauxInteret = new TauxPeriodique(0, TypePeriode.ANNUEL, TypeTaux.PROPORTIONNEL);
_TypeSequenceCredit = TypeSequenceCredit.AMORTISSABLE;
_TypePeriode = TypePeriode.MENSUEL;
_NombrePeriode = 0;
_TypeAssurance = Finance.TypeAssurance.SUR_CRD_INCLUS;
_TauxAssurance = new TauxPeriodique(0, Finance.TypePeriode.ANNUEL, TypeTaux.PROPORTIONNEL);
_Progressivite = 0;
}
public static void CreerAssurance(decimal montant, TypeAssurance typeAssurance)
{
Assurance assurance = new Assurance
{
Montant = montant,
TypeAssurance = typeAssurance
};
ServiceAssurance.CreerAssurance(assurance);
}
public IEnumerable <Assurance> FiltrerAssurance(TypeAssurance typeAssurance)
{
return(dalAssurance.FiltrerAssurance(typeAssurance));
}
public Assurance(TypeAssurance type, decimal montant)
{
Type = type;
Montant = montant;
}
