//PUT api/Management/Result/ModifFile/{IdResult}
public async Task <IActionResult> UpdateFileResult([FromForm] IFormFile file, int IdResult)
{
var a = HttpContext.Request.Form.Files.FirstOrDefault();
if (a == null || a.Length == 0 || IdResult == 0)
{
return(Content("file not selected"));
}
byte[] barray;
using (var stream = new MemoryStream())
{
await a.CopyToAsync(stream);
barray = stream.ToArray();
};
Fileget fileset = new Fileget
{
Name = a.FileName,
Link = barray
};
dbm.UpdateFileResult(fileset, IdResult);
return(Ok());
}
public void UpdateFileResult(Fileget file, int IdResult)
{
var sql = "UPDATE Result SET Name = @Name, Form = @Form WHERE Id = @Id";
using (var conn = new SqlConnection(connStr))
{
conn.Open();
conn.Execute(sql, new { @Name = file.Name, @Form = file.Link, @Id = IdResult });
conn.Close();
}
}
//GET api/Management/Attached/{IdPostulant}/{Name}
public async Task <IActionResult> GetFile(int IdPostulant, string Name)
{
if (Name == null)
{
return(Content("Filename not present"));
}
Fileget file = dbm.GetFile(IdPostulant, Name);
var memory = new MemoryStream();
Stream stream;
using (stream = new MemoryStream(file.Link))
{
await stream.CopyToAsync(memory);
}
string fileextension = file.Name.Split(".")[file.Name.Split(".").Length - 1];
memory.Position = 0;
return(File(memory, fnc.getMimeTypes(fileextension)));
}
