private void AddAggeregateRow(List <string> distinctPersons, List <JiraDataModel> jiraList, HtmlGenericControl tableElement)
{
var rowAggeregates = new List <decimal>();
var headerControl1 = new HtmlGenericControl("tr");
headerControl1.Attributes["class"] = "row text-right";
ResolvedJiraHtmlTable.AppendLine("<tr class='row text-right'>");
var cell = new HtmlGenericControl("td");
cell.Attributes["class"] = "col-sm-2";
cell.InnerText = "Total";
headerControl1.Controls.Add(cell);
ResolvedJiraHtmlTable.AppendLine("<td class='col-sm-2'>Total</td>");
foreach (var person in distinctPersons)
{
decimal aggValue = 0;
try
{
var list = (from row in jiraList
where row.Assignee == person
select row).ToList();
aggValue = list.Count;
}
catch { }
cell = new HtmlGenericControl("td");
cell.Attributes["class"] = "col-sm-1";
cell.InnerText = aggValue.ToString("0.00");
headerControl1.Controls.Add(cell);
ResolvedJiraHtmlTable.AppendLine("<td class='col-sm-1'>" + aggValue.ToString("0.00") + "</td>");
rowAggeregates.Add(aggValue);
}
cell = new HtmlGenericControl("td");
cell.Attributes["class"] = "col-sm-1";
cell.InnerText = rowAggeregates.Sum().ToString("0.00");
headerControl1.Controls.Add(cell);
ResolvedJiraHtmlTable.AppendLine("<td class='col-sm-1'>" + rowAggeregates.Sum().ToString("0.00") + "</td>");
ResolvedJiraHtmlTable.AppendLine("</tr");
tableElement.Controls.Add(headerControl1);
}
private string GetEmailTemplate()
{
var emailTemplate = string.Empty;
var stream = System.Web.HttpContext.Current.Server.MapPath("~/Templates/" + "ResolvedJiraSummaryReport.html");
using (var reader = new StreamReader(stream))
{
emailTemplate = reader.ReadToEnd();
}
GetJiraData();
emailTemplate = emailTemplate.Replace("##ResolvedIssuesTable##", ResolvedJiraHtmlTable.ToString());
emailTemplate = emailTemplate.Replace("##TimePeriod##", ResultTimePeriod);
return(emailTemplate);
}
private void AddHeaderRow(List <string> distinctPersons, HtmlGenericControl tableElement)
{
var headerControl = new HtmlGenericControl("tr");
headerControl.Attributes["class"] = "row text-center";
ResolvedJiraHtmlTable.AppendLine("<tr class='row text-center'>");
var cell = new HtmlGenericControl("th");
cell.Attributes["class"] = "col-sm-2";
cell.InnerText = "";
headerControl.Controls.Add(cell);
ResolvedJiraHtmlTable.AppendLine("<th class='col-sm-2'></th>");
cell = new HtmlGenericControl("th");
cell.Attributes["class"] = "col-sm-11 text-center";
cell.Attributes["colspan"] = (distinctPersons.Count + 1).ToString();
cell.InnerText = "Asignees";
headerControl.Controls.Add(cell);
ResolvedJiraHtmlTable.AppendLine("<th class='col-sm-11 text-center' colspan='" + (distinctPersons.Count + 1).ToString() + "'>Asignees</th>");
ResolvedJiraHtmlTable.AppendLine("</tr>");
tableElement.Controls.Add(headerControl);
var headerControl1 = new HtmlGenericControl("tr");
headerControl1.Attributes["class"] = "row text-center";
ResolvedJiraHtmlTable.AppendLine("<tr class='row text-center'>");
cell = new HtmlGenericControl("th");
cell.Attributes["class"] = "col-sm-2";
cell.InnerText = "Projects";
headerControl1.Controls.Add(cell);
ResolvedJiraHtmlTable.AppendLine("<th class='col-sm-2'>Projects</th>");
foreach (var str in distinctPersons)
{
var userFullName = GetUserFullName(str);
cell = new HtmlGenericControl("th");
cell.Attributes["class"] = "col-sm-1";
cell.InnerText = userFullName;
headerControl1.Controls.Add(cell);
ResolvedJiraHtmlTable.AppendLine("<th class='col-sm-1'>" + userFullName + "</th>");
}
cell = new HtmlGenericControl("th");
cell.Attributes["class"] = "col-sm-1";
cell.InnerText = "Total";
headerControl1.Controls.Add(cell);
ResolvedJiraHtmlTable.AppendLine("<th class='col-sm-1'>Total</th>");
ResolvedJiraHtmlTable.AppendLine("<tr/>");
tableElement.Controls.Add(headerControl1);
}
