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