/// <summary> /// Altera tbCatalogo /// </summary> /// <param name="param"></param> /// <returns></returns> public static void Update(string token, tbCatalogo param) { try { // Atualiza o contexto ((IObjectContextAdapter)_db).ObjectContext.Refresh(RefreshMode.StoreWins, _db.ChangeTracker.Entries().Select(c => c.Entity)); tbCatalogo value = _db.tbCatalogos .Where(e => e.cdCatalogo.Equals(param.cdCatalogo)) .First <tbCatalogo>(); // OBSERVAÇÂO: VERIFICAR SE EXISTE ALTERAÇÃO NO PARAMETROS if (param.cdCatalogo != null && param.cdCatalogo != value.cdCatalogo) { value.cdCatalogo = param.cdCatalogo; } if (param.dsCatalogo != null && param.dsCatalogo != value.dsCatalogo) { value.dsCatalogo = param.dsCatalogo; } _db.SaveChanges(); } catch (Exception e) { if (e is DbEntityValidationException) { string erro = MensagemErro.getMensagemErro((DbEntityValidationException)e); throw new Exception(erro.Equals("") ? "Falha ao alterar TbCatalogo" : erro); } throw new Exception(e.InnerException == null ? e.Message : e.InnerException.InnerException == null ? e.InnerException.Message : e.InnerException.InnerException.Message); } }
// PUT /tbCatalogo/token/ public HttpResponseMessage Put(string token, [FromBody] tbCatalogo param) { tbLogAcessoUsuario log = new tbLogAcessoUsuario(); try { log = Bibliotecas.LogAcaoUsuario.New(token, JsonConvert.SerializeObject(param), "Post"); HttpResponseMessage retorno = new HttpResponseMessage(); if (Permissoes.Autenticado(token)) { GatewayTbCatalogo.Update(token, param); log.codResposta = (int)HttpStatusCode.OK; Bibliotecas.LogAcaoUsuario.Save(log); return(Request.CreateResponse(HttpStatusCode.OK)); } else { log.codResposta = (int)HttpStatusCode.Unauthorized; Bibliotecas.LogAcaoUsuario.Save(log); return(Request.CreateResponse(HttpStatusCode.Unauthorized)); } } catch (Exception e) { log.codResposta = (int)HttpStatusCode.InternalServerError; log.msgErro = e.Message; Bibliotecas.LogAcaoUsuario.Save(log); throw new HttpResponseException(HttpStatusCode.InternalServerError); } }
/// <summary> /// Adiciona nova TbCatalogo /// </summary> /// <param name="param"></param> /// <returns></returns> public static short Add(string token, tbCatalogo param) { try { // Atualiza o contexto ((IObjectContextAdapter)_db).ObjectContext.Refresh(RefreshMode.StoreWins, _db.ChangeTracker.Entries().Select(c => c.Entity)); _db.tbCatalogos.Add(param); _db.SaveChanges(); return(param.cdCatalogo); } catch (Exception e) { if (e is DbEntityValidationException) { string erro = MensagemErro.getMensagemErro((DbEntityValidationException)e); throw new Exception(erro.Equals("") ? "Falha ao salvar TbCatalogo" : erro); } throw new Exception(e.InnerException == null ? e.Message : e.InnerException.InnerException == null ? e.InnerException.Message : e.InnerException.InnerException.Message); } }