public async Task <IActionResult> Links(string name)
{
string tempFolder = Path.GetTempPath();
var fileName = $"{name} (Links) {Settings.GetDateTimeNowFile()}.xlsx";
string path = Path.Combine(tempFolder, fileName);
Infrastructure.ReportGenerator report = new Infrastructure.ReportGenerator(User.Identity.Name, path);
report.LinksReport(repository.GetLinks(name));
var memory = new MemoryStream();
using (var stream = new FileStream(path, FileMode.Open))
{
await stream.CopyToAsync(memory);
}
memory.Position = 0;
return(File(memory, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", fileName));
}
public async Task <IActionResult> NumberingExcel([Bind(Prefix = nameof(ViewModels.NumberingSearchViewModel.ExcelSearch))] NpSearch search)
{
var nps = NumberingQuery(search);
string tempFolder = Path.GetTempPath();
var fileName = $"Numbering {Settings.GetDateTimeNowFile()}.xlsx";
string path = Path.Combine(tempFolder, fileName);
Infrastructure.ReportGenerator report = new Infrastructure.ReportGenerator(User.Identity.Name, path);
report.Numbering(nps);
var memory = new MemoryStream();
using (var stream = new FileStream(path, FileMode.Open))
{
await stream.CopyToAsync(memory);
}
memory.Position = 0;
return(File(memory, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", fileName));
}
public async Task <IActionResult> RedFolderExcel(string abb, string code, QueryMode mode)
{
var trunks = GetRedFolderRecords(abb, code, mode);
string tempFolder = Path.GetTempPath();
var fileName = $"RedFolder({abb}_{code}) {Settings.GetDateTimeNowFile()}.xlsx";
string path = Path.Combine(tempFolder, fileName);
Infrastructure.ReportGenerator report = new Infrastructure.ReportGenerator(User.Identity.Name, path);
report.RedFolder(trunks);
var memory = new MemoryStream();
using (var stream = new FileStream(path, FileMode.Open))
{
await stream.CopyToAsync(memory);
}
memory.Position = 0;
return(File(memory, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", fileName));
}
public async Task <IActionResult> ShenasnameExcel(Area area)
{
string tempFolder = Path.GetTempPath();
var q = await repository.Exchanges.Where(x => x.Area == area).Include(x => x.NetworkElements).ThenInclude(x => x.Parent).ToListAsync();
var fileName = $"{q.First().Area} (Shenasname) {Settings.GetDateTimeNowFile()}.xlsx";
string path = Path.Combine(tempFolder, fileName);
Infrastructure.ReportGenerator report = new Infrastructure.ReportGenerator(User.Identity.Name, path);
report.ShenasnameByArea(q);
var memory = new MemoryStream();
using (var stream = new FileStream(path, FileMode.Open))
{
await stream.CopyToAsync(memory);
}
memory.Position = 0;
return(File(memory, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", fileName));
}
public async Task <IActionResult> NeExcel(long neId)
{
var ne = repository.NetworkElements.Where(x => x.Id == neId).Include(x => x.Exchange).AsNoTracking();
//Links
ne = ne.Include(x => x.LinksOnEnd1)
.ThenInclude(x => x.End2)
.ThenInclude(x => x.Exchange);
//Numberings
ne = ne.Include(x => x.NumberingPoolNetworkElements)
.ThenInclude(x => x.Numbering);
//Childrens with Numbering
ne = ne
.Include(x => x.NetworkElements)
.ThenInclude(x => x.NumberingPoolNetworkElements)
.ThenInclude(x => x.Numbering)
.Include(x => x.NetworkElements)
.ThenInclude(x => x.Exchange);
var res = await ne.FirstAsync();
string tempFolder = Path.GetTempPath();
var fileName = $"{res.Name} {Settings.GetDateTimeNowFile()}.xlsx";
string path = Path.Combine(tempFolder, fileName);
Infrastructure.ReportGenerator report = new Infrastructure.ReportGenerator(User.Identity.Name, path);
report.NE(res);
var memory = new MemoryStream();
using (var stream = new FileStream(path, FileMode.Open))
{
await stream.CopyToAsync(memory);
}
memory.Position = 0;
return(File(memory, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", fileName));
}
