/// <summary>
/// Altera tbCanal
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public static void Update(string token, tbCanal param)
{
try
{
// Atualiza o contexto
((IObjectContextAdapter)_db).ObjectContext.Refresh(RefreshMode.StoreWins, _db.ChangeTracker.Entries().Select(c => c.Entity));
tbCanal value = _db.tbCanals
.Where(e => e.cdCanal.Equals(param.cdCanal))
.First <tbCanal>();
// OBSERVAÇÂO: VERIFICAR SE EXISTE ALTERAÇÃO NO PARAMETROS
if (param.cdCanal != null && param.cdCanal != value.cdCanal)
{
value.cdCanal = param.cdCanal;
}
if (param.dsCanal != null && param.dsCanal != value.dsCanal)
{
value.dsCanal = param.dsCanal;
}
_db.SaveChanges();
}
catch (Exception e)
{
if (e is DbEntityValidationException)
{
string erro = MensagemErro.getMensagemErro((DbEntityValidationException)e);
throw new Exception(erro.Equals("") ? "Falha ao alterar TbCanal" : erro);
}
throw new Exception(e.InnerException == null ? e.Message : e.InnerException.InnerException == null ? e.InnerException.Message : e.InnerException.InnerException.Message);
}
}
// PUT /tbCanal/token/
public HttpResponseMessage Put(string token, [FromBody] tbCanal param)
{
tbLogAcessoUsuario log = new tbLogAcessoUsuario();
try
{
log = Bibliotecas.LogAcaoUsuario.New(token, JsonConvert.SerializeObject(param), "Put");
HttpResponseMessage retorno = new HttpResponseMessage();
if (Permissoes.Autenticado(token))
{
GatewayTbCanal.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 TbCanal
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public static short Add(string token, tbCanal param)
{
try
{
// Atualiza o contexto
((IObjectContextAdapter)_db).ObjectContext.Refresh(RefreshMode.StoreWins, _db.ChangeTracker.Entries().Select(c => c.Entity));
_db.tbCanals.Add(param);
_db.SaveChanges();
return(param.cdCanal);
}
catch (Exception e)
{
if (e is DbEntityValidationException)
{
string erro = MensagemErro.getMensagemErro((DbEntityValidationException)e);
throw new Exception(erro.Equals("") ? "Falha ao salvar TbCanal" : erro);
}
throw new Exception(e.InnerException == null ? e.Message : e.InnerException.InnerException == null ? e.InnerException.Message : e.InnerException.InnerException.Message);
}
}