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