public List<Promotion>SelectPromotionPourUneRegionPourUnType(int idType,int idRegion) { SqlConnection cnx = AccesBDD.GetInstance().GetSqlConnexion(); SqlCommand maCommand = new SqlCommand(); SqlDataReader monLecteur; maCommand.Parameters.Clear(); List<Promotion> lesPromotions = new List<Promotion>(); maCommand.Connection = cnx; maCommand.CommandType = System.Data.CommandType.StoredProcedure; maCommand.CommandText = "SelectPromotionPourUneRegionPourUnType"; maCommand.Parameters.Add("idPromo", System.Data.SqlDbType.Int); maCommand.Parameters[0].Value = idType; maCommand.Parameters.Add("idRegion", System.Data.SqlDbType.Int); maCommand.Parameters[1].Value = idRegion; monLecteur = maCommand.ExecuteReader(); while(monLecteur.Read()) { Pharmacie unePharmacie = new Pharmacie((string)monLecteur["nomPharmacie"]); Intervenant unIntervenant = new Intervenant((string)monLecteur["nomIntervenant"]); Promotion unePromotion = new Promotion((int)monLecteur["idPromotion"], (string)monLecteur["intitulePromo"], (DateTime)monLecteur["datePromo"], (string)monLecteur["commentairePromo"], unIntervenant, unePharmacie); lesPromotions.Add(unePromotion); } return lesPromotions; }
public int CreerPromotion(string sonIntitulePromo,DateTime saDatePromo,string sonCommentairePromo,int sonIdPharmacie,int sonIdTypePromo,int sonIdIntervenant) { Pharmacie laPharmacie = new Pharmacie(sonIdPharmacie); TypePromo leTypePromo = new TypePromo(sonIdTypePromo); Intervenant lIntervenant = new Intervenant(sonIdIntervenant); Promotion laPromotion = new Promotion(sonIntitulePromo, saDatePromo, sonCommentairePromo, laPharmacie, leTypePromo,lIntervenant); return PromotionDAO.GetInstanceDAOPromotion().AjoutPromotion(laPromotion); }
public Promotion(int idPromotion, string intitulePromo, DateTime datePromo, string commentairePromo, Intervenant unIntervenant, TypePromo unTypePromo) { this.idPromotion = idPromotion; this.intitulePromo = intitulePromo; this.datePromo = datePromo; this.commentairePromo = commentairePromo; this.UnIntervenant = unIntervenant; this.unTypePromo = unTypePromo; }
public Promotion(int idPromotion, string intitulePromo, DateTime datePromo, string commentairePromo,Intervenant unIntervenant,Pharmacie unePharmacie) { this.idPromotion = idPromotion; this.intitulePromo = intitulePromo; this.datePromo = datePromo; this.commentairePromo = commentairePromo; this.UnIntervenant = unIntervenant; this.unePharmacie = unePharmacie; }
public Promotion(string intitulePromo,DateTime datePromo,string commentairePromo,Pharmacie unePharmacie,TypePromo unTypePromo,Intervenant unIntervenant) { this.intitulePromo = intitulePromo; this.datePromo = datePromo; this.commentairePromo = commentairePromo; this.unePharmacie = unePharmacie; this.unTypePromo = unTypePromo; this.UnIntervenant = unIntervenant; }
public List<Intervenant> SelectIntervenant() { SqlConnection cnx = AccesBDD.GetInstance().GetSqlConnexion(); SqlCommand maCommand = new SqlCommand(); maCommand.Parameters.Clear(); maCommand.Connection = cnx; maCommand.CommandType = System.Data.CommandType.StoredProcedure; maCommand.CommandText = "SelectIntervenant"; List<Intervenant> lesIntervenants = new List<Intervenant>(); SqlDataReader monLecteur = maCommand.ExecuteReader(); while(monLecteur.Read()) { Intervenant unIntervenant = new Intervenant((int)monLecteur["idIntervenant"], (string)monLecteur["nomIntervenant"]); lesIntervenants.Add(unIntervenant); } return lesIntervenants; }