// Excel
protected void ExtractDataStatistics(object sender, EventArgs e)
{
var manager = new Manager();
var dataextraction = new SurveyDataExtractor {
PollId = id_poll
};
var poll = manager.getPoll(id_poll);
var questions = manager.getQuestions(poll.Id);
string surveytable = poll.TableName;
string meetingtable = poll.TableMeetingName;
string sessiontable = poll.TableSessionName;
string wstable = poll.TableWsName;
var meetings = (meetingQuestionCount > 0) ? manager.getMeetings(poll.Id, meetingtable) : new List <Meeting>();
//var attantedmeetings = dataextraction.getAttendedMeetings(poll.Id, meetingtable);
var sessionAtelier = (sessionQuestionCount > 0) ? DataExtractionUtils.getSessionAtelier(poll.Id, sessiontable) : new List <Atelier>();
var wsAtelier = (workshopQuestionCount > 0) ? DataExtractionUtils.getWsAtelier(poll.Id, wstable): new List <Atelier>();
var wb = dataextraction.Print_into_excel_file2(questions, surveytable, meetingtable, sessiontable, wstable, meetings, sessionAtelier, wsAtelier);
string fullPath = "~/surveys/DataWithStatistics_B1AB75ED32D74914B015B05C2EB3081E " + DateTime.Now.Millisecond + ".xlsx";
try
{
wb.SaveAs(Server.MapPath(fullPath));
wb.Close();
}
catch (Exception) { }
DataExtractionUtils.DeleteGeneratedFile(fullPath, 2000);
Response.Redirect(fullPath);
}
public void getWsAtelierTest()
{
List <Atelier> sessionAtelier1 = new List <Atelier>();
Atelier workshop = new Atelier();
workshop.id_atelier = 1;
workshop.id_event = 1;
workshop.theme = "session 1";
workshop.description = "";
List <Atelier> wsAtelier2 = DataExtractionUtils.getWsAtelier(id_poll, tablesession);
for (int i = 0; i < wsAtelier2.Count; i++)
{
Atelier workshop2 = wsAtelier2[i];
Assert.AreEqual(workshop.id_event, workshop2.id_event);
Assert.AreEqual(workshop.id_atelier, workshop2.id_event);
Assert.AreEqual(workshop.theme, workshop2.id_event);
Assert.AreEqual(workshop.description, workshop2.id_event);
}
}