// GET: Employees/GenerateCV/5
public ActionResult GenerateCV(int?id)
{
Employee employee = db.Employees.Find(id);
string profilePicUrl = "";
//getting the picture ready
Common.CreateSkillTemplates(employee);
if (employee.File != null)
{
profilePicUrl = Utils.Common.SaveImgLocally(db, employee.File.FileID.ToString());
ViewBag.profilePicUrl = profilePicUrl;
}
else
{
ViewBag.profilePicUrl = System.Web.HttpContext.Current.Server.MapPath("~/Content/Pictures/");
}
//getting the projects for this employee
List <Task> tasks = db.Tasks.Include(x => x.Sprint).Where(x => x.EmployeeID == employee.EmployeeID).ToList();
List <Project> projects = (from t in db.Tasks
join s in db.Sprints on t.SprintID equals s.SprintID
join p in db.Projects on s.ProjectID equals p.ProjectID
where t.EmployeeID == employee.EmployeeID
select p).Distinct().ToList();
foreach (Project p in projects)
{
//selecting the correct tasks for each project
List <Task> projectTasks = tasks.Where(x => x.Sprint != null && x.Sprint.ProjectID == p.ProjectID).ToList();
foreach (Task t in projectTasks)
{
if (t.Estimation.HasValue)
{
p.ManHoursEffort += t.Estimation.Value;
}
}
}
ViewBag.projects = projects;
ViewBag.headertext = "CV: " + employee.FirstName + " " + employee.LastName;
//initialize baseUrl
string baseUrl = Request.Url.Scheme + "://" + Request.Url.Authority +
Request.ApplicationPath.TrimEnd('/') + "/";
ViewBag.baseUrl = baseUrl;
//initializing CV
employee.SkillLevelsList = employee.SkillLevels.ToList();
ViewBag.SkillCategories = db.SkillCategories.OrderByDescending(x => x.Skills.Count).ToList();
//generating the main body
string generatedPDFHtml = ViewRenderer.RenderView("~/Views/Employees/PdfCVGenerator.cshtml", employee,
ControllerContext);
//generating the header
string headertext = ViewRenderer.RenderView("~/Views/Employees/PdfCVHeader.cshtml", employee,
ControllerContext);
byte[] pdfBuffer = PdfGenerator.ConvertHtmlToPDF(generatedPDFHtml, headertext);
//delete the temporary generated file
if (!String.IsNullOrEmpty(profilePicUrl))
{
Utils.Common.DeleteLocalImage(profilePicUrl);
}
//sending the pdf file to download
this.HttpContext.Response.ContentType = "application/pdf";
this.HttpContext.Response.AddHeader("Content-Disposition", "attachment; filename=" + "EmployeeCV.pdf");
this.HttpContext.Response.BinaryWrite(pdfBuffer);
this.HttpContext.Response.Flush();
this.HttpContext.Response.Close();
return(View(employee));
}