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); }
private static void Main(string[] args) { var manager = new Manager(); var poll = manager.getPoll(6); foreach (var q in poll.Questions) { Console.WriteLine(q.Label); if (q.Category == QuestionType.General) { var dataSet = DataExtractionUtils.GetAnswersByColumn(poll.TableName, q.Column); for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++) { Console.WriteLine(dataSet.Tables[0].Rows[i][q.Column]); } } Console.WriteLine(); } Console.WriteLine(); }
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); } }
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); } }
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); } }
public void NumberResponseTest() { Assert.AreEqual(1, DataExtractionUtils.NumberResponse(tablesession, "SUB_rbl4_a", "SomeWhat Satisfied", "Activity", 14, 84)); }
public void NumberResponse_GeneralQuestionTest() { Assert.AreEqual(2, DataExtractionUtils.NumberResponse_GeneralQuestion(tablesurvey, "rbl1_a", "Flat")); }