public IEnumerable <Persist> fnSelect(string campagneID, short cibleEnqueteID, short status)
{
List <Enquete> mListe = new List <Enquete>();
db.definirProcedureStockee("Enquete_Lister");
db.ajouterParametreEntree("@Campagne", 8, SqlDbType.VarChar, campagneID);
db.ajouterParametreEntree("@CibleEnqueteID", 8, SqlDbType.SmallInt, cibleEnqueteID);
db.ajouterParametreEntree("@Status", 8, SqlDbType.SmallInt, status);
IDataReader reader = db.executeReader();
while (reader.Read())
{
Enquete mClass = new Enquete();
mapFromDataReaderToObject(reader, mClass);
mListe.Add(mClass);
}
reader.Close();
return(mListe);
}
private void mapFromDataReaderToObject(IDataReader reader, Enquete mClass)
{
if (reader != null)
{
if (!Convert.IsDBNull(reader["ID"]))
{
mClass.ID = (int)reader["ID"];
}
if (!Convert.IsDBNull(reader["Titre"]))
{
mClass.Titre = reader["Titre"].ToString();
}
if (!Convert.IsDBNull(reader["Campagne"]))
{
mClass.Campagne = reader["Campagne"].ToString();
}
mClass.Cible = new CibleEnquete();
if (!Convert.IsDBNull(reader["CibleID"]))
{
mClass.Cible.ID = short.Parse(reader["CibleID"].ToString());
}
if (!Convert.IsDBNull(reader["CibleNom"]))
{
mClass.Cible.Nom = reader["CibleNom"].ToString();
}
if (!Convert.IsDBNull(reader["DateDebut"]))
{
mClass.DateDebut = DateTime.Parse(reader["DateDebut"].ToString());
}
if (!Convert.IsDBNull(reader["DateFin"]))
{
mClass.DateDebut = DateTime.Parse(reader["DateFin"].ToString());
}
if (!Convert.IsDBNull(reader["CreationDate"]))
{
mClass.CreationDate = DateTime.Parse(reader["CreationDate"].ToString());
}
if (!Convert.IsDBNull(reader["CreationUtilisateur"]))
{
mClass.CreationUtilisateur = reader["CreationUtilisateur"].ToString();
}
if (!Convert.IsDBNull(reader["ModificationUtilisateur"]))
{
mClass.ModificationUtilisateur = reader["ModificationUtilisateur"].ToString();
}
if (!Convert.IsDBNull(reader["ModificationDate"]))
{
mClass.ModificationDate = DateTime.Parse(reader["ModificationDate"].ToString());
}
if (!Convert.IsDBNull(reader["Rowversion"]))
{
mClass.RowVersion = (byte[])reader["RowVersion"];
}
if (!Convert.IsDBNull(reader["Statut"]))
{
mClass.Statut = (bool)reader["Statut"];
}
}
}