/// <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; }