// PUT /tbNewsStatus/token/ public HttpResponseMessage Put(string token, [FromBody] tbNewsStatus param) { tbLogAcessoUsuario log = new tbLogAcessoUsuario(); try { log = Bibliotecas.LogAcaoUsuario.New(token, JsonConvert.SerializeObject(param), "Put"); HttpResponseMessage retorno = new HttpResponseMessage(); if (Permissoes.Autenticado(token)) { GatewaytbNewsStatus.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> /// Altera tbNewsStatu /// </summary> /// <param name="param"></param> /// <returns></returns> public static void Update(string token, tbNewsStatus param) { try { // Atualiza o contexto ((IObjectContextAdapter)_db).ObjectContext.Refresh(RefreshMode.StoreWins, _db.ChangeTracker.Entries().Select(c => c.Entity)); // token Int32 idUsers = Permissoes.GetIdUser(token); tbNewsStatus value; if (idUsers != 330) { value = _db.tbNewsStatuss .Where(e => e.idNews == param.idNews && e.id_users == idUsers) .First <tbNewsStatus>(); } else { value = _db.tbNewsStatuss .Where(e => e.idNews == param.idNews && e.id_users == param.id_users) .First <tbNewsStatus>(); } // OBSERVAÇÂO: VERIFICAR SE EXISTE ALTERAÇÃO NO PARAMETROS //if (param.idNews != null && param.idNews != value.idNews) // value.idNews = param.idNews; //if (param.id_users != null && param.id_users != value.id_users) // value.id_users = param.id_users; if (param.flRecebido != null && param.flRecebido != value.flRecebido) { value.flRecebido = param.flRecebido; } if (param.flLido != null && param.flLido != value.flLido) { value.flLido = param.flLido; } _db.SaveChanges(); } catch (Exception e) { if (e is DbEntityValidationException) { string erro = MensagemErro.getMensagemErro((DbEntityValidationException)e); throw new Exception(erro.Equals("") ? "Falha ao alterar tbNewsStatu" : erro); } throw new Exception(e.InnerException == null ? e.Message : e.InnerException.InnerException == null ? e.InnerException.Message : e.InnerException.InnerException.Message); } }
/// <summary> /// Adiciona nova tbNewsStatu /// </summary> /// <param name="param"></param> /// <returns></returns> public static Int32 Add(string token, tbNewsStatus param) { try { // Atualiza o contexto //((IObjectContextAdapter)_db).ObjectContext.Refresh(RefreshMode.StoreWins, _db.ChangeTracker.Entries().Select(c => c.Entity)); using (var db = new painel_taxservices_dbContext()) { db.tbNewsStatuss.Add(param); db.SaveChanges(); db.Dispose(); return(param.idNews); } } catch (Exception e) { if (e is DbEntityValidationException) { string erro = MensagemErro.getMensagemErro((DbEntityValidationException)e); throw new Exception(erro.Equals("") ? "Falha ao salvar tbNewsStatu" : erro); } throw new Exception(e.InnerException == null ? e.Message : e.InnerException.InnerException == null ? e.InnerException.Message : e.InnerException.InnerException.Message); } }