// OPT00020100219
// Obtenir toutes les Questions d'un Questionnaire
public static PollQuestionCollection GetByQuestionnaireID(int questionnaireID)
{
DataSet ds = new DataSet();
SqlParameter param = new SqlParameter();
param = new SqlParameter("@QuestionnaireID", SqlDbType.Int, 4);
param.Value = questionnaireID;
ds = SqlDataProvider.ExecuteDataset
(
Tools.DatabaseConnectionString,
CommandType.StoredProcedure,
"GetPollQuestionByQuestionnaireID",
param
);
PollQuestionCollection oc = new PollQuestionCollection();
foreach (DataRow r in ds.Tables[0].Rows)
{
PollQuestion o = PollQuestion.Fill(r);
oc.Add(o);
}
return(oc);
}
public static PollQuestion GetLatestQuestion()
{
PollQuestion pq = new PollQuestion();
PollQuestionCollection pqc = PollQuestionCollection.GetAll();
pqc.Sort(pq.Compare);
return(pqc[0]);
}
public static PollQuestionCollection GetBySociete(string societe)
{
PollQuestionCollection newpqc = new PollQuestionCollection();
PollQuestionCollection pqc = PollQuestionCollection.GetAll();
foreach (PollQuestion pc in pqc)
{
if (pc.Societe == societe)
{
newpqc.Add(pc);
}
}
return(newpqc);
}
/// <summary>
/// Trouver les Questions d'un Questionnaire
/// </summary>
/// <param name="questionnaireID">questionnaireID</param>
/// <returns></returns>
public static PollQuestionCollection GetByQuestionnaire(int questionnaireID)
{
// OPT00020100219
//PollQuestionCollection newpqc = new PollQuestionCollection();
//PollQuestionCollection pqc = PollQuestionCollection.GetAll();
//foreach ( PollQuestion pc in pqc )
//{
// if ( pc.QuestionnaireID == questionnaireID )
// {
// newpqc.Add( pc );
// }
//}
PollQuestionCollection newpqc = PollQuestionDAL.GetByQuestionnaireID(questionnaireID);
return(newpqc);
}
public static PollQuestion GetQuestion(Guid PollQuestionId)
{
if (PollQuestionId == Guid.Empty)
{
return(null);
}
PollQuestionCollection pqc = PollQuestionCollection.GetAll();
foreach (PollQuestion pc in pqc)
{
if (pc.PollQuestionId == PollQuestionId)
{
return(pc);
}
}
return(null);
}
public static PollQuestionCollection GetAll()
{
DataSet ds = new DataSet();
ds = SqlDataProvider.ExecuteDataset
(
Tools.DatabaseConnectionString,
CommandType.StoredProcedure,
"GetPollQuestionAll"
);
PollQuestionCollection oc = new PollQuestionCollection();
foreach (DataRow r in ds.Tables[0].Rows)
{
PollQuestion o = PollQuestion.Fill(r);
oc.Add(o);
}
return(oc);
}
