public IEnumerable <Resultget> UpdateResult(Resultget result, int IdPostulant)
{
var sql = "UPDATE Result SET Observation = @Observation, OK = @OK WHERE Id = @Id";
using (var conn = new SqlConnection(connStr))
{
conn.Open();
conn.Execute(sql, result);
conn.Close();
}
return(this.GetResult(IdPostulant));
}
public Result createResult(Resultget resultget, byte[] barray, string Name)
{
Result result = new Result
{
Form = barray,
Name = Name,
IdMeeting = resultget.IdMeeting,
Observation = resultget.Observation,
OK = resultget.OK
};
return(result);
}
//PUT api/Management/Result/Modif/{IdPostulant}
public IEnumerable <Resultget> UpdateResult([FromBody] Resultget result, int IdPostulant)
{
return(dbm.UpdateResult(result, IdPostulant));
}
//POST api/Management/Result/{IdPostulant}
public async Task <IActionResult> insertResult([FromForm] Resultget resultget, [FromForm] IFormFile file, int IdPostulant)
{
var a = HttpContext.Request.Form.Files.FirstOrDefault();
if (a == null || a.Length == 0)
{
return(Content("File not selected"));
}
if (this.ModelState.IsValid && IdPostulant != 0)
{
int IdState = dbm.GetState(IdPostulant);
byte [] barray;
using (var stream = new MemoryStream())
{
await a.CopyToAsync(stream);
barray = stream.ToArray();
};
Result result = fnc.createResult(resultget, barray, a.FileName);
switch (resultget.IdInstance)
{
case 1:
{
if (IdState == 2)
{
dbm.InsertResult(result);
dbm.UpdateState(IdPostulant, 3);
}
else
{
return(BadRequest("El estado no corresponde"));
}
break;
}
case 2:
case 3:
{
if (IdState == 4 || IdState == 5)
{
dbm.InsertResult(result);
dbm.UpdateState(IdPostulant, 5);
}
else
{
return(BadRequest("El estado no corresponde"));
}
break;
}
case 4:
{
if (IdState == 6)
{
dbm.InsertResult(result);
}
else
{
return(BadRequest("El estado no corresponde"));
}
break;
}
default: {
return(BadRequest("Unknown"));
}
}
return(Ok());
}
else
{
return(BadRequest("Faltan valores"));
}
}
