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))); }