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