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