public async Task <HttpResponseMessage> ExportExcel(HttpRequestMessage request, int idDuAn)
{
return(CreateReponse(request, () =>
{
string filename = string.Concat(DateTime.Now.ToString("ddMMyyyyhhmmss") + "aso.xlsx");
var folderReport = ConfigHelper.GetValueByKey("ReportFolder");
string path = HttpContext.Current.Server.MapPath(folderReport);
var pathTemplate = ConfigHelper.GetValueByKey("Template");
string fullPathTemplateStandad = Path.Combine(HttpContext.Current.Server.MapPath(pathTemplate));
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
string fullPath = Path.Combine(path, filename);
try
{
var duan = _daService.GetAllInfoById(idDuAn);
var hangmucGt = _hangmucService.GetHangMucByIdDuAn(idDuAn, 1);
var hangmucTT = _hangmucService.GetHangMucByIdDuAn(idDuAn, 0);
//fullPathTemplateStandad //, new System.IO.FileInfo()
using (ExcelPackage ep = new ExcelPackage(new System.IO.FileInfo(fullPath)))
{
if (hangmucGt.Count() > 0)
{
ExcelWorksheet exs = ep.Workbook.Worksheets.Add("GIÁN TIẾP");
var thamgiaGt = _thamGia.GetIncomeById(idDuAn, 1);
this.ExcelAction(hangmucGt, thamgiaGt, exs, duan, 1);
}
if (hangmucTT.Count() > 0)
{
ExcelWorksheet dexs = ep.Workbook.Worksheets.Add("TRỰC TIẾP");
var thamgiaTt = _thamGia.GetIncomeById(idDuAn, 0);
this.ExcelAction(hangmucTT, thamgiaTt, dexs, duan, 0);
}
// direct
//ExcelWorksheet dexs = ep.Workbook.Worksheets[2];
//GenerateInfoProject(duan, dexs, 0);
//this.GenerateContent(hangmucTT, dexs);
//exs.Cells["B15"].AutoFitColumns(hangmuc);
//ExcelCellAddress start = range.Start;
//ExcelCellAddress end = range.End;
//range.Worksheet.Cells[start.Row, start.Column, end.Row, end.Column].Merge = true;
ep.Save();
}
return request.CreateErrorResponse(HttpStatusCode.OK, Path.Combine(folderReport, filename));
}
catch (Exception ex)
{
return request.CreateResponse(HttpStatusCode.BadRequest, ex);
}
}));
}
