// 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 getSessionAtelierTest() { List <Atelier> sessionAtelier1 = new List <Atelier>(); Atelier session = new Atelier(); session.id_atelier = 1; session.id_event = 1; session.theme = "session 1"; session.description = ""; List <Atelier> sessionAtelier2 = DataExtractionUtils.getSessionAtelier(id_poll, tablesession); for (int i = 0; i < sessionAtelier2.Count; i++) { Atelier session2 = sessionAtelier2[i]; Assert.AreEqual(session.id_event, session2.id_event); Assert.AreEqual(session.id_atelier, session2.id_event); Assert.AreEqual(session.theme, session2.id_event); Assert.AreEqual(session.description, session2.id_event); } }