private void DrawColomn(string table, Excel.Worksheet sheet, int line, int column, Question q)
{
sheet.Cells[line, column] = q.Label;
sheet.Cells[line, column].Interior.Color = ColorTranslator.ToOle(Color.LightGreen);
var ds = DataExtractionUtils.GetAnswersByColumn(table, q.Column);
var tmp = line + 1;
for (var j = 0; j < ds.Tables[0].Rows.Count; j++)
{
sheet.Cells[tmp, column] = ds.Tables[0].Rows[j][q.Column];
tmp++;
}
}
public int PersonInfoColumns(int pos, Excel.Worksheet worksheet, string questionType, string tableName)
{
var column = 1;
var generalPersonInfo = new Dictionary <string, string>
{
{ "PER_id_person", "Id_person" },
{ "PER_id_company", "Id_company" },
{ "PER_first_name", "First name" },
{ "PER_last_name", "Last name" },
};
var sessionPersonalInfo = new Dictionary <string, string>
{
{ "PER_id_person", "Id_person" },
{ "PER_id_company", "Id_company" },
{ "PER_first_name", "First name" },
{ "PER_last_name", "Last name" },
{ "theme", "theme" }
};
var wsPersonalInfo = new Dictionary <string, string>
{
{ "PER_id_person", "Id_person" },
{ "PER_id_company", "Id_company" },
{ "PER_first_name", "First name" },
{ "PER_last_name", "Last name" },
{ "theme", "theme" }
};
var meetingPersonalInfo = new Dictionary <string, string>
{
{ "MEE_id_person", "Id_person" },
{ "PER_id_company", "Id_company" },
{ "PER_first_name", "First name" },
{ "PER_last_name", "Last name" },
{ "MEE_id_meeting", "id_meeting" },
{ "MEE_owner", "owner" }
};
Dictionary <string, string> keys;
switch (questionType)
{
case QuestionType.General:
keys = generalPersonInfo;
break;
case QuestionType.Meeting:
keys = meetingPersonalInfo;
break;
case QuestionType.Workshop:
keys = wsPersonalInfo;
break;
case QuestionType.Session:
keys = sessionPersonalInfo;
break;
default:
keys = null;
break;
}
foreach (var key in keys.Keys)
{
worksheet.Cells[pos, column] = keys[key];
worksheet.Cells[pos, column++].Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.LightGreen);
worksheet.Columns.AutoFit();
}
if (questionType == QuestionType.Meeting)
{
worksheet.Cells[pos, column] = "Participants";
worksheet.Cells[pos, column++].Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.LightGreen);
worksheet.Columns.AutoFit();
}
pos++;
var dataSet = DataExtractionUtils.GetAnswersByColumn(tableName, "person_info");
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
column = 1;
foreach (var columnName in keys.Keys)
{
worksheet.Cells[pos, column++] = dataSet.Tables[0].Rows[i][columnName];
}
if (questionType == QuestionType.Meeting)
{
var companies = getMeetingParticipants(
int.Parse(dataSet.Tables[0].Rows[i]["MEE_id_meeting"].ToString()),
int.Parse(dataSet.Tables[0].Rows[i]["PER_id_company"].ToString())
);
worksheet.Cells[pos, column++] = companies;
}
pos++;
}
worksheet.Columns.AutoFit();
return(column);
}
