public async Task <IActionResult> GetIncomeAndExpenseAccountLineById(Int64 IncomeAndExpenseAccountLineId)
{
IncomeAndExpenseAccountLine Items = new IncomeAndExpenseAccountLine();
try
{
Items = await _context.IncomeAndExpenseAccountLine.Where(q => q.IncomeAndExpenseAccountLineId == IncomeAndExpenseAccountLineId).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 <IncomeAndExpenseAccountLine> > Insert([FromBody] IncomeAndExpenseAccountLine _IncomeAndExpenseAccountLine)
{
IncomeAndExpenseAccountLine _IncomeAndExpenseAccountLineq = new IncomeAndExpenseAccountLine();
try
{
_IncomeAndExpenseAccountLineq = _IncomeAndExpenseAccountLine;
_context.IncomeAndExpenseAccountLine.Add(_IncomeAndExpenseAccountLineq);
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(_IncomeAndExpenseAccountLineq)));
}
public async Task <IActionResult> Delete([FromBody] IncomeAndExpenseAccountLine _IncomeAndExpenseAccountLine)
{
IncomeAndExpenseAccountLine _IncomeAndExpenseAccountLineq = new IncomeAndExpenseAccountLine();
try
{
_IncomeAndExpenseAccountLineq = _context.IncomeAndExpenseAccountLine
.Where(x => x.IncomeAndExpenseAccountLineId == (Int64)_IncomeAndExpenseAccountLine.IncomeAndExpenseAccountLineId)
.FirstOrDefault();
_context.IncomeAndExpenseAccountLine.Remove(_IncomeAndExpenseAccountLineq);
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(_IncomeAndExpenseAccountLineq)));
}
public async Task <ActionResult <IncomeAndExpenseAccountLine> > Update([FromBody] IncomeAndExpenseAccountLine _IncomeAndExpenseAccountLine)
{
IncomeAndExpenseAccountLine _IncomeAndExpenseAccountLineq = _IncomeAndExpenseAccountLine;
try
{
_IncomeAndExpenseAccountLineq = await(from c in _context.IncomeAndExpenseAccountLine
.Where(q => q.IncomeAndExpenseAccountLineId == _IncomeAndExpenseAccountLine.IncomeAndExpenseAccountLineId)
select c
).FirstOrDefaultAsync();
_context.Entry(_IncomeAndExpenseAccountLineq).CurrentValues.SetValues((_IncomeAndExpenseAccountLine));
//_context.IncomeAndExpenseAccountLine.Update(_IncomeAndExpenseAccountLineq);
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(_IncomeAndExpenseAccountLineq)));
}
