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