public ActionResult Pdf(int?id, bool isfirm)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var campaign = db.Campaigns.Include(c => c.ApplicationUsers).Include(a => a.Customer).FirstOrDefault(c => c.IdCampaign == id);
ViewBag.Interviews = db.Interviews.Where(o => o.IdCampaign == id).Where(o => o.Deleted == false).ToList();
ViewBag.Questions = db.Questions.Where(w => w.IdQuestionnaire == campaign.IdQuestionnaire).OrderBy(x => x.IdNode).ToList();
ViewBag.FirmImage = ImageController.GetImage("Firms", campaign.ApplicationUsers.IdFirm.ToString());
ViewBag.CustomerImage = ImageController.GetImage("Customers", campaign.IdCustomer.ToString());
List <Tuple <global::Interview.Interview, double> > listinterviewsscores = new List <Tuple <global::Interview.Interview, double> >();
foreach (var i in db.Interviews.Where(o => o.IdCampaign == id).Where(o => o.Deleted == false))
{
listinterviewsscores.Add(new Tuple <global::Interview.Interview, double>(i, GetWeightedAverage(i.IdInterview)));
}
ViewBag.InterviewsScores = listinterviewsscores;
ViewBag.IsFirm = isfirm;
return(View(campaign));
}
// GET: Customers/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Customer customer = db.Customers.Find(id);
if (customer == null)
{
return(HttpNotFound());
}
var image = ImageController.GetImage("Customers", customer.IdCustomer.ToString());
if (image != "")
{
ViewData["image"] = image;
}
else
{
ViewData["image"] = ImageController.GetImage("Users", "Default");
}
ViewBag.IdIndustry = new SelectList(db.Industries, "IdIndustry", "Name", customer.IdIndustry);
return(View(customer));
}
// GET: Standards
public ActionResult Index()
{
var standards = db.Standards.ToList();
var listStandards = (from item in standards
let image = ImageController.GetImage("Standards", item.IdStandard.ToString())
select Tuple.Create(item, image)).ToList();
return(View(listStandards));
}
// GET: Questionnaires
public ActionResult Index()
{
var standards = db.Standards.Include(s => s.Frameworks);
var listStandards = new List <Tuple <Standard, string> >();
foreach (var item in standards)
{
var image = ImageController.GetImage("Standards", item.IdStandard.ToString());
listStandards.Add(Tuple.Create(item, image));
}
return(View(listStandards));
}
// GET: Customers
public ActionResult Index()
{
var userid = User.Identity.GetUserId();
var userfirm = db.Users.Where(u => u.Id == userid).Select(u => u.IdFirm).FirstOrDefault().GetValueOrDefault();
var customers = db.Customers.Include(c => c.Industry).Where(c => c.IdFirm == userfirm);
var listCustomers = new List <Tuple <Customer, string> >();
foreach (var item in customers)
{
var image = ImageController.GetImage("Customers", item.IdCustomer.ToString());
listCustomers.Add(Tuple.Create(item, image));
}
return(View(listCustomers));
}
public ActionResult Edit([Bind(Include = "IdStandard,Name,Description,Version")] Framework.Standard standard, HttpPostedFileBase fileBase)
{
if (ModelState.IsValid)
{
db.Entry(standard).State = EntityState.Modified;
db.SaveChanges();
if (fileBase != null)
{
var imgctrl = new ImageController();
imgctrl.SetImage(fileBase, "Standards", standard.IdStandard.ToString());
}
return(RedirectToAction("Index"));
}
return(View(standard));
}
public ActionResult Edit([Bind(Include = "IdFirm,Name,Description,Comment")] Firm firm, HttpPostedFileBase fileBase)
{
if (ModelState.IsValid)
{
db.Entry(firm).State = EntityState.Modified;
db.SaveChanges();
if (fileBase != null)
{
var imgctrl = new ImageController();
imgctrl.SetImage(fileBase, "Firms", firm.IdFirm.ToString());
}
return(RedirectToAction("Index"));
}
return(View(firm));
}
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Campaign campaign = db.Campaigns.Find(id);
if (campaign == null)
{
return(HttpNotFound());
}
var interviews = db.Interviews.Where(x => x.IdCampaign == id).Where(x => x.Deleted == false).ToList();
ViewBag.Interviews = interviews;
var candidatescampaign = db.CandidateCampaigns.Where(x => x.IdCampaign == id).Include(x => x.Candidate).Include(x => x.Group);
var candidates = candidatescampaign.Select(cc => cc.Candidate).ToList();
ViewBag.Candidates = candidates;
var consultantscampaign = db.ConsultantCampaigns.Where(x => x.IdCampaign == id).Include(x => x.ApplicationUsers);
var consultants = consultantscampaign.Select(ccc => ccc.ApplicationUsers).ToList();
ViewBag.Consultants = consultants;
// Lists for the selects to add consultant and candidates to a campaign
if (User.IsInRole("Admin"))
{
ViewBag.FullConsultants = new List <ApplicationUser>(db.Users.ToList());
}
else
{
var idfirm = db.Users.Find(User.Identity.GetUserId()).IdFirm;
ViewBag.FullConsultants = idfirm != null ? new List <ApplicationUser>(db.Users.Where(x => x.IdFirm == idfirm).ToList()) : new List <ApplicationUser>();
}
ViewBag.FullCandidats = db.Candidates.Where(c => c.IdCustomer == campaign.IdCustomer);
var grps = db.Groups.Where(g => g.IdCampaign == id).ToList();
ViewBag.FullGroups = grps;
ViewBag.UserImage = ImageController.GetImage("Users", campaign.Id);
ViewBag.CustomerImage = ImageController.GetImage("Customers", campaign.IdCustomer.ToString());
return(View(campaign));
}
public ActionResult Create([Bind(Include = "IdStandard,Name,Description,Version")] Standard standard, HttpPostedFileBase fileBase)
{
if (ModelState.IsValid)
{
db.Standards.Add(standard);
db.SaveChanges();
if (fileBase != null)
{
var imgctrl = new ImageController();
imgctrl.SetImage(fileBase, "Standards", standard.IdStandard.ToString());
}
ViewBag.ImgTitle = "Upload standard logo";
return(RedirectToAction("Index"));
}
return(View(standard));
}
// GET: Firms
public ActionResult Index()
{
ApplicationUser actualuser = db.Users.Find(User.Identity.GetUserId());
List <Firm> firms = new List <Firm>();
if (User.IsInRole("Admin"))
{
firms = db.Firms.ToList();
}
else
{
firms = db.Firms.Where(x => x.IdFirm == actualuser.IdFirm).ToList();
}
var listFirms = (from item in firms
let image = ImageController.GetImage("Firms", item.IdFirm.ToString())
select Tuple.Create(item, image)).ToList();
return(View(listFirms));
}
public ActionResult Edit([Bind(Include = "IdCustomer,Name,Description,Comment,IdIndustry")] Customer customer, HttpPostedFileBase fileBase)
{
if (ModelState.IsValid)
{
var userid = User.Identity.GetUserId();
var firm = db.Users.Find(userid).IdFirm.Value;
customer.IdFirm = firm;
db.Entry(customer).State = EntityState.Modified;
db.SaveChanges();
if (fileBase != null)
{
var imgctrl = new ImageController();
imgctrl.SetImage(fileBase, "Customers", customer.IdCustomer.ToString());
}
return(RedirectToAction("Index"));
}
ViewBag.IdIndustry = new SelectList(db.Industries, "IdIndustry", "Name", customer.IdIndustry);
return(View(customer));
}
// GET: Standards/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var standard = db.Standards.Find(id);
if (standard == null)
{
return(HttpNotFound());
}
var image = ImageController.GetImage("Standards", standard.IdStandard.ToString());
if (image != "")
{
ViewData["image"] = image;
}
else
{
ViewData["image"] = ImageController.GetImage("Users", "Default");
}
return(View(standard));
}
// GET: Firms/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Firm firm = db.Firms.Find(id);
if (firm == null)
{
return(HttpNotFound());
}
var image = ImageController.GetImage("Firms", firm.IdFirm.ToString());
if (image != "")
{
ViewData["image"] = image;
}
else
{
ViewData["image"] = ImageController.GetImage("Firms", "Default");
}
return(View(firm));
}
public ActionResult Pdf(int?id, bool isfirm)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var interview = db.Interviews.Where(f => f.IdInterview == id).Include(c => c.ApplicationUsers).Include(c => c.Campaign).FirstOrDefault();
ViewBag.Nodes = db.Nodes.Where(x => x.IsRoot == false).ToList();
ViewBag.Questions = db.Questions.Where(w => w.IdQuestionnaire == interview.Campaign.IdQuestionnaire).OrderBy(x => x.IdNode).ToList();
ViewBag.FirmImage = ImageController.GetImage("Firms", interview.Campaign.ApplicationUsers.IdFirm.ToString());
ViewBag.CustomerImage = ImageController.GetImage("Customers", interview.Campaign.IdCustomer.ToString());
ViewBag.ConsultantImage = ImageController.GetImage("Users", interview.ApplicationUsers.Id.ToString());
ViewBag.OverallScore = GetWeightedAverage((int)id).ToString();
ViewBag.InterviewInterviewee = "";
var b = false;
foreach (var ie in db.Interviewees.Where(x => x.IdInterview == id).Include(c => c.Candidate))
{
if (b)
{
ViewBag.InterviewInterviewee += ", ";
}
else
{
b = true;
}
ViewBag.InterviewInterviewee += ie.Candidate.FullName;
}
ViewBag.IsFirm = isfirm;
return(View(interview));
}
public ActionResult Create([Bind(Include = "IdCustomer,Name,Description,Comment,IdIndustry")] Customer customer, HttpPostedFileBase fileBase)
{
if (ModelState.IsValid)
{
var userid = User.Identity.GetUserId();
var firm = db.Users.Find(userid).IdFirm.Value;
customer.IdFirm = firm;
db.Customers.Add(customer);
db.SaveChanges();
TempData["Msg"] = "Data has been saved successfully";
if (fileBase != null)
{
var imgctrl = new ImageController();
imgctrl.SetImage(fileBase, "Customers", customer.IdCustomer.ToString());
}
ViewBag.ImgTitle = "Upload customer logo";
return(RedirectToAction("Index"));
}
ViewBag.IdIndustry = new SelectList(db.Industries, "IdIndustry", "Name", customer.IdIndustry);
return(View(customer));
}
public ActionResult Edit(int idinterview)
{
//if (idinterview == null)
//{
// return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
//}
iditv = idinterview;
// Initialisation
nodes = db.Nodes;
var idquest = db.Interviews.Include(i => i.Campaign)
.Where(i => i.IdInterview == idinterview)
.Select(i => i.Campaign.IdQuestionnaire).FirstOrDefault();
questions = db.Questions.Where(q => q.IdQuestionnaire == idquest);
var inodes = nodes.Where(n => n.IdQuestionnaire == idquest);
//questions = db.Questions;
answers = db.Answers;
list = new List <Tuple <int, int> >();
order = new List <Tuple <int, string, string, string, string, int, bool> >();
comments = new List <Tuple <int, int, string, string, bool> >();
rootnode = inodes.FirstOrDefault(i => i.IsRoot);
// Fill list to store nodes and their parents
foreach (var node in inodes.Where(node => !node.IsRoot))
{
if ((node.IdParentNode != null) && (rootnode != null) && (node.IdParentNode != rootnode.IdNode))
{
var idpn = (int)node.IdParentNode;
list.Add(Tuple.Create(idpn, node.IdNode));
}
else
{
list.Add(Tuple.Create(node.IdNode, node.IdNode));
}
}
// Sort list to display in right order
list.Sort(Comparer <Tuple <int, int> > .Create((x, y) =>
{
var result = x.Item1.CompareTo(y.Item1);
return(result == 0 ? x.Item2.CompareTo(y.Item2) : result);
}));
// Put RootNode name in ViewBag (not displayed for now)
ViewBag.RootNode = rootnode;
// Put the HTML string (created from recursive function) to ViewBag
ViewBag.Tree = createTree(0, true);
// Put the HTML string of roles checkboxes to ViewBag
var idframework = questions.Select(q => q.Questionnaire.IdFramework).FirstOrDefault();
ViewBag.Roles = createRolePanel(idframework);
// Put list that orders questions to ViewBag for angular
ViewBag.List = new JavaScriptSerializer().Serialize(order);
// Put the list that will contain the comments to ViewBag
ViewBag.Comments = new JavaScriptSerializer().Serialize(comments);
var campaign = db.Campaigns.Find(db.Interviews.Find(idinterview).IdCampaign);
ViewBag.InterviewName = db.Interviews.Find(idinterview).Name;
ViewBag.InterviewCampaign = campaign.Name;
ViewBag.InterviewIdCampaign = db.Interviews.Find(idinterview).IdCampaign;
ViewBag.Questionnaire = db.Questionnaires.Find(idquest).Name;
ViewBag.Candidate = db.Interviewees.Include(i => i.Candidate).Where(i => i.IdInterview == idinterview).Select(i => i.Candidate.FirstName + " " + i.Candidate.LastName + " - " + i.Candidate.Function).ToList();
ViewBag.CustomerImage = ImageController.GetImage("Customers", campaign.IdCustomer.ToString());
ViewBag.CustomerName = campaign.Customer.Name;
ViewBag.CustomerIndustry = campaign.Customer.Industry.Name;
return(View("Index", idinterview));
}
public ActionResult Word(int id, int type, byte[] image, bool pdf = false)
{
var dba = new ApplicationDbContext();
int idCustomer;
string idConsultant;
global::Interview.Interview interview = null;
Campaign campaign = null;
byte[] byteArrayImg;
if (type == 1 || type == 2)
{
idCustomer = db.Interviews.Where(i => i.IdCampaign == id).Include(i => i.Campaign.Customer).Select(i => i.Campaign.Customer.IdCustomer).FirstOrDefault();
idConsultant = db.Interviews.Where(i => i.IdCampaign == id).Select(u => u.Id).FirstOrDefault();
var idFirm = db.Users.Where(u => u.Id == idConsultant).Select(u => u.IdFirm).FirstOrDefault();
byteArrayImg = ImageController.GetImage("Firms", idFirm.ToString(), true);
}
else
{
idCustomer = db.Interviews.Where(i => i.IdInterview == id).Include(i => i.Campaign.Customer).Select(i => i.Campaign.Customer.IdCustomer).FirstOrDefault();
idConsultant = db.Interviews.Where(i => i.IdInterview == id).Select(u => u.Id).FirstOrDefault();
byteArrayImg = ImageController.GetImage("Users", idConsultant, true);
}
var byteArrayCust = ImageController.GetImage("Customers", idCustomer.ToString(), true);
Stream streamCust = new MemoryStream(byteArrayCust);
Stream streamImg = new MemoryStream(byteArrayImg);
WordDocument document = new WordDocument();
IWSection section = document.AddSection();
section.PageSetup.DifferentFirstPage = true;
section.PageSetup.InsertPageNumbers(false, PageNumberAlignment.Center);
section.PageSetup.Margins.Left = 50;
section.PageSetup.Margins.Right = 50;
// Add a new paragraph for header to the document.
IWParagraph headerPar = new WParagraph(document);
// Add a new table to the header.
IWTable table = section.HeadersFooters.FirstPageHeader.AddTable();
// Styles
const string font = "Segoe UI";
Style styleTitle = (WParagraphStyle)document.AddParagraphStyle("Title");
styleTitle.CharacterFormat.FontName = font;
styleTitle.CharacterFormat.FontSize = 25;
styleTitle.CharacterFormat.TextColor = Color.FromArgb(31, 73, 125);
Style stylePNode = (WParagraphStyle)document.AddParagraphStyle("PNode");
stylePNode.CharacterFormat.FontName = font;
stylePNode.CharacterFormat.TextColor = Color.FromArgb(238, 131, 0);
stylePNode.CharacterFormat.FontSize = 20;
Style styleNode = (WParagraphStyle)document.AddParagraphStyle("Node");
styleNode.CharacterFormat.FontName = font;
styleNode.CharacterFormat.TextColor = Color.FromArgb(195, 23, 0);
styleNode.CharacterFormat.FontSize = 17;
Style styleQuestion = (WParagraphStyle)document.AddParagraphStyle("Question");
styleQuestion.CharacterFormat.FontName = font;
styleQuestion.CharacterFormat.Bold = true;
styleQuestion.CharacterFormat.FontSize = 11;
Style styleAnswer = (WParagraphStyle)document.AddParagraphStyle("Answer");
styleAnswer.CharacterFormat.FontName = font;
styleAnswer.CharacterFormat.FontSize = 11;
styleAnswer.CharacterFormat.TextColor = Color.FromArgb(31, 73, 125);
Style styleList = (WParagraphStyle)document.AddParagraphStyle("List");
styleList.CharacterFormat.FontName = font;
styleList.CharacterFormat.TextColor = Color.FromArgb(51, 132, 204);
styleList.CharacterFormat.FontSize = 11;
styleList.CharacterFormat.UnderlineStyle = UnderlineStyle.Single;
Style styleComment = (WParagraphStyle)document.AddParagraphStyle("Comment");
styleComment.CharacterFormat.FontName = font;
styleComment.CharacterFormat.Italic = true;
styleComment.CharacterFormat.FontSize = 11;
var format = new RowFormat();
// Setting cleared table border style.
format.Borders.BorderType = BorderStyle.Cleared;
// Inserting table with a row and two columns.
table.ResetCells(1, 2, format, 265);
IWTextRange textRange;
// Inserting logo image to the table cells.
headerPar = table[0, 0].AddParagraph() as WParagraph;
headerPar.AppendPicture(Image.FromStream(streamImg));
(headerPar.Items[0] as WPicture).Width = 50;
(headerPar.Items[0] as WPicture).Height = 50;
headerPar.AppendText(Environment.NewLine);
var userName = db.Users.Find(idConsultant).FullName;
switch (type)
{
case 1:
case 2:
textRange = headerPar.AppendText("Manager: " + userName);
textRange.CharacterFormat.FontName = font;
headerPar.AppendText(Environment.NewLine);
textRange = headerPar.AppendText("Type : Campaign");
textRange.CharacterFormat.FontName = font;
break;
case 3:
case 4:
textRange = headerPar.AppendText("Consultant: " + userName);
textRange.CharacterFormat.FontName = font;
headerPar.AppendText(Environment.NewLine);
textRange = headerPar.AppendText("Type: Interview");
textRange.CharacterFormat.FontName = font;
break;
}
headerPar.ParagraphFormat.HorizontalAlignment = HorizontalAlignment.Left;
var customerName = db.Customers.Find(idCustomer).Name;
var industryName =
db.Customers.Where(c => c.IdCustomer == idCustomer)
.Include(c => c.Industry)
.Select(c => c.Industry.Name).FirstOrDefault();
// Inserting text to the table second cell.
headerPar = table[0, 1].AddParagraph() as WParagraph;
headerPar.AppendPicture(Image.FromStream(streamCust));
((WPicture)headerPar.Items[0]).Width = 50;
((WPicture)headerPar.Items[0]).Height = 50;
headerPar.AppendText(Environment.NewLine);
headerPar.AppendText("Customer: " + customerName);
headerPar.AppendText(Environment.NewLine);
headerPar.AppendText("Industry: " + industryName);
headerPar.ParagraphFormat.HorizontalAlignment = HorizontalAlignment.Right;
section = document.AddSection();
section.BreakCode = SectionBreakCode.NoBreak;
IWParagraph paragraph = section.AddParagraph();
//TableOfContent toc = paragraph.AppendTOC(1, 3);
//toc.UseHeadingStyles = false;
//toc.SetTOCLevelStyle(1, "Title");
//toc.SetTOCLevelStyle(2, "PNode");
//toc.SetTOCLevelStyle(3, "Node");
if (type == 1 || type == 2)
{
campaign = db.Campaigns.Find(id);
var idQuestionnaire = db.Interviews.Where(i => i.Campaign.IdCampaign == id).Include(i => i.Campaign).Select(i => i.Campaign.IdQuestionnaire).FirstOrDefault();
var questions = db.Questions.Where(q => q.IdQuestionnaire == idQuestionnaire);
var questionnairename = db.Questionnaires.Find(idQuestionnaire).Name;
var interviewees =
db.CandidateCampaigns.Include(cc => cc.Candidate).Include(x => x.Group)
.Where(cc => cc.IdCampaign == campaign.IdCampaign)
.Select(x => x.Candidate);
var consultants =
db.Campaigns.Where(c => c.IdCampaign == campaign.IdCampaign)
.Include(c => c.ApplicationUsers)
.Select(c => c.ApplicationUsers);
string start = "";
if (campaign.StartDate != null)
{
start = campaign.StartDate.Value.ToShortDateString();
}
var end = "";
if (campaign.EndDate != null)
{
end = campaign.EndDate.Value.ToShortDateString();
}
paragraph.AppendText(Environment.NewLine + Environment.NewLine + Environment.NewLine);
textRange = paragraph.AppendText("Campaign: " + campaign.Name);
paragraph.ApplyStyle("Title");
paragraph.AppendText(Environment.NewLine + Environment.NewLine);
paragraph = section.AddParagraph();
textRange = paragraph.AppendText("Start: " + start + " -> Expected End: " + end);
textRange.CharacterFormat.FontName = font;
paragraph.ParagraphFormat.HorizontalAlignment = HorizontalAlignment.Left;
paragraph.AppendText(Environment.NewLine + Environment.NewLine);
textRange = paragraph.AppendText("Questionnaire: " + questionnairename);
textRange.CharacterFormat.FontName = font;
paragraph.AppendText(Environment.NewLine + Environment.NewLine);
textRange = paragraph.AppendText("Description: " + campaign.Description);
textRange.CharacterFormat.FontName = font;
paragraph.AppendText(Environment.NewLine + Environment.NewLine);
if (type == 2 && !string.IsNullOrEmpty(campaign.Comment))
{
textRange = paragraph.AppendText("Comment: " + campaign.Comment);
textRange.CharacterFormat.FontName = font;
}
paragraph.AppendText(Environment.NewLine + Environment.NewLine);
paragraph = section.AddParagraph();
paragraph.AppendText("Consultants: ");
paragraph.ApplyStyle("List");
foreach (var consultant in consultants)
{
paragraph = section.AddParagraph();
textRange = paragraph.AppendText(consultant.FullName);
textRange.CharacterFormat.FontName = font;
paragraph.ListFormat.ApplyDefBulletStyle();
}
var dbg = new ApplicationDbContext();
if (type == 2)
{
paragraph = section.AddParagraph();
paragraph.AppendText("Interviewees: ");
paragraph.ApplyStyle("List");
foreach (var interviewee in interviewees)
{
paragraph = section.AddParagraph();
var group = dbg.CandidateCampaigns.Where(cc => cc.IdCandidate == interviewee.IdCandidate).Select(cc => cc.Group).FirstOrDefault();
var groupname = "";
if (group != null)
{
groupname = group.Name;
}
textRange = paragraph.AppendText(interviewee.FullNameAndFunction + " - " + groupname);
textRange.CharacterFormat.FontName = font;
paragraph.ListFormat.ApplyDefBulletStyle();
}
}
// Nodes
var fullnodes = db.Nodes.Where(x => x.IdQuestionnaire == idQuestionnaire).ToList();
if (fullnodes.Any())
{
var root = fullnodes.FirstOrDefault(r => r.IsRoot);
if (root != null)
{
var nodes = fullnodes.Where(n => !n.IsRoot && n.IdParentNode != root.IdNode).ToList();
var pnodes = fullnodes.FindAll(p => p.IdParentNode == root.IdNode).ToList();
foreach (var pnode in pnodes)
{
section = document.AddSection();
paragraph = section.AddParagraph();
paragraph.AppendText(Environment.NewLine);
paragraph.AppendText(pnode.Name);
paragraph.ApplyStyle("PNode");
if (db.Questions.Any(x => x.IdNode == pnode.IdNode))
{
foreach (var question in questions.Where(q => q.IdNode == pnode.IdNode))
{
paragraph = section.AddParagraph();
paragraph.AppendText(question.Description);
paragraph.ApplyStyle("Question");
paragraph.AppendText(Environment.NewLine);
if (!question.IsRelevant)
{
textRange.CharacterFormat.TextColor = Color.DimGray;
}
section.AddParagraph().AppendText(Environment.NewLine);
var dbi = new ApplicationDbContext();
foreach (var answer in dba.Answers.Where(a => a.IdQuestion == question.IdQuestion && a.Interview.IdCampaign == campaign.IdCampaign && !a.Interview.Deleted))
{
var intervname = dbi.Interviews.Find(answer.IdInterview).Name;
paragraph = section.AddParagraph();
paragraph.AppendText("Answer from Interview " + intervname + ":");
paragraph.ApplyStyle("Answer");
if (answer != null && answer.IntervieweeAnswer != null)
{
if (question.AnswerType == AnswerType.Integer)
{
textRange = paragraph.AppendText(answer.IntervieweeAnswer + " / 5");
}
else
{
textRange = paragraph.AppendText(answer.IntervieweeAnswer);
}
textRange.CharacterFormat.FontName = font;
textRange.CharacterFormat.Bold = true;
paragraph.AppendText(Environment.NewLine);
}
else
{
paragraph = section.AddParagraph();
textRange = paragraph.AppendText("No answer yet");
textRange.CharacterFormat.FontName = font;
textRange.CharacterFormat.TextColor = Color.DarkGray;
paragraph.AppendText(Environment.NewLine);
}
if (type == 2 && !string.IsNullOrEmpty(answer.ConsultantComment))
{
if (answer.Comment != null)
{
paragraph = section.AddParagraph();
paragraph.AppendText("Comment: " + answer.Comment);
paragraph.ApplyStyle("Comment");
paragraph.AppendText(Environment.NewLine);
}
paragraph = section.AddParagraph();
paragraph.AppendText("Consultant's comment: " + answer.ConsultantComment);
paragraph.ApplyStyle("Comment");
paragraph.AppendText(Environment.NewLine);
}
}
}
}
else
{
foreach (var node in nodes.Where(n => n.IdParentNode == pnode.IdNode))
{
paragraph = section.AddParagraph();
paragraph.AppendText(Environment.NewLine);
paragraph.AppendText(" > " + node.Name);
paragraph.ApplyStyle("Node");
paragraph.AppendText(Environment.NewLine);
foreach (var question in questions.Where(q => q.IdNode == node.IdNode))
{
paragraph = section.AddParagraph();
paragraph.AppendText(question.Description);
paragraph.ApplyStyle("Question");
paragraph.AppendText(Environment.NewLine);
if (!question.IsRelevant)
{
textRange.CharacterFormat.TextColor = Color.DimGray;
}
var dbi = new ApplicationDbContext();
foreach (var answer in dba.Answers.Where(a => a.IdQuestion == question.IdQuestion && a.Interview.IdCampaign == campaign.IdCampaign && !a.Interview.Deleted))
{
var intervname = dbi.Interviews.Find(answer.IdInterview).Name;
paragraph = section.AddParagraph();
paragraph.AppendText("Answer from Interview " + intervname + ":");
paragraph.ApplyStyle("Answer");
if (answer.IntervieweeAnswer != null)
{
paragraph = section.AddParagraph();
if (question.AnswerType == AnswerType.Integer)
{
textRange = paragraph.AppendText(answer.IntervieweeAnswer + " / 5");
}
else
{
textRange = paragraph.AppendText(answer.IntervieweeAnswer);
}
textRange.CharacterFormat.FontName = font;
textRange.CharacterFormat.Bold = true;
paragraph.AppendText(Environment.NewLine);
}
else
{
paragraph = section.AddParagraph();
textRange = paragraph.AppendText("No answer yet");
textRange.CharacterFormat.FontName = font;
textRange.CharacterFormat.TextColor = Color.DarkGray;
paragraph.AppendText(Environment.NewLine);
}
if (type == 2 && !string.IsNullOrEmpty(answer.ConsultantComment))
{
if (answer.Comment != null)
{
paragraph = section.AddParagraph();
paragraph.AppendText("Comment: " + answer.Comment);
paragraph.ApplyStyle("Comment");
paragraph.AppendText(Environment.NewLine);
}
paragraph = section.AddParagraph();
paragraph.AppendText("Consultant's comment: " + answer.ConsultantComment);
paragraph.ApplyStyle("Comment");
paragraph.AppendText(Environment.NewLine);
}
}
}
}
}
}
}
}
}
else if (type == 3 || type == 4)
{
interview = db.Interviews.Find(id);
var idInterviewee = db.Interviewees.Where(i => i.IdInterview == id).Select(i => i.IdCandidate).FirstOrDefault();
var idQuestionnaire = db.Interviews.Where(i => i.IdInterview == id).Include(i => i.Campaign).Select(i => i.Campaign.IdQuestionnaire).FirstOrDefault();
var questions = db.Questions.Where(q => q.IdQuestionnaire == idQuestionnaire);
var interviewees =
db.Interviewees.Include(cc => cc.Candidate)
.Where(cc => cc.IdInterview == interview.IdInterview)
.Select(x => x.Candidate);
var consultant = interview.ApplicationUsers;
paragraph.AppendText(Environment.NewLine + Environment.NewLine + Environment.NewLine);
paragraph.AppendText("Interview: " + interview.Name);
paragraph.ApplyStyle("Title");
paragraph.AppendText(Environment.NewLine + Environment.NewLine);
paragraph = section.AddParagraph();
textRange = paragraph.AppendText("Date: " + interview.Date.ToShortDateString() + Environment.NewLine);
textRange.CharacterFormat.FontName = font;
paragraph.AppendText(Environment.NewLine + Environment.NewLine);
textRange = paragraph.AppendText("Description: " + interview.Description);
textRange.CharacterFormat.FontName = font;
paragraph.AppendText(Environment.NewLine + Environment.NewLine);
if (type == 4 && interview.Comment != null)
{
textRange = paragraph.AppendText("Comment: " + interview.Comment + Environment.NewLine);
textRange.CharacterFormat.FontName = font;
}
paragraph.ParagraphFormat.HorizontalAlignment = HorizontalAlignment.Left;
paragraph.AppendText(Environment.NewLine + Environment.NewLine);
paragraph = section.AddParagraph();
paragraph.AppendText("Consultants: ");
paragraph.ApplyStyle("List");
paragraph = section.AddParagraph();
textRange = paragraph.AppendText(consultant.FullName);
textRange.CharacterFormat.FontName = font;
paragraph.ListFormat.ApplyDefBulletStyle();
paragraph = section.AddParagraph();
paragraph.AppendText("Interviewee(s): ");
paragraph.ApplyStyle("List");
var dbc = new ApplicationDbContext();
foreach (var i in interviewees)
{
paragraph = section.AddParagraph();
var group =
dbc.CandidateCampaigns.Where(
cc => cc.IdCandidate == i.IdCandidate && cc.IdCampaign == interview.IdCampaign).Select(cc => cc.Group).FirstOrDefault();
var groupname = "";
if (group != null)
{
groupname = group.Name;
}
textRange = paragraph.AppendText(i.FullNameAndFunction + " - " + groupname);
textRange.CharacterFormat.FontName = font;
textRange.CharacterFormat.Bold = false;
paragraph.ListFormat.ApplyDefBulletStyle();
}
var fullnodes = db.Nodes.Where(x => x.IdQuestionnaire == idQuestionnaire).ToList();
if (fullnodes.Any())
{
var root = fullnodes.FirstOrDefault(r => r.IsRoot);
if (root != null)
{
var nodes = fullnodes.Where(n => !n.IsRoot && n.IdParentNode != root.IdNode).ToList();
var pnodes = fullnodes.FindAll(p => p.IdParentNode == root.IdNode).ToList();
foreach (var pnode in pnodes)
{
var score = db.CustomScores.FirstOrDefault(c => c.IdNode == pnode.IdNode && c.IdInterview == interview.IdInterview);
var val = 0;
if (score != null)
{
val = score.Value != null ? score.Value : 0;
}
section = document.AddSection();
paragraph = section.AddParagraph();
paragraph.AppendText(Environment.NewLine);
paragraph.AppendText(pnode.Name + " " + val + " / 5");
paragraph.ApplyStyle("PNode");
if (db.Questions.Any(x => x.IdNode == pnode.IdNode))
{
foreach (var question in questions.Where(q => q.IdNode == pnode.IdNode))
{
var answer = dba.Answers.FirstOrDefault(a => a.IdQuestion == question.IdQuestion && a.IdInterview == id);
paragraph = section.AddParagraph();
paragraph.AppendText(question.Description);
paragraph.ApplyStyle("Question");
paragraph.AppendText(Environment.NewLine);
if (answer != null && answer.IntervieweeAnswer != null)
{
paragraph = section.AddParagraph();
paragraph.AppendText("Answer:");
paragraph.ApplyStyle("Answer");
paragraph = section.AddParagraph();
if (question.AnswerType == AnswerType.Integer)
{
paragraph.AppendText(answer.IntervieweeAnswer + " / 5");
}
else
{
paragraph.AppendText(answer.IntervieweeAnswer);
}
textRange.CharacterFormat.FontName = font;
textRange.CharacterFormat.Bold = true;
paragraph.AppendText(Environment.NewLine);
if (type == 4 && !string.IsNullOrEmpty(answer.ConsultantComment))
{
if (answer.Comment != null)
{
paragraph = section.AddParagraph();
paragraph.AppendText("Comment: " + answer.Comment);
paragraph.ApplyStyle("Comment");
paragraph.AppendText(Environment.NewLine);
}
paragraph = section.AddParagraph();
paragraph.AppendText("Consultant's comment: " + answer.ConsultantComment);
paragraph.ApplyStyle("Comment");
paragraph.AppendText(Environment.NewLine);
}
}
else
{
paragraph = section.AddParagraph();
textRange = paragraph.AppendText("No answer yet");
textRange.CharacterFormat.FontName = font;
textRange.CharacterFormat.TextColor = Color.DarkGray;
paragraph.AppendText(Environment.NewLine);
}
}
}
else
{
foreach (var node in nodes.Where(n => n.IdParentNode == pnode.IdNode))
{
paragraph = section.AddParagraph();
paragraph.AppendText(Environment.NewLine);
paragraph.AppendText(" > " + node.Name + " " + val + " / 5");
paragraph.ApplyStyle("Node");
paragraph.AppendText(Environment.NewLine);
foreach (var question in questions.Where(q => q.IdNode == node.IdNode))
{
var answer = dba.Answers.FirstOrDefault(a => a.IdQuestion == question.IdQuestion && a.IdInterview == id);
paragraph = section.AddParagraph();
paragraph.AppendText(question.Description);
paragraph.ApplyStyle("Question");
paragraph.AppendText(Environment.NewLine);
if (answer != null && answer.IntervieweeAnswer != null)
{
paragraph = section.AddParagraph();
paragraph.AppendText("Answer:");
paragraph.ApplyStyle("Answer");
paragraph = section.AddParagraph();
if (question.AnswerType == AnswerType.Integer)
{
paragraph.AppendText(answer.IntervieweeAnswer + " / 5");
}
else
{
paragraph.AppendText(answer.IntervieweeAnswer);
}
textRange.CharacterFormat.FontName = font;
textRange.CharacterFormat.Bold = true;
paragraph.AppendText(Environment.NewLine);
if (type == 4 && !string.IsNullOrEmpty(answer.ConsultantComment))
{
if (answer.Comment != null)
{
paragraph = section.AddParagraph();
paragraph.AppendText("Comment: " + answer.Comment);
paragraph.ApplyStyle("Comment");
paragraph.AppendText(Environment.NewLine);
}
paragraph = section.AddParagraph();
paragraph.AppendText("Consultant's comment: " + answer.ConsultantComment);
paragraph.ApplyStyle("Comment");
paragraph.AppendText(Environment.NewLine);
}
}
else
{
paragraph = section.AddParagraph();
textRange = paragraph.AppendText("No answer yet");
textRange.CharacterFormat.FontName = font;
textRange.CharacterFormat.TextColor = Color.DarkGray;
paragraph.AppendText(Environment.NewLine);
}
}
}
}
}
}
}
}
switch (type)
{
case 1:
if (!pdf)
{
return(document.ExportAsActionResult(DateTime.Now.ToShortDateString() + "_" + campaign.Name + "_Customer.docx", FormatType.Word2013, HttpContext.ApplicationInstance.Response, HttpContentDisposition.Attachment));
}
else
{
var converted = ConvertToPDF(document);
return(converted.ExportAsActionResult(DateTime.Now.ToShortDateString() + "_" + campaign.Name + "_Customer.pdf", HttpContext.ApplicationInstance.Response, HttpReadType.Save));
}
case 2:
if (!pdf)
{
return(document.ExportAsActionResult(DateTime.Now.ToShortDateString() + "_" + campaign.Name + "_Firm.docx", FormatType.Word2013, HttpContext.ApplicationInstance.Response, HttpContentDisposition.Attachment));
}
else
{
var converted = ConvertToPDF(document);
return(converted.ExportAsActionResult(DateTime.Now.ToShortDateString() + "_" + campaign.Name + "_Firm.pdf", HttpContext.ApplicationInstance.Response, HttpReadType.Save));
}
case 3:
if (!pdf)
{
return(document.ExportAsActionResult(DateTime.Now.ToShortDateString() + "_" + interview.Name + "_Customer.docx", FormatType.Word2013, HttpContext.ApplicationInstance.Response, HttpContentDisposition.Attachment));
}
else
{
var converted = ConvertToPDF(document);
return(converted.ExportAsActionResult(DateTime.Now.ToShortDateString() + "_" + interview.Name + "_Customer.pdf", HttpContext.ApplicationInstance.Response, HttpReadType.Save));
}
case 4:
if (!pdf)
{
return(document.ExportAsActionResult(DateTime.Now.ToShortDateString() + "_" + interview.Name + "_Firm.docx", FormatType.Word2013, HttpContext.ApplicationInstance.Response, HttpContentDisposition.Attachment));
}
else
{
var converted = ConvertToPDF(document);
return(converted.ExportAsActionResult(DateTime.Now.ToShortDateString() + "_" + interview.Name + "_Firm.pdf", HttpContext.ApplicationInstance.Response, HttpReadType.Save));
}
}
return(document.ExportAsActionResult("Report.docx", FormatType.Word2013, HttpContext.ApplicationInstance.Response, HttpContentDisposition.Attachment));
}