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