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