private byte[] BuildCsv(IssuesSonarViewModel viewModel)
{
StringBuilder stringBuilderCsv = new StringBuilder();
stringBuilderCsv.Append("Date de creation");
stringBuilderCsv.Append(";" + "Groupe Ad");
stringBuilderCsv.Append(";" + "Code Project");
stringBuilderCsv.Append(";" + "Assignee");
stringBuilderCsv.Append(";" + "Projet");
stringBuilderCsv.Append(";" + "Severite");
stringBuilderCsv.Append(";" + "Regle");
stringBuilderCsv.Append(";" + "ChangeSet");
stringBuilderCsv.Append(";" + "Line");
stringBuilderCsv.Append(";" + "Count Code Line for changeSet");
stringBuilderCsv.AppendLine();
foreach (var item in viewModel.Issues.IssueSet)
{
stringBuilderCsv.Append(item.IssueDetail.creationDate);
stringBuilderCsv.Append(";" + item.ADGroup);
stringBuilderCsv.Append(";" + item.CodeProject);
stringBuilderCsv.Append(";" + item.IssueDetail.assignee);
stringBuilderCsv.Append(";" + item.IssueDetail.project);
stringBuilderCsv.Append(";" + item.IssueDetail.severity);
stringBuilderCsv.Append(";" + item.IssueDetail.rule);
stringBuilderCsv.Append(";" + item.ChangetSet);
stringBuilderCsv.Append(";" + item.IssueDetail.line);
stringBuilderCsv.Append(";" + item.CodeLineCountForChangeSet);
stringBuilderCsv.AppendLine();
}
return(Encoding.UTF8.GetBytes(stringBuilderCsv.ToString()));
}
public IssuesSonarViewModel BuildIssuesSonarViewModel(DateTime DateFrom, DateTime DateTo)
{
_sonarRequestGetIssues.DateFrom = DateFrom;
_sonarRequestGetIssues.DateTo = DateTo;
var result = _sonarService.GetIssuesSonar(_sonarRequestGetIssues);
IssuesSonarViewModel issuesSonarViewModel = new IssuesSonarViewModel()
{
Issues = result, DateFrom = DateFrom, DateTo = DateTo
};
issuesSonarViewModel.Issues = result;
return(issuesSonarViewModel);
}
public FileContentResult DownloadCSV(IssuesSonarViewModel model)
{
var viewModel = _issuesSonarViewModelFactory.BuildIssuesSonarViewModel(model.DateFrom, model.DateTo.AddDays(1));
if (viewModel?.Issues?.IssueSet == null)
{
return(default(FileContentResult));
}
var data = BuildCsv(viewModel);
string filename = "reportSonar_" + model?.DateFrom.ToString("dd-MM-yyyy") + "_" + model?.DateTo.ToString("dd-MM-yyyy") + ".csv";
return(File(data, "text/csv", filename));
}
public ActionResult report(IssuesSonarViewModel model)
{
var viewModel = _issuesSonarViewModelFactory.BuildIssuesSonarViewModel(model.DateFrom, model.DateTo.AddDays(1));
return(View("Index", viewModel));
}
