public async Task <IActionResult> GetFormulasConceptoById(int Id)
{
FormulasConcepto Items = new FormulasConcepto();
try
{
Items = await _context.FormulasConcepto.Where(q => q.IdformulaConcepto.Equals(Id)).FirstOrDefaultAsync();
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(BadRequest($"Ocurrio un error:{ex.Message}"));
}
return(await Task.Run(() => Ok(Items)));
}
public async Task <ActionResult <FormulasConcepto> > Insert([FromBody] FormulasConcepto payload)
{
FormulasConcepto FormulasConcepto = payload;
try
{
_context.FormulasConcepto.Add(FormulasConcepto);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(BadRequest($"Ocurrio un error:{ex.Message}"));
}
return(await Task.Run(() => Ok(FormulasConcepto)));
}
public async Task <IActionResult> Delete([FromBody] FormulasConcepto payload)
{
FormulasConcepto FormulasConcepto = new FormulasConcepto();
try
{
FormulasConcepto = _context.FormulasConcepto
.Where(x => x.IdConcepto == (int)payload.IdConcepto)
.FirstOrDefault();
_context.FormulasConcepto.Remove(FormulasConcepto);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(await Task.Run(() => BadRequest($"Ocurrio un error:{ex.Message}")));
}
return(await Task.Run(() => Ok(FormulasConcepto)));
}
public async Task <ActionResult <FormulasConcepto> > Update([FromBody] FormulasConcepto _FormulasConcepto)
{
try
{
FormulasConcepto FormulasConceptoq = (from c in _context.FormulasConcepto
.Where(q => q.IdConcepto == _FormulasConcepto.IdConcepto)
select c
).FirstOrDefault();
_FormulasConcepto.FechaCreacion = FormulasConceptoq.FechaCreacion;
_FormulasConcepto.UsuarioCreacion = FormulasConceptoq.UsuarioCreacion;
_context.Entry(FormulasConceptoq).CurrentValues.SetValues((_FormulasConcepto));
// _context.FormulasConcepto.Update(_FormulasConcepto);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(await Task.Run(() => BadRequest($"Ocurrio un error:{ex.Message}")));
}
return(await Task.Run(() => Ok(_FormulasConcepto)));
}
