ColmagCasas IColmagCasasManager.Delete(int keyColmagCasaId)
{
var methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ColmagCasas result = null;
try
{
logger.Log(LogLevel.Debug, $"Iniciando operación: {methodName}");
result = context.ColmagCasas.Where((x) => x.ColmagCasaId == keyColmagCasaId).FirstOrDefault();
if (result == null)
{
logger.Log(LogLevel.Error, $"Llave no Existe: ColmagCasas({keyColmagCasaId})");
return(null);
}
else
{
context.ColmagCasas.Remove(result);
}
}
catch (Exception ex)
{
logger.Log(LogLevel.Error, $"Error en: {methodName}\n{ex.Message}\n{ex.StackTrace}");
}
finally
{
logger.Log(LogLevel.Debug, $"Finalizada operación: {methodName}");
}
return(result);
}
ColmagCasas IColmagCasasManager.Add(ColmagCasas row)
{
var methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ColmagCasas result = null;
try
{
logger.Log(LogLevel.Debug, $"Iniciando operación: {methodName}");
result = context.ColmagCasas.Where((x) => x.ColmagCasaId == row.ColmagCasaId).FirstOrDefault();
if (result == null)
{
result = row;
context.Entry(row).Property("Usuario").CurrentValue = userId;
context.ColmagCasas.Add(row);
}
else
{
logger.Log(LogLevel.Error, $"Llave Duplicada: ColmagCasas({row.ColmagCasaId})");
return(null);
}
}
catch (Exception ex)
{
logger.Log(LogLevel.Error, $"Error en: {methodName}\n{ex.Message}\n{ex.StackTrace}");
}
finally
{
logger.Log(LogLevel.Debug, $"Finalizada operación: {methodName}");
}
return(result);
}
ColmagCasas IColmagCasasManager.Update(int keyColmagCasaId, Delta <ColmagCasas> changes)
{
var methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ColmagCasas result = null;
try
{
logger.Log(LogLevel.Debug, $"Iniciando operación: {methodName}");
result = context.ColmagCasas.Where((x) => x.ColmagCasaId == keyColmagCasaId).FirstOrDefault();
if (result == null)
{
logger.Log(LogLevel.Error, $"Llave no Existe: ColmagCasas({keyColmagCasaId})");
return(null);
}
else
{
changes.CopyChangedValues(result);
context.Entry(result).Property("Usuario").CurrentValue = userId;
context.Entry(result).Property("Fecha_Computador").CurrentValue = DateTime.Now;
}
}
catch (Exception ex)
{
logger.Log(LogLevel.Error, $"Error en: {methodName}\n{ex.Message}\n{ex.StackTrace}");
}
finally
{
logger.Log(LogLevel.Debug, $"Finalizada operación: {methodName}");
}
return(result);
}
public IActionResult Post([FromBody] ColmagCasas row)
{
try
{
var orgrow = this.ColmagCasasManager.Add(row);
if (orgrow == null)
{
HttpContext.Response.StatusCode = StatusCodes.Status406NotAcceptable;
return(BadRequest($"Llave primaria duplicada ({row.ColmagCasaId})"));
}
else
{
this.ColmagCasasManager.SaveChanges();
return(Created(row));
}
}
catch (Exception)
{
var errors = String.Join("\n", ModelState.Root.Errors.Select((e) => e.Exception.Message));
return(BadRequest($"Código repetido o datos inválidos\n{errors}"));
}
}