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