public async Task <ModelMenuA4_FileDownload> GetA4DownloadFileByIdAsync(int DocId, int Id) { string sql = "SELECT TOP(1) file1name FROM Doc_MenuA4 WHERE doc_id='" + DocId + "' "; using (SqlConnection conn = new SqlConnection(ConnectionString)) { conn.Open(); using (SqlCommand command = new SqlCommand(sql, conn)) { SqlDataReader reader = await command.ExecuteReaderAsync(); if (reader.HasRows) { ModelMenuA4_FileDownload e = new ModelMenuA4_FileDownload(); while (await reader.ReadAsync()) { if (Id == 1) { e.filebase64 = ServerDirectorys.ReadFileToBase64(_IEnvironmentConfig.PathDocument, FolderDocument.menuA4, reader["file1name"].ToString()); e.filename = "คำขอชี้แจง_แก้ไขโครงการตามมติคณะกรรมการ"; } } return(e); } } conn.Close(); } return(null); }
public async Task <IActionResult> GetA4DownloadFileById(int DocId, int Id) { ModelMenuA4_FileDownload e = await _IDocMenuAService.GetA4DownloadFileByIdAsync(DocId, Id); if (e != null) { return(Ok(e)); } else { return(BadRequest()); } }