// OPT00020100219 public static PollVoteCollection GetPollVoteByPollAnswerID(Guid pollAnswerID) { DataSet ds = new DataSet(); SqlParameter param = new SqlParameter(); param = new SqlParameter("@PollAnswerID", SqlDbType.UniqueIdentifier); param.Value = pollAnswerID; ds = SqlDataProvider.ExecuteDataset ( Tools.DatabaseConnectionString, CommandType.StoredProcedure, "GetPollVoteByPollAnswerID", param ); PollVoteCollection oc = new PollVoteCollection(); foreach (DataRow r in ds.Tables[0].Rows) { PollVote o = PollVote.Fill(r); oc.Add(o); } return(oc); }
public static PollVoteCollection GetPollVotes(int questionnaireID, Guid personneGUID) { SqlParameter[] parameters = new SqlParameter[2]; parameters[0] = new SqlParameter("@QuestionnaireID", SqlDbType.Int); parameters[0].Value = questionnaireID; parameters[1] = new SqlParameter("@UserGUID", SqlDbType.UniqueIdentifier); parameters[1].Value = personneGUID; DataSet ds = SqlDataProvider.ExecuteDataset ( Tools.DatabaseConnectionString, CommandType.StoredProcedure, "GetPollVotes", parameters ); PollVoteCollection oc = new PollVoteCollection(); foreach (DataRow r in ds.Tables[0].Rows) { PollVote o = PollVote.Fill(r); oc.Add(o); } return(oc); }
// Lorsque l'on boucle sur toutes les Personne d'un Questionnaire > 500 // l'utilisation de GetPollVotes lance un procedure stockee 500 fois // ce n'est pas optimum on va preferer lancer une fois GetPollVotesByQuestionnaireID // et utiliser cette fonction public PollVoteCollection FindByPersonneGUID(Guid userGUID) { PollVoteCollection newpvc = new PollVoteCollection(); foreach (PollVote pv in this) { if (pv.UserGUID == userGUID) { newpvc.Add(pv); } } return(newpvc); }
// Trouver les Votes pour une Reponse donnee dans la Collection public PollVoteCollection FindByAnswerID(Guid answerID) { PollVoteCollection newpvc = new PollVoteCollection(); foreach (PollVote pv in this) { if (pv.PollAnswerId == answerID) { newpvc.Add(pv); } } return(newpvc); }
// Pareil 70 ms environ public static int CountTotalVotes(Guid pollQuestionId) { int count = 0; PollVoteCollection pvc = PollVoteCollection.GetAll(); foreach (PollVote pv in pvc) { if (pv.PollQuestionID == pollQuestionId) { count += 1; } } return(count); }
// OPT00020100219 // Voila une procedure qui prend 100 ms au bas mot lorsque l'on a 1300 votes public static int NumberOfVotesByAnswer(Guid answerID) { // OPT00020100219int count = 0; //PollVoteCollection pvc = PollVoteCollection.GetAll(); //foreach ( PollVote pv in pvc ) //{ // if ( pv.PollAnswerId == answerID ) // { // count += 1; // } //} PollVoteCollection pvc = PollVoteDAL.GetPollVoteByPollAnswerID(answerID); return(pvc.Count); }
// Trouver les Votes pour une Reponse donnee public static PollVoteCollection GetVotes(Guid answerID) { //PollVoteCollection pvc = PollVoteCollection.GetAll(); //PollVoteCollection newpvc = new PollVoteCollection(); //foreach ( PollVote pv in pvc ) //{ // if ( pv.PollAnswerId == answerID ) // { // newpvc.Add( pv ); // } //} // OPT00020100219 PollVoteCollection newpvc = PollVoteDAL.GetPollVoteByPollAnswerID(answerID); return(newpvc); }
public static PollVoteCollection GetAll() { DataSet ds = new DataSet(); ds = SqlDataProvider.ExecuteDataset ( Tools.DatabaseConnectionString, CommandType.StoredProcedure, "GetPollVoteAll" ); PollVoteCollection oc = new PollVoteCollection(); foreach (DataRow r in ds.Tables[0].Rows) { PollVote o = PollVote.Fill(r); oc.Add(o); } return(oc); }