protected void ExtractRawData(object sender, EventArgs e) { var dataextraction = new SurveyDataExtractor { PollId = id_poll }; var manager = new Manager(); var poll = manager.getPoll(id_poll); var questions = poll.Questions; string surveytable = poll.TableName; string meetingtable = poll.TableMeetingName; string sessiontable = poll.TableSessionName; string wstable = poll.TableWsName; var attantedmeetings = (meetingQuestionCount > 0) ? DataExtractionUtils.getAttendedMeetings(poll.Id, meetingtable) : new List <Meeting>(); var wb = dataextraction.Print_into_excel_file(questions, attantedmeetings, surveytable, meetingtable, sessiontable, wstable); string fullPath = "~/surveys/DataWithDetails_B1AB75ED32D74914B015B05C2EB3081E " + DateTime.Now.Millisecond + ".xlsx"; try { wb.SaveAs(Server.MapPath(fullPath)); wb.Close(); } catch (Exception) { } DataExtractionUtils.DeleteGeneratedFile(Page.MapPath(fullPath), 2000); Response.Redirect(fullPath); }
public void getAttendedMeetingsTest() { List <Meeting> meetings1 = new List <Meeting>(); Meeting m = new Meeting(); m.id_meeting = 1; m.id_company = 12; m.company_name = "com"; meetings1.Add(m); List <Meeting> meetings2 = DataExtractionUtils.getAttendedMeetings(id_poll, tablemeeting); for (int i = 0; i < meetings2.Count; i++) { Meeting m2 = meetings2[i]; Assert.AreEqual(m.id_meeting, m2.id_meeting); Assert.AreEqual(m.id_company, m2.id_meeting); Assert.AreEqual(m.company_name, m2.company_name); } }