// GET /tbRecebimentoTEF/token/colecao/campo/orderBy/pageSize/pageNumber?CAMPO1=VALOR&CAMPO2=VALOR
public HttpResponseMessage Get(string token, int colecao = 0, int campo = 0, int orderBy = 0, int pageSize = 0, int pageNumber = 0)
{
// Abre nova conexão
painel_taxservices_dbContext _db = new painel_taxservices_dbContext();
tbLogAcessoUsuario log = new tbLogAcessoUsuario();
try
{
log = Bibliotecas.LogAcaoUsuario.New(token, null, "Get", _db);
Dictionary <string, string> queryString = Request.GetQueryNameValuePairs().ToDictionary(x => x.Key, x => x.Value);
HttpResponseMessage retorno = new HttpResponseMessage();
if (Permissoes.Autenticado(token, _db))
{
Retorno dados = GatewayTbRecebimentoTEF.Get(token, colecao, campo, orderBy, pageSize, pageNumber, queryString, _db);
log.codResposta = (int)HttpStatusCode.OK;
Bibliotecas.LogAcaoUsuario.Save(log, _db);
return(Request.CreateResponse <Retorno>(HttpStatusCode.OK, dados));
}
else
{
log.codResposta = (int)HttpStatusCode.Unauthorized;
Bibliotecas.LogAcaoUsuario.Save(log, _db);
return(Request.CreateResponse(HttpStatusCode.Unauthorized));
}
}
catch (Exception e)
{
log.codResposta = (int)HttpStatusCode.InternalServerError;
log.msgErro = e.Message;
Bibliotecas.LogAcaoUsuario.Save(log);//, _db);
throw new HttpResponseException(HttpStatusCode.InternalServerError);
}
finally
{
// Fecha conexão
_db.Database.Connection.Close();
_db.Dispose();
}
}
// POST /tbRecebimentoTEF/token/
public HttpResponseMessage Post(string token, [FromBody] tbRecebimentoTEF param)
{
// Abre nova conexão
painel_taxservices_dbContext _db = new painel_taxservices_dbContext();
tbLogAcessoUsuario log = new tbLogAcessoUsuario();
try
{
log = Bibliotecas.LogAcaoUsuario.New(token, JsonConvert.SerializeObject(param), "Post", _db);
HttpResponseMessage retorno = new HttpResponseMessage();
if (Permissoes.Autenticado(token, _db))
{
Int32 dados = GatewayTbRecebimentoTEF.Add(token, param, _db);
log.codResposta = (int)HttpStatusCode.OK;
Bibliotecas.LogAcaoUsuario.Save(log, _db);
return(Request.CreateResponse <Int32>(HttpStatusCode.OK, dados));
}
else
{
log.codResposta = (int)HttpStatusCode.Unauthorized;
Bibliotecas.LogAcaoUsuario.Save(log, _db);
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);
}
finally
{
// Fecha conexão
_db.Database.Connection.Close();
_db.Dispose();
}
}
/// <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);
}
}
