public Demande( string libelleDemande, string moisAnnee,Pharmacie unePharmacie,TypePromo unTypePromo)
{
this.libelleDemande = libelleDemande;
this.moisAnnee = moisAnnee;
this.unePharmacie =unePharmacie;
this.unTypePromo = unTypePromo;
}
/// <summary>
/// Ajout d'une demande de promotion
/// </summary>
/// <param name="libelleDemande"></param>
/// <param name="moisAnnee"></param>
/// <param name="idPharmacie"></param>
/// <param name="idTypePromo"></param>
/// <returns></returns>
public int CreerDemande(string libelleDemande,string moisAnnee,int idPharmacie, int idTypePromo)
{
Pharmacie laPharmacie = new Pharmacie(idPharmacie);
TypePromo leTypePromo = new TypePromo(idTypePromo);
Demande laDemande = new Demande(libelleDemande, moisAnnee, laPharmacie, leTypePromo);
return DemandeDAO.GetInstanceDAODemande().AjoutDemande(laDemande);
}
public Demande(int numDemande, string libelleDemande, string moisAnnee,TypePromo unTypePromo)
{
this.idDemande = numDemande;
this.libelleDemande = libelleDemande;
this.moisAnnee = moisAnnee;
this.unTypePromo = unTypePromo;
}
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(string intitulePromo, DateTime datePromo, string commentairePromo)
{
this.intitulePromo = intitulePromo;
this.datePromo = datePromo;
this.commentairePromo = commentairePromo;
this.unePharmacie = null;
this.unTypePromo = null;
this.UnIntervenant = null;
}
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<TypePromo> SelectTypePromo()
{
SqlConnection cnx = AccesBDD.GetInstance().GetSqlConnexion();
SqlCommand maCommand = new SqlCommand();
maCommand.Parameters.Clear();
maCommand.Connection = cnx;
maCommand.CommandType = System.Data.CommandType.StoredProcedure;
maCommand.CommandText = "SelectTypePromo";
List<TypePromo> lesTypePromos = new List<TypePromo>();
SqlDataReader monLecteur = maCommand.ExecuteReader();
while (monLecteur.Read())
{
TypePromo unTypePromo = new TypePromo((int)monLecteur["idTypePromo"], (string)monLecteur["libelleTypePromo"]);
lesTypePromos.Add(unTypePromo);
}
return lesTypePromos;
}
public List<Promotion> SelectPromotionPourUnePharmacie(int idPharmacie)
{
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 = "SelectPromotionPourUnePharmacie";
maCommand.Parameters.Add("idPharmacie", System.Data.SqlDbType.Int);
maCommand.Parameters[0].Value = idPharmacie;
monLecteur = maCommand.ExecuteReader();
while (monLecteur.Read())
{
TypePromo unTypePromo = new TypePromo((string)monLecteur["libelleTypePromo"]);
Intervenant unIntervenant = new Intervenant((string)monLecteur["nomIntervenant"]);
Promotion unePromotion = new Promotion((int)monLecteur["idPromotion"], (string)monLecteur["intitulePromo"], (DateTime)monLecteur["datePromo"], (string)monLecteur["commentairePromo"], unIntervenant, unTypePromo);
lesPromotions.Add(unePromotion);
}
return lesPromotions;
}
public List<Demande> SelectDemandePouruneRegionPharmacie(int idRegion,int idPharmacie)
{
SqlConnection cnx = AccesBDD.GetInstance().GetSqlConnexion();
SqlCommand maCommand = new SqlCommand();
SqlDataReader monLecteur;
maCommand.Parameters.Clear();
List<Demande> lesDemandes = new List<Demande>();
maCommand.Connection = cnx;
maCommand.CommandType = System.Data.CommandType.StoredProcedure;
maCommand.CommandText = "SelectDemandePouruneRegionPharmacie";
maCommand.Parameters.Add("idRegion", System.Data.SqlDbType.Int);
maCommand.Parameters[0].Value = idRegion;
maCommand.Parameters.Add("idPharmacie", System.Data.SqlDbType.Int);
maCommand.Parameters[1].Value = idPharmacie;
monLecteur = maCommand.ExecuteReader();
while (monLecteur.Read())
{
TypePromo unTypePromo = new TypePromo((string)monLecteur["libelleTypePromo"]);
Demande uneDemande = new Demande((int)monLecteur["idDemande"], (string)monLecteur["libelleDemande"], (string)monLecteur["moisAnnee"], unTypePromo);
lesDemandes.Add(uneDemande);
}
return lesDemandes;
}