public MortgageDocResponse GetDocsPath(long LoanDocsID)
{
MortgageDocResponse response = new MortgageDocResponse();
try
{
using (IDbConnection conn = GetConnection())
{
response.MorgageLoanDoc = conn.Query <MorgageLoanDocs>(" SELECT * FROM MortgageLoanDocs where LoanDocsID = ?LoanDocsID ", new { LoanDocsID }).FirstOrDefault();
if (response.MorgageLoanDoc != null)
{
response.Status = true;
response.Description = "Successful";
}
else
{
response.Status = false;
response.Description = "No data";
}
}
}
catch (Exception ex)
{
response.Status = false;
response.Description = ex.Message;
}
return(response);
}
public MortgageDocResponse Read(long MortgageId)
{
MortgageDocResponse response = new MortgageDocResponse();
try
{
using (IDbConnection conn = GetConnection())
{
response.MorgageLoanDoc = conn.Get <MorgageLoanDocs>(MortgageId);
if (response.MorgageLoanDoc != null)
{
response.Status = true;
response.Description = "Successful";
}
else
{
response.Status = false;
response.Description = "No data";
}
}
}
catch (Exception ex)
{
response.Status = false;
response.Description = ex.Message;
}
return(response);
}
public string GetFileName(long LoanDocsID)
{
string fileName = string.Empty;
MortgageDocResponse docs = repo.GetDocsPath(LoanDocsID);
fileName = docs.MorgageLoanDoc.DocsName;
return(fileName);
}
public IActionResult DownloadFile(long LoanDocsID)
{
//MortgageDocResponse docsresp = new MortgageDocResponse();
var currentDirectory = System.IO.Directory.GetCurrentDirectory();
MortgageDocResponse docsPath = repo.GetDocsPath(LoanDocsID);
//currentDirectory = currentDirectory + "\\src\\assets"Path.Combine(Path.Combine(currentDirectory, "attachments"), fileName);;
var filelink = docsPath.MorgageLoanDoc.DocsLink;
var file = Path.Combine(currentDirectory, filelink);
var memory = new MemoryStream();
using (var stream = new FileStream(file, FileMode.Open))
{
stream.CopyTo(memory);
}
memory.Position = 0;
return(File(memory, GetContentType(file)));
}
