public async Task <CatalogueByGuidModel> GetCatalogueByGuid(string catalogueId)
{
CatalogueByGuidModel catalogueDetails = await(from catalogues in _catalogueContext.Catalogues
where catalogues.CatalogueId == catalogueId
select new CatalogueByGuidModel
{
CatalogueId = catalogues.CatalogueId,
FileName = catalogues.FileName,
CompanyDetails = (from company in _catalogueContext.CompanyDetails
where company.CatalogueId == catalogueId
select new CompanyDetailModel
{
CompanyId = company.CompanyId,
CompanyName = company.CompanyName,
Region = company.Region,
Sector = company.Sector,
SubSector = company.SubSector,
NumberOfEmployees = company.NumberOfEmployees,
TotalRevenues = company.TotalRevenues,
WebSite = company.WebSite
}).ToList()
}).FirstOrDefaultAsync();
return(catalogueDetails);
}
public async Task <CatalogueByGuidModel> GetCatalogueByCatalogueId(string catalogueId)
{
CatalogueByGuidModel catalogueByGuidModel = null;
if (!string.IsNullOrWhiteSpace(catalogueId))
{
catalogueByGuidModel = await _retrieveCatalogueDetailsRepo.GetCatalogueByGuid(catalogueId);
}
return(catalogueByGuidModel);
}
public void Given_CatalogueId_As_string_1()
{
string catalogueId = "1";
CatalogueByGuidModel catalogueByGuidModel = new CatalogueByGuidModel();
var taskDecorator = Task.FromResult(catalogueByGuidModel);
_mockRetrieveCatalogueDetailsRepo.Setup(x => x.GetCatalogueByGuid(It.IsAny <string>())).Returns(taskDecorator);
var result = _catalogueDetails.GetCatalogueByCatalogueId(catalogueId);
Assert.IsTrue(result is Task <CatalogueByGuidModel>);
}
public async Task <IActionResult> GetCompanyDetails([FromRoute] string catalogueId)
{
try
{
CatalogueByGuidModel catalogueDetails = await _catalogueDetails.GetCatalogueByCatalogueId(catalogueId);
if (catalogueDetails != null)
{
return(Ok(catalogueDetails));
}
else
{
return(StatusCode(404));
}
}
catch (Exception e)
{
return(StatusCode(500, e.Message));
}
}
public async Task <ExportModel> Export(string catalogueId)
{
try
{
CatalogueByGuidModel catalogueDetails = await _retrieveCatalogueDetailsRepo.GetCatalogueByGuid(catalogueId);
string path = _constructFileStoragePath.GetPath(catalogueId);
_constructExcelFile.Create(path, catalogueDetails.CompanyDetails);
byte[] file = File.ReadAllBytes(path);
_deleteFile.Delete(path);
ExportModel fileDetails = new ExportModel
{
FileBytes = file,
FileName = catalogueDetails.FileName
};
return(fileDetails);
}
catch (Exception ex)
{
throw ex;
}
}