public async Task <IActionResult> GetFormulasConFormulasById(int Id)
{
FormulasConFormulas Items = new FormulasConFormulas();
try
{
Items = await _context.FormulasConFormulas.Where(q => q.IdFormulaconformula.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 <FormulasConFormulas> > Insert([FromBody] FormulasConFormulas payload)
{
FormulasConFormulas FormulasConFormulas = payload;
try
{
_context.FormulasConFormulas.Add(FormulasConFormulas);
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(FormulasConFormulas)));
}
public async Task <IActionResult> Delete([FromBody] FormulasConFormulas payload)
{
FormulasConFormulas FormulasConFormulas = new FormulasConFormulas();
try
{
FormulasConFormulas = _context.FormulasConFormulas
.Where(x => x.IdFormulaconformula == (int)payload.IdFormulaconformula)
.FirstOrDefault();
_context.FormulasConFormulas.Remove(FormulasConFormulas);
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(FormulasConFormulas)));
}
public async Task <ActionResult <FormulasConFormulas> > Update([FromBody] FormulasConFormulas _FormulasConFormulas)
{
try
{
FormulasConFormulas FormulasConFormulasq = (from c in _context.FormulasConFormulas
.Where(q => q.IdFormulaconformula == _FormulasConFormulas.IdFormulaconformula)
select c
).FirstOrDefault();
_FormulasConFormulas.FechaCreacion = FormulasConFormulasq.FechaCreacion;
_FormulasConFormulas.UsuarioCreacion = FormulasConFormulasq.UsuarioCreacion;
_context.Entry(FormulasConFormulasq).CurrentValues.SetValues((_FormulasConFormulas));
// _context.FormulasConFormulas.Update(_FormulasConFormulas);
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(_FormulasConFormulas)));
}
