public ActionResult CreateExcel()
{
var config = GetConfig();
var report = new DevOpsReport(config);
report.ExecEstimateReport(GetEstimateFile());
var excel = new ExcelReport();
excel.AddList(report.TaskEstimateReport, new Dictionary <string, string>());
var bytes = excel.GetXlsFile();
var key = $"Execl{Guid.NewGuid().ToString()}";
TempData[key] = new TmpFile
{
FileName = "Оценка задач.xlsx",
Content = bytes
};
return(new JsonNetResult
{
Data = new
{
key = key
}
});
}
public ActionResult DevOpsReport(DevOpsReportParams @params)
{
try
{
var report = new DevOpsReport(GetConfig(), GetCustomFieldsFile());
report.ExecMainReport(@params);
return(new JsonNetResult
{
Data = new
{
success = true,
activity = report.ActivityReport,
task = report.TaskReport,
diff = report.WorkingTimeDiffReport,
time = report.WorkingTimeReport
}
});
}
catch (Exception e)
{
return(new ExceptionResult(e));
}
}
public ActionResult EstimateReport()
{
var report = new DevOpsReport(GetConfig());
report.ExecEstimateReport(GetEstimateFile());
return(new JsonNetResult
{
Data = new
{
rows = report.TaskEstimateReport
}
});
}
public ActionResult CreateExcel(DevOpsReportParams @params)
{
try
{
var config = GetConfig();
var report = new DevOpsReport(config, GetCustomFieldsFile());
report.ExecMainReport(@params);
var excel = new ExcelReport();
var criteria = new Dictionary <string, string>
{
{ "Период", $"{@params.Start:dd.MM.yyyy} - {(@params.End ?? DateTime.Now.Date):dd.MM.yyyy}" },
{ "Сотрудники", string.Join(", ", config.Employees.Where(x => @params.Employees.Contains(x.Name)).Select(x => x.NameShort).OrderBy(x => x)) },
};
excel.AddList(report.ActivityReport, criteria);
excel.AddList(report.TaskReport, criteria);
excel.AddList(report.WorkingTimeReport, criteria);
excel.AddList(report.WorkingTimeDiffReport, criteria);
var bytes = excel.GetXlsFile();
var key = $"Execl{Guid.NewGuid().ToString()}";
TempData[key] = new TmpFile
{
Content = bytes,
FileName = "Аналитический отчет.xlsx"
};
return(new JsonNetResult
{
Data = new
{
key = key
}
});
}
catch (Exception e)
{
return(new ExceptionResult(e));
}
}
