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