public async Task <IActionResult> GetListNameProduct(string term)
{
var list = await _productConnectAPI.GetAllProduct();
var listname = list.Select(x => x.Name).ToList();
return(Json(new
{
status = true,
data = listname
}));
}
public async Task <IActionResult> ExportExcel()
{
string sWebRootFolder = _hostingEnvironment.WebRootPath;
string directory = Path.Combine(sWebRootFolder, "export-files");
if (!Directory.Exists(directory))
{
Directory.CreateDirectory(directory);
}
string sFileName = $"Product_{DateTime.Now:yyyyMMddhhmmss}.xlsx";
string fileUrl = $"{Request.Scheme}://{Request.Host}/export-files/{sFileName}";
FileInfo file = new FileInfo(Path.Combine(directory, sFileName));
if (file.Exists)
{
file.Delete();
file = new FileInfo(Path.Combine(sWebRootFolder, sFileName));
}
var listproduct = await _productConnectAPI.GetAllProduct();
using (ExcelPackage package = new ExcelPackage(file))
{
// add a new worksheet to the empty workbook
ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("Products");
worksheet.Cells["A1"].LoadFromCollection(listproduct, true, TableStyles.Light1);
worksheet.Cells.AutoFitColumns();
package.Save(); //Save the workbook.
}
var test = fileUrl;
return(Json(new
{
status = true,
data = test
}));
}