/// <summary>
/// Get a list of all files associated with this guidto
/// </summary>
public FileData GetGuidFiles(string groupGuid)
{
ArrayList sqlParams = new ArrayList();
{
sqlParams.Add(new SqlParameter("@GroupGuid", groupGuid).SqlValue);
}
FileData dataSet = new FileData();
DbConnection.db.LoadDataSet("vts_spFileGetListForGuid", dataSet, new string[] { "Files" }, sqlParams.ToArray());
return dataSet;
}
/// <summary>
/// Returns all the files that have already been validated
/// </summary>
public FileData GetValidatedFileAnswers(int surveyId, int pageNumber, int pageSize, out int totalRecords)
{
FileData dataSet = new FileData();
//SqlParameter[] commandParameters = new SqlParameter[]
//{ new SqlParameter("@SurveyID", surveyId),
// new SqlParameter("@CurrentPage", pageNumber),
// new SqlParameter("@PageSize", pageSize),
// new SqlParameter("@TotalRecords", SqlDbType.Int) };
//commandParameters[3].Direction = ParameterDirection.Output;
ArrayList sqlParams = new ArrayList();
{
sqlParams.Add(new SqlParameter("@SurveyID", surveyId).SqlValue);
sqlParams.Add(new SqlParameter("@CurrentPage", pageNumber).SqlValue);
sqlParams.Add(new SqlParameter("@PageSize", pageSize).SqlValue);
sqlParams.Add(new SqlParameter("@TotalRecords", SqlDbType.Int) { Direction = ParameterDirection.Output }.SqlValue);
}
DbConnection.db.LoadDataSet("vts_spFileValidatedGetAll", dataSet, new string[] { "Files" }, sqlParams.ToArray());
totalRecords = dataSet.Files.Rows.Count;
//totalRecords = int.Parse(sqlParams[3].ToString());
return dataSet;
}
/// <summary>
/// Get all details of the file
/// </summary>
public FileData GetAnswerFile(int fileId, string groupGuid)
{
FileData dataSet = new FileData();
//SqlParameter[] commandParameters = new SqlParameter[2];
//commandParameters[0] = new SqlParameter("@FileId", SqlDbType.Int, 4);
//commandParameters[0].Value = fileId;
//commandParameters[1] = new SqlParameter("@GroupGuid", SqlDbType.NVarChar, 40);
//commandParameters[1].Value = groupGuid;
ArrayList sqlParams = new ArrayList();
{
sqlParams.Add(new SqlParameter("@FileId", fileId).SqlValue);
sqlParams.Add(new SqlParameter("@GroupGuid", groupGuid).SqlValue);
}
DbConnection.db.LoadDataSet("vts_spFileGetDetails", dataSet, new string[] { "Files" }, sqlParams.ToArray());
return dataSet;
}
