public FormResponseInfoModel GetFormResponseInfoModel(string SurveyId, int PageNumber, string sort = "", string sortfield = "", int orgid = -1)
{
int UserId = SurveyHelper.GetDecryptUserId(Session["UserId"].ToString());
FormResponseInfoModel FormResponseInfoModel = new FormResponseInfoModel();
FormResponseInfoModel.SearchModel = new SearchBoxModel();
SurveyResponseXML SurveyResponseXML = new SurveyResponseXML();
if (!string.IsNullOrEmpty(SurveyId))
{
SurveyAnswerRequest FormResponseReq = new SurveyAnswerRequest();
FormSettingRequest FormSettingReq = new Enter.Common.Message.FormSettingRequest();
//Populating the request
FormSettingReq.FormInfo.FormId = SurveyId;
FormSettingReq.FormInfo.UserId = UserId;
//Getting Column Name List
FormSettingReq.CurrentOrgId = orgid;
FormSettingReq.FormInfoOnly = true;
FormSettingResponse FormSettingResponse = _isurveyFacade.GetFormSettings(FormSettingReq); //Pain Point
Columns = FormSettingResponse.FormSetting.ColumnNameList.ToList();
Columns.Sort(Compare);
// Setting Column Name List
FormResponseInfoModel.Columns = Columns;
FormResponseInfoModel.FormInfoModel.IsShared = FormSettingResponse.FormInfo.IsShared;
FormResponseInfoModel.FormInfoModel.IsShareable = FormSettingResponse.FormInfo.IsShareable;
// Set User Role
//if (FormResponseInfoModel.FormInfoModel.IsShared)
//{
// SetUserRole(UserId, orgid);
//}
//else
//{
//SetUserRole(UserId, FormSettingResponse.FormInfo.OrganizationId);
//}
SetUserRole(UserId, orgid);
FormResponseReq.Criteria.SurveyId = SurveyId.ToString();
FormResponseReq.Criteria.PageNumber = PageNumber;
FormResponseReq.Criteria.UserId = UserId;
FormResponseReq.Criteria.IsSqlProject = FormSettingResponse.FormInfo.IsSQLProject;
FormResponseReq.Criteria.IsShareable = FormSettingResponse.FormInfo.IsShareable;
FormResponseReq.Criteria.UserOrganizationId = orgid;
Session["IsSqlProject"] = FormSettingResponse.FormInfo.IsSQLProject;
Session["IsOwner"] = FormSettingResponse.FormInfo.IsOwner;
//if (Session["SearchCriteria"] != null)
//{
// FormResponseInfoModel.SearchModel = (SearchBoxModel)Session["SearchCriteria"];
//}
// Following code retain search starts
if (Session["SearchCriteria"] != null &&
!string.IsNullOrEmpty(Session["SearchCriteria"].ToString()) &&
(Request.QueryString["col1"] == null || Request.QueryString["col1"] == "undefined"))
{
FormResponseReq.Criteria.SearchCriteria = Session["SearchCriteria"].ToString();
FormResponseInfoModel.SearchModel = (SearchBoxModel)Session["SearchModel"];
}
else
{
FormResponseReq.Criteria.SearchCriteria = CreateSearchCriteria(Request.QueryString, FormResponseInfoModel.SearchModel, FormResponseInfoModel);
Session["SearchModel"] = FormResponseInfoModel.SearchModel;
Session["SearchCriteria"] = FormResponseReq.Criteria.SearchCriteria;
}
// Following code retain search ends
PopulateDropDownlists(FormResponseInfoModel, FormSettingResponse.FormSetting.FormControlNameList.ToList());
if (sort.Length > 0)
{
FormResponseReq.Criteria.SortOrder = sort;
}
if (sortfield.Length > 0)
{
FormResponseReq.Criteria.Sortfield = sortfield;
}
SurveyAnswerResponse FormResponseList = _isurveyFacade.GetFormResponseList(FormResponseReq);//Pain Point
//var ResponseTableList ; //= FormSettingResponse.FormSetting.DataRows;
//Setting Resposes List
List <ResponseModel> ResponseList = new List <ResponseModel>();
foreach (var item in FormResponseList.SurveyResponseList)
{
if (item.SqlData != null)
{
ResponseList.Add(ConvertRowToModel(item, Columns));
}
else
{
ResponseList.Add(SurveyResponseXML.ConvertXMLToModel(item, Columns));
}
}
//foreach (var item in FormResponseList.SurveyResponseList)
//{
// ResponseList.Add(SurveyResponseXML.ConvertXMLToModel(item, Columns));
//}
FormResponseInfoModel.ResponsesList = ResponseList;
//Setting Form Info
FormResponseInfoModel.FormInfoModel = Mapper.ToFormInfoModel(FormResponseList.FormInfo);
//Setting Additional Data
FormResponseInfoModel.NumberOfPages = FormResponseList.NumberOfPages;
FormResponseInfoModel.PageSize = ReadPageSize();
FormResponseInfoModel.NumberOfResponses = FormResponseList.NumberOfResponses;
FormResponseInfoModel.sortfield = sortfield;
FormResponseInfoModel.sortOrder = sort;
FormResponseInfoModel.CurrentPage = PageNumber;
}
return(FormResponseInfoModel);
}