public override DataSet Clone()
{
InvitationQueueData data = (InvitationQueueData)base.Clone();
data.InitVars();
return(data);
}
/// <summary>
/// Returns the invitation queue of the survey
/// </summary>
public InvitationQueueData GetVotersInvitationQueue(int surveyId, int pageNumber, int pageSize, out int totalRecords)
{
InvitationQueueData dataSet = new InvitationQueueData();
//SqlParameter[] commandParameters = new SqlParameter[]
//{ new SqlParameter("@TotalRecords", SqlDbType.Int){Direction = ParameterDirection.Output},
// new SqlParameter("@SurveyID", SqlDbType.Int){SqlValue = surveyId},
// new SqlParameter("@CurrentPage", SqlDbType.Int){SqlValue=pageNumber},
// new SqlParameter("@PageSize", SqlDbType.Int){SqlValue=pageSize} };
//commandParameters[0].Direction = ParameterDirection.Output;
ArrayList commandParameters = new ArrayList();
{
commandParameters.Add(new SqlParameter("@TotalRecords", SqlDbType.Int) { Direction = ParameterDirection.Output }.SqlValue);
commandParameters.Add(new SqlParameter("@SurveyId", surveyId).SqlValue);
commandParameters.Add(new SqlParameter("@CurrentPage", pageNumber).SqlValue);
commandParameters.Add(new SqlParameter("@PageSize", pageSize).SqlValue);
}
DbConnection.db.LoadDataSet("vts_spVoterInvitationQueueGetAll", dataSet, new string[] {"InvitationQueues"}, commandParameters.ToArray());
//totalRecords = Convert.ToInt32(commandParameters[0].ToString());
//note: output parameter redundant, no longer used; cannot be combined with dataSet output;
totalRecords = dataSet.InvitationQueues.Rows.Count;
return dataSet;
}
public void RemoveInvitationQueuesRow(InvitationQueueData.InvitationQueuesRow row)
{
base.Rows.Remove(row);
}
public InvitationQueuesRowChangeEvent(InvitationQueueData.InvitationQueuesRow row, DataRowAction action)
{
this.eventRow = row;
this.eventAction = action;
}
public void AddInvitationQueuesRow(InvitationQueueData.InvitationQueuesRow row)
{
base.Rows.Add(row);
}
