public void createCSV1(int id, string memberHash)
{
System.Web.HttpResponse csvresponse = System.Web.HttpContext.Current.Response;
csvresponse.Clear();
csvresponse.AddHeader("content-disposition", "attachment; filename=surveyResults.csv");
csvresponse.ContentType = "text/csv";
csvresponse.Write("Question No: ,Question: ,Option: ,Responses: ,No of Responses: ,");
csvresponse.Write(Environment.NewLine);
using (var session = FluentNHibernateConfiguration.InitFactory.sessionFactory.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
var result = new SurveyResults();
var member = Member.GetByHash(session, memberHash);
if (member == null)
return;
var survey = member.memberSurveyList.ToList<Survey>().Find(item => item.Id == id);
int i = 0;
foreach (var question in survey.surveyQuestionList)
{
var resultQn = new Questions();
resultQn.questionTitle = question.surveyQuestionTitle;
resultQn.questionType = question.surveyQuestionType;
switch (question.surveyQuestionType)
{
case 0:
case 1:
case 5:
case 10:
{
int optionNo = 0;
foreach (var option in question.surveyQuestionOptionList)
{
string fileRow = "";
string cell = "";
cell += "Question " + (i + 1).ToString() + ",";
if (question.surveyQuestionTitle.Contains(","))
{
cell += "\"" + question.surveyQuestionTitle + "\"" + ",";
}
else
{
cell += question.surveyQuestionTitle + ",";
}
if (option.surveyQuestionOptionTitle.Contains(","))
{
cell += "\"" + option.surveyQuestionOptionTitle + "\"" + ",";
}
else
{
cell += option.surveyQuestionOptionTitle + ",";
}
cell += "N.A" + ",";
int choices = 0;
foreach (var response in question.surveyQuestionResponseList)
{
if (response.responseIntegerValue == optionNo)
{
choices++;
}
}
optionNo++;
cell += choices + ",";
fileRow += cell + ",";
csvresponse.Write(fileRow);
csvresponse.Write(Environment.NewLine);
}
i++;
break;
}
case 2:
case 3:
{
foreach (var response in question.surveyQuestionResponseList)
{
var questionOption = new Options { responseStr = response.responseIntegerValue.ToString() , noOfRespondents=1};
bool add = true;
foreach(var tempOption in resultQn.optionList)
{
if (questionOption.responseStr == null)
{
tempOption.noOfRespondents++;
add = false;
questionOption.noOfRespondents = tempOption.noOfRespondents;
}
else if (tempOption.responseStr.Equals(questionOption.responseStr))
{
tempOption.noOfRespondents++;
add = false;
questionOption.noOfRespondents = tempOption.noOfRespondents;
}
}
if (add)
{
questionOption.optionTitle = response.responseIntegerValue.ToString();
resultQn.optionList.Add(questionOption);
}
}
foreach (var qnOption in resultQn.optionList)
{
string fileRow = "";
string cell = "";
cell += "Question " + (i + 1).ToString() + ",";
if (question.surveyQuestionTitle.Contains(","))
{
cell += "\"" + question.surveyQuestionTitle + "\"" + ",";
}
else
{
cell += question.surveyQuestionTitle + ",";
}
cell += "N.A" + ",";
if (qnOption.optionTitle == null)
{
cell += qnOption.noOfRespondents.ToString() + " Responpondents has not responded." + ",";
cell += qnOption.noOfRespondents.ToString() + ",";
fileRow += cell + ",";
csvresponse.Write(fileRow);
csvresponse.Write(Environment.NewLine);
}
else
{
cell += qnOption.optionTitle + ",";
cell += qnOption.noOfRespondents.ToString() + ",";
fileRow += cell + ",";
csvresponse.Write(fileRow);
csvresponse.Write(Environment.NewLine);
}
}
i++;
break;
}
case 4:
case 6:
case 7:
{
foreach (var response in question.surveyQuestionResponseList)
{
var questionOption = new Options { responseStr = response.responseStringValue, noOfRespondents = 1 };
bool add = true;
foreach (var tempOption in resultQn.optionList)
{
if (tempOption.responseStr.Equals(questionOption.responseStr))
{
tempOption.noOfRespondents++;
add = false;
questionOption.noOfRespondents = tempOption.noOfRespondents;
}
}
if (add)
{
questionOption.optionTitle = response.responseStringValue;
resultQn.optionList.Add(questionOption);
}
}
foreach (var qnOption in resultQn.optionList)
{
string fileRow = "";
string cell = "";
cell += "Question " + (i + 1).ToString() + ",";
if (question.surveyQuestionTitle.Contains(","))
{
cell += "\"" + question.surveyQuestionTitle + "\"" + ",";
}
else
{
cell += question.surveyQuestionTitle + ",";
}
cell += "N.A" + ",";
if (qnOption.optionTitle.Contains(","))
{
cell += "\"" + qnOption.optionTitle + "\"" + ",";
}
else
{
cell += qnOption.optionTitle + ",";
}
cell += qnOption.noOfRespondents.ToString() + ",";
fileRow += cell + ",";
csvresponse.Write(fileRow);
csvresponse.Write(Environment.NewLine);
}
i++;
break;
}
}
}
}
}
csvresponse.End();
}
public void getSurvey(int id, string memberHash)
{
using (var session = FluentNHibernateConfiguration.InitFactory.sessionFactory.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
JavaScriptSerializer js = new JavaScriptSerializer();
var member = Member.GetByHash(session,memberHash);
if (member == null)
return;
var survey = member.memberSurveyList.ToList<Survey>().Find(item => item.Id == id);
//var survey = Entities.Survey.GetById(session, id);
var result = new SurveyResults();
result.surveyTitle = survey.surveyTitle;
result.surveyDescription = survey.surveyDescription;
result.noOfRespondents = survey.respondentList.Count;
int i = 0;
int totalTime = 0;
foreach (var respondent in survey.respondentList)
{
totalTime += respondent.respondentTime;
//add country code to list sequential search
bool add = true;
var countryCode = new KeyValueResponse { key = respondent.respondentCountryCode, value=1 };
foreach (var tempCode in result.countryCode)
{
if(tempCode.key.Equals(countryCode.key))
{
tempCode.value++;
add = false;
}
}
if (add) result.countryCode.Add(countryCode);
//add browser type
add = true;
var browserBrowser = new KeyValueResponse { key = respondent.respondentBrowser, value = 1 };
foreach (var tempBrowser in result.browserBrowser)
{
if (tempBrowser.key.Equals(browserBrowser.key))
{
tempBrowser.value++;
add = false;
}
}
if (add) result.browserBrowser.Add(browserBrowser);
//add operating system
add = true;
var browserOS = new KeyValueResponse { key = respondent.respondentOS, value = 1 };
foreach (var tempOS in result.browserOS)
{
if (tempOS.key.Equals(browserOS.key))
{
tempOS.value++;
add = false;
}
}
if (add) result.browserOS.Add(browserOS);
}
if (result.noOfRespondents > 0)
result.avgTime = (totalTime / result.noOfRespondents) / 1000;
else result.avgTime = 0;
foreach (var question in survey.surveyQuestionList)
{
var resultQn = new Questions();
i++;
resultQn.questionTitle = question.surveyQuestionTitle;
resultQn.questionType = question.surveyQuestionType;
switch (question.surveyQuestionType)
{
//multiple choices and checkboxes
case 0:
case 1:
case 5:
case 10:
int count = 0;
foreach (var option in question.surveyQuestionOptionList)
{
var questionOption = new Options();
questionOption.optionTitle = option.surveyQuestionOptionTitle;
foreach (var response in question.surveyQuestionResponseList)
{
if (response.responseIntegerValue == count)
{
questionOption.noOfRespondents++;
}
}
count++;
resultQn.optionList.Add(questionOption);
}
result.questionList.Add(resultQn);
break;
case 2: //slider
case 3: //numerical input
{
foreach (var response in question.surveyQuestionResponseList)
{
var questionOption = new Options { responseStr = response.responseIntegerValue.ToString() , noOfRespondents=1};
bool add = true;
foreach(var tempOption in resultQn.optionList)
{
if (tempOption.responseStr.Equals(questionOption.responseStr))
{
tempOption.noOfRespondents++;
add = false;
}
}
if(add)
resultQn.optionList.Add(questionOption);
}
result.questionList.Add(resultQn);
break;
}
case 4: //date
case 6: //text
case 7: //textarea
foreach (var response in question.surveyQuestionResponseList)
{
var questionOption = new Options {responseStr = response.responseStringValue, noOfRespondents=1};
bool add = true;
foreach(var tempOption in resultQn.optionList)
{
if (tempOption.responseStr.Equals(questionOption.responseStr))
{
tempOption.noOfRespondents++;
add = false;
}
}
if(add)
resultQn.optionList.Add(questionOption);
}
result.questionList.Add(resultQn);
break;
}
}
//print to webservice
Context.Response.Write(js.Serialize(result));
}
}
}
